I have to agree with Bob, on this one -- I'd write a python script that talks to the current db and populates the new db with the appropriate data..
I *almost* wonder if there'd be any advantage to using the inspectdb command from manage.py to setup some django models that represent the current sites data and THEN write your migration piece leveraging that code...just a thought. I did something similar on a project that involved a horribly designed Access DB. Converted the Access tables and dumped them into mysql, ran inspect db, and then wrote django views to read from that and populate the new db... (actually I add the old table to the same db so I didn't have to worry about connecting the two db's. then just deleted the old tables once everything migrated) Ryan On Tue, Sep 8, 2009 at 3:10 PM, Iain Mac Donald <[email protected]> wrote: > > On Tue, 08 Sep 2009 08:50:34 -0400 > Bob Waycott <[email protected]> wrote: > > > If it is in any format that is readable by Python (i.e., csv) you > > could write a script that imports it to the appropriate models. Else, > > you could write a script that imports it to your SQL backend. > > I am going to be facing this issue quite soon too. I am going to be > moving a site from another ecommerce system to Satchmo. The product mix > is quite complex with many product categories and different brands. I > too was considering importing lots of csv files into the relevant > tables. > > A cursory glance suggests populating all the brand* and product* tables > would be sufficient. Is that right? > > Are there any gotchas to look out for? > > Regards, > Iain. > > > > -- http://www.sudovi.com/ http://www.twitter.com/lifewithryan http://www.thecommontongue.com http://www.lifewithryan.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
