Automated synchronizing Excel databases
$30-250 USD
S-au achitat serviciile după ce au fost prestate
Project Goal: Synchronizing master Excel database with a new Excel database + make csv output file of only the modified data.
Project description.
Master Excel database has about 35000 products. Each product showing many columns of product details. One small program (executable) need to be written that does the following:
1. Get the new files from my supplier from a FTP location (about 13 csv files from a list of many files)
2. Merge those 13 csv files together into 1 csv file and save as .xlsx file (input-file).
3. Open the master excel database on the local computer. This master database will now automatic update the fields (this master database has already the needed links to update the necessary fields, so this update process is not part of the job)
4. The fields that are updated are shown in about 5 columns.
5. Save the master database with the updated information
6. Select only the updated values from those 5 columns.
7. Write those updated fields together with the product keys in a newly created .csv file.
8. Store this output file on a fixed location.
9. Optional: create a cron-job for import in my Prestashop 1.7.3.x web shop.
Above need to be done every 2 or 3 hours.
ID Proiect: #17236700
Detalii despre proiect
Acordat lui:
Hi, there. My name's Paris and I'm a very experienced and skilled Excel developer. In fact, I've accomplished 233 projects in the last 5 years on this platform which makes me believe strongly that I can undertake yo Mai multe
24 freelanceri plasează o ofertă medie de 185$ pentru proiect
Hello, I can help with you in your project Automated synchronizing Excel databases. I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Software Architecture, Visual Basic. We have wo Mai multe
I can work for you. I'm interested in your project. I've an experience of works with MS Excel and VBA. Ping me any time to discuss about this project.
Eassy peasy. Provided your server is a windows one. Not that it wont work on Unix (provided DotNet is installed) But anyways I have 18 years software development experience. Maurice Marinus
Hi, In past I worked donwloading files from ftp server, I can develop a vb.net application to download your csv files, merge and write an output csv file using the 5 columns that you need.
Hi we are a software development company from india in past 8 years me & my Team developed approx 10592 projects for global market , we try to satisfy clients needs . we developed lots of projects for several industr Mai multe
Hi, I can write you a console application written in .NET platform and using Visual Basic. The application would be open at the background, and will work in intervals you specified. Please share the files if y Mai multe
Dear customer, as experienced Java developer, I could do this job very easily this night (within the next 5 hours). Looking forward to work on this project. Best regards Jörn Dyherrn from Germany
I have 6 year experience Freelancer,up work,Fiverr & 99design market place I have seen your project that i can to do easily because I have many experience to Graphic Design,Webdesign,Web Develop & programming .So I cou Mai multe
I guarantee you that I can serve you in the best form and at the lowest price maybe less than the amount I will give you now any amount you specify
Hi, I am having 8+ years of experience in Automation tasks and database management. I can help you on this automation using VBA scripts. Are we having any criteria to identify updated rows in 5 columns else I need to Mai multe
Hi, I am sorry, but it will be much better to create small database for you project instead of using Excel. Simplest way- use ms access and if you need - just export data to excel . Alex (Ukraine)