Forums

exporting to a .csv file

ntertainme 23 Dec, 2009
Dear sirs,

I created a for steps multiform (mother).
And everything seems to work fine.
I receive the email with all the 4 forms information, so far so good.

I named al the fields the same as our access database.
Now I want to import all the filled-in field to our database system.
I guess the work is done by sending all the information to a .csv file.
What are the exact step to create a file?
I didn't create a connection to a database yet, so nothing is stored to a database.
Please explain me what do to.

Thanx for your apply.
Sander
GreyHead 23 Dec, 2009
Hi sander,

Create a DB Connection -- see the Tutorial from the Tutorials link above.

Then you can either export to CSV or Excel using the link in the Toolbar in the Forms Manager | View Data page; or I think that you can have an OBDC link directly between MySQL and Access.

Bob
ntertainme 23 Dec, 2009
Dear Bob,

thanx for your feedback.
I created a database and selected all database fields to be stored in the database.
No errors here,

As soon as I open the mother form, the following error appeared:

Parse error: syntax error, unexpected T_FOR, expecting ',' or ';' in /storage/mijndomein/users/012760/public/sites/www.ntertainme-webdesign.nl/cosmo/components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 9

Fatal error: Call to a member function bind() on a non-object in /storage/mijndomein/users/012760/public/sites/www.ntertainme-webdesign.nl/cosmo/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13



What should I do?
GreyHead 23 Dec, 2009
Hi ntertainme,

This is probably a problem with one of your input field names - they should have only a-z, 0-9 & underscore - no spaces, dashes or other special characters.

Bob
This topic is locked and no more replies can be posted.