Skip to main content
R
RK_114927095-Regular Member
5-Regular Member
April 16, 2025
Question

Hyperlink on the document number or name after exporting the file

  • April 16, 2025
  • 1 reply
  • 828 views

While exporting the bulk documents list into XLSX or XLS the items in the list should have hyperlink either in Document number or in name.

The purpose of the hyper link is, it will be helpful for the users to redirect them directly to the document page in the windchill.

For now in our windchill we are having hyperlink on the name after clicking on the name it will redirect us to the information page of the particular document, but if I export the list to the excel(XLSX) then the hyper link is getting missed 

So we would like to have the hyperlink on the number or name after exporting the documents list into XLSX file.

RK_11492709_0-1744814552488.png

RK_11492709_1-1744814889360.png

 

 

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
April 16, 2025

So are you looking to have the export to XLSX option provide URLs? Currently (in 12.0) you just get text of what you see in the table. This is how most table exports are done. Just confirming you are asking for URLs to be part of the export that they are not currently being created. right?

R
RK_114927095-Regular MemberAuthor
5-Regular Member
April 17, 2025

Hello @avillanueva 

 

Thank you for your response

Yes, you are right I'm expecting URL to be part of the export.

Kindly suggest if there is any way to achieve my expectation...

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
April 17, 2025

As far as I know, not directly via export from spreadsheet. https://www.ptc.com/en/support/article/CS194090?source=search

There are two ways we could accomplish this but there would be an extra step involved.

  1. If you look at the URLS generated to get you to the details page, they use internal IDs of objects, versions and iterations. If you can get those to output in a table, they in Excel, you could reconstruct the URL via scripting or formulas to recreate the URL. This would not be directly in the export spreadsheet but would need to be post processed.
  2. A custom jsp page can be created to create a "static" url to objects that only needs the objects number. We created something like this to download content directly and takes in parameters like object number and object type. This jsp page does a search and lookup and returns content. In your case, it could redirect to the object's details page easy enough. Solution here is customization. Still, post processing is required to take the number and form a URL. Something like this:

For WTDocument 123456 whose URL is https://<hostname>/Windchill/app/#ptc1/tcomp/infoPage?oid=VR%3Awt.doc.WTDocument%3A1576631446&u8=1  the custom URL might be https://hostname/Windchill/netmarkets/jsp/direct/DirectLink.jsp?number=123456

 

    Terms & ConditionsAccessibility statement