Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (mmkk), 74 guests, and 391 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 82
Joined: September 2008
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
M4TT 12
FREAK 11
Ruben 8
isaac 4
mmkk 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
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
Joined: Jan 2009
Posts: 20
V
volfreak Offline OP
stranger
volfreak  Offline OP
stranger
V
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
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
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.
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
Joined: Jan 2009
Posts: 20
V
volfreak Offline OP
stranger
volfreak  Offline OP
stranger
V
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
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)