Little database, to "Read only" data from WINDCHILL.

[mbuonfiglioli]

I have a Little excel database, and I would like to read the "Status" and the "Version+Iteration" of drawing.

Also the description, maintaining some kind of Read-Only link from Windchill, I suppose that somethiing like DTI "DEsktop integration"  that do an OOTB from office applications, but is possible to do ?

[Marco_Tosin]

In these TS articles you can find some advice to work with DTI.

How to add custom attributes to Desktop Integration (DTI)

https://www.ptc.com/en/support/article?n=CS36657

Best practices and recommendations for inserting and updating attributes in MS Word using DTI

https://www.ptc.com/it/support/article?n=CS194304

Does "Windchill Desktop Integration" support multi value attribute?

https://www.ptc.com/en/support/article?n=CS67201

Here some link to help center:

https://www.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=DTIMapPropertiesAbout&action=show

https://www.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=DTIWCDocAttributesInsert&action=show

Be very careful and pay attention to this article:

Windchill attribute mapped to Microsoft Word through Desktop Integration does not show the correct value when downloaded without DTI

https://www.ptc.com/en/support/article?n=CS223475

[Vincent-Kulak · Accepted solution]

@Marco_Tosin shared link if for the document itself ( not data inside ) right ?

IMO Desktop integration cannot do that.

@mbuonfiglioli you need to make a report

Report can be exploited directly or linked as data source in excel.

[mbuonfiglioli]

Vincent-Kulak

this is what I was looking for, thanks a lot

[Marco_Tosin]

Hi Vincent,

yes, as you wrote, DTI cannot make a list like the image from Excel file.

You could link attribute from a Windchill WTDocument and put it in his Primary Content, using DTI.

To obtain something like in Excel image you have to use a query builder report as source.

@mbuonfiglioli

Here you can find lots of report ready to use and some useful advises on how to work with query builder.