Maximo

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hello,

Thanks for your advice and help. I was able to follow the script. 

Any clue how to map the value person id to "maxuser.personid"? 

Thanks again.

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

I'm not sure what do you mean... Could you please elaborate a bit more what is it that is not working?
Basically when the script finds a PERSON record by e-mail, then it injects it into the integration pipeline and MAXUSER record gets created for given PERSON, therefore MAXUSER.PERSONID gets set to PERSON.PERSONID.

Hello,

Thanks for your advice and help. I was able to follow the script. 

Any clue how to map the value person id to "maxuser.personid"? 

Thanks again.

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hello,

Thank you for your patience. The concept of " it injects it into the integration pipeline and MAXUSER record gets created for given PERSON (the code line 

ctx.setMbo(mbo)

  is relatively new to me).  I was therefore confused. I will try the same and get back to you.

Regards

Pankaj Bhide

Hi Pankaj,

I'm not sure what do you mean... Could you please elaborate a bit more what is it that is not working?
Basically when the script finds a PERSON record by e-mail, then it injects it into the integration pipeline and MAXUSER record gets created for given PERSON, therefore MAXUSER.PERSONID gets set to PERSON.PERSONID.

Hello,

Thanks for your advice and help. I was able to follow the script. 

Any clue how to map the value person id to "maxuser.personid"? 

Thanks again.

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

I'm not sure what do you mean... Could you please elaborate a bit more what is it that is not working?
Basically when the script finds a PERSON record by e-mail, then it injects it into the integration pipeline and MAXUSER record gets created for given PERSON, therefore MAXUSER.PERSONID gets set to PERSON.PERSONID.

Hello,

Thanks for your advice and help. I was able to follow the script. 

Any clue how to map the value person id to "maxuser.personid"? 

Thanks again.

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

I'm not sure what do you mean... Could you please elaborate a bit more what is it that is not working?
Basically when the script finds a PERSON record by e-mail, then it injects it into the integration pipeline and MAXUSER record gets created for given PERSON, therefore MAXUSER.PERSONID gets set to PERSON.PERSONID.

Hello,

Thanks for your advice and help. I was able to follow the script. 

Any clue how to map the value person id to "maxuser.personid"? 

Thanks again.

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Andrzej,

thank you for this hint.
We tried it, but the problem seems to be, that we only can add it to manage and not to core. So it has no effect, becuase the table only exists in Core.

How do we add it to core? Do you have a manual?

Thanks in advance

Kind regards

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------

Hi Gunter,

I get the feeling that we're mixing up here different use cases. What I helped Pankaj with was the scenario where he creates user record in MAS Core which needs to be further quite specifically handled when synching MAS Core to MAS Manage.

Could you please describe your use case? Are you still somehow trying to add user to MAS Manage and hoping that it gets synched to MAS Core?

Hi Andrzej,

thank you for this hint.
We tried it, but the problem seems to be, that we only can add it to manage and not to core. So it has no effect, becuase the table only exists in Core.

How do we add it to core? Do you have a manual?

Thanks in advance

Kind regards

Hi Pankaj,

this sounds just like the process at one of my customers :-) 

There are probably other ways to do it but I would recommend creating Object Structure integration processing automation script for MASPERUSER object structure which may look as follows.

Script Name: OSIN.MASPERUSER

Script Source:

from psdi.mbo import SqlFormatdef mboRules(ctx):    table = ctx.getProcessTable()    if table == "PERSON":           data = ctx.getData()        # Mark the character casing - for parent/child navigation you need to use upper-case names        emails = data.getChildrenData("EMAIL")        # Find primary e-mail - example code below looks for a first found primary e-mail        # Mark the character casing - you need to use lower-case to access JSON attributes        primaryEmail = next((e.getCurrentData("emailaddress") for e in emails if e.getCurrentDataAsBoolean("isprimary")), None)        # Find PERSON record with given e-mail        mboSet = ctx.getMboSet()        sqf = SqlFormat(ctx.getUserInfo(), "exists(select 1 from email where email.personid = person.personid and email.emailaddress = :1)")        sqf.setObject(1, "EMAIL", "EMAILADDRESS", primaryEmail)        mboSet.setWhere(sqf.format())        mbo = mboSet.moveFirst()        if mbo:            # Inject identified person MBO into the integration processing pipeline.             # The rule is that if mboRules function returns MBO (through the ctx) then             # the integration logic does not look for one on its own using standard rules.            # The other way to do this would be to simply override "personid" column value            # in the inbound JSON structure data but passing back MBO you save one            # SQL query as the object to be processed has already been identified.            ctx.setMbo(mbo)        else:            # Raise exception            ctx.error("<msggrp>", "<msgkey>", [ "param1" ])    elif table in ["EMAIL", "PHONE"]:        # Skip updates to the EMAIL and PHONE tables        ctx.skipMbo()#end def

MASPERUSER object structure, used by MAS Core to Manage synchronization, uses PERSON record at the top level and you cannot really skip this one as you would not let the integration logic create corresponding child level MAXUSER record (PERSON/MAXUSER). If you do not want MAS Core to update person's details (display name, title, etc.) then you can do that by enabling Inbound Setting Restrictions for the attributes you're interested in. 

------------------------------
Andrzej Więcław
Maximo Technical Consultant
AFRY
Wrocław, Poland

Original Message:
Sent: Thu January 30, 2025 12:15 AM
From: Pankaj Bhide
Subject: MAS 9 to Manage user synchronization

Hello,

For the several years, we follow below mentioned conventions for users and persons in MAXIMO 7.6. There is absolutely no possibility for the business to change to the best practises in this connection.

Person id: A numeric number e.g. 999999

Email Id: JoneDoe@company.com

User Id: JoneDoe

SAMLID: JoneDoe

Our custom integration programs populate the details of PERSON, EMAIL and PHONE MBOs. This happens much earlier before the new employee is introduced in MAS 9. For example, a new employee with person id 555555, Email id: JamesBond@company.com is joined the organization. His details in PERSON, EMAIL and PHONE MBOs are synchronised in Manage.

Now, he is introduced to the Facilities dept and the system administrator adds his details in MAS 9 having details such as Useid: JamesBond,  Email id=JamesBond@company.com,  SAMLId= JamesBond

The cron task that syncs MAS 9 to Manage will create additional person and possibly the related MBOs (e.g. email, phone etc) records in manage which we don't want. 

To address this, I am trying to do the following:

Develop an automation script OSIN.MASPERUSER (integration script that intercepts the message for MAXUSER MBO) that does the following:

1. Get the value of the email address from the external record (ER).

2. Read the "EMAIL" mbo with the following condition:

             email.emailaddress=<email address from ER>

3. If the record does not exist then, raise the exception with the error message suggesting "email/person details do not exist in Manage for the user xxxxxx" and skip processing that row and go to the next row.

4. If the record exists in "EMAIL" mbo, then, get the value of "email.personid" into the variable "personid".

5. Map the value of "personid" to "maxuser.personid".

6. Lastly, skip processing the information in "person", "email" and "phone" MBOs by executing the method titled "skipMbo". This way, it will not insert/update the records into "email","person" and "phone" mbos.

if (ctx.getMosDetailInfo().getObjectName() == "EMAIL" or

        ctx.getMosDetailInfo().getObjectName() == "PERSON" or

        ctx.getMosDetailInfo().getObjectName() == "PHONE"):

        ctx.skipMbo() 

My challenge is how to access the ER record? What API call (any example?) will allow me getting email address from ER?

 Please help.

Thanks

------------------------------
Pankaj Bhide
------------------------------