DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

EXT: julle_form2csv¶

Author:	Kasper Skårhøj
Created:	2002-11-01T00:32:00
Changed:	2006-01-11T13:20:31
Email:	christian@jul.net

EXT: julle_form2csv¶

Extension Key: julle_form2csv

http://jul.net

This document is published under the Open Content License

available from http://www.opencontent.org/opl.shtml

The content of this document is related to TYPO3

- a GNU/GPL CMS/Framework available from www.typo3.com

Table of Contents¶

EXT: julle_form2csv 1

Introduction 1

What does it do? 1

Screenshots 1

Users manual 1

Creating a form 1

CSV 1

Adminstration 1

Privacy 1

Known problems 1

To-Do list 1

Changelog 1

Introduction¶

What does it do?¶

By installing this extension, mail form submissions are logged to a CSV file. You would typically use this extension when you need a mail form, particularly when you need to import form data into a spreadsheet or other program capable of importing data in CSV format.

If julle_formpreview is installed, the visitor may preview the message before a form mail is submitted. A receipt will be mailed to the visitor if the julle_formreceipt extension is also installed.

Screenshots¶

Here is an example mail form, as seen by visitors in the frontend:

Users manual¶

Creating a form¶

From the “New content” menu, choose a Mail form . In the “Configuration” field, you enter a form definition. The format for form definitions is defined in TSRef:

http://typo3.org/documentation/document- library/doc_core_tsref/FORM/

Here is an example form definition:

CSV¶

Whenever a form is submitted, the form data will be appended to the CSV file configured in TypoScript, by default this is “fileadmin/csv(pagename}_{month}.csv. If Page is the name of the page the form data was submitted to and Mon is the current month, the default filename will be.

fileadmin/csv/Page_Mon.csv

If you download and import the file

Note that the extension automatically creates CSV columns from the fields in the formmail, this means that if you alter the form, the extension will add more columns but never remove any, just leave the fields empty. this way you can change the form without loosing any data in your csv-file

Adminstration¶

Before installing this extension, you must manually create a csv subfolder in the fileadmin folder, so the fileadmin/csv folder exists. You must also ensure the folder is writable. If the server seems to hang the first time you try to submit a form, it may be trying to write to a file. There are no configuration options for CSV files.

In addition to this extension, you may wish to install one or more of the extensions julle_formpreview and julle_form2csv . If you do, it is important to install the extensions in the following order:

julle_formpreview

julle_formreceipt

julle_form2csv

If you install the first and the third, and later wish to install the second, you should uninstall everything and reinstall the extensions in the appropriate order.

Forms use exactly the same markup as a Typoscript FORM. Thus, you can alter the presentation of forms by changing the CSS stylesheet. Most HTML elements are styled with CSS classes, like csc-mailform, csc- form-labelcell, etc

Configuration¶

the extension has a few configuration options, please not that these options are located in config.tx_julleform2csv and not in plugin.tx_julleform2csv .

config.tx_julleform2csv

path¶

name

path

description

the path relative to the siteroot that the csv files will be stored in

default value

fileadmin/csv

filename¶

name

filename

description

the name of the file. This string is passed through the PHP function strftime ( http://php.net/strftime ), which means it is possible to specify that the ie. the month should be part of the filename and so the extension creates a new csv-fle every month, because the filename changes automatically.

Also the string {page} is susbstitued with the title of the page submitted to.

default value

{page}:_%b.csvthat is: name of page underscore current month dot csv

dontSendEmail¶

name

dontSendEmail

description

if this is set to 1 no email will be sent, the information will only be stored in the csv.

default value

0

Credits¶

This extensions was funded by Aarhus School of Architecture ( http://aarch.dk ). Thanks a lot for your dedication to TYPO3!

Changelog¶

1.0.0: Revised by Christian Jul Jensen for publication

0.0.0: Initial version by Jacob Hammeken from Wildside (thanks a lot)

EXT: julle_form2csv - 3