From: deskpilot on
I am creating .tdms files during testing that I would like to convert to .lvm files post test. The files are around 500k lines so I need to split them up into multiple files for older versions of excel. When I read the .tdms data into a Write to Spreadhseet File set up to write to multiple files, it does not work. I get one file.
 
If I break the .tdms data up using offset and length on the .tdms read, I lose continuity on my time stamp.  I would really like to be able to share .lvm files rather than having people download the .tdms reader for excel. Any suggestions?
From: Captain Kirby on
Hi deskpilot, How are you setting up the "Write to Spreadsheet File" to write to multiple files? Are you parsing the output from the TDMS read using string or numeric compare functions? This method should work if you parse correctly and assign new files correctly. Can you post what you currently have so we could see where the problem is?
From: deskpilot on
I have attached the vi that works but starts the time over on each spreadsheet. As noted on the block diagram, it is set to write one file because the file names are correct this way. The only change that occurs when you set it to write new files every 60,000 lines is that the file name is different.


TDMS to Excel.vi:
http://forums.ni.com/attachments/ni/170/339066/1/TDMS to Excel.vi
From: Captain Kirby on
Hi deskpilot,I'm a little confused, I ran your VI with a randomly generated TDMS file, and came out with a few text files, and the time on each of the text files seemed to be correct.Time at the end of the first text file:<img src="http://forums.ni.com/attachments/ni/170/339849/2/Time%20at%20End.png"> Time at the beginning of second text file:<img src="http://forums.ni.com/attachments/ni/170/339849/3/Time%20at%20Beginning.png"> The only change I made
to your code was to generate the file name a bit more cleanly. In your
method, the file name used as the base for name generation was
interpreted as a folder, and you ended up with files with no extension
and just an auto generated number.Message Edited by Captain Kirby on 07-10-2008 05:59 PM


TDMS to Excel.vi:
http://forums.ni.com/attachments/ni/170/339849/1/TDMS to Excel.vi


Time at End.png:
http://forums.ni.com/attachments/ni/170/339849/2/Time at End.png


Time at Beginning.png:
http://forums.ni.com/attachments/ni/170/339849/3/Time at Beginning.png
From: deskpilot on
Captain,
Thank you for your help so far. I see that it does work with the file you generated, can I perhaps email you the file that I am working with? I checked it with your modifications just to make sure, and it still starts the time over on the second file.