CONTENTS DELETED
The author has deleted this message.
|
It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne.
-Adrian --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: > From: bsreekanth <[hidden email]> > Subject: Key data model relationship pages in Wiki > To: [hidden email] > Date: Sunday, February 7, 2010, 10:23 AM > > Hello, > I added few of the data model > relationship diagrams to the Wiki (up to > Example, in alphabetical order). Please know if it is any > help. I don't know > much about the data model, but anyone may edit the page to > add details to > it. Once I read the data model book, I may contribute as > well. > > Link: > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > (Available through Documentation Overview) > > thanks, > Babu. > -- > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html > Sent from the OFBiz - User mailing list archive at > Nabble.com. > |
In reply to this post by bsreekanth
Thank you Babu for this effort.
The charts are jpg files. How do you think people can help updating it? -Bruno 2010/2/7 bsreekanth <[hidden email]>: > > Hello, > I added few of the data model relationship diagrams to the Wiki (up to > Example, in alphabetical order). Please know if it is any help. I don't know > much about the data model, but anyone may edit the page to add details to > it. Once I read the data model book, I may contribute as well. > > Link: > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > (Available through Documentation Overview) > > thanks, > Babu. > -- > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
In reply to this post by Adrian Crum-2
Or just keep both.
For newbies including me, they may not familiar that VARCHAR(20) equals to "id-ne" in entity definition, or vise-versa. thanks, Miles. 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: > It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne. > > -Adrian > > --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: > > > From: bsreekanth <[hidden email]> > > Subject: Key data model relationship pages in Wiki > > To: [hidden email] > > Date: Sunday, February 7, 2010, 10:23 AM > > > > Hello, > > I added few of the data model > > relationship diagrams to the Wiki (up to > > Example, in alphabetical order). Please know if it is any > > help. I don't know > > much about the data model, but anyone may edit the page to > > add details to > > it. Once I read the data model book, I may contribute as > > well. > > > > Link: > > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > > > (Available through Documentation Overview) > > > > thanks, > > Babu. > > -- > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html > > Sent from the OFBiz - User mailing list archive at > > Nabble.com. > > > > > |
The problem with using the SQL type is that it varies depending upon the database being used.
-Adrian --- On Sun, 2/7/10, [hidden email] <[hidden email]> wrote: > From: [hidden email] <[hidden email]> > Subject: Re: Key data model relationship pages in Wiki > To: [hidden email] > Date: Sunday, February 7, 2010, 11:13 AM > Or just keep both. > For newbies including me, they may not familiar that > VARCHAR(20) equals > to "id-ne" in entity definition, or vise-versa. > > thanks, > Miles. > > 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: > > It would be better to use the data type in those > diagrams instead of the SQL type. For example, instead of > partyId being VARCHAR(20) make it id-ne. > > > > -Adrian > > > > --- On Sun, 2/7/10, bsreekanth <[hidden email]> > wrote: > > > > > From: bsreekanth <[hidden email]> > > > Subject: Key data model relationship pages in > Wiki > > > To: [hidden email] > > > Date: Sunday, February 7, 2010, 10:23 AM > > > > > > Hello, > > > I added few of the data model > > > relationship diagrams to the Wiki (up to > > > Example, in alphabetical order). Please know if > it is any > > > help. I don't know > > > much about the data model, but anyone may edit > the page to > > > add details to > > > it. Once I read the data model book, I may > contribute as > > > well. > > > > > > Link: > > > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > > > > > (Available through Documentation Overview) > > > > > > thanks, > > > Babu. > > > -- > > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html > > > Sent from the OFBiz - User mailing list archive > at > > > Nabble.com. > > > > > > > > > > > > |
In reply to this post by Miles Huang
+1, but be explicit about what they are both
Jacques From: <[hidden email]> > Or just keep both. > For newbies including me, they may not familiar that VARCHAR(20) equals > to "id-ne" in entity definition, or vise-versa. > > thanks, > Miles. > > 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: >> It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being >> VARCHAR(20) make it id-ne. >> >> -Adrian >> >> --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: >> >> > From: bsreekanth <[hidden email]> >> > Subject: Key data model relationship pages in Wiki >> > To: [hidden email] >> > Date: Sunday, February 7, 2010, 10:23 AM >> > >> > Hello, >> > I added few of the data model >> > relationship diagrams to the Wiki (up to >> > Example, in alphabetical order). Please know if it is any >> > help. I don't know >> > much about the data model, but anyone may edit the page to >> > add details to >> > it. Once I read the data model book, I may contribute as >> > well. >> > >> > Link: >> > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference >> > >> > (Available through Documentation Overview) >> > >> > thanks, >> > Babu. >> > -- >> > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html >> > Sent from the OFBiz - User mailing list archive at >> > Nabble.com. >> > >> >> >> > > |
In reply to this post by Miles Huang
+1
I suspect a lot more newbies understand SQL than OFBiz, but we need to learn the new lingo too. On Mon, 2010-02-08 at 03:13 +0800, [hidden email] wrote: > Or just keep both. > For newbies including me, they may not familiar that VARCHAR(20) equals > to "id-ne" in entity definition, or vise-versa. > > thanks, > Miles. > > 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: > > It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne. > > > > -Adrian > > > > --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: > > > > > From: bsreekanth <[hidden email]> > > > Subject: Key data model relationship pages in Wiki > > > To: [hidden email] > > > Date: Sunday, February 7, 2010, 10:23 AM > > > > > > Hello, > > > I added few of the data model > > > relationship diagrams to the Wiki (up to > > > Example, in alphabetical order). Please know if it is any > > > help. I don't know > > > much about the data model, but anyone may edit the page to > > > add details to > > > it. Once I read the data model book, I may contribute as > > > well. > > > > > > Link: > > > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > > > > > (Available through Documentation Overview) > > > > > > thanks, > > > Babu. > > > -- > > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html > > > Sent from the OFBiz - User mailing list archive at > > > Nabble.com. > > > > > > > > > > -- Matt Warnock <[hidden email]> RidgeCrest Herbals, Inc. |
In reply to this post by Adrian Crum-2
CONTENTS DELETED
The author has deleted this message.
|
In reply to this post by Bruno Busco
CONTENTS DELETED
The author has deleted this message.
|
In reply to this post by bsreekanth
I think that a explanation about db and where the db info for ofbiz can
be found would be appropiate. If you want to use SQL varchar(20) then make sure is modeled for the db that has the least. So someone does not ask why there db can not handle larger values of varchar Adrian Crum sent the following on 2/7/2010 11:28 AM: > The problem with using the SQL type is that it varies depending upon the database being used. > > -Adrian > > --- On Sun, 2/7/10, [hidden email] <[hidden email]> wrote: > >> From: [hidden email] <[hidden email]> >> Subject: Re: Key data model relationship pages in Wiki >> To: [hidden email] >> Date: Sunday, February 7, 2010, 11:13 AM >> Or just keep both. >> For newbies including me, they may not familiar that >> VARCHAR(20) equals >> to "id-ne" in entity definition, or vise-versa. >> >> thanks, >> Miles. >> >> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: >>> It would be better to use the data type in those >> diagrams instead of the SQL type. For example, instead of >> partyId being VARCHAR(20) make it id-ne. >>> -Adrian >>> >>> --- On Sun, 2/7/10, bsreekanth <[hidden email]> >> wrote: >>>> From: bsreekanth <[hidden email]> >>>> Subject: Key data model relationship pages in >> Wiki >>>> To: [hidden email] >>>> Date: Sunday, February 7, 2010, 10:23 AM >>>> >>>> Hello, >>>> I added few of the data model >>>> relationship diagrams to the Wiki (up to >>>> Example, in alphabetical order). Please know if >> it is any >>>> help. I don't know >>>> much about the data model, but anyone may edit >> the page to >>>> add details to >>>> it. Once I read the data model book, I may >> contribute as >>>> well. >>>> >>>> Link: >>>> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference >>>> >>>> (Available through Documentation Overview) >>>> >>>> thanks, >>>> Babu. >>>> -- >>>> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html >>>> Sent from the OFBiz - User mailing list archive >> at >>>> Nabble.com. >>>> >>> >>> >> >> > > > > |
In reply to this post by bsreekanth
If you look at the entity reference page in Webtools, you will see all of the entity information in a convenient table format. So, the code already exists to gather the entity information, you just need to output it in another format.
-Adrian --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: > From: bsreekanth <[hidden email]> > Subject: Re: Key data model relationship pages in Wiki > To: [hidden email] > Date: Sunday, February 7, 2010, 12:35 PM > > Adrian, > thanks for the feedback. the graph is generated from the > database tables, > and may have to look at how to do the same from xml schema > definitions. the > easiest to do would be explaining the sql and ofbiz data > types, and how they > maps. I can point to the configuration where it also shows > how it differ for > different databasses. > thanks, > babu > -- > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html > Sent from the OFBiz - User mailing list archive at > Nabble.com. > |
In reply to this post by bsreekanth
If people are interested in making diagrams there is some stuff build into OFBiz to export "eomodeld" files. That particular file format can be imported by a few tools, but mostly on the Mac (my preferred tool being OmniGraffle). Unfortunately the weeks I put into that code, organizing the entities into groups, and then creating and organizing diagrams for the groups, was done while I was part of Hotwax Media so I don't actually have any rights to the diagrams any more, and I'm not sure what the situation is with them (a Hotwax rep would have to answer that I guess). I've thought about doing a new export and creating a new set of diagrams, but the amount of work required to layout all of the diagrams again is well beyond what this is worth to me... :) It would be great to see another pass at this be done fully open so that various people could participate and share the load. To do so would require agreeing on some file formats at least, and possibly tools as well (which makes it difficult, at best). The eomodeld files that OFBiz exports are NOT diagram files, but can be imported into a diagramming tool. From there a diagram file can be exported and maintained going forward. BTW, for new and changed entities it is probably more work to redo the export and layout than it is to modify the diagram files, so creating the diagram file from the eomodeld files probably only needs to be done once. The output formats that I can do easily with OmniGraffle include: Visio XML, PICT Vector, SVG, EPS Vector, PDF Vector, and various rendered pixel/bit-map formats that are probably not of much use. BTW, just to note Visio XML is only supported by a limited number of tools and is not the same as the Visio binary files. The alternative would be to write some other export code to write the model in a different format. On a side note, there is some stuff to write eomodeld files for services as well (with ECAs joining the services together). -David On Feb 7, 2010, at 2:35 PM, bsreekanth wrote: > Adrian, > thanks for the feedback. the graph is generated from the database tables, > and may have to look at how to do the same from xml schema definitions. the > easiest to do would be explaining the sql and ofbiz data types, and how they > maps. I can point to the configuration where it also shows how it differ for > different databasses. > thanks, > babu > -- > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html > Sent from the OFBiz - User mailing list archive at Nabble.com. |
In reply to this post by Jacques Le Roux-2-2
CONTENTS DELETED
The author has deleted this message.
|
Babu: could you please subscribe to the list so I don't have to moderate through every message you send? I may not always be around to do so in a timely manner... -David On Feb 7, 2010, at 3:32 PM, bsreekanth wrote: > > Jaques.. thanks for the feedback. With reference to my reply to David (in a > different thread "nice job on keeping the download site up-to-date." ), it > is best if I link the documents to the main index of the wiki. I even saw a > page there for similar effort > http://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages > couple of things.. > 1. at the latest, you added a link there, which seems broken > 2. the entity model is from 2003, and not sure how updated it all. > > Do you agree to replace the content with what I added at > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > which I would complete or you prefer to keep a link to the existing page. > > Babu. > > > Jacques Le Roux-2-2 wrote: >> >> +1, but be explicit about what they are both >> >> Jacques >> >> From: <[hidden email]> >> >> >>> Or just keep both. >>> For newbies including me, they may not familiar that VARCHAR(20) equals >>> to "id-ne" in entity definition, or vise-versa. >>> >>> thanks, >>> Miles. >>> >>> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道: >>>> It would be better to use the data type in those diagrams instead of the >>>> SQL type. For example, instead of partyId being >>>> VARCHAR(20) make it id-ne. >>>> >>>> -Adrian >>>> >>>> --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote: >>>> >>>>> From: bsreekanth <[hidden email]> >>>>> Subject: Key data model relationship pages in Wiki >>>>> To: [hidden email] >>>>> Date: Sunday, February 7, 2010, 10:23 AM >>>>> >>>>> Hello, >>>>> I added few of the data model >>>>> relationship diagrams to the Wiki (up to >>>>> Example, in alphabetical order). Please know if it is any >>>>> help. I don't know >>>>> much about the data model, but anyone may edit the page to >>>>> add details to >>>>> it. Once I read the data model book, I may contribute as >>>>> well. >>>>> >>>>> Link: >>>>> >>>> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference >>>>> >>>>> (Available through Documentation Overview) >>>>> >>>>> thanks, >>>>> Babu. >>>>> -- >>>>> View this message in context: >>>> http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html >>>>> Sent from the OFBiz - User mailing list archive at >>>>> Nabble.com. >>>>> >>>> >>>> >>>> >>> >>> >> >> >> > -- > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472354.html > Sent from the OFBiz - User mailing list archive at Nabble.com. |
CONTENTS DELETED
The author has deleted this message.
|
In reply to this post by David E. Jones-2
Le 07/02/2010 22:31, David E Jones a écrit :
> -David We've got a tool here that uses the entitymodel files to generate diagrams : http://labs.libre-entreprise.org/projects/ufo/ -- Erwan de FERRIERES www.nereide.biz |
CONTENTS DELETED
The author has deleted this message.
|
In reply to this post by David E. Jones-2
CONTENTS DELETED
The author has deleted this message.
|
In reply to this post by bsreekanth
Le dimanche 07 février 2010 à 14:03 -0800, Babu Sreekanth a écrit :
> Hello Erwan, > I can'r find any activity on the link you sent. Can you please give a link to download the tool and documentation, so I may try. > thanks, Hi, you can download it with svn : svn checkout svn://labs.libre-entreprise.org/svnroot/ufo run 'mvn' in trunk to compile then launch it with java -jar UFO-0.9.15-SNAPSHOT-full.jar in target folder. you can get some information here : http://ufo.labs.libre-entreprise.org/UFO/index.html It is still in developpement because it is part of a student project but it is already quite usable. Please feel free to report or ask anything you want to, here or in neogia mailing list ( [hidden email] ) -- Matthieu BOLLOT www.nereide.biz |
In reply to this post by David E. Jones-2
There are some perfect (not very perfect :) web-based process modelers
now, for example: http://bpt.hpi.uni-potsdam.de/Oryx http://bxmodeller.eng.it/ Not sure whether they are useful to draw a database diagram. Shi Jinghai/Beijing Langhua Ltd. 在 2010-02-07日的 15:31 -0600,David E Jones写道: > If people are interested in making diagrams there is some stuff build into OFBiz to export "eomodeld" files. That particular file format can be imported by a few tools, but mostly on the Mac (my preferred tool being OmniGraffle). Unfortunately the weeks I put into that code, organizing the entities into groups, and then creating and organizing diagrams for the groups, was done while I was part of Hotwax Media so I don't actually have any rights to the diagrams any more, and I'm not sure what the situation is with them (a Hotwax rep would have to answer that I guess). > > I've thought about doing a new export and creating a new set of diagrams, but the amount of work required to layout all of the diagrams again is well beyond what this is worth to me... :) > > It would be great to see another pass at this be done fully open so that various people could participate and share the load. To do so would require agreeing on some file formats at least, and possibly tools as well (which makes it difficult, at best). The eomodeld files that OFBiz exports are NOT diagram files, but can be imported into a diagramming tool. From there a diagram file can be exported and maintained going forward. > > BTW, for new and changed entities it is probably more work to redo the export and layout than it is to modify the diagram files, so creating the diagram file from the eomodeld files probably only needs to be done once. The output formats that I can do easily with OmniGraffle include: Visio XML, PICT Vector, SVG, EPS Vector, PDF Vector, and various rendered pixel/bit-map formats that are probably not of much use. BTW, just to note Visio XML is only supported by a limited number of tools and is not the same as the Visio binary files. The alternative would be to write some other export code to write the model in a different format. > > On a side note, there is some stuff to write eomodeld files for services as well (with ECAs joining the services together). > > -David > > > On Feb 7, 2010, at 2:35 PM, bsreekanth wrote: > > > Adrian, > > thanks for the feedback. the graph is generated from the database tables, > > and may have to look at how to do the same from xml schema definitions. the > > easiest to do would be explaining the sql and ofbiz data types, and how they > > maps. I can point to the configuration where it also shows how it differ for > > different databasses. > > thanks, > > babu > > -- > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Free forum by Nabble | Edit this page |