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 babu.sreeka...@yahoo.com 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
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 mailingl...@antwebsystems.com 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 babu.sreeka...@yahoo.com 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.
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 mailingl...@antwebsystems.com 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: 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 bibr...@gmail.com 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
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
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 babu.sreeka...@yahoo.com 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.
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: 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 erwan.de-ferrie...@nereide.fr 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
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 matthieu.bol...@nereide.biz 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
