Automated Hyperlinkstemplates

Juun Steen

I’m testing Hyperlinks in the BETA envirement where you can use JAVA and objectfiltering to get documentlinks to components. I wonder if there is someone who can tell me if making hyperlink files automated from excel is possible. I’m searching for a workflow where I have to copy/paste less and let the computer do the work finding and summerizing documents and make automated hyperlink templates.

Who understands my question, please do respont!

lasse.lindqvist

Hi.

Presenting data from Excel automatically can be done in 9.12.0 (beta version currently) with the custom information API (https://society.solibri.com/topic/563/information-api)

Do you have a specific reason to present the data as hyperlinks? Modifying (adding) hyperlinks is not currently possible with the API, but adding any kind of arbitrary data to the custom infos tab in the info view is.

Juun Steen

@lasse-lindqvist I was thinking linking documents to BATID by using Excel within the worksheet Hyperlink Template Name, Filtering by BATID and Hyperlink. From there It would be nice to generate automated Hyperlink template files for all the files to Hyperlink in SMC to components.

Making Hyperlink Templates is repetitive work which would be nice being automated from Excel, XML or CSV.

lasse.lindqvist

If you just need to present the links from an Excel, custom info will be enough to automate that. Those will be presented as text however, not clickable links. The text can be copy-pasted though.

If you want hyperlinks specifically, you can use the Javascript API to do that (https://society.solibri.com/topic/620/javascript-api-documentation-solibri-version-9-10-8/2) Reading Excel files is a bit more difficult in Javascript though, so that might become a barrier. Using Javascript is also less stable, as we don’t focus in testing its compatibility between as much as we do for the Java API.

If you implement the URL reading from the Excel in Java custom information, it is possible that in some future that info can be used in a hyperlink template as output, making it possible to have the url as a hyperlink instead of just text.