Skip to Content
0

How to allow .scot email domain in base data cleanse transform ?

Jun 19, 2017 at 08:04 AM

78

avatar image
Former Member

Hi All,

Scenario:
We are using Base data cleanse transform for cleansing the email address & recently business has decided to go with emails having .scot domain. Unfortunately, this email address when parsed by the transform, returns a NULL value in the output.

This means, transform is not accepting the domain.

Can anyone here suggest me the ways to allow this domain to be successfully parsed.
Also, I'm not looking for any manual solution and moreover looking for any SAP Notes or any existing solution around this.

Note:
We do not have Information steward installed to modify the existing cleansing package.

Thanks in advance,
Santosh G.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Dirk Venken
Jun 20, 2017 at 02:00 PM
0

Is is the tool to maintain/customise that type of information, it's part of the standard cleansing package. If you don't have it installed, I am afraid I cannot help.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Dirk.

I think i'll have to go with the IS installation .

0
Doug Staub
Jun 27, 2017 at 05:06 PM
0

Hi Santosh,

The domain list that Data Cleanse uses to parse email addresses is a hard-coded list and is not modifiable even with Information Steward. Note that the domain information that can be modified via Information Steward Cleansing Package Builder is used to be able to flag internet service provider (ISP) emails via the Email_is_ISP output field. The information maintained in that list does not impact how emails are parsed.

I would suggest logging an enhancement request via SAP Idea Place to add any missing domains to a future release of the cleansing package and to also request that this internal domain list be made modifiable via Information Steward Cleansing Package Builder module in the future.

Regards,

Doug

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Doug.

Now, I'm more interested in knowing email cleansing - what exactly this transform does apart from checking whether the domain is valid or not because the cleansing part is already done by the custom function. If it does validation then, what sort of validation it does?

Any inputs of the above queries would be helpful.

Rgds - Santosh

0

Santosh,

Data Cleanse simply identifies and parses the email address components . There is no validation being done to check if the email address is valid or not. I hope that helps.

Doug

0
Former Member

Hi Doug,

Sorry to bother you again, maybe understanding is still unclear.

I installed information steward, created a dummy package out of Person_firm. In the EditReferenceData -> Email section I added a custom domain, say "abc.scot". I tried to validate using adding the sample data.

For ex:

input email1 = a@b.scot

but, this email didn't get parsed under standard email output field but the output for it got logged under extra_field(not expected). The standard domain examples were working perfectly fine and the successfully getting parsed under standard email output field.

I just want to know,

1. what is the use of adding custom domains to the email reference data if they're not getting parsed?

2. Also that means we cannot add custom domains and use it in our cleansing job?

Regards,
Santosh G.

0
Doug Staub
Aug 07, 2017 at 03:32 PM
0

Hi Santosh,

As mentioned in my original response, adding the domain in Cleansing Package Builder will not impact the domains that Data Cleanse can parse. The email information you can add in CPB is used solely to identify if an email address (that was parsed successfully) is an ISP so they can be flagged as such. The email domains that can be successfully identified are hard-coded in the product and can not be added to at this time.

Please consider submitting an enhancement request via SAP Idea Place to add the missing domains in a future release and to request the ability to modify the domain list in CPB so you can add your own in the future.

Regards,

Doug

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 11, 2017 at 10:06 AM
0

Thanks Doug, now I'm clear. But can you guide me through below statement:

"The email domains that can be successfully identified are hard-coded in the product"

Can i get access to this list?


Regards,
Santosh G.

Share
10 |10000 characters needed characters left characters exceeded