LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Importing XML Data

    Employee
    Posted 11-17-2015 09:13

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

    Originally posted by: ericbrazis

    The XML data which I'm attempting to import via the XML Data node is causing an error. I've been able to identify why the error is occurring, but can't figure out how to correct the issue. In the data files I'm working with there are 5-10 lines, depending on the data file I'm working on, which summarize the contents of the file. The summary lines are causing an error to occur because the data can't be parsed out correctly and therefore is not passing through all the data like it should. I've set my Error Threshold to 0 and said Ignore to NoRecordForOutputBehavior, UnmappedFieldBehavior, and NullValueBehavior. No luck though and still receive an error. Any help would be greatly appreciated. Thanks.


  • 2.  RE: Importing XML Data

    Employee
    Posted 11-17-2015 09:54

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

    Originally posted by: ericbrazis

    I posted this under Nodes by mistake. I have since re-posted to Data Acquisition. Sorry, thanks.


  • 3.  RE: Importing XML Data

    Employee
    Posted 11-18-2015 08:10

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

    Originally posted by: lnason

    Any chance you could provide a mock xml file that has the same characteristics of the files you are working with? and/or...could you provide the details of the error message?

    One possible option would be for you to "wash" your xml data with LAE before using the XML Data node to unpack the contents of your data. You could go about this by reading your xml data into a graph using the "Delimited File" node, setting the FieldDelimiter and RecordDelimiter parameters to both be '\n' and populating the FieldNames parameter with a single column name like "DATA". After that... you might be able to do some scripting to remove or alter whatever it is in the summary data that is causing your issue. Finally, save your cleansed data to an updated xml file using the "Output Raw" node. Now, you should be able to use the XML Data node on your cleansed data.