tInputFileXML returns null values in Open Studio 7.1

[spr654]

Hi,

Using an xml that I have entered as metadata (I don't know why, but xsd files are not working 100% with the mapping), I have imported it as tInputFileXML in a job. This file is in attachment. This is the structure in the metadata:

In the file I have 2 transactions, and in each transactions I have  2 changeEvents. 2 of the events are of type QualificationInformationChangeEvent; and 2 are customsqualificationValidityChangeEvent.

The issue: when I try to get the 4 records, I get nulls everywhere. This is the loop XPath query that I use:

"/ns0:replicationMessage/body/transaction/changeEvent"

and the results:

|messageId|sender|recoveryMode|sentOnTime|transactionId|changeType|changeTime|versionId|source|typeOfQualification...
|=--------+------+------------+----------+-------------+----------+----------+---------+------+-------------------+
|null |null |null |null |null |null |null |null |null |null
|null |null |null |null |null |null |null |null |null |null
|null |null |null |null |null |null |null |null |null |null
|null |null |null |null |null |null |null |null |null |null

What went wrong? Any help is welcome.

[Anonymous]

Have you configured your XPaths? Can you show us the configuration of your tFileInputXML?

[spr654]

Hi,

thanks. Of course, here it is:

[Anonymous]

I see your loop shows a namespace, but your XPaths do not. Namespaces can be a bit of a pain here. You have a couple of options, you can add your namespaces to your XPaths. This will be a bit of a pain, but means you are being 100% accurate. Alternatively, goto the "Advanced Settings" and click on the "ignore the namespaces". See if that changes anything

[spr654]

Hi rahll, Thank you very much for your help. How can I add a namespace in a xpath? Could you show a picture of what you mean? Where should I add it? Thanks for your help and support.

[Anonymous]

I'm afraid I do not have any jobs where I have done this on the machine I am currently using. I tend to be lazy and just use the "ignore the namespace" option in most cases 🙂

However, this should help you (https://stackoverflow.com/questions/3931817/xpath-expression-from-xml-with-namespace-prefix)

[spr654]

Hi rahll,

ignoring the namespaces didn't work. Any ideas? I'm loosing hope...

[Anonymous]

Can you give an example of your actual XML file (remove any private data) and the XPaths you have just tried please? I will take a look and see what I can suggest

[spr654]

Hi rahll,

The test I am doing since yesterday is with the file example.xml. The result is exactly the same I get with the real data. If I get to make work example.xml, that's it. The problem is that the file doesn't produce 4 records with data in Talend. It produces 4 records with null values. If I solve the problem with example.xml, I have solved the problem.

Any help is welcome.

[spr654]

Update:

I have created a new job and I have mapped manually some fields. It is working now, but it is going to take me ages to fix all the mapping manually. Here is the mapping: