You need to Register for free and Login to post a message in the forum.

Forum

Subject: User Import from Excel
Prev Next
You are not authorized to post a reply.

Author Messages
sstoos
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:2

15 Oct 2008 1:48 PM  
I'm working on a website that the client has several 100 members that they want to add as users.  Is there a way to import the members into the users table in dnn database by using sql?  If so, will it mess up any other tables that might be joined to the users table when an user gets added the orignal way.  Please help.  I don't want to manually enter all of the users.

Thanks!
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2520


15 Oct 2008 1:58 PM  
I have used John Mitchell's script (http://blogs.snapsis.com/PermaLink,guid,c9d3082b-d7b1-4dfb-8c9c-67c0e864964d.aspx) a couple of times. It's easy to use, and easy to figure out how to modify it to fit your needs.

You biggest problem will be to get the data into an xml file correctly

Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > User Import from Excel



ActiveForums 3.7

Latest Forum Posts

RE: Can't Login! Login Page can't be accessed... by durationinc
Hi,I still redirected to the home page with this URL: localhost/DNN/Default.aspx/tabid=37&error=Obje...
RE: Can't Login! Login Page can't be accessed... by e-kreator
problem solved, thanks for the help
RE: Child portal to live site by psgrzelak
Ok the original site that I had a standard web site was jacksonnjgop.com I than created a child port...
RE: Child portal to live site by jncraig
Is there any URL that will get me to your site?
RE: Child portal to live site by jncraig
"Ok I changed the A record of the Jackson site to point to the IP address of the DNN portal. I than...
RE: Child portal to live site by jncraig
I'm sorry that I offended you.  I was trying to give an honest answer.  That answer is, I continue t...
RE: Child portal to live site by psgrzelak
Kind of a round about way of answering my question without answering it.... I prefer the straight fo...
RE: Child portal to live site by jncraig
A subscription to this site will let you view the tutorials.  I believe that will be useful.  In fac...
RE: Child portal to live site by psgrzelak
Ok I changed the A record of the Jackson site to point to the IP address of the DNN portal. I than w...
RE: DotNetNuke News 8th Dec 08 by jncraig
Yes, I'm getting an error, also. But ... you can probably get the podcast from this link: http...
RE: Can't Login! Login Page can't be accessed... by jncraig
This table is part of your DotNetNuke database.You might first want to review these tutorials to hel...
DotNetNuke News 8th Dec 08 by pwadding
When I attempt to download the  Podcast I get an error message. Tried both servers. The first few li...
RE: Can't Login! Login Page can't be accessed... by e-kreator
a database that you mean.
RE: DotNetNuke 4.9.1 and 5.0.0 by jncraig
Yes, lots of learning, lots of new things and new ways.  I played a little with Beta6 of DotNetNuke ...
RE: PDF File Content by jncraig
If you want to just serve up the PDF files as PDF files, upload them using the File Manager.  You ca...
RE: Navigating between modules by jncraig
What is the URL that is generated? To which page does it send you?
RE: New Logo cant display by jncraig
There is nothing wrong with this, provided that you did it correctly.  I would have to look at your ...
RE: Child portal to live site by jncraig
You should set DNS to point the URL to the IP address of the DotNetNuke installation.  Inside of the...
RE: PopUp Page by jncraig
To open a link in a new window, format the link this way:Link to us! It is the target="_blank" that...
RE: How to Change fckeditor alignment by jncraig
It might be easier to use a different skin for your administrative pages. There have been some ot...
DotNetNuke Modules
RSS Feeds