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,

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