Unexpected field value when converting XML file

martintangn

• October 03, 2016 00:00

• Answered

Follow

Hi. We have created a graph using the GUI tool to convert XML file to CSV/XLS file. However, when flushing in a lot of data, outputs are broken. In version 4.0.1, some data are converted to "<SEARCH_QUE", which looks like an angle bracket plus some characters of the field names. In version 4.3, some data are converted with duplicated text, say "aa:[10] bb:[20]" is converted to "aa:[10] bb:[20 bb:[20]". We have around 800 records when meeting the issue.


Graph settings are as follow:

XMLExtract ----------> UniversalDataWriter or SpreadsheetDataWriter

In XMLExtract:
<Mappings>
<Mapping element="TABLE">
<Mapping element="RECORD" outPort="0"
xmlFields="{}LOCATION;{}LOG_TIME;{}RESULT_COUNT;{}SEARCH_QUERY;{}SEARCH_SN;{}USER_ID"
cloverFields="LOCATION;LOG_TIME;RESULT_COUNT;SEARCH_QUERY;SEARCH_SN;USER_ID">
</Mapping>
</Mapping>
</Mappings>




During file generation, an error message was flashed out.
[Fatal Error] :6:10: The end-tag for element type "Mapping" must end with a '>' delimiter.


Any idea?

• 

  Pedro Vazquez Rosario

  • October 04, 2016 18:04

  0

  Comment actions Permalink

  Hi Martintangn,
  
  I would like to replicate this issue of the duplicate data on my end could you please provide me with your graph and a sample of the XML structure you use (please use dummy data). Also it would appear you are missing ">" after outPort="0" which is causing the error.

Please sign in to leave a comment.