Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
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!
Project ID: 6485996

About the project

3 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (4 reviews)
2.9
2.9
3 freelancers are bidding on average $129 USD for this job
User Avatar
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 in 5 days
5.0 (4 reviews)
3.9
3.9
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FINLAND
hometown, Finland
5.0
7
Payment method verified
Member since Aug 26, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.