Publisher review: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:
- 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.
- Error handling on a per-row basis. Includes the option to fix a row with the wrong number of columns or ignore it. Fixing a row will append extra columns to the end of the row if the row is lacking columns and will remove excess columns from a row that contains too many columns.
- Includes the option to create an Auto-Increment ID column on the MySQL table.
- Error reporting will show you which rows had errors and how those rows were read by the datafeed parser.
- Options to create the SQL only or create it and execute it.
- Great for affiliate datafeeds, Datafeed-to-MySQL also includes a find and replace feature to allow you to replace a generic affiliate ID with your ID.
- Includes security features: password-only access and restrict use to an IP address.
- Immediate download after cleared payment. As soon as PayPal informs us that your payment has cleared, an email will be automatically sent to you with a link to download the file. For credit card payments, you should be able to download the file within a few minutes after purchase.
- Download available in zip and tar.gz formats.
- Datafeed-to-MySQL works where the PHP function fgetcsv() fails!
- Does NOT use MySQL's LOAD DATA statement (which is not supported on most web hosts)!
- Features a total of 3 levels of server-load reduction!
Datafeed-to-MySQL is a PHP script for XML Tools scripts design by Php Mill.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris
Datafeed-to-MySQL script details 
