Datafeed-to-MySQL is designed to parse properly formatted tab, comma, pipe, semi-colon, colon, tilde, and star delimited datafeeds into MySQL format. It will detect errors in the feed and attempt to fix them or ignore them. This is a great tool to parse affiliate datafeeds into a MySQL table. License allows for use on any number of websites as long as they are owned and operated by the purchaser.
Features:
* Cron Jobs now possible: allows user to bypass form submissions. Script can be run by accessing it’s url.
* Supports properly formatted tab, comma, pipe, semi-colon, colon, tilde, and star delimited datafeed files.
* Supports enclosing/escaping characters.
* Supports line breaking characters within a row of data.
* Allows preservation or removal of non-row-terminating line breaks.
* Includes user-adjustable features that significantly help reduce server-load.
* Supports large feeds of more than 100 MB.
* Has options to use the first row for MySQL column names, read it as data, or ignore it.
* And more…
Requirements:
PHP > 4.1, MySQL (optional), writable directory, fopen(), internet connection