Hi,
I need to import data into my new PE-Shop from different sources (OS-Commerce, Newsletter Listings and inventory management).
All data is available as mySQL database tables and I like to import it via SQL statements.
Newsletter:
each subscriber needs an entry in oxuser and the corresponding entry in oxnewssubscribed. What, if only the e-mail adress is available?
User (Customer):
I like to import users with name, first adress and e-mail; after the switch to the new system I want to tell my customers just to request a new password to login.
Which tables needs to be filled: oxuser, oxadress and oxnewssubscribed? Any other tables involved?
As I announced here, we will come up with an importer script for osCommerce. Although I don’t know it particularly, I am pretty sure that, with this script, everything will be imported that is applicable. Hope you can wait a bit?
the connection between tables is pretty easy. if you just look in your db u’ll see it in like seconds. (if u know how to use sql).
the object(user) has his own ID. this id is used in any other table to reference to this user.
a user importer shouldnt be that hard. if you can code urself its a work from like 30 mins to write the user importer and test it. i coded for me several importer/exporter and a own api to access oxid data through mysql. its not a big deal. just work.
