DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

TDM Excel Add-In truncate

We're experiencing a wierd issue with the TDM Excel Add-In where data is truncating depending on from where the file is read.

 

We haveTDMS (binary encoded data) files on a lab PC and copies of these files in a server folder.

 

When we run the TDM Excel Add-In to import these files the behavior is different when it comes from a "local" drive versus when the same data file (binary compare confirms they are the same) comes from a server folder.

 

We normally get ~8900 rows and when it is read from the server we get ~1400 rows per control.

 

A test of a different server was also performed with the same baffling results.

This previously worked as expected from both locations.

 

Is anyone else seeing this issue?  Do you have a fix??

 

0 Kudos
Message 1 of 4
(4,276 Views)

Can you provide some additional information.

  • Excel Addin version
  • An example file
  • Kind of share (Normal windows share?)
0 Kudos
Message 2 of 4
(4,269 Views)

Hi Perkin,

 

 Just to clarify, when you import from a local file, you are able to load the entire file (approx 8900 rows). However, when you load the same file from the server, you are only able to load a portion of the file (approx 1400 rows). 

 

Does this happen every time you load the file?

You mentioned that this used to work, do you know of any changes that you have made since that time? (Consider software installation, removal, firewall or network changes).

If you try to load a smaller file (such as one with fewer than 1400 rows) does the entire file get loaded? 

 

 Also, please do let us know about your software versions, share types, etc. as AndreasK mentioned.

 

Thanks, and have a great afternoon!

National Instruments
Applications Engineer
0 Kudos
Message 3 of 4
(4,232 Views)

Hi Perkin,

 

The simplest answer would be that the *.tdms_index file on the server is old and is effectively filtering the rows you get back.  Please try deleting the *.tdms_index file on the server and loading the *.tdms file from the server again-- that will cause the *.tdms_index file on the server to be recreated with the latest information in the *.tdms file.

 

Brad Turpin

DIAdem Product Support Engineer

National Instruments

0 Kudos
Message 4 of 4
(3,754 Views)