Datafeed into Database

yeahiknowiamyeahiknowiam Member
in Help edited June 2008
Ok. I am using FoxyCart on an online business card order form, and here is my goal...

Once a customer enters the information going on the card(s) and checks out, I want all that info to go into a database. Then I'll have InDesign access the database and use datamerge to import particular fields directly into my business card template; hence, avoiding having to typeset anything.

I got my datafeed producing an xml file w/ all the information from my checkout, and I got my database created. However, I have no clue how to get that information into my database. Keep in mind I've only been web designing for a few months now.
Comments
  • lukeluke FoxyCart Team
    There are a lot of options here... you can either process the XML directly as FoxyCart sends it to your server and then write SQL statements (probably using PHP) to insert records into your database. Check the datafeed integration page for more information:

    http://wiki.foxycart.com/integration?datasrt=&dataflt=tags:datafeed

    You could also drop the XML directly into a database to process it later: http://wiki.foxycart.com/integration?datasrt=&dataflt=system:MySQL

    As for processing the data and dealing with databases... you may want to bring a developer onboard for this or you'll have a lot more fun stuff to learn. :)

    Looking through some of the datafeed example pages for various integrations should give you an idea how to work with the XML and how to work with a database (assuming you're using PHP). Please let us know if you have any specific questions or things you're confused by.
  • brettbrett FoxyCart Team
    Assuming you're working with PHP and MySQL, tizag has great tutorials: http://www.tizag.com/mysqlTutorial/

    It's basically just parsing the XML with PHP (or something), then sticking it into a database. It's not difficult, but if you haven't done anything like that before you'll definitely want to go through those tutorials and set aside a block of time.
Sign In or Register to comment.