We have a thriving online business, but changes to our courier's shipping software mean we need to be able to process CSV files automatically without our staff needing to manipulate the data manually.
Ideally, the workflow will be as follows:
- Drag-and-drop CSV file into Windows folder (CSV IN, for instance)
- Script recognises presence of file and parses data - amends column headers, writes extra column of data based on existing data, removes unnecessary columns. Then writes to new CSV file with appended filename (time and date added) in different Windows folder (CSV OUT, for instance)
Obviously I can provide greater detail as required.
Anyway, that's what I'm thinking! I'm sure it's possible with some kind of script that runs in the background, but am unsure of how to do this.
29 freelancers are bidding on average £163 for this job
Hi I have rich experience in Python script development. I can develop it to transact with CSV easily. Please check my profile and past reviews. Let us discuss in more detail through chat. Thanks. Wang C.
i can write app which will check csv in folder and once csv file is dropped in it , it will update csv out file , this automation can be done via python or java .
hi there , it can be possible to create script that run back ground by creating windows service i am ready to work on it kindly message me for discussion regards tscreators
I am good in perl, php along with data conversion, for your requirement i can write perl script and give u the demo before delivery the code Please let me know if you are good to award this project to me
Hello there! Yes this is definitely doable with a script. Is this a Windows or Linux environment? Can you provide example of the original csv and example of what you need it to look like? I hope to hear from you