Support

Bugs Detected

Scot — 2008-10-02T22:55:04Z

I don't have a copy of Pro installed, so I can't test this out (or walk you through the visio menu sommands), but the XSLT grabs the datatype you set within Visio. Try using a different driver for the DB.

Scot.

Could not install OrthogonalToolbox1.5

ldthang — 2008-07-18T07:48:39Z

Thank Scot for your reply.
However, this version is the same as the one that I downloaded.
It also complain that my system have not installed .NET framework version 1.1.4322 though I have already installed .NET framework 2.0 (running VS 2005 ok). :(

Database Model Diagrams to mysql SQL code

modelright — 2007-09-12T13:16:19Z

Do you meant generating MySQL 5.x SQL code from your diagram? If yes, of course, Modelright 2 does the job...

You can use MR2 to create a diagarm, and then generate the SQL and then even execute that SQL in your database. Also, it can reverse engineer an existing database into a new model, if you need.

Just to make sure... you need to use the latest MR 2 version (currently in beta). Also, if you use Vista as you operating system, then you need to use the latest build - 2014. Earlier releases had an issue with running on Vista.

Contact the support, if you have issues (or need to figure out how to use it), and they will help you out.

Good luck.

XML > SQL Script

Scot — 2007-09-03T11:37:44Z

Hi Merc,

It might be a rendering problem in your browser (i.e. if it's not HTML it doesn't interpret/display it). What browser/version are you using?

My knowledge of Access is dated, but I don't believe there was a DDL/import functionality. That may have changed with a later version. Dig around and see if they support some type of SQL DDL or maybe an XML schema? Once you know that, you can adjust the XSLT to gen the output in a version Access can read.

Scot.

Install error on Windows XP "it might be unsafe"

bakkengj — 2007-06-08T17:06:30Z

Trying to insall on Windows xp v5.1, I get the error message:

This advertised application will not be installed because it might be unsafe. Contact your administrator to change the installation user interface option of the package to basic.

VBA project creation error

mkking — 2006-04-07T13:27:20Z

I had my local IT support take a look at my settings, and he was able to narrow it down. So if someone else asks down the road, the "right" answer is that on the "Security" response window, on the "Trusted Publishers" tab, the "Trust access to Visual Basic Project" checkbox must be enabled. I just ran the export and it worked like a charm.

Thanks for your help in eliminating other possible causes.

Cheers,
Michelle

Doesnt work in Visio 2002 Pro Spanish

Scot — 2006-02-24T12:05:25Z

If you e-mail (scot at orthogonal software dot com) me the related vss and vst files, I might be able to figure out what is going on and fix it in time for the next version.

Thanks Much,
Scot.

Doesn't work with latest VEA...

Scot — 2006-02-19T18:52:38Z

With regards to the "Microsoft Visual Basic For Applications project creation must be enabled..." error message:

The security level (Tools | Macros | Security...) appears to be irrelevant (High vs. Low). However, on the Trusted Publishers tab, "Trust access to Visual Basic Project" must be checked.

Failure to have this checked will result in no export of ORM model subtype information; however, everything else should export fine. If you have no ORM subtypes, the message can be disregarded. I'll add a FAQ and provide better error text in version 1.5.1 (under development now).

FYI,
Scot.

XML export from ORM Source model for model specs interchange (XML/XMI?)

Scot — 2005-06-12T20:05:52Z

Guennadi V. Vanine wrote

"and a third that converts the ER model into SQL DDL"
I thought it was being done by VEA(?). What was your inconvenience with it?

It is done by VEA.

Visio Professional, however, supports ER modeling (but not ORM) except it has no forward engineering functionality. Thus, that XSLT was created to users could at least create a basic schema. It's been quite popular.

Scot.

XML export sample style

g_vanine — 2005-06-11T21:23:36Z

I tried to export again and it worked (showed tables in IE).

I understood that I should get correct result on 2nd or 3d trial.

BTW, OT continues to disappear and I am to periodically repair it (it seems to happen when I have a lot of MS Ofiice applications, like MS Word and MS Outlook, opened. I use MS Office 2000 Premium)

no import of typed objects without predicates

Scot — 2005-06-07T00:01:40Z

Guennadi V. Vanine wrote
I tried to import the text file with the only line:
One
or
One Two

Well, it doesn't import any objects (to me)

This works for me. A file with the above two lines creates two Object types, One and Two. I noticed that the object types window sometimes does not refresh. Ditto for the fact types/Object types pane of the Business Rules window. For the latter, you can right-click and select "Refresh. For the former, try closing and re-opening the window.

Guennadi V. Vanine wrote

BTW, it is impossible to have such rule (rule without predicate) in VEA. If I drag&drop an object onto a diagram, it doesn't show up in "Fact Editor | Object (tab) | Select object:" list

That selection window contains object in the given fact, not the model. If you drag and drop a new object and use it in some fact, it will appear when you click on that window. Besides, if you really want an object with no predicate, why do anything in the Fact Editor anyway?

Guennadi V. Vanine wrote
But is it possible to create isolated typed objects (without predicate) in any other way than drag&dropping from "ORM Source" stencil?

Yes. The OT can import them, you can drag and drop them, and you can create new ones from the Object Types Tab of the Business Rules Window.

Guennadi V. Vanine wrote
This is strange to me. So, if I create "ClassRoom is Subtype of Room", it is not rule, has no semantics and only graphic annotation?

It is a rule, just not (technically, or at least not to VEA) a fact type. There is an implied fact type, but VEA ignores that as the semantics expressed by subtyping are stronger than the implied fact type.

Also, just to be clear, the Toolbox only imports objects and facts and not subtype relationships. You'll have to create those manually.

Scot.

Unable to use Toolbox functionality...

g_vanine — 2005-06-06T23:51:45Z

"(though I haven't seen any specific reference to VEA SP-2). "
I am searching VEA SP -2 or SP2 or SP.
I do not have even SP1 X:-((((
And cannot find anything. Can you give me any link on downloads for VEA?

Orthogonal Toolbox Interoperability

g_vanine — 2005-06-05T13:36:35Z

"I think of ORM as a class of modeling languages (FORML, FCO-IM, NIAM, among others) much like ER is a class of languages (Barker, IDEF1x, IE, etc.)."

M.b. FORML, FCO-IM are subclasses |X;'-((( of NIAM(?)

Sounds 2 b obvious but for me it was not that all so simple due to interference with other issues, especially for ER notations since I was not DBA/data-oriented (rather UML one). I even "thought" IDEF1X is coceptual-level notation! At least something like this is used by Len Silverston for "Peoples and Organizations" model, or not, never mind.
Thanx Scot!

"restart system" confuses

g_vanine — 2005-06-05T12:11:17Z

I do not know exactly how to spoil O.g.T.b. integration X:'-((( again

exporting rules

Scot — 2005-06-04T00:48:32Z

Guennadi V. Vanine wrote

thanx a lot, Scot,
you save the ORM cause in Portugal answering my silly questions!

Glad to help.

Scot.

Unhandled Exception

Scot — 2005-04-12T10:29:07Z

Hi Vikram,

This usually happens when there is a relationship line that is either a) not connected on one or both ends or b) doesn’t have the parent-child columns “associated”.

To verify: on the Database Properties Definition tab for the relationship, select the parent column on the left and the child column on the right and make sure that the button between says “Disconnect”. If it says “Associate”, or there are no parent/child columns, then the relationship is not fully connected.

If you have a lot of relationships, you might try generating a DDL or doing a model error check as that might help you spot the relationship line(s) that are the problem.

The Visio API is a little less than graceful when this happens (and my code doesn’t have complete error handling); I have it on the v2.0 to do list to fix this up some.

Hope that helps,
Scot.

Welcome

Scot — 2005-03-23T15:54:03Z

Welcome to the ObjectRoleModeling.com Orthogonal Toolbox Support Discussion forum. Any (logged in) member of the site is welcome to post here. If your topic is related to a non-support topic for which there is a specific forum (e.g. ORM, Visio, General Discussion), please post in that forum instead.

Support

Bugs Detected

Could not install OrthogonalToolbox1.5

Database Model Diagrams to mysql SQL code

XML > SQL Script

Install error on Windows XP "it might be unsafe"

VBA project creation error

Doesnt work in Visio 2002 Pro Spanish

Doesn't work with latest VEA...

XML export from ORM Source model for model specs interchange (XML/XMI?)

XML export sample style

no import of typed objects without predicates

Unable to use Toolbox functionality...

Orthogonal Toolbox Interoperability

"restart system" confuses

exporting rules

Unhandled Exception

Welcome

More...