Find Jobs
Hire Freelancers

VB Script to Import and Export a CSV-file to a database

$30-250 USD

已完成
已发布超过 9 年前

$30-250 USD

货到付款
I am doing an Visual Basic Script (vbs) -application for my client to do a specific kind of person list management on a Windows 7 host PC. For this application I need some utility functions for data importing and exporting. For development you should only use .vbs -fileformat and Windows Script Host as the interpreter. Please do not use any IDE, such as Visual Studio. The application uses a local MsSQL (or MySQL) database, via ODBC, as a data storage and the users of the application needs to be able to manipulate a person list externally (in MS Excel) and then "import" that list to the application's database storage. Also, same need is also to "export" the data out from my application's dB storage to an external file, which can then be further processed in Excel, and potentially be imported back to the database. The database will store no more than few hundred entries. The import/export fileformat can be CSV or some other suitable text format, which can be safely opened and saved in MS Excel as well. I have prepared an Excel (xls) file, see attached, which consists of the two simple db table structures used by the application and some sample data. In principle there are two tables: one for persons (list of people) and one for organizations (their companies). Each person has an organization associated with them in the database. Your task is to write three VBS-functions: dbImport(), dbExport() and dbClear(). dbExport(filesaveFolder) should ask the user which table (PersonsDB or OrganizationsDB) export all the data from the database and store it to a CSV-file in to the location defined in the filesaveFolder -argument. The file must use a timestamp-based filename (such as "[login to view URL]"). dbImport(filereadPath) will read a CSV-file (provided in the filereadPath-argument) and it will parse all the data from the file and store that to the database accordingly. The function must check the second column of each record, if it is "person" then the data is saved to PersonsDB -table and if it's "org" then it needs to be saved to OrganizationsDB -table. dbClear() will ask the operator which table to clear, either PersonsDB or OrganizationsDB then the script should automatically make a backup copy to a file (by using dbExport()) and then empty the corresponding table. Notes about coding style: All possible object names and other references within the VB code must use variables which are introduced in the beginning of the script for easy future modification. Use a suitable prefix in variable names, for example "ImpExp_ExportFolderPath". This is to avoid collisions with other parts of the script when source codes are merged into one script. Because the script will need to be migrated from your database environment to the actual production environment, please use clearly named variable names and functions for all database connections and calls so those can be changed as needed in migration. Please also use comments to explain the flow of the program where appropriate. If you have any questions, please do not hesitate to contact me. THANK YOU!
项目 ID: 6485996

关于此项目

3提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello, Thanks for the posting the project on freelancer. I am having 10 years professional experience in software development. I have worked with various reputed IT organizations like Capgemini and Dell before I started as a freelancer. I have real-time experience in C#, VB.Net, VB6, VBScript, MVC, PHP, Web API, RESTFul, Web Scraping, JQuery, JSON, XML, SQL Server etc. I have gone through your project requirement and understand this very well. I can write the vbscript function to import and export the data. Ping me to discuss more on this. I highly value professionalism and hold myself strictly accountable for the quality of deliverables. I don’t have any other commitment, so I can start the work immediately. Please take a look at my Freelancer reviews. I’m glad to answer any questions you may have. Thank you for your time. blueasso
$100 USD 在1天之内
5.0 (4条评论)
2.9
2.9
3威客以平均价$129 USD来参与此工作竞价
用户头像
Greetings, with over 14 years of development experience I consider myself to be. an ideal candidate for this task. I'd encourage you to read my reviews in order to learn about my professional ethics and work quality. let's get it started and have it done! Regards, John.
$187 USD 在5天之内
5.0 (4条评论)
3.9
3.9
用户头像
I got 7+years work experience in .NET,FLASH,C#,MVC,Linux,Visual Studio2010,Joomla,Illustrator, Majento,ASP,Javascript,Java,Coldfusion,PHP,Python,Prestashop,SQL,XML,moodle,AJAX,CMS,HTML,Drupal,SEO,CSS,wordpress,Bootstrap,Photoshop,Oscommerce, CSS,Paypal API technologies here.I'm a web and tech savvy person.I have satisfied more clients successfully in short duration.I will give you very good quality and high level of Accuracy for this position.I can accept your payment terms and method here,Keep me posted. I will complete this project in short duration. Thank you.
$100 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

FINLAND的国旗
hometown, Finland
5.0
7
付款方式已验证
会员自8月 26, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。