Big binary file to spreadsheet conversion - How? LabView 5.1

[george-195]

Hallo everyone,
I am new to LabView and need to collect 4 channels at high speed rate (max at PCI-MIO16E-1, about 300 kHz) for about 1 minute. Can do it with high speed data logger but how to convert this file into spreadsheet one. I can read even huge file into Origin software. Also can prepare some pieces from it using ASCII operating software, cannot deal with binary directly yet...
Thank you for any help,
George

[devchander]

If you are using 'High Speed data Logger.vi' from LabVIEW Examples, you will also find a 'High speed data reader.vi' in the same examples folder to convert data from Binary to ASCII.

In that VI, after converting data to ASCII, use suitable File I/O functions to write/append to a spread sheet file

Hope this helps

Message Edited by devchander on 09-13-2006 06:35 AM

Message Edited by devchander on 09-13-2006 06:36 AM

[george-195]

Thank you for swift reply. Yes, I have noted this example - but this converts a part of the data to the graph. All I need is to convert complete file at a time to have it like recorded in a spreadsheet form. Since I am not very familiar with LabView and huge amount of its functions maybe there exists a VI which asks for a BIN data file name and an output ASCII one and simply makes the conversion? George

[george-195]

Hi again - Please help...
Since I am very new to the LabView, do not know which function to use and how.... :((
George

[altenbach]

I would stay away from converting a huge binary file into an ASCII spreadheet. The datafile will multiply in size and you'll loose precision. Reading and writing will be comparatively slow because of all the formatting/scanning operations

Origin should be able to read your binary file directly. Have you tried the import wizard?

( http://www.originlab.com/index.aspx?s=8&lm=200 )

[george-195]

Hallo Christian, What a surprise... As soon as I get access to my Lab (it is too late now) I will try this opportunity. Simply since even big data files (about 500 MB) can be presented and processed successfullu with Origin, I did not try this... I will let you know how it works tomorrow. THANKS A LOT! George

[devchander]

Oh cool,

I did not know this about Origin

Christian, should any care be taken for importing Binara data logged with LabVIEW ( endian conversion), to Origin??

Regards

Dev

[altenbach]

Sorry, I actually don't have a copy of origin.

One thing you can be pretty sure is that LabVIEW binary files are big endian unless efforts are made to force little endian, so try that first and see how the data looks. There are only two possibilities with respect to byte order, and one is right. 😉

[george-195]

Hi,
Not a big success, but some. I was able to import only small amount of binary data to the Origin. All depends how to establish the proper size of a header. Since binary data logger puts I16 numbers I was able to establish the size once (by chance??) simply stopping after the last nonzero character... Then got reading of 4 channels with integer values reflecting properly signals character. But trying to go to higher sampling rates and longer files Origin hung up...
There is still not clear do I have to define header variables and how - tried to put 4 integer values, then changing them to 2-bytes. The pattern used was 4 columns with 2-byte integers and 'count' set to 1 each case.
Found the description of the header here:
http://digital.ni.com/public.nsf/allkb/747b83b6c8e4a6218625669100563b61
but it looks it is variable length... and maybe here is the point.
Anyone tried something like that?
Thank you,
George