Originally posted by: bchin74

Hi all,
I am still working on the same project, but run into different issue. Hope someone can help or point me to the right direction.
I am converting an xml file to a csv file.
I have two fields to map (first field is alpha, second is number.)
I have mapped the fiels and got no error, and it created a csv file, but my csv file has no data, when I look at the trace log, it's blank.
Any idea, what is my problem??
see attached fiels and the screen shot of the map.

Thanks!!
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

I ran your map in v8.2 and received an unknown data error on the input file. looks like the pprovided input file is empty.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: bchin74

thanks for taking the look..
the input xml is not empty..here is what is looks like..

it has values in the AccountID and ObjID.
Is my mapping wrong...am I mapping a wrong element??
One thing with xml tree is it looks like the same elemement was in diffent spots and not sure which field I should use...I used the Value:ElemDecl ObjId:Seq:inputxml, hope that is correct...

<?xml version="1.0" encoding="UTF-8"?>
<Search xmlns="urn:enterprise.soap.hireright.com/objs"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SearchRequest objType="BackgroundScreeningReport">
<AccountId>WSAPI</AccountId>
<ObjId>77777777</ObjId>
</SearchRequest>
</Search>
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: jvanboga

I did see the two elements defined in your type tree

<AccountId>WSAPI</AccountId>
<ObjId>77777777</ObjId>

The trace file indicates that the map could not find your data error message "INPUT 1 exists (322 bytes) but has no content." Looks like the data does not match the type tree definition so the map doesn't recognise your data. Below is the trace file related to the input:

Level 0: Offset 0, len 0, comp 1 of 0, #1, DI 00000001:)
Data at offset 0 ('<?xml version="1...') does not match INITIATOR '<OWSP><<IGNORE...><NULL>SearchRequest'
of TYPE X'0004' (ElemDecl SearchRequest Element XSD).

INPUT 1 exists (322 bytes) but has no content.

End of Validation messages for INPUT CARD 1.

It looks like your xml based tree is looking for '<optional white space><<IGNORE...><NULL>SearchRequest' but it finds '<?xml version=...'. I did not see where the tree had accounted for "<?xml version="1.0" encoding="UTF-8"?>". I could have just missed it. As a matter of presonal preference, I generally stay away from using 8.2 and above when I can. So someone that is more used to navigating the Eclypse version of the tool may see it when I didn't.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender