Buy Now
Sign in

Data sent to Access file instead of email?

Stockmom , November 06 2007, 20:16
S
Stockmom 3
November 06 2007, 20:16 #3476
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 64
November 06 2007, 21:35 #3478
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
admin 27
November 06 2007, 23:59 #3479
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
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
S
Stockmom 3
November 07 2007, 07:43 #3484
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 64
November 07 2007, 16:00 #3487
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
S
Stockmom 3
November 08 2007, 01:35 #3497
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 64
November 08 2007, 01:55 #3499
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.
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
admin 27
November 08 2007, 21:21 #3519
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
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!