Re: Update Theme Data after being installed once (deleted stylesheets)
Thanks for the info. Is there an easy way to delete the whole theme with all theme ressources? Or at least multiple entries? Adrian Crum adrian.c...@sandglass-software.com schrieb: Use the Web Tools application to modify data. You can look up/edit/delete entity values, and load entity data via XML. -Adrian On 10/7/2012 9:09 PM, Andreas Allacher wrote: Hello, I would like to know: How do I update theme data after I had installed it already once? Normally I would do ./ant run-install-seed BUT for instance if I deleted a stylesheet - like e.g. first there were 3 and now there are 2, the stylesheet doesn't get deleted. However, if I change a stylesheet that works. Well, of course, this works fine after ./ant clean-data but that way ALL other data is lost too. Furthermore, is there anyway to update style data WITHOUT rebooting the server? Regards, Andreas Allacher
Re: Help me if you know-please
the standard way is to martial the data in groovy script that are called out(the new way) in a screen definition. you can find many examples of this in the code. The martialed data is then defined and passed to the screen where you define screenlets to define layout. I don't use SQL directly but define a entityview. Note: I sent this to the user ML so others that may approach this differently can respond. however if you want personalized help, I will be glad to consult for a fee with you. giridhar mungi sent the following on 10/7/2012 10:03 PM: Hi Freeman, Good day to you. my name is giridhar.Thanks for accepting for my connection request in linkedin. i have seen ur mail id in linkedin. I have doubt in Sql.please help me if you know. *TableName:stores* *storeid date price paymenttype* 101 Oct-0126Creditcard 101 Oct-0125Creditcard 101 Oct-0125Cash 101 Oct-0124Cash 101 Oct-0133Cash 101 Oct-0135Cash. This is the sample data.I want to display the total creditcard amount and total cash amount individually per date and storeid. if we want to display the creditcard,we can give like *select storeid,date,sum(price) as creditcardtotal from stores where paymenttype='creditcard'* *group by storeid,date*; if we want to display the cash total,we can give like *select storeid,date,sum(price) as cashtotal from stores where paymenttype='cash'* *group by storeid,date*; *How to display the total amounts of credit card and cash per storeid and date in a single query like, storeid datetotalcreditcardamount totalcashamount *please help me sir.* * Thanks Regards,, giridhar.
Re: Add comments on WorkEffortSkillStandard entity
Hi, We have in neogia addons repository some addons about project management (base on existing ofbiz project-phase-task portlet done by Ant System). Most of your requirements are cover. These addons will be migrate in ofbizextra to be more visible and more easy to install, but in my todo task, there are a lot of task before. You can have a first look in fttp://demo.neogia.org/consultantb2b Olivier Le 04/10/2012 20:26, Ted Byers a écrit : Hi Tom, On Thu, Oct 4, 2012 at 1:28 PM, Tom Burnstramseybu...@yahoo.com wrote: This is a reply to a subject on the dev list posted by Nicolas Malin. Hope no one gets too upset because I am replying here but I can't get on dev list (it only replies to any request with Remote host said: 552 spam score (7.5) exceeded threshold ) I, for one, am glad you resorted to posting it here, as the subject is of interest to me. Any way, Nicolas Malin asked for any thoughts about adding a comments field to the WorkEffortSkillStandard entity which associates a work effort with a skill. I have a thought for another few related extensions. First, there is, to my mind, a need for something like a track record. Let's take the task of writing code to support transaction processing through either a gateway or directly through a processing bank. You could have one programmer with 20 years experience, who has done it once, or another with 5 years experience who has done it a couple dozen times. If the latter had the details of his work stored in OFBiz (task assigned, time actually taken,c.), then we ought to be able to see the average time to complete the task decreasing nonlinearly (with each instance providing a diminiishing return wrt effectiveness at completing the task. I see this as potentially useful in terms of identifying continuing education requirements, and in assigning tasks to the most capable person, or the peson who needs the extra experience the most, depending on whatever other constraints may appkly in the situation. Related to this, is the task of estimating the effort required to complete a task or project. What I have seen so far (and I have been studying OFBiz, outside normal office hours, for only a few weeks), is that in workeffort one can enter an estimate of time required, but where that estimate comes from appears to be just a manager's guess. Based on my decades of experience in software engineering, such guesstimates are always wrong and, when made by marketing types rather than coders, excessively optimistic. What I would like is a tool that handles two things. One that facilitates funtional requirements analysis, which of course leads to a list of requirements, and then the second thing the tool needs to do is take the list of requirements and produce, from the workers' track records, an estimate of expected value of the time required for each task, along with it's upper 95% confidence limit. One deficiency I see in the work effort page is that there is no way to specify that certian quantities of consumables, from inventory, are required to complete the task (such as shingles used by a roofer, or wood, nails and screws used by a carpenter). Finally, I would like to be able to relate tsks that end up being required in support of warranty service to the original work effort that proved to be faulty, so that a statistical model can be estimated to relate need for, and cost of, warranty service to both workers doing the work and the supplies used, so that one can take suitable corrective action whether the deficincy is in the skills possessed by the labourers or in the quality of supllies provided by suppliers. Now, the question for you is, is any of this available now, and I just haven't found it yet, or does it all have to be developed (as I suspect - I will have to sort out what I will need to add to deal with the complexities involved in contrators, sub-contractors, day labourers and employees,c.)? Do you have any thoughts on how best to realize support for these ideas? I still have to navigate the OFBiz code, and refresh my memory on how Java/JSP/JSF programming is best handled (it has been a while). But perhaps you can point me to the directories and files I will need to examine first, and the relevant tables inthe DB. Thanks Ted
Inventory issue with Marketing Package:Auto
Hi, I am implementing marketing package product type. I have added a product of type MARKETING_PKG_AUTO and i also see it in the front-end. The issue is when i add the product to cart, inventory of the associated products is not getting decreased, although there is no error with the order creation. I was trying to see the demo ofbiz site for reference but it didn't show up the product(GZ-Basket). Please tell me what i am missing with and also give some references on this if available. Thanks, Jyoti Sharma. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Inventory-issue-with-Marketing-Package-Auto-tp4636776.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Add comments on WorkEffortSkillStandard entity
On Thu, Oct 4, 2012 at 6:00 PM, Tom Burns tramseybu...@yahoo.com wrote: Well if you follow my suggestions and you will reduce your reading by an order of magnitude! I understand that, and appreiate it; and I thank you. From: Ted Byers r.ted.by...@gmail.com To: user@ofbiz.apache.org; Tom Burns tramseybu...@yahoo.com Sent: Thursday, October 4, 2012 5:03 PM Subject: Re: Add comments on WorkEffortSkillStandard entity On Thu, Oct 4, 2012 at 3:51 PM, Tom Burns tramseybu...@yahoo.com wrote: Ted, You will not find everything you want OOB. I am not surprised at this. I recommend getting copy of The Data Model Resource Book: A Library of Universal Data Models for All Enterprises, Revised Edition, Volume 1 (see http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html). Study the chapters on Work Effort, People and Organizations, and Products. You will find entities in the model to support your requirements. OFBiz has over 850 entities that implement the books models OOB. In OFBiz study the Asset Maintenance, Manufacturing, Party, Project, SCRUM and Work Effort applications for inspiration on using the entities that touch on your problem. Thanks Tom, I have that book. ;-) In fact, it is one of three volumes, and I have all 3. But I haven't penetrated it very far yet. I was hoping to wade through it all faster, but there is a lot of code. Thanks Ted -- R.E.(Ted) Byers, Ph.D.,Ed.D. t...@merchantservicecorp.com CTO Merchant Services Corp. 17665 Leslie st., unit 30 Newmarket , Ontario L3Y 3E3
Re: Add comments on WorkEffortSkillStandard entity
On Mon, Oct 8, 2012 at 6:25 AM, olivier Heintz olivier.hei...@neogia.orgwrote: Hi, We have in neogia addons repository some addons about project management (base on existing ofbiz project-phase-task portlet done by Ant System). Most of your requirements are cover. These addons will be migrate in ofbizextra to be more visible and more easy to install, but in my todo task, there are a lot of task before. You can have a first look in fttp://demo.neogia.org/**consultantb2bhttp://demo.neogia.org/consultantb2b Olivier Hi Oliver Thanks. That is interesting. Do you have a timeline when they will be migrated to ofbizextra, so I can see the code, and do a gap analysis to determine precisely what else I may need to add? Thanks Ted
Create product content type / attribute groups
Hello, for my products I require attributes or content types that contain multiple attributes / content types (I would also like to specify the datatype like e.g. integer, I saw that there is such an option for attributes but I do not know WHAT I can specify there and if it changes anything). What I mean with product attribute groups would be something like: I have an attribute called technical specifications which then has attributes like width, height, weight, ... Is the only way to create the attributes with prefixes and group them using those? Or can I create a link to a foreign table or something like this? Regards, Andreas Allacher
Problems with jackrabbit configuration and remote MySql database
I'm trying to configure jackrabbit to work with a remote mysql database. I have changed JackRabbit to work with MySql instead of the default derby by adding a Versioning and Workspace configuration for mysql. This same configuration works on a local mysql database (ofbiz and mysql on same machine), but now when I try to access the remote database I get a connection failure. The same mysql configuration is working for ofbiz because I can correctly create the database tables and seed them with the following ant builds: ant run-install ant run-install-seed But using the same MySql configuration attributes for host, user, and password I get the the following error: 20411 [main] ERROR org.apache.jackrabbit.core.RepositoryImpl - Failed to initialize workspace 'default' javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager at org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1346) at org.apache.jackrabbit.core.RepositoryImpl.access$300(RepositoryImpl.java:124) at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2011) at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1994) at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:510) at org.apache.jackrabbit.core.RepositoryImpl.init(RepositoryImpl.java:318) I'm not using the standard 'ofbiz' database name. Would that be a possible problem? Are there other configuration files I am missing to setup jackrabbit? I've only edited the ofbiz/framework/jcr/config/jackrabbit.xml file for this mysql change. Thanks in advance for your help. Brett On Mon, Feb 20, 2012 at 2:34 AM, m...@javafreedom.org wrote: Hi Brett, let me guess, you have changed the Database to not use derby, right? There was already a short discussion concerning this one here on the list. The solution is rather simple, in that you need to change the jackrabbit.xml file in framework\jcr\config\ to use your database. E.g.: PersistenceManager class=org.apache.jackrabbit.** core.persistence.bundle.**PostgreSQLPersistenceManager param name=driver value=org.postgresql.Driver/** param name=url value=jdbc:postgresql://10.** 202.10.80:5432/ofbizcms http://10.202.10.80:5432/ofbizcms / param name=schema value=postgresql /!-- warning, this is not the schema name, it's the db type -- param name=user value=ofbiz / param name=password value=ofbiz / param name=schemaObjectPrefix value=${wsp.name}_ / param name=externalBLOBs value=false / /PersistenceManager Adopt this for both, the Versioning (Tag: Versioning) as well as for the Workspace (Tag: Workspace). Hope this helps. R, Markus On Mon, 20 Feb 2012 01:16:49 -0700, Brett Palmer wrote: This is probably an easy question, but its been a while since we updated our ofbiz version. We are trying to update to the latest version from the trunk to determine what changes we need to make to our code. When I start ofbiz after setting up the database and build, I get a JCR LoginException and then ofbiz shuts down. Is JackRabbit now required to run ofbiz? If so are there some other setup steps that I need to perform? Thanks in advance for your help. Brett Here is the stack trace: dispatcher [auth-dispatcher] (main)^M 2012-02-20 00:57:42,294 (main) [ JCRFactoryImpl.java:159:ERROR] ^M exception report --** Exception: javax.jcr.LoginException Message: LoginModule could not perform authentication: null cause --**--**- Exception: javax.security.auth.login.**LoginException Message: LoginModule could not perform authentication: null cause --**--**- Exception: java.lang.NullPointerException Message: null stack trace --**--**--- java.lang.NullPointerException org.ofbiz.jcr.loader.**OFBizLoginModule.login(** OFBizLoginModule.java:114) org.apache.jackrabbit.core.**security.authentication.** LocalAuthContext.login(LocalA uthContext.java:86) org.apache.jackrabbit.core.**RepositoryImpl.login(** RepositoryImpl.java:1458) org.apache.jackrabbit.core.**TransientRepository.login(** TransientRepository.java:38 1) org.apache.jackrabbit.commons.**AbstractRepository.login(** AbstractRepository.java:1 23) org.ofbiz.jcr.loader.**jackrabbit.JCRFactoryImpl.** createSession(JCRFactoryImpl.**java :146) org.ofbiz.jcr.loader.**jackrabbit.JCRFactoryImpl.** start(JCRFactoryImpl.java:100) org.ofbiz.jcr.loader.**JCRContainer.start(**JCRContainer.java:129) org.ofbiz.base.container.**ContainerLoader.start(**
Re: Problems with jackrabbit configuration and remote MySql database
I found the error. I was using a previous copy of ofbiz from another environment. The configuration is copied at run time to runtime/data/jcr directory. It was picking up an old configuration. I had run clean but this was not clearing out these directories. I deleted the data/jcr directory and restarted the server and everything came up all right after that. Brett On Mon, Oct 8, 2012 at 10:43 AM, Brett Palmer brettgpal...@gmail.comwrote: I'm trying to configure jackrabbit to work with a remote mysql database. I have changed JackRabbit to work with MySql instead of the default derby by adding a Versioning and Workspace configuration for mysql. This same configuration works on a local mysql database (ofbiz and mysql on same machine), but now when I try to access the remote database I get a connection failure. The same mysql configuration is working for ofbiz because I can correctly create the database tables and seed them with the following ant builds: ant run-install ant run-install-seed But using the same MySql configuration attributes for host, user, and password I get the the following error: 20411 [main] ERROR org.apache.jackrabbit.core.RepositoryImpl - Failed to initialize workspace 'default' javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager at org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1346) at org.apache.jackrabbit.core.RepositoryImpl.access$300(RepositoryImpl.java:124) at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2011) at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1994) at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:510) at org.apache.jackrabbit.core.RepositoryImpl.init(RepositoryImpl.java:318) I'm not using the standard 'ofbiz' database name. Would that be a possible problem? Are there other configuration files I am missing to setup jackrabbit? I've only edited the ofbiz/framework/jcr/config/jackrabbit.xml file for this mysql change. Thanks in advance for your help. Brett On Mon, Feb 20, 2012 at 2:34 AM, m...@javafreedom.org wrote: Hi Brett, let me guess, you have changed the Database to not use derby, right? There was already a short discussion concerning this one here on the list. The solution is rather simple, in that you need to change the jackrabbit.xml file in framework\jcr\config\ to use your database. E.g.: PersistenceManager class=org.apache.jackrabbit.** core.persistence.bundle.**PostgreSQLPersistenceManager param name=driver value=org.postgresql.Driver/** param name=url value=jdbc:postgresql://10.** 202.10.80:5432/ofbizcms http://10.202.10.80:5432/ofbizcms / param name=schema value=postgresql /!-- warning, this is not the schema name, it's the db type -- param name=user value=ofbiz / param name=password value=ofbiz / param name=schemaObjectPrefix value=${wsp.name}_ / param name=externalBLOBs value=false / /PersistenceManager Adopt this for both, the Versioning (Tag: Versioning) as well as for the Workspace (Tag: Workspace). Hope this helps. R, Markus On Mon, 20 Feb 2012 01:16:49 -0700, Brett Palmer wrote: This is probably an easy question, but its been a while since we updated our ofbiz version. We are trying to update to the latest version from the trunk to determine what changes we need to make to our code. When I start ofbiz after setting up the database and build, I get a JCR LoginException and then ofbiz shuts down. Is JackRabbit now required to run ofbiz? If so are there some other setup steps that I need to perform? Thanks in advance for your help. Brett Here is the stack trace: dispatcher [auth-dispatcher] (main)^M 2012-02-20 00:57:42,294 (main) [ JCRFactoryImpl.java:159:ERROR] ^M exception report --** Exception: javax.jcr.LoginException Message: LoginModule could not perform authentication: null cause --**--** - Exception: javax.security.auth.login.**LoginException Message: LoginModule could not perform authentication: null cause --**--** - Exception: java.lang.NullPointerException Message: null stack trace --**--**--- java.lang.NullPointerException org.ofbiz.jcr.loader.**OFBizLoginModule.login(** OFBizLoginModule.java:114) org.apache.jackrabbit.core.**security.authentication.** LocalAuthContext.login(LocalA uthContext.java:86) org.apache.jackrabbit.core.**RepositoryImpl.login(** RepositoryImpl.java:1458)
RE: OsWorkflow Integration
Hello All, I am trying Integrate osworkflow but not getting success due to some configuration missing. 1. I have added src code from osuser,oscore and osworkflow to new component. 2. I had put xml configuration files in META-INF after customizing osworkflow.xml like: osworkflow persistence class=com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore / factory class=com.opensymphony.workflow.loader.URLWorkflowFactory property key=cache value=true / property key=resource value=workflows.xml / /factory /osworkflow and osuser.xml like opensymphony-user provider class=com.opensymphony.user.provider.ofbiz.OFBizAccessProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizCredentialsProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizProfileProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider / /opensymphony-user but getting error 2012-10-09 00:33:10,531 (http-0.0.0.0-8443-1) [ UserManager.java:132:ERROR] unexpected runtime exception during initialization java.lang.RuntimeException: org/ofbiz/core/entity/GenericEntityException at com.opensymphony.user.util.ConfigLoader.load(ConfigLoader.java:76) at com.opensymphony.user.UserManager.init(UserManager.java:108) at com.opensymphony.user.UserManager.init(UserManager.java:60) at com.opensymphony.user.UserManager.getInstance(UserManager.java:127) when I am trying to execute this line in my code UserManager um = UserManager.getInstance(); Please let me know if you have something for me. Regards A Walia -- View this message in context: http://ofbiz.135035.n4.nabble.com/OsWorkflow-Integration-tp162418p4636787.html Sent from the OFBiz - User mailing list archive at Nabble.com.
osworkflow integration configuration problem
Hello All, I am trying Integrate osworkflow but not getting success due to some configuration missing. 1. I have added src code from osuser,oscore and osworkflow to new component. 2. I had put xml configuration files in META-INF after customizing osworkflow.xml like: osworkflow persistence class=com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore / factory class=com.opensymphony.workflow.loader.URLWorkflowFactory property key=cache value=true / property key=resource value=workflows.xml / /factory /osworkflow and osuser.xml like opensymphony-user provider class=com.opensymphony.user.provider.ofbiz.OFBizAccessProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizCredentialsProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizProfileProvider / provider class=com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider / /opensymphony-user but getting error 2012-10-09 00:33:10,531 (http-0.0.0.0-8443-1) [ UserManager.java:132:ERROR] unexpected runtime exception during initialization java.lang.RuntimeException: org/ofbiz/core/entity/GenericEntityException at com.opensymphony.user.util.ConfigLoader.load(ConfigLoader.java:76) at com.opensymphony.user.UserManager.init(UserManager.java:108) at com.opensymphony.user.UserManager.init(UserManager.java:60) at com.opensymphony.user.UserManager.getInstance(UserManager.java:127) when I am trying to execute this line in my code UserManager um = UserManager.getInstance(); Please let me know if you have something for me. Regards A Walia -- View this message in context: http://ofbiz.135035.n4.nabble.com/osworkflow-integration-configuration-problem-tp4636789.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Revision of product
Seems like I am asking very boring question that no one seems to respond Please, point to some clues... I need to find if/how Ofbiz can handle multiple Product revisions. Thanks and Regards, Parminder Lehal On Fri, Oct 5, 2012 at 4:26 PM, Parm Lehal parmle...@gmail.com wrote: Hello Ofbiz experts, Is there any way to have multiple revisions of a product in Ofbiz? If yes, then how is it handled on the BOM side, if one revision is being phased out on a certain date and next one being brought in? Thanks and Regards, Parminder Lehal
anyone interesting in co-hosting ofbiz with me.
I have some free Dell 1950s in a data center, I would like to host OfBiz. Would anyone be interested in doing some co-hosting venture with me. I more confortable marketing, I'm looking for someone with technical expertise with OfBiz. Paul