Automated synchronizing Excel databases

Selesai Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Selesai 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.

Pemrosesan Data Excel Microsoft Access Perancangan Perangkat Lunak Visual Basic

ID Proyek: #17236700

Tentang proyek

24 proposal Proyek online Aktif 5 tahun yang lalu

Diberikan kepada:

paris2785

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

$130 USD dalam 3 hari
(542 Ulasan)
8.5

24 freelancer rata-rata menawar $185 untuk pekerjaan ini

schoudhary1553

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

$250 USD dalam 3 hari
(585 Ulasan)
8.5
liangjongai

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.

$155 USD dalam 3 hari
(253 Ulasan)
7.8
zekovicm

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

$155 USD dalam 3 hari
(201 Ulasan)
8.0
dgled

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

$250 USD dalam 3 hari
(95 Ulasan)
7.5
mauricemarinus

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

$100 USD dalam 3 hari
(116 Ulasan)
7.1
satishtl

- 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

$390 USD dalam 4 hari
(56 Ulasan)
6.2
solucionesnet

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.

$155 USD dalam 3 hari
(53 Ulasan)
6.0
quickapp100

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

$155 USD dalam 3 hari
(14 Ulasan)
5.1
rylkov

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

$250 USD dalam 3 hari
(49 Ulasan)
5.2
serdaryalcin

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

$140 USD dalam 3 hari
(25 Ulasan)
4.6
joerndyherrn

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

$133 USD dalam 1 hari
(5 Ulasan)
4.4
brobb07

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

$155 USD dalam 3 hari
(1 Ulasan)
3.8
mohammadullah177

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

$155 USD dalam 3 hari
(1 Ulasan)
2.6
tsft

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

$233 USD dalam 10 hari
(2 Ulasan)
1.2
goooogl

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

$30 USD dalam 4 hari
(0 Ulasan)
0.0
Sakthivel021

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

$166 USD dalam 5 hari
(0 Ulasan)
0.0
aabramenkov

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)

$155 USD dalam 3 hari
(0 Ulasan)
0.0