Tab delimited file

[tonyfugere]

I have a tab-delimited file with the username, email, and homepage

What is the easiest way to import all 900+ of these users into new users in vB3?

[Steve Machol]

Use the 'Text File Importer' (aka Flat File User) in the Impex system.

http://www.vbulletin.com/forum/showthread.php?t=102412

[tonyfugere]

Well, I had no trouble getting Impex installed, but I cannot figure out how to import a tab-delimited file of user information. Is the Flat File Importer you speak of an add-on to Impex?

[Steve Machol]

What trouble exactly? It's a matter of uploading the files and editing the Impexconfig.php file. The Flat File importer is a part of Impex, yes.

[tonyfugere]

The installed importers;

1 . Infopop eve (http://www.infopop.com/eve_platform/index.php) 4.0x
2 . Invision Power Board (http://www.invisionboard.com/) 1.3
3 . DCForum+ MySQL (http://www.dcscripts.com/)
4 . e107 (http://www.e107.org/) 0.617
5 . Invision Board 2 (http://www.invisionboard.com/) 2
6 . DigiPost (http://www.digiposts.com/) 2.0
7 . FuseTalk (http://www.fusetalk.com/) 0.0
8 . Ikonboard (MySQL) (http://www.ikonboard.com/) 3.x
9 . megaBBS (http://www.megabbs.com/) 1.69
10 . EncoreII (http://www.aborior.com/encore/) 2
11 . CuteCast (http://www.artscore.net/) 2.x
12 . Geeklog (http://www.geeklog.net/) 1.3.10
13 . bbBoard (http://www.bbboard.com/) 2
14 . ASPPlayground (http://www.aspplayground.net/) 2.4.3
15 . Max Web Portal (http://www.maxwebportal.com/) 0
16 . Jive Forums (http://www.jivesoftware.com/products/forums/) 4.0.0
17 . Deluxe Portal (http://www.deluxeportal.com/) 2.0
18 . DiscusWare (file based) (http://www.discusware.com/) 4.00.6

Do I choose DiscusWare?

[Steve Machol]

You did not install the latest version of Impex. The latest version has over 40 Impex scripts, including 'Text file importer' which I mentioned above.

[tonyfugere]

I grabbed Impex from the members page.... did I miss something there?

[tonyfugere]

http://www.vbulletin.com/members/import.php to be exact

[tonyfugere]

AH-HA! The upload failed when I thought it did not.............. I'll try again in a minute

[tonyfugere]

So here's what I have. A file like so:

*id*,*user*,*email*,*pass*
....

I have also tried this same procedure and same results with a |$| delimiter.

I choose the txt_file importer and do it. I choose field 1 to be the id, 2 to be the username, 3 to be the email, and 4 to be the password

I end up with the users in a usergroup called imported. I move them all to the registered group. Their data appears correct. I try to login as one of these new users and it fails. I check the hash in the table with the salt and it does not hash the same when I run a command line php of: <? echo md5(md5("*pass*") . "*salt*") ?>. I change the password manually and it works properly.

Is there a bug in the importer? Has anyone else had this trouble?

[tonyfugere]

So here's what I have. A file like so:

*id*,*user*,*email*,*pass*
....

I have also tried this same procedure and same results with a |$| delimiter.

I choose the txt_file importer and do it. I choose field 1 to be the id, 2 to be the username, 3 to be the email, and 4 to be the password

I end up with the users in a usergroup called imported. I move them all to the registered group. Their data appears correct. I try to login as one of these new users and it fails. I check the hash in the table with the salt and it does not hash the same when I run a command line php of: <? echo md5(md5("*pass*") . "*salt*") ?>. I change the password manually and it works properly.

Is there a bug in the importer? Has anyone else had this trouble?

[tonyfugere]

Outside of this problem, if I have only one user in the flat file, then it is successful. Is there a proper newline character that the importer looks for?

[Jerry]

That would depend on if the password is a md5() hash to start with or not and if you are telling impex that.

[tonyfugere]

The passwords are cleartext and I'm telling Impex that they are NOT md5 hashes. See my more recent post and response here: http://www.vbulletin.com/forum/showthread.php?t=129450

[Jerry]

Can you please keep one issue to one thread, I've merged them to make it readable.

The importer uses file() (http://ca.php.net/manual/en/function.file.php) function , so every line is grabbed with a new line.

You may not have auto-detect-line-endings (http://ca.php.net/manual/en/ref.filesystem.php#ini.auto-detect-line-endings) enabled.

The only other thing I can think is that the new line is being added to the end of the password field.

I have updated the importer by trimming all the fields now, so that if that is the case it will remove it.

Download impex again and reupload the importer.

[tonyfugere]

Sorry about that. I was afraid that no one would see my new post to the old thread. That was the problem. The new importer works perfectly!