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
volfreak Offline OP
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

Express Hosting
Re: Import users from CSV/TXT file [Re: volfreak] #253280 07/29/2013 6:33 PM
Joined: Jun 2006
Posts: 15,834
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,834
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.
Need to Upgrade? [virtualnightclub.net]
Forums: A Gardeners Forum [agardenersforum.com] Scouters World [scoutersworld.com]
UBB.threads: UBBWiki [ubbwiki.com], UBB Styles [virtualnightclub.net], UBB.Sitemaps [virtualnightclub.net]
Longtime Supporter & Resident Post-A-Holic
VNC Web Services [virtualnightclub.net]: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Import users from CSV/TXT file [Re: volfreak] #253281 07/29/2013 9:09 PM
Joined: Jan 2009
Posts: 20
volfreak Offline OP
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.


Additional Community Resources
UBB Developers
UBB Wiki
ShoutChat Box
Recent Topics
Error Messages - What to do???
by Daryl Fawcett - 06/20/2019 9:05 AM
Forum - Left Alignment / Margin?
by keysolutns - 06/19/2019 9:58 AM
Forum Not Working after Cpanel upgrade.
by doug - 06/14/2019 2:35 PM
YouTube does not display?
by BlackMale - 06/09/2019 6:34 AM
Removing a redirect?
by Baldeagle - 06/01/2019 4:50 PM
Who's Online Now
1 registered members (isaac), 66 guests, and 165 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 670
Joined: June 2006
Show All Member Profiles 
Forum Statistics
Forums35
Topics35,303
Posts192,571
Members11,855
Most Online978
Jun 24th, 2007
Random Gallery Image
Latest Photos
Land Rocks
Cozy Places
Trees
Retreats
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190623)