MachForm Community Forums » MachForm 2

1. Beaverman
   Member

   I am using Machform and its brilliant. I wanted to know if and how i go about exporting the mysql data to Access automatically, can this be done with some code on the page or do i need to do this through access at all? If so can anyone point me in the right direction?

   Not sure if im explaining myself properly, but the end result i want is that i have an access database that is on my local PC and any time someone submits a form it will appear in my Access database without me having to do anything.

   Thanks in advance.

   Posted 15 years ago #

2. AMurray
   Pro Member

   There's no automatic way 'out of the box' but you can do this manually.

   Just export the mySQL form data to Excel or CSV file, then import that into Access. If you get a lot of data entries, maybe do this twice a day....not sure how else to make this work.

   It would take a lot of modifcation and not sure you can have it submit to mySQL AND MS Access in any case - would have to be one or the other.

   Machform might not be wholly suited to what you want to do since it works primarily with mySQL not MS Access.

   I don't know much about "CRON" jobs (LInux hosting) but maybe that could do it. It could export the data to Excel, and email/FTP the file to your computer....not sure if that would work or is the intent of the type of thing CRON jobs do.

   Someone else might chime in here.....?

   Posted 15 years ago #

3. AMurray
   Pro Member

   Just found out a bit more about CRON jobs....you could set a CRON job up to execute the "export-entries.php?form_id=x" script where "x" is the number of your form you want to export. (Look up CRON Job on Wikipedia - http://en.wikipedia.org/wiki/Cron)

   It will of course only export to Excel or CSV, but at least that part could be automatic; it's exporting to Access that is the trouble as Machform won't do it natively.

   The fact you can use an Excel doc as your Access data source might cut this down, since if you do the CRON job, to export to Excel and email, then you just have to save the attachment to the folder and overwrite the existing one, which means when you view in Access, the newer records should be visible.

   Posted 15 years ago #

4. Beaverman
   Member

   Thanks for the reply. I could use the Excel file as a data source as you say. This may work with a little luck and a bit of research on my part.

   Thanks again.

   Posted 15 years ago #

RSS feed for this topic

Reply

You must log in to post.