TDMS excel add-in won't open my TDMS due to group name. I get a 0x80020009 error

[ApparentlyNotTheOnlyFelix]

Hello,

I'm having troubles opening a TDMS file with the MS Excel add-in. for some of my TDMS files, I get a 0x80020009 error and the data for the following groups is not shown in excel.

The TDMS file opens normally in labview and I can see all the data there.

I tried to figure out what was wrong and started playing around with my files. I wanted to see if it could somehow be related to the names of the channels or groups after i read this : https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000YJorCAG&l=en-US

I discovered that it was related to the group names in my files (enven though i dont use the word "History" in my names..)

when I rename the group "Flush Line 70->420 with HCL 0.04M" into "Flush Line 70->420 with HCl 0.04M", the file can be opened with MS Excel.

see examples in attachement, i'm using the last version of the add-in (24/11/2021) and Microsoft Excel 2019 MSO (Version 2209 Build 16.0.15629.20200)

Is there any guide about the names / words / characters to be avoided into the group names in order to have the add-in work normally ?

Is there an easy way to modify my TDMS files in order to open them in excel or to convert TDMS files into excel files ?

Best regards,

Félix

[ApparentlyNotTheOnlyFelix]

Hello,

the problem is now worse.. I tried to uninstall and re install the excel add-in via the NIPM, just in case it would help.

I'm now unable to have the add-in launch into excel.. when I go to COM add-in, tdm importer is unchecked. if I check it and open COM addins again, the TDM importer is still unchecked..

Could anyone help me repairing my TDM add-in, i'm running out of ideas ?

Félix

[ApparentlyNotTheOnlyFelix]

Hello,

After a complete uninstall/reinstall of labview, the TDM add-in works again. I'm now back to the initial issue (see files in first post) works.tdms can open without error in excel, doesntwork.tdms produces a 0x80020009 error.

is there any documentation for the TDM excel add-in ?

is there any easy way to change the group names in a TDMS file ?

Best regards,

Félix

[l.hovs]

Hi Félix, 

Yes, there is an article about Editing TDM(S) files with the TDM Excel Add-In - NI  , go through that to find your answers in it. 

And of course, there is an article about second one which is Changing TDMS Channel or Group Names from LabVIEW - NI. 

Also, the error that you have been receiving is caused by a group name when using the TDMS Add-In in Excel with the TDMS file (for example do not use "History" or "history" names). 

Regards)

[GerdW]

Hi I.hovs,

---

@l.hovs wrote:

Also, the error that you have been receiving is caused by a group name when using the TDMS Add-In in Excel with the TDMS file (for example do not use "History" or "history" names). 

---

Can you link to a (NI) documents where such "problematic" group/channel names are listed? That would be very helpful information from NI!

What is the reason behind forbidding certain names?

[ApparentlyNotTheOnlyFelix]

Hello,

thank for your answers. I had my problem solved by creating a VI to change group names in LV, then I'm able to open my TDMS files with excel.

a list of "forbidden" group names would be super useful but i'm not 100% sure that it would be possible. I did this a few weeks ago now but while testing my VIs i'm almost certain that the problematic group name in my TDMS could be used in another TDMS with a different number of groups, without causing the error..

i'll upload my LV project here in case it could help somebody.

To use the program, there are 3 modes : "Minuscule" will change the group names to lower case ("Group NAME" will become "group name"), "Longueur" will change the group names by keepin only the number of characters specified in "longueur" numeric input ("Group NAME" with input 7 will become "Group N") "Saisie manuelle" will ask you replace every group name in the TDMS with a string input, automatically preset to the current group name.

independently of the selected mode, the new group names will be prefixed with the group number (a TDMS with 2 groups named "Group 1" "GROUP 2", used with "Minuscule" mode would have its names changed to "1 - group 1" "2 - groupe 2"

Save your TDMS fils before using the soft as there will be no copy created, the soft modifies the input TDMS.

Hope this can help,

Best regards,

Félix