Automated synchronizing Excel databases
$30-250 USD
Dibayar saat pengiriman
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 Proyek: #17236700
Tentang proyek
Diberikan kepada:
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 Lebih banyak
24 freelancer rata-rata menawar $185 untuk pekerjaan ini
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 Lebih banyak
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.
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Lebih banyak
Hi, I am a financial expert and guru in Excel and Excel-VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, scr Lebih banyak
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
- Went through the description and the PDF format showing the input CSV and the Master file. - This could be run via scripting running to download the input file from FTP synchronizing the changed fields into the Mast Lebih banyak
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 Lebih banyak
I see that your mentioned Visual Basic in Skills required. I know it, but my favorite programming language is Java. I used it to make many standalone applications for Windows. I can make program to download CSV files f Lebih banyak
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 Lebih banyak
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
1. Excel expert with extensive vba programming experience. I can help you with the synchronizing of your CSV files into a master spreadsheet. I do something similar on a daily basis for a current project. 2. I h Lebih banyak
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 Lebih banyak
Dear Sir/Madam: I offer to solve your Excel's DB with VBA, extracting, converting to and from any format . Working with 2016 and backward. Full services: programming, PM, technical translation/writing. Expertis Lebih banyak
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 Lebih banyak
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)