Forums

Can anyone please explain how to store user inputs in database?
This is the first time I'm using ChronoForms;)
I have followed a tutorial on how to Save the Data into the database, but I'm not getting all the inputs stored.
I'll I get is:
cf_id : 1
uid : IMjU5YmRjYzdhOWQ0f31326a7ef02eac3cb0fc2e544c97e9a
recordtime : 2010-09-16 - 14:40:17
ipaddress : 98.189.47.82
cf_user_id : 0

how to get First Name, Last Name, Email, etc?

Please advise

Hi jarekmas ,

Looks as though you didn't slelect all the inputs in the Create Table dialogue. It's changed since the tutorial and you have to select the extra bars. Green bars are selected, red bars are not. Drop (delete) the table using the Table Manager and start over.

Bob

You need to refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.

I have selected the inputs in the Create Table dialogue(they are green now) and also did refreshed the DB Connections, but I'm not getting any Field Data stored. When I view the the "Record" I only have Filed Names but no Field Data inputs.
I have used mostly text inputs in my form (with one upload file field) and changed "VARCHAR(255)" to "text"

I´ve got the exact same problem. Do you also get a corrupt excel file when you export(download) it?

I found this topic http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=2&t=17343&p=48106&hilit=stevenlips#p48106 stating the same problem, however this person did not select the wanted fields to be stored in the database. When I created the table I selected almost every field except for the checkboxes, hidden fields and fileupload fields. I've left them all at "varchar(255)".

After my test entry I checked the record wich was created but (just as above) it only showed entries for the 5 standard fields. The field names that I selected myself were shown but there were no entries to be seen in the field data column behind them.

I tried exporting the file to both excel and CSV and both were downloaded corrupted and there were no entries to be seen there either.

I hope you can help us.

I've fixed the problem for me at least.

I removed every dash (-) and spaces ( ) from my form names and field names and created a new table.

Everything works perfect now. Even exporting to excel. I'm so happy😀 Struggled with this for 1,5 weeks!!

I hope this helps other people with the same problem!