Forums

Can't save data to DB, GoogleSpreadsheet or XLS

eMCe71 21 Jul, 2015
Hello,

I must confess that I find chronoforms very nice but however I am trying to do everything due to FAQs and docs I still have some major problems.

I am creating form for registration for conference: http://chdz.pl/sympozjum.html

I need save form data from applicants in file / spreadsheet / db so my other colleagues can verify it.

Problems:
1. When I create DB:
- most important fields data (text1, text2...) are not going to DB table
- only button9 etc are saving

This is what debbuger shows:
[DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `chdz_chronoengine_chronoforms_sulislaw2015` (`button9`, `user_id`, `uniq_id`, `created`) values ('Wyślij zgłoszenie / Submit', '0', '279c69d349710a4742e7ca0b5125551b84aab570', '2015-07-21 10:25:13');



2. When I choose Google Spreadsheet Save:
- spreadsheet is not filling in
- I attach screenshots

3. When I choose XLS
- xls file is creating but nothing happens in this file

Please please help! Thank you

PS. Could anyone explain me what "Array" means? English is not my first language and as you can see I am not IT/programming specialist and this word occurs very often and maybe this is my problem I don't understand this

For example I still have something like this in debbuger


Errors

Array
(
)
GreyHead 21 Jul, 2015
Hi eMCe71,

For Array, please see here - we're mostly using PHP but the idea is the same.

The empty Errors array just says that no errors were found.

For the DB Save - does your table have columns with the names text1, text2, etc? If so please try clicking the Delete Cache icon in the Forms Manager toolbar to update ChronoForms records and then re-test.

For Google Save there is a problem because Google has changed the Authorisation method a few weeks ago and the current action no longer works. I have a 'beta' version of a new action - if you want to test it please send me a PM, it is a little more complicated to install than the current action as it uses a Google API library.

The XLS Export should work OK, please copy and paste the whole of the Debugger output here so I can see the data that is being submitted.

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