.. You may want to use the usual include line. Uncomment and adjust the path. .. include:: ../Includes.txt ==================== 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: EXT: julle\_form2csv ==================== Extension Key: **julle\_form2csv** Copyright 2005, christian@jul.net, 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: 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: Introduction ------------ .. _What-does-it-do: 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: Screenshots ^^^^^^^^^^^ Here is an example mail form, as seen by visitors in the frontend: |img-1| .. _Users-manual: Users manual ------------ .. _Creating-a-form: 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: |img-2| .. _CSV: 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 |img-3| 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: 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: 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** .. ### BEGIN~OF~TABLE ### .. _path: path ^^^^ .. container:: table-row name path description the path relative to the siteroot that the csv files will be stored in default value fileadmin/csv .. _filename: filename ^^^^^^^^ .. container:: table-row 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: dontSendEmail ^^^^^^^^^^^^^ .. container:: table-row 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 .. ###### END~OF~TABLE ###### .. _Credits: Credits ------- This extensions was funded by Aarhus School of Architecture ( `http://aarch.dk `_ ). Thanks a lot for your dedication to TYPO3! .. _Changelog: Changelog --------- 1.0.0: Revised by Christian Jul Jensen for publication 0.0.0: Initial version by Jacob Hammeken from Wildside (thanks a lot) |img-4| EXT: julle\_form2csv - 3 .. ######CUTTER_MARK_IMAGES###### .. |img-1| image:: img-1.png .. :align: left .. :border: 0 .. :height: 311 .. :id: Graphic3 .. :name: Graphic3 .. :width: 402 .. |img-2| image:: img-2.png .. :align: left .. :border: 0 .. :height: 238 .. :id: Graphic2 .. :name: Graphic2 .. :width: 493 .. |img-3| image:: img-3.png .. :align: left .. :border: 0 .. :height: 81 .. :id: Graphic4 .. :name: Graphic4 .. :width: 1190 .. |img-4| image:: img-4.png .. :align: left .. :border: 0 .. :height: 32 .. :id: Graphic1 .. :name: Graphic1 .. :width: 102