Hi,
I have extracting xml data through using below stages
rowgen ---> trans---> xml input----->seq
I have tried with one file it's working fine, but trying with 2nd file not producing data and not getting any error or warning in director logs, it showing success with exporting 0 records.
but both files have same xsd.
but if i give 2nd file schema and namespace declaration,second file also working..
Please help me in this case
Not fetching data from XML Input stage
Moderators: chulett, rschirm, roy
Look at the "xpath" in the Description Properties of the output link of the xmlInput Stage....see if they have prefixes defined in the xpath (such as /xyz:name ) ...if so, then you need the namespaces to be "in" the actual xml......or not, if they aren't there. Look at your documents carefully....something is different about them.
Most often when you get zero rows means that the xpath is wrong, the spelling is wrong, or you have namespaces and no namespaces in the xpath, or namespaces in the xpath and none in the document.
Ernie
Most often when you get zero rows means that the xpath is wrong, the spelling is wrong, or you have namespaces and no namespaces in the xpath, or namespaces in the xpath and none in the document.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
If you don't include the namespace in your X-Path, it will not fetch the data. Maybe one of your files is defined with namespace and the other is not. If this is the case, the same X - Path will not work for both.
E.g.,
With namespace:
/ns1:root/ns:1records/ns1:value/text()
Without:
/root/records/value/text()
E.g.,
With namespace:
/ns1:root/ns:1records/ns1:value/text()
Without:
/root/records/value/text()
Arun
That's fine. Provided that you aren't getting other errors, rejections, or invalid documents, then something is different ....check the xpaths, check the namespaces ...see if the namespace declarations at the top are different between the documents....... Something is different.
Maybe it is being read incorrectly --- is the difference something about the size? Is one massively larger than the other?
Ernie
Maybe it is being read incorrectly --- is the difference something about the size? Is one massively larger than the other?
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>