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

Pages: [1] 2
1
Trying to create a matrix mapping database view columns to database table columns.
How does the EA repository represent a view column?  What is the join condition for navigating from the view column to the parent view object? 

I see that I have created connectors from table columns to XSDElements, but I'm stuck trying to connect table columns to view columns.

Thank you,
CCW

2
Suggestions and Requests / Re: Improved support for View columns
« on: May 10, 2024, 04:16:17 am »
Agree!

3
I retrieve object properties like column length, etc., and especially Notes from SQL Server repository for a user walkthrough. The Notes contain the definitions obtained from the users.  But I get things like this "<font color="#424242">The medication given to the patient</font>."
How can I set/reset all fonts (typeface, size, color, etc.) for all objects in the entire model? It's a bit tedious to manually change these for every "offending" piece of text in the thousands of columns in the model!

I feel like I've tried all of the options in the EA UI.

Thank you in advance,
CCW

4
General Board / Re: EA - SQL to show hierarchy of packages?
« on: April 10, 2024, 12:34:42 am »
Thanks!

5
General Board / Re: EA - SQL to show hierarchy of packages?
« on: April 06, 2024, 05:35:19 am »
Thanks.  And does t_object.ParentID for a column get you to the containing table's object_id?

And then the table's t_object.package_id get you to the containing package's package_id?

6
General Board / EA - SQL to show hierarchy of packages?
« on: April 06, 2024, 02:29:11 am »
Hi -  Can someone share a SQL (SQL Server) query to show the hierarchy of packages in a "project"?  A query to run against the Sparx repository.
Thank you,
CCW

7
Suggestions and Requests / Re: Database builder - differences report
« on: March 07, 2023, 08:52:28 am »
Hi Geert, et al., We, too could very much use the ability to export (to Excel, for example) the differences as well as the chosen resolution actions.

If the capability already exists, where do I find it??

Thank you,
CCW

8
We have been using Sparx EA for a few years - ver 15.1 currently.  Some users have EA installed on their local workstations.  Other users run EA that is installed on a shared Citrix machine.
I am having a problem where a project model created on a Citrix box and using the EA-JSON add-in cannot be opened on a non-Citrix user's workstation running EA.
Trying to import an MDG technology (resource), I do not have a folder/URL containing the xml for EA-JSON.  I believe our access to the registered users' section of your site has expired.
Thank you,
CCW

9
General Board / Re: Where to find NOTES for an object in the repository?
« on: September 15, 2021, 05:33:03 pm »
Of course!  How did I miss that!?

Thanks again,
  CCW

10
General Board / Re: Where to find NOTES for an object in the repository?
« on: September 15, 2021, 10:22:31 am »
I found a "Find in Project" query builder window, but I cannot see that it exposes the generated SQL underlying the search, e.g., in the SQL Scratch Pad tab. Missing something, wrong place to look, something else?

11
General Board / Re: Where to find NOTES for an object in the repository?
« on: September 15, 2021, 09:52:25 am »
Thank you for the prompt response.   Sorry, but I do not know where to find the "Search Window" you refer to.  Could you explain a bit more precisely or attach a screen shot?
Thanks in advance.
  CCW

12
General Board / Where to find NOTES for an object in the repository?
« on: September 15, 2021, 05:08:58 am »
Not in t_object?

Also, Can we find documentation of the usage of PDATA1..PDATA5columns of t_object?

Thank you,
  CCW

13
An invalid character was found in text content.

How do I attach a screenshot?

14
(Sparx:) Where in the tool is this error coming from?  exactly what conditions trigger it?

I have received the same error in various circumstances, though I cannot remember the specifics.

Thanks,
CCW

15
General Board / Re: How to convert class objects into attribute objects?
« on: October 02, 2020, 03:46:42 am »
Thanks for replying- sorry for taking so long to get back into the thread.  But -  I want to be sure that I get this right.  Can you explain how I would use EA to "use your DataElement classes as types for attributes in your entity/table classes".  By "type", do you mean a user-defined data type for an attribute or something else ?  Can you explain a little more how "the tagged values in your DataElement classes will be shown in the attributes' properties, and accessible from the attributes as "extended" tagged values."?
Thank you.

Pages: [1] 2