Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2009
    Posts
    34
    Plugin Contributions
    0

    Have a Drink Create a form to write to CSV?

    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!

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,266
    Plugin Contributions
    3

    Default Re: Create a form to write to CSV?

    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

  3. #3
    Join Date
    Jul 2009
    Posts
    34
    Plugin Contributions
    0

    Default Re: Create a form to write to CSV?

    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.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Create a form to write to CSV?

    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.

  5. #5
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,266
    Plugin Contributions
    3

    Default Re: Create a form to write to CSV?

    Quote Originally Posted by jupitergardens View Post
    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.
    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

  6. #6
    Join Date
    Jul 2009
    Posts
    34
    Plugin Contributions
    0

    Default Re: Create a form to write to CSV?

    Quote Originally Posted by DrByte View Post
    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.
    That's what I was wondering. I suppose, since I'm not expecting a lot of responses, I could just tweak the contact_us form and just have them emailed to me, too.

    Thanks!

  7. #7
    Join Date
    Jul 2009
    Posts
    34
    Plugin Contributions
    0

    Default Re: Create a form to write to CSV?

    Quote Originally Posted by schoolboy View Post
    As my time is worth money, I tend to go for options that are cost-effective.
    Well, I'm not sure I'll need another form, and I may be moving platforms soon. It was more a "hey, is this possible?" sort of thing. :)

    Thanks!

  8. #8
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,266
    Plugin Contributions
    3

    Default Re: Create a form to write to CSV?

    Quote Originally Posted by jupitergardens View Post
    Well, I'm not sure I'll need another form, and I may be moving platforms soon. It was more a "hey, is this possible?" sort of thing. :)

    Thanks!
    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

 

 

Similar Threads

  1. custom form with csv export?
    By jupitergardens in forum General Questions
    Replies: 1
    Last Post: 20 Dec 2009, 11:36 AM
  2. Form Validator - Create Account Form
    By ftv in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 18 Feb 2009, 11:19 PM
  3. Using Access Database to create EP/CSV
    By dropbop in forum General Questions
    Replies: 0
    Last Post: 13 Sep 2008, 02:55 PM
  4. re-write of customers.php form problem
    By Goshawk in forum General Questions
    Replies: 0
    Last Post: 7 Feb 2008, 02:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg