tdms excel

[viScience]

The TDM/TDMS excel plugin does not seem to recognize the TDMS format. I also tried to use the TDMS to TDM conversion vi, but could not get that to work either. I am using the TDMS write example vi to generate a test TDMS file and the TDMS viewer is able to preview the generated file.

[TCPlomp]

Could it be that your PC is not english. The TDM plugin only works on english windows platforms....

[Joe_Guo]

this plugin did not work on my computer either, had error when trying to read a tdms file. Had no problem reading the properties, but failed when reading the actual data, which is the important part.

OS: WinXP Pro SP2 English
Excel: MS Office 2007 Beta 2 Tech Prev

-Joe

[JLS]

Hello,

Just in case there's a correlation, can you also not convert to TDM using the VI?  I'd like to determine if this is expected behavior given some common circumstances, or if this is a problem we need to address.

Best Regards,

JLS

[Joe_Guo]

I tested the excel addin using only tdms files.

-Joe

[JLS]

Hello,

One solution would be to use LabVIEW to read your tdms data into numeric arrays, then use the array to spreadsheet string function to get it into an excel-compatible format.

That should be easy to write, can be configurable as to precisely what data you want to extract and write, and ultimately solve the problem immediately.

Best Regards,

JLS

[Joe_Guo]

although using labview is an alternative,but it defeats the purpose of having an excel tdms addin. hope this bug can be fixed soon.

-Joe

[JLS]

Hello,

I have done a bit more research on this, and the only potential problem I have found thus far involves the fact that Excel limits the amount of data that you can load per data channel to 65,535 values - could this be the problem?

If not, please let me know and I'll continue experimenting - if you can post a tdms file, I would be willing to try to open in using the plugin here, to see if this is a machine specific issue or perhaps correlated with your file(s).

Thank you,

Best Regards,

JLS

Message Edited by JLS on 10-03-2006 11:03 AM

[JLS]

Hello,

I found another potential cause for the problem.  Apparently due to a recent update in many of your websites, some document links for some time linked to older versions of software - the plugin was one of them.  The latest version of 1.1.10, and I have attached it here in case this is the problem.  You can uninstall your current version (it should be in your add/remove programs list as Excel TDM Add-in, or similar based on your installed version), and then try installing the version attached here to see if that solves the problem.  If not, please attach your file so I can reproduce it and take the necessary action internally.

Best Regards,

JLS

NOTE: msi is not a valid attachment extension in this forum, so I have renamed the file with extension txt.  After downloading it, simply rename the extension back to msi.

Message Edited by JLS on 10-03-2006 12:27 PM

[Joe_Guo]

i am using the tdms excle version 1.1.10, it has no problem opening tmds file, however, it returned some strange results.

take a look at the attached file, the first column should be double values (0.005, 0.010, 0.015 ...), but the values are -693957.99999, ... . the last column are also double values, they are shown correctly.

are there some special concers when writting doubles to a tdms file?

thanks,

-Joe

Message Edited by Joe Guo on 10-10-2006 04:54 PM