01-24-2009 01:35 PM
Hello All,
I ‘am saving data in a TDMS file format. When I try to open the file in excel, I get an error message. An error box appears labeled "TDM Importer" with an error message of "USI encountered an exception: (177): Error while initializing interface" inside the box.
In my VI I ‘am using the Write to Measurement File to create data files. I have the measurement file set to start a new file every 10 Megabytes. One set of data measurements is 3 files large. I ‘am able to open the first two in excel but not the last one. The write to measurement file also creates a .txt file with this message "ERROR: TDS Exception in Initialize: Tds Error: TdsErrAccessDenied(8):"
Any ideas why this is happening and how to fix it?
Thank you for your help,
-Mike
01-26-2009 11:33 PM
Hello Mike,
I have not seen this error before, but I can look into it. Could you write to an excel file as well as TDMS?
Anna K
01-27-2009 03:45 AM
01-27-2009 10:35 AM
HI All,
Thank you for replying. I did find a work around for this problem, instead of using the Write to Measurement function. I used the long method of TDMS Open, Write, and Close. When I did this a few things happened that I can't explain. The files are smaller, a lot smaller. Instead of three files totaling 30 Megabytes, it's one file of ~1.5 megabytes. That's OK with me, the smaller the files the easier it is to move around and process the data. When I opened the data file this morning, I was able to use the Add-In button within excel with no problems. One thing that I 'am concerned about is the write function, it holds the data until the close function executes. If I have an power outage, I might lose that data. Not the end of the world, but would be nice to keep all the data taken.
I have attached two files. Mike Battery Charger Version 3, is the write to measurement version. Mike Battery Charger Version 4, is my work around. I 'am not the best LabVIEW programmer, everything I know is pretty much from a book and a few people who knew enough to get me started. If you have any tips and tricks I would like to hear them.
Here is a basic overview of the program. This VI is designed to charge and discharge batteries autonomous while taking readings every second. I 'am interested in Temp (AD 590), Voltage (Voltage divider connected to a AI port, then software to correct the measurement), Current (40 Amp Hollow Effect Sensor), Watts (Software Calculation), and Watt hours (Software Calculation). The battery box is 66 NiCad's in a parallel series configuration. Charge time takes about 4 to 5 hours, depending on the load, the discharge can take anywhere from halve an hour to 12 hours.
In Version 3, if I complete just one charge and discharge cycle the files are fine. If I let Version 3 run forever, the last file in the series becomes corrupted. I 'am useing excel 2007 with the Add-in driver downloaded from NI.com
Thank you,
- Mike
01-28-2009 03:58 PM
Hello Mike,
To be safe, we can insert a TDMS Flush Vi right after Write. This will flush all data from system memory.
Anna K.