LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reading the xml file and sort

Hi all, 

 

I need to read the XML file and sort the content in that. but initially, I had a problem with the reading itself.

 

the error stating that file was empty. but the file has a content .

I read ( opened ) the content and verified using the MS access database.

 expecting your ideas 

Download All
0 Kudos
Message 1 of 12
(2,071 Views)

audit date.vi ‏is empty

0 Kudos
Message 2 of 12
(2,055 Views)

Hi artem , 

 

pls find the attachment . 

 

from the XML file, i need to extract the first column ( date ) and sort. 

 

 

0 Kudos
Message 3 of 12
(2,045 Views)

You can't read no-LV xml by LV-reader.

Do it manual

xml.png

0 Kudos
Message 4 of 12
(2,039 Views)

@Artem.SPb wrote:

You can't read no-LV xml by LV-reader.

 

LABVIEW-version.PNG

 

Do it manual

 


 

 although "parse XML fragments.vi" does take some amount of time to execute,

  using "parse XML fragments" on "audit.xml" from the zip-file results in the following:

2018-09-18_125138_xml-fragments.png

 

 

0 Kudos
Message 5 of 12
(2,033 Views)

Hi artem , 

 

i am new to this domain .and expecting the guidelines 

pls attach the vi file 

 

More over ParseXML fragments.vi is available under which palette ? i dint have it 

 

i opened by MS access database. for sample just see the format of the file . ( find attachment)

 

i need to sort the date ( first column )  . For that ? is it possible ?

0 Kudos
Message 6 of 12
(2,015 Views)

Place Read From XML file.vi on BD and open it. You'll find how it works.

ParseXML fragments.vi is part of BD, I've taken it from here, not from menu.

My image is snippet, so you can save it and drag on your BD.

0 Kudos
Message 7 of 12
(1,952 Views)

Thanks artem ,

 

but the vi taking so much time to list out the output . what was the reason and how to avoid this ?

0 Kudos
Message 8 of 12
(1,902 Views)

I think you can't avoid long waiting.
You source file too big for fast working.

If you need work with file many times, better resave it in binary format or into DB

0 Kudos
Message 9 of 12
(1,898 Views)

If you really need to reduce your execution time [You need to develop your own LV code by invoking MSXML] which will reduce your execution time.

Palanivel Thiruvenkadam,
CertifiedLabVIEWArchitect|| CertifiedTestStandDeveloper
0 Kudos
Message 10 of 12
(1,895 Views)