NukeCoder

Joined: May 05, 2005 Posts: 21 Location: Midwest City, Ok

My squad is dropping their old website and forums. It is now redirected to my site. I need to insert all of the nuke_users from the old to my db. I have the list in an exported to csv file.

Is there a utility or script available to make this task a little bit easier?

Thanks,
Tom

Site Admin Joined: Oct 25, 2004 Posts: 921

Well if you still have a chance, get a .sql dump and just use phpmyadmin to import it to the new site(assuming the 2 sites are using the same version of nuke). If not, I think phpmyadmin handles CSV files. But before you do anything, backup any info on the new site thats important.

Joined: May 05, 2005 Posts: 21 Location: Midwest City, Ok

Boy, you weren't kidding. I did a couple backups then tested the import. Turns out, the table order must be exact and the data types (such as dates) must match.

At any rate, after much editing of the csv file in MSACCESS, I was able to put the file in the proper structure and export to a new csv. The exort was from pnbb2 and importing to phpbb, so you can see I had to do a lot of manipulation. Some data such as user_regdate isn't in the same format. A lot of fields didn't even exist.