Devam Ediyor

496295 Custom PHP script to parse XML and CSV into MySql

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.

Example:

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.

Function:

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.

Beceriler: Her şey Kabul, MySQL, PHP, Kabuk Betiği, XML

Daha fazlasını görün: php upload file csv, php save data file, xml tab, custom function php, mysql append data, function check php, mysql append, mysql save data, xml mysql php script, script clean list, php drop list, mysql store xml, mysql source xml, csv files processing, drop list php, mysql select xml, clean csv file php, php script function, php xml processing, xml local database, upload xml, xml processing, mysql clean data, clean php script, simple mysql processing

İşveren Hakkında:
( 60 değerlendirme )

Proje NO: #2242210