v4 Form data to Excel export

Hey there,

Is it possible to export the data of a form to an Excel-worksheet? I found this rather easy in v3 but can't get it to work in v4.

Any help is highly appreciated! 😀

Franklin

Hi Franklin,

There are several ways:
[list=a]

If you want a full table dump from the admin area then you can use the 'CSV EXport' from the Table Date Viewer icon in the Forms Manager ToolBar, you need to select a form and table first.

If you want a one-off selective export and are familiar with MySQL a little then you can use the AceSQL Joomla! extension which will let you build a query and export the results.

If you want to routinely export selected results then I'd build a form using the CSV Export [GH] action (or better the v2 from my site ) that will export a list at the click of a Submit button.

[/list:o]
If the table you are exporting uses long text inputs from textareas then you may need to use the last option to set the delimiters get the csv file to open cleanly in Excel.

Most CSV files will open in Excel if you use the From Text button on the Data tab.

Bob

Dear Bob,

Once again, you really show what the Open Source community is all about. Top notch extensions, and fast & friendly support. Really really great!

Your answer was certainly helpful. I used the DB Save action and that works like a charm. Cheers again for you fast support!

Regard,

Franklin

Hi Bob,

I used the Export Custom action method its works for me using Table.

I need to create directly Excel file from form data (Not from DB Table). I have already defined Column in Excel so i just need to append my form value to EXCEL File (Only EXCEL).

Can you pl advice me. Thanks


Regards
Gopi

Hi Gopi,

The CSV Export action will work from data in the $form->data array:

The path to the data list in the form->data array, use this if you already have the data in your form data array through a DBMRL action for example.
e.g. MODEL_ID

Bob

Hi Bob

I can't make it work. if i choose table its work for me but form to Excel no idea. can you plz help me out.


i drag DB multi Loader into On sumbit and set the Model ID
I drag the CSV Export action - Set Data Path to Model ID. Is it correct.
Save Path, Filename and Delimiter already set.

What else i need to set ? can u plz advice

Thanks
Gopi

Can anybody help

I am trying to do insert current Form data to Excel and send email to admin.

Email all Ok but I have a problem to collect the form->data using Multiload and CSV export.

Someone advice pls.

Thanks

HI hralthbook,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Bob