02-02-2012 11:05 AM
I am using the NI excel TDMS plugin to read some files I am creating from labview. I've made custom group properties but they dont display anywhere in the file. It seems that the problem is with the excel importer but I dont know how to fix it. This is using ver 3.3.0.0 of the plugin on Excel 2007.
02-02-2012 02:07 PM
Please post the TDM file structure, you have made and also any error , if you are getting.
02-02-2012 02:18 PM - edited 02-02-2012 02:19 PM
VI is attached. No errors, it creates the file fine, but the custom properties are no where to be found.
02-02-2012 07:43 PM
hi glib,
I tried to download and open your attached VI, but it failed to open the VI, the error message is "LabVIEW: End of file encountered." Could you please confirm whether the VI file is correct?
And could you please tell me what properties you didn't see in Excel? All the properties or some specific properties, like named begin with "NI_"?
Thank you!
02-02-2012 08:22 PM
Please also make sure the option to load custom properties is checked in the Configuration dialog of Excel Add-in.
Hope this helps,
Mavis
02-03-2012 07:08 AM - edited 02-03-2012 07:11 AM
Mavis: Yes that box is checked, however nothing new appears under the "Available Properties" column as shown.
02-03-2012 07:11 AM
Im not sure why it didnt open, I downloaded it from that link and tried it and it worked. I'll post a screen shot of the relevant section.
The properties that dont appear are three "Free Text" terminals added to the "Write Data [ Channel Group]" block. They dont appear on any of the tabs of the excel TDMS spreadsheet, nor do they appear in the configuration menu. Perhaps I am writing to the file incorrectly?
02-03-2012 03:56 PM
Hi,
Have you considered using the lower level TDMS calls to create these data files? They will allow for much easier control to the file format. You can find several examples of these in the LabVIEW example finder.
Regards,
Greg H.
02-05-2012 07:05 PM
Hi,
Is this possible for you to post an example file here for us to investigate more?
Thank you!
02-05-2012 11:26 PM
"Free Text" properties are acturally "RegisterTxt" you found in the config dialog. Please add them to the right side "Selected properties".
Custom properties will not appear under "Available properties", if that box is checked, they will be read directly to worksheet.
Hope this helps,
Mavis