Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Jan 2003, 19:29
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
Thumbs up User List Import

Greetings all, and happy New Year!

I have been lurking here for a little while, and have found I am not alone in my problem: I would like to import an existing membership database for my organization (in text-delimited format) as a starting point for my forum. (Then I can e-mail all of my members on how to get started).

After trying a number of search strings, I found several posts where people asked about this, but they kind of disintegrated into thin air.

On another Web site I manage, we use Discus, where the administrator may or may not choose to use MySQL as a backend, but it has an import facility/utility that allows the admin to paste delimited text, which it parses into the database.

Any/all suggestions are most appreciated!

Last edited by jacobi; 03 Jan 2003 at 23:49.
Reply With Quote
  #2  
Old 03 Jan 2003, 20:52
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
well shouldn't be too hard to do

just a little script is required, which reads out from that file,and filles in the information into the user and userfield tables...

i'd say it would be a job of 5 perhaps 10 minutes for any hacker out here.
just the thing to manege the db at first a bit, to include all the fields can take a bit more (wether explaining or doing it self per admin rights)
Reply With Quote
  #3  
Old 07 Jan 2003, 12:00
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
Anybody out there?

I would like to go "live" with my forum soon, but one of the features I touted to our organization was the ability to browse a list of our members. If we have to wait for everyone to register, that feature won't be a reality for months, unfortunately.

I tried to upload a CSV tab delimited file in a MySQL management program, matching the relevant fields (including the appropriate group id number), and it showed up in my admin group list, but did not show up in the user list. The admin CP showed that number of members, but I could not manage the data. There seems to be something I'm missing.

Thanks again,
Adam
Reply With Quote
  #4  
Old 07 Jan 2003, 12:24
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
After trying a number of search strings, I found several posts where people asked about this, but they kind of disintegrated into thin air.
Actually why this does not exist is highly related to the fact that there can not be a "magical script" that can work for all.

The conversion script must be a custom one depending on the user details of the site applied for everyone. So for example your memberinfo might be including membername, email, location, age, while some other site owner's list has membername, profession, interests, birthday.

Therefore you can code a script that will work for your site but you can not easily turn it to a "full release vb hack" which will work for other users as well who are trying to achieve the same goal..
__________________
Logician's Blog | WebTemplates for vb 4.x : VB Integrated Content Management System
Reply With Quote
  #5  
Old 07 Jan 2003, 16:54
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
Originally posted by jacobi
I tried to upload a CSV tab delimited file in a MySQL management program, matching the relevant fields (including the appropriate group id number), and it showed up in my admin group list, but did not show up in the user list. The admin CP showed that number of members, but I could not manage the data. There seems to be something I'm missing.
Whenever you import a member into the user table, you have to create a row in the userfield table also
after you have created this row (just userid must be filled, the rest is irrelevant) the user can be edited from within your acp
Reply With Quote
  #6  
Old 07 Jan 2003, 18:15
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
First, Xenon - thanks for the tip. I bet that'll do the trick and I can't wait to try.

Regarding Logician's post...
The conversion script must be a custom one depending on the user details of the site applied for everyone. So for example your memberinfo might be including membername, email, location, age, while some other site owner's list has membername, profession, interests, birthday.
I realize this, which is why I customized my member info file to match with vBulletin's fields. I actually painstakingly reorganized the data columns to work with the import, which is why the MySQL database was populated correctly. If the MySQL import worked (and I was just missing what Xenon pointed out), I'm wondering if a be-all, end-all script couldn't prompt the user to match fields and then change the field names/descriptions later. Just a thought.
Reply With Quote
  #7  
Old 08 Jan 2003, 13:51
jacobi's Avatar
jacobi jacobi is offline
 
Join Date: Jan 2003
Real name: Adam Jacobi
It worked

Well, I imported to both the "user" and "userfield" tables, and it worked like a charm. In fact, I probably should have just done that in the first place because I did have the profile data for the userfield table; I was simply looking for instant gratification.
Reply With Quote
  #8  
Old 12 Jan 2003, 17:04
charlesm charlesm is offline
 
Join Date: May 2002
Custom User Import Required - Prepared to pay

Hi,

We a have a user list that we need to import for a client and would prefer to pay someone to write a script that works rather than bodge it ourselves...

