tbawarehouse
asked on
Inventory aggregation with csv files
We have a drop-ship company and receive 15 inventory updates daily from our drop-ship vendors. Currently we are manually editing and uploading each and every one of these csv files that we receive to our inventory management system. We would like a solution that provides aggregation of the csvs and automatically processes these csvs with the needed formating to upload to our inventory management system. Hopefully this makes sense.
Any ideas?
Sincerely,
Completely Clueless
Any ideas?
Sincerely,
Completely Clueless
ASKER
Sounds great but I worry if they have to upload to a website I may get some kick back. Seeing as now they are just ftping the file which is an automated process. Would this be as well?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This very much depends on input and output format, of course. Processing CSVs isn't difficult, in Windows you would e.g. use PowerShell or VBS with an FileSystemWatcher or WMI event monitoring script to kick-start the script, or start it on a regular base as stated abvove.
Do you want to insert that into a database (which DBMS?), or construct a web page (HTML table)?
Do you want to insert that into a database (which DBMS?), or construct a web page (HTML table)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Could you tell why you chose that two answers as solution?
php has builtin str_getcsv to parse the csv and has adapters to all the common databases.
Of course, there are an infinite number of other languages that could do the same thing.