Topic
  • 8 replies
  • Latest Post - ‏2014-01-09T18:58:24Z by BKDowning
SystemAdmin
SystemAdmin
5842 Posts

Pinned topic Allow duplicate email addresses?

‏2011-04-29T15:40:07Z |
Hi All

Is it possible to have duplicate email addresses assigned to person records in Maximo 7? Our project requirement is that more than one person may share the same email address, and this needs to be stored in Maximo.

Currently you cannot add a duplicate email address through the person application, but it is possible to update the database via SQL into the EMAIL table - so the restriction is in the application somewhere

Has anyone done any customisation to allow a duplicate email address be added?

Thanks,
Eugene
Updated on 2011-05-04T16:59:42Z at 2011-05-04T16:59:42Z by G1lles
  • G1lles
    G1lles
    70 Posts

    Re: Allow duplicate email addresses?

    ‏2011-05-04T16:59:42Z  
    email addresses are case sensitive, so you can use the same one by just replacing some letters with upper case ones. Ugly, but the email servers should not be case sensitive and emails should still be send to the right person.
  • TimBratcher
    TimBratcher
    30 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-07T20:16:27Z  
    • G1lles
    • ‏2011-05-04T16:59:42Z
    email addresses are case sensitive, so you can use the same one by just replacing some letters with upper case ones. Ugly, but the email servers should not be case sensitive and emails should still be send to the right person.

    Doesn't work in 7.5.  Still get error message, "BMXAA4129E - Record already exists for E-mail=MyAddress@company.com.  Ensure that the key value for the given record is unique."

    Tried different variations in case of letters and still receive the same error message.

     

  • bgbaird
    bgbaird
    252 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-08T12:52:25Z  

    Doesn't work in 7.5.  Still get error message, "BMXAA4129E - Record already exists for E-mail=MyAddress@company.com.  Ensure that the key value for the given record is unique."

    Tried different variations in case of letters and still receive the same error message.

     

    Tim, the reason this is in place is to enable the email listener to associate an email address with a userid. There are a couple of ways to address this IF you don't use email listener:

    If you have access into exchange, you can alias the email addresses (bill@123.com, william@a23.com, and billy@123.com all resolve to billJones@123.com).

    If you REALLY have some bravado, you can modify the index EMAIL_NDX2 by adding another field (personid maybe?) to manage uniqueness.  I did this in a test environment, and it didn't break anything yet.......

    Brian

     

  • TimBratcher
    TimBratcher
    30 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-08T15:59:04Z  
    • bgbaird
    • ‏2014-01-08T12:52:25Z

    Tim, the reason this is in place is to enable the email listener to associate an email address with a userid. There are a couple of ways to address this IF you don't use email listener:

    If you have access into exchange, you can alias the email addresses (bill@123.com, william@a23.com, and billy@123.com all resolve to billJones@123.com).

    If you REALLY have some bravado, you can modify the index EMAIL_NDX2 by adding another field (personid maybe?) to manage uniqueness.  I did this in a test environment, and it didn't break anything yet.......

    Brian

     

    I tried this by removing EMAIL_NDX2 from the EMAIL table and duplicates are still not allowed.  There must be something in the software enforcing the unique requirement.  It should be configurable by making the change in the database configuration, but I can see how this could cause a problem with the email listener.

    The contacts are actually locations for departments and divisions, and they map to person records.  Previously we would use the email address of the person in charge of that department, but maybe it's time to make addresses for each department in Exchange, or at least an alias for the department contacts.  Instead of bill@123.com we could make an alias for him like warehouse@123.com and use that address.

    Tim

  • bgbaird
    bgbaird
    252 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-08T18:02:23Z  

    I tried this by removing EMAIL_NDX2 from the EMAIL table and duplicates are still not allowed.  There must be something in the software enforcing the unique requirement.  It should be configurable by making the change in the database configuration, but I can see how this could cause a problem with the email listener.

    The contacts are actually locations for departments and divisions, and they map to person records.  Previously we would use the email address of the person in charge of that department, but maybe it's time to make addresses for each department in Exchange, or at least an alias for the department contacts.  Instead of bill@123.com we could make an alias for him like warehouse@123.com and use that address.

    Tim

    Tim, rather than removing the index, you might try adding a field to it, like emailid....

  • swkim90049
    swkim90049
    287 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-08T23:52:16Z  

    Doesn't work in 7.5.  Still get error message, "BMXAA4129E - Record already exists for E-mail=MyAddress@company.com.  Ensure that the key value for the given record is unique."

    Tried different variations in case of letters and still receive the same error message.

     

    We had duplicate e-mails in Maximo 6, but the upgrade to Maximo 7 prevented duplicate e-mails.

    The other thought is to use PersonGroups and add people you want to the PersonGroups. 

    In your escalation or communication template, you can reference the PersonGroup rather than the Person.

     

  • DexterEnders
    DexterEnders
    6 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-09T13:26:04Z  
    • bgbaird
    • ‏2014-01-08T18:02:23Z

    Tim, rather than removing the index, you might try adding a field to it, like emailid....

    We had the same issue, where customers had group e-mail boxes where they wanted mail sent to.

    We added a field to the person table for "Group Email UserID". The only issue we found was when users send in e-mail to create the ticket the e-mail listener is unable to match the person to the Group Email address. So the Service Desk has to update the ticket with the correct person id.

  • BKDowning
    BKDowning
    15 Posts

    Re: Allow duplicate email addresses?

    ‏2014-01-09T18:58:24Z  

    It appears that the requirement is to facilitate the ability for multiple people to respond to an inbound communication, thus Bill and Joe could both have maintenance@mycompany.com email address in addition to his individual email address. 

    If this is the case, then a group on the email server should have the individual email addresses as part of a group id.   Then inbound communications are routed through escalations, actions, persongroup, or even a dummy user/person with the group email address id.  You can set this up in any active directory.  This solves the limitation of multiple email addresses.