Header Row

The header row tells the script if the first record in your datafeed contains data or column names. If your datafeed contains a header, the first record will be used to define the field names in the database. If there is no header row then default column names (e..g field1, field2) will be assigned.

Field Delimiter

The field delimiter defines what character is used to delineate fields in the datafeed. The most common delimiter is a comma (CSV), however the script supports many other delimiter types (e..g. piped, tabbed)

Quoted

Some datafeeds enclose each field in quotes (e.g. "name","address","age"). The values of each field are wrapped by quotes (typically double quotes). If your feed is structured like this, set the quote drop down appropriately.

Search/Replace

In many datafeeds you might be required to substitute a generic field (e.g. an affiliate ID) with a unique value. Set the search/replace values accordingly. These fields are case sensitive. The default search and replace parameters can be set in the configuration file.

Table Name

The table name field is used to build the SQL code to define and populate your table. The default table name is controlled in the configuration file.

Miscellaneous

The script ignores rows in the datafeed with a mismatched number of columns (e.g. they don't match the count from the first record). This is necessary to support poorly formatted feeds.