I would love to create a form that will write directly to a CSV file (or a SQL database table that I can export to CSV). I didn't see any add-ons for that.
Is that something I can do within zen cart?
Thanks!
I would love to create a form that will write directly to a CSV file (or a SQL database table that I can export to CSV). I didn't see any add-ons for that.
Is that something I can do within zen cart?
Thanks!
There is an extremely easy, wysiwyg program to create, manage and store web forms, and I use it on many ZC sites.
See an EXAMPLE
The program used is nothing to do with ZC, and stores the form submissions in its own database, and it also has the CSV export facility you need.
Designing and creating even the most complex of forms takes just a few minutes, and they are "embedded" in your ZC (I do it on ezpages) with a simple Iframe. (You can also use php - the code is generated for you by the program)
Machform by Appnitro - a really great piece of software.
20 years a Zencart User
Thanks. I looked at Machform but was hoping for a free solution, or even a tutorial. There's a lovely program for joomla called Chronoforms that I like to use.
Or you could write your own. Search the forum for "band_signup" for an example of a totally custom form built within ZC. The processing sends an email, but you could just as easily write its output to a file, or just plain save it into a custom table in your database.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
I suppose it's a case of individual perspective, but this software is so cheap it's almost free. You would solve your problem in under 15 minutes.
Still, Dr Byte suggests another option, and while totally free, is likely to take you a few hours (or more).
As my time is worth money, I tend to go for options that are cost-effective.
20 years a Zencart User
Good point - and a valid one. The nice thing about machforms is that they are completely "platform-independent". If/when you change platforms, you just embed the simple link, and the same form will appear on your new site.
This has a few advantages, including the fact that if your form has already started collecting data (and storing it in its database) then changing your platform for other functions will not affect the machform data - it remains intact and accessible.
I don't intend to sound like a "salesman" for Appnitro - and indeed I make no endorsement of the product, nor do I have any commercial interest in that organisation.
Just that I have found it to be a really neat package that almost instantly solves all "challenges" I have faced with creating online forms that need to send email responses as well as collect the submission data, and generate Excel/csv exports.
20 years a Zencart User