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

Pages: 1 ... 4 5 [6] 7 8 ... 48
We cannot use headings to indicate our requirements. And so they were reserved for the Chapter. Although, there are some ideas, but it adds to the work. But well, i think it's good idea to test MDG. Maybe maybe. ???

No, we can't import tables because of different languages, EA just throws garbage, and you can't change UTF when importing CSV. But if someone knows how it can be organized, I will be glad.
Okay so it sounds like you haven't given us enough info to help you.  The example you provided looks like headers were being used for requirements. Don't you what your reference to chapters are. I'm total confused and have no idea what your MS word doc looks like now so your going to have to explain further.
Sounds like your requirements maybe written in a language other than english is that correct?
Do you have any programming/scripting skills ?

Time travel is beyond my skillset

Don't under estimate yourself. You are travelling forward into the future one second at a time.

Try this:

  • Modify the "DDL" Template (Design -> Tools -> Transform -> Transform Templates)
  • Replace: type=%qt%%CONVERT_DB_TYPE(genOptDefaultDatabase, attType)%%qt%
        type = %qt%varchar%qt%
        length = %255%qt%

And see if works.
Wouldn't that make ALL columns of type varchar(255)?

Your right Geert. There needs to be some kind of %if ...% statement. However looking at the MySQL DDL transform it looks like
modification of a few lines DDL Data Type (lines 24 to 26) might be the answer as that looks like it sets the length to 0 there.
Code: [Select]
%elseIf $Type=="varchar" or $Type=="nvarchar" or $Type=="varbinary" %
However isn't the point of varchar is that it has a variable length otherwise just use char and fix the length.

General Board / Re: Performance problem or what?
« on: August 18, 2018, 08:21:28 am »
If everything is the same bar the AD then it kind of points to that. Maybe AD is involved in authorising each request to the DB and one AD is slower at responding. Not sure how it all works under the hood but may be AD is involved in validating security tokens on each request to the DB.  You might be able to find out some kind of message sequence diagram via google to help understand how DB requests and AD interact for authorisation.

Networks can also be set up to give different qualities of services and that might be dependent on which AD users are on.

If you want an approach to problem solving look up Kepner Tregoe. It helps to work through the logic and isolate root cause. I've used it a lot over the last 25 years and it was really useful.

Bugs and Issues / Re: Notes for class attributes
« on: August 17, 2018, 12:16:57 pm »
I have the feeling that the GUI designers at Sparx are hired from Sirius Cybernetics Co. Let's hope the revolution will come soon.


Hitch Hikers Guide to the Galaxy. aye?

General Board / Re: EA 14 - double click on elements in project browser
« on: August 17, 2018, 11:28:01 am »
Thanks a lot Sunshine for explanations.

Nevertheless in EA 14 build 1423 there is no option Start | View | Visual style | Prefer Property Dialogs (but in help it is!)
Your right its in build 1425 aka V14.1 beta

General Board / Re: 14.1 Beta: any schema changes
« on: August 17, 2018, 11:24:33 am »
jag har försökt kontakta dig via PM här, verkar inte funka....
Skicka gärna ett mejl om konsult hjälp
And in English it says
I have tried to contact you via PM here, seems not work .... Please send an email of consultancy

General Board / Re: EA 14 - double click on elements in project browser
« on: August 16, 2018, 06:41:05 am »
If there is a way to change it so double click opens the properties dialogue I haven't found it yet
The other approach I've found from the project browser is to use the context menu properties>special action
However in a diagram if you double click on the element it opens the properties dialog.
Kind of inconsistent which is never a good user experience.

I've also found out when creating attributes on elements the new features & properties window doesn't have access to notes for the attributes or operations. So you need to enable the notes window. Start|properties|notes

Alternatively if you prefer the old attributes/operations dialog you need to change the visual styles
Start | View | Visual style | Prefer Property Dialogs

Bugs and Issues / Re: Notes for class attributes
« on: August 16, 2018, 06:32:45 am »
Thanks Simon - would never have found that.

