Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - bholtzman

Pages: 1 [2] 3 4
16
General Board / Re: Visio import: Element text invisible
« on: July 10, 2018, 11:05:05 pm »
To add to the above, I searched every number column of the entire database for a reference to the Object_ID of the element whose style I am trying to use as a templete. I only found one, in the field Object_ID in t_diagramobjects. The field ObjectStyle contained some parameters that seem to affect the appearance of the object:

BCol=13758696;LCol=16777215;DUID=04ED5C6D;

However, tinkering with these only enabled me to change the border color and not to change the font color, background color or style.

Bill

17
General Board / Re: Visio import: Element text invisible
« on: July 10, 2018, 10:24:23 pm »
Thanks, Nizam. The import tool actually will only import the Visio 2003-2010 (.vsd) format so I had already been using that. I presume I could try and work this from the Visio side but I didn't create the diagram and am not an experienced Visio user. So I think my best approach is to figure out how to work it inside the EA database.

I composed a query to join t_object and t_xref:
select o.name, o.object_type, x.name, x.type, x.description from t_object o, t_xref x where x.client = o.ea_guid and o.package_id = 305 order by o.name

But the object I modified via EA did not appear in the result set.

What other tables are involved?

Thanks.

Bill

18
General Board / Visio import: Element text invisible
« on: July 10, 2018, 07:42:00 am »
Hi all,
I am trying to import some Visio diagrams into an instance of EA on Amazon Web Services which uses a MySQL database. I used the MDG Link for Microsoft Visio within EA 14 (Build 1421). I opened my diagram to find a number of issues:
1. default style is hand drawn mode
2. there don't seem to be any connectors
3. the text inside each item is not visible

Item 1 is easily addressed.

For item 2, I did some checking inside the database as I have SQL access. I ran this query (after identifying package_id 305 as the import):
select * from t_connector where start_object_id in (select object_id from t_object where package_id = 305) or end_object_id in (select object_id from t_object where package_id = 305)

The result set was null, so I concluded that no connectors were created.

For item 3, I found that each element was of type Rectangle and stereotype rectangle. I found that if I null the stereotype, the Element Name text suddenly appears. I attempted to make the change using an SQL update to a different element:
update t_object set stereotype = null where object_id = 9717

But this did not make the Element Name text visible.

I searched all through the t_ tables in the database but could not figure out where the data is stored that makes the text visible. When you change the stereotype of an element to null using EA, where does that change appear in the database other than in the stereotype column of t_object? I noticed that once you do that the Element Type in the Element Properties window changes to Class.

I ran SQL to select all from t_object to fetch only the two elements of interest, the one I whose stereotype I changed to null using EA and the one whose stereotype I changed to null using SQL. I could not detect any difference.

Any thoughts or insights? Thank you.

Bill


19
General Board / Re: Insert tagged value from MS Access
« on: September 08, 2017, 10:15:15 pm »
That's awesome. In the course of trying to evaluate this, as I mentioned I built some code to look for a matching guid in any table. In so doing, I am realizing the value of the guid. If you have metadata that can apply to individual rows in a variety of tables in your database, the guid gives you a single "primary key" to use to look up those rows. I understand that better now that I have code that can search all of your tables for a specific value in a specific field. If anyone is interested, below is my VB code.

Bill

Private Function findGUID(guid As String)
'this loops through all EA tables in the database to find a specific guid, displaying a message box to identify the table where it was found,
'along with the 1st field in that table and the value of the field for that guid

Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb
Dim fld As DAO.Field, sql As String, rst As Recordset, i As Single, FirstField As String

For Each tdf In db.TableDefs
i = 0
    If (tdf.name Like "t_*") Then
            For Each fld In tdf.Fields
            If i = 0 Then
            FirstField = fld.name
            i = 1
            End If
            If fld.name = "ea_guid" Then
                sql = "select " & FirstField & " as FF from " & tdf.name & " where " & fld.name & " = " & Chr(34) & guid & Chr(34) & ";"
                Set rst = CurrentDb.OpenRecordset(sql)
                If rst.RecordCount > 0 Then
                MsgBox (tdf.name & "." & FirstField & ": " & rst!FF)
                End If
            End If
            Next
    End If
Set fld = Nothing
Next

MsgBox ("Done")

End Function

