This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to extract the hyperlink information associated with elements

I have some SewerGems and CivilStorm files that has hyperlinks to photos attached to any of the elements. This information doesn't appear to be available in any of the export formats that are available in the latest releases of these products.

We are migrating the data to SQL Server spatial tables and have completed the export of the geometry and other properties that we require via flex table export to shape files. My current analisys of the files is that this information is probably stored in one of the binary files and not included when creating an iModel file or a flex table. I even browsed the SQLite database file.

It would be nice to not have to re-enter al the link URL's into the target database manually.

  • Hello,

    There is not a direct way to get this information from flex-tables and exporting to shapefiles. However, if you are browsing the SQLite database file try looking at the HMIEmbeddedStickyObject table. Currently WaterObjects.NET has the API to access this information.

    An alternate way to get these links is to map the hyperlinks to the Notes field in the element properties. You can have the Notes field as a flex-table column and can export this information from the table.

    Let me know if this helps.


    Regards,

    Yashodhan Joshi