General Board / Re: 14.1 Beta: any schema changes
« on: August 16, 2018, 05:52:32 am »
Sparx Systems haven't changed the schema.
You good to use repositories created in earlier versions with 14.1

Bugs and Issues / Re: Notes for class attributes
« on: August 15, 2018, 12:00:51 pm »
Apparently version 14.1 is bringing back the attributes dialog :)
Just downloaded V14.1 beta to see if that is true. The attributes window remains and I can't see anyway of getting to the attributes dialog so may its fake news :)

Select a class and press F9. Or right-click > Features > Attributes. Both bring up a modal Features dialog where you can create attributes with their notes. The modeless Features & Properties window remains which will need to be used in conjunction with the modeless Notes window.

Sorry KP I've just tried again with Build 1425 and both of those mechanisms, F9 or right-click>Features>Attributes  I only get the modeless features window. No Dialog appears.

I also tried element properties dialog>details>attributes but only get the features window. Can't think of any other way to get a dialog but think I've pretty much exhausted the options.

Are you using the same build or a different one?

Bugs and Issues / Re: v14 long lasting bugs
« on: August 15, 2018, 11:49:08 am »
New features could drive sales.  A bug that gets very few reports - beyond the mavens here - probably are not cost effective to fix outside of when the code that contains them is being refactored.
Good point.
Wonder how many reports they got on PNG transparency issue.

Bugs and Issues / Re: v14 long lasting bugs
« on: August 15, 2018, 07:39:33 am »
Bugs - I hear you man.
I can say Sparx Systems does tend to
a) respond quickly and acknowledge bugs
b) never commits to when they will be fixed but often fix things I've raised within a 6 months.

I guess sometimes its more interesting for developers to add new features than it is to fix bugs.

Thanks, but DOORS too massive solution for our integration. Also, it's no small script for this... i'm examine the features of the structure of word files and realized that this is a Pandora's box.  :-\
Yep spent a long time using DOORS back in 1997 - it was a beast then.

I looked at MDG, good software but not suitable for our document structure.
Why is that ?

Looking at your example text
Example of text:
1. Test
1.1 req1 text:
1.2 req2 text
I can state categorically that I've had very similar structured documents and managed to import successfully using the Office MDG. Takes a bit of experimentation but it works.

Is the document inconsistent/ badly structured? I've found I've been able to import a lot of MS word docs using the Office MDG by pre-processing the doc using search and replace or scripts to fix that type of problem before importing using the Office MDG.
Remember MS word has some very powerful text manipulation built in so you could reformat the doc so its easier to import into Sparx EA.

Alternatively you could save the doc as Word XML and use XSTL to transform into a CSV then import that.

The last option is to go through the doc and manually reconstructed it in Sparx EA using cut and paste. But that would be tedious.

Well there are some alternative approaches  on tackling your problem for you to investigate further. However I'd be tempted to investigate the Office MDG further.

Think that template was aimed at logical and physical data models where entities have embedded attributes/columns. You know the other way to model data.

You'll need to create your own template for ERD. Its easy to do

General Board / Re: Is EA v 14 ready for Enterprise use?
« on: August 15, 2018, 06:55:53 am »
I'm a bit in dubio.

On the one hand 1423 indeed seems to be a more or less stable version, but then I see that in v14.1 they are bringing back the attributes and operations dialog, which is much more user-friendly then the current docked window in v14.

I would say, if you have a couple of months time to wait until v14.1 is stable then it might be worth the wait.

Yes with V14.1 beta making an appearance I concur with Geert on waiting a few months for a stable version of V14.1
Haven't had any stability problems with V14 Build 1423 and been using it for a couple of weeks now.

BTW: The attributes and operations dialog doesn't appear to be in V14.1 Build 1425 so you need to ensure  the notes window is enabled to add notes to those.

Pages: 1 ... 4 5 [6] 7 8 ... 48