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
1
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

2
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.


3
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

4
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

5
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

6
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

7
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

8
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

9
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

10
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

11
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

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

Bill

13
General Board / baseline fail
« on: July 14, 2016, 09:48:22 pm »
Hi all:
We have a PostgreSQL database set up with our EA 12.1.1227 Corporate Edition clients. I was trying to create a new baseline and got the message:

"ERROR: column "bincontent" is of type bytea but expression is of type lo; Error while executing the query"

I tracked this issue down to what I believe is the culprit, the column bincontent in the table t_document. This appears to be where EA stores the global attributes associated with each baseline. Interestingly, I was able to create a single baseline weeks ago for my database because (I believe) there was no data in this table previously. But now that a baseline exists I cannot create a second one because the code fails when it encounters the original baseline data. So as I see it I can only have one baseline in the database. Any ideas other than delete the first baseline?

Thanks.

Bill

14
Bugs and Issues / Re: MS Access 2013 and EAP files
« on: May 20, 2016, 03:33:14 am »
Does anyone know how to code an ODBC connection into the Access file? We'd like users to be able to run the app with the run-time version, which doesn't allow them to configure the connection. Just hoping someone has some copy-and-paste and save me the trouble...

Bill

15
Bugs and Issues / Re: MS Access 2013 and EAP files
« on: May 06, 2016, 10:43:32 pm »
Hi GB,
We did that and it seems to have turned out fine. I also published to HTML and that went fine. I didn't do any comprehensive testing though. Is there anything in particular we should be looking for in terms of problems with migration?

All in all we haven't had any issues so far except for performance over the VPN from far away.

Bill

Pages: [1] 2