ADVANCED_TEMPLATES

Index

VALID_ENV

This page documents the LIMITED_IMPORT configuration setting in FormMail.

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.

Specifies limitations in your CSV processing.

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

define("LIMITED_IMPORT",true);

define("LIMITED_IMPORT",false);

CSVDIR

CSV File Settings

ADVANCED_TEMPLATES

Index

VALID_ENV