Cancel
Showing results for 
Search instead for 
Did you mean: 

Using Excel Live to Update Item and ItemRevision Properties

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor

I've installed the "Teamcenter Extensions for Microsoft Office" and created a custom excel template for exporting property values via Excel Live (Tools > Export > Objects to Excel). However, I'm only able to get the property values from the Item and not the ItemRevision which remain blank.

 

Does anyone have a working example of an excel template that exports both the Item and ItemRevision properties at the same time? For instance, the following data model explanation:

 

Item

  • item_id
  • item_name

 

ItemRevision

  • revision_id
  • owning_user

 

I would like all the properties to be listed on a single line in the exported excel spreadsheet.

 

Best,

/Randy


Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

2 REPLIES

Re: Using Excel Live to Update Item and ItemRevision Properties

Experimenter
Experimenter
can u tell how to install the team center extension for ms excel 2016

回复: Using Excel Live to Update Item and ItemRevision Properties

Genius
Genius

Hello Randy

 

Maybe you can try this in BMIDE

1.PNG2.PNG3.PNG4.PNG

 

 

Best Regard

Teamcenter 11.4,Active Workspace 3.4
Solid Edge ST10