Automate .xlsx File Transformation to .csv
Budget: $30 – $250 USD
Objective: Develop a script to retrieve a .xlsx file from a fixed URL which creates the file, modify specific values in the file, and save the transformed file to the server as .csv
Processes the .xlsx file by modifying the values in column G as follows:
1 → 200
empty (no value ) → 0
Save the modified file to the server under the name blbstocks.csv
retaining all other column data unchanged. Schedule the script to run automatically 2 times a day using a cron job (directadmin or ssh).
Deliverables: Fully functional script installed on the specified website.
A cron job configured for automated execution.
Note: You will be informed of the specific folder or website location where the script should be installed.
General Responsibilities:
Develop and install the required script.
Configure the cron jobs for automated execution.
Ensure all thoroughly tested and fully functional.
Provided Resources:
FTP credentials and full access to the target website will be shared upon project award.
Link url for getting xlsx. The link will generate a .xlsx file. The name of the file received on the url is different all the time (they add date, time)
i added example of the xlsx to pick up.
Colom A is SKU
Colom G is stock which needs changed value
The .csv is what needs to be the endresult on our server
Questions let me know
Processes the .xlsx file by modifying the values in column G as follows:
1 → 200
empty (no value ) → 0
Save the modified file to the server under the name blbstocks.csv
retaining all other column data unchanged. Schedule the script to run automatically 2 times a day using a cron job (directadmin or ssh).
Deliverables: Fully functional script installed on the specified website.
A cron job configured for automated execution.
Note: You will be informed of the specific folder or website location where the script should be installed.
General Responsibilities:
Develop and install the required script.
Configure the cron jobs for automated execution.
Ensure all thoroughly tested and fully functional.
Provided Resources:
FTP credentials and full access to the target website will be shared upon project award.
Link url for getting xlsx. The link will generate a .xlsx file. The name of the file received on the url is different all the time (they add date, time)
i added example of the xlsx to pick up.
Colom A is SKU
Colom G is stock which needs changed value
The .csv is what needs to be the endresult on our server
Questions let me know