Essentially we will have a CSV file that determines the user name, password, email addresses and a series of fields that relates to the their options (this may or not be necessary).

This will then need to be imported into the main database - initially when it is installed and then possibly every six months.

The board is being is installed within a secure extranet, so the only way that people can be added will be either via the admin section or via this install.

If you need anything else to price this, please let me know,
Reply With Quote
  #9  
Old 19 Apr 2003, 19:47
kaihawaii kaihawaii is offline
 
Join Date: Apr 2003
Question hack available

is there a generic hack fpr these issue, for importing such userfiles, e.g.:

"email"
"[email protected]"
"[email protected]"

or

"email","firstname","lastname"?

it should upd. all the needed tables for 2.6 and must be customizable before on the customfields.
__________________
kind regards / mit freundlichen grüssen
kai baumgartner
Reply With Quote
  #10  
Old 28 Jul 2003, 16:13
brobson168 brobson168 is offline
 
Join Date: Jul 2003
Hi, we are just setting up a chat room for DECUS - the UK Digital Pensioners association. We have very similar requirement - we wish to import from a CSV file our member details (we have over 500 member so typing them in is a major task).

Can anyone help?

Cheers

Brian Robson([email protected])
Reply With Quote
  #11  
Old 31 Jul 2003, 17:29
rikkuotaku rikkuotaku is offline
 
Join Date: Jul 2003
Hi,

I'd like to import users with text passwords into vBulletin along with a forum structure that's stored in an ascii text file.

With all the different scripts to import tons of different boards into vBulletin, someone must know how to import a simple text file with that info???

I have searched the board and found lots of threads about this subject, but no clear answers. Some say 'just import it'. Some say' md5() it and import it'. But none of this helps me with the specifics.

If someone would even give me sample sql code to import a user, and a sample sql code to import a category/forum/subforum structure, I could modify my text file to just have one sql command after another for each user and forum - no problem!!

I just need somewhere to start!

Thanks!!!
Reply With Quote
  #12  
Old 03 Dec 2003, 17:43
selzlerb's Avatar
selzlerb selzlerb is offline
 
Join Date: Jul 2003
Importing A UserList

Hello Team,

I have been looking for a solution to this problem as well. I'm assuming that users could be created from a userlist using basic information. Group, Username, Password, and other VB defaults. Then the user could log in and flesh out the profile themselves.

It seems like there are some with ideas as to how to do this. I took a look at the WebMin MySQL controls to see if there was a method there, but it doesn't look that way.

If anyone has some thoughts or a hint as to where to start I would really appreciate it.

Thanks.

- Sez
__________________
=========

The road goes on forever.....
Reply With Quote
  #13  
Old 08 Jan 2004, 03:09
selzlerb's Avatar
selzlerb selzlerb is offline
 
Join Date: Jul 2003
Thumbs up Congratulations!

Originally Posted by jacobi
Well, I imported to both the "user" and "userfield" tables, and it worked like a charm. In fact, I probably should have just done that in the first place because I did have the profile data for the userfield table; I was simply looking for instant gratification.
So, how did you do this? Can you post the script/method you used?

Thanks.

- Sez
__________________
=========

The road goes on forever.....
Reply With Quote
  #14  
Old 11 May 2004, 21:40
StewardManscat StewardManscat is offline
 
Join Date: May 2004
I imported my custom user table ok, but the number of members (stats) is not correct. Can anyone tell me how this gets updated, or can I just zap the number in the table (I see it buried in some gobbledegook in a settings table row of some sort...)

None of the repair/integrity functions updated the user count. Curious.

I just paid $500 CDN for this software. I have the insane 20 digit number after digging it out, but then lost the place in this system where I am suppoed to put it in. Argh.

Again: conversion of members appears to be completed normally, but no clue how to get the count updated.

Please and thank you.
Reply With Quote
  #15  
Old 11 May 2004, 22:26
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
you should update to vb3 and then run the repair user profiles function in the maintenance section.

it's not only, that the users are not counting on the memberslist, but you also cannot edit them in the acp as long as you don't do that.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Miscellaneous Hacks 404 / 301 after import redirect on import ids Jerry vBulletin 3.6 Add-ons 84 30 Jun 2014 16:27



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:43.

Layout Options | Width: Wide Color: