I've dug myself a hole and am stuck. I'm in the process of setting up a site that sells animations to which end I have set up a FileMaker Pro Database to keep track of all the products. I had hoped to use the DB to generate the XML file for subsequent import into UC but it's gotten more and more complex to the point where I'm now stuck - the basic product side of the DB isn't the problem, it's trying to set everything up so that it generates the correct XML that's proving to be a nightmare. So I'm wondering whether anyone has any suggestions for getting a large number of products into UC without having to generate each one manually.
Wed, 10/10/2007 - 01:48
I guess there is a plan for
I guess there is a plan for this:
"CSV importing, documentation of XML importing. Publicizing of same."
Re: I guess there is a plan for
There are various ways to do it and there are quite a few people working on CSV to XML/Ubercart. I have just (last night and this morning) manually added 150+ products to a site I'm working on and apart from it taking hours to do it's not so bad since I setup CCK fields and formatted my data slightly before I started. Just a lot of copy and pasting really.
I have an osCommerce database that I need to grab another 100 or so products from so may try and generate the XML for them. Then again, it's quite an effort to add the right formatting by hand so would need to build a help app in php. I made one that converts CSV to HTML tables but that's simple as it's basic 2D data.
Saying that, the data from the database I'm working with is pretty simple, I wouldn't even need the products to be imported into categories since I use the Taxonomy Multi Editor (highly recommended).
So all I have is title, description, image, price, model and meta description. This should be a fairly easy task but I don't care to generate the XML manually. Are the people who are using this using an XML editor that sorts all this out for you.
I've seen something about CCK imports from CSV and the (Drupal based) interface for this allows matching of column headers to CCK fields. Something like this would be ideal for Ubercart. Just an idea.
Re: Re: I guess there is a plan for
I've managed to create a standalone script that queries the database and generates the XML for importing. My problem now is that the importer is generating an error. Going to post a thread about it so it gets seen.
Re: Re: Re: I guess there is a plan for
Thanks for the feedback. I'm beginning to think that I may well have to go the manual route. My problem is that I have so many additional fields per product that it's certain to be a major pain in the arse (currently sitting at around 24 fields including the std. UC ones). Sigh. The FMP database was a big step in the right direction - if I should manage to finish it I may upload it here, see if it's of use to anyone else.
thanks again,
Ole
Re: Re: Re: Re: I guess there is a plan for
Hi Ole, I've managed to get it working for me: http://www.ubercart.org/comment/4419/Now-Ive-sorted-out-my