Simple web PHP script to import a csv, make changes, and export the revised csv file
4364
$$
- Posted:
- Proposals: 5
- Remote
- #133983
- Archived
Description
Experience Level: Intermediate
Hi,
Please see the attached file which shows 4 different orders.
This is a sample input file (I will provide a URL from where this can be downloaded with the latest version).
I'd like to access a web script / web app which will import the latest version of this file, follow some rules as detailed below and then export a new version of this csv file. I'd like this new csv file to be uploaded to an ftp location I will provide.
I'd like to be able to set rules such as:
1) If the product code = X then change it to Y
2) If the product code for a particular order contains "clarisonic" and "mia" AND the delivery country is in Europe* then add a new line to that order with a product code of 'uk-eu'
* I will provide a table which has the different delivery zones: UK, Europe, Rest of World and lists which countries are in each zone, (The countries will be listed as the 3 character country code to match what will be in the order file.)
Therefore I need two sections:
1) A page where I press a button, the script runs, and I see a confirmation message showing how many orders were downloaded and edited and that the ftp upload was successful
2) A separate page where I can create the rules
I suggest this is done in php but will listen to proposals in other languages.
Thanks,
Andrew
Please see the attached file which shows 4 different orders.
This is a sample input file (I will provide a URL from where this can be downloaded with the latest version).
I'd like to access a web script / web app which will import the latest version of this file, follow some rules as detailed below and then export a new version of this csv file. I'd like this new csv file to be uploaded to an ftp location I will provide.
I'd like to be able to set rules such as:
1) If the product code = X then change it to Y
2) If the product code for a particular order contains "clarisonic" and "mia" AND the delivery country is in Europe* then add a new line to that order with a product code of 'uk-eu'
* I will provide a table which has the different delivery zones: UK, Europe, Rest of World and lists which countries are in each zone, (The countries will be listed as the 3 character country code to match what will be in the order file.)
Therefore I need two sections:
1) A page where I press a button, the script runs, and I see a confirmation message showing how many orders were downloaded and edited and that the ftp upload was successful
2) A separate page where I can create the rules
I suggest this is done in php but will listen to proposals in other languages.
Thanks,
Andrew
Andrew S.
99% (63)Projects Completed
77
Freelancers worked with
74
Projects awarded
44%
Last project
23 Apr 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies