LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Errors opening TDMS files using excel 2016

Hello Experts, I am trying to open a file in Excel 2016 (64 bit). Labview is also 2017, 64-bit. the error messages I am getting is attached in snapshot - I have no clue what is going on.

the s/w that produced the tdms file is a legacy one- so, I know that there is no problem in the tdms file that is being produced. i had previously opened the tdms files in Excel 2013 - not sure what the problem is. can anyone help?

 

PS: I tried uninstalling TDMImporter program and re-installing it again, didn't help. it's too work hassle to uninstall excel as it is part of corporate Office Program. 

 

Error logsError logs

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 1 of 10
(1,775 Views)

Hi LV_Enthu,

 

Can you clarify a few things? You said that the software that produced the TDMS file is legacy, what software and version was it that created the files?

 

Additionally, is this occurring when you're importing a TDMS file or just opening excel or any file in general in excel?

Tyler C.
Technical Support Engineering
National Instruments
0 Kudos
Message 2 of 10
(1,721 Views)

Hi Tyler, I have 2 conditions: 

  1. The s/w that was used to produce .tdms files was written in LABVIEW 2010. I am running the s/w (.exe) file. I tried to open the .tdms file using 2017 Excel TDM importer program
  2. I have opened the same s/w (src code) in LABVIEW 2017 and repeated same as in point #1. 

I can open this .tdms file in LabVIEW using low level tdms vi's, I have issue only when I open the file in excel -> pointing towards issue could be in the tdmimporter plugin. Excel in general works fine. 

 

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 3 of 10
(1,711 Views)

Hi LV_Enthu,

 

what version of TDM Importer (TDM Excel Add-In) is installed on your computer?

Can you update the TDM Excel Add-In to the most recent version?

TDM Excel Add-In for Microsoft Excel Download

 

0 Kudos
Message 4 of 10
(1,703 Views)

The error occurres when the data type of a channel is determined.

 

  • Is it possible to share the file?
  • After trying to read the file in Excel. Is there a logfile beneath the tdms file?
    Does it contain more information?
  • Did the file change since opened with Excel successful? (Appended to it)
  • Is it a single file or do you have a bunch of it?
0 Kudos
Message 5 of 10
(1,694 Views)

@AndreasK wrote:

The error occurres when the data type of a channel is determined.

 

  • Is it possible to share the file?
  • After trying to read the file in Excel. Is there a logfile beneath the tdms file?
    Does it contain more information?
  • Did the file change since opened with Excel successful? (Appended to it)
  • Is it a single file or do you have a bunch of it?

  1. Yes, I have shared the file, filename test3.tdms and test3.tdms_index
  2. There is a log file, I have attached that as well, called test3.tdms.txt, it has the error messages
  3. It was never successfully read so, no change
  4. I have lots of these files that I have issue with. 

I have tried to install the latest version of the TDMExport and also tried to open the file in DiaDEM, it doesn't work! Interestingly, I could open the tdms file in matlab using the standard tdms to matlab code published on NI website... 

 

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 6 of 10
(1,689 Views)

Hi LV_Enthu,

 

The corrupt TDMS in your attachment contains three empty channels("X2", "Y2", "Z2") under the "IAAM" group, these channels has no data(of course no data type), but these channels has scaling info on them(I guess you probably used TDMS Create Scaling Information.vi on them, the TDMS file are not produced by DAQmx, right?)

 

This causes problem when you try to open the TDMS file in Excel, Excel 2016 stops your from opening the file on TdsErrNotSupported(53) and doing further operation. To fix the corrupt file, I write a VI to append some data to the empty channel in your TDMS file, and then it should be able to opened in Excel without showing the error dialog and generates a error log file. The VI and fixed TDMS file are in the attachment.

 

P.S.: Earlier version TDM Excel Add-in also throw this error and generates the error log file, but it still allows you to open TDMS file in Excel. It seems there are some behavior changes in TDM Excel Add-in side that it now stops user to open Excel on this error.

 

Message 7 of 10
(1,657 Views)

The fixed TDMS file didn't upload successfully in my last reply, attach the zip again.

0 Kudos
Message 8 of 10
(1,652 Views)

The issue shows up because of empty channels containing some scaling properties.

Those properties where not interpreted by old versions of the TDMS stack.

In the newer version they are causing an error leading to a failure in reading of the file.

 

I have added it as a correction request to our software but it will only be solved in future versions.

As a workaround I only see the change of the file using labview 😞

 

Sorry for the inconveniance

Andreas

Message 9 of 10
(1,643 Views)

@Tianbin_Xu wrote:

The fixed TDMS file didn't upload successfully in my last reply, attach the zip again.



thank you very much, I will try that and let you know!! cheers

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 10 of 10
(1,609 Views)