Comments on Impossible Siebel 2.0: Strip off Number format in DTYPE_PHONE field (No S...

In the Integration Field Map >> Source Expression ...

2009-09-16T01:48:27.547+10:00

In the Integration Field Map >> Source Expression use the expression:

ToChar([Work Phone #])

This removes the international prefix (e.g. +44) and the trailing format mask. Simple. I'm using this appraoch in Siebel 7.8 using a workflow deployed as a web service.

Hi Raju, the draw back of using this user property...

2009-08-21T08:07:46.013+10:00

Hi Raju, the draw back of using this user property is that it will apply this formatting to every field in the IO. eg, currency, date, etc

This is not desirable, when the remote system just wants the raw data, and control its own presentation.

If we use the Integration Object user Property a...

2009-08-21T02:46:55.511+10:00

If we use the Integration Object user Property

as

UseFormattedValues = 'Y' it will do send the phone numbers to external application through webservices without appended formatted zeros.

I incorrectly posted the reply to your EAI XSLT Se...

2009-05-05T21:32:00.000+10:00

I incorrectly posted the reply to your EAI XSLT Service question in the Impossible Solutions post, the concept will be the same.

See
http://siebel-essentials.blogspot.com/2009/04/scriptless-siebel-challenge-phone_16.html

The idea of setting the profileattr to \r\n is intruiging.

You can also use the profile attribute with value ...

2009-05-05T16:13:00.000+10:00

You can also use the profile attribute with value set to \r\n if you do not want to use business service in source expr. Also from the wf, before invoking data mapper step, you can set the profile attribute using BS:'SIS OM PMT Service' method 'Set Profile Attribute'

The source expr look like

IIf(InStr([Work Phone #],GetProfileAttr("CRLF")),Left([Work Phone #],(InStr([Work Phone #],GetProfileAttr("CRLF")) - 1)),[Work Phone #])

Ok for web services, I have figured out...It;s in ...

2009-05-05T15:56:00.000+10:00

Ok for web services, I have figured out...It;s in HTTP Transport where we have to intercept the outgoing XML and applying XSLT before passing it to external system. I will check it soon.

Nice find on the BS! It looks like it would work, ...

2009-05-05T09:01:00.000+10:00

Nice find on the BS! It looks like it would work, but the disadvantage is that it wont scale well.

In which step we need to invoke EAI XSLT Service w...

2009-05-05T01:51:00.000+10:00

In which step we need to invoke EAI XSLT Service when we are using Web Service. Also I think the same requirement could be achieved if the motive is to strip the trailing format. so if you have +44123456789CRLF000 000 000 then it will show +44123456789 and if you have +44123456789 then it will show +44123456789.

You can use following source expression:(NOTE: I did not test it personally but I guess it will work)

IIf(InStr([Work Phone #],InvokeServiceMethod("SSSE Address Parser (eScript)","GetCRLF","Name=Val","CRLF")),Left([Work Phone #],(InStr([Work Phone #],InvokeServiceMethod("SSSE Address Parser (eScript)","GetCRLF","Name=Val","CRLF")) - 1)),[Work Phone #])

EAI XSLT Service

2009-04-07T23:17:00.000+10:00

EAI XSLT Service

how can the xlst be applied to the xml during webs...

2009-04-07T20:46:00.000+10:00

how can the xlst be applied to the xml during webservice integration ?