Tab delimited file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tonyfugere
    New Member
    • Feb 2005
    • 14

    Tab delimited file

    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
    Former Customer Support Manager
    • Jul 2000
    • 154488

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

    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • tonyfugere
      New Member
      • Feb 2005
      • 14

      #3
      Flat File Impex

      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?

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        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.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • tonyfugere
          New Member
          • Feb 2005
          • 14

          #5
          Which one

          The installed importers;

          1 . Infopop eve 4.0x
          2 . Invision Power Board 1.3
          3 . DCForum+ MySQL
          4 . e107 0.617
          5 . Invision Board 2 2
          6 . DigiPost 2.0
          7 . FuseTalk 0.0
          8 . Ikonboard (MySQL) 3.x
          9 . megaBBS 1.69
          10 . EncoreII 2
          11 . CuteCast 2.x
          12 . Geeklog 1.3.10
          13 . bbBoard 2
          14 . ASPPlayground 2.4.3
          15 . Max Web Portal 0
          16 . Jive Forums 4.0.0
          17 . Deluxe Portal 2.0
          18 . DiscusWare (file based) 4.00.6

          Do I choose DiscusWare?

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            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.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • tonyfugere
              New Member
              • Feb 2005
              • 14

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

              Comment

              • tonyfugere
                New Member
                • Feb 2005
                • 14

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

                Comment

                • tonyfugere
                  New Member
                  • Feb 2005
                  • 14

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

                  Comment

                  • tonyfugere
                    New Member
                    • Feb 2005
                    • 14

                    #10
                    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?

                    Comment

                    • tonyfugere
                      New Member
                      • Feb 2005
                      • 14

                      #11
                      Impex Flat File Import

                      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?

                      Comment

                      • tonyfugere
                        New Member
                        • Feb 2005
                        • 14

                        #12
                        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?

                        Comment

                        • Jerry
                          Senior Member
                          • Dec 2002
                          • 9137
                          • 1.1.x

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

                          Blog | Me

                          Comment

                          • tonyfugere
                            New Member
                            • Feb 2005
                            • 14

                            #14
                            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

                            Comment

                            • Jerry
                              Senior Member
                              • Dec 2002
                              • 9137
                              • 1.1.x

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

                              The importer uses file() function , so every line is grabbed with a new line.

                              You may not have 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.
                              I wrote ImpEx.

                              Blog | Me

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              😀
                              😂
                              🥰
                              😘
                              🤢
                              😎
                              😞
                              😡
                              👍
                              👎