Suljettu

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, pixmania, pixmania csv checker, caricare file csv pixmania, pixmania wordpress csv, automatically update excel csv, wordpress csv, vendita, synchronize, solo ad, online da, noi, dati, dal, CSV, csv php, creato, cerco, c pi, csv post, perl change file, php 23000, lista

About the Employer:
( 0 reviews ) 70028, Italy

Projektin tunnus: #411882

19 freelanceria on tarjonnut keskimäärin 118 $ tähän työhön

festsoft

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)
5.0
Tablassus

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: Inet1.Protocol = icHTTP Inet1 Lisää

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

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)
2.9
asyouwish

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)
1.8
AlxP

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

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

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

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

i wil do it by excel

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

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)
0.0
swati1508

We can develop software

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

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)
0.0
laupb

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)
0.0
porcupine

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)
0.0
DexterConsulting

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)
0.0
jmsantos72

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)
0.0
dingxl05

I think there is a way to do it

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

Please check PMB. Thanks.

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

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

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

i can do it.thanks

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

Hello, Please see your PMB for details.

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