Previous Thread
Next Thread
Print Thread
Hop To
Import users from CSV/TXT file
#253279 07/29/2013 6:08 PM
Joined: Jan 2009
Posts: 20
stranger
OP Offline
stranger
Joined: Jan 2009
Posts: 20
I've looked in these sections and have found only one post that even mentions this so am hoping that someone can help.

We are starting a new board - brand new, no posts to bring over or anything.

BUT we have about 18,000 users we need to get imported. Is there a way to do this with the app or can someone tell me the tables I need to make sure I populate with a custom SQL script/commands? Also, is there a way to call the encryption method for encrypting any fields that need to be encrypted?

Thanks much!!
Jay

Re: Import users from CSV/TXT file
volfreak #253280 07/29/2013 6:33 PM
Joined: Jun 2006
Posts: 15,938
Likes: 27
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,938
Likes: 27
The user tables are ubbt_USERS, ubbt_USER_DATA, ubbt_USER_GROUPS, ubbt_USER_NOTES, ubbt_USER_PROFILE. Of these the tables that must be populated for each user would be ubbt_USERS, ubbt_USER_DATA, ubbt_USER_GROUPS, ubbt_USER_PROFILE.

Well, it's just an MD5 hash, no salt, so no "encryption" necessary.

I'd recommend doing a dummy install and creating a couple of users so you can see the data each table is going to require.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import users from CSV/TXT file
volfreak #253281 07/29/2013 9:09 PM
Joined: Jan 2009
Posts: 20
stranger
OP Offline
stranger
Joined: Jan 2009
Posts: 20
Thanks, Gizmo!!

I've run a few SELECTs against those tables and so the data. Good suggestion on seeing what fields are needed. I've just done a new install so I should be able to query those tables and get the required records/fields. Thanks for that idea.


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
[NOTABUG] Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
Who's Online Now
2 members (Morgan, 1 invisible), 96 guests, and 39 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4