Site Links
Pricing & Order
Members Area
Support Options
Who's Online Now
2 registered members (JAISP, TheBrit), 56 guests, and 227 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Daryl Fawcett
Daryl Fawcett
Posts: 596
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 13
SteveS 8
Morgan 5
Ruben 4
jorb 4
Zarzal 2
Latest Photos
Testing to drag photos
Comfortable Cats
BSA photos
Previous Thread
Next Thread
Print Thread
Import users from CSV/TXT file #253279
07/29/13 05:08 PM
07/29/13 05:08 PM
volfreak  Offline OP
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!!

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Import users from CSV/TXT file [Re: volfreak] #253280
07/29/13 05:33 PM
07/29/13 05:33 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 17,013
Portland, OR; USA
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?
Forums: A Gardeners Forum 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 [Re: volfreak] #253281
07/29/13 08:09 PM
07/29/13 08:09 PM
volfreak  Offline OP
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.

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
table issue
by TheBrit. 12/13/18 06:05 PM
testing table layout
by TheBrit. 12/13/18 11:16 AM
header.php after update from 7.5.x to 7.6.x
by Zarzal. 12/12/18 05:29 AM
Does 7.6.2 support php 71?
by Baldeagle. 12/12/18 02:17 AM
Cannot contact support
by . 12/11/18 06:43 PM
Forum Statistics
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2