how do i remove all users with imported in it?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lowandloudinc
    Member
    • Feb 2005
    • 61
    • 3.0.6

    how do i remove all users with imported in it?

    i have alot of imported_username members and i want to know how to mass delete all of them. anyone know how?
  • Jerry
    Senior Member
    • Dec 2002
    • 9137
    • 1.1.x

    #2
    ImpEx prepends the username with imported_ if the username already exists in the database, it all depends on if this was a clean import or a merge etc.
    I wrote ImpEx.

    Blog | Me

    Comment

    • lowandloudinc
      Member
      • Feb 2005
      • 61
      • 3.0.6

      #3
      it was a merge. now i have alot of users with imported_ in front of the usernames. how do i delete them?

      i think they are all doubles.

      Comment

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

        #4


        Did you merge during the user module ?
        I wrote ImpEx.

        Blog | Me

        Comment

        • lowandloudinc
          Member
          • Feb 2005
          • 61
          • 3.0.6

          #5
          i merged 2 forums both VB 3.6.7 pl1

          the target had 7500 members

          and the source had 11,000 members

          i followed all the modules by th ladder and all went fine except for some phrases.

          Comment

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

            #6
            There is an issue, that if they are valid users then deleting them will remove their posts as well, though if ImpEx didn't merge them on email address then they are different users though there was a clash on the username, i.e. it already existed.

            So it's either a case of merge the users, delete the user accounts, or delete the users and their posts ?
            I wrote ImpEx.

            Blog | Me

            Comment

            • lowandloudinc
              Member
              • Feb 2005
              • 61
              • 3.0.6

              #7
              well i checked 5 accounts and every imported user had the same name.

              so they are duplicates on the forum and i should either merge them or delete? the imported do have posts in some of the accounts.

              Comment

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

                #8
                Originally posted by lowandloudinc
                well i checked 5 accounts and every imported user had the same name.
                Though do they have different email address and have you set up your vBulletin to have unique usernames or allow duplicates ?

                Originally posted by lowandloudinc
                so they are duplicates on the forum and i should either merge them or delete? the imported do have posts in some of the accounts.
                Well if they have posts it depends on if they are the same user, or duplicate names or have the same email etc.
                I wrote ImpEx.

                Blog | Me

                Comment

                • lowandloudinc
                  Member
                  • Feb 2005
                  • 61
                  • 3.0.6

                  #9
                  Originally posted by Jerry
                  Though do they have different email address and have you set up your vBulletin to have unique usernames or allow duplicates ?



                  Well if they have posts it depends on if they are the same user, or duplicate names or have the same email etc.
                  some have different some have the same email. but the username always says in use when i try to delete the import part of it.

                  they are the same user for sure cause alot of these names are duplicates cause it was an affiliated forum.

                  Comment

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

                    #10
                    Originally posted by lowandloudinc
                    some have different some have the same email.
                    If they have the same email and are the same user, then you should merge on email during the user module that will remove a lot of the duplicates.

                    Originally posted by lowandloudinc
                    but the username always says in use when i try to delete the import part of it.
                    I don't understand what you mean. If you are trying to trim the imported_ off the name then of course it will be there, and twice now as if there is a user Jerry and Jerry is imported again then the 2nd one will be imported_Jerry.

                    Originally posted by lowandloudinc
                    they are the same user for sure cause alot of these names are duplicates cause it was an affiliated forum.
                    I'm having trouble following what your saying, though if they are the same then merge them during the user module.
                    I wrote ImpEx.

                    Blog | Me

                    Comment

                    • lowandloudinc
                      Member
                      • Feb 2005
                      • 61
                      • 3.0.6

                      #11
                      ok so i should run the user module one more time?

                      and some emails arent the same as their other account.

                      example:

                      vinny - email: [email protected]
                      imported_vinny - email: [email protected]


                      will it matter?

                      Comment

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

                        #12
                        If the emails are different, then they won't match, that is the one field they match on.

                        Though it will match the ones where they are, and where you have :

                        vinny - email: [email protected]
                        imported_vinny - email: [email protected]

                        and your sure they are the same person :

                        I wrote ImpEx.

                        Blog | Me

                        Comment

                        • lowandloudinc
                          Member
                          • Feb 2005
                          • 61
                          • 3.0.6

                          #13
                          Originally posted by Jerry
                          If the emails are different, then they won't match, that is the one field they match on.

                          Though it will match the ones where they are, and where you have :

                          vinny - email: [email protected]
                          imported_vinny - email: [email protected]

                          and your sure they are the same person :

                          http://www.vbulletin.com/docs/html/main/users_merge
                          yes they are the same and that merge user would take me forever since there are almost over 500 - 1000 users like this.

                          so back to my original question. since i know all the users have an account already. can i delete the ones with imported in em?

                          Comment

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

                            #14
                            Originally posted by lowandloudinc
                            yes they are the same and that merge user would take me forever since there are almost over 500 - 1000 users like this.
                            That is the nature of the import.

                            Originally posted by lowandloudinc
                            so back to my original question. since i know all the users have an account already. can i delete the ones with imported in em?
                            If you want the posts associated with those users to be deleted as well sure.
                            I wrote ImpEx.

                            Blog | Me

                            Comment

                            • lowandloudinc
                              Member
                              • Feb 2005
                              • 61
                              • 3.0.6

                              #15
                              Originally posted by Jerry
                              If you want the posts associated with those users to be deleted as well sure.
                              can i do that on a mass scale? or one by one?

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...