I am looking for the same information. Anyone know how to retrieve this information through a macro to export it into a custom property?
It set me on the right path at least. Looks like you have to go out to the .sldmat file and pull the data from there. I have modified a function I found to be able to go out and pull the material description. It is posted below. Hope this helps everyone.
Function GetCustomProperty(materialName As String, materialDatabaseFile As String) As String
' materialName is the name of the material in the .sldmat material manager file
' materialDatabaseFile is the full path filename of the .sldmat material manager file
' customProperty is the Property Name as you entered it in the Custom Tab of the Material Manager
' Material description as string
' This could potentially be Double; I think the manager only accepts double values here.
'Reference to Microsoft XML, v 6.0 (although an earlier version will probably work -
' the .sldmat file itself is written in XML 1.0
Dim xml_doc As New DOMDocument
Dim brtn As Boolean
Dim onode As IXMLDOMElement
brtn = xml_doc.Load(materialDatabaseFile) 'xml_doc exiting reference
If brtn Then
For Each onode In xml_doc.selectNodes("//material") 'Get any nodes that are labeled as materials
If onode.getAttribute("name") = materialName Then 'Look for the material we are interested in
GetCustomProperty = onode.getAttribute("description") 'Get the description for the material we are interested in and set it to a variable
MsgBox "Unable to open XML File" 'Built in error message if it can't open the xml file
I have a macro that pulls custom properties from the material and puts them into the part's custom property. Contact me if you're interested.
Why don't you share that publicly if you're OK with that?