TDMS excel custom properties dont display

[glib]

Greg: I suppose I could use the  lower level TDMS blocks, however the ones Im using would be fine for my VI, if their custom properties work as they should.

Mavis: Absolutely nothing appears in the config dialog, other than the default values. Whether or not "custom properties" is checked, there is nothing in the left side column.

I'll post my VI again, not sure why it wouldnt open for some the first time. Thanks!

[Mavis]

Hi glib,

Your observation is correct that custom properties will not appear in config dialog, whether or not "custom properties" is checked. There is no way to config custom properties one by one. Instead, we can import them all or none.

But in your VI, you are writing 'Free Text', right? They are default/standard Root/Group/Channel properties that can be found in the config dialog named as "RegisterTxt". Please refer to my screenshot attached in Message#5. Adding them from the left side column to the right side should enable you to import them to worksheet. Please give it a try and let me know if any problems.

Best Regards,

Mavis

[glib]

I understand what you are saying but "RegisterTxt" does not appear in the config menu. In fact, nothing changes in the config menu regardless of wether or not I activate those free text inputs. See attached screenshot which is the TDMS file in question as created by my VI.

[Mavis]

OK, I got the problem.

"RegisterTxt" properties have been removed from the config dialog since Add-in version 3.0(if I remember correctly).

But for compatibility, the Add-in will display "RegisterTxt" if your machine has a history of configuring "RegisterTxt" within earlier Add-in versions (like that on my machine).

I think one option for you is to trick the Add-in by changing a registry key value:

HKEY_CURRENT_USER\Software\National Instruments\Common\USI\ExcelTDM

Please exit Excel and change the key value "group" data to "08 00 00 00". Launch Excel and go to the config dialog, you will find "RegisterTxt" properties under the Group tab.

You can also do the same to "root"/"channel" key values.

Hope this helps,

Mavis

[glib]

That worked, thank you so much! I knew it would be some arcane knowledge that was the solution.

Is there anyway to have the column title be something of my choosing instead of "registertxt"?

[Mavis]

For standard/default properties, we cannot change their name displayed as column title.

Fortunately custom properties enable us to do that, but your VI needs a small change. Instead of writing 'FreeTxt' properties, please use 'Set Property.vi'(on Storage>>Advanced palette) to write properties, naming them whatever you want(except those reserved).

Hope this helps,

Mavis

[glib]

How do I configure this at the group level? I've tried wiring in the VI you mentioned but it results in a broken wire.

[Mavis]

The VI may look like this:

If you don't want 'FreeText' to appear as terminals of Write Data, please go to its config dialog and choose them to be ignored.

Best Regards,

Mavis