Personalised Email for Students (Options and Implementation)
  1. Home
  2. Projects
  3. Personalised Email for Students (Options and Implementation)
  4. Developer Testing

Developer Testing

 

 

 

 Activity

 

 

 Date

 

 

 Notes

 

Test 1 - Check Data Migration                  

                             16/10                                              

 

select * from idstore_identity where eduniidmsid='13593600-B56B-4A48-BCBA-7CC21EEC598A';

Miss Sheila Sheila Mitchell 701 10-JAN-12 13593600-B56B-4A48-BCBA-7CC21EEC598A A 8838385 Wsauat51 s8838385

select * from idstore_emailaddresses where eduniidmsid='13593600-B56B-4A48-BCBA-7CC21EEC598A';

19-SEP-17 13593600-B56B-4A48-BCBA-7CC21EEC598A UniAlias S.M.Mitchell-1@sms.ed.ac.uk 0 SMSDIR 19-SEP-17 13593600-B56B-4A48-BCBA-7CC21EEC598A UniAlias S.M.Mitchell@sms.ed.ac.uk 1217476020 SMSDIR 31-MAY-10 13593600-B56B-4A48-BCBA-7CC21EEC598A University s8838385@sms.ed.ac.uk EUCLID

                            
Test 2 - Generate Name Based Alias 16/10

(1). Find a student

select * from idstore_identity where eduniidmsid='4D033B4E-E70E-4A54-AB20-599A876473BC';

Dr Patrick Patrick Healey 627 12-FEB-10 4D033B4E-E70E-4A54-AB20-599A876473BC A 9013970 aautuc55 s9013970

select * from idstore_emailaddresses where eduniidmsid='4D033B4E-E70E-4A54-AB20-599A876473BC';

19-SEP-17 4D033B4E-E70E-4A54-AB20-599A876473BC UniAlias P.G.T.Healey@sms.ed.ac.uk 0 SMSDIR 31-MAY-10 4D033B4E-E70E-4A54-AB20-599A876473BC University s9013970@sms.ed.ac.uk EUCLID

(2). Delete all emails of this student

delete from idstore_emailaddresses where eduniidmsid='4D033B4E-E70E-4A54-AB20-599A876473BC';

(3). Simulate generate email

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN P_EDUNIIDMSID := '4D033B4E-E70E-4A54-AB20-599A876473BC'; P_MAILTYPE := 'University'; P_MAIL := 's9013970@sms.ed.ac.uk'; P_UID := 's9013970';

IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

Connecting to the database IDMStore. Process exited. Disconnecting from the database IDMStore.

(4). Check results

19-SEP-17 4D033B4E-E70E-4A54-AB20-599A876473BC University P.Healey@sms.ed.ac.uk IDM 19-SEP-17 4D033B4E-E70E-4A54-AB20-599A876473BC UniAlias s9013970@sms.ed.ac.uk EUCLID
Test 3 - Generate Name Based Alias with the Same Name 16/10

(1). Find a Test Account

select * from idstore_identity where eduniidmsid='F8E546BE444360ABE04400144F00F4CC';

Miss Can Can Cui 15-FEB-91 3846651086 08-MAY-14 F8E546BE444360ABE04400144F00F4CC A 1303137 cXW9bKmx s1303137

select * from idstore_emailaddresses where eduniidmsid='F8E546BE444360ABE04400144F00F4CC';    

18-SEP-17 F8E546BE444360ABE04400144F00F4CC UniAlias C.Cui-3@sms.ed.ac.uk 0 SMSDIR 18-SEP-17 F8E546BE444360ABE04400144F00F4CC University s1303137@sms.ed.ac.uk 0 EUCLID

(2). Prepare This Account

removes all emails for this identity

delete from idstore_emailaddresses where eduniidmsid='F8E546BE444360ABE04400144F00F4CC';

update its name to Test (2) name

update idstore_identity set givenname='Patrick', edupersonnickname='Patrick', sn='Healey' where eduniidmsid='F8E546BE444360ABE04400144F00F4CC';

(3). Simulate Eugex Insert Email

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN P_EDUNIIDMSID := 'F8E546BE444360ABE04400144F00F4CC'; P_MAILTYPE := 'University'; P_MAIL := 's1303137@sms.ed.ac.uk'; P_UID := 's1303137'; IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

(4). Check Results

19-SEP-17 F8E546BE444360ABE04400144F00F4CC University P.Healey-1@sms.ed.ac.uk IDM 19-SEP-17 F8E546BE444360ABE04400144F00F4CC UniAlias s1303137@sms.ed.ac.uk EUCLID

This is correct as P.Healey@sms.ed.ac.uk is already allocated in Test 2
Test 4 - VRS 1 16/10

student https://www-test.vrs.mis.ed.ac.uk/Identity/index.cfm?eduniIDMSID=4E73749E9B0411A9E053081DA8C023E3&fuseaction=identity

Email Addresses

