Exporting Content Center Data (Part Number, Description, etc.) to an Excel file

[chelmickVUXUE]

Hello, I would like to export data from a custom content center library to an excel file so that I can share it with our purchasing/inventory teams. 

Basically, I would like to compile an excel sheet with data (Part Number, Vendor, Stock Number, and Description) from all the parts in a custom content center we have created. I found a decent article on the Autodesk website with an iLogic code which I believe is getting me on the right track, but I am having issues modifying the code to pull all of the previously mentioned data, specifically Vendor and Description. 

Here is a link to the code:

How to export the whole Inventor Content Center Library Standard to the Excel file. 

[Frederick_Law]

Edit custom content center.

Edit the table in Excel and copy or save it as another file.

[chelmickVUXUE]

That is certainly an option, however I am looking for a way to export the entire content center library to excel instead of doing it manually Family by Family.

The iLogic code I linked initially gets close but doesn't include all of the data that I need.

[A.Acheson]

Adjusting this type of code really is a trial and error approach. Your families need to have consistent internal names. I suggest to carefully follow the patterns for each iproperty. Can you post the modified code your using? 

[chelmickVUXUE]

I just took the code linked in the original post and added Vendor, Stock Number, and Description following the patterns I could find. It worked for Stock Number, but for some reason Vendor and Description are not populating. 

I also noticed that the results of running the code differ each time I run it (ie. the first time it had data populated for ~1400 parts, the second time ~600 parts, and the third time ~1800 parts). 

[A.Acheson]

Hi @chelmickVUXUE 

It seemed to work ok for me. For the iproperties not working is the internal column name matching? The display name and internal name might be different.