20
General Board / Re: Insert tagged value from MS Access
« on: September 08, 2017, 01:30:46 am »
Hi qwerty,
I did have success in creating completely random guids and inserting them into the ea_guid field in t_attributetags along with the user-specified fields - ElementID (ID field from t_attribute), Property and Value. The data thus entered using MS Access then appeared perfectly in the EA model. I was also able to manipulate the same data from either EA or Access, updating and deleting. The only thing is I now get two errors when I close the Properties dialog box in EA. See attached. I get the Microsoft Cursor Engine error first, and then the Recordset error. But the mechanics of EA and the Access app still work properly. (I don't seem to be able to upload images of the errors to this site.)

I ran some code to see if an EA-generated ea_guid from t_attributetags appeared anywhere else in the database, at least in any table visible to me in MS Access. There was none. So I feel like your assumption that this ea_guid value is basically random and serves no core purpose is valid.

What are your thoughts? Thanks.

**Update** The errors were due to incorrect selection of ODBC driver options so disregard them! The method seems to actually work!

Bill

PS We use EA 13.5.1351 Corporate and are accessing a MySQL database on Amazon Web Services.


21
Bugs and Issues / Re: MS Access 2013 and EAP files
« on: September 07, 2017, 11:47:40 pm »
Hi Gary,
I should check this more often (the emails go to my spam for some reason). Did you find a resolution? I find that I get these EAP files in the old format and to upgrade them, I load them into my circa-2004 Sony VAIO and use Access 2003 to convert them.

Bill

22
General Board / Re: Insert tagged value from MS Access
« on: August 11, 2017, 04:27:39 am »
Got it. I'll try it out and report back! ;)

Bill

23
General Board / Re: Insert tagged value from MS Access
« on: August 11, 2017, 04:01:26 am »
So it's completely arbitrary and my choice of one has no impact on EA (unless I happen to miraculously match another one?

Bill

24
General Board / Re: Insert tagged value from MS Access
« on: August 10, 2017, 04:04:49 am »
Thanks qwerty. Can you tell me anything about what the ea_guid does?

Bill

25
General Board / Insert tagged value from MS Access
« on: August 10, 2017, 01:54:22 am »
I've built a tool in MS Access that connects to the EA database and provides tracking and a custom metadata "overlay". The tool can export a combined set of EA and non-EA metadata in various custom formats. One of the data elements I am extracting is from the two tagged value tables in EA, t_attributetag and t_objectproperties.

I have limited the Access app to querying the native EA tables only. I have never done any inserts from the Access app, but I have selectively run a few table updates manually.

The question has now come up as to whether new tagged value entries can be made from the Access side. Is that a bad idea or is it doable with careful diligence? Is there a way to populate the ea_guid field in the tagged value tables?

I am using EA 13.5 and Access 2016.

Thanks.

Bill

26
General Board / Re: Upgrade to 13 with Postgres db
« on: December 07, 2016, 08:22:44 am »
Fabulous, thank you. EA is a powerful tool.

Bill

27
General Board / Re: Upgrade to 13 with Postgres db
« on: December 07, 2016, 07:58:19 am »
Can you just clarify a bit? There must be some releases that do require changes to the database. In those cases I guess it would be made very clear? Thanks.

Bill

28
General Board / Upgrade to 13 with Postgres db
« on: December 07, 2016, 04:53:55 am »
Hi all,
If I upgrade my application to EA 13 can I still use the same EA 12 Postgres database? Thanks.

Bill

29
Bugs and Issues / Re: MS Access 2013 and EAP files
« on: October 09, 2016, 02:42:43 am »
I have to tell you guys, using MS Access with an EA Postgres database has been working out great. I have so much flexibility in terms of customizing the Access front-end, adding and modifying my custom data tables, and customizing the output capabilities it is tremendous. Even if I knew how to build MDG Technologies, I am not sure I'd have the same ease-of-use that I have and it would have taken me months if not more to get to the same level of proficiency. It helped, of course, that I had years of experience with Access. But I really am skeptical that I could have achieved the same level of capability with MDG Technologies even if I had mastered them.

I haven't had any issues with corrupting the database or any other setback. Naturally I am diligently and religiously careful never to touch the EA native tables. The only issues I have are performance-related when I am using a VPN connection. Most functions work well but when Access does heavy data crunching, as most of you know, it passes lots of data back and forth with the database. So one procedure - when I review all of the EA changes and build a new data dictionary - can take as long as a half hour to run. But it's an issue that's very workable and a small price to pay for the powerful tool I have built.

Well, I just wanted to update you on my efforts and let you know that this method does indeed have value despite your misgivings. You just have to be careful and know what you're doing, as I think Paolo said previously. Thanks, Paolo!

Bill

30
General Board / Re: baseline fail
« on: July 15, 2016, 12:31:05 am »
Thanks all.

Bill

Pages: 1 [2] 3 4