MachForm Community Forums » MachForm 3

1. jaa
   Member

   Is there any chance to save automatically forms to .xls?

   Thanks

   Posted 12 years ago #

2. AMurray
   Pro Member

   Saving the forms to Excel ? Or saving the data submitted? - Yes you can do that. From the Entries Manager, there are the options to export to Excel, and CSV format and a couple of others but it's not an automated process.

   I suppose to do so automatically would require a CRON job (advanced stuff, too much to explain in this forum, and I'm not sure how to set CRON jobs up - ask your host about such matters) which could be scheduled to export the data to an excel file and email to you, but that's outside the functionality of Machform.

   Posted 12 years ago #

3. ceemjay
   Member

   Forgetting the external mechanisms eg CRON etc. Does anyone know what would need to be done on the Machform server to export to XLS i.e. to automatically replicate a user logging in and selecting the export option?

   At the moment I run a SQL query to do it but that's a bit messy. Happy to help if anyone wants to do it that way!

   Thanks
   Ceemjay

   Posted 11 years ago #

4. ceemjay
   Member

   After some investigation the easiest way is to create a new php program based on export_entries.php. It's quite easy to comment out the security checks - but take all necessary precautions to keep things secure.

   The complication doing it with cURL/Wget is coping with the security - they were a step too far for me!

   Happy to help if anyone needs it

   ceemjay

   Posted 11 years ago #

5. ceemjay
   Member

   Forgot to add to previous post that you will still need to use cURL or wget to execute the php script to copy the file from the machform server.

   ceemjay

   Posted 11 years ago #

RSS feed for this topic

Reply

You must log in to post.