topic Re: Format XML data in LabVIEW

Format XML data

willcan — Sun, 16 Aug 2020 16:05:35 GMT

Hi team ,

I wrote a data into XML file , but format was i need to change

All data are written in a single line . All parameters name and data need to write in separate new line

How i need to modify and write.

Please suggest

Thanks in advance

Re: Format XML data

Sebastian.Weber — Sun, 16 Aug 2020 18:51:35 GMT

There should be no need for linebreaks in XML, they are only there for better human(!) readability. Maybe, some odd software needs them, too.

However, XML documents in LabVIEW have the method "pretty print", which returns the document as XML with linebreaks and indentation:

Re: Format XML data

Its_Me_Ashiq(ஆஷிக்) — Mon, 17 Aug 2020 09:17:36 GMT

Hi @willcan ,

Please check this post.

Re: Format XML data

willcan — Sat, 29 Aug 2020 16:12:50 GMT

Hi sebastian weber,

I got the data for 1 set . But i am in need to display data for multiple tagname after a completion first tagname ( data set ) .

all data should be printed in a same document (multiple tagname ) .

i got a error . please find attachment of error and model format

Re: Format XML data

Sebastian.Weber — Mon, 31 Aug 2020 10:56:57 GMT

Hi!

You have a SubVI which inserts the nodes, which I have not on my system. Therefore, I use pure method / property calls here:

The point is to create an element (just the tag) and a text node (the value). The text node is appended to the element, and this element is appended to the <TestData> element.

The output of the "Generated XML" indicator is:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><TestData><S.no>1</S.no><Testcase>Name</Testcase><LOLIM>0</LOLIM><HILIM>5</HILIM><Rule>NA</Rule><Unit>unit</Unit><Result>Test Failed</Result></TestData>

and the output of the "PrettyXML" indicator is:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<TestData>
  <S.no>1</S.no>
  <Testcase>Name</Testcase>
  <LOLIM>0</LOLIM>
  <HILIM>5</HILIM>
  <Rule>NA</Rule>
  <Unit>unit</Unit>
  <Result>Test Failed</Result>
</TestData>

I noticed that PrettyPrint always inserts two linebreaks, so I replace them with a single one in my code.

Of course, you can simply replace ">" by ">\n" in the original XML, but PrettyXML also does indentation.

Finally, there's one problem with your tags. Due to the XML standard, a tag must not have a whitespace in it. Otherwise, it is not valid XML.

Some of your tags have a trailing white space, and "test case" consists of two words. So, this is not allowed.