Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileInputMSXML - book example doesn't work

Please help this absolute Talend novice.
I am following the text in Components_TOS_RG_EN.pdf version 3.1_c very closely. I can't follow them exactly because they talk about a third tLogRow which is not defined in any way, so I'm ignoring that.

Point to note, the definition of the XPath Queries field in the tFileInputMSXML, Basic settings, Outputs section is not well described at all. I am going on the assumption that I need to have the same thing as per the screenshot in the book -- i.e. ".". I tried it with and without, and the result is exactly the same.
This result is -- when I press F6, I get the message
Execution failed :Failed to generate code.

Other jobs are compiling and running fine, so I'm guessing it's not the setup, but please correct me.
I did notice that the links don't seem to inherit any columns, even though I have defined the column when declaring the schema (as per the screenshot).
I manually created a schema for tLogRow_1 and 2, with the columns named "record" and "book" respectively and Sync'ed the columns. Again, tried it with and without declaring the columns, exactly the same happens.
Please tell me it's something very easy.
Kind regards,
Mihai
Labels (3)
10 Replies
_AnonymousUser
Specialist III
Specialist III

hi
how to use tFileInputMSXML file to read below xml file :
<?xml version="1.0" encoding="UTF-8"?>
<!--
Generated by: tap3xml TAP3-XML Converter
copyright (c) 2005-2012 Javier Gutierrez
All rights reserved
tap3edit Tools ( http://www.tap3edit.com)
-->
<RapDataInterChange>
<returnBatch>
<rapBatchControlInfoRap>
<sender>ARETC</sender>
<recipient>SYCCW</recipient>
<rapFileSequenceNumber>00750</rapFileSequenceNumber>
<rapFileCreationTimeStamp>
<localTimeStamp>20130304034636</localTimeStamp>
<utcTimeOffset>+0100</utcTimeOffset>
</rapFileCreationTimeStamp>
<rapFileAvailableTimeStamp>
<localTimeStamp>20130304034636</localTimeStamp>
<utcTimeOffset>+0100</utcTimeOffset>
</rapFileAvailableTimeStamp>
<specificationVersionNumber>3</specificationVersionNumber>
<releaseVersionNumber>11</releaseVersionNumber>
<rapSpecificationVersionNumber>1</rapSpecificationVersionNumber>
<rapReleaseVersionNumber>5</rapReleaseVersionNumber>
<tapDecimalPlaces>3</tapDecimalPlaces>
</rapBatchControlInfoRap>
<returnDetails>
<severeReturn>
<fileSequenceNumber>06875</fileSequenceNumber>
<gprsCall>
<gprsBasicCallInformation>
<gprsChargeableSubscriber>
<chargeableSubscriber>
<simChargeableSubscriber>
<imsi>424021431426942</imsi>
<msisdn>971504524600</msisdn>
</simChargeableSubscriber>
</chargeableSubscriber>
<pdpAddress>10.130.30.69</pdpAddress>
</gprsChargeableSubscriber>
<gprsDestination>
<accessPointNameNI>blackberry.net</accessPointNameNI>
<accessPointNameOI>mnc002.mcc424.gprs</accessPointNameOI>
</gprsDestination>
<callEventStartTimeStamp>
<localTimeStamp>20130303201159</localTimeStamp>
<utcTimeOffsetCode>0</utcTimeOffsetCode>
</callEventStartTimeStamp>
<totalCallEventDuration>0</totalCallEventDuration>
<partialTypeIndicator>I</partialTypeIndicator>
<chargingId>443428443</chargingId>
</gprsBasicCallInformation>
<gprsLocationInformation>
<gprsNetworkLocation>
<recEntity>
<RecEntityCode>1</RecEntityCode>
<RecEntityCode>4</RecEntityCode>
</recEntity>
<locationArea>1</locationArea>
<cellId>264</cellId>
</gprsNetworkLocation>
</gprsLocationInformation>
<equipmentIdentifier>
<imei>3574610464245312</imei>
</equipmentIdentifier>
<gprsServiceUsed>
<dataVolumeIncoming>0</dataVolumeIncoming>
<dataVolumeOutgoing>0</dataVolumeOutgoing>
<chargeInformationList>
<ChargeInformation>
<chargedItem>X</chargedItem>
<exchangeRateCode>0</exchangeRateCode>
<callTypeGroup>
<callTypeLevel1>10</callTypeLevel1>
<callTypeLevel2>0</callTypeLevel2>
<callTypeLevel3>0</callTypeLevel3>
</callTypeGroup>
<chargeDetailList>
<ChargeDetail>
<chargeType>00</chargeType>
<charge>0</charge>
<chargeableUnits>0</chargeableUnits>
<chargedUnits>0</chargedUnits>
</ChargeDetail>
</chargeDetailList>
<taxInformation>
<TaxInformation>
<taxCode>0</taxCode>
<taxValue>0</taxValue>
</TaxInformation>
</taxInformation>
</ChargeInformation>
</chargeInformationList>
</gprsServiceUsed>
</gprsCall>
<errorDetail>
<ErrorDetail>
<errorContext>
<ErrorContext>
<pathItemId>1</pathItemId>
<itemOccurrence>1</itemOccurrence>
<itemLevel>1</itemLevel>
</ErrorContext>
<ErrorContext>
<pathItemId>3</pathItemId>
<itemOccurrence>367</itemOccurrence>
<itemLevel>2</itemLevel>
</ErrorContext>
<ErrorContext>
<pathItemId>14</pathItemId>
<itemOccurrence>1</itemOccurrence>
<itemLevel>3</itemLevel>
</ErrorContext>
</errorContext>
<itemOffset>87340</itemOffset>
<errorCode>255</errorCode>
</ErrorDetail>
</errorDetail>
<operatorSpecList>
<OperatorSpecInformation>SeqNo:6875</OperatorSpecInformation>
<OperatorSpecInformation>DESCR: Duplicated GPRS call</OperatorSpecInformation>
<OperatorSpecInformation>CONTEXT: TransferBatch ->
CallEventDetailList ->
GprsCall</OperatorSpecInformation>
</operatorSpecList>
</severeReturn>
</returnDetails>
<rapAuditControlInfo>
<totalSevereReturnValue>0</totalSevereReturnValue>
<returnDetailsCount>1</returnDetailsCount>
</rapAuditControlInfo>
</returnBatch>
</RapDataInterChange>


i tried implementing the above logic of "book" and "disk" ,here the loop elements are "rapBatchControlInfoRap", "severeReturn" and "rapAuditControlInfo" the details for "severeReturn" is not getting displayed in tLogRow component . Do suggest the solution.