Messages

16

General Board / Re: Use of Tagged Values for version notes

« on: June 18, 2020, 04:57:36 am »

Here's what shows up in the debug window.

Bill

[512023404]      Stack recording threshold set to 3 frames
[512023470]      Default Directory is C:\Program Files (x86)\Sparx Systems\EA
[512023471]      Agent dll found: C:\Program Files (x86)\Sparx Systems\EA\SScript.DLL
[512023471]      Default Directory is C:\Program Files (x86)\Sparx Systems\EA
[512023471]      Agent: Started
[512023491]      Microsoft Process Debug Manager creation Failed: 0x80040154
[512023491]      This is included as part of various Microsoft products.
[512023492]      Download the Microsoft Script Debugger to install it.
[512023492]      Failed to initialize VBScript engine
[512023492]      Warning, all breakpoints failed to bind, check binaries built with debug information and source files synchronized with Model
[512023492]      Debug Session Ended

17

General Board / Re: Use of Tagged Values for version notes

« on: June 18, 2020, 03:42:37 am »

I think I might need to take a few steps back:
- I noticed the code includes getUserLogin. Right now my file is unsecured. Do I need to add security and require a login?
- The purpose of this is to link elements to CRs, right? How do I enter a CR? What does EA recognize as a CR? I see the below in your code. Can you explain?

Bill

   sqlGetString = "select top 1 o.Object_id " & _
               " from (t_objectproperties tv " & _
               " inner join t_object o on o.ea_guid = tv.VALUE) " & _
               " where tv.[Notes] like 'user=" & userLogin & ";" & wildcard & "' " & _
               " order by  " & sqlDateString & " desc, tv.PropertyID desc "

18

General Board / Re: Use of Tagged Values for version notes

« on: June 18, 2020, 02:48:25 am »

Hi Geert,
I am finally getting around to trying this out (Link to CR.vbs). I imported this script (and Util.vbs and LinkToCRMain.vbs) into my EAP file. I can run the script by right-clicking on an object in a diagram (Specialize -> Scripts). But nothing seems to happen. What am I missing?

Hope you're well. Thanks.

Bill

19

General Board / Re: Use of Tagged Values for version notes

« on: March 26, 2020, 12:46:09 am »

Thanks Geert! 

20

General Board / Re: Use of Tagged Values for version notes

« on: March 25, 2020, 11:53:05 pm »

OK so you're saying that I can just follow the instructions here and then use your code as-is?
https://bellekens.com/2015/12/27/how-to-use-the-enterprise-architect-vbscript-library/

You're saying I should download the entire Library or just the LinkToCRMain.vbs?

Is there code in there to generate reports of the changes as well? This would really be great if it's as easy as it sounds.

Bill

21

General Board / Re: Use of Tagged Values for version notes

« on: March 25, 2020, 06:23:11 am »

>>Each object we use has a property named TaggedValue, so the function doesn't need to know which type it is dealing with.<<


Are you saying that every row in t_attribute has a corresponding row in t_attributetag in which the property is TaggedValue and the value is "attribute"?


Also, what is the relationship between your method and an MDG? Is your code part of an MDG?


Thanks again.


Bill

22

General Board / Re: Use of Tagged Values for version notes

« on: March 25, 2020, 01:55:14 am »

This is cool, thanks Geert! I have some dumb questions:
-What does CR stand for?
-When you say "change object" what are you referring to exactly?
-How are these functions triggered to run and when? It looks like maybe linkItemToCR runs while the user is making changes to the model?
-Can you confirm that linktoCR actually adds a row in one of the tagged value tables in the database?
-If so, why does linktoCR not use the input variable selectedItemType? Don't you need to know the item type to know which table to use?

Thanks very much and I hope the epidemic is not affecting your area of the country.

Bill

23

General Board / Use of Tagged Values for version notes

« on: March 25, 2020, 12:11:37 am »

Does anyone use Tagged Values as a way for the modeler to annotate changes to the model? I was thinking of a Tagged Value called "Change Description" that the modeler would use to describe what changed. There might be other Tagged Values identifying the reason and/or source of the change. You could then run a script or query to extract all of the changes into a neat report, publish the new version with the change information embedded in the model for reference along with the change report, clear out all of the same Tagged Values in the master and start over for the next version.

Thanks.

Bill

24

Automation Interface, Add-Ins and Tools / Re: UTF-8 Encoding for JSON generation with Schema Composer

« on: March 20, 2020, 11:56:12 pm »

Sorry but here's one other note. I found some other characters that did not match anything in my ASCII table and seemed to be non-ASCII. When I used the Asc() function on them, the result was ASCII 9, which is a backspace. That doesn't make sense right? Does the Asc() function somehow pick the closest possible?! :-)

25

Automation Interface, Add-Ins and Tools / Re: UTF-8 Encoding for JSON generation with Schema Composer

« on: March 20, 2020, 11:34:59 pm »

Ok but this debate is about the JSON export from Schema Composer right? May issue is slightly different. If I paste a non-ASCII character into the Notes field of an object in EA, is it possible to detect that using an EA query? What I've done is:
- added a small Greek alpha character to the Notes field in an EA object
- open the EAP in MS Access
- add a new table containing all ASCII characters (except for those that can't be represented)
- build VB code to loop through every t_object.note field and every t_attribute.notes field
- loop through the text in each of these fields character by character
- verify that each character matches a character in the ASCII table
- identify any characters that do not have a match
- output the object or attribute name of any match fails and the position of the non-matching characters in the string

Oddly, when I tried to use the Asc() function in Access, when it hit my alpha it decided it was a small "a", as in ASCII character 97.

Any thoughts? Our goal is to publish a model that does not have any non-ASCII characters.

Bill

26

Automation Interface, Add-Ins and Tools / Re: UTF-8 Encoding for JSON generation with Schema Composer

« on: March 20, 2020, 03:26:50 am »

Are you saying I can find non-ASCII characters with this query in the SQL Scratch Pad?
select * from t_object where instr(note, '#nnnn;') > 0

27

Automation Interface, Add-Ins and Tools / Re: UTF-8 Encoding for JSON generation with Schema Composer

« on: March 14, 2020, 11:14:23 am »

I suspect that this isn't directly related to the schema composer (or database format.)

Internally, EA encodes characters in the extended ascii range for the system code page by escaping them. It would appear that the schema composer isn't restoring the original character.

I'm not actually sure what code page the schema composer writes files as or what options impact that.

Eve,
Since "EA encodes characters in the extended ascii range for the system code page by escaping them" as you say, then how would I go about recognizing them in the database? We want to publish a model but we want to first make sure that no UTF-8 characters got into it first. Thanks!

Bill

28

General Board / Re: Relationship matrix data

« on: October 22, 2019, 06:26:19 am »

Another issue with the relationship matrix - using a MySQL database on an Amazon WS server, and using different recent versions of EA, when I right-click to add a relationship I never get the "Create new relationship" option, just a small empty pop-up. Once again, use of MS Access is the workaround!

Bill

29

General Board / Re: Relationship matrix data

« on: August 14, 2019, 01:39:32 am »

You know the biggest hassle of using the Relationship Matrix? Reading the top header - the text is aligned vertically! I wind up tilting my head or taking a screen shot and rotating it...not sure of a better way, maybe some kind of cursor hover feature?

Bill

30

General Board / Re: Relationship matrix data

« on: August 13, 2019, 04:30:53 am »

Thanks, all. Sorry for the delayed response as I was on a 2 week holiday!

Bill