Contact Form Processing Products - for all your needs

FormMail • Form Encryption • Hosted Forms

LIMITED_IMPORT Setting

This page documents the LIMITED_IMPORT configuration setting in FormMail.

Type Of Setting

LIMITED_IMPORT is an OPTIONAL setting, which means...

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

NOTE: LIMITED_IMPORT is deprecated as of version 8.23 of FormMail. You should not use this feature any more as it is superseded by more exact per-field control provided by format specifications in the csvcolumns and filter_fields hidden fields. See Creating HTML Forms for more details.

The documentation below may no longer be accurate.

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:

  • truncate to MAXSTRING length
  • strip the value of line breaks and multiple spaces
  • trim the value from leading and trailing white spaces

Default Value

From version 9 onwards:

$LIMITED_IMPORT = true;

Before version 9:

define("LIMITED_IMPORT",true);

Examples

From version 9 onwards:

$LIMITED_IMPORT = false;

Before version 9:

define("LIMITED_IMPORT",false);

See Also

 
Close