Creating logins/passwords in iMIS in iMIS 15

Has anyone tried to create the passwords/keys used in iMIS 15 in mass? We're trying to avoid having a customer have to go into every record and create the login/password info.
Thanks,
Terry

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Eric, Thanks for the info. I

Eric,
Thanks for the info.
I have populated the Name_Security, Name_Security_Groups tables as we would in the past.

I then created the page you mention in your second link. I took out the demographic tables b/c they didn't apply. I modified the query to pull the Name_Security.web_login, Name_Security.password as the values in the call to the webservice.

The page runs - with no errors however when I do some troubleshooting I found that once it gets to the cfinvokeargument tab - it fails. It doesn't give me an error though. :(

Any thoughts, this is all we need to go live.
Thanks,
Terry

Terry Hammond
enSYNC Corporation
Fort Worth, TX
terry@ensync-corp.com

Can you look in both the

Can you look in both the Asi.Webroot.log file (in C:\Program Files\ASI\iMIS15\ on the application server) and the Application Windows event log and see if there's anything that looks relevant?

The Event Viewer displays an

The Event Viewer displays an error with the following information:

Event code: 4006
Event message: Membership credential verification failed.
Event time: 3/18/2008 2:49:32 PM
Event time (UTC): 3/18/2008 7:49:32 PM
Event ID: ec5744c2e97545a08743c3c501319e33
Event sequence: 256
Event occurrence: 9
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/Root/iMIS15_2-2-128503207498789258
Trust level: Full
Application Virtual Path: /iMIS15_2
Application Path: C:\Program Files\ASI_2\iMIS15\net\
Machine name: SWSQL

Process information:
Process ID: 4172
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Request information:
Request URL: http://38.96.209.143/IMIS15_2/AsiCommon/Services/Membership/MembershipWebservice.asmx
Request path: /IMIS15_2/AsiCommon/Services/Membership/MembershipWebservice.asmx
User host address: 65.205.109.107
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Name to authenticate: 10006

-------

Pretty much the same error in each viewer error. Still looking in to the iMIS log.

Terry Hammond
enSYNC Corporation
Fort Worth, TX
terry@ensync-corp.com

Terry, according to at least

Terry, according to at least one forum post I found (http://forums.asp.net/t/1035351.aspx), that error might be caused by not having the "applicationName" in your <membership< provider's configuration set to something other than "/". Can you check that in the web.config file?

I'm having the same problem

Eric,
I'm getting the same problem. My error is "MembershipWebService (ValidateUser) could not generate stub objects for web service invocation. 100009) (100009 is the record ID for the iMIS record that I'm trying to update)

It has an applicationName="iMIS", any ideas?

-------------------------------------

[membership defaultProvider="CustomizedProvider"]
[providers]
[add name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="DataSource.iMIS.Connection" applicationName="iMIS" requiresQuestionAndAnswer="false" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" /]
[/providers]
[/membership]

Progress, I think...

Originally I was attempting to use the membershipwebservice to RegisterWebUser in the production web site while my CM site was using a development db. After changing to update the dev db, it works fine. It seems like I should be able to update the production db with the same list of logins and passwords, shouldn't I?

This is a CF [cfinvoke] based on Mike Rileys post.

thanks!

We created an excel macro that uses RegisterWebUser web service

We are using an excel doc to cut and paste the following fields
iMISID, WebLogin, WebPassword - (these generally come from some legacy system or are set with new values)

iMISID = imisid
WebLogin = Email of record (macro uses this for both weblogin and the email address)

This macro has a row variable that ends at the end of the date...it limits the rows to 11181 -- so change this value if you have more or less records to import.

There's no data source in the macro. The data source is part of the web service. The macro just points at the web service.

~~~~~~~~~~~~~~~~~~~~~~ LoadUserNames MACRO

Sub LoadUserNames()

Dim ContactID As String
Dim userName As String
Dim Password As String
Dim email As String
Dim passwordQuestion As String
Dim passwordAnswer As String
Dim isApproved As Boolean
Dim ws As New clsws_MembershipWebService
Dim rtn As New struct_WebServiceProxyableM
Dim Row As Variant

Row = 2

While Row

Here is the rest

Range("A" + CStr(Row)).Select

On Error Resume Next

ContactID = Range("A" + CStr(Row)).Text
userName = Range("B" + CStr(Row)).Text
Password = Range("C" + CStr(Row)).Text
email = Range("B" + CStr(Row)).Text
passwordQuestion = "enter your question here?"
passwordAnswer = "enter your answer here"
isApproved = True

' call the web service here.
rtn = ws.wsm_RegisterWebUser(ContactID, userName, Password, email, passwordQuestion, passwordAnswer, isApproved)

Row = Row + 1

Wend

End Sub
~~~~~END OF MACRO ~~~~~~~~~~~~~~~~~~~~~~~