Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: shimon on January 22, 2024, 09:34:16 pm

Title: Searching and editing links in Notes
Post by: shimon on January 22, 2024, 09:34:16 pm

Hi,
We used (part of the) notes on elements to link to documents. As the directory name of some of these documents were in Hebrew, these hyperlinks do not render properly ( and do not work) in any RTF Documentation.

The work-around that seems to work is to create a file in a directory who's path is only in English that links to the original file.

The problem is to find all these links. The capability of viewing the present path  for a hyperlink in the Notes is non-existent in EA.

Using the SQL to search the Notes did not bring any results as explained by Geert here:
https://sparxsystems.com/forums/smf/index.php/topic,47483.msg276791.html#msg276791 (https://sparxsystems.com/forums/smf/index.php/topic,47483.msg276791.html#msg276791).

After figuring this out (and giving the Notes column an alias) I have to figure out the syntax for striping the Notes and leaving only the Hyperlinks.
Another option is to find non-English characters in a Hyperlink.

Sincerely,
Shimon

P.S. If anyone has done this already, please share.



 

Title: Re: Searching and editing links in Notes
Post by: Geert Bellekens on January 22, 2024, 09:57:40 pm

I think the best option is to create a small script to update your notes.

If you have a list of before/after paths, you can loop those and updates the notes one by one.

That will probably be easier (and safer) than trying to write an update query.

Geert

Title: Re: Searching and editing links in Notes
Post by: shimon on January 23, 2024, 12:28:17 am

Hi Geert,
I'm not looking to update via SQL. I'm just looking for a way to find all the notes that have such links.

I found it by searching for :
where t_object.notes like '%href%&#%\'.
It could probably be perfected, but this did the job for me.

Sincerely,
Shimon