473,789 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Importing Existing Users into New ASP.NET Membership Table

I am setting up a new web application with ASP.NET 2.0 and I was
wanting to utilize the 2.0 Membership and Profiles system. However, I
am having a lot of trouble importing a table of user info into the
aspnet_Users table due to the unique identifiers and large number of
dependencies this new system has.

Is there any way to easily import exisiting user data into the 2.0
Membership system without having to do data entry for 200+ users?

Also, is anyone using this system? I can't find much feedback on the
messageboards like the other technologies that I utilize.

Jan 21 '06 #1
2 2513
I haven't seen any "importers" yet, although I am sure that with all the
interest and the dozens of articles both by MS and developers promoting the
scheme, somebody will surely write one. It's basically just observing SQL
constraints while importing data into SQL tables.

As far as anyone using it, yes lots of people are. In fact, I wrote a SQLite
Membership/Roles provider class to use the SQLite database engine instead of
MSAccess or SQL Server. Somebody else wrote one for MySql.

Of course, nothing is stopping you from using your own database arrangement
and performing Forms Authentication / roles against it instead of the
provided infrastructure.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dawg1998" wrote:
I am setting up a new web application with ASP.NET 2.0 and I was
wanting to utilize the 2.0 Membership and Profiles system. However, I
am having a lot of trouble importing a table of user info into the
aspnet_Users table due to the unique identifiers and large number of
dependencies this new system has.

Is there any way to easily import exisiting user data into the 2.0
Membership system without having to do data entry for 200+ users?

Also, is anyone using this system? I can't find much feedback on the
messageboards like the other technologies that I utilize.

Jan 21 '06 #2
On 21 Jan 2006 13:46:28 -0800, "dawg1998" <wr*******@gmai l.com> wrote:

Also, is anyone using this system? I can't find much feedback on the
messageboard s like the other technologies that I utilize.


It's a great time-saver.

I also dumped the userid as a foreign key in other tables, and it made
the whole thing easier to code.
Jan 24 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2804
by: D Mat | last post by:
Hi, I'm trying to get MS Access 2000 to automatically import a series of (~200) flat text, tab delimited, data files into a single Access table, with consistent fields and rows. The files have different, but somewhat logical naming structures (ex.Jun01.txt, Jun02.txt, Jul01.txt, etc...). Is there a relatively simple way to accomplish this, considering i'm new to Access. I was especially hoping to do this without having to manually...
2
3929
by: kuhni | last post by:
Hi everybody, I am totally desperate because I cannot solve a really simple problem: I have a specific text-file which I want to import into an existing database. The problem is that the columns have different names so I receive an error message when importing via the "Get External Data"-Wizard. The second problem is that this text file includes several rows without any relevant data, only symbols like "-----" in the various columns. I...
5
3184
by: dixie | last post by:
If I sent a user an empty database container - dB with no tables and I needed them to import their tables into it and one of their tables was a hidden table with the prefix Usys, is there any way in code I can get that table imported without them having to go to options and show hidden tables and then import it manually? dixie
0
1004
by: hikkk | last post by:
I have an application named "wr",and the local destination is "wwwroot\wr",my default website is "wwwroot". when i create an new user "kkk",i found that,in table aspnet_Application,the applicationName is "\" but not "wr",and when i logged on and inserted some data into my table"TbMain",and i found that in aspnet_Users a new user is added automatically with the same userName of "kkk",the same Password, but a different userID and...
2
3185
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to set this up so as to do it reliably and minimize overhead? There are currently no constraints on the destination table. Assume the user or some configuration specifies the database name, server name, and filename+fullpath. The server is SQL...
1
3113
by: puremetal33 | last post by:
I have worked very little with Access and have hit a snag. My task right now is to import the data from a spreadsheet into an existing table in an Access database. I edited the .xls file so that fields are laid out the same L-R and made certain that the data is the same in both the .xls file and the table it is to be imported to have the same data type in each field. I follow the File>Get External Data>Import path and choose the .xls...
4
3347
by: JJ | last post by:
How can I import my current asp.net membership records in my local sql server to the empty tables on the live server? I've tried removing contraints with: ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT...
2
2562
by: lrheeza | last post by:
Hello everyone, I am a newbie at MS Access and I need help!!! I am importing an excel file using Import functionality in MS Access, all the fields are required but there are instances in the excel sheet wherein some of the fields are not populated. The fields that are being imported are: Full Name, first name, last name, initial (optional), userID and email address. How do i inform the users that the following records were not imported...
0
9666
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10410
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10200
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10139
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9984
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7529
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6769
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3701
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2909
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.