Import Submitted Forms

You can Import Submitted Form data from your local computer using a simple spreadsheet file.

The CSV text file format is a universally accepted way to move data between systems, and since most spreadsheet and database programs can import/export CSV text files, it is an ideal way to exchange data.


	Select Formatted Text File to Upload
CSV File:	Browse and select the CSV file from your local computer that contains the Submitted Form data you wish to import. NOTE: If you are creating a CSV file from a spreadsheet file, each column in the FIRST row of the spreadsheet must match a Field Name from the Custom Form. Once a field match is found, the same column for all additional rows will be imported into the database for that Field. This matching of fields continues for all columns in the first row. When complete, a new Submitted Form that will be created for each additional row of data found. NOTE: These columns can be in any order. If you are saving a CSV file on a Mac, you might need to select the "Windows CSV" format in Excel.
	Select the Custom Form
Custom Form:	Select the Custom Form that contains the Form Definition (fields) that will be imported.

Limitations when importing Submitted Forms

There are two methods for collecting Submitted Form data. The most common is to capture a Submitted Form each time a Custom Form Page is submitted through the website. The other method is to import the Submitted Form data from a file.

There are some limitations when importing Submitted Forms:

If any Form Fields are set to "Connect to Contact", Contacts and User accounts are not updated.
No Custom Form Page work-flow features or auto-responders are triggered.
If the Custom Form Page defines any File Upload Fields, they will be ignored.

Import Submitted Forms

Select Formatted Text File to Upload

Select the Custom Form

Limitations when importing Submitted Forms