Re: is compile and ofbiz restart still needed for java changes?
Hi Bob, The mocking code sounds great. Would you be happy to share? Bob Morley wrote: We typically execute Ofbiz from Eclipse and some people have reported that the hot-swapping works fairly well. (Usually we do not run an ant build until right before check-in and then just to ensure we are compiling and avoiding classpath issues). The approach I often take is to write my unit test in conjunction with the service implementation I am working on. I have added some mocking capabilities in our Ofbiz installation, so I can avoid starting up the container at all and still exercise all of the logic in the service method. Result is usually a sub-second unit test. Naturally an integration test would require container start-up and a reasonably heavy penalty. Another approach others have used is to write the service method in groovy and once working convert this into java. From memory there is really only a single sample of a groovy implemented service, and when I went to do there there was at least one bug I had to resolve. But this is a feasible way and the groovy is quite a bit like java. :) - Bob Ruth Hoffman-2 wrote: Hi Chris: I guess I'm just use to the inconvenience. :-( The other thing I do to try and minimize restart time is to comment out the components I might not be using. Ruth -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25019021.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: problem Running with MS-SQL
Actually, I think I had a similar problem: http://www.nabble.com/Violation-of-PRIMARY-KEY-constraint-%27PK_SERVER_HIT%27.-Cannot-insert-duplicate-key-in-object-%27ofbiz.SERVER_HIT%27-tp23479493p23479493.html Weixue Zhang wrote: I am using ms sql server 2005 and this problem had bothered me for long time. At last I found it was caused by a few unique indices of some tables (You can find them by searching with unique=true in files entitymodel.xml). After I changed them into unique=false, demo data works fine. Can anybody explain why this problem doesn't exist with other database servers, and why we need to set unique=true at some indices while most others are unique=false? -- View this message in context: http://www.nabble.com/problem-Running-with-MS-SQL-tp24895969p25019038.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Database description
Hi; Can any one tell how I can find the description of the database.. I wan to know the role of each table. With Regards, Manish.K www.cevalsoft.com Go Green Print only when necessary.
Re: Database description
Look for Model in wiki Jacques From: manish manish.krish...@cevalsoft.com Hi; Can any one tell how I can find the description of the database.. I wan to know the role of each table. With Regards, Manish.K www.cevalsoft.com Go Green Print only when necessary.
Re: Database description
I found the Data Model Resource book Volume 1 to be very useful: http://docs.ofbiz.org/x/QQg manish-25 wrote: Hi; Can any one tell how I can find the description of the database.. I wan to know the role of each table. With Regards, Manish.K www.cevalsoft.com Go Green Print only when necessary. -- View this message in context: http://www.nabble.com/problem-Running-with-MS-SQL-tp24895969p25019800.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: is compile and ofbiz restart still needed for java changes?
+1 - would be super helpful. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 12:05 AM, snowc wrote: Hi Bob, The mocking code sounds great. Would you be happy to share? Bob Morley wrote: We typically execute Ofbiz from Eclipse and some people have reported that the hot-swapping works fairly well. (Usually we do not run an ant build until right before check-in and then just to ensure we are compiling and avoiding classpath issues). The approach I often take is to write my unit test in conjunction with the service implementation I am working on. I have added some mocking capabilities in our Ofbiz installation, so I can avoid starting up the container at all and still exercise all of the logic in the service method. Result is usually a sub-second unit test. Naturally an integration test would require container start-up and a reasonably heavy penalty. Another approach others have used is to write the service method in groovy and once working convert this into java. From memory there is really only a single sample of a groovy implemented service, and when I went to do there there was at least one bug I had to resolve. But this is a feasible way and the groovy is quite a bit like java. :) - Bob Ruth Hoffman-2 wrote: Hi Chris: I guess I'm just use to the inconvenience. :-( The other thing I do to try and minimize restart time is to comment out the components I might not be using. Ruth -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25019021.html Sent from the OFBiz - User mailing list archive at Nabble.com. smime.p7s Description: S/MIME cryptographic signature
Re: entity condition expression problem
So close, yet so far... I simplified my problem description. Actually, the complex-alias needed was: alias name=amountDue complex-alias operator=- complex-alias-field entity-alias=SalvageAmounts field=calculatedSalvageGross/ complex-alias-field entity-alias=VehiclePaymentSummaryView field=vehiclePaymentTotalAmount/ /complex-alias /alias Where: - SalvageAmounts is an entity that sits on top of a database view, not a table. - VehiclePaymentSummaryView is a view-entity with an aggregate function. Running the report results in the error: exception report -- Failure in by condition find operation, rolling back transaction Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT Uplift.ingUplNumber, Uplift.strUplInsurer, Uplift.dtmUplPickupDate, VehiclePaymentSummaryView.SUM_Ve hiclePayment_ingAmount_, UpliftFlags.strFlag, UpliftFlags.blnAgreed, UpliftFlags .blnReviewed, SalvageAmounts.upliftPAVBand, SalvageAmounts.ingPercentage, Salvag eAmounts.calculatedSalvageNet, SalvageAmounts.calculatedSalvageVat, SalvageAmoun ts.calculatedSalvageGross, (SalvageAmounts.calculatedSalvageGross - VehiclePayme ntSummaryView.SUM(VehiclePayment.ingAmount)) FROM ((dbo.tblUplift Uplift LEFT OU TER JOIN (SELECT Uplift.ingUplNumber AS Uplift_ingUplNumber, SUM(VehiclePayment. ingAmount) AS SUM_VehiclePayment_ingAmount_ FROM dbo.tblUplift Uplift LEFT OUTER JOIN dbo.tblVehiclePayment VehiclePayment ON Uplift.ingUplNumber = VehiclePayme nt.ingUpliftNumber GROUP BY Uplift.ingUplNumber) VehiclePaymentSummaryView ON Up lift.ingUplNumber = VehiclePaymentSummaryView.Uplift_ingUplNumber) INNER JOIN db o.tblUpliftFlags UpliftFlags ON Uplift.ingUplNumber = UpliftFlags.ingUplift) INN ER JOIN dbo.vSalvageAmounts SalvageAmounts ON Uplift.ingUplNumber = SalvageAmoun ts.ingUplNumber WHERE (Uplift.ingUplNumber ? AND UpliftFlags.strFlag = ? AND U pliftFlags.blnAgreed = ? AND UpliftFlags.blnReviewed = ? AND Uplift.dtmUplPickup Date IS NOT NULL) (Cannot find either column VehiclePaymentSummaryView or the user-defined function or aggregate VehiclePaymentSummaryView.SUM, or the name is ambiguous.) -- I think I will push my logic back into a database view. I find that using pure entity and view-entity does not have the power needed to work with some legacy data designs. For example other posts have mentioned wanting to specify join conditions in view-link's which would be very useful. Many thanks, Chris Bob Morley wrote: I think I would create a view-entity that aliased all of the fields you have here and added a complex-alias for the difference of the actual and estimated net amounts. Something like -- alias name=actualEstimatedDelta complex-alias operator=- complex-alias-field entity-alias=E1 field=actualNetAmount/ complex-alias-field entity-alias=E1 field=estimatedNetAmount/ /complex-alias /alias Then do your entity condition on this field in your v-e. condition-expr field=actualEstimatedDelta operator=greater value=0/ Bob snowc wrote: I have some legacy data that I am trying to access in ofbiz. entity name=E1 field name=e1ID/ field name=actualNetAmount/ field name=estimatedNetAmount/ /entity Conceptually, I want to filter as shown here: SELECT e1Id, actualNetAmount, estimatedNetAmount FROM E1 WHERE actualNetAmount estimatedNetAmount entity-condition entity=E1 condition-expr field=actualNetAmount operator=greater value=${this.estimatedNetAmount}/ /entity-condition How can I achieve the equivalent of this is a entity condition expression? I do not want to filter by iterating the list as the data volumes are huge. One option I am thinking of is to create a SQL view and use that to filter the data: SELECT e1Id, actualNetAmount, estimatedNetAmount, CASE WHEN actualNetAmount estimatedNetAmount THEN 1 ELSE 0 END CASE AS actualGTEstimated FROM E1 Maybe I could use DynamicViewEntities, but I was trying to use less beanshell/java and more minilang. Many thanks in advance, Chris -- View this message in context: http://www.nabble.com/entity-condition-expression-problem-tp25010865p25020621.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: DB field name definition
Done http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices#OFBizContributorsBestPractices-NamingEntities Jacques From: Ashish Vijaywargiya vijaywargiya.ash...@gmail.com +1 on Jacques comment. And thanks a lot Rishi for such a nice explaination. -- Ashish On Fri, May 29, 2009 at 6:48 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Thanks Rishi, I don't know if there is already a such description in wiki, if not we may add it in Contributor Best Practices... Jacques From: Rishi Solanki rishisolan...@gmail.com Hi Ravi, Here are some rules or say patterns which are common for defining any entity. - Entity name must be in UpperCamelCase. - If entity name is abbreviation like Unit Od Measure (UOM) then treat it as one word and name is like Uom. - The Field name must be in lowerCamelCase and name should be self descriptive enough to show the purpose of the field. - If relation tag specify the relationship between two entities then the fk-name should contains the words from both entities separated by (_) underscore. - If a entity relation with another entity defines more than one time then it should be differentiated by title attribute while defining a relation like Form or To. - In the same if both field in the key-map tag are same then no need to specify rel-field-name. - In case of view entities the name will consists of name of all its member entities. - The view-link should be define for the proper view in the webtools. Apart from the above you can also refer to entitymodel.xsd for understanding the tags. And you can find several examples as given by Parimal is PostalAddress matches your requirement. Posted all the basic scenarios for defining the entity may I missed any, Hope the above notes helps you. -- Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd.
Re: Ecommrce login on demo goes to hotwax
It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: Ecommrce login on demo goes to hotwax
This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. smime.p7s Description: S/MIME cryptographic signature
Re: Ecommrce login on demo goes to hotwax
now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
configuring products for a jewelery store
Hi, Following is the requirement for a jewelery that store sells bracelets. How do I configure and get the final price of the bracelet. * Input the weight of the bracelet in gms * Add extra weight called wastage. For example 10% of the weight of the bracelet * The value of the bracelet is dependent on the weight of the bracelet * Add making charges to the bracelet Example for the price calculation: Cost per gm of gold = $32 Weight of the bracelet = 10 gms Extraweight(wastage) that needs to be added = 10 * 0.1 = 1 Making charges = $100. Final price = (weight + wastage) * cost/gm + makingcharges. Final prices = (10 + 1) * 32 + 100 = $452. Is this possible to configure OOTB Thanks -Aswath
Re: product hierarchies
Hi Chris: I would try something like this: Product: productId = StockNum[E320C] productName= Engine, facilityId = my back yard |- ProductFeature name = condition, FeatureValue = new |- ProductFeature name= model, FeatureValue = Volvo |- ProductFeature name=make, FeatureValue = X Product: productId = StockNum[DEF234], productName=Engine, faclityId=lot 10 |- ProductFeature name=condition, FeatureValue=engine seized, will not start |- ProductFeature model, FeatureValue=Toyota |- ProductFeature make, FeatureValue=Camery |- ProductFeature model_year, FeatureValue=1996 ... Your virtual product is Engine and your variants are the physical products: StockNums [E320C] and [DEF234]. Then you can decide how each variant is associated with the virtual product. For example, you can associate by the make, model, condition or year. Or perhaps all four. I don't have time to try this out right now. But, you could try building a couple of these with the Catalog Manager and seeing how they would render (by default) on the ecommerce website. See if you can get the desired result. If I get a chance in the next day or so, I'll see if I can't try it. You may need to create some new feature types like condition. Regards, Ruth snowc wrote: Hi Ruth, The stock number that is allocated is shared by all components of the vehicle. Therefore, the product ID would probably be a manufacturer identifier, e.g. E320C for a specific engine type. For an item of stock such as the engine E320C. The description and photos would be for the product, but each inventory item would probably need additional comments relating to the specific item. For example: Product: Engine[E320C] |-Inventory Item StockNum[ABC123] - condition new |-Inventory Item StockNum[DEF234] - engine seized. will not start. Would this type of structure work for virtual products? E.g. the Engine E320C is the virtual product. But Engine StockNum[ABC123] and Engine StockNum[DEF234] are the actual physical products with inventory items? Many thanks in advance, Chris. Ruth Hoffman-2 wrote: Thanks. Please keep us posted. Ruth snowc wrote: Hi Ruth, Please feel free to use this as an example. I have some more information to follow later... Many thanks, Chris Ruth Hoffman-2 wrote: Hi Chris: Quick answer and MHO would be as follows (and I'm hardly an expert on this, so others, feel free to chime in): snowc wrote: Hi Ruth, When a vehicle is received, they would like to book the vehicle and each of it's main components (Engine, Gearbox, Axles, Body, Etc) into stock: Vehicle (e.g. StockRef[ABC123] Make[Volvo] Model[F10] Type[4x2 TU] Year[2000]) |- Engine (e.g. ModelId[400E34]) |- Gearbox (e.g. ModelId[5206B]) |- Etc Vehicle (e.g. StockRef[ABC234] Make[Ford] Model[Escort] Type[Sedan] Year[1985]) |- Engine (e.g. ModelId[231AA]) |- Gearbox (e.g. ModelId[345BB]) |- Etc When the vehicle is received whole, the component locations will be the same as the vehicle location. However, when broken, the individual components locations will be different. The customer would like to be able to answer customer enquiries such as: Do you have any Ford Escort engines (model 231AA) in stock?. The customer would like to also list all stock (vehicle and components) on their website. They do not want ecommerce cart, just a list of available stock. I think I can maybe model the relationship between the vehicle and component as associations, e.g.: Engine (StockRef[231AA]) is an Actual Product Component of Vehicle (StockRef[ABC234]) Does this relationship make sense? Yes. Here is my reasoning: Since you want to track and list major components as entities separate from their source - a vehicle, I think both the vehicle and each of the major components that you want to track are PRODUCTS. The productID could be the StockRef# or VIN depending on the item (since I don't think gear boxes have VINs?). Then, for browsing (and tracking) purposes you could create one or more product associations (bundles) so that an engine (StockRef#/VIN, facilityID=still in the vehicle) may be associated with a vehicle (with stockref #/VIN, facilityId = sitting on back lot) and a gearbox (with stockref #, facilityId = building 10, shelf 2) may be associated with a vehicle etc. You could even have categories set up to just show gear boxes (as products) or entire vehicles. So, without actually trying this out with some test data, I can't really say if it would work exactly as you envision. [if you don't mind I'd like to use something like this example in the book since, as of today, I don't really talk much about product associations. This would be a great use-case.] For storing the attibutes such as make, model, year would feature be the best way? For example, if I create a feature hierarchy: Make (E.g. Ford) | - Model (e.g. Escort) I would also create a feature group for each Make/Model
Re: is compile and ofbiz restart still needed for java changes?
Hi Bob: Yes, I forgot. Its been a while since I've done any hardcore development. I also write as much of what I can in the Bean Shell (I haven't converted to Groovy yet. :-( Once I get things working, I convert to Java. That does save lots of time :-) Ruth Bob Morley wrote: We typically execute Ofbiz from Eclipse and some people have reported that the hot-swapping works fairly well. (Usually we do not run an ant build until right before check-in and then just to ensure we are compiling and avoiding classpath issues). The approach I often take is to write my unit test in conjunction with the service implementation I am working on. I have added some mocking capabilities in our Ofbiz installation, so I can avoid starting up the container at all and still exercise all of the logic in the service method. Result is usually a sub-second unit test. Naturally an integration test would require container start-up and a reasonably heavy penalty. Another approach others have used is to write the service method in groovy and once working convert this into java. From memory there is really only a single sample of a groovy implemented service, and when I went to do there there was at least one bug I had to resolve. But this is a feasible way and the groovy is quite a bit like java. :) - Bob Ruth Hoffman-2 wrote: Hi Chris: I guess I'm just use to the inconvenience. :-( The other thing I do to try and minimize restart time is to comment out the components I might not be using. Ruth
Re: DB field name definition
Thank you Jacques, I go thru it, and try to edit the docs but I think do not have the permission to edit others documentations. Here are some more points and changes to do ; - Change the Unit Od Measure -- Unit Of Measure. - Entity name should not be more then 30 letters. - Field name should not be more then 128 letters. - fk-name should not be more then 18 letters. I got these information from Ashish Vijaywargiya, and think the above points should be added. Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Aug 18, 2009 at 4:00 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Done http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices#OFBizContributorsBestPractices-NamingEntities Jacques From: Ashish Vijaywargiya vijaywargiya.ash...@gmail.com +1 on Jacques comment. And thanks a lot Rishi for such a nice explaination. -- Ashish On Fri, May 29, 2009 at 6:48 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Thanks Rishi, I don't know if there is already a such description in wiki, if not we may add it in Contributor Best Practices... Jacques From: Rishi Solanki rishisolan...@gmail.com Hi Ravi, Here are some rules or say patterns which are common for defining any entity. - Entity name must be in UpperCamelCase. - If entity name is abbreviation like Unit Od Measure (UOM) then treat it as one word and name is like Uom. - The Field name must be in lowerCamelCase and name should be self descriptive enough to show the purpose of the field. - If relation tag specify the relationship between two entities then the fk-name should contains the words from both entities separated by (_) underscore. - If a entity relation with another entity defines more than one time then it should be differentiated by title attribute while defining a relation like Form or To. - In the same if both field in the key-map tag are same then no need to specify rel-field-name. - In case of view entities the name will consists of name of all its member entities. - The view-link should be define for the proper view in the webtools. Apart from the above you can also refer to entitymodel.xsd for understanding the tags. And you can find several examples as given by Parimal is PostalAddress matches your requirement. Posted all the basic scenarios for defining the entity may I missed any, Hope the above notes helps you. -- Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd.
TaxAuthority Entity
Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: TaxAuthority Entity
Hi su2, If you see the records in the party entity of the same party, they all are of type PartyGroups in role of TAX_AUTHORITY. Here the partyId field (pk in Party entity) is self explain its purpose, The first half is the state name and another half is the company name (not exactly but we can say). Now the key says that company in which state. If you see the relationship of the TaxAuthority then its PK is composite key of the geoId and partyId from the Geo and Party entity. Finally we can say that, These are the partyIds which are doing business in particular state. Hope it helps !!! Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Aug 18, 2009 at 6:59 PM, su2 shu...@pexsupply.com wrote: Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: TaxAuthority Entity
Any other view Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Aug 18, 2009 at 7:51 PM, Rishi Solanki rishisolan...@gmail.comwrote: Hi su2, If you see the records in the party entity of the same party, they all are of type PartyGroups in role of TAX_AUTHORITY. Here the partyId field (pk in Party entity) is self explain its purpose, The first half is the state name and another half is the company name (not exactly but we can say). Now the key says that company in which state. If you see the relationship of the TaxAuthority then its PK is composite key of the geoId and partyId from the Geo and Party entity. Finally we can say that, These are the partyIds which are doing business in particular state. Hope it helps !!! Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Aug 18, 2009 at 6:59 PM, su2 shu...@pexsupply.com wrote: Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Ecommrce login on demo goes to hotwax
I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: TaxAuthority Entity
Shuchi, The field you are talking about is taxAuthPartyId. So, NY_DTF, CA_BOE and UT_TAXMAN are partyId's for PartyGroups corresponding to the Government entity responsibly for taxation in that particular state. For example, the government entity which does taxation in New York (NY) is Department of Tax and Finance (DTF), which explains the term NY_DTF. Similarly, Board of Equalization (BOE) is responsible for taxation in California (CA), hence CA_BOE. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Tue, Aug 18, 2009 at 6:59 PM, su2 shu...@pexsupply.com wrote: Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: TaxAuthority Entity
Hi Rishi, Thank you for your explanation. So that means let say I create/change NY partyID in Party Entity from NY_DTF to NY_ABC, and changing taxAuthPartyId in TaxAuthority entitiy to NY_ABC, there should not be any issue right? (what I understood is, its just the matter of how we name partyID in Party Entity. Correct?) Thanks. su- Rishi Solanki wrote: Hi su2, If you see the records in the party entity of the same party, they all are of type PartyGroups in role of TAX_AUTHORITY. Here the partyId field (pk in Party entity) is self explain its purpose, The first half is the state name and another half is the company name (not exactly but we can say). Now the key says that company in which state. If you see the relationship of the TaxAuthority then its PK is composite key of the geoId and partyId from the Geo and Party entity. Finally we can say that, These are the partyIds which are doing business in particular state. Hope it helps !!! Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Aug 18, 2009 at 6:59 PM, su2 shu...@pexsupply.com wrote: Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25026542.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Ecommrce login on demo goes to hotwax
That link works for me. -Adrian Tim Ruppert wrote: I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: TaxAuthority Entity
Perfect Mridul, Thank you so much. It is clear now. And I suppose for other states its TAXMAN as generic name. Thank you. Mridul Pathak-2 wrote: Shuchi, The field you are talking about is taxAuthPartyId. So, NY_DTF, CA_BOE and UT_TAXMAN are partyId's for PartyGroups corresponding to the Government entity responsibly for taxation in that particular state. For example, the government entity which does taxation in New York (NY) is Department of Tax and Finance (DTF), which explains the term NY_DTF. Similarly, Board of Equalization (BOE) is responsible for taxation in California (CA), hence CA_BOE. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Tue, Aug 18, 2009 at 6:59 PM, su2 shu...@pexsupply.com wrote: Hi All, In TaxAuthority Entity, I see NY_UTF, CA_BOE and UT_TAXMAN(any state except NY CA). Why do we have 3 different names after the underscore _ ?. What does UTF, BOE TAXMAN stands for? Your help is really appreciated. Thank you. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25024881.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/TaxAuthority-Entity-tp25024881p25027265.html Sent from the OFBiz - User mailing list archive at Nabble.com.
OFBiz doesn't start : Exception in thread main java.lang.IncompatibleClassChangeError
Hi, I've updated my custom OFBiz from the trunk, version 805338 Now, I can't start OFBiz I obtain this error into console.log : 2009-08-18 16:22:43,105 (main) [ DelegatorImpl.java:169:INFO ] Doing entity definition check... Exception in thread main java.lang.IncompatibleClassChangeError at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:43) at org.ofbiz.entity.DelegatorImpl.init(DelegatorImpl.java:171) at org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) at org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:172) at org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190) at org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66) at org.ofbiz.base.start.Start.initStartLoaders(Start.java:259) at org.ofbiz.base.start.Start.init(Start.java:97) at org.ofbiz.base.start.Start.main(Start.java:408) Do you have the same problem after an update ? Thanks for your feedback Eric
Re: OFBiz doesn't start : Exception in thread main java.lang.IncompatibleClassChangeError
Run ant clean, then ant build. -Adrian eric...@free.fr wrote: Hi, I've updated my custom OFBiz from the trunk, version 805338 Now, I can't start OFBiz I obtain this error into console.log : 2009-08-18 16:22:43,105 (main) [ DelegatorImpl.java:169:INFO ] Doing entity definition check... Exception in thread main java.lang.IncompatibleClassChangeError at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:43) at org.ofbiz.entity.DelegatorImpl.init(DelegatorImpl.java:171) at org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) at org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:172) at org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190) at org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66) at org.ofbiz.base.start.Start.initStartLoaders(Start.java:259) at org.ofbiz.base.start.Start.init(Start.java:97) at org.ofbiz.base.start.Start.main(Start.java:408) Do you have the same problem after an update ? Thanks for your feedback Eric
Re: Ecommrce login on demo goes to hotwax
tim: one more step yes you link goes to http://demo904.ofbiz.org/ecommerce/ now click on login this goes to https://demo904.ofbiz.org:8443/ecommerce/control/checkLogin/main;jsessionid=9A771C81D31EAF8A45E47360CE99B8E5.jvm1 I just did this. it times out. Tim Ruppert sent the following on 8/18/2009 7:33 AM: I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: OFBiz doesn't start : Exception in thread main java.lang.IncompatibleClassChangeError
OFBiz starts Easy !!! Thank you very much Eric - Original Message - From: Adrian Crum adri...@hlmksw.com To: user@ofbiz.apache.org Sent: Tuesday, August 18, 2009 6:07 PM Subject: Re: OFBiz doesn't start : Exception in thread main java.lang.IncompatibleClassChangeError Run ant clean, then ant build. -Adrian eric...@free.fr wrote: Hi, I've updated my custom OFBiz from the trunk, version 805338 Now, I can't start OFBiz I obtain this error into console.log : 2009-08-18 16:22:43,105 (main) [ DelegatorImpl.java:169:INFO ] Doing entity definition check... Exception in thread main java.lang.IncompatibleClassChangeError at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:43) at org.ofbiz.entity.DelegatorImpl.init(DelegatorImpl.java:171) at org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) at org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:172) at org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190) at org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66) at org.ofbiz.base.start.Start.initStartLoaders(Start.java:259) at org.ofbiz.base.start.Start.init(Start.java:97) at org.ofbiz.base.start.Start.main(Start.java:408) Do you have the same problem after an update ? Thanks for your feedback Eric
Re: Ecommrce login on demo goes to hotwax
Now that's finally something I can work with! I'll get this out straight away and get it fixed. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: tim: one more step yes you link goes to http://demo904.ofbiz.org/ecommerce/ now click on login this goes to https://demo904.ofbiz.org:8443/ecommerce/control/checkLogin/main;jsessionid=9A771C81D31EAF8A45E47360CE99B8E5.jvm1 I just did this. it times out. Tim Ruppert sent the following on 8/18/2009 7:33 AM: I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: OFBiz Content Management System.
Hi, the ofbiz cms functionality is limited comparing to specialized document management systems. Currently there are no repository functions like check in or check out or versioning. If you are looking for a comfortable DMS perhaps you should evaluate Alfresco http://www.alfresco.com/ Its also possible to use the alfresco file repository as an ofbiz file store (eg. for images or downloads) Sebastian --On Samstag, 15. August 2009 18:14 +0530 Bravo Pal bravo.pal...@gmail.com wrote: Friends, I've some questions on OFBiz CMS : 1. Is OFBiz CMS can be used as Central Document Management repository where user can perform operation like(Check in, Checkout etc.)? 1. Purpose of CompDoc sub module of Content module ? 2. Is OFBiz CMS provide file tracking facility ? Waiting for any response. Thanks, Bravo Pal. -- Sebastian Schirmer ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Martin Wepper, Sebastian Schirmer http://www.zyres.com/ -- RFC|1855|2.1.1
Re: Ecommrce login on demo goes to hotwax
Fixed - thanks for reporting it BJ. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - Tim Ruppert tim.rupp...@hotwaxmedia.com wrote: Now that's finally something I can work with! I'll get this out straight away and get it fixed. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: tim: one more step yes you link goes to http://demo904.ofbiz.org/ecommerce/ now click on login this goes to https://demo904.ofbiz.org:8443/ecommerce/control/checkLogin/main;jsessionid=9A771C81D31EAF8A45E47360CE99B8E5.jvm1 I just did this. it times out. Tim Ruppert sent the following on 8/18/2009 7:33 AM: I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Re: Ecommrce login on demo goes to hotwax
thanks for the fix Tim Ruppert sent the following on 8/18/2009 10:28 AM: Fixed - thanks for reporting it BJ. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - Tim Ruppert tim.rupp...@hotwaxmedia.com wrote: Now that's finally something I can work with! I'll get this out straight away and get it fixed. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: tim: one more step yes you link goes to http://demo904.ofbiz.org/ecommerce/ now click on login this goes to https://demo904.ofbiz.org:8443/ecommerce/control/checkLogin/main;jsessionid=9A771C81D31EAF8A45E47360CE99B8E5.jvm1 I just did this. it times out. Tim Ruppert sent the following on 8/18/2009 7:33 AM: I still do not anywhere. I'll be happy to have Contegix look into this, but we've done this before and I know what the answer will be. I put in - http://demo904.ofbiz.org/ and it always goes where it's supposed to. Is there another problem that I'm missing? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 - BJ Freeman bjf...@free-man.net wrote: now I get a time out. Tim Ruppert sent the following on 8/18/2009 3:52 AM: This has been fixed - please clear you cache and try again. I have tested it on different browsers and there doesn't appear to be an issue. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 4:38 AM, Jacques Le Roux wrote: It seems that this has still not be fixed. I don't get an error message like BJ, but no answer from the server. This works well locally Jacques From: BJ Freeman bjf...@free-man.net http://demo904.ofbiz.org/ecommerce/ click on login get this message can't find the server at demo904.hotwaxmedia.com. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
disassemble a BOM after it is produced?
Anyone aware of a way to do this? I need to return components back to inventory if I produce more than I need, don't sell them all, etc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell
Re: disassemble a BOM after it is produced?
Hi Vince You could try the decomposeInventoryItem service. It's currently used to breakdown returned marketing packages. Regards Scott On 19/08/2009, at 10:36 AM, Vince Clark wrote: Anyone aware of a way to do this? I need to return components back to inventory if I produce more than I need, don't sell them all, etc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell smime.p7s Description: S/MIME cryptographic signature
Re: disassemble a BOM after it is produced?
Interesting, I'll check out that service. We have posed that question before specifically related to breaking down returned marketing packages. Note that we have tested returning marketing packages and it seems to just put the whole package into inventory. On a related note, we need to display all of the components of a marketing package when creating a return. In the implementation we are working on our client will allow customers to return individual components of a package. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: Scott Gray scott.g...@hotwaxmedia.com To: user@ofbiz.apache.org Sent: Tuesday, August 18, 2009 4:46:56 PM GMT -07:00 US/Canada Mountain Subject: Re: disassemble a BOM after it is produced? Hi Vince You could try the decomposeInventoryItem service. It's currently used to breakdown returned marketing packages. Regards Scott On 19/08/2009, at 10:36 AM, Vince Clark wrote: Anyone aware of a way to do this? I need to return components back to inventory if I produce more than I need, don't sell them all, etc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell
Re: disassemble a BOM after it is produced?
Sorry I only have time for quick answers inline. Regards Scott On 19/08/2009, at 10:56 AM, Vince Clark wrote: Interesting, I'll check out that service. We have posed that question before specifically related to breaking down returned marketing packages. Note that we have tested returning marketing packages and it seems to just put the whole package into inventory. I would create a jira issue, as far as I am aware marketing packages should always be decomposed after being returned. There is another service checkDecomposeInventoryItem (or something like that) whose job it is to see if the returned product needs to be broken down. On a related note, we need to display all of the components of a marketing package when creating a return. In the implementation we are working on our client will allow customers to return individual components of a package. That's sound like a perfectly valid scenario but I have no idea how well supported it is. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: Scott Gray scott.g...@hotwaxmedia.com To: user@ofbiz.apache.org Sent: Tuesday, August 18, 2009 4:46:56 PM GMT -07:00 US/Canada Mountain Subject: Re: disassemble a BOM after it is produced? Hi Vince You could try the decomposeInventoryItem service. It's currently used to breakdown returned marketing packages. Regards Scott On 19/08/2009, at 10:36 AM, Vince Clark wrote: Anyone aware of a way to do this? I need to return components back to inventory if I produce more than I need, don't sell them all, etc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell smime.p7s Description: S/MIME cryptographic signature
Re: disassemble a BOM after it is produced?
Scott - thanks so much for the replies. You have definitely put us in the right direction. I'll figure out why marketing packages aren't being disassembled when returned. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: Scott Gray scott.g...@hotwaxmedia.com To: user@ofbiz.apache.org Sent: Tuesday, August 18, 2009 5:09:49 PM GMT -07:00 US/Canada Mountain Subject: Re: disassemble a BOM after it is produced? Sorry I only have time for quick answers inline. Regards Scott On 19/08/2009, at 10:56 AM, Vince Clark wrote: Interesting, I'll check out that service. We have posed that question before specifically related to breaking down returned marketing packages. Note that we have tested returning marketing packages and it seems to just put the whole package into inventory. I would create a jira issue, as far as I am aware marketing packages should always be decomposed after being returned. There is another service checkDecomposeInventoryItem (or something like that) whose job it is to see if the returned product needs to be broken down. On a related note, we need to display all of the components of a marketing package when creating a return. In the implementation we are working on our client will allow customers to return individual components of a package. That's sound like a perfectly valid scenario but I have no idea how well supported it is. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: Scott Gray scott.g...@hotwaxmedia.com To: user@ofbiz.apache.org Sent: Tuesday, August 18, 2009 4:46:56 PM GMT -07:00 US/Canada Mountain Subject: Re: disassemble a BOM after it is produced? Hi Vince You could try the decomposeInventoryItem service. It's currently used to breakdown returned marketing packages. Regards Scott On 19/08/2009, at 10:36 AM, Vince Clark wrote: Anyone aware of a way to do this? I need to return components back to inventory if I produce more than I need, don't sell them all, etc. Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell
beanshell ports not showing up in external tomcat server
I am running ofbiz on an external tomcat server. I generated the templates using java -jar ofbiz.jar -setup tomcat6 and then copied the configuration files in the appropriate places in the tomcat directory. I start ofbiz by starting the tomcat server. However the ports for Beanshell do not show up when i start the tomcat server. If I try to do telnet localhost 9990; i get the message connection refused. If I stat ofbiz using ./startofbiz.sh (on internal server), I am able to telnet into the beanshell ports. Please tell me as to how I can do telnet localhost 9990 and go bsh prompt of ofbiz application, while running ofbiz on external tomcat server ? -- View this message in context: http://www.nabble.com/beanshell-ports-not-showing-up-in-external-tomcat-server-tp25037470p25037470.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: is compile and ofbiz restart still needed for java changes?
I have created a first shot at making use of mocking in unit tests. You can take a look at https://issues.apache.org/jira/browse/OFBIZ-2842. There are more notes on the ticket; but here are some highlights: - selected mockito framework (MIT lic) - created a new BaseTestCase - extended to an OfbizMockTestCase (in services) with mocked delegator, disaptcher, and dctx. Also has some testcase extensions to make checking success/error of services easier, creating service context, etc. - wrote CommonDimensionServicesTest This guy does not require an ofbiz container and runs inside my Eclipse in about .5s (granted it does not test a whole lot). It tests some failure scenarios as well as a successful creation of a DateDimension entity. One thing you will notice is that it is easy to test exception scenarios. So testing error handling for situations like database deadlocks become very easy to do. Moreover, you can test third party integration logic using similar techniques. Tim Ruppert wrote: +1 - would be super helpful. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Aug 18, 2009, at 12:05 AM, snowc wrote: Hi Bob, The mocking code sounds great. Would you be happy to share? -- View this message in context: http://www.nabble.com/is-compile-and-ofbiz-restart-still-needed-for-java-changes--tp24971472p25038084.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Ofbiz evaluation for a different application other than ecommerce
Hi All, We are evaluating ofbiz for insurance based application. Here we want to configure the Insurance product which is a combination of coverages, some what like configurable product. Is ofbiz suites for this kind of application? I want build a insurance application. -- Thanks, Vamsi Mandava
Re: entity condition expression problem
Hi Chris, At our company we make very heavy use of view-entities; but in order to do so we have made quite a few enhancements that have yet to be bundled up and offered back to the community. The one thing that hit me was (I believe) Ofbiz OOTB does not support the notion of having a v-e based on another v-e (this is something we make a lot of use of). We have made so many changes I often have to do some research to be sure; but I remember fixing a bug in the v-e population based on the fact that the v-e was not based solely on entities. With this support you could create your aggr. v-e and then have a v-e that will use it joined with your entity using the technique we talked about earlier. Another hack we put in was the notion of being able to specify qualifier-sql in the v-e definition. Effectively you could write a piece of sql right in the v-e, so it could absolutely do the where clause you were looking for. Now I think we would have to formalize the grammar of such an enhancement. I think the approach you are taking is fine. It is good to hear that other folks have struggled with a few of the limitations of view-entities, and I will look towards trying to bundle/formalize some of this support to try to get it in the product moving forward. Take care, Bob snowc wrote: So close, yet so far... I simplified my problem description. Actually, the complex-alias needed was: alias name=amountDue complex-alias operator=- complex-alias-field entity-alias=SalvageAmounts field=calculatedSalvageGross/ complex-alias-field entity-alias=VehiclePaymentSummaryView field=vehiclePaymentTotalAmount/ /complex-alias /alias Where: - SalvageAmounts is an entity that sits on top of a database view, not a table. - VehiclePaymentSummaryView is a view-entity with an aggregate function. Running the report results in the error: exception report -- Failure in by condition find operation, rolling back transaction Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT Uplift.ingUplNumber, Uplift.strUplInsurer, Uplift.dtmUplPickupDate, VehiclePaymentSummaryView.SUM_Ve hiclePayment_ingAmount_, UpliftFlags.strFlag, UpliftFlags.blnAgreed, UpliftFlags .blnReviewed, SalvageAmounts.upliftPAVBand, SalvageAmounts.ingPercentage, Salvag eAmounts.calculatedSalvageNet, SalvageAmounts.calculatedSalvageVat, SalvageAmoun ts.calculatedSalvageGross, (SalvageAmounts.calculatedSalvageGross - VehiclePayme ntSummaryView.SUM(VehiclePayment.ingAmount)) FROM ((dbo.tblUplift Uplift LEFT OU TER JOIN (SELECT Uplift.ingUplNumber AS Uplift_ingUplNumber, SUM(VehiclePayment. ingAmount) AS SUM_VehiclePayment_ingAmount_ FROM dbo.tblUplift Uplift LEFT OUTER JOIN dbo.tblVehiclePayment VehiclePayment ON Uplift.ingUplNumber = VehiclePayme nt.ingUpliftNumber GROUP BY Uplift.ingUplNumber) VehiclePaymentSummaryView ON Up lift.ingUplNumber = VehiclePaymentSummaryView.Uplift_ingUplNumber) INNER JOIN db o.tblUpliftFlags UpliftFlags ON Uplift.ingUplNumber = UpliftFlags.ingUplift) INN ER JOIN dbo.vSalvageAmounts SalvageAmounts ON Uplift.ingUplNumber = SalvageAmoun ts.ingUplNumber WHERE (Uplift.ingUplNumber ? AND UpliftFlags.strFlag = ? AND U pliftFlags.blnAgreed = ? AND UpliftFlags.blnReviewed = ? AND Uplift.dtmUplPickup Date IS NOT NULL) (Cannot find either column VehiclePaymentSummaryView or the user-defined function or aggregate VehiclePaymentSummaryView.SUM, or the name is ambiguous.) -- I think I will push my logic back into a database view. I find that using pure entity and view-entity does not have the power needed to work with some legacy data designs. For example other posts have mentioned wanting to specify join conditions in view-link's which would be very useful. Many thanks, Chris Bob Morley wrote: I think I would create a view-entity that aliased all of the fields you have here and added a complex-alias for the difference of the actual and estimated net amounts. Something like -- alias name=actualEstimatedDelta complex-alias operator=- complex-alias-field entity-alias=E1 field=actualNetAmount/ complex-alias-field entity-alias=E1 field=estimatedNetAmount/ /complex-alias /alias Then do your entity condition on this field in your v-e. condition-expr field=actualEstimatedDelta operator=greater value=0/ Bob snowc wrote: I have some legacy data that I am trying to access in ofbiz. entity name=E1 field name=e1ID/ field name=actualNetAmount/ field name=estimatedNetAmount/ /entity Conceptually, I want to filter as shown here: SELECT e1Id, actualNetAmount, estimatedNetAmount FROM E1 WHERE actualNetAmount estimatedNetAmount
Re: Ofbiz evaluation for a different application other than ecommerce
Of course Vamsi. You can find examples of some configurable products on demo ecommerce site: http://demo.ofbiz.org/, for reference Configurable PC and Enchiladas are two configurable products available there. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Wed, Aug 19, 2009 at 11:11 AM, Vamsi Gmail! vamseemand...@gmail.comwrote: Hi All, We are evaluating ofbiz for insurance based application. Here we want to configure the Insurance product which is a combination of coverages, some what like configurable product. Is ofbiz suites for this kind of application? I want build a insurance application. -- Thanks, Vamsi Mandava