Primary Email

There is no primary email information to display.

Additional University Email(s)

There is no additional university email information to display.

Private Email

Email Type:Home Email Address:some@gmail.com Last Modified:08-Sep-2017 17:13:29

 

select * from idstore_identity where idstoreuid='s1691828';

Ms Alice Mae Alice Terrett 24-JAN-94 4188224820 08-MAY-17 4E73749E9B0411A9E053081DA8C023E3 A 1691828 gyn2fhqM 1001009003921754 20150015413734s1691828

select * from idstore_emailaddresses where eduniidmsid='4E73749E9B0411A9E053081DA8C023E3';

08-SEP-17 4E73749E9B0411A9E053081DA8C023E3 Home some@gmail.com

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN

P_EDUNIIDMSID := '4E73749E9B0411A9E053081DA8C023E3'; P_MAILTYPE := 'University'; P_MAIL := 's1691828@sms.ed.ac.uk'; P_UID := 's1691828';

IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

https://www-test.vrs.mis.ed.ac.uk/Identity/index.cfm?eduniIDMSID=4E73749E9B0411A9E053081DA8C023E3&fuseaction=identity

Email Addresses

Primary Email

Email Type:University Email Address:A.M.Terrett@sms.ed.ac.uk Last Modified:19-Sep-2017 12:48:56

Additional University Email(s)

Email Type:UniAlias Email Address:s1691828@sms.ed.ac.uk Last Modified:19-Sep-2017 12:48:56 [Set As Primary]

Private Email

Email Type:Home Email Address:some@gmail.com Last Modified:08-Sep-2017 17:13:29

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

click [Set As Primary]

The primary email address for this Identity has been sucessfully updated.

Email Addresses

Primary Email

Email Type:University Email Address:s1691828@sms.ed.ac.uk Last Modified:19-Sep-2017 12:50:14

Additional University Email(s)

Email Type:UniAlias Email Address:A.M.Terrett@sms.ed.ac.uk Last Modified:19-Sep-2017 12:50:14 [Set As Primary] 

Private Email

Email Type:Home Email Address:some@gmail.com Last Modified:08-Sep-2017 17:13:29

 

  
Test 5 - VRS 2 16/10

applicant https://www-test.vrs.mis.ed.ac.uk/Identity/index.cfm?eduniIDMSID=0BFB49341BDD5795E0540003BAFB115D&fuseaction=identity

correct, this should be old layout
Test 6 - VRS 3 16/10

staff https://www-test.vrs.mis.ed.ac.uk/Identity/index.cfm?eduniIDMSID=56B74A5A-D314-4F34-83C0-4A304F2F1848&fuseaction=identity

correct, this should be old layout
Test 7 - Test effective date 1 16/10

delete from idstore_emailaddresses where eduniidmsid='F8E546BE444360ABE04400144F00F4CC';

delete from IDSTORE_EMAIL_CONFIG;

insert into IDSTORE_EMAIL_CONFIG(domain,dateeffective,datemodified) values ('sms.ed.ac.uk',sysdate + 20,sysdate);

 

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN P_EDUNIIDMSID := 'F8E546BE444360ABE04400144F00F4CC'; P_MAILTYPE := 'University'; P_MAIL := 's1303137@sms.ed.ac.uk'; P_UID := 's1303137'; IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

select * from idstore_emailaddresses where eduniidmsid='4E73749E9B0411A9E053081DA8C023E3';

19-SEP-17 F8E546BE444360ABE04400144F00F4CC University s1303137@sms.ed.ac.uk

correct, simulate effective date is in the future, so IDM should generate uun based email not name based.
Test 8 - Test effective date 2 16/10

set effective date earlier than identity;

delete from IDSTORE_EMAIL_CONFIG; insert into IDSTORE_EMAIL_CONFIG(domain,dateeffective,datemodified) values ('sms.ed.ac.uk',sysdate -311120,sysdate);

19-SEP-17 F8E546BE444360ABE04400144F00F4CC University P.Healey-1@sms.ed.ac.uk IDM 19-SEP-17 F8E546BE444360ABE04400144F00F4CC UniAlias s1303137@sms.ed.ac.uk EUCLID

correct, name based alias take effect
Test 9 - Test IDM Student Email Change XML Generated by Microservice 16/10

delete all email of this identity

delete from idstore_emailaddresses where eduniidmsid='D365F4AA-7E38-4456-BEBB-7F48DFCC6A67';

IDM Student Email Change XML (generated by microservice)

<email xmlns="http://schema.soa.is.ed.ac.uk/IDM/ext/processHandler"><uniqueIdentifier>0347553</uniqueIdentifier><uid>s0347553</uid><mail>H.Sun-2@sms.ed.ac.uk</mail><changeType>I</changeType></email>

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN P_EDUNIIDMSID := 'D365F4AA-7E38-4456-BEBB-7F48DFCC6A67'; P_MAILTYPE := NULL; P_MAIL := 'H.Sun-2@sms.ed.ac.uk'; P_UID := 's0347553';

IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

select * from idstore_emailaddresses where eduniidmsid='D365F4AA-7E38-4456-BEBB-7F48DFCC6A67';

20-SEP-17 D365F4AA-7E38-4456-BEBB-7F48DFCC6A67 University H.Sun-2@sms.ed.ac.uk IDM

correct, this should have University type and IDM source

 

Another change xml on the same identity with a different email, note, this kind of change xml from EDDIR never passes in mail type, no mail type will be treated as University mail type

<email xmlns="http://schema.soa.is.ed.ac.uk/IDM/ext/processHandler"><uniqueIdentifier>0347553</uniqueIdentifier><uid>s0347553</uid><mail>H.Sun-6@sms.ed.ac.uk</mail><changeType>I</changeType></email>

DECLARE P_EDUNIIDMSID VARCHAR2(36); P_MAILTYPE VARCHAR2(16); P_MAIL VARCHAR2(128); P_UID NVARCHAR2(64); BEGIN P_EDUNIIDMSID := 'D365F4AA-7E38-4456-BEBB-7F48DFCC6A67'; P_MAILTYPE := NULL; P_MAIL := 'H.Sun-3@sms.ed.ac.uk'; P_UID := 's0347553';

IDSTORE_EMAIL_PACKAGE.INSERT_IDSTORE_EMAIL( P_EDUNIIDMSID => P_EDUNIIDMSID, P_MAILTYPE => P_MAILTYPE, P_MAIL => P_MAIL, P_UID => P_UID ); --rollback;  END;

select * from idstore_emailaddresses where eduniidmsid='D365F4AA-7E38-4456-BEBB-7F48DFCC6A67';

20-SEP-17 D365F4AA-7E38-4456-BEBB-7F48DFCC6A67 UniAlias H.Sun-2@sms.ed.ac.uk IDM 20-SEP-17 D365F4AA-7E38-4456-BEBB-7F48DFCC6A67 University H.Sun-3@sms.ed.ac.uk IDM

Correct, insert new mail, its type should be University, whereas previous University mail will be come UniAlias
Test 10 - name change in EUCLID to re-generate name based alias 16/10

step 1. find a student, it has

select * from idstore_emailaddresses where eduniidmsid='48040FF5-E7C9-4FAC-BA4A-70EB84D72C15'; 18-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 UniAlias F.A.M.Forbes@sms.ed.ac.uk 0 SMSDIR 0 0  18-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 UniAlias F.Forbes@sms.ed.ac.uk 971256481 SMSDIR 0 0  31-MAY-10 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 University s0091153@sms.ed.ac.uk 0 EUCLID 1 0

step 2. find this person detail select * from idstore_identity where eduniidmsid='48040FF5-E7C9-4FAC-BA4A-70EB84D72C15';

Mr Farquhar Farquhar Forbes 138079 12-FEB-10 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 A 0091153 ad5Eaiec s0091153

step 3. update the surname

Forbes

update idstore_identity set sn='Ferbes' where eduniidmsid='48040FF5-E7C9-4FAC-BA4A-70EB84D72C15';

step 4. run update email address function to simulate a email change

P_EDUNIIDMSID := '48040FF5-E7C9-4FAC-BA4A-70EB84D72C15'; P_MAILTYPE := 'University'; P_MAIL := 's0091153@sms.ed.ac.uk'; P_UID := 's0091153';

Connecting to the database IDMStore. v_count - 0 F.Ferbes@sms.ed.ac.uk  insert - F.Ferbes@sms.ed.ac.uk Process exited. Disconnecting from the database IDMStore.

step 5. check again, F.Ferbes@sms.ed.ac.uk is University now select * from idstore_emailaddresses where eduniidmsid='48040FF5-E7C9-4FAC-BA4A-70EB84D72C15';

18-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 UniAlias F.A.M.Forbes@sms.ed.ac.uk 0 SMSDIR 0 0  29-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 University F.Ferbes@sms.ed.ac.uk 0 IDM 1 29-SEP-17 18-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 UniAlias F.Forbes@sms.ed.ac.uk 971256481 SMSDIR 0 0  29-SEP-17 48040FF5-E7C9-4FAC-BA4A-70EB84D72C15 UniAlias s0091153@sms.ed.ac.uk 1506699173 IDM 0 0 29-SEP-17

 

 

 

This article was published on

Project Info

Project
Personalised Email for Students (Options and Implementation)
Code
COM033
Programme
Digital Transformation - Integrated Identities (DTIP09)
Management Office
ISG PMO
Project Manager
Don MacIver
Project Sponsor
Alex Carter
Current Stage
Close
Status
Closed
Start Date
26-Oct-2016
Planning Date
n/a
Delivery Date
n/a
Close Date
09-Feb-2018
Programme Priority
3
Overall Priority
Normal
Category
Discretionary

Documentation

Execute