spade Posted March 17, 2003 Share Posted March 17, 2003 Is there a tool that will help me import my customers from an excisting database (MySQL, CSV, whatever)? One thing I would like to do is import the excisting customer passwords (used for .htpasswd). Is that possible? Also I might want to add another phone number and a department number. Are there any side-effects/issues that I have to be aware off? Link to comment Share on other sites More sharing options...
kiernanb Posted March 17, 2003 Share Posted March 17, 2003 I don't know of a specific contribution as I am new to OSC. However, I imported textfiles containing ~800 products using phpMyAdmin. Here is on suggested method if you are building from the beginning: 1. Delete all customers in OSC Admin. 2. In phpMyAdmin, examine any customer related tables. Note which ones contain no records (the Browse tab will be black, not blue). 3. Create 1 customer in OSC. 4. Examine the tables in phpMyAdmin to see which ones now contain data. 5. Import the appropriate fields into the required tables. It's simpler than it sounds, though a bit tedious. Fact: You'll never get out of here alive. Link to comment Share on other sites More sharing options...
spade Posted March 17, 2003 Author Share Posted March 17, 2003 Thanks, I am that far, but it seems to be a bit tedious. I can always do it by hand, but I have to manually sync customer and address table and I can't see yet if there are any other dependencies. I also had asked about importing the password from my .htaccess file, which I can't just do with PHPMyAdmin I think. It seems the same password is much longer in OSC then it is in .htaccess. I was hoping to find a mod like EasyPopulate but for customers and addresses. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.