CSV synchronization

Our supplier has a csv file updated daily ([url removed, login to view]).It has more than 23000 records.

We had our personal csv file (stored in our computers) made of some of these records.

These records are the items that we actually sell online, and we add new records every day(copied manually from the supplier's csv)

We are searching the way to synchronize automatically our csv file with the supplier's csv.

Infact we want to quickly find if any item is over or change the price.

pleace ask for more details.

We paid for setup an efficient system to do that. Post your way to do that.

Disponiamo di un file .csv (che contiene dati relativi ad alcuni prodotti)

Questo file (che chiamiamo per esempio A) è aggiornato frequentemente dal fornitore e contiene oltre 23000 records,che corrispondono ad altrettanti prodotti.

Parte di questi prodotti sono caricati per la vendita online. Questi ultimi andranno a formare una nuova lista in un' altro file csv (che chiamiamo file B) da noi creato.

Cerco un modo per individuare il più rapidamente possibile le indisponibilità dei prodotti e le modifiche dei prezzi dei prodotti da noi scelti nel file B....

In pratica bisognerebbe sincronizzare il file B solo dei records che ci interessano presenti nel file A.

Possibilità di collaborazione frequente per implementazione di altri progetti.

Taidot: tietojenkäsittely, Excel, Perl, PHP, XML

Näytä lisää: searching supplier, fichiers php, daily item, revendeur_it pixmania, pixmania, pixmania csv checker, http wwwpixmaniacomcomppixprofichiersitrevendeur_itcsv, caricare file csv pixmania, pixmania wordpress csv, automatically update excel csv, csv parser, wordpress csv, vendita, Synchronize, solo ad, online da, NOI, dati, dal, csv, csv php, creato, Cerco, c++ pi, c pi

Tietoa työnantajasta:
( 0 arvostelua ) 70028, Italy

Projektin tunnus: #411882

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I have made a prototype PHP program which will do this task. Please see my proposal in more detail in your Private Message (PM). Thank you.

$30 USD 3 päivässä
(18 arvostelua)

Can be done easily: 1) Create a VB .exe file that transfers the contents of the web file (.csv) into a .dat file (stored in your computer). This will be done using the Inet control: [login to view URL] = icHTTP Inet1 Lisää

$50 USD 2 päivässä
(14 arvostelua)

Dear Sir/Madam, I am familiar with such types of task. I have done it previously. I have the script which does the similar job. Please check PMb to see details.

$30 USD 1 päivässä
(5 arvostelua)

First i would download the CSV file with the PHP module cURL. Then I would step through eacy line, checking the price against the price in your CSV file by searching your CSV file product names or product ID's. I Lisää

$120 USD 3 päivässä
(1 arvostelu)

Hi! I make similar job and can do this for you.

$30 USD 2 päivässä
(2 arvostelua)

Can do it in Java. Plz check PMB. Thank you.

$250 USD 5 päivässä
(0 arvostelua)

i wil do it by excel

$200 USD 5 päivässä
(0 arvostelua)

I need few more details. Why do you need to maintain a separate excel on every computer? Just trying to understand the flow.

$250 USD 10 päivässä
(0 arvostelua)

We can develop software

$150 USD 5 päivässä
(0 arvostelua)

Please provide me the business details that may help me to make this program more convinient for you that your expectations

$40 USD 3 päivässä
(0 arvostelua)

Hi, Can you give me more details about this project. From you're description, it sounds like a matter of comparing your csv file with the suppliers csv file for any differences. Regards, Paul.

$100 USD 3 päivässä
(0 arvostelua)

Hi, my suggestion is create macros in excel which will automatically update the CVS file. Also you can use excel functions for the same. Thanks

$250 USD 10 päivässä
(0 arvostelua)

Hi Vitoturi, As per my understanding, I guess you require a feature in your CSV file which on comparing with the supplier's CSV sheet fetches data and processes it to provide alerts on certain conditions like price Lisää

$125 USD 4 päivässä
(0 arvostelua)

Hi. My suggestion is to make an excel project (workbook) that would validate the current items against the new ones or modified the data (price and quantity available if it´s the case) based in the new CSV. Old item Lisää

$200 USD 2 päivässä
(0 arvostelua)

I think there is a way to do it

$30 USD 5 päivässä
(0 arvostelua)

Please check PMB. Thanks.

$50 USD 0 päivässä
(0 arvostelua)

Hi this can be done easily by using a rdbms like mysql or something like this.

$45 USD 2 päivässä
(0 arvostelua)

i can do [login to view URL]

$100 USD 2 päivässä
(0 arvostelua)

Hello, Please see your PMB for details.

$200 USD 2 päivässä
(0 arvostelua)