mike1081
-
Total Posts
:
8
-
Reward points
:
0
- Joined: Sep 19 '03
-
Status: offline
|
Importing Data
Mon. Oct 6, '03 7:55 PM
( permalink)
I want to import my current user database in to the forums, there is about 28000 usersnames with other data, e.g. passwords, email, address etc. whats the best way to do this? through enterprise manager? thanks Mike
|
|
|
|
medit
-
Total Posts
:
281
-
Reward points
:
1450
- Joined: Jun 25 '03
-
Status: offline
|
RE: Importing Data
Mon. Oct 6, '03 8:25 PM
( permalink)
i imported over 800 accounts through the "fast member import" feature of the forum. i didn't have enterprise manager running on my dev machine, so that's why i used the forum. i had to modify the code and stored procedures, though, to import passwords, emails, and two extra custom fields.
|
|
|
|
Samuel
-
Total Posts
:
11850
-
Reward points
:
180550
- Joined: May 23 '01
-
Status: offline
|
RE: Importing Data
Mon. Oct 6, '03 10:33 PM
( permalink)
I think the best way is still fast member import. It is a lot easier than coding your own routine. Just output your members in a comma delimited file (refer to the admin help file for more info) and break the file up into 6-7 batches (request.form cannot handle more than 128KB of data at once). The whole importing process should take less than 5 min.
ASPPlayground.NET ~ see our Version 4 plans here
|
|
|
|
mike1081
-
Total Posts
:
8
-
Reward points
:
0
- Joined: Sep 19 '03
-
Status: offline
|
RE: Importing Data
Tue. Oct 7, '03 1:04 AM
( permalink)
what about my custom fields? how do i import them? it looks like fast member import will only take : Name|E-mail|Password
|
|
|
|
FreddyD
-
Total Posts
:
835
-
Reward points
:
41220
- Joined: Mar 02 '02
- Location: Louis Lake
-
Status: offline
|
RE: Importing Data
Tue. Oct 7, '03 3:45 AM
( permalink)
Did you set up the custom fields with the admin control panel? are you trying to migrate the forum database to another server (DTS)? It is unclear to me what you are trying to achieve..  But you are right, the fast member import feature only imports required fields for this forum, which makes sense because these are the only crucial things for the forum to function.
|
|
|
|