Forums

Data sent to Access file instead of email?

Stockmom 06 Nov, 2007
Can the data from the form be sent to create a file rather than sent to email address? I couldn't find this stated anywhere.
GreyHead 06 Nov, 2007
Hi Stockmom,

You can use the Create table button to have the data saved to a MySQL file if this helps. Or, I guess, you could create a template to email a csv style entry to be put into a database. There's no direct support for Access databases though.

Bob
Max_admin 06 Nov, 2007
Hi Stockmom,

Just as Bob mentioned, there is no direct support for "access" databases, however if you mean "access" some file, so you mean add/append data to it ? yes, you can have this done very easily if you added few lines of code to save the data variable sent in the email to a file, just 2 lines of PHP🙂

Cheers

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Stockmom 07 Nov, 2007
I meant for the form to create a .csv file for signing up for our Mailing List. We have too many contacts to send results via e-mail. If this extension doesn't do it, do you know which one might fit my needs better? And what about security of obtaining name/address info?
GreyHead 07 Nov, 2007
Hi Stockmom,

We're talking a bit in shorthand here and, I suspect. getting confused as a result.

What do you want to have happen to this file? Is it to remain on your server and then used to update the mailing file ever day or so?

What are you using for your mailings? Is it a Joomla extension? or some other mail server programme like PHPList? Or something completely independent?

I also don't understand your question about security? Files on a webserver database are moderately well protected but that does depend critically on how you and your ISP have set up the site. ChronoForms itself does nothing to change that for better or worse.

Bob
Stockmom 08 Nov, 2007
The .csv file would remain on the server. We would just be grabbing it (via FTP) and entering it into our independent system.

Can Chrono write the form data to a .csv file or do I need another extension. If so, do you happen to know what would best fit my needs?

Thank you so much...
GreyHead 08 Nov, 2007
Hi Stockmom,

Max may well have a suggestion for a code hack that will do this for you.

I have a workaround to offer. If you set the file to save the data to a MySQL table that you can probably use the free MySQL Query Browser to connect to the database, query it and output the results to a CSV file.

I say 'probably' because while this works well for me I have to set up my ISP to allow me to connect from my current IP address.

Bob

PS That said I guess that you could do the same with PHPMyAdmin, I just prefer Query Browser because it is a lot more friendly.
Max_admin 08 Nov, 2007
Hi Stockmom,

We will add this feature in the future but can't set a timeline because there is some other changes leading it in the list!🙂

Cheers

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.