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.
"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.