PDA

View Full Version : importing users only



AussieWeb
Thu 13th Dec '07, 11:16pm
I started reading through the Impex 'readme' and 'Howto' but I'm not sure if it's going to help or perhaps it's a full body plaster cast solution for a band-aid level problem....

I'm importing from an unsupported forum (an in-house forum from a forum site we're helping out)

The old forum uses access and the only reliable way to export the user info is as a CSV.

My thought was to:
1. Backup the new vb user table

2. Export a copy of the user table from the new vb install as a CSV

3. Make sure that the CSV from the old forum had the correct fields (if not add dummy info so the entries do match)

4. Import the combined CSV through phpmyadmin overrighting the old table


If any more clever minds (not that hard) can spot a flaw in my logic please throw it at me :)

Floris
Thu 13th Dec '07, 11:40pm
Using impex you can import a .cvs file.

AussieWeb
Fri 14th Dec '07, 12:51am
Thanks Floris,
Impex seems to depend on the source of the incoming data being one of the listed forums.

I've done a search for CSV in the howto files and manual, but can't find the reference in order to only import the users (no posts, etc.)

Any help welcome :)

Jerry
Fri 14th Dec '07, 2:01pm
Create a file with username, email, userid, password.

The password can be plain text or a MD5 hash.

The only mandatory filed is the email, though username as well is ideal .

AussieWeb
Tue 18th Dec '07, 5:55am
Thanks Jerry, but I'm unsure of how to use Impex as the drop-down lists specific forum types rather than an individual source.

I'm thinking phpMyAdmin might have to be the solution

peterska2
Tue 18th Dec '07, 7:15am
The text/CSV importer is the one called Text File. You can delete all folders from the impex/systems directory apart from txt_file which is the one that you need for your import.