Forums

Hi!

I have a reservation form. When the form is filled out, the data is saved in a database table. This works OK.

As a next step I want to save a CSV with all data from the table in a directory on the server.

I got the file to save, but is still empty. I think I need to have a different Data Provider for the CSV action.

How do I get the data that is read by Read Data action in the CSV file? What do I specify as the Data Provider?

There is currently no XLS save function? Only CSV?

Kind regards,
Jip

Hello jj135,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
P.S: I'm just an automated service😉

The Read Data action name="read_data_12". Model name "Data12". The debuggers sows an array with all the data....

In the CSV action I tried as Data Provider:
{data:read_data12}
{data:Model12}

Or just plain 'Model12' and 'read_data12'

This did not work. I got an empty CSV...

Now I tried {var:read_data12}

This showed me all records in the Excel, but every line says 'Array' insstead of showing the actual data of the records... The first line says 'Data12' (column title I guess)

I probably need somthing like {var:read_data12.data}? But this also does not put any data in the CSV file... Any suggestions?

This is the data from the debugger:
In need read_data12 in the CSV.

Array
(
    [titel] => test
    [chronoform] => reserveren
    [event] => submit
    [evenement] => test
    [kaarten] => 2
    [naam] => Jip
    [email] => jip@inxpact.nl
    [bijzonderheden] => sads
    [nieuwsbrief] => Nee
    [verzenden] => 
    [9e1e2a3db4910608585af23807040050] => 
    [4495b413f6e3bac190fc5d78be0a1d25] => i2jooh2hrb8mq614hqrj4pm3i2
    [e5df12cfb0317a80490c8b43c18851d7] => ml1o9vj44ltl7s0m2q5094o9i2
    [_gat] => 1
    [_ga] => GA1.2.190844832.1501412382
    [_gid] => GA1.2.290154437.1501412382
    [Itemid] => 709
    [option] => com_chronoforms6
    [view] => form
)
Array
(
    [validate_fields6] => Array
        (
            [log] => Automatic validation enabled.
            [var] => 1
        )

    [save_data9] => Array
        (
            [data] => Array
                (
                    [titel] => test
                    [chronoform] => reserveren
                    [event] => submit
                    [evenement] => test
                    [kaarten] => 2
                    [naam] => Jip
                    [email] => jip@inxpact.nl
                    [bijzonderheden] => sads
                    [nieuwsbrief] => Nee
                    [verzenden] => 
                    [9e1e2a3db4910608585af23807040050] => 
                    [4495b413f6e3bac190fc5d78be0a1d25] => i2jooh2hrb8mq614hqrj4pm3i2
                    [e5df12cfb0317a80490c8b43c18851d7] => ml1o9vj44ltl7s0m2q5094o9i2
                    [_gat] => 1
                    [_ga] => GA1.2.190844832.1501412382
                    [_gid] => GA1.2.290154437.1501412382
                    [Itemid] => 709
                    [option] => com_chronoforms6
                    [view] => form
                    [created] => 2017-07-30 14:20:17
                )

            [_success] => Data saved successfully
            [log] => Array
                (
                    [0] => INSERT INTO `d1ajs_chronoengine_chronoforms_data_reserveren` (`evenement`, `kaarten`, `naam`, `email`, `bijzonderheden`, `nieuwsbrief`, `created`)  values  ('test', '2', 'Jip', 'jip@inxpact.nl', 'sads', 'Nee', '2017-07-30 14:20:17');
                )

            [var] => Array
                (
                    [evenement] => test
                    [kaarten] => 2
                    [naam] => Jip
                    [email] => jip@inxpact.nl
                    [bijzonderheden] => sads
                    [nieuwsbrief] => Nee
                    [created] => 2017-07-30 14:20:17
                    [aid] => 73
                )

        )

    [read_data12] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Data12`.`aid` AS `Data12.aid`, `Data12`.`created` AS `Data12.created`, `Data12`.`evenement` AS `Data12.evenement`, `Data12`.`kaarten` AS `Data12.kaarten`, `Data12`.`naam` AS `Data12.naam`, `Data12`.`email` AS `Data12.email`, `Data12`.`bijzonderheden` AS `Data12.bijzonderheden`, `Data12`.`nieuwsbrief` AS `Data12.nieuwsbrief` FROM `d1ajs_chronoengine_chronoforms_data_reserveren` AS `Data12`;
                )

            [var] => Array
                (
                    [0] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 47
                                    [created] => 2017-07-28 16:03:37
                                    [evenement] => Afrikaanse Avond
                                    [kaarten] => 1
                                    [naam] => Jip Jonker
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sdfdfsdf
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [1] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 63
                                    [created] => 2017-07-28 17:25:45
                                    [evenement] => Tiel van het evenement
                                    [kaarten] => 1
                                    [naam] => Jip Jonker
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => hgffghfghgfhhgh
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [2] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 64
                                    [created] => 2017-07-28 17:28:09
                                    [evenement] => Tiel van het evenement
                                    [kaarten] => 1
                                    [naam] => Jip Jonker
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => hgffghfghgfhhgh
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [3] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 65
                                    [created] => 2017-07-30 11:00:09
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sadasd
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [4] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 66
                                    [created] => 2017-07-30 11:01:24
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sadasd
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [5] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 67
                                    [created] => 2017-07-30 11:03:42
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sdsadddsd
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [6] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 68
                                    [created] => 2017-07-30 14:15:54
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => asdsasds
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [7] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 69
                                    [created] => 2017-07-30 14:17:58
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => qewqwe
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => asdasd
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [8] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 70
                                    [created] => 2017-07-30 14:19:07
                                    [evenement] => test
                                    [kaarten] => 1
                                    [naam] => qewqwe
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => asdasd
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [9] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 71
                                    [created] => 2017-07-30 14:19:34
                                    [evenement] => test
                                    [kaarten] => 2
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sads
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [10] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 72
                                    [created] => 2017-07-30 14:19:55
                                    [evenement] => test
                                    [kaarten] => 2
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sads
                                    [nieuwsbrief] => Nee
                                )

                        )

                    [11] => Array
                        (
                            [Data12] => Array
                                (
                                    [aid] => 73
                                    [created] => 2017-07-30 14:20:17
                                    [evenement] => test
                                    [kaarten] => 2
                                    [naam] => Jip
                                    [email] => jip@inxpact.nl
                                    [bijzonderheden] => sads
                                    [nieuwsbrief] => Nee
                                )

                        )

                )

        )

)

Hi Max, yes this works! I knew there had to be a way. Never would have thought of the [n] ;-) Have missed that in the forum / documentation somewhere? Anyway, it works for me now. Thanks!

I also changed the delimiter to ; so I could open the file in Excel with the fields separated in columns. The comma delimiter opened the records in one column.

Kind regards, Jip

Hi Jip,

Have missed that in the forum / documentation somewhere?

I think its mentioned in a few forum posts only, its not common to use this syntax, but its required for the CSV action, and maybe needed in special cases.

Best regards,
Max