cezdev / xml_sql_converter

Import XML files to MySQL-database

A very simple application for importing XML structured data into a MySQL database.

First a custom report scan is made with Network Inventory Advisor. Afterwards the report is exported to a XML-file. The index.php page handles the action form for uploading the XML. Upload_xml.php uploads and stores the file by usage of the $_FILES function in PHP. Convert_XML.php loads the XML-file (with use of simplexml_load_file) and parses the lines into a single MySQL-query. The query is executed and the data is stored in the appropiate table.

Until so far this conclude the README for the XML_SQL_Converter.

xml_sql_converter's Issues

Uploading XML Results in `HTTP Error 413.1 - Request Enity Too Large`

I also changed the Default uploadReadAheadSize from 49152 to 2147483647. The XML File I try to parse has a size of 300 MB.

When I also change maxAllowedContentLength to 5000000000 the Page Results in:

PHP Warning: POST Content-Length of 258023685 bytes exceeds the limit of 8388608 bytes in Unknown on line 0 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 4 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 10 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 11 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 12 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 14 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 20 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 21 PHP Notice: Undefined index: file in C:\xsc\upload_xml.php on line 22 

I could fix it by cahnging also in php.ini post_max_size = 8000M and upload_max_filesize = 20000M but now I get a Screen like this:

Ad when I click Convert.. then there is no Page:

How does it work ?