PHP FormMail,
Form Encryption
 
LIMITED_IMPORT Setting

This page documents the LIMITED_IMPORT configuration setting in FormMail.

Type Of Setting

LIMITED_IMPORT is an OPTIONAL setting, which means...

Pointer

OPTIONAL

you can change this setting if you need to, but the default value is fine for most circumstances.

Précis

Specifies limitations in your CSV processing.

Description

Set LIMITED_IMPORT to false if your target database understands escaped quotes and newlines within CSV files.

When formmail.php is instructed to write to a CSV file, it can strip special encodings or leave them intact.

What you want to do depends on the final destination of your CSV file. If you intend to import the CSV file into a database, and the database doesn't accept these special encodings, you must leave LIMITED_IMPORT set to true.

Microsoft Access is one example of a database that doesn't understand escaped quotes and newlines, so you need LIMITED_IMPORT set to true.

When LIMITED_IMPORT is true, the following transformations are made on every form value before placement in the CSV file:

  • \\ is replaced by \
  • \X is replaced by X where X is any character except \
  • control characters and multiple spaces are replaced with a single space (this means newlines are removed too)

define("LIMITED_IMPORT",true);

Examples

define("LIMITED_IMPORT",false);

See Also

CSVDIR

CSV File Settings