Find Jobs
Hire Freelancers

CSV synchronization

$30-250 USD

Geschlossen
Veröffentlicht vor fast 15 Jahren

$30-250 USD

Bezahlt bei Lieferung
Our supplier has a csv file updated daily ([login to view URL]).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.
Projekt-ID: 411882

Über das Projekt

19 Vorschläge
Remote Projekt
Aktiv vor 15 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
19 Freelancer bieten im Durchschnitt $118 USD für diesen Auftrag
Avatar des Nutzers
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 in 3 Tagen
5,0 (18 Bewertungen)
5,0
5,0
Avatar des Nutzers
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 in 1 Tag
5,0 (5 Bewertungen)
2,9
2,9
Avatar des Nutzers
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 need to see the layout of your CSV files. Then I would save the results in a new CSV file. This script would run on a cron Linux schedule for any time you wish. Thanks.
$120 USD in 3 Tagen
5,0 (1 Bewertung)
1,8
1,8
Avatar des Nutzers
Hi! I make similar job and can do this for you.
$30 USD in 2 Tagen
3,2 (2 Bewertungen)
1,6
1,6
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 point exceeded etc. This can be done easily by writing a Macro. Can you kindly let us know the details/additional functioanlities required?
$125 USD in 4 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi this can be done easily by using a rdbms like mysql or something like this.
$45 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Please check PMB. Thanks.
$50 USD in 0 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I think there is a way to do it
$30 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 items would be removed and new ones inserted. The new CSV could be sorted by your needs. The Excel workbook would have an built-in toolbar (the toolbar would follow the workbook with no need for installation), with buttons that would simplify the running of the actions (macros). Button - insert new CSV Button - integrate new data Button - export new data to a clean CSV I hope this will fill your needs and i hope to your from you soon! Jorge
$200 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hello, Please see your PMB for details.
$200 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Can do it in Java. Plz check PMB. Thank you.
$250 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Please provide me the business details that may help me to make this program more convinient for you that your expectations
$40 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
We can develop software
$150 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
i wil do it by excel
$200 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von ITALY
70028, Italy
0,0
0
Mitglied seit März 31, 2009

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.