LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ericbrazis

Is there a way to import multiple XML files at the same time? Whenever I try I end up receiving an error stating "The error threshhold of 1 has been reached". I know this can be done for CSV and Excel files, but I can't seem to figure out how to do this for XML. I'm on a time crunch so any help is greatly appreciated that can be provided quickly.


Thanks,
Eric

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

That error is telling you that something is wrong with one of your XML files.
Either change the Threshold up to something large like 10,000 or inspect the XMLs to ensure that they all have the same columns, etc.

If I'm not mistaken, the FIRST xml needs to have all the possible output columns in it.. if some later XML needs to "add" a column, I don't think that is handled properly.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ericbrazis

Thanks stonysmith. Another issue I'm running into is I'm receiving an error on a lot of the files I'm importing that state
"Error occurred parsing XML data:
Error occurred while processing tokens to be sent to the node outputs.
At Line 46,972, Column 7"
The line is different for each file, but the column is the same. How do I find this point in the XML when none of the lines are numerically identified?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

What I do for such investigations is to switch to the Delimited File node
filename=YourFile
FieldSeparator=\n
RecordSeparator=\n

Then, add a filter to that output:

emit *
emit execCount as rownum
where execCount >46970 and execCount<49874 #one record before and after the error