Email Generation Rules "No Special Characters selected"

[Yeya]

Hello team,

I have a problem with my mail generation rule,
I created users with special characters,
example: firstname = ökîàéç and lastname = Lêäùèô ;
my 1st mail generation rule having failed,
I created a userupdate rule to trigger mail generation (i base the Action of Generate User Email, on the update off the firstname or lastname),

the log says “No Special Characters selected, Please Add Special Characters for Email Generation Rule.

I found this forum : https://forums.saviynt.com/t5/identity-governance/email-update-based-on-attribute-change/m-p/98907 
and I modified the “Reuse same email for user” as indicated but no change could be observed.

please found logs in attatch file

Would you have a clue for my email generation rule?
Thanks in advance

[indra_hema_95]

Hi @Yeya have you tried with users who don't have special characters in their first or last name?

Regards,

Indra 

[Yeya]

Hi @indra_hema_95 ,

Thanks for your answer

I just tried with a user that is :
firstname = Lola and lastname = Lêäùèô
and the email address generated is = lola.l@mail.com
and the logs still show the same thing

[indra_hema_95]

Hi @Yeya So as per your email generation logic what should be the mail that should generate?

Regards,

Indra

[Yeya]

Hi @indra_hema_95 ,

it should generate : lola.leaueo@mail.com

my Email Generation Rule is : 

CASE

    WHEN users.employeeclass = 'XXX'

        THEN CONCAT(LOWER(FN_EIC_REPLACE(users.firstname, NULL)), '.', LOWER(FN_EIC_REPLACE(users.lastname, NULL)), '.ext@mail.com')

    WHEN users.employeeclass = 'YYY'

        THEN CONCAT(LOWER(FN_EIC_REPLACE(users.firstname, NULL)), '.', LOWER(FN_EIC_REPLACE(users.lastname, NULL)), '@mail.com')

    ELSE CONCAT(LOWER(FN_EIC_REPLACE(users.firstname, NULL)), '.', LOWER(FN_EIC_REPLACE(users.lastname, NULL)), '@mail.com')

END

[indra_hema_95]

HI @Yeya Can try for user like John Smith and see if it is working expected or not?

Regards,

Indra

[Yeya]

@indra_hema_95 ,

thanks for your answer

I try, and it's working as expected 

[rushikeshvartak]

Did you added special characters in global configurations ?

[Yeya]

Hi @rushikeshvartak 
thanks for your answer
I add : User Regex Validation : [a-zA-Z\u00C0-\u024F\u1E00-\u1EFF]

[rushikeshvartak]

If your issue is resolved, Please mark applicable response even if its your as solution to help community 

[stalluri]

@Yeya 

CASE
    WHEN users.employeeclass = 'XXX'
        THEN CONCAT(LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.firstname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '.', LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.lastname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '.ext@mail.com')
    WHEN users.employeeclass = 'YYY'
        THEN CONCAT(LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.firstname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '.', LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.lastname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '@mail.com')
    ELSE CONCAT(LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.firstname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '.', LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.lastname, 'ö', 'o'), 'î', 'i'), 'à', 'a'), 'é', 'e'), 'ç', 'c'), 'ù', 'u'), 'è', 'e'), 'ô', 'o')), '@mail.com')
END

https://forums.saviynt.com/t5/saviynt-knowledge-base/how-to-escaping-special-characters-in-user-attr...

[Yeya]

Hi @stalluri 

thank you for your reply,
thank you for your help,
but isn't it possible to use the function (FN_EIC_REPLACE(users.firstname, NULL) ? 

because the documentation states: https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat...
“This DB function can be used with the advanced configuration of identity rules (System Username Generation, Email Generation, and Account Name)”.

thanks in advance