Create a complete list of all available Content Centre parts

[Anonymous]

Hi there

We would like to be able to access all of filenames from the available Content Centre parts, Excel or the likes.

The reason being we have many duplicate parts in our outdated Access database and Vault. I'd love to be able to tidy this up by pointing the duplicates to the Content Centre part i.e. "do not use, use ********* from Content Centre".

If anybody could help me I'd be most appreciative.

Thanks

[Anonymous]

Hi there

We would like to be able to access all of filenames from the available Content Centre parts, Excel or the likes.

The reason being we have many duplicate parts in our outdated Access database and Vault. I'd love to be able to tidy this up by pointing the duplicates to the Content Centre part i.e. "do not use, use ********* from Content Centre".

If anybody could help me I'd be most appreciative.

Thanks

[A.Acheson]

Your actually looping through all of the categories on your way to the family members. This sample here shows how its layed out. 

Get the node in the content browser based on the names of the nodes in the hierarchy.
    Dim hexHeadNode As ContentTreeViewNode
     hexHeadNode = ThisApplication.ContentCenter.TreeViewTopNode.ChildNodes.Item("Fasteners").ChildNodes.Item("Bolts").ChildNodes.Item("Hex Head")
    

You will need the displayname of the last node before looping through the families. Syntax here from API help. Or you could print the full tree path for additional info. 

[A.Acheson]

Your actually looping through all of the categories on your way to the family members. This sample here shows how its layed out. 

Get the node in the content browser based on the names of the nodes in the hierarchy.
    Dim hexHeadNode As ContentTreeViewNode
     hexHeadNode = ThisApplication.ContentCenter.TreeViewTopNode.ChildNodes.Item("Fasteners").ChildNodes.Item("Bolts").ChildNodes.Item("Hex Head")
    

You will need the displayname of the last node before looping through the families. Syntax here from API help. Or you could print the full tree path for additional info. 

[Rich-T]

Thanks again AA

I think I'll have to park this for a while - i've reached my skill limit with ilogic an need to level up a bit i think.

[Rich-T]

Thanks again AA

I think I'll have to park this for a while - i've reached my skill limit with ilogic an need to level up a bit i think.

[suresh.r.ext]

Hi it's works well. But if some component doesn't have partnumber column then it shows error again. Can you ignore the part number column if family member doesn't have it means?

[suresh.r.ext]

Hi it's works well. But if some component doesn't have partnumber column then it shows error again. Can you ignore the part number column if family member doesn't have it means?

[alexanderboogaard]

This solution works great, however I just have an additional question. Would it be possible to only show the Unsuppressed items?
We have suppressed most of the fastener lengths and diameters to make our content center clean and similar to what we have have in stock. Our users are only allowed to use some specific diameters and lengths.

If i edit the Family table through Excel, I find that every family table has a column STATUS, but it won't show in the oFamily.TableColumns in the iLogic.

[alexanderboogaard]

This solution works great, however I just have an additional question. Would it be possible to only show the Unsuppressed items?
We have suppressed most of the fastener lengths and diameters to make our content center clean and similar to what we have have in stock. Our users are only allowed to use some specific diameters and lengths.

If i edit the Family table through Excel, I find that every family table has a column STATUS, but it won't show in the oFamily.TableColumns in the iLogic.

[A.Acheson]

Hi @alexanderboogaard 

Yes this is possible

 For Each oMember As ContentTableRow In oFamily.TableRows
	If oMember.IsSuppressed = True Then Continue For
         '.........Other code
 Next

And here is the method if you want to show all the rows but know what is and isn't suppressed. 

First add the property Status to the Family Member Class, this will allow it's use through out the sub routines. 

Public Property Status

Next in the row loop you can click on the variable name and check the methods and properties available. You will find a property of Is Suppressed. 

In the same for loop copy one of the other properties try catch statement and  paste in the bottom then adjust the Class property and then sets it's value like below.

Try
      FamilyMember.Status = oMember.IsSuppressed
Catch ex As Exception
      FamilyMember.Status = "#N/A"			
End Try

Next  in the set to excel sub routine create the excel column and set the rows value. 

oSheet.Range("J1").Value  = "Status"

and lastly in the loop of class properties set the cell value of the column you just added. 

oSheet.Range("J" & oCount).Value = FamilyMember.Status

[A.Acheson]

Hi @alexanderboogaard 

Yes this is possible

 For Each oMember As ContentTableRow In oFamily.TableRows
	If oMember.IsSuppressed = True Then Continue For
         '.........Other code
 Next

And here is the method if you want to show all the rows but know what is and isn't suppressed. 

First add the property Status to the Family Member Class, this will allow it's use through out the sub routines. 

Public Property Status

Next in the row loop you can click on the variable name and check the methods and properties available. You will find a property of Is Suppressed. 

In the same for loop copy one of the other properties try catch statement and  paste in the bottom then adjust the Class property and then sets it's value like below.

Try
      FamilyMember.Status = oMember.IsSuppressed
Catch ex As Exception
      FamilyMember.Status = "#N/A"			
End Try

Next  in the set to excel sub routine create the excel column and set the rows value. 

oSheet.Range("J1").Value  = "Status"

and lastly in the loop of class properties set the cell value of the column you just added. 

oSheet.Range("J" & oCount).Value = FamilyMember.Status

[alexanderboogaard]

Hi Alan,

Thank you very much. Working like a charm.

[alexanderboogaard]

Hi Alan,

Thank you very much. Working like a charm.