Hyperlink on the document number or name after exporting the file

[RK_11492709]

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.

[avillanueva]

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?

[RK_11492709]

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]

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

[joe_morton]

Another possible workaround is to use Query Builder. If you create a report and add the document object to the output, you'll get a URL back to the documents that meet the query's criteria. This would be a different workflow for your users though. They'd have to run the report, then they could download it to Excel.

[RK_11492709]

hi @joe_morton 

Thank you for your information.

Sure, will check this as well and let you know.

[anursingh]

Hi @RK_11492709,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag 

[RK_11492709]

Hello @avillanueva 

Thank you for your information.

Sure, will check and let you know.