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:2368


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: No Access for me too by ristori
it is ok now. Thanks for this action.
skin/container error load by islandman
Has anyone else run across this error when loading skins or containers from site settings?I am using...
Email Set UP per Portal by islandman
How do I set up a unique email address per domain name off 1 hosting environment. for example...m...
RE: localhost Install issues by cdees
Lee: I wanted to follow up on this for anyone following this thread. I have been unable to solve t...
RE: Add New Profile Properties by WSI
HI Joe, The DNN version is 4.5.5. Thanks, Cliff
Change Skin on URL by vinita
Hi,Can the skin be changed based on the url used to access a portal. Multiple portal aliases may be ...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
Best DNN portal ever! by derpir
I have been a subscriber since august 2008, and DNNCreative.com is simply the best DNN Portal, their...
RE: skinning trouble by derpir
Hello Yes could you be so kind and take a look att the htm-file and css-file.I would be very gratef...
Search function is not working by kishorpawar
I am using Seach module in my project but not working, i have set   host setting alsoHost --> Schedu...
RE: backend is changing from sql2005 to sql2008 by leesykes
hello,There should not be any code changes needed, but you'll need to make sure that SQL 2008 upgrad...
RE: skinning trouble by leesykes
Hello,I would need to see your code to help you with this one, you can zip up your files and attach ...
RE: Installing DotNetNuke 4.9.00 on VWD 2005 w/ SQL server 2008 by leesykes
I have run a test with SQL Server 2008 express and DotNetNuke installed in exactly the the same way ...
RE: Issue 39 Interview by leesykes
thanks Bill, glad it was useful, we will have a think about the best way to approach this,Thanks,
RE: Issue 39 Authentication by leesykes
yes I have a live site in 4.9.0 at it seems stable as well.
backend is changing from sql2005 to sql2008 by meenu
hi all advance thanks. in my DNN0408 website am using sql2005 as backend.now planning to remove sq...
About catalook error by kishorpawar
 I am  using dnn 4.8.4 version in my project, this  site is in 2 language,whenver i click on the BYN...
RE: Menu Keeps Verticaly by ruimacdonald
Tnx for your help. It's done. Rui
RE: Menu Keeps Verticaly by jncraig
The configuration of the MENU skin object is defined in the skin.xml file. You'll need to modify th...
AppTheory
RSS Feeds