I need a script that can parse an XML or CSV (csv, txt, tab, pipe, ect.) file into Mysql but it has to store all the data temporarily before importing.
I have 5 files, 3 are xml and 2 are csv. I need to upload each one separate but all the data needs to be stored in a temporarily file or something. Every time I upload a new file it would append the data to the temporarily file. Once complete, I would select a button that would add all the data from the temporarily file into the database.
When I select a file to upload (or the url to the file) I choose a company from a drop down list. When processing the file the script will check the database for the id and save the data in the temporarily file in this format: local id - source id - company - value. The "local id" is found by checking my database WHERE source_id = source_id. The company is the one I selected from the drop down list.
This is a very simple script and should be clean and function properly.
Please PM Questions.