Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Is possible to use joomla db for any record and send 1 cvs file per day?

webmasterinaffitto 08 Oct, 2019

Hi,
I'd like to install a pro version of Chronoforms in a website. My customer ask to get at the end of every day just a .cvs file contain all the new data collected in just that day.
Is it possible?

How can I set the "send" action to do this?
I don't know if is it possible to collect every single form in joomla db and at the end of the day the system send all the day collected data by email in a cvs format.

Thank you for answer

GreyHead 08 Oct, 2019

Hi webmasterinaffitto,

It's probably simplest to do this using a cron job on your server with a bit of PHP (or you could call a from event if you like).

There is also a MySQL excel extension that can sync between your server database and Excel - provided that your server allows remote access.

Or you can save the form data on submission to Google Sheets and export from that as needed.

Bob

healyhatman 08 Oct, 2019

It is possible.
In your form, set your event to "standalone"
Read data, save to csv, email the client.

Set up your cron job to point to yoursite.com/index.php?option=com_chronoforms6&chronoform=YOURFORMNAME&tvout=view

You could also do the same thing, but purchase my Save to Google Sheets action.

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