how to export all fields from chronoconnectivity to txt separated by coma?

Qbik 03 Apr, 2014
like in subject Is there any option to export/download all fields from chronoconnectivity to txt separated by coma?

i need it for program and it have to look like this


field1,field2,field3,field4,field5
field1,field2,field3,field4,field5
...


any idea how to do that??
Max_admin 03 Apr, 2014
Answer
Hi Qbik,

A quick solution would be to connect this table to a chronoform and use the "db viewer" to export all records, you get a CSV file with the format you need.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 04 Apr, 2014
ok i tried to do a CF for that in setup i add DB read and it show my records in debbuger as array but when i add CSV Export nothing happen
how to export this records? I try to find some manual for that but with no effect😟

ps a lot of questions lately
Max_admin 04 Apr, 2014
No, after you add "db read" and save your form, you should find your table under the "tables connected" in the forms manager, just click that link and you should have a button to export records.
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 04 Apr, 2014
Ok thx i dont know why i think that it should show something on frontend😑

thx
Max_admin 04 Apr, 2014
Well, you just need to export the data, then better do that only on admin for security and simplicity!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 04 Apr, 2014
Ok last questions about that.
Can I disable showing id and creation date?
I wrote in fields what i want to show but there is still whole table😟
Max_admin 04 Apr, 2014
Just configure this under the "DB viewer" tab inside the form itself.
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 04 Apr, 2014
Ok to show without backup yes, it show what i want, but when I mark all records and download them as csv files it download all records from table (with id and created date)too😟
Max_admin 06 Apr, 2014
Ok, in order to customize the fields in the file itself you will need to use the CSV backup action into a form event, then you will need to configure the action to list the fields you need.
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 06 Apr, 2014
Ok i tried to do tat but still the same all the time id is added to csv file😟

now i prepare special form with only "export to csv" on load i set all columns i need in Columns field, I left empty Data Path, Titles and Order by
and there is the same effect as for "DB read"
Max_admin 07 Apr, 2014
Using the "export csv" action you also get all the columns in the csv file ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Qbik 08 Apr, 2014
Yes, for now i set to wrote in DB only id and my own fields and its always export with id too how to disable "id" to not export at csv file
Qbik 13 Apr, 2014
Any idea how to do that?? where is the problem??
If You want to i can send You login and password to my site on PM than you can check by yourself
Max_admin 13 Apr, 2014
Hi Qbik,

I found a bug, please send me a message using the contact us page to get the patch file!

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.