Dumping Values to a Database:
Text File

Dumping field values to a text file it's common solution to have all the field values in a standard format, which can be used to import the values to spreadsheets, databases and other programs. This option writes the field values of the HTML form into a text file in the same server after the user submit the form.

It is independent of the email message to the form's owner. If the text file doesn't exists, the script will create one.

Requirements and Restrictions

• This option is only available in the registered version of Forms To Go.

• The directory were the text file will be created must have write permission for the web server

To configure the settings and activate this option, select Text file dump... from the Settings menu.

Dump field values to a text file

Select this option to include in the script the specific code to dump the fields values to the text file.

File format

Specify which format you would like to use: Tab Separated Text or Comma Separated Values. Both formats are very common for many applications. Check which format support the application you'll be using to later import the values.

End of line

Depending on the operating system you'll be using to process the text file with the field values, you must select the End of line type. If you'll be opening the text file in Excel on a MS Windows OS, you must select DOS/Windows as the End of line. If you'll be using Excel on a Mac OS, you must select Mac.

File name

The file path to the text file. The file path can be relative to the script location, but it is suggested to type the full path in case you move the script to another location on the server.

Example:

c:\mydomain\htdocs\data\webdata.txt

if you're running on a Windows server or

/vserver/mydomain/htdocs/webdata.txt

if you're running in a Unix server.

The directory were the text file will be created should have write permission from the script. If the text file already exists, it should have write permission as well.

Add timestamp to each dump

This will add a timestamp, like 2004-07-14 16:07:00, with the field values every time it dumps to the text file.

Fields to dump

When dumping the form's field values to the text file, you must select which fields will be dumped by clicking in the checkbox at the left of the field name. You need to check at least one field name.


More about Dumping Values to a Database:

Text file
MySQL
MS Access

Index