Re: Multiple Subsidiaries in OfBiz
Hello James, Yes, multiple companies can be setup in OFBiz and independent company management (accounting, ordering, warehousing, procuring, etc) is achievable. Please seem my comments inline. Thanks & Regards Mridul Pathak Hotwax Systems http://www.hotwaxsystems.com <http://www.hotwaxmedia.com> On Tue, Jan 24, 2017 at 4:28 AM, <ja...@productive1.com> wrote: > Hi all I am new to this group so hopefully I am posting in the correct > areas. We would like to set up OfBiz with Multiple Companies that all > roll up into a Parent Company. We are looking for the following: > > Separate Vendors (CRM tied to a separate company) > Separate Customers (CRM tied to a seperate company > Sales Associates can be tied to multiple companies > All of the above can be configured using PartyRelationship. > Each company can fulfill from each others warehouse (intercompany > transaction) > Should be able to invoice each other > You should be able to maintain inter company customer/supplier relationships and raise SOs and POs. > Warehouses should be tied to a company > Stores should be tied to a company > Financials Should be tied to a company > Purchases Should be tied to a company > Each company could have separate currency > Each company could have separate language > With correct setup specific to each company above items could be achieved easily. Following are few entities involved in configuration. 1) Party (Company in internal organization role) 2) PartyAcctgPreferences (Specific to each company) 3) GL setup specific to each company 4) ProductStore setup tied to the specific company 5) Facility (Warehouse) setup for each company. A company could be setup as warehouse owner. > > We can use external reporting to handle the Intercompany consolidation > That should be a good approach. > > My question is does Ofbiz handle this OTB? If so what are the key areas > we need to configure for this to handle properly. > In essence it all depends on data modeling. If standard approach with proper understanding of OFBiz data model and API is followed then pretty much all the OOTB workflows should execute as expected. > > Thanks in Advance. > > James > Productive One >
Re: Congratulations!
Congratulations Chatree!! Regards Mridul Pathak On Fri, Jan 16, 2015 at 12:19 AM, Divesh Dutta divesh.du...@hotwaxmedia.com wrote: Congratulations Chatree Srichart Thanks -- Divesh Dutta. On Thu, Jan 15, 2015 at 10:09 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Ok, the last person that was invited have also accepted the new role and so we can announce him too: welcome Chatree Srichart (chatrees)! Jacopo On Jan 15, 2015, at 12:42 PM, Mridul Pathak mridul...@gmail.com wrote: Thank you all!! Congratulations Gavin and Pranay!! Regards Mridul Pathak --- direct: +91 - 942.592.6892 On Wed, Jan 14, 2015 at 2:55 PM, Arun Patidar arun.pati...@hotwaxmedia.com wrote: Many Congratulations Gavin, Mridul and Pranay ! Thanks Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxmedia.com On Monday 12 January 2015 02:04 PM, Jacopo Cappellato wrote: Thank you for starting this thread Pierre. Please also welcome Gavin Mabie (gavinmabie) that was invited as committer with Pranay and Mridul. They are all officially OFBiz committers now; we were waiting to send the congratulation email just because we are waiting for the response of a fourth person but it's good to move on and I will let you all know as soon as we have some news. Regards, Jacopo On Jan 12, 2015, at 8:00 AM, Pierre Smits pierre.sm...@gmail.com wrote: Hi All, Please join me in welcoming and congratulating Pranay Panday and Mridul Pathak of HotWax Media as the newest committers of this project. According to the blog of HotWax Media ( http://www.hotwaxmedia.com/apache-ofbiz-blog/happy-2015-team-hotwax/) it was a milestone in 2014 for the organisation to having them invited and accepted as committers by this project. Regards, Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com
Re: Congratulations!
Thank you all!! Congratulations Gavin and Pranay!! Regards Mridul Pathak --- direct: +91 - 942.592.6892 On Wed, Jan 14, 2015 at 2:55 PM, Arun Patidar arun.pati...@hotwaxmedia.com wrote: Many Congratulations Gavin, Mridul and Pranay ! Thanks Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxmedia.com On Monday 12 January 2015 02:04 PM, Jacopo Cappellato wrote: Thank you for starting this thread Pierre. Please also welcome Gavin Mabie (gavinmabie) that was invited as committer with Pranay and Mridul. They are all officially OFBiz committers now; we were waiting to send the congratulation email just because we are waiting for the response of a fourth person but it's good to move on and I will let you all know as soon as we have some news. Regards, Jacopo On Jan 12, 2015, at 8:00 AM, Pierre Smits pierre.sm...@gmail.com wrote: Hi All, Please join me in welcoming and congratulating Pranay Panday and Mridul Pathak of HotWax Media as the newest committers of this project. According to the blog of HotWax Media ( http://www.hotwaxmedia.com/apache-ofbiz-blog/happy-2015-team-hotwax/) it was a milestone in 2014 for the organisation to having them invited and accepted as committers by this project. Regards, Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com
Re: Gift Cards
Craig, Please see my comments inline. On Thu, Aug 19, 2010 at 12:01 AM, Craig Ambrose cr...@tastingroom.comwrote: Hello, I am implementing gift cards for our eCommerce application and I'm not getting a clear picture from what is implemented on the sample eCommerce site. Here is how I am expecting it to work - Customer purchases gift card from eCommerce site, lets say a $50, pre-specified gift card - Upon submission of the order some sort of account is created where $50 can be debited on future orders. - After the order is submitted and approved, the customer will receive an e-mail with the gift card number to be used on subsequent purchases - When doing a subsequent purchase the customer can input the unique Gift Card identifier to be used as a payment method - If the gift card does not contain enough value to pay for the entire order, a credit card or additional gift card can be used for the remaining balance From the eCommerce sample web site I can purchase a gift card and receive the e-mail with my order confirmation. But it doesn't contain any gift card identification. I only see the product ID. OFBiz generates gift card number and pin and they should be sent in the email. I see GiftCard and GiftCardFulfillment entities, but not sure how to use them. So, some of my questions are: - What is the entity that encapsulates the Gift Card account? It's FinAccount of type GIFTCERT_ACCOUNT. - Is there an ECA service that generates the Gift Card account automatically when an order is approved that contains a Gift Card in the order items? No, it's a digital fulfillment service associated to gift card product. See more details below. - Is there any special attributes of a product that is a gift card that will trigger the account creation? A gift card product should be a DIGITAL product. There is OOTB service ofbizGcPurchase which acts as a digital fulfillment service and is associated to the gift card in form of ProductContent of type FULFILLMENT_EXTSYNC or FULFILLMENT_EXTASYNC. A digital product is fulfilled right away without needing order approval. The digital fulfillment service is triggered as soon as the digital item (gift card) is fulfilled. - Is there any weirdness in having more than one PAYMENT_METHOD per order? Does ofbiz allow for this easily? Not at all. You might not find OOTB UI for setting multiple payment methods at the time of order checkout but you can set them in your custom app without any issues. Thanks for any clarity on gift cards -craig -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892
Re: Need help in configuring POS
Hi Priya, Here is the documentation available on OFBiz wiki, HTH: http://cwiki.apache.org/confluence/display/OFBIZ/POS+System http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=6553930 http://cwiki.apache.org/confluence/display/OFBIZ/Sync+Setup+Notes+and+Example -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Feb 11, 2010 at 7:56 AM, priya renjith priya.ren...@gmail.comwrote: Hi, I am a beginner in java. This is a very new area to me.I want to configure POS with ofbiz. The details are as follows My OS is Windows Vista Home Premium SP1 I have installed ofbiz4.0 in the folder C:\workspace\ofbiz4.0 jdk1.6.0_18 folder is in the folder C:\java\jdk1.6.0_18 Epson 1.11.9 is in the folder C:\Program Files\Epson is 1.11.9 How do i open POS - order entry and all other windows in apache web server? What is the command using for that ? I have configured opentaps in my system. I am using the below url to open the opentaps crm http://localhost:8080/opentaps Similar way how do i open POS s/w in apache server?What should be the link for opening that? I am running the POS in ofbiz using the following command in the command prompt startofbiz -pos ( pls find the screen shot for that command) But i dont know how to view the UI section. Pls help me..I am very new to this section(in java and ERP). Its very urgent . Pls do needful. Pls help me. If this is not the correct place for the help, pls send me the correct mail id Thanks in advance, Priya
Re: Different order status for COD and CC
It certainly depends on what status change you want to have, if in both cases the next status change would be ORBER_APPROVED, then better to customize the view logic to show different descriptions, instead of creating new statuses. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Jan 28, 2010 at 10:50 PM, Ramkrishna Swamy ramkrishna.swamyof...@gmail.com wrote: Hi Scott, What could be possible harm if i do so, i don't have much knowledge of OFBiz and since it's my client's requirement so i have to follow. -- Thanks Ramkrishna On Fri, Jan 29, 2010 at 11:04 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: I would seriously consider why the same status has to have a different description depending on the payment method type. You're adding unnecessary complexity when other simpler approaches could probably achieve the same goal. Regards Scott On 28/01/2010, at 10:12 PM, Ramkrishna Swamy wrote: Hi Scott, Thanks for your reply, i have to set status Order to be approved for COD and Order Placed for CC instead of Created, as per my understanding i'll have to create new status and have to call seca for changing the order status while placing the order, is this correct or there is another way to do. -- Thanks Ramkrishna On Fri, Jan 29, 2010 at 4:41 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: Start off by setting Auto Approve Order on the Product Store to N which will cause all order to remain in the Created status and will need to be manually moved to Approved. Regards Scott HotWax Media http://www.hotwaxmedia.com On 28/01/2010, at 12:36 AM, Ramkrishna Swamy wrote: Has anyone idea on this. Plz help. -- Thanks Ramkrishna On Mon, Dec 28, 2009 at 12:47 PM, Ramkrishna Swamy ramkrishna.swamyof...@gmail.com wrote: Hi list, I have a requirement of setting different order status, for COD status should be Order to be Approved and for CC Order Placed is required, and in both cases order will be approved later on, how to implement this. Plz help. -- Thanks Ramkrishna
Re: Problems calling addAdditionalViewForProduct
The first thing that you need to make sure is that your servicedef
implements uploadFileInterface, add following line to your servicedef:
implements service=uploadFileInterface/
The next thing you will need to do is to pass in the following input
parameters (comes from uploadFileInterface) to addAdditionalViewForProduct
service:
set
field=addAdditionalViewForProduct.uploadedFile
from-field=parameters.uploadedFile/
(you already have this one)
set
field=addAdditionalViewForProduct._uploadedFile_fileName
from-field=parameters._uploadedFile_fileName/
set
field=addAdditionalViewForProduct._uploadedFile_contentType
from-field=parameters._uploadedFile_contentType/
Once this is done your service should work.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892
On Thu, Jan 28, 2010 at 1:37 PM, Alexander1893
alexan...@familie-schweizer.net wrote:
Hi all,
I'm trying to use the service addAdditionalViewForProduct and I'm havin
some problems.
I have the following form in the front-end:
form type=upload name=singleFileUpload
target=performSingleFileUpload
field name=uploadedFile title=chose file
file/
/field
field name=submitButton title=${uiLabelMap.CommonAdd}
widget-style=smallSubmit
submit button-type=button /
/field
/form
After submitting I do some other things necessary (calling some services
etc.).
Than I prepare the Input-Map for the service addAdditionalViewForProduct:
set field=addAdditionalViewForProduct.userLogin
from-field=userLogin.userLogin/
set field=addAdditionalViewForProduct.productId
from-field=productRoleAttributes.productId/
set
field=addAdditionalViewForProduct.productContentTypeId
value=DIGITAL_DOWNLOAD/
set field=addAdditionalViewForProduct.uploadedFile
from-field=parameters.uploadedFile/
And then I call the service:
call-service service-name=addAdditionalViewForProduct
in-map-name=addAdditionalViewForProduct/
When I do that, I don't get any errors in the log - but nothing really
happens (the file is not associated with the product...)
I debugged the ProductServices.java in Eclipse - and obviously the
imageData ist Null in after this Line:
ByteBuffer imageData = (ByteBuffer) context.get(uploadedFile);
Can anyone help?
Thanks a lot!
Alexander
--
View this message in context:
http://n4.nabble.com/Problems-calling-addAdditionalViewForProduct-tp1397293p1397293.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problems calling addAdditionalViewForProduct
Hi Alexander, You don't need to add these parameters to your form. This is the job of ServiceEventHandler to put the uploaded file related information in the parameters that are being passed to the service, refer ServiceEventHandler.java (line 151 - 227). You said you are writing custom logic around the OOTB addAdditionalViewForProduct service. If that's true it would be easier for you if your custom logic is written as a service and the service def implements uploadFileInterface service interface. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Jan 28, 2010 at 2:16 PM, Alexander1893 alexan...@familie-schweizer.net wrote: Hi Midrul, first of all - it's not my service I'm calling. You said that this is missing: set field=addAdditionalViewForProduct._uploadedFile_fileName from-field=parameters._uploadedFile_fileName/ set field=addAdditionalViewForProduct._uploadedFile_contentType from-field=parameters._uploadedFile_contentType/ First: Actualy I'dont understand why I should have this parameters in the form, if they are optional in the service-dev... If optional meens, that the service doesn't work - than the service-def is useless. I have only one field in the form - which is a input type file. Where should the fileName and contentType come from? Thanks a lot for futher help! Alexander -- View this message in context: http://n4.nabble.com/Problems-calling-addAdditionalViewForProduct-tp1397293p1400053.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: build error on stable release
If you have checked it out via SVN, then to get the revision number of your
installed copy, on terminal go to OFBiz trunk directory, and run svn info
command, it will give you the revision info of your installed copy.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892
On Mon, Jan 25, 2010 at 12:49 PM, Patrick patrickinminneapo...@gmail.comwrote:
I think I am running the most stable release 9.04, but I can't
completely remember which version I downloaded. How can I get the
version number from OfBiz?
I was going to use my build number to ask this question. I tried to
compile by running ant, I just typed ant in the ofbiz-trunk
directory. I get the following error.
BUILD FAILED
/opt/ofbiz-trunk/build.xml:190: The following error occurred while
executing this line:
/opt/ofbiz-trunk/framework/build.xml:147: The following error occurred
while executing this line:
/opt/ofbiz-trunk/macros.xml:27: The following error occurred while
executing this line:
/opt/ofbiz-trunk/common.xml:51: taskdef A class needed by class
org.ofbiz.tools.ant.IfTask cannot be found: ConditionBase
Line 51 is this: taskdef name=if
classname=org.ofbiz.tools.ant.IfTask
classpath=${ofbiz.home.dir}/tools/build/classes/
What should I do to make it compile? Thanks.
Patrick
Re: Problem eith Form-Field of type file
Use form type=upload. That would actually render an html from with
enctype=multipart/form-data required for file upload.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892
On Sat, Jan 23, 2010 at 10:26 AM, Alexander1893
alexan...@familie-schweizer.net wrote:
Hi all,
I want to add a new imageDataResource using the Service
createImageDataResource.
I'm using the following form:
form type=single name=singleFileUpload
target=performSingleFileUpload
field tooltip=I'm a tooltip name=imageData
title=Select
Image:file//field
field name=submitButton title=${uiLabelMap.CommonAdd}
widget-style=smallSubmitsubmit button-type=button//field
/form
And I'm getting the following error:
The Following Errors Occurred:
... (SQL Exception while setting value on field [imageData] of entity
ImageDataResource: (An attempt was made to put a data value of type
'java.lang.String' into a data value of type 'BLOB'.))]
So it seems, that the name of the file but not the file-data itself is
passed to the service. Can anyone help how to use the service correctly?
Thanks a lot!
Alexander
--
View this message in context:
http://n4.nabble.com/Problem-eith-Form-Field-of-type-file-tp1288314p1288314.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: extending view entities
Or you can define a new view using an existing view entity as member entity. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Jan 20, 2010 at 3:59 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: I don't believe so, you can either define a new view or you can redefine the existing view using the same name and have it override the existing. Regards Scott HotWax Media http://www.hotwaxmedia.com On 20/01/2010, at 5:49 AM, snowch wrote: Can view-entities be extended? Many thanks, Chris
Re: auto-fields-service question related to tutorial
Hi Patrick, There are two ways of doing this: 1) Don't use auto-field-service tag and explicitly specify the fields you want to include in your form. 2) Limit the input attributes in updatePracticePerson service. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Jan 21, 2010 at 1:53 PM, Patrick patrickinminneapo...@gmail.comwrote: I'm on step 2 of this tutorial. http://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide . I'm expecting to see the image, http://cwiki.apache.org/confluence/download/attachments/6553969/Personform1.png , with a list of 3 person related fields and an update and delete button, specifically [First Name] [Middle Name] [Last Name] [Update] [Delete] My code is retrieving every field, eg. [Birth Date] [Member ID] etc. I would like to restrict the retrieved fields to just First, Middle and Last Name and ignore all the other fields. I think the line that's doing it is this. auto-fields-service service-name=updatePracticePerson default-field-type=edit map-name=person/ How can I limit the number of fields that auto-fields-service is pulling? Thanks Patrick
Re: Forgot Password Error - Trunk Release 901582
Its looks like a bug, the screen is broken for all the applications except for workeffort. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Jan 21, 2010 at 7:29 AM, Scott. sc...@anglolimited.com wrote: After logging out from order manager in the trunk demo and arriving at the login page, if you click on forgot password, you get the following error; org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#forgotPassword]: java.lang.IllegalArgumentException: Could not find screen with name [login-decorator] in class resource [component://order/widget/ordermgr/CommonScreens.xml] (Could not find screen with name [login-decorator] in class resource [component://order/widget/ordermgr/CommonScreens.xml]) Thanks. -- View this message in context: http://n4.nabble.com/Forgot-Password-Error-Trunk-Release-901582-tp1049771p1049771.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem entering Purchase Order
Which revision of OFBiz are you using? -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Sat, Jan 16, 2010 at 6:11 AM, advait75 adv...@retailwave.com wrote: Hi, I have set up Ofbiz with seed data. I am using the system only to enter POs. When I try to create a PO I get the following error- Error calling event: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.IllegalArgumentException: productStoreId cannot be null (productStoreId cannot be null) I obviously am missing something in my data set up. Can somebody please tell me what I am missing? I have set up the following - 1. 1 party for Internal org 2. Products 3. Products-Suppliers Thanks and regards, Advait -- View this message in context: http://n4.nabble.com/Problem-entering-Purchase-Order-tp1015601p1015601.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Ecommerce in Ofbiz
Kranthi, Paypal integration is available in OFBiz, make sure you have cofigured ProductStorePaymentSettings (you can find PaymentGateway services in services_paypal.xml) and PaymentGatewayPayPal entities correctly. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Jan 7, 2010 at 3:11 PM, kranthi reddy kranthili2...@gmail.comwrote: Hi all, I am a newbie to ofbiz. I am trying to integrate the ofbiz ecommerce for my application. I am trying to go through the ecommerce application and trying to use the paypal gateway. I get an error when i say checkout. Is this because paypal hasn't been integrated or I need to implement my own services to access the paypal stuff ? If I am not clear, Can some one tell me as to how I can do a payment transaction using Paypal in Ofbiz. Thanks in advance, kranthi
Re: New ecommerce website based on OFBiz
Sac, My suggestion for the best way to start with a new ecommerce website based on OFBiz is to: 1) Create a separate new component in hot-deploy. 2) Copy over the basic screens and templates from specialpurpose/ecommerce. Style them as you like. Create new if required. 3) Refer demo ecommerce data to setup your store/catalog/categories/products in the same manner. 4) Include specialpurpose/ecommerce controller.xml in you hot-deploy component's controller.xml and use OOTB business processes from ecommerce and other components as much possible. And lastly this link will certainly help you to setup your ecommerce store and is a good guide to begin with: http://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide . -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Mon, Nov 30, 2009 at 7:20 PM, sac sha sacsh...@gmail.com wrote: Hi All I am trying to develop an ecommerce website through ofbiz. All I am doing is copying the ecommerce from special purpose package. Not sure whether this is right way of doing an ecommerce website through ofbiz. Please suggest. -- Regards Sac
Re: ProductPromoAction implementation : AND or OR ?
Hi, I don't know why you don't want to associate conditions to your rule, but a ProductPromoRule is a combination of Conditions and Actions. A rule can be setup in following ways: 1. single condition, single action 2. single condition, multiple actions 3. multiple conditions, single action 4. multiple conditions, multiple actions 5. Can be just actions, if you don't have any conditional requirements The way code is written is if all the conditions are met (AND is applied here) then only all the Actions in that rule should apply (if they are applicable). If any of the conditions in that rule is not satisfied, none of the actions will run. In your case, since there are no conditions, it will run all the applicable actions of your rule. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Nov 25, 2009 at 3:23 PM, cqnunez ge...@yahoo.com wrote: I was just wondering if it had been intended in ofbiz to implement actions in an AND or an OR manner? I have tried the ff scenario in ofbiz: promo 1. no conditions 2. action 1 : X Product for Y Price qty = 2 amount = 5 product = GZ-1004 action 2 : X Product for Y Price qty = 1 amount = 5 product = GZ-2002 if the order created has the ff order items GZ-1004 qty = 2 Total = 5 GZ-2002 qty = 1 Total = 5 giving a Cart Total: 10 which I know to be correct. If I changed the order to only have one order item: GZ-1004 qty = 2 Total = 5 which shows that action 1 of the promo was implemented without requiring the implementation of action 2. wouldn't it be more correct to not apply the promo because condition implied by the promoActions, that there should 2 of GZ-1004 and 1 of GZ-2002, are not satisfied? Thanks for any clarification on the matter. -- View this message in context: http://n4.nabble.com/ProductPromoAction-implementation-AND-or-OR-tp787414p787414.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: chargeShipping on catalog/product page
Hi Shuchi, Raj Creating shipping estimates using price breaks and weight breaks of course is one option to create fine shipping rules, but still they apply on a product store as a whole and not on a single product. For instance, the case Shuchi has presented here can be very product specific, user may want to allow certain shipping methods for one of the products and it might not be possible to create shipping estimates based on price/weight breaks as other products fall in same range. Shuchi, chargeShipping won't help you here either. It just determines if a product has to be charged shipping or not, it doesn't allow you to associate certain shipping methods to the product. One way of doing this is to create Product and Shipment Method specific promotion, which will though show that particular shipping method for the product during checkout, but when selected will not apply shipping charges for that particular product. But if the requirements are very specific, like have ground shipping for free for a product and user don't even needs to select the shipping method (which means that if none selected, then ground shipping will be set in cart as default), then that is too custom a requirement and you will need to implement custom code for it, which will still need to create the promotion I specified. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Nov 26, 2009 at 10:09 AM, Raj Saini rajsa...@gmail.com wrote: Hello Suchi, Did you try the shipping estimates? You can create shipping rules based on varied criteria. Have a look at http://www.goldencharm.co.uk/ and see how different shipping options are offered based on price. Thanks, Raj su2 wrote: Thanks Mridul for your reply. My main goal is: Using chargeShipping dropdown, I want to offer free ground shipping on particular products, so basically I want to show all the other shipping options in as-is condition while making ground shipping as free for this particular item. Right now what is happening is: when I make chargeShipping = N, it does not show any shipping options for this item at all. I scanned through the shippingApplies function in ProductWorker, ShoppingItem and ShoppingCartItem files and tried to forcefully make shippingApplies = true (just to see if it would show all the shipping options for such products) but the attempts where unsuccessful. Could you please point me out where I might need to concentrate for making this happen? Thanks Again, and I appreciate your response and time on this. Shuchi- Mridul Pathak-2 wrote: Shuchi, ProductWorker class has a method shippingApplies() which checks for this field. This method in turn is used in OrderReadHelper.shippingApplies() and ShoppingCartItem.shippingApplies() to perform the check. ShoppingCart.shippingApplies() use ShoppingCartItem.shippingApplies() to check if there are shippable items in cart. ShoppingCart.shippingApplies() and OrderReadHelper.shippingApplies() is used in CheckoutHelper and CheckoutEvents which are classes responsible for checkout. These are also used in few more classes like ShippingEvents, InvoiceServices, PayPalServices, PayflowPro. You can refer these classes and check the code. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Tue, Nov 24, 2009 at 8:20 PM, su2 shu...@pexsupply.com wrote: Hello friends, for during checkout, where can I find the code for checking the value of chargeShipping(which is set on catalog/product page)? I tried finding it but could not find where actually it is checking if chargShipping is set to 'N'. I really appreciate the help. Thank you. su -- View this message in context: http://n4.nabble.com/chargeShipping-on-catalog-product-page-tp786880p786880.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: chargeShipping on catalog/product page
Shuchi, ProductWorker class has a method shippingApplies() which checks for this field. This method in turn is used in OrderReadHelper.shippingApplies() and ShoppingCartItem.shippingApplies() to perform the check. ShoppingCart.shippingApplies() use ShoppingCartItem.shippingApplies() to check if there are shippable items in cart. ShoppingCart.shippingApplies() and OrderReadHelper.shippingApplies() is used in CheckoutHelper and CheckoutEvents which are classes responsible for checkout. These are also used in few more classes like ShippingEvents, InvoiceServices, PayPalServices, PayflowPro. You can refer these classes and check the code. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Tue, Nov 24, 2009 at 8:20 PM, su2 shu...@pexsupply.com wrote: Hello friends, for during checkout, where can I find the code for checking the value of chargeShipping(which is set on catalog/product page)? I tried finding it but could not find where actually it is checking if chargShipping is set to 'N'. I really appreciate the help. Thank you. su -- View this message in context: http://n4.nabble.com/chargeShipping-on-catalog-product-page-tp786880p786880.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Bundling
Abhijeet, I'll vote for Marketing Packages again too. About your problem regarding showing the components on order detail page, you can always customize the ftl file to fetch the associated component products and show them. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Mon, Nov 2, 2009 at 3:34 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: Marketing Packages, same as my last reply. Regards Scott On 2/11/2009, at 10:50 PM, Abhijeet Pandey wrote: Hi Everyone, Any finding for this ? Anyone has got a clue how to do the bundling thing ? Plz go through the mail and then respond. Thanks in Advance, Abhijeet Pandey On Fri, Oct 9, 2009 at 12:00 PM, Ofbiz Learner getof...@gmail.com wrote: Hi, one basic question -- even if i use the said example for the checkout ( https://demo.ofbiz.org/ecommerce/products/PC-100/p_PC001) how come at looking at the order , we can tell that what configuration has been choosen by the user. For example , while doing a checkout i choose diffrent options, and i placed my order successfully , how at the back end it will be determined that what options were choosen. It should / can not be price as it may depend that price for diffrent component will be diffrent. Hope i am able to put my question clearly. Thanks, On 10/9/09, Ruth Hoffman rhoff...@aesolves.com wrote: Hi Scott: I stand corrected! You are correct. Regards, Ruth Scott Gray wrote: Yes you can, it wouldn't make much sense otherwise. See here for an example (The components section): https://demo.ofbiz.org/catalog/control/EditProductConfigOptions?configItemId=ITconfigOptionId=OP000 Regards Scott On 9/10/2009, at 4:47 PM, Ruth Hoffman wrote: Hi Scott: I've tried. Configurable Products do not take other Products as the component parts. If you want the original items to be products, then you have to create your own associations to do this and those associations are not supported OOTB. Regards, Ruth Scott Gray wrote: It may be possible with a Configurable Product, I've never tried. Regards Scott HotWax Media http://www.hotwaxmedia.com On 9/10/2009, at 4:35 PM, Ruth Hoffman wrote: Hi Ofbiz Learner: OOTB you cannot do this. Regards, Ruth Ofbiz Learner wrote: Hi, I don't want to give selection to the user. i want to bundle few products , want to give it a name, may be will put a diffrent price (which may or may not be the sum of price of product involved). For Example -- let's say i have DVDs which i sell on my site. I want to bundle few of them and sell ,may be on special price. For example i have 6 james bond movies on my site. *Quantum of Solace* http://en.wikipedia.org/wiki/Quantum_of_Solace price -- 99 $ *Casino Royale* http://en.wikipedia.org/wiki/Casino_Royale_%282006_film%29 price -- 99 $ *Die Another Day* http://en.wikipedia.org/wiki/Die_Another_Day price -- 99 $ *The World Is Not Enough*http://en.wikipedia.org/wiki/The_World_Is_Not_Enough price -- 99 $ *Tomorrow Never Dies http://en.wikipedia.org/wiki/Tomorrow_Never_Dies price -- 99 $* *GoldenEye* http://en.wikipedia.org/wiki/GoldenEye price -- 99 $ Now i want to sell 2 of them in bundle which user cannot choose. Let us say i will name that as Dainel Craig As Bond which will consist of *Quantum of Solace* http://en.wikipedia.org/wiki/Quantum_of_Solace and *Casino Royale*http://en.wikipedia.org/wiki/Casino_Royale_%282006_film%29 i can have Price of Dainel Craig As Bond as 150 $ or it may be 198 $. What is the best way to do it. Plz help. ** i want to create a product called Best of Bond and want to sell 3 of them On 10/8/09, Ruth Hoffman rhoff...@aesolves.com wrote: Hello Ofbiz Learner: I would approach this differently. I would create virtual and variant products and then perhaps use promotions to associate special pricing rules. Regards, Ruth Hoffman http://www.myofbiz.com Ofbiz Learner wrote: Hi Mridul, Thanks for that. i did whatever you suggested and was able to create a product comprising of 2 product. i checked out that product and order was generated. but i didn't see that it consist of 2 items in order detail. it is showing as one Order with one product in it. shouldn't it show that it consist of 2 products. Plz help. Thanks On 10/7/09, Mridul Pathak mridul.pat...@hotwaxmedia.com wrote: Akhil, You can create a new product of type Manufacturing Package: Pick Assembly, and then you can associated the selected products that you want to sell in a bundle to this new product as components in ProductAssoc entity. For this new product you can define new prices. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com
Re: Starting problem with release 9.4
Looks like you haven't installed the data, did you run ant run-install? -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Tue, Nov 3, 2009 at 2:08 AM, Abey Jacob abcja...@yahoo.com wrote: Hi, I am fresh to OfBiz. I checked out the 4.0 code a few days back and did an Ant build using Eclipse. Finally I could run the ofbiz from my PC and do some tweakings. Ofcourse, with the help of a book by Janathan Wong. Today I tried to do the same thing with release 9.4. It seems that the build went fine and ofbiz could be started. I got an error.log file in 'runtime/logs' folder. When I try to access ecommerce, the following messages are thrown out in the browser. org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://ecommerce/widget/CommonScreens.xml#leftbar]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Error in simple-method [Get visual theme resources [file:/C:/Workspace/release09.04/framework/common/script/org/ofbiz/common/CommonServices.xml#getVisualThemeResources]]: ; [Visual Theme resources not found.] (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Error in simple-method [Get visual theme resources [file:/C:/Workspace/release09.04/framework/common/script/org/ofbiz/common/CommonServices.xml#getVisualThemeResources]]: ; [Visual Theme resources not found.])-- Anyone, please tell me what I should do to correct this problem and get ofbiz to run properly. Thanks,Abey.
Re: Unable to start Lambda Probe
It is super delicious and has so many variations :-). -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Oct 29, 2009 at 3:02 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: Sounds delicious :-) Regards Scott HotWax Media http://www.hotwaxmedia.com On 29/10/2009, at 10:25 PM, Pranay Pandey wrote: This can be interesting for others: http://en.wikipedia.org/wiki/Laddu Thanks Regards -- Pranay Pandey HotWax Media | www.hotwaxmedia.com ApacheCon US 2009 Gold Sponsor http://us.apachecon.com/c/acus2009/sponsors/sponsors On Oct 29, 2009, at 2:39 PM, Divesh Dutta wrote: Wah Laddooo... Fokut ke laddo mil rahe ho to jarur khana chahenge OFBiz community ke log. Pehli bar koi OFBiz users ko ladooo offer kar raha hai. ;-) Nice to see Hindi in OFBiz user mailing list. Thanks -- Divesh Dutta Team Lead Enterprise Software Development ApacheCon US 2009 Gold Sponsor http://us.apachecon.com/c/acus2009/sponsors/sponsors neha.me...@lntinfotech.com wrote: to hum kya karen.. laddooo baaten ?? Thanks Regards, Neha Mehta Software Engineer (A-1-1) Larsen Toubro Infotech Ltd. Cell: +91 97694 72267 Email-id: neha.me...@lntinfotech.com EL-200, TTC Electronic Zone, Shil Mahape Road, Navi Mumbai, 400710 T: +91 022 67954324 India +0530 UTC/GMT ** The most beautiful thing is to see a person smiling… And even more beautiful is knowing that you are the reason behind it!!! Be a reason for others to smile HAVE A NICE DAY AHEAD.. ** Larsen Toubro Infotech Ltd. www.Lntinfotech.com This Document is classified as: LT Infotech Proprietary LT Infotech Confidential LT Infotech Internal Use Only LT Infotech General Business This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. richa.mit...@lntinfotech.com 10/29/2009 02:14 PM Please respond to user@ofbiz.apache.org To user@ofbiz.apache.org cc Subject Unable to start Lambda Probe I deployed Lambda probe as a component in ofbiz application. I used this link: http://bizlift.com/ofbiz/lambda_probe_for_ofbiz.html When I start the ofbiz application following exception comes: Cannot find class [org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean] for bean with name 'userDetailsService' defined in ServletContext resource [/WEB-INF/spring-root-acegi.xml]; java.lang.ClassNotFoundException: org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean Thanks Richa Mittal __ __ __
Re: Unable to start Lambda Probe
Looks like either you are missing some jar file or if these classes comes with the component then there might be some thing missing in the build configuration (build.xml) of your component. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Oct 29, 2009 at 2:14 PM, richa.mit...@lntinfotech.com wrote: I deployed Lambda probe as a component in ofbiz application. I used this link: http://bizlift.com/ofbiz/lambda_probe_for_ofbiz.html When I start the ofbiz application following exception comes: Cannot find class [org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean] for bean with name 'userDetailsService' defined in ServletContext resource [/WEB-INF/spring-root-acegi.xml]; java.lang.ClassNotFoundException: org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean Thanks Richa Mittal __
Re: Unable to start Lambda Probe
Or might be possible that you started OFBiz without building it. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Oct 29, 2009 at 3:29 PM, Mridul Pathak mridul.pat...@hotwaxmedia.com wrote: Looks like either you are missing some jar file or if these classes comes with the component then there might be some thing missing in the build configuration (build.xml) of your component. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Oct 29, 2009 at 2:14 PM, richa.mit...@lntinfotech.com wrote: I deployed Lambda probe as a component in ofbiz application. I used this link: http://bizlift.com/ofbiz/lambda_probe_for_ofbiz.html When I start the ofbiz application following exception comes: Cannot find class [org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean] for bean with name 'userDetailsService' defined in ServletContext resource [/WEB-INF/spring-root-acegi.xml]; java.lang.ClassNotFoundException: org.jstripe.tomcat.probe.beans.TomcatUsersDaoBean Thanks Richa Mittal __
Re: Promo - Buy A and get B free
Set requireCode for your promo to N on EditProductPromo screen. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Oct 28, 2009 at 7:15 PM, su2 shu...@pexsupply.com wrote: Hello Friends, I was trying to create a promo under promo tab in product catalog. The promo is Buy 1 or more of 'A' item and get 'B' free. In Conditions:X Quantity of Product; is greater than equal to; 1 Conditions Products: A In Actions: Gift with purchase; quantity=1; item=B This does not work for me. It gives Invalid code Error while using in the shopping cart. Does anybody know what am I missing? Thanks for the help in advance. -- View this message in context: http://n4.nabble.com/Promo-Buy-A-and-get-B-free-tp277461p277461.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: extending ofbiz
The standard practice is to extend the webapp in you hot-deploy component and customize the desired forms, menus and screens. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Mon, Oct 12, 2009 at 7:27 PM, Chris Snow sno...@snowconsulting.co.ukwrote: Is there documentation available describing how to extend ofbiz? In particular, I am looking for ways to extend (and hide) existing functionality. For example, if I want to add a custom menu item to a party manager profile screens, how would I do it? What about if I want to hide a menu item such as the party Billing Account menu? Many thanks in advance, Chris
Re: Product Bundling
Akhil, I am not sure if OOTB order detail shows the components of marketing package or not, if it doesn't you may want to customize the code to display the components too. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Oct 7, 2009 at 8:19 PM, Ofbiz Learner getof...@gmail.com wrote: Hi Mridul, Thanks for that. i did whatever you suggested and was able to create a product comprising of 2 product. i checked out that product and order was generated. but i didn't see that it consist of 2 items in order detail. it is showing as one Order with one product in it. shouldn't it show that it consist of 2 products. Plz help. Thanks On 10/7/09, Mridul Pathak mridul.pat...@hotwaxmedia.com wrote: Akhil, You can create a new product of type Manufacturing Package: Pick Assembly, and then you can associated the selected products that you want to sell in a bundle to this new product as components in ProductAssoc entity. For this new product you can define new prices. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Oct 7, 2009 at 6:38 PM, Ofbiz Learner getof...@gmail.com wrote: Hi, Actually i want to sell products as a group. let's say i have 3 DVDs which i sell on my site. I want to sell them as a bundle also may be on special price. For example i have 5 james bond movies on my site. i want to create a product called Best of Bond and want to sell 3 of them in a group. How i can achieve this. Plz help. Thanks, Akhil On 10/7/09, Vivek Mishra vivek.mis...@hotwaxmedia.com wrote: Hi Akhil, Your question is not clear enough. Please put some more details with your current findings that what you exactly want to achieve and what research have you done for this so far. Thanks and Regards, -- Vivek Mishra Ofbiz Learner wrote: Can anyone help me on this? On 10/7/09, Ofbiz Learner getof...@gmail.com getof...@gmail.com wrote: Hi All, i need to bundle two or more existing products. What are the ways to do it. Please Guide. -- Thanks, Akhil -- Thanks, Akhil -- Thanks, Akhil
Re: Product Bundling
Akhil, You can create a new product of type Manufacturing Package: Pick Assembly, and then you can associated the selected products that you want to sell in a bundle to this new product as components in ProductAssoc entity. For this new product you can define new prices. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Oct 7, 2009 at 6:38 PM, Ofbiz Learner getof...@gmail.com wrote: Hi, Actually i want to sell products as a group. let's say i have 3 DVDs which i sell on my site. I want to sell them as a bundle also may be on special price. For example i have 5 james bond movies on my site. i want to create a product called Best of Bond and want to sell 3 of them in a group. How i can achieve this. Plz help. Thanks, Akhil On 10/7/09, Vivek Mishra vivek.mis...@hotwaxmedia.com wrote: Hi Akhil, Your question is not clear enough. Please put some more details with your current findings that what you exactly want to achieve and what research have you done for this so far. Thanks and Regards, -- Vivek Mishra Ofbiz Learner wrote: Can anyone help me on this? On 10/7/09, Ofbiz Learner getof...@gmail.com getof...@gmail.com wrote: Hi All, i need to bundle two or more existing products. What are the ways to do it. Please Guide. -- Thanks, Akhil -- Thanks, Akhil
Re: is Stroed Procedures possible in OFBiz?
Shuchi,
One way is to define a view entity, in your component's entity-model.xml
using view-entity tag. You can use
aliascomplex-alias/complex-alias/alias child tags for your summing
requirement. This view will also be accessible in webtools. In your code
you can then use delegator methods to retrieve the list from this view
entity.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892
On Tue, Oct 6, 2009 at 7:14 PM, su2 shu...@pexsupply.com wrote:
Hi Chris,
Thank you for the response.
My query has multiple joins with different tables and also I would like to
use sum(column name) and (column 1 + column 2) as column 3.
Is it possible to use sum(column name) in java method with delegator?
Also, the stored procedure I want to use in jasper report.
Thank you for the help.
Su-
Chris Snow-3 wrote:
Hi Su,
I use SQL Views for complex queries:
entity entity-name=ClearanceReport
table-name=vClearanceReport
package-name=uk.co.dhales
title=Clearance Report Entity
no-auto-stamp=true
never-cache=true
field name=strIsrCompany col-name=strIsrCompany
type=long-varchar/
field name=strIsrBranch col-name=strIsrBranch
type=long-varchar/
field name=strIsrCode col-name=strIsrCode
type=long-varchar/
field name=ingUplNumber col-name=ingUplNumber
type=numeric/
...
prim-key field=ingUplNumber/
/entity
The table name vClearanceReport is actually a SQL View. The attributes
no-auto-stamp and never-cache where needed.
Also, here is a service that is using a SQL Stored procedure:
public class DHSequenceService {
public static Map getNextSequenceValue(DispatchContext ctx, Map
context) {
Connection conn = null;
CallableStatement statement = null;
String sql = {call getNextSequenceValue(?,?)};
Long seqValue;
try{
conn = ConnectionFactory.getConnection(dhmssql);
if (conn == null) {
throw new Exception(No dhmssql connection
configured);
}
statement = conn.prepareCall (sql);
String seqTable = (String)context.get(seqTable);
statement.registerOutParameter(1, Types.INTEGER);
statement.setString(2, seqTable);
statement.execute();
seqValue = new Long(statement.getLong(1));
statement.close();
} catch (Exception e){
Debug.logError(e, Error running SQL - ,
DHSequenceService.class.getName());
return ServiceUtil.returnError(Error running SQL + e);
}
finally {
if (statement != null)
try {
statement.close();
} catch (Exception e) {}
if (conn != null)
try {
conn.close();
} catch (Exception e) {}
}
Map resultMap = ServiceUtil.returnSuccess();
resultMap.put(seqValue, seqValue);
return resultMap;
}
}
Note that by using SQL Views/Stored Procedures you are limiting the
portability of your application to other databases.
Cheers,
Chris
su2 wrote:
Hello Friends,
I need to write quite complex query which is little easier to write as
Stored Procedures. So I would like to know whether is it possible to
write
and access stored procedures in OFBiz with mySQL?
If its possible, can i have example or reference for how to do that ?
Thank you for the help in advance.
Su-
--
View this message in context:
http://www.nabble.com/is-Stroed-Procedures-possible-in-OFBiz--tp25768161p25768992.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Calling simple method from another component
Following code will serve your purpose: call-simple-method method-name=createUser xml-resource= component://party/script/org/ofbiz/party/user/UserEvents.xml/ -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Sat, Oct 3, 2009 at 3:26 PM, ARays a...@kenfuse.com wrote: Hi, I am trying to extend PartyMgr application to cover a few additional types of uses besides Employee, Customer types, for example 'Viewer'. As just have created a new component called 'myapp' under hot-deploy folder and have been able to get the forms showing. The form submit now goes through request mapping fine in controller.xml (under myapp). See snippet below request-map uri=createViewer security https=true auth=true/ event type=simple path=component://viewer/script/org/ofbiz/party/user/UserEvents.xml invoke=createViewer/ response name=success type=request-redirect value=viewprofile/ response name=error type=view value=NewViewer/ /request-map createViewer code is on the lines similar to createEmployee that is available in UserEvents.xml under party component. The trouble is createViewer method in turn needs to call call-simple-method method-name=createUser/ createUser method is still under Party application and I looking to see if I can avoid duplicating the code and directly point to the orginal createUser method. Tried setting up a servicedef with the full package name like below but no luck. service name=createUser engine=simple default-entity-name=Person location=org.ofbiz.party.party.PartyServices invoke=createUser auth=false Any pointers to what I may be missing? Thanks Aray -- View this message in context: http://www.nabble.com/Calling-simple-method-from-another-component-tp25727271p25727271.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Creation of new Security group (Facility module)
You can manage Security Groups, their permissions and associated user logins under PartyMgr Security tab ( https://demo.ofbiz.org/partymgr/control/FindSecurityGroup). Create a new Security Group, assign FACITLITY_VIEW, FACILITY_CREATE, FACILITY_UPDATE, FACILITY_DELETE, FACILITY_ADMIN permissions to this security group as per your requirements. Then you can assign this security group to a user login from same tab or Party Profile, under User Logins screenlet. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 30, 2009 at 12:55 PM, naveen chanda chand...@gmail.com wrote: Dear All, Could anyone explain me the steps to create a new security group of type (FACILITY) to access all the screens under Facility module. How can i create and add the security group to the user. Please help to do this. Thanks and Regards, Naveen Chanda -- View this message in context: http://www.nabble.com/Creation-of-new-Security-group-%28Facility-module%29-tp25676226p25676226.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Creation of new Security group (Facility module)
Can you be more verbose with the error you are getting, console log could be helpful to know if it is a permission error or something else? -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 30, 2009 at 3:33 PM, naveen chanda chand...@gmail.com wrote: Hi, I have followed as per the steps mentioned, but the below error is getting when i login with username/password: The Following Errors Occurred: unable to login this application Please help me to solve the issue. Thanks, Naveen Chanda. Mridul Pathak-2 wrote: You can manage Security Groups, their permissions and associated user logins under PartyMgr Security tab ( https://demo.ofbiz.org/partymgr/control/FindSecurityGroup). Create a new Security Group, assign FACITLITY_VIEW, FACILITY_CREATE, FACILITY_UPDATE, FACILITY_DELETE, FACILITY_ADMIN permissions to this security group as per your requirements. Then you can assign this security group to a user login from same tab or Party Profile, under User Logins screenlet. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 30, 2009 at 12:55 PM, naveen chanda chand...@gmail.com wrote: Dear All, Could anyone explain me the steps to create a new security group of type (FACILITY) to access all the screens under Facility module. How can i create and add the security group to the user. Please help to do this. Thanks and Regards, Naveen Chanda -- View this message in context: http://www.nabble.com/Creation-of-new-Security-group-%28Facility-module%29-tp25676226p25676226.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/Creation-of-new-Security-group-%28Facility-module%29-tp25676226p25678252.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Shipment address in checkout process
Hi Simon, This is possible, AFAIK shipping address is not required for Digital and Service goods. You may need to write your custom front-end checkout for such products. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Fri, Sep 25, 2009 at 8:51 PM, Simon Hutchinson simon.hutchin...@ixxus.co.uk wrote: Hi, Is it possible to prevent the requirement of a shipping address in the checkout process for specific products (e.g Digital products made available for download). Thans Simon
Re: How to pass a parameter from drop down selected value
Make a small form around your dropdown list, on click of the link submit this form. The selected value will be posted as a parameter, which you can then capture on your next view. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Thu, Sep 24, 2009 at 5:32 PM, naveen chanda chand...@gmail.com wrote: Dear All, I have a requirement to pass a value to another form, which is selected from drop down list. When i click a hyperlink in one form, the selected value must be pass as a parameter and it should display as text field. I have seen the existing ones for reference, i cannot able to find the above one. Please help me to solve my issue. Thanks, Naveen -- View this message in context: http://www.nabble.com/How-to-pass-a-parameter-from-drop-down-selected-value-tp25561883p25561883.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: How to Create Own Store
Jitender, This should definitely help you: http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Fri, Sep 18, 2009 at 12:54 PM, Jitender Kumar Maurya jitender.kumarmau...@pb.com wrote: Hi, can u please help : How to Create Own Store using ofbiz. wating for reply Thanks. Kumar
Re: No service to get party postal address
+1 for using service to wrap the worker method. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Fri, Sep 18, 2009 at 6:00 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: I wouldn't attempt to call the service from the worker method, doing so would require that the be signature changed which means you have to deprecate the existing method and create a new one (which is a bit pointless because callers might as well call the service themselves). I would either use the service to wrap the worker method or otherwise move the code to service and deprecate the worker. Regards Scott HotWax Media http://www.hotwaxmedia.com On 18/09/2009, at 9:23 PM, Abdullah Shaikh wrote: cool I will do that it's more clear now On Fri, Sep 18, 2009 at 2:41 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: From: Abdullah Shaikh abdullah.sha...@viithiisys.com I got confused. You meant that you will commit the already provided patch ?. It was really a cursory review and I must I did not thought about generalising. I was having ContactMechWorker.getCurrentPostalAddress ContactMechWorker.getPartyPostalAddresses, in my mind, what I was thinking was that to make the getPartyPostalAddress service in java by taking the code out of the ContactMechWorker methods, and calling this service from the ContactMechWorker class, or should we let ContactMechWorker methods as it is ? and the getPartyPostalAddress service in simple-method as already provided ? Let me know. Yes you are right, but be sure to mimic exactly current behaviours. Thanks Jacques On Fri, Sep 18, 2009 at 1:06 PM, Abdullah Shaikh abdullah.sha...@viithiisys.com wrote: Hi Jacques, I will provide the patch as discussed. Just to be sure, what I need to do is : 1) Create a service to get party postaladdress (getPartyPostalAddress) 2) Call this service from the ContactMechWorker.getCurrentPostalAddress ContactMechWorker.getPartyPostalAddresses The patch that I already submitted, won't suffice, for the ContactMechWorker methods, I guess. I will need to change it to make it work as per ContactMechWorker methods, so as to get it called from these methods. Thanks, Abdullah On Fri, Sep 18, 2009 at 12:49 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Hi Abdullah, I had a quick look and it seems good. I will commit I guess. Thanks (and thank you to Sumit for the link and 1st review) Jacques From: Abdullah Shaikh abdullah.sha...@viithiisys.com I feel that we should have this service, 1) To get party's data, either we should have all the code in a class or all should be exposed as a service, to avoid confusion. Right now, it's partially from the service (i.e. email telephone) and partially from the ContactMechWorker class. All should be exposed as a service. 2) Also, as in the case of email telephone, we can export the service, no service for postal address to export. Does this makes sense ?, if yes, then I thought of making a service wrapper for ContactMechWorker.getCurrentPostalAddress ContactMechWorker.getPartyPostalAddresses, but then I noticed that one of the parameter for these methods is ServletRequest object. In this case what can be done is create a service and can it from the methods above, instead of they hitting the delegator. Please let me know your thoughts ? or am I missing something else ? On Fri, Sep 18, 2009 at 2:54 AM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: There are ContactMechWorker.getCurrentPostalAddress ContactMechWorker.getPartyPostalAddresses But yes no services, maybe because it's not needed ? Jacques From: Abdullah Shaikh abdullah.sha...@viithiisys.com There are services to get the party telephone email, getPartyTelephone getPartyEmail respectively, but no service to get the party postal address. I can submit a patch for getPartyPostalAddress service, to get the party's postal address. What do you think ?
Re: ofbiz latest stable version
Hi Anil, The latest OFBiz release is 9.04. Release 9.04 has more features then that of 4.0, you can find the differences at http://docs.ofbiz.org/display/OFBIZ/Main+New+Features. No new development occurs in the stable releases, just bug fixes, thats why they are called stable releases. Many people use release 4.0 and thats the reason it is still eligible for bug fixes. All the development is done in trunk. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Wed, Sep 16, 2009 at 2:33 PM, Anil Sharma a...@olivetech.net wrote: Hello Guys, Can any one please tell me what is the current stable ofbiz release. what us the difference between ofbiz-release9.04 and ofbiz-release4.0. why is both ofbiz9.04 and ofbiz4.0 being developed parallely Thanks, Anil Sharma -- View this message in context: http://www.nabble.com/ofbiz-latest-stable-version-tp25468563p25468563.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ofbiz latest stable version
Anil, I would definitely go with Ashish's suggestion here. Releasing a stable version doesn't means that trunk is not stable. Even the trunk is always stable except a few incidences. Working on trunk gives you opportunity to leverage most recent updates. For instance, you have requirements of Human Resource component and after release 9.04 there have been many improvements in this component, which you can facilitate by working on latest trunk. Keeping an eye on commits and dev mailing list can help you decide when to take updates, without breaking your custom code. --- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 16, 2009 at 4:04 PM, Ashish Vijaywargiya vijaywargiya.ash...@gmail.com wrote: Release-9.04 is more stable and feature reach then Release-4.0. Although if you are a developer and you understand how things are coming in OFBiz then I would prefer you to go with trunk. Just start your development keeping your custom component in hot-deploy directory on trunk and take update daily or weekly which ever option is more appropriate for you. -- Ashish On Wed, Sep 16, 2009 at 3:59 PM, Anil Sharma a...@olivetech.net wrote: Hello Mridul, Thanks for prompt reply. Actually I have some requirements which matches with that in ofbiz9.04 like Human Resource, Order Management and Product Management and warehouse etc. So now I need to make a decision to go with ofbiz9.04 or ofbiz4.0. Can you please suggest me any one in terms of features and Stability of code. Thanks, Anil Sharma. Anil Sharma wrote: Hello Guys, Can any one please tell me what is the current stable ofbiz release. what us the difference between ofbiz-release9.04 and ofbiz-release4.0. why is both ofbiz9.04 and ofbiz4.0 being developed parallely Thanks, Anil Sharma -- View this message in context: http://www.nabble.com/ofbiz-latest-stable-version-tp25468563p25469737.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product option Display
Akhil, This should help you http://www.nabble.com/Confused-about-Inventory-Items-to14330191.html#a14330191. Once you have setup your product correctly you can use OOTB Product Detail page in ecommerce which displays such products. You can customize look and feel as per your requirement. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 16, 2009 at 5:49 PM, Ofbiz Learner getof...@gmail.com wrote: Hi All, Please help me in resolving one query. i would like to add a product which may have variation. let us say that i will add a Shirt which is avilable in 3 sizes (S,M and L) and two colours ( Blue and Balck). i would like to enter them as one product but one product detail page user will have option of chossing his choice of size and / or colour. Please guide me on this. What changes is needed while enetring the product and what changes i will have to make on detail page for displaying them. what is the best way of doing this. -- Thanks, Akhil
Re: hot-deploy components build.xml
Look at build target in ${OFBIZ_HOME}/build.xml.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892
On Wed, Sep 16, 2009 at 6:51 PM, snowc chsnow...@gmail.com wrote:
How does ofbiz know how to find my components build.xml file and what
targets
to call when I run ant from OFBIZ_HOME?
Many thanks,
Chris
--
View this message in context:
http://www.nabble.com/hot-deploy-components-build.xml-tp25472248p25472248.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product option Display
Hi Akhil, May be you missed my email, but the in the link that I suggested you is a step by step procedure to create such products. Here is the link again: http://www.nabble.com/Confused-about-Inventory-Items-to14330191.html#a14330191 http://www.nabble.com/Confused-about-Inventory-Items-to14330191.html#a14330191 Try to have a good knowledge of OFBiz data model which is based on following book: http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471380237/ref=sr_1_1?ie=UTF8s=booksqid=1253164796sr=1-1. This will help you understand the business process implementation in OFBiz better. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com - direct: +91 - 942.592.6892 On Wed, Sep 16, 2009 at 7:25 PM, Ofbiz Learner getof...@gmail.com wrote: Hi Sumit, Thanks for that. Can you please throw light on this? I mean where exactly and what exactly i should look into. I am a beginner in this and any help in this will be highly appreciated. Please help and eloborate. Thanks On 9/16/09, Sumit Pandit sumit.pan...@hotwaxmedia.com wrote: Hi Akhil, You can find similar example in existing demo data in OFBiz, you can take reference of that data and create similar for your own. -- Thanks And Regards Sumit Pandit On 16-Sep-09, at 6:55 PM, Ofbiz Learner wrote: Hi Sumit, Something like that. What is the way to get this ? Thanks On 9/16/09, Sumit Pandit sumit.pan...@hotwaxmedia.com wrote: Hi Akhil, Do you mean - http://demo.hotwaxmedia.com/shopdemo/control/product/~category_id=1001/ ~product_id=Long-Sleeve-Shirt -- Regards Sumit Pandit On 16-Sep-09, at 5:49 PM, Ofbiz Learner wrote: Hi All, Please help me in resolving one query. i would like to add a product which may have variation. let us say that i will add a Shirt which is avilable in 3 sizes (S,M and L) and two colours ( Blue and Balck). i would like to enter them as one product but one product detail page user will have option of chossing his choice of size and / or colour. Please guide me on this. What changes is needed while enetring the product and what changes i will have to make on detail page for displaying them. what is the best way of doing this. -- Thanks, Akhil -- Thanks, Akhil -- Thanks, Akhil
Re: Question about new customer workflow
Look at the action attribute of form element. createcustomer request is
called on form submit. The request entry can be found in controller.xml of
ecommerce component. Here you can know about the event fired on this
request.
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
On Thu, Sep 10, 2009 at 4:21 PM, MarioF oceanoart...@gmail.com wrote:
Ops, the instruction didn't appear:
javascript:document.newuserform.submit()
class=button${uiLabelMap.CommonSave}
MarioF wrote:
Hi all,
I have to change the workflow in the new customer screen, the problem now
is that I don't know how works ofbiz when the user press the save button.
I have seen (in the newcustomer.ftl file) this instruction:
javascript:document.newuserform.submit() ${uiLabelMap.CommonSave}
So, what does it happen when the user press the save button? Which file
is
called?
Thanks in advance,
Mario.
--
View this message in context:
http://www.nabble.com/Question-about-new-customer-workflow-tp25381087p25381120.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Multiple POs in ONE shipment and on ONE Invoice
This is already supported in OFBiz. Go to Facility -- Shipment -- Order Items screen. It is possible to add multiple orders to a shipment from this screen. The primaryOrderId indicates the order for which shipment was created actually from Order Detail screen, but it doesn't restrict you from adding more orders to a shipment. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Tue, Sep 8, 2009 at 9:22 PM, masionas michael.koro...@gmail.com wrote: Hi guys, Very often supplier combines inventory from different POs in one shipment and sends it in one box. In Ofbiz, Shipment entity has a primary key as shipmentId and to indicate order it has primaryOrderId. However this design allows only one order per one shipment. Did anyone do some workarounds to have it working for multiple orders per one shipment? I can extend the Shipment entity primary key def to be a composite key with (shipmentId, primaryOrderId). But would like first to ask if there is something native supports my case. With an invoice I do not see much problem as it is not tied explicitly to orderId, so I can put there items from different orders. Thanks. -- View this message in context: http://www.nabble.com/Multiple-POs-in-ONE-shipment-and-on-ONE-Invoice-tp25348927p25348927.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: exception report
Ruth, Scott The admin user login now lies in ecommerce component as demo data. After the introduction of ant target create-admin-user-login what I remember is that seed data for admin user login was removed and for any ant target (that installs data) other than run-install, you need to create admin user login using the ant target introduced. On the other hand in case of run-install demo data for admin is present in ecommerce component, so you need not to run the other ant target. But in Ruth's case, since he commented out special purpose applications, this demo data wasn't loaded and he had to create admin user login using the ant target. The other thing is that, when you create admin user login using the ant target Party record for admin is not created, that is when you see problems such as one specified by Ruth about creating DataResource. When a DataResource is created the logged in party is associated to data resource as its owner, but since admin user doesn't have any party the business process fails. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Mon, Sep 7, 2009 at 7:23 AM, Scott Gray scott.g...@hotwaxmedia.comwrote: Hi Ruth For future reference it is much easier to help you diagnose a problem if you fully describe what changes you've made to the system. It sounds like there are dependencies on the special purpose applications in the base applications for the seed or demo data (hopefully only there) which is definitely a bug. Could you create a jira issue for this? Thanks Scott On 7/09/2009, at 1:17 PM, Ruth Hoffman wrote: Ok, I just verified that adding back specialpurpose hot-deplay fixed all my problems. After adding them back to my original working set and then running an ant clean-data, ant run-install I was able to login to webtools ( http://localhost:8080/webtools) and go to the Content tab and add Data Resource. No errors. So, Scott and David (if you are listening), is this a problem of my creation - that is taking out those two component directories is a no no - or is this a problem with the demo/seed data that comes with the distribution? TIA Ruth Ruth Hoffman wrote: Hi Scott: Here is one way things break: 1) From a fresh download start up ofbiz (./startofbiz.sh) and try to login to webtools using admin/ofbiz -- this works! 2) Comment out specialpurpose hot-deploy in ~framework/base/config/component-load.xml 3) Run ant clean-data 4) Run ant run-install 5) ./startofbiz.sh and try to login to webtools -- get the unable to login application error Did I do something wrong? Isn't one suppose to be able to decouple specialpurpose hot-deploy from the framework and still be able to use webtools? TIA Ruth Scott Gray wrote: Hi Ruth I just downloaded r809901, did an ant run-install without errors and was able to login successfully. Did you modify any of the files after downloading? Regards Scott HotWax Media http://www.hotwaxmedia.com On 7/09/2009, at 10:32 AM, Ruth Hoffman wrote: Makes sense. Shouldn't a fresh ant run-install with the download data make this all well again? I guess I'm wondering how it should work. Are you saying there is something missing in the download that should be there and that what I'm experiencing is the result of a bad release? Or, are you saying that I am not following the right procedure for getting well. After all, all I'm trying to do is login to webtools and create a new DataResource as the admin user. TIA Ruth David E Jones wrote: It's really simple. Either you have the login credentials and necessary permissions configured in the database or you don't. If you don't you can't login or access things that require permissions. If you've emptied your database and there is an error loading data you need... then the data you need isn't in there and that must be resolved first. -David On Sep 6, 2009, at 4:06 PM, Ruth Hoffman wrote: Hi David: From trunk version 809901 downloaded today/yesterday. This all started when I did an ant clean-data because I was testing and I wanted to start over with a clean database. After I did that, I couldn't login to webtools. I got the unable to login application error. So I tried to clean everything (ant clean-all/ant run-install). I still couldn't login with admin/ofbiz. So I did the ant load-admin-user-login -D... after which I was able to login, but not create the DataResource. TIA Ruth David E Jones wrote: Those look like two different things... but possibly related. The first exception report you sent over was about a foreign key violation that was part of importing the PartyDemoData.xml file. Based on that it looks like there is some bad data in that file (ie someone put some data in there in the wrong order). After that you mentioned a login error, which could be caused by missing data (ie data files that did not load
Re: exception report
May be we can move admin demo data from ecommerce component to a new CommonDemoData.xml file in framework/common component, only if it sounds reasonable.Also, what about creating a Party record for admin as part of create-admin-user-login ant target, or may be at the time of password reset? So that we don't come across issues like creating records associated to Party for a non-existing Party, normally it happens on triggers and not directly? -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Mon, Sep 7, 2009 at 4:22 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: Hi Mridul, Thanks for the info, I'm aware that the admin user login needs to be created separately but the problem is that ant run-install is no longer successful without the special purpose apps. I had a quick look into it and the first problem I saw was that myportal defines a RoleType record which is referred to in the party app data. It could be that one is the only problem but I didn't have time to look any further. Regards Scott On 7/09/2009, at 10:28 PM, Mridul Pathak wrote: Ruth, Scott The admin user login now lies in ecommerce component as demo data. After the introduction of ant target create-admin-user-login what I remember is that seed data for admin user login was removed and for any ant target (that installs data) other than run-install, you need to create admin user login using the ant target introduced. On the other hand in case of run-install demo data for admin is present in ecommerce component, so you need not to run the other ant target. But in Ruth's case, since he commented out special purpose applications, this demo data wasn't loaded and he had to create admin user login using the ant target. The other thing is that, when you create admin user login using the ant target Party record for admin is not created, that is when you see problems such as one specified by Ruth about creating DataResource. When a DataResource is created the logged in party is associated to data resource as its owner, but since admin user doesn't have any party the business process fails. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Mon, Sep 7, 2009 at 7:23 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: Hi Ruth For future reference it is much easier to help you diagnose a problem if you fully describe what changes you've made to the system. It sounds like there are dependencies on the special purpose applications in the base applications for the seed or demo data (hopefully only there) which is definitely a bug. Could you create a jira issue for this? Thanks Scott On 7/09/2009, at 1:17 PM, Ruth Hoffman wrote: Ok, I just verified that adding back specialpurpose hot-deplay fixed all my problems. After adding them back to my original working set and then running an ant clean-data, ant run-install I was able to login to webtools ( http://localhost:8080/webtools) and go to the Content tab and add Data Resource. No errors. So, Scott and David (if you are listening), is this a problem of my creation - that is taking out those two component directories is a no no - or is this a problem with the demo/seed data that comes with the distribution? TIA Ruth Ruth Hoffman wrote: Hi Scott: Here is one way things break: 1) From a fresh download start up ofbiz (./startofbiz.sh) and try to login to webtools using admin/ofbiz -- this works! 2) Comment out specialpurpose hot-deploy in ~framework/base/config/component-load.xml 3) Run ant clean-data 4) Run ant run-install 5) ./startofbiz.sh and try to login to webtools -- get the unable to login application error Did I do something wrong? Isn't one suppose to be able to decouple specialpurpose hot-deploy from the framework and still be able to use webtools? TIA Ruth Scott Gray wrote: Hi Ruth I just downloaded r809901, did an ant run-install without errors and was able to login successfully. Did you modify any of the files after downloading? Regards Scott HotWax Media http://www.hotwaxmedia.com On 7/09/2009, at 10:32 AM, Ruth Hoffman wrote: Makes sense. Shouldn't a fresh ant run-install with the download data make this all well again? I guess I'm wondering how it should work. Are you saying there is something missing in the download that should be there and that what I'm experiencing is the result of a bad release? Or, are you saying that I am not following the right procedure for getting well. After all, all I'm trying to do is login to webtools and create a new DataResource as the admin user. TIA Ruth David E Jones wrote: It's really simple. Either you have the login credentials and necessary permissions configured in the database or you don't. If you don't you can't login or access things that require permissions. If you've emptied your
Re: Re: problem Running with MS-SQL
Abhijeet, Is it OFBiz demo data or demo data created by you? If the demo data is created by you then it looks like primary key sequence problem. In OFBiz sequence always start with 1, so the recommended way of having demo/test data is have sequences less then 1, as we do have in OFBiz demo data, to avoid conflicts. You can fix your current problem by adjusting sequence for ProductDimension entity in SequenceValueItem entity, but it would be difficult if you have many such records in other entities as well. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com 2009/9/4 Abhijeet Pandey abhijeet.pan...@gmail.com Hi, i am able to connect to ofbiz with demo data after doing modification suggested. but i am not able to add product. i am getting below error -- The Following Errors Occurred: Error: Error trying to begin transaction, could not process method: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductDimension]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)) (Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.))) calling service addProductToCategory in createProductInCategory does the changes suggested below is the culprit ? Plz guide. Thanks, Abhijeet Pandey On Mon, Aug 31, 2009 at 5:42 AM, weixuezhang weixuezh...@hotmail.com wrote: Either demo data or entitymodel definition has problem. Can someone look into this problem? I found 6 places with unique=true in trunk as below. I simply changed true into false, then started from creating a new database. accounting\entitydef\entitymodel.xml 1,931: index name=GLACCT_UNQCD unique=true marketing\entitydef\entitymodel.xml 216: index name=CNTLSTCST_MSG_ID unique=true party\entitydef\entitymodel.xml (2 matches) 714: index name=COMMEVT_MSG_ID unique=true 1,007: index name=EMAIL_VERIFY_HASH unique=true product\entitydef\entitymodel.xml (2 matches) 1,839
Re: blank screen while calling java event
I see problem with the value of path attribute. Shouldn't it be TestEvents instead of testEvents? -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Thu, Sep 3, 2009 at 2:09 AM, su2 shu...@pexsupply.com wrote: Hello All, I have a request-map where I am calling a java event. -- request-map uri=CheckAccess security auth=true/ event type=java path=org.ofbiz.test.test.testEvents invoke=checkAccess/ response name=success type=view value=CheckAccess/ /request-map -- When I try to access the screen it goes to correct uri but screen is blank. And when I remove event. It shows the screen(of course not with the process which is in java event). I have jar file class-path in ofbiz-component.xml file. I would really appreciate the help. Thanks in advance. -- View this message in context: http://www.nabble.com/blank-screen-while-calling-java-event-tp25265335p25265335.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Virtual product and pricing
Depends on your requirements, AFAIK if price vary with variants then store them for variants, else storing it for virtual product will be sufficient. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Tue, Sep 1, 2009 at 6:42 PM, buzlite bzb...@gmail.com wrote: when working with virtual/variant products. where should the prices ideally be stored. should it be stored with the virtual product. with the variant. or at the feature level assoc with each variant? -- View this message in context: http://www.nabble.com/Virtual-product-and-pricing-tp25240074p25240074.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Virtual product and inventory
You are in right direction, inventory is maintained only for variant products. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Tue, Sep 1, 2009 at 6:03 PM, buzlite bzb...@gmail.com wrote: does one create an inventory item for a virtual product or does one create an inventory item for variant product? It seems that a virtual product represents a concept and does not represent something that actually have an inventory item associated with it. Thanks in advance -- View this message in context: http://www.nabble.com/Virtual-product-and-inventory-tp25239545p25239545.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com
Re: external soap service
Hi Chris, You can refer specialpurpose/oagis component for other examples of OFBiz interacting with web services. For example, oagisSendConfirmBod, oagisSendReceiveDelivery, oagisSendProcessShipment, etc. All these services post xml templates as streams to external web services. There are other examples in USPSSevices.java file as well. Hope that helps. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Mon, Aug 24, 2009 at 7:19 PM, snowc chsnow...@gmail.com wrote: Hi Vivek, I'm trying to call a web service outside of ofbiz where ofbiz is the client to that web service. I am not trying to export my code as a web service. Cheers, Chris Vivek Mishra-2 wrote: Hi, This link may help you to understand the concept http://docs.ofbiz.org/display/OFBIZ/Export+Ofbiz+Services+that+use+complex+type+parameters+via+SOAP+using+AXIS2 Thanks and Regards, -- Vivek Mishra snowc wrote: I'm trying to call an external soap service. My service definition is: service name=HpiLookup engine=soap location= http://www.q.hpi.co.uk/tradeservice/servlet/messagerouter; invoke=enquire namespaceurn:enquiry/namespace attribute name=message type=String mode=IN/ attribute name=result type=String mode=OUT/ /service My bsh: delegator = GenericDelegator.getGenericDelegator(default); dispatcher = GenericDispatcher.getLocalDispatcher(mydelegator, delegator); userLogin = delegator.findByPrimaryKey(UserLogin, UtilMisc.toMap(userLoginId, admin)); message = hpi:enquire xmlns:hpi=\urn:enquiry\ + hpi:Authentication + hpi:CustomerDetails + hpi:CustomerCodeCUSTCODE/hpi:CustomerCode + hpi:InitialsCC/hpi:Initials + hpi:PasswordPASSWORD/hpi:Password + /hpi:CustomerDetails + /hpi:Authentication + hpi:Request + hpi:Asset + hpi:Vrm/hpi:Vrm + hpi:Vin/hpi:Vin + /hpi:Asset + hpi:Product + hpi:Code/hpi:Code + /hpi:Product + /hpi:Request + /hpi:enquire; Map serviceCtx = UtilMisc.toMap(message, message, userLogin, userLogin); resultMap = dispatcher.runSync(HpiLookup, serviceCtx); -- The message input attribute is getting encoded (see below), but I just want to send the message as a raw string. Is this possible? Many thanks in advance... POST /tradeservice/servlet/messagerouter HTTP/1.0 Content-Type: text/xml; charset=utf-8 Accept: application/soap+xml, application/dime, multipart/related, text/* User-Agent: Axis/1.4 Host: www.q.hpi.co.uk Cache-Control: no-cache Pragma: no-cache SOAPAction: Content-Length: 948 ?xml version=1.0 encoding=UTF-8?soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance soapenv:Bodyenquire xmlns=message xsi:type=xsd:stringlt;hpi:enquire xmlns:hpi=quot;urn:enquiryquot;gt; lt;hpi:Authenticationgt; lt;hpi:CustomerDetailsgt; lt;hpi:CustomerCodegt;CUSTCODElt;/hpi:CustomerCodegt; lt;hpi:Initialsgt;CClt;/hpi:Initialsgt; lt;hpi:Passwordgt;PASSWORDlt;/hpi:Passwordgt; lt;/hpi:CustomerDetailsgt; lt;/hpi:Authenticationgt; lt;hpi:Requestgt; lt;hpi:Assetgt; lt;hpi:Vrmgt;lt;/hpi:Vrmgt;...lt;hpi:Vingt;lt;/hpi:Vingt; lt;/hpi:Assetgt; lt;hpi:Productgt; lt;hpi:Codegt;lt;/hpi:Codegt; lt;/hpi:Productgt; lt;/hpi:Requestgt;lt;/hpi:enquiregt;/message/enquire/soapenv:Body/soapenv:Envelope -- View this message in context: http://www.nabble.com/external-soap-service-tp25115630p25116391.html Sent from the OFBiz - User mailing list archive at Nabble.com.
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: 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
Re: passing map parameter from ftl to event type java
Hari, I am pretty sure that I have understood your problem. Here are few comments from my side: 1) AFAIK, you can never send a Java object other than String and Array as a (hidden) parameter from FTL. What you can send is string values and array. The reason is there are two major methods available with a request object to fetch parameters: String getParameters(String) and String[] getParameterValues(String). You can't fetch any parameter whose value is a Java Object of other types. 2) For your problem, when you catch the parameters in .bsh, instead of putting them in context try using request.setAttribute() method. 3) Now in your Java event use request.getAttribute() method and it should work. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] On Fri, Dec 5, 2008 at 8:37 AM, Hari Plaikoil [EMAIL PROTECTED]wrote: Hi Nalin, thanks for your response. I'll try to describe my process's path : First, when I click a submit link, it will call java service. The output of the java service are Map and JRDataSource. (on this service, there is no problem) Second, through a .bsh file, I catch the both of the parameters and put them on context (on this .bsh there is no problem), and I pass the context to .ftl file Third, on .ftl file I catch the Map and JRDataSource which has been sent by .bsh file (on context) before. And here is the problem : I want to send (again) both of the parameters to become input parameters for a java's event. I don't know how to assign both of this parameters on ftl to become attribute. So, when I catch them on java's event by code request.getAttribute(Map) it will not give me null value. I don't want to send both of the parameters on .ftl by @inputHidden. All my problem is between .ftl and java's event. There is no screen widget here. That's all. I hope you have a clear view now on my problem. Thanks nalin chandra wrote: Hi Sorry but, i don't understand your problem completely. But what ever i understand from your conversation with Scott, i think you want to send value through ftl file. So you try set field=abc from-field=parameters.abc/ set field=xyz from-field=parameters.xyz/ between screens actions/actions tag. Hari Plaikoil wrote: Dear all, Could you tell me how to pass a Map's parameter from ftl to java? When in ftl, the parameter has data. But when I call it in java's method by this code below, I got null value: MapString, Object jPrm = (MapString, Object)request.getAttribute(jrParameters); JRDataSource jrDataSource = (JRDataSource) request.getAttribute(jrDataSource); In this case, I want to pass jrParameter and jrDatasource to make a report. Please, help me... Thanks. -- View this message in context: http://www.nabble.com/passing-map-parameter-from-ftl-to-event-type-java-tp20790183p20847035.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Book on Apache OFBiz development
Anand, May be increasing Heap Memory of your Eclipse environment will resolve the problem. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] On Mon, Nov 24, 2008 at 5:12 PM, anand joshi [EMAIL PROTECTED] wrote: hi ofbiz version 2.0 eclipse Version: 3.4.0 ram 2gb but its giving memory exception,while debug the ofbiz. byee anand On Mon, Nov 24, 2008 at 3:50 PM, BJ Freeman [EMAIL PROTECTED] wrote: which version ofbiz are you using? which method did you choose to use? anand joshi sent the following on 11/23/2008 9:39 PM: Hi Failed to connect to remote VM. Connection refused. Connection refused: connect i got this error while debug the ofbiz .. can u give me the configuration of the eclipse... On Mon, Nov 24, 2008 at 10:34 AM, BJ Freeman [EMAIL PROTECTED] wrote: http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse anand joshi sent the following on 11/23/2008 8:46 PM: Hello all can any one explain me how to debug the ofbiz into eclipse.. when i debug the ofbiz its giving memory exception. byeee Anand On Sat, Nov 22, 2008 at 6:42 PM, Eric DE MAULDE [EMAIL PROTECTED] wrote: Hi, Have people bought and read this book ? What is your opinion ? My goal is to lean in order to improve or create services in trunk ! Thanks Eric - Original Message - From: Jacques Le Roux [EMAIL PROTECTED] To: user@ofbiz.apache.org Sent: Monday, November 10, 2008 7:24 PM Subject: Re: Book on Apache OFBiz development Hi all, Damian from Packt asked me if we were interested to receive information about royalties. They will send 5% of all sales to the ASF. So we have not to care about redirecting links or such, cool ! In the past Struts and SpamAssassin have already done the same and Brian Fitzpatrick (ASF Public Relations Vice President) has been involved. I will contact him soon. One more point : I have been asked if we would like to know about individual statements that breaks down the royalty (they pay the royalties on a quarterly period through PayPal to ASF). It seems to me that this would be interesting from a statistic POV. I may use my own address for that because we can't use private not dev or user ML (since I guess there will be nominative informations) and forward to private ML. What do you think ? I have set the links from news in main page and Wiki books page Jacques From: Jacques Le Roux [EMAIL PROTECTED] Thanks Marco, Packt Publishing propose to donate a percentage of the money made from each book sold to the Apache foundation, in line with [their] Open Source Project Royalty program. So I will before try to know if something already at the ASF which allows to make that easy. I will also put a link from our books page on Wiki. Of course if anybody see a problem with that feel free to express yourself Jacques From: [EMAIL PROTECTED] Hi to all, I saw on this article ( http://www.pr-inside.com/apache-ofbiz-development-the-beginner-s-tutorial-r894197.htm ) that now is available one book on Apache OFBiz development. If someone want to add it to the OFBiz site news. Thanks Marco - --
Re: how to find sub contents
Hi,Have a look at org.ofbiz.product.product.ProductContentWrapper class. This is meant to extract Product Content from related content entities. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] On Thu, Oct 23, 2008 at 5:49 PM, Loki [EMAIL PROTECTED]wrote: hi at all, actual I want to write a special standalone servlet which uses ofbiz business classes. So far so good, with org.ofbiz.product.product.ProductWorker.findProduct(...) I can access the simple content fields of a product, now I want to get some values from attached content entities, but I can't find a method to achieve these neither the GenericValue by the given productId contains the id's of the inner contents. Can anyone help me ? bye Thomas PS: we use ofbiz release 4.0
Re: inventory item status
AFAIK, Inventory Item Status are used only in case of serialized inventory, and not for non-serialized ones. So in case of non-serialized inventory items you may find blank inventory item status. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] On Mon, Oct 20, 2008 at 2:54 PM, yasin lyyas [EMAIL PROTECTED] wrote: Hi all, I have a question here regarding the inventory item status id. If the status id is blank (null), what will happen if there is a reservation made to this inventory item? In our case, we have a returned inventory item. Status ID for this inventory item has been removed ( becomes blank), and it has 10 qoh and atp. When a reservation made to this inventory item, the order becomes a backorder. atp/qoh is 9/10, but in reservation table, it shows the qty not available = 1. Can we not leave the inventory item status blank? Thanks Lyyas Yasin
Re: ecommerce shopping cart checkout
Hi, Those checkboxes are for following two functionalities: 1) Remove Selected Items from Shopping Cart 2) Add selected items to shopping list For your desired functionality, you can first check those items which you want to buy later and add them to an existing shopping list or create a new shopping list for them. Then you can remove the selected items from cart and proceed for checkout with only those items you wish to purchase now. At later date you can visit the application, view your shopping lists and create an order from that shopping list with the remaining items. I hope this helps :). -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] On Fri, Oct 3, 2008 at 11:12 AM, Grant Edwards [EMAIL PROTECTED] wrote: Hi I have added 3 products to my shopping cart and when viewed at http://demo.hotwaxmedia.com/ecommerce/control/view/showcart every thing looks great. However, if I then tick the check box for just one of the products, expecting only to checkout this single product, and proceed to the final checkout options page ( https://demo.hotwaxmedia.com/ecommerce/control/checkoutoptions) all 3 products are present on this page and ready for final order submission. This is not the behaviour I was expecting. I was hoping to be able to selectively checkout products from my shopping cart and return to this shopping cart at a later date to once again checkout all or a subset of products in the shopping cart. Any help would be greatly appreciated. Kind regards Grant Edwards
Re: search form
Hi Adithi, Here are the answers to your questions: 1) env-name refers to the name of the environment variable which you either create or is available in the screen context (in this particular case). 2) performFind service is a generic service available in OFBiz which performs search on a single entity. Its not necessary to use performFind service for your application, but it provides you with the logic to perform search in a single entity (or a view-entity) on different conditions. So you can always use it if it matches your criteria. 3) Since performFind service is already available in OFBiz you need not to define it any where, neither you need any script/*service.xml file unless required. You can find it in framework/common/servicedef/services.xml. On Tue, Sep 30, 2008 at 10:31 PM, adithi agarwal [EMAIL PROTECTED]wrote: Hii all Can someone tell me this Iam trying to create a search form as in findExample.. For that service name=performfind is used in findExample form serviceservice-name=performFindresult-map-name=resultresult-map-list-name=listIt field-mapfield-name=inputFieldsenv-name=exampleFeatureCtx/ field-mapfield-name=entityNamevalue=ExampleFeature/ /service (What is env-name referring to..) For my application also do I have to use performfind for search form. If so where do I define the performfind service in context.and do I need script/*services.xml Thankyou -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED]
Re: entity-one
Hi Divesh, Aditi For #1 I would just like to add that its not necessary to use override tags with interfaces only. You can obviously use them when you use auto-attribute tag in you service definition. So the use of override tag in this service definition is completely fine and as this service definition comes from OFBiz itself, it can't be wrong :). The use of override tag is to override the behavior of a field that comes from an interface or auto-attribute tag or some other implemented service, in our service definition. On Mon, Sep 29, 2008 at 8:27 PM, Divesh Dutta [EMAIL PROTECTED]wrote: service name=createExample default-entity-name=Example engine=entity-auto invoke=create auth=true descriptionCreate a Example/description permission-service service-name=exampleGenericPermission main-action=CREATE/ auto-attributes include=pk mode=OUT optional=false/ auto-attributes include=nonpk mode=IN optional=true/ override name=exampleTypeId optional=false/ override name=statusId optional=false/ override name=exampleName optional=false/ /service 1)This is service definition.you dont need override tag here.if you implement any interface just like when we implement any class in java,then you need override tag. 2)engine=entity-auto:: reason for using this tag is given below in this link: http://www.nabble.com/The-fancy-new-entity-auto-service-execution-engine-td18674040.html 3)engine=entity-auto invoke=create play the role for creating the records for the default-entity Example. 4) auto-attributes include=pk mode=OUT optional=false/ auto-attributes include=nonpk mode=IN optional=true/ This tag automatically includes primary key and non primary key of default-entity-name=Example Additional tags can be added by: attribute name=firstName mode=IN type=String optional=false/ 5)auto-attributes tag are used only in service definition. 6)Please refer to practice application.I have already given you the link.most of the answer of your question are given over there. Thanks And Regards Divesh Dutta Hotwax Media Pvt Ltd. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED]
Re: Many entities that should has foreign key but it not, why?
No foreign key indices are maintained for the one-nofk relationship, that is the reason why no foreign key constraints apply to a one-nofk relationship. This may be the reason that you are not able to locate this relation is the constraint part. You can find this relationship in the Webtools application in context of the entity you are looking for. In case of one-nofk relationship constraints do not apply but you can fetch the related data on the basis of this relationship. This is the reason of keeping this relationship, you can have access to related data but you need not to worry about any constraints while performing CRUD operations. On Wed, Jun 25, 2008 at 6:59 PM, him_aeng [EMAIL PROTECTED] wrote: Sorry for asking another question. When I see to the Real Database that OFBiz just constructed and look in to the constraint part of PaymentBudgetAllocation I can't see any thing that point to the one-nofk thing. It show only which is one thing in database. Is that mean, It doesn't matter that you specify relation-type = one-nofk or not? The real entity in RDBMS remain the same (don't have relation at all). So, I just feel strange that what the purpose of one-nofk relation-type? Thank and Regards Tanakorn Numrubporn Rishi Solanki wrote: The relation-type = nofk is used when we need a relation but don't want to apply foreign key constraints on it. This relation comes in existance only when we need to use the attribute of a entity into another entity. And we needed that when we delete/expire a record from entity say PaymentBudgetAllocation then their is no need to delete the record from BudgetItem. In such case we specify relation-type = nofk. Thanks and Regards [Rishi Solnaki] On Tue, Jun 24, 2008 at 5:41 PM, him_aeng [EMAIL PROTECTED] wrote: I see you intent to make two of compound key (budgetId and budgetItemSeqId) of PaymentBudgetAllocation entity have relation-type = nofk that not similar to The Data Model Resource Book Vol.1 in Figure 8.10. I think you have to has a good reason for implementation /applications/accounting/entitydef/entitymodel.xml entity entity-name=PaymentBudgetAllocation package-name=org.ofbiz.accounting.payment title=Payment Budget Allocation Entity field name=budgetId type=id-ne/field field name=budgetItemSeqId type=id-ne/field field name=paymentId type=id-ne/field field name=amount type=currency-amount/field prim-key field=budgetId/ prim-key field=budgetItemSeqId/ prim-key field=paymentId/ relation type=one fk-name=PAYMENT_BA_BDGT rel-entity-name=Budget key-map field-name=budgetId/ /relation - relation type=one-nofk rel-entity-name=BudgetItem + relation type=one fk-name=PAYMENT_BUDGIT rel-entity-name=BudgetItem key-map field-name=budgetId/ key-map field-name=budgetItemSeqId/ /relation relation type=one fk-name=PAYMENT_BA_PMT rel-entity-name=Payment key-map field-name=paymentId/ /relation /entity and another question in the same figure in the book (Figure 8.10). In order_item entity has two attribute that is budgetId and budgetItemSeqId but you don't use it to link to budget_item entity, and I don't know why? /applications/order/entitydef/entitymodel.xml entity entity-name=OrderItem package-name=org.ofbiz.order.order never-cache=true title=Order Item Entity field name=orderId type=id-ne/field field name=orderItemSeqId type=id-ne/field field name=externalId type=id/field field name=orderItemTypeId type=id-ne/field field name=orderItemGroupSeqId type=id-ne/field field name=isItemGroupPrimary type=indicator/field field name=fromInventoryItemId type=id/field field name=budgetId type=id/field field name=budgetItemSeqId type=id/field ... + relation type=one fk-name=ORDER_ITEM_BUDGET_ITEM rel-entity-name=BudgetItem + key-map field-name=budgetId/ + key-map field-name=budgetItemSeqId/ + /relation -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18089666.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18112499.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED]
Re: Query entity
You have not defined the prim-key fields and also you have not defined the
foreign key relationships if any of the field is coming from some other
entity.
On Mon, Apr 21, 2008 at 10:45 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
One thing that jumps out at me is that I see no primary key.
Perhaps adding
prim-key field=asset_itemid/
and maybe if asset_itemid is not always unique
prim-key field=depid/
-Original Message-
From: Nattanicha Rittammanart [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 20, 2008 1:38 PM
To: user@ofbiz.apache.org
Subject: Query entity
Hi all,
I have a problem to ask you.
I have table like this:
entity package-name=org.ofbiz.ams.ams
entity-name=DepreciationTrans title=Keeps depreication record from
depreciation table which created in each period
field type=id-ne name=asset_itemid/field
field type=id-ne name=depid/
field type=id name=account_no/
field type=currency-amount name=value_before_cal/
/entity
I want to show it by using form, I do like this:
form name=ShowDepreTables type=list list-name=depre_to_dates
paginate-target=ShowDepreTable
actions
entity-condition entity-name=DepreciationTransorder-by
field-name=calculate_date//entity-condition
/actions
field name=asset_itemid title=asset
itemiddisplay//field
field name=depid title=department iddisplay//field
field name=account_no title=account
numberdisplay//field
field name=value_before_cal title=before
pricedisplay//field
/form
But asset_itemid is a field which link from another table. If I show
table as above, it will show asset_itemid. What I want is, I need it
to show asset_item_name. So, I do like this:
..
field name=asset_itemid title=asset item name
display-entity entity-name=AssetItems
description=${asset_item_desc}
key-field-name=asset_itemid/display-entity
/field
..
But it caused error like this
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://ams/widget/common/CommonScreens.xml#GlobalDecorator]:
java.lang.IllegalArgumentException: Error getting value from the
database for display of field [asset_itemid] on form
[ShowDepreTables]: org.ofbiz.entity.GenericModelException:
[GenericDelegator.findOne] Passed primary key is not a valid primary
key:
[GenericEntity:AssetItems][asset_itemid,08000200010002(java.lang.String)]
(Error getting value from the database for display of field
[asset_itemid] on form [ShowDepreTables]:
org.ofbiz.entity.GenericModelException: [GenericDelegator.findOne]
Passed primary key is not a valid primary key:
[GenericEntity:AssetItems][asset_itemid,08000200010002(java.lang.String)])
How can I do to link asset_item_name from another table to show in
table which has asset_itemid??
Thank in advances,
Nattanicha
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.0/1381 - Release Date: 4/16/2008
9:34 AM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.0/1381 - Release Date: 4/16/2008
9:34 AM
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
Re: Discovering Program Flow
Hi,The best way to trace the process is to watch the consol log properly and you may go through the control flow, and put debug statements in different methods to debug the code. Now moving to your problem, I tried to trace the flow for Purchase Order and was able to trace where exactly the call is made for creating Invoice while receiving the purchase order. On following the consol log carefully I found that after processing receiveInventory and createShipmentReceipt, on updateShipment service createInvoiceFromShipment is triggered as an ECA. And after that capturePaymentFromInvoice service is triggered as an ECA on createInvoiceForOrder. The service createInvoiceForOrder is called inline from createInvoicesFromShipments service which again is called inline from creatInvoicesFromShipment service. I'll like to suggest you to debug the process to understand it better, because this is a very complicated process and I think just reading out the code may not be of much help. On Fri, Apr 4, 2008 at 4:47 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am writing purchase orders, and then receiving them. As part of that process, an Invoice is being created when the items are received I see a shipment and shipmentItems created, .ItemIssuance and related, InventoryItem and Detail, and several others. For the life of me, I cannot see what code is being called to create the Invoice. This is not the first time I ran into this. I have searched all the routines called directly and the ecas two levels down so far, but still cannot find out how the invoice is being created. Can someone tell me what is the best way and/or resources to use to discover how these things happen when you can't trace through the code. Skip No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: 3/31/2008 10:13 AM -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Disable JobManager
Yes Bilgin, you are right. Job Manager is used by the service engine to run and manage async services. And I don't think there is any way to stop Job Manager and even one should not attempt doing that. On Fri, Apr 4, 2008 at 2:32 PM, Bilgin Ibryam [EMAIL PROTECTED] wrote: Vedam, If I'm not wrong Job Manager is used by service engine for async services so better do not stop it(and I don't know how can you do it). Bilgin -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Error processing payment authorization
Hi Case, The store setting which you have used, i.e. PRDS_PAY_EXTERNAL is basically used for the external payments, for example via paypal or worldpay or for offline and cod payments. Following are the Demo ProductStorePaymentSettings for the Credit Card Payments extracted from trunk/ecommerce/data/DemoProduct.xml : ProductStorePaymentSetting productStoreId=9000 paymentMethodTypeId= CREDIT_CARD paymentServiceTypeEnumId=PRDS_PAY_AUTH paymentService= alwaysApproveCCProcessor/ ProductStorePaymentSetting productStoreId=9000 paymentMethodTypeId= CREDIT_CARD paymentServiceTypeEnumId=PRDS_PAY_RELEASE paymentService= testCCRelease/ ProductStorePaymentSetting productStoreId=9000 paymentMethodTypeId= CREDIT_CARD paymentServiceTypeEnumId=PRDS_PAY_CAPTURE paymentService= testCCCapture/ ProductStorePaymentSetting productStoreId=9000 paymentMethodTypeId= CREDIT_CARD paymentServiceTypeEnumId=PRDS_PAY_REAUTH paymentService= alwaysApproveCCProcessor/ ProductStorePaymentSetting productStoreId=9000 paymentMethodTypeId= CREDIT_CARD paymentServiceTypeEnumId=PRDS_PAY_REFUND paymentService= testCCRefund/ You may change the productStoreId and paymentService fields if you are using different ones, rest of the settings must remain same. On Tue, Apr 1, 2008 at 11:59 PM, Case Torres [EMAIL PROTECTED] wrote: Hi, All of our orders are thru Order Entry. Some orders are paid thru credit card, most are not. We do not use a authorization service but manually authorize the cc payment. We need all the pertinent CC payment information in the db for the order. When processing a cc order I can get to the final order page and there is an Authorization button when I click on this I'm sent to the Accounting package Authorize screen and clicking on the Authorize button I get the following error. Error processing payment authorization: org.ofbiz.base.util.GeneralException: Could not find any valid payment settings for order with ID [QC10155], and payment operation (serviceType) [PRDS_PAY_AUTH] OFBiz version 4 is installed. My store settings Payment Type for CC's is set to PRDS_PAY_EXTERNAL. Is there another setting some where that I need to set to be able to process CC payments manually in the system? Also, I did quite a bit of searching and couldn't find any documentation on how to setup manual cc processing via Order Entry. Point me in the right documentation direction is they're out there. Thanks much in advance, --- Case Torres [EMAIL PROTECTED] -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: component not found when invoking notifications
Hi Ryan,
Can you please let me know if that have you written some custom code or are
you running the OFBiz code? If you have written anything custom, than is it
ok for you if you can share ProductStoreEmailSettings at your end, if you
have defined any custom ones? Please let me know which process in OFBiz you
are exactly trying to run.
On Wed, Apr 2, 2008 at 4:44 AM, Ryan Sweet [EMAIL PROTECTED] wrote:
Hi All,
I'm having a problem getting the notification emails wired up. When a
service invokes the notification service, it tries to load the email
from the provided templates, and can't find it via the normal
component:// URL.
[NotificationServices.java:204:ERROR] Problem getting the template URL:
component://party/widget/partymgr/PartyEmailNotification.xml#CreatePartyNotification
not found
I've verified that
${OFBIZ_HOME}//party/widget/partymgr/PartyEmailNotification.xml exists
and has a screen named CreatePartyNotification.
I don't see where else to look for this guy.
Is there some reason that in the context of NotificationServices the
reference to component:// urls would not be valid?
regards,
-Ryan
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
__
Office : 509.855.4113
Mobile : +919425926892
Re: component not found when invoking notifications
Actually, the error you are getting is in prepareNotification() method of
NotificationServices class. This method is called from sendNotification()
method of the same class which is invoked through
sendGenericNotificationMail service in services_email.xml. Now this service
actually uses a template (ftl) to render the email body. But the URL you
are passing renders a screen, and such a url is used in the service
sendMailFromScreen. So this problem is not related to the component URL.This
lead me to think that you might be using wrong ProductStoreEmailSettings.
On Wed, Apr 2, 2008 at 10:19 AM, Mridul Pathak
[EMAIL PROTECTED] wrote:
Hi Ryan,
Can you please let me know if that have you written some custom code or
are you running the OFBiz code? If you have written anything custom, than
is it ok for you if you can share ProductStoreEmailSettings at your end, if
you have defined any custom ones? Please let me know which process in OFBiz
you are exactly trying to run.
On Wed, Apr 2, 2008 at 4:44 AM, Ryan Sweet [EMAIL PROTECTED] wrote:
Hi All,
I'm having a problem getting the notification emails wired up. When a
service invokes the notification service, it tries to load the email
from the provided templates, and can't find it via the normal
component:// URL.
[NotificationServices.java:204:ERROR] Problem getting the template URL:
component://party/widget/partymgr/PartyEmailNotification.xml#CreatePartyNotification
not found
I've verified that
${OFBIZ_HOME}//party/widget/partymgr/PartyEmailNotification.xml exists
and has a screen named CreatePartyNotification.
I don't see where else to look for this guy.
Is there some reason that in the context of NotificationServices the
reference to component:// urls would not be valid?
regards,
-Ryan
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
__
Office : 509.855.4113
Mobile : +919425926892
--
Thanks Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
__
Office : 509.855.4113
Mobile : +919425926892
Re: Product features, virtuals and variants: an alternative approach.
Thanks Hans for clarifying my doubts. This is really a nice functionality and will be very useful if added to OFBiz. On Fri, Mar 28, 2008 at 6:52 AM, Hans Bakker [EMAIL PROTECTED] wrote: Hi Mridul. On Thu, 2008-03-27 at 20:21 +0530, Mridul Pathak wrote: . My question is, can't it be possible that a customer selects a set of features for which no variant exists and also the company does not sell such a product? These incompabilities of features can be entered in a existing table called 'ProductFeatureIactn'. We will add some screens to maintain this table. Regards, Hans Current function in OFBiz. -- The OFBiz system has a facility to allow the selection of variants of a basic product called a 'virtual' product, for example a t-shirt. This shirt can have colors and sizes. These colors and sizes can be defined in features types. Features relate to these feature types and specify the actual sizes and colors. These features can be specified on the virtual product as selectable features and as standard features on the variant products. Not all feature combinations need to be there if certain features combinations are not available or compatible. Only feature combinations which result in existing variant products can be selected when the product is ordered. Current implementation. --- The current OFBiz implementation builds a variant tree according the features listed on the virtual product, checks if the related variant is present. When not found, the feature will not be in the tree and cannot be selected. This is fine upto about 200 variants. if more variants are present, the time to built the tree and the size become too big. The service used is called 'getProductVariantTree' and is called from the productdetail.bsh program. Proposed alternative approach. -- Instead of creating a variant tree, a feature tree should be created using the specified features on the virtual product without checking the available variants. In order to be able to specify incompatibilities between features the existing entity 'ProductFeatureIactn' should be used where general (no productId) or specific (with productId) dependencies or incompatibilities can be specified. If a feature selection is done at order entry, the related variant should be found which has all these standard features. If the variant can be found, the processing is the same as it is now: this variant will be added to the shoppingcart using the variant prices. If the variant cannot be found, the system will create the variant automatically, using the prices in the to be created 'FeaturePrice' entity similar to the 'ProductPrice' entity. The prices in this table however are price adjustments to the price specified on the virtual product. This new approach can be added to the existing implementation by adding a field to the product or allow more values in the 'isVirtual' field and change the processing accordingly. -- AntWebsystems.com: Quality OFBiz services for competitive rates. -- AntWebsystems.com: Quality OFBiz services for competitive rates. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Product features, virtuals and variants: an alternative approach.
Please see the comments below. On Thu, Mar 27, 2008 at 4:57 PM, Jacopo Cappellato [EMAIL PROTECTED] wrote: Hans, it looks good to me; please see my comment below: On Mar 26, 2008, at 9:02 PM, Hans Bakker wrote: Good morning! (at least for me it is...) As I have written before I have a customer who has many variants (1000) which do not really fit in categories or configurations and it has to work with drop-shipments. This alternative proposal has practically no limit on the number of variants and is largely compatible with the current implementation. Please let me know for comments/questions and enhancements and what the opinion of the community is, and if this is a valuable addition to the current system. Regards, Hans Current function in OFBiz. -- The OFBiz system has a facility to allow the selection of variants of a basic product called a 'virtual' product, for example a t-shirt. This shirt can have colors and sizes. These colors and sizes can be defined in features types. Features relate to these feature types and specify the actual sizes and colors. These features can be specified on the virtual product as selectable features and as standard features on the variant products. Not all feature combinations need to be there if certain features combinations are not available or compatible. Only feature combinations which result in existing variant products can be selected when the product is ordered. Current implementation. --- The current OFBiz implementation builds a variant tree according the features listed on the virtual product, checks if the related variant is present. When not found, the feature will not be in the tree and cannot be selected. This is fine upto about 200 variants. if more variants are present, the time to built the tree and the size become too big. The service used is called 'getProductVariantTree' and is called from the productdetail.bsh program. Proposed alternative approach. -- Instead of creating a variant tree, a feature tree should be created using the specified features on the virtual product without checking the available variants. In order to be able to specify incompatibilities between features the existing entity 'ProductFeatureIactn' should be used where general (no productId) or specific (with productId) dependencies or incompatibilities can be specified. If a feature selection is done at order entry, the related variant should be found which has all these standard features. If the variant can be found, the processing is the same as it is now: this variant will be added to the shoppingcart using the variant prices. If the variant cannot be found, the system will create the variant automatically, using the prices in the to be created 'FeaturePrice' entity similar to the 'ProductPrice' entity. The prices in this table however are price adjustments to the price specified on the virtual product. This new approach can be added to the existing implementation by adding a field to the product or allow more values in the 'isVirtual' field and change the processing accordingly. We may also use a new product type for this. Or may be we can add another field (something like isVirtual) to the entity and use it in combination with isVariant in the same way it is done for Virtual and Variant. Another option can be to add a field in ProductStore or Product itself which can be used to select one of the two approaches, i.e. use Feature Tree or Variant Tree for the Virtual/Variant products (we can create enumeration for this field). This way the Virtual/Variant logic will remain untouched and you will just need to specify the approach to be used while dealing with such products. Jacopo -- AntWebsystems.com: Quality OFBiz services for competitive rates. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Error while receiving inventory in inventory
If you are not using the Accounting module much and specifically the GL section, than go to accounting -- ofbiz-component.xml and comment the entry for secas_ledger.xml in that file, restart the server and try again. I think this may solve your problem. On Fri, Mar 28, 2008 at 3:23 PM, Rupinder [EMAIL PROTECTED] wrote: Hi While receiving an product item in inventory I am getting the following error: Error:Error trying to begin transaction, could not process method: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [createAcctgTransAndEntries] threw an unexpected exception/errororg.ofbiz.service.ServiceValidationException: The following required parameter is missing: [OUT] [createAcctgTransAndEntries.acctgTransId] (The following required parameter is missing: [OUT] [createAcctgTransAndEntries.acctgTransId]) calling service balanceInventoryItems in receiveInventoryProduct. I am getting this error after upating ofbiz through SVN 15 days ago. The previous version, which was around one year old, didn't gave any such error. Can somebody shed light on this. -- View this message in context: http://www.nabble.com/Error-while-receiving-inventory-in-inventory-tp16348992p16348992.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Can't Approve Orders with service products
Hi Enrique,Please see my comments below. On Fri, Mar 28, 2008 at 5:46 AM, Enrique Ruibal [EMAIL PROTECTED] wrote: Hello Mridul. with regard to your comments below: This is fairly simple. Any service or digital product is a non shippable item, so it can be fulfilled as soon as it has been ordered. Just think about some membership product on an online store of a Club. If a user orders such product, and provides the required billing information like Credit Card etc, then we can at the same moment fulfill his order by capturing the payment from his credit card, and therefore at same time invoice is generated and its status is updated to PAID as well. But this does not apply for general inventory products which are shippable items. First the order is created by the customer, which need to be than approved by the CSR. You need to check if the product is available in the inventory, then pick, pack and ship. This is a simple abstract of the complete process, may be I have missed out something. Since the logic of fulfillment is different for such products, than obviously different business rules will be applied to them. I see your point, but what if: 1) A customer places a multi-line item order containing several finished 'inventory goods' as well as some service items WITHIN THE SAME ORDER, shouldn't ofbiz business logic be able to handle this nicely? I tried this out and was successful at that. I added one service product and one general inventory product and created an order for that. The digital Item got fulfilled when I created the order and the inventory item was in approves status. Only one invoice was generated for them. Now I quick shipped entire order and was again successful at that. The inventory product that I ordered was in completed status and the order as well. But the change I saw was that now there were two invoice for the same order, one for digital product and the other for inventory product. Didn't get any errors at all. I think this logic is handled pretty well in OFBiz. At this point I would like to ask you that are you using the latest version of OFBiz? 2) The CSR needs to place some service orders required by customers without an upfront payment, I mean in many cases there is no credit card or a check paid on advance, and this is a pretty common business situation too. I think all these situations are handled in OFBiz and you may need to explore it well. Go through the ProductStore entity and the Demo Data it contains using webtools. You can find this data in ecommerce/data/DemoProduct.xml as well. There you can find lots of fields which can be used to manage the Order Process. For example, there is a field autoApproveOrder which can be set to Y if you want to automatically approve the order when it is created. There are some fields to control invoicing too. You can use the perfect combination for you while defining your own ProductStore. Finally I would like to suggest you to follow the back end logic for the order processing and get a better understanding of what is happening there. Go through the requests, events called on these requests, eca's triggered on different service events, etc. This will take a lot of time, but I think that will help you to understand the process well and use it perfectly according to your requirements. Please, let me know your advise on this.. -Enrique -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892 -- View this message in context: http://www.nabble.com/Can%27t-Approve-Orders-with-service-products-tp16242722p16343111.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Can't Approve Orders with service products
On Wed, Mar 26, 2008 at 1:10 AM, Enrique Ruibal [EMAIL PROTECTED] wrote: I do have the following questions with regard to invoicing of service products through ofbiz, as per your last reply: Any invoice against an order is generated automatically in OFBiz through service eca's when the order is created. We can create manual invoices as well in Accounting Component. The invoice is created for the orders containing service/digital products in the same way as it is done for any physical product, with the only difference, that, it is updated to the Paid status automatically because the order for such products is completed and payment is captured as well directly. Any digital product is obviously a product for Company and the customer, with the sale price defined and since it can be ordered by the customer, I think we can easily create an invoice against that order. You can find link to the invoices against an order in the *Payment Information* section of the Order Detail page. Why is the service good invoice generated ONLY AFTER payment is received? Why are there different business rules for invoicing a product depending wether customer is ordering an inventory good or a service item, what does this has to do with issuing an invoice to the customer? This is fairly simple. Any service or digital product is a non shippable item, so it can be fulfilled as soon as it has been ordered. Just think about some membership product on an online store of a Club. If a user orders such product, and provides the required billing information like Credit Card etc, then we can at the same moment fulfill his order by capturing the payment from his credit card, and therefore at same time invoice is generated and its status is updated to PAID as well. But this does not apply for general inventory products which are shippable items. First the order is created by the customer, which need to be than approved by the CSR. You need to check if the product is available in the inventory, then pick, pack and ship. This is a simple abstract of the complete process, may be I have missed out something. Since the logic of fulfillment is different for such products, than obviously different business rules will be applied to them. Could you please try to complete and order with two detail items, one is an inventory good say GZ-2644, and the other one is a suscritption service say GZ-NEWS-1MO and let me know what is the outcome you get? I cannot complete this in my ofbiz instance..thanks in advance I didn't get time to try this today. I'll surely run that process tomorrow. -- View this message in context: http://www.nabble.com/Can%27t-Approve-Orders-with-service-products-tp16242722p16286882.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Catalog -- Stores -- Emails
Heidi, The screen you have specified here represents Email Settings for your product store. Here are the answers to your questions. 1) *Body Screen Location:* Here you specify the Component Uri location for the screen-widget which contains the template for your email body and will be renered in your email. 2) *Attachment Screen Location (XSL-FO):* Here you specify the Component Uri location for the screen-widget which contains the template for your email attachment (pdf) and will be sent as an attachment in your email. 3) If you want the system to send emails than you must need to change the value of *mail.notifications.enabled* property to *Y* in *general.properties * file. On Mon, Mar 24, 2008 at 4:33 AM, Heidi Dehaes [EMAIL PROTECTED] wrote: Can someone explain me the fields in this screen: Catalog -- Stores -- Emails What is meant by: Body Screen Location: Attachment Screen Location (XSL-FO) : ??? What do i have to fill in? Also if i select registration for the email, will the system send automatically an email after someone registrates??? It seems this doesn't work by me! Regards, Heidi Dehaas -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Can't Approve Orders with service products
Enrique, According to my understanding, Digital as well as Service products are the non-shippable products. Hence whenever you create an order for them they are directly fulfilled (payment is captured as well) and the status is set to COMPLETE by default. You need not to first create an order, approve it and then set it to complete status. This type of flow is followed for Physical Products where, first the order is created, then approved and finally shipped (COMPLETED) based on the Inventory available. Also a completed Order can never be set back to approved status. This is against business logic hence such functionality is restricted in OFBiz using StatusValidChange entity. On Mon, Mar 24, 2008 at 5:05 AM, Enrique Ruibal A. [EMAIL PROTECTED] wrote: I placed the following order in Managment demo -trunk-, but when I tried to approve it, it sends the following error: The Following Errors Occurred: ERROR : Could not change order status ; status is not a valid change.: [ORDER_COMPLETED] - [ORDER_APPROVED] I also tried with other digital goods and no success.. Product Status QuantityUnit / List Adjustments Sub Total GZ-NEWS-1MO - Gizmo Newsletter 1 Month Catalog https://demo.hotwaxmedia.com/catalog/control/EditProduct?productId=GZ-NEWS-1MO Ecommerce https://demo.hotwaxmedia.com/ecommerce/control/product?product_id=GZ-NEWS-1MO Inventory https://demo.hotwaxmedia.com/catalog/control/EditProductInventoryItems?productId=GZ-NEWS-1MOshowAllFacilities=YexternalLoginKey=EL91956417685 Required for SO 1 In Inventory [Web Store Warehouse] QOH 0 (ATP: 0) In Inventory [All Facilities] QOH 0 (ATP: 0) On Order0 In Production 0 Unplanned 1 Current Created 2008-03-23 18:24:00.126 Created *Ordered* 1 *Ship Request* 0 *Cancelled* 0 *Qty Picked*0 *Remaining* 1 *Qty Shipped* 0 *Shortfalled* 0 *Outstanding* 1 *Invoiced* 0 *Returned* 0 $3.99 / $5.00 ($3.99) $0.00 -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: How to use event to send session parameter
There can be two cases: 1) In the request-map you are using Java Engine. In this case of a Java Event you can get the session object from a request object available to you in the event by useing *getSession()* method on request object. Now you can get all your required session infromation from the session object. There are lots of examples that you can find in OFBiz for this approach. 2) In the request-map you are using Service engine, and in the service definition you are using engine type of Java. In this case session object is not available to you, but it can be made availabel by adding an IN attribute to your service definition in the following way: attribute mode=IN name=session optional=true type= javax.servlet.http.HttpSession/. Now you can get this session object in your Java Service from the context map in the following way: HttpSession session = (HttpSession)context.get(session); I think this way you can access the session information. On Sat, Mar 22, 2008 at 7:03 AM, Nattanicha Rittammanart [EMAIL PROTECTED] wrote: Dear all, I need to work with session information. I knew that we can send session information to Java engine by using event. Anyway, I don't know how to do this. Who used to do this please tell me or tell me where I can read this is also OK. Thanks in advance. Nattanicha -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Picture
I think this link can help you to understand the use of this screen: http://www.nabble.com/Data-File-tool-Help-for-comma-seperated-file-to6654086.html#a6654086 On Wed, Mar 19, 2008 at 8:46 PM, ladroge [EMAIL PROTECTED] wrote: Someone can explain me how to use this screen of admin tools in ofbiz? Thanks http://www.nabble.com/file/p16144714/Data_file.jpg -- View this message in context: http://www.nabble.com/Picture-tp16144714p16144714.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: uiLabelMap access from a service?
Peter, Are you writing your service in Java or Minilang?? 1) If you are writing the service in Java then you can use * org.ofbiz.base.util.UtilProperties* class and its methods to access the properties files. If you specifically want to get a map of all the properties in a field you can use *UtilProperties.getResourceBundleMap(String resource, Locale locale)* method which will return all the properties from the resource file in a Map. There are other useful methods as well which you can use according to your purpose. 2) If you are writing your service in minilang, than there are some special tags availble which adds, checks and return errors in a service which also uses localized strings from property files. The below structure can be used to return an error in a service containing a string from properties file: *add-error fail-property resource= property= / /add-error check-errors/ * There is another tag *property-to-field* which can be used to access any property from a property file in our service. If you want all the properties from a property file in a Map, than you can use *call-class-method* tag to call the static method that I suggested in first point above. On Wed, Mar 19, 2008 at 9:53 PM, Peter Felts [EMAIL PROTECTED] wrote: Does anyone know if there is a way to access a uiLabelMap (the list of local text strings, etc. associated with a language in an application /Module/config/your language here.properties) from within a service that only has access to the DispatchContext and the Map objects? What I am trying to do is return errors from a service containing localized strings. Any ideas? Thank you. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Some questions on Sales Order and Sales Invoice
On Wed, Mar 19, 2008 at 3:53 PM, james yong [EMAIL PROTECTED] wrote: Hi, I have a couple of questions. 1. Let say I logged in as an admin and created an order. From the order list tab of the Order Manager, there is a list of checkboxes for the status which includes Created, Processing, Approved, Held, Completed etc. So how can I set the status of the order to Completed? Right now, I can only toggle between Approved and Held status. An order is said to be completed when it has been shipped. Go to the Order Detail page where you can find the link to *Quick Ship Entire Order*and other links to manually ship the order. 2. I created a sales invoice but didn't find a field where I can add in a PO number. Have I missed anything? 3. In the sales invoice that I created, I added an product but in the overview screen, the total didn't include the tax. I have earlier setup the tax authority to include the product and added the catalog, discount and store to the tax authority. Any reference link that I can go and read up? Regards, James -- View this message in context: http://www.nabble.com/Some-questions-on-Sales-Order-and-Sales-Invoice-tp16142675p16142675.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: in stock / not in stock
Hi Heidi, Following steps can be used to determine if the product is in stock or not: 1) productType != SERVICE Or DIGITAL_GOOD 2) product.requireInventory = Y or empty, and if empty then productStore.requireInventory = Y or empty, or we can say both of them must not equals N 3) Check for Toat ATP (availableToPromise) in the InventoryItem for that product (there can be more than one InventoryItems for a product). If it comes out to be less than or equal to ZERO than product is out of stock, else it is in stock. On Tue, Mar 18, 2008 at 3:55 PM, Vikas Mayur [EMAIL PROTECTED] wrote: If I understand it right than, In Stock -- Product is available in the facility / warehouse. See InventoryItem entity, there are two fields ATP - Available To Promise QOH - Quantity On Hand QOH represents items available in the facility (This also includes items reserved for any orders (if any), that are not delivered yet) ATP represents items that are available in facility for new orders. Vikas Vikas On Tue, Mar 18, 2008 at 1:52 PM, Heidi Dehaes [EMAIL PROTECTED] wrote: Hello, What is the (detailed) procedure to follow in order to have near the product visualised the sentence: in stock or not in stock? What steps have to be done? thanks, H. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: inventory for a virtual product?
Ryan, Any subscription product is a Digital Good, so productTypeId=DIGITAL_GOOD for this product. A subscription product will neither be virtual nor varient. You'll need to create a SubscriptionResource record and finally associate it to the Product using ProductSubscriptionResource entity. In ProductSubscriptionResource entity you can use fields useTime and useTimeUomId to set the Subscription Duration. On Sat, Mar 15, 2008 at 4:01 AM, Ryan Sweet [EMAIL PROTECTED] wrote: I'm lost - I'm trying to create a product that is virtual - ie has no inventory - it is a subscription account billed either monthly or yearly. I must be missing something because I've set the product to virtual in the catalog, but in the store it still says that there are none of the item in stock. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Confused about Inventory Items
Hi Andrew, Have you created a single product for the Gearbox, i.e. only one entry in the Product entity for the product Gearbox, and trying to apply all the selectable features to this particular product? If yes, than your data is still not complete. :) Here is something that I know about creating a Product with more than one selectable features. 1) The first thing to note down is, a product with selectable features means a product with variations, that means this product can have different variations depending upon its selectable features. Each set of selectable features defines one variation of that product. So we can say, suppose for buying purpose, that a customer won't buy the product itself, but its varients. 2) Above explaination leads to the point that for a product with selectable features, you need to create: a) A Virtual Parent Product (for which no physical inventory exists and hence can't be purchased) b) One Varient Product for each set of selectable features, so this gives a whole bunch of products to you. (Physical Inventory will exist and will be the actual purchasable products). 3) Create ProductAssoc(s) for Virtual Parent Product and its Varient Products. 4) You need to define a ProductFeatureCategory for your Product. 5) Prepare seed data for ProductFeatureType for make, model, quality etc. if not present in OFBiz seed data. 6) Create ProductFeature records for the selectable features of each type. 7) Associate ProductFeature(s) to the Virtual Parent Product as SELECTABLE_FEATURES in ProductFeatureAppl. 8) Associate each Varient Product to the set of ProductFeature it corresponds to as STANDARD_FEATURES in ProductFeatureAppl. I think that is all we need to do to create a product with selectable features. For an example of creating such products in OFBiz, you can refer to ofbiz-trunkapplicationsecommercedataDemoProduct.xml. And finally I think this should answer your question about inventory. The Inventory you receive will be for the varient products, which are the actual physical products, each varient reqresenting a set of selectable features and not for the Virtual Parent Product. Actually you are not supposed to select features while receiving Inventory, instead you will receive the required varient for the set of required selectable features. On Dec 14, 2007 10:22 AM, Andrew [EMAIL PROTECTED] wrote: I'm apparently missing something about the way inventory works, but hey I'm still learning. I have set up a product (Gearbox) with a few selectable features. (Make, model, quality, year) Or rather created some Feature Groups which are then attached to my Category of used parts. and Gearbox is product of that category. Now if I go my facility and receive inventory of 1 Gearbox there is no way to select what the values features are . eg make= honda, model=civic, quality=damaged, year=1990. I would have thought an inventory item (Which I now have) would have to have those features set. On I suspect a similar note I never have anything in Physical Inventory and in general have no idea what that tab is for. I expect there is just some user documentation on Facilities I haven't found that would explain all this. Thanks for any pointers. Andrew Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Party Information
Hi Brendan, We can create Party for any person or group. A person is for a single person and a Group is for any organization or a departments in an organization. We can assign roles (more than one) to each person according to the roles they play in a organization (like employee, customer, vendor etc.). We can also create PartyRelationships to represent the relation between different persons, groups and person to group. We can also upload Contents for a Party(person). We can create UserLogin for each person and associate it to a SecurityGroup to give him required access permissions to the System. There are many more functions available for a Party that can be used according to individual's purpose. On Dec 9, 2007 7:12 PM, Brendan Vogt [EMAIL PROTECTED] wrote: Hi there, Is there any document-specific information about the party section? What I mean is I need to know what type of party is used for what? And maybe an explanation for all the input fields. I don't know when I party is a person or an employee? Every one that works for me is going to use the system, so is he/she a person or an employee. If there is anything like this please let me know. I am trying to learn as much as possible about the OFBiz system but by bit. Thanks Brendan -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Error in simple-method operation
Hi Micheal,
For the OutOfMemoryError here is the solution I think that might work in
your case:
For running ofbiz from command line..instead of java -jar ofbiz.jar you
can use
java -Xms512m -Xmx1024m -jar ofbiz.jar
This will solve ur OutOfMemory problem in any of the ofbiz operations.
Regards,
Mridul
On 5/1/07, Michael Imhof [EMAIL PROTECTED] wrote:
I got an OutOfMemoryError using simple-method entity-and (same with
find-by-and).
Error in simple-method operation [entity-and/]:
java.lang.OutOfMemoryError: Java heap space
The Error occurs only once (the first call of the service).
Then it works fine...
entity-and entity-name=Country list-name=countryList
field-map field-name=itaCode value=${itaValue}/
/entity-and
Does somebody has an idea where this is coming from??? And why does it
only
occurs the first time (probably something with initialization, cache,
..??)?
Michael
--
View this message in context:
http://www.nabble.com/Error-in-simple-method-operation-tf3674071.html#a10266407
Sent from the OFBiz - User mailing list archive at Nabble.com.
