Forums

Admin data export to csv

fullfusion 01 May, 2012
Hello,

I have ChronoForms V4.0 RC3.3 installed on a Joomla! 2.5.4 site. I have a simple test form set up that writes to a db. I want to be able to export that table data from the Table Data Viewer screen using the CSV Export button. I select a record, or all the records, click the button and I'm taken the the Admin forms processor page, but nothing else happens. I've read various posts about using the CSV Export action in the form, but that seems to all be related to making it possible for front end users to export data from a table. I need everything to be in the back end administrator view at this time. How do I get that CSV Export button to work?

Thanks.
Dan
GreyHead 01 May, 2012
Hi Dan,

I think it works like this.

Add a new event to the form and put the CSV Export action there. The click the Form Name link and click the Admin actions tab. Put the name of the new event in the Data View Functions box. Save the form and then you should have a new icon in the Data View linked to the CSV Export event.

Bob
fullfusion 01 May, 2012
Thanks for the quick reply, Bob!

That created a new button that looks just like, and does the same thing as, the one that was already there.

I tried configuring various aspects of the CSV Export action, but I still get the same results. What should be configured in that action since this is on the admin side of things?
fullfusion 08 May, 2012
Following up on this... Bob, any suggestions?
Max_admin 09 May, 2012
Hi Dan,

I'm not sure I can understand the issue here.

The CSV export button in the "Show data" page works fine here, what do you need to do exactly ?

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
fullfusion 09 May, 2012
Thanks for the reply, Max.

I want to be able to export that data. I select all the records, click the CSV Export button and I'm taken the the "Admin forms processor" page, but nothing else happens. Clicking the CSV Export button should download that data in a CSV file format, correct?

Dan
fullfusion 14 May, 2012
Max or Bob? I need some assistance on this please.
fullfusion 07 Jun, 2012
I've been working on some other projects, but this one is coming back onto my radar. My CSV export is still not working. Please help.
fullfusion 11 Jun, 2012
Yo, guys. Where are you?
webbman66 14 Jun, 2012
Hi Guys,

I too am trying to figure this out. The same thing happens to me.

1. I click "show data" for the connected table for my form.
2. It takes me to the list of records for that form.
3. Whether I select one or all of the records, as soon as I click the "CSV Export Button" in the toolbar above, it redirects me to a blank "Admin forms processor" page where nothing happens. Its just a blank page. Should this not do something?
GreyHead 18 Jun, 2012
Hi,

Sorry, I'm not sure how the toolbar buttons work. I usually use front-end forms instead and they seem to work OK provided that the CSV Export action is correctly configured.

Maybe you have to configure an Admin Form to do the export? There is a 'Data View Functions' box on the Form 'Admin actions' tab.

Bob
fullfusion 18 Jun, 2012
No matter what I do in the configuration, it doesn't change my result. See my earlier post. I have on_csv_export:CSV Export in the Data Views Function field. Do you have any other suggestions, or can Max shed any light on this?
m1hc 19 Jun, 2012
Hi. I resolve this issue. Set 777 to folder /components/com_chronoforms/exports/ and subfolders. Export is working now.
altcom 19 Jun, 2012
Hi,

I managed to solve this without having to set the permissions to 777 (a security issue).

The folders for each form are created in the export folder with the FTP user as the owner and group. I had to set the group to apache and add group write positions to get the file generation to work. Maybe there is a way to get this to work if the FTP user is in the same group as apache or something like that???

Hope this helps someone determine what the problem is rather than having to change the group of each folder.

Cheers, Harvey
This topic is locked and no more replies can be posted.