Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace más de 9 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 6485996

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
2,9
2,9
3 freelancers están ofertando un promedio de $129 USD por este trabajo
Avatar del usuario
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 en 5 días
5,0 (4 comentarios)
3,9
3,9
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de FINLAND
hometown, Finland
5,0
7
Forma de pago verificada
Miembro desde ago 26, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.