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

audit date.vi ‏is empty

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

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

Do it manual

xml.png

0 Kudos
Message 4 of 12
(2,953 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,947 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,929 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,866 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,816 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,812 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,809 Views)