Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (JAISP), 46 guests, and 231 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 125
Joined: June 2011
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
isaac 14
TheBrit 10
SteveS 8
Zarzal 6
Morgan 5
Ruben 4
jorb 4
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
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
V
volfreak  Offline OP
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
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,014
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
V
volfreak  Offline OP
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.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
update multilanguage site problem
by Zarzal. 12/15/18 04:20 PM
Char coding utf-8 and older forums
by Zarzal. 12/15/18 03:59 PM
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
Forum Statistics
Forums36
Topics35,180
Posts191,677
Members12,122
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2