From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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,965 Views)

audit date.vi ‏is empty

0 Kudos
Message 2 of 12
(2,949 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,939 Views)

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

Do it manual

xml.png

0 Kudos
Message 4 of 12
(2,933 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,927 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,909 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
(2,846 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
(2,796 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
(2,792 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 | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 10 of 12
(2,789 Views)