Target field

[Former Member]

Hello everyone,

i have a requirement to convert CSV file to XML file, i have a small issue while creating Data Types.

My trading partner want one of the target node as shown below

LUCENT.ACKNOWLEDGE_DELIVERY_001.INVDETAIL.USERAREA

the problem is PI does not accept any symbols like .+-

can any one help me please

Regards

Chandrika

[Former Member · Accepted solution]

try this:

1) create data type and its corresponding message type

2) export the message type as .xsd

3) re-adjust the node name

4) import the xsd under ED

[Former Member · Accepted solution]

Thanks Amit, it worked.

[Former Member]

It wont allow you to create.

According to the standards only A-Z, a-z,0-9 and _ is allowed.

For your case,

1. You crete a data type according to the standard, 
say for that node use it as Lucent_ACK

2. Write an XSLT mapping to convert your node name
from Lucent_ACK to
LUCENT.ACKNOWLEDGE_DELIVERY_001.INVDETAIL.USERAREA

I think this is one good option!

Regards

Ramesh

[Former Member]

Hi Ramesh,

Thanks for your help, but i am not familiar with XSLT and JAVA mapping, is there any other way.

[Former Member]

Amit solution is good one and easy to implement.

Develop the required message type in XI. Export to local machine and edit it accroding to your requirement and re-import it back ans Amit suggested!

Regards

Ramesh