XI Mapping Question

[Former Member]

Hi Friends,

I have a mapping error becuase the customer has sent a blank record in his file. He sends me a daily text file with all our customers; the data is all in one long stream NOT broken into fields. So in mapping I substring out all the data into fields. Anyway, he sent a blank line for the first time and it has bombed. I would like to add to the map to bypass any blank lines so the file keeps on processing. Is this possible using an IF Statement?

<i><b>Here is a sample of how the error looks in the data:</i>

<Recordset>

<RAW>

<FIELD1>011NWhipkey HC Corporation</FIELD1>

<FIELD2>A 20018512 11111 Highlands Square Dr.</FIELD2>

</RAW>

</Recordset>

<Recordset>

<RAW>

</RAW>

</Recordset></b>

<i>Sample of how the Map looks</i>:

<b>[O] Store_File

[O]Recordset

[O]Loop

[O]CMPY

[O]BTSO

[O]STREE

[O]TYPE

[O]ADD1etc.</b>

<i>Running a test case with the missing line of data, I get this Error.</i>

[<b>b]Cannot produce target element /ns0:MT_Amplifon_STRXRFPF/Recordset[45]/LOOP/CMPY. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd</b> </b>

Please let me know if I could provide more info: thank you for taking your valuable time to read my issue : )

Best Regards,

Eddie

[Former Member]

Hello,

I guess in the data types your occurences for the fields are 1:1 which makes it mandatory. And when you say file is sent with blank data for that particular fields which means you can change the occurence to 0:1 then it will solve the issue.

When there is any string it will parse else it will take blank data.

Regards,