Re: Demo data : description and conversion to ext
thanks Hans.. the setup application indeed helped me to understand where to start with all the applications. Can you please tell me the roadmap for setup application. Is it complete with the intended functionalities, or extend to other components (eg: how to setup a project with work plan etc). thanks, Babu. From: Hans Bakker To: user@ofbiz.apache.org Sent: Tue, February 16, 2010 3:31:25 AM Subject: Re: Demo data : description and conversion to ext If you are looking for an absolute minimum setup you can use the "setup" application which is explained in the help screens and which will only show when only the seed data is loaded. The help screens however will always show in the help index. Regards, hans -- Antwebsystems.com: Quality OFBiz services for competitive rates On Tue, 2010-02-16 at 00:24 -0800, Babu Sreekanth wrote: > Hello, >In the Production Setup Guide, it is advised to load the demo data and > modify it for small installations. Also, one could go through all the demo > (reader) targets and adapt to the needs. I wonder anyone has this info > 1. A description of demo data ( the rationale for those entries) > 2. What are the minimum set of demo data needed to convert to ext? (GL, tax > entries) or all of these ext data could be created through UI. > thank you,\ > Babu. > > >
Re: UI error messages
Hello Hans, :-) .. I'm still learning the system, and hopefully would be able to contribute soon. When I see similar error, I would raise a JIRA issue and add to it. thanks, Babu. From: Hans Bakker To: user@ofbiz.apache.org Sent: Tue, February 16, 2010 3:33:25 AM Subject: Re: UI error messages Manual error messages need to be hand coded in the application. If that is not done you will get a message like you mentioned. So if you would like to contribute, there is a task for you here? Regards, Hans -- Antwebsystems.com: Quality OFBiz services for competitive rates On Tue, 2010-02-16 at 00:18 -0800, Babu Sreekanth wrote: > the actual cause for this error was missing preferredCurrencyUomId in party. > This happened because it is an optional field during party creation and/or it > was supposed to have a proper default for this attribute (in properties file > ??). I raised an issue for it. > https://issues.apache.org/jira/browse/OFBIZ-3482 > > But please respond to the actual question that whether should we display a > user friendly message on error? > > thanks, > \Babu. > > > > From: Babu Sreekanth > To: user@ofbiz.apache.org > Sent: Tue, February 16, 2010 1:53:04 AM > Subject: UI error messages > > Hello, >In quite few screens the sql error is displayed in the UI if an entity > operation results in error (esp. foreign key violation. One example, I > created an organization through Ofbiz Setup, and tried to create an invoice. > It shows a long exception message in the user screen (which is useful, but > more useful for a technical person. In that sense, it is available in the log > files). The reason could be easily seen in the log file. > > stack trace > --- > ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key > constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId). The statement has > been rolled back. > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) > > After a bit of debugging, I found the Party Accounting Preference needs to be > available (in UI, through Accounting --> ORG GL Settings --> setup). Do you > think it would be more useful for the user to have a text "The accounting > setup needs to be completed before " in the UI than the exception > message. I hope the end user also create parties etc. > Thanks, > Babu. > > >
Demo data : description and conversion to ext
Hello, In the Production Setup Guide, it is advised to load the demo data and modify it for small installations. Also, one could go through all the demo (reader) targets and adapt to the needs. I wonder anyone has this info 1. A description of demo data ( the rationale for those entries) 2. What are the minimum set of demo data needed to convert to ext? (GL, tax entries) or all of these ext data could be created through UI. thank you,\ Babu.
Re: UI error messages
the actual cause for this error was missing preferredCurrencyUomId in party. This happened because it is an optional field during party creation and/or it was supposed to have a proper default for this attribute (in properties file ??). I raised an issue for it. https://issues.apache.org/jira/browse/OFBIZ-3482 But please respond to the actual question that whether should we display a user friendly message on error? thanks, \Babu. From: Babu Sreekanth To: user@ofbiz.apache.org Sent: Tue, February 16, 2010 1:53:04 AM Subject: UI error messages Hello, In quite few screens the sql error is displayed in the UI if an entity operation results in error (esp. foreign key violation. One example, I created an organization through Ofbiz Setup, and tried to create an invoice. It shows a long exception message in the user screen (which is useful, but more useful for a technical person. In that sense, it is available in the log files). The reason could be easily seen in the log file. stack trace --- ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId). The statement has been rolled back. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) After a bit of debugging, I found the Party Accounting Preference needs to be available (in UI, through Accounting --> ORG GL Settings --> setup). Do you think it would be more useful for the user to have a text "The accounting setup needs to be completed before " in the UI than the exception message. I hope the end user also create parties etc. Thanks, Babu.
UI error messages
Hello, In quite few screens the sql error is displayed in the UI if an entity operation results in error (esp. foreign key violation. One example, I created an organization through Ofbiz Setup, and tried to create an invoice. It shows a long exception message in the user screen (which is useful, but more useful for a technical person. In that sense, it is available in the log files). The reason could be easily seen in the log file. stack trace --- ERROR 23503: INSERT on table 'INVOICE' caused a violation of foreign key constraint 'INVOICE_CUOM' for key (defaultCurrencyUomId). The statement has been rolled back. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) After a bit of debugging, I found the Party Accounting Preference needs to be available (in UI, through Accounting --> ORG GL Settings --> setup). Do you think it would be more useful for the user to have a text "The accounting setup needs to be completed before " in the UI than the exception message. I hope the end user also create parties etc. Thanks, Babu.
Re: Party ID during creation
Bilgin, thanks for the quick reply. I raised a JIRA issue for it, and think it is of priority critical. https://issues.apache.org/jira/browse/OFBIZ-3480 thanks, Babu. From: Bilgin Ibryam To: user@ofbiz.apache.org Sent: Sun, February 14, 2010 4:42:46 PM Subject: Re: Party ID during creation bsreekanth wrote: > Is it to prevent the user not to enter > the PK field with random text? The PK field in party creation service is validated for special characters and so on. So the user is actually allowed to try with random text. I think this field is simply missing in the UI. That's why you are not "allowed" to enter the id. > thanks, > Babu. > In addition to this, ofbiz display Ids in most of the forms ( and all the lookup fields). So it is very important to allow users to enter meaningful Ids, especially for data that it used for long period like partyId, facailityId, fixedAssetId, agreementId... So create forms should have an optional Id field (partyId, facilityId...) with a label saying that if an Id is not specified, the system will generate one. What do the others think about that? Bilgin
Issue with create category : Raising Jira issue
Hello, I found an issue with create category. The screen shot is attached. The scenario is. 1. Through the setup application (ofbiz setup), created an organization 2. Added Facility, Product store etc. and came to the last section 'First product" 3. Created a product catalog , then tried to create a category. It throws the below exception. A TRUNCATION ERROR WAS ENCOUNTERED TRYING TO SHRINK VARCHAR 'ABJ_CATALOG_PROMOTIONS' TO LENGTH 20. CALLING SERVICE CREATEPRODUCTCATEGORY IN CREATEPRODUCTCATEGORYANDADDTOPRODCATALOG The issue was on SVN trun, retrieved on 02/12/2010 (Yesterday). Well the error seems to occur when it try to shrink to fit into the 20 char table name. In the setup UI, there is no place to give the name for catalog promotion table. Do you think I should raise a Jira issue. I just created one related to ofbizsetup --> update contact . https://issues.apache.org/jira/browse/OFBIZ-3477 . I wanted to make sure I am following the practice to raise a bug. Do I need to discuss it in the group prior to create a JIRA ticket? Thanks, Babu.
Re: Party ID during creation
One additional detail. It is possible to specify Party ID through "Create organization" section of ofbizsetup app. But, then why it should not be the case through Party manager? From: bsreekanth To: user@ofbiz.apache.org Sent: Sat, February 13, 2010 4:46:13 PM Subject: Party ID during creation Hello, It is not possible to specify the party id through GUI while creating a Party (Person or Party Group). It gets the id through a sequence. At the same time, a meaningful name is used as id through seed data in all the demo purpose. So, what is the intention? Is it to prevent the user not to enter the PK field with random text? thanks, Babu. -- View this message in context: http://n4.nabble.com/Party-ID-during-creation-tp1554713p1554713.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)
Hello David, The page you added is correctly indexed to "Ofbiz Technical Documentation" --> "Data Model". If appropriate, please make the following corrections (which I don't have access to edit, I guess). 1. Remove following from the main "Ofbiz Documentation Index". a. General Documents --> Entity Overview . This is aptly availabe through "Ofbiz Technical Documentation" --> "Data Model" b. Data Model Documents and Diagrams . Please move this to "Ofbiz Technical Documentation" --> "Data Model" if it is still relevant, or remove it. 2. Add a link to "Ofbiz Technical Documentation" in "Ofbiz Documentation Index thanks, Babu. From: David E Jones To: user@ofbiz.apache.org Sent: Tue, February 9, 2010 1:39:32 AM Subject: Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki) The data model diagrams are now on cwiki, available on this page: http://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagrams Please note that because there is a 20MB limit for files on cwiki the version of the diagrams attached is split into a table of contents (TOC) and 4 files with different page ranges. If anyone hasn't taken a look at these yet I highly recommend that you do. They are a great resource for training as well as for discussions and reference during developments. I've had an older version of this document in my desk drawer for a couple of years now to use for easy reference. Enjoy! -David On Feb 8, 2010, at 11:23 PM, David E Jones wrote: > > For those looking at these the first time, the best file to choose is the > "AllDiagramsAndTOC_20081030.pdf" file. > > After reviewing these files we might want to move the PDF files to a cwiki > page and attach them to it, and eliminate them from SVN (they are rather > large, and being binary files can't benefit from revision management). I may > also go ahead and remove the eomodeld files since they aren't all that useful > any more, and are also fairly large (lots of files anyway). > > I'll be doing this soon in order to avoid all of these files ending up on the > web site on the next update. > > Answers inline... > > > > On Feb 8, 2010, at 10:44 PM, Babu Sreekanth wrote: > >> Ruppert, >> thanks for the documents. To update them, is it possible to post a quick >> writeup in wiki on >> >> 1. how to get (updated) emodeled files from ofbiz > > In the WebTools app there is a screen to export eomodeld files for different > entity groups (ie based on the records in the EntityGroup and related > entities). > >> 2. how to know the changes in data model from the creation of those files, >> and how to manually incorporate the changes > > There is no use in manually changing the eomodeld files, and I wouldn't > recommend creating new diagrams based on them either... it would be an > ENORMOUS amount of work. The finished diagrams you see are the result of > hundreds of hours of work (if I were to guess I'd say about 500 hours). > >> 3. software necessary for transformation into pdf documents in different >> platforms > > As I explained in an earlier message software for the eomodeld files only > exists in Mac OS X machines (AFAIK anyway). The problem we used for creating > these diagrams is called "OmniGraffle". The .graffle files that are needed to > change these diagrams are in SVN, in the > site/ofbiz_datamodel/graffle_diagrams directory. > > -David > > > >> >> From: Tim Ruppert >> To: user@ofbiz.apache.org >> Sent: Mon, February 8, 2010 9:47:13 PM >> Subject: Re: Data Model Diagrams (was Re: Key data model relationship pages >> in Wiki) >> >> Anytime my friend - anytime. >> >> Cheers, >> Ruppert >> -- >> Tim Ruppert >> HotWax Media >> http://www.hotwaxmedia.com >> >> o:801.649.6594 >> f:801.649.6595 >> >> On Feb 8, 2010, at 7:12 PM, David E Jones wrote: >> >>> >>> I just checked it out, and it looks good. >>> >>> Thanks again Tim. >>> >>> -David >>> >>> >>> On Feb 8, 2010, at 6:50 PM, Tim Ruppert wrote: >>> >>>> This is complete - under the site under the directory ofbiz_datamodel - >>>> just as it was in our repo. David, feel free to move that around wherever >>>> you like and give everyone a tour of the work that was put in and how much >>>> this may help them going forward. Great stuff. >>>> >&
Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)
Ruppert, thanks for the documents. To update them, is it possible to post a quick writeup in wiki on 1. how to get (updated) emodeled files from ofbiz 2. how to know the changes in data model from the creation of those files, and how to manually incorporate the changes 3. software necessary for transformation into pdf documents in different platforms thanks, Babu. From: Tim Ruppert To: user@ofbiz.apache.org Sent: Mon, February 8, 2010 9:47:13 PM Subject: Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki) Anytime my friend - anytime. Cheers, Ruppert -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Feb 8, 2010, at 7:12 PM, David E Jones wrote: > > I just checked it out, and it looks good. > > Thanks again Tim. > > -David > > > On Feb 8, 2010, at 6:50 PM, Tim Ruppert wrote: > >> This is complete - under the site under the directory ofbiz_datamodel - just >> as it was in our repo. David, feel free to move that around wherever you >> like and give everyone a tour of the work that was put in and how much this >> may help them going forward. Great stuff. >> >> Cheers, >> Ruppert >> -- >> Tim Ruppert >> HotWax Media >> http://www.hotwaxmedia.com >> >> o:801.649.6594 >> f:801.649.6595 >> >> On Feb 8, 2010, at 5:16 PM, David E Jones wrote: >> >>> >>> Cool, sounds great. >>> >>> -David >>> >>> >>> On Feb 8, 2010, at 6:08 PM, Tim Ruppert wrote: >>> Yeah - I think putting them into SVN would be best - I'll do that later today. Cheers, Ruppert On Feb 8, 2010, at 3:58 PM, David E Jones wrote: > > That's great Tim. Thank you to you, and to Hotwax, for making these > available. With all of the work on color and adding seed data and such > that Laurian did these are really great diagrams (well, I guess I am > biased about that). > > I guess the place that makes the most sense for now is attached to a page > on cwiki. If people start updating too much it might make sense to put > them in SVN somewhere, or maybe it would be better to start with that (in > the ofbiz/site directory would probably be best). > > -David > > > On Feb 8, 2010, at 11:03 AM, Tim Ruppert wrote: > >> HotWax would love to donate these and the time that went into them from >> David Jones, John Maw and Laurian Escalanti. It's a great set of >> information for people learning or using OFBiz - for those of you at >> ApacheCon New Orleans, we were handing these out at the booth. >> >> Be warned that they haven't been updated in about a year, but they do >> have a ton of useful information that will be an amazing jump start to >> getting these efforts started up again. David, just let me know where >> you'd like them and I'll get them posted and the effort can again be off >> to the races. >> >> Cheers, >> Ruppert >> -- >> Tim Ruppert >> HotWax Media >> http://www.hotwaxmedia.com >> >> o:801.649.6594 >> f:801.649.6595 >> >> On Feb 7, 2010, at 2:31 PM, David E Jones wrote: >> >>> 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). >> > >>> >> >
Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)
Matthieu, thank you very much for the info. I could able to use the tool, and it is quite impressive. I still need to discuss with the group what are the requirements for data model diagrams. I have some queries, which I would send to the list you given. thank you, Babu. From: Matthieu Bollot To: user@ofbiz.apache.org Sent: Sun, February 7, 2010 6:16:43 PM Subject: Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki) 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 ( neogia-de...@lists.sourceforge.net ) -- Matthieu BOLLOT www.nereide.biz
Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)
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, Babu. From: Erwan de FERRIERES To: user@ofbiz.apache.org Sent: Sun, February 7, 2010 4:49:38 PM Subject: Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki) 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