Announcement

Collapse
No announcement yet.

Need Help with Impex Text Import Please

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need Help with Impex Text Import Please

    I am attempting to import a list of users from a csv file into vBulletin 4.2.2 and am having a hard time figuring out how to make this work. Judging from reading through some of the php files provided with the Impex Text File importer it looks as though the format for the file should be something like username, id, email, password. I created a file named users.txt and placed it in c:\ on the Windows 2012 Server that I have vBulletin installed on. For now I have only added two lines to the file, they look something like (I tried it both with and without the quotes)...

    "Ender Wiggens", "ender_wiggens", "[email protected]", "somepassword"

    I have Impex installed with only the Text file importer. When I start the importer I am asked to select a version and product to export to, I chose vBulletin 4.0.*-4.1.* (there is no option for 4.2 listed). I then clicked Begin Import, then I clicked the Start Module button next to Check and update database. It asks me for the file name, I enter c:\users..txt and click Check database. At this point I see the following text...

    moderator - importmoderatorid OK
    usergroup - importusergroupid OK
    ranks - importrankid OK
    poll - importpollid OK
    forum - importforumid OK
    forum - importcategoryid OK
    user - importuserid OK
    style - importstyleid OK
    thread - importthreadid OK
    post - importthreadid OK
    thread - importforumid OK
    smilie - importsmilieid OK
    pmtext - importpmid OK
    avatar - importavatarid OK
    customavatar - importcustomavatarid OK
    customprofilepic - importcustomprofilepicid OK
    post - importpostid OK
    attachment - importattachmentid OK
    pm - importpmid OK
    usernote - importusernoteid OK
    phrase - importphraseid OK
    subscription - importsubscriptionid OK
    subscriptionlog - importsubscriptionlogid OK
    filedata - importfiledataid OK

    Followed by this error...


    ImpEx Database error

    mysql error: Invalid SQL:
    INSERT INTO usergroup
    (
    importusergroupid, title, description,
    usertitle, passwordexpires, passwordhistory,
    pmquota, pmsendmax,
    opentag, closetag, canoverride,
    ispublicgroup, forumpermissions, pmpermissions,
    calendarpermissions, wolpermissions, adminpermissions,
    genericpermissions, genericoptions, attachlimit,
    avatarmaxwidth, avatarmaxheight, avatarmaxsize,
    profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
    signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
    sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
    sigmaxrawchars, sigmaxlines
    )
    VALUES
    (
    '69',
    'Imported Users',
    'Usergroup description',
    '',
    0,
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    ''
    )


    mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1

    mysql error number: 1366

    Date: Thursday 06th 2014f March 2014 02:16:47 PM
    Database: our_vbulletin_db
    MySQL error: Incorrect integer value: '' for column 'passwordhistory' at row 1


    Can anyone tell me what I might be doing wrong?

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