cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

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

mbuonfiglioli
12-Amethyst

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

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

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions

@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.

 

 

View solution in original post

4 REPLIES 4

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

 

 

Marco

@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.

 

 

Vincent-Kulak

this is what I was looking for, thanks a lot

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.

Marco
Top Tags