Re: Problem: mysql with ofbiz 10.4

View this message in context: > http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3616546.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > -- James McGill Phoenix AZ

Re: Simplifying OFBiz screens

it from others. One common way to do that is to use conditional widgets in a section, example "applications/humanres/widget/RecruitmentScreens.xml#FindJobRequisitions" -- James McGill Phoenix AZ

Re: purchasse order and round in calcul

ShoppingCart and Order to accommodate this. We do not ever use any currency besides USD, and do not use any of the tax calculations. I imagine that my changes would be very broken if we did. -- James McGill Phoenix AZ

Re: calling screen from javascript

of injecting dynamic content. Then you can simply call a controller request that runs a service but renders no view, let Javascript get the service output as JSON, and update your screen this way. James McGill Phoenix AZ

Re: Entity storage and retrieval questions

uld > get all the values and stick them into my own object, but I'm not sure that's > the proper way of doing it. > > Thanks for the time, help and patience. > > David van der Staak -- James McGill Phoenix AZ

Attaching a PDF to a FO-FTL generated PDF

I have a situation where I need to generate a PDF (purchase order document), but also attach another PDF document to the end of it. I can't generate this document via PDF, I just want to append it so that when you get the order, you get this page as well. Can FO-FTL handle this? --

Re: Event & Service

this facility, Events are called directly form > the controller. The only point of confusion for me is in In this case, an event *is* a service. -- James McGill Phoenix AZ

Re: Manually allocate inventory to order

ings to fit your business rules. It also sounds like you need to add steps in the user workflow in order to provide the user a means of issuing specific inventory lots to an order. This is also fairly simple, as OFBiz customizations go. -- James McGill Phoenix AZ

Re: Is there a find mothed that can one by one page return result in GenericDelegator?

n in the delegator. With that in mind, consider the approach that paginating screens are using. Look at how performFind queries work, with the EntityListIterator, such as in the Facility app for InventoryItems. This design is efficient enough for millions of inventory rows when running on modest hardware. -- James McGill Phoenix AZ

Re: Changing OfBiz Logo

Header.groovy to see how this part of the page is being evaluated and rendered. -- James McGill Phoenix AZ

Re: How to import a pre existing product database

cal data, orders and inventory transactions.) -- James McGill Phoenix AZ

Re: How to create inventory for a product

ing total of transactions that can be audited against the InventoryItem. If you want to manually change the ATP and QOH quantities, use the Variance service. In a production system, variances will probably be rare, since inventory should be created as a result of shipment receipts or work efforts

Re: bsh or groovy in services

So are you saying that the

Re: Issues while connecting Ofbiz eclipse in Debug Mode

can use tend to be inside the framework instead of at the service level. Sometimes it's a challenge to find a piece of Java that you can use to make a breakpoint. On the other hand, this is a fast way to learn how the minilang processor actually works. -- James McGill Phoenix AZ

Re: product price in sales order in order manager

istaken, putting a basePrice in the context already causes a price record to be updated. The behavior of Purchase Orders as opposed to Sales orders is probably different, but for Purchase Orders I think that you can simply add a basePrice input field to get the desired result. -- James McGill Phoenix AZ

Re: Ofbiz grouping at Entity level

o for Having clauses, but I don't know of an example. -- James McGill Phoenix AZ

Re: SSL certificates for the OFBiz demo domains

an isolated environment. We'd still really like to have the encrypted communication of SSL without the third party authentication bits. The deployment is large enough that the step of "accepting the self-signed certs" really is a nuisance. -- James McGill Phoenix AZ

Re: SSL certificates for the OFBiz demo domains

On Thu, Oct 21, 2010 at 2:40 PM, Scott Gray wrote: > On 22/10/2010, at 10:21 AM, James McGill wrote: > > > On Thu, Oct 21, 2010 at 6:56 AM, Sam Hamilton wrote: > > > >> No - just the usual error messages you would expect to see if it were > the > >> self

Re: SSL certificates for the OFBiz demo domains

benefits of SSL other than the external CA part. -- James McGill Phoenix AZ

Re: SOLVED getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

to find the problem. > someday I will put energy into the remote debugging. > :D > I find remote debugging is extremely easy, using Eclipse. If only there was a way to step into minilang services -- they make remote debugging pretty frustrating, especially if you want to breakpoint an E

Receiving Non-Inventory items on Purchase Order

x have a method for dealing with non-inventory orders? -- James McGill Phoenix AZ

Re: MyPortal issue, service error in one portlet causes stack trace in a different portlet

On Thu, Aug 26, 2010 at 2:43 PM, James McGill < james.mcg...@ableengineering.com> wrote: > > https://issues.apache.org/jira/browse/OFBIZ-3903 > > I found that by adding TransactionUtil.rollback(); after seeing an error result from the Dispatcher, I can at least hide the pr

MyPortal issue, service error in one portlet causes stack trace in a different portlet

some way to flush the dispatcher? I hope someone can look at this and explain what's going on. -- James McGill Phoenix AZ

Re: How to control order of fields in Form with auto-fields-service

On Wed, Aug 25, 2010 at 1:07 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > > Thank you, I see how it works. I assume this means that you have to know all the fields that are bound by any "auto" tags, and have to list them explicitly in sort-order. -- James McGill Phoenix AZ

How to control order of fields in Form with auto-fields-service

When adding fields to a Form where an auto-fields-service is used, my additional fields always sort to the bottom. How do you control the display order of these fields? -- James McGill Phoenix AZ

Re: Including Category Name in Title tag on Product Details Page

p that the FTL can see. There might be an easier way, but this is one way I'd handle it. What page are you looking at exactly? -- James McGill Phoenix AZ

Re: Groovy question regarding passing html parameters

7;d want to make sure that my assumptions are correct (performance of subsequent cached queries, cost of traversing an EntityListIterator for conditions, selecting on a view or DVE, etc.) -- James McGill Phoenix AZ

Re: Just wondering if anyone on this list is interested in this?

much you can do there. -- James McGill Phoenix AZ

Re: Just wondering if anyone on this list is interested in this?

I am curious as to what server OS you run that doesn't have a Java 6 SDK. I'm also wondering which Java 6 incompatibilities cause problems with OFBiz. NIO? Calendar durations? Bean eventHandlers? Forced validation on casts? -- James McGill Phoenix AZ

Re: View entity extra conditions

is still a valid view entity definition, the engine > ignores "entity-condition". > With the latest 10.04 trunk ModelViewEntity contains the parsing logic > for "entity-condition". > So, OFBiz 9.04 doesn't support "entity-condition" in views. I didn&

Re: OrderItemRole entity

tion flexibility if you wanted to associate party roles on a per-item basis, instead of per-order. Also look at OrderItemContactMech, supported but never really used in the application out of the box. There are quite a few ares where the application uses a subset of the data model. -- James McGill Phoenix AZ

Re: Optimistic locking based on timestamps

ests with inventory counts, which for us is a pretty big issue. Reading ahead, I'm really interested in the nested transaction problem. Since you're strongly suggesting Postgres, do you have any advice for migrating a live system between databases, hopefully from an Entity perspective? -- James McGill Phoenix AZ

Re: Optimistic locking based on timestamps

rts of the system where this might not be such a problem, but on InventoryItem it's a potential nightmare. What do you think about my idea of giving the delegator a "select for update" option? -- James McGill Phoenix AZ

Optimistic locking based on timestamps

rs in data where the "last update wins." Has anyone else had concurrency problems when multiple threads are updating entities? Are there any locking provisions in the Delegator that would allow us to prevent this kind of problem? -- James McGill Phoenix AZ

Re: Suggest Project topics

those days. On the other hand, I'm having a hard time seeing a business / information system platform as a starting point for a Computer Science Engineering project. But then I'm not thinking in terms of the framework itself, but rather the business applications on the framework. -- James McGill Phoenix AZ

Re: Suggest Project topics

to a CIS type of program than to CSE, but the process of learning how to work with the OFBiz framework can definitely be very educational. -- James McGill Phoenix AZ

Re: Proper use of thruDate

d look at ProductPriceChange or PartyNameHistory for examples of this idea. -- James McGill Phoenix AZ

Re: Service class reloading

h evolution, that they would be better, in the long run, ported to Java. -- James McGill Phoenix AZ

Re: After Receiving, user refreshes page, receive is repeated.

to rewrite the whole Receiving application, but I have to fix this first. We're already using this for an industrial inventory system, and this one bug is giving me a black eye every day. -- James McGill Phoenix AZ

Re: After Receiving, user refreshes page, receive is repeated.

only the item is recieved. > Are you saying you have a custom receiving application, or are you talking about the OFBiz facility/ ReceiveInventory request? -- James McGill Phoenix AZ

Re: After Receiving, user refreshes page, receive is repeated.

d. I'm trying that because I'm desperate to make this problem stop, not because I think it's a good fix. -- James McGill Phoenix AZ

After Receiving, user refreshes page, receive is repeated.

At the end of Receive Inventory, if the user reloads the page in the browser, the action is repeated and inventory is created and purchase orders are adjusted. This is user error that we want to prevent. Any ideas? -- James McGill Phoenix AZ

Re: Using Form lookup attribute "target-parameter"

It turns out that you have to change the lookup screen to accept "paramN" parameters explicitly. -- James McGill Phoenix AZ

Re: Using Form lookup attribute "target-parameter"

blem by appending parameters and values onto the target-form-name, so I gave up on using target-parameter. -- James McGill Phoenix AZ

Re: Using Form lookup attribute "target-parameter"

On Fri, Jun 4, 2010 at 10:24 AM, James McGill < james.mcg...@ableengineering.com> wrote: > > > On Thu, Jun 3, 2010 at 8:21 PM, Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > >> It seems you are using a revision before r949710, update at least to t

Re: Using Form lookup attribute "target-parameter"

On Thu, Jun 3, 2010 at 8:21 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > It seems you are using a revision before r949710, update at least to this > to use target-parameter or patch with r946593 if you want to stay with the > revision you are > > Is there a corresponding change to

Using Form lookup attribute "target-parameter"

string like: http://ofbiz/facility/control/LookupFacilityLocation?id=undefined&parm0=myFacilityId and I think we want something like: https://ofbiz/facility/control/LookupFacilityLocation?facilityId=myFacilityId Can I make that happen within the Form xsd? -- James McGill Phoenix AZ

Re: Configure default application

writing front end on this, I had to make a dummy application that mounts on "/" but redirects to the main application. Thanks for the help! -- James McGill Phoenix AZ

Configure default application

How do you set a specific application to be the default, that is, when a user goes to http://ofbiz.server.com/ , and you want that to log directly into a specific application, instead of needing to add "application/control/main" to the url, what do you do? -- James McGill Phoenix AZ

Re: Best of Open Source ERP

urce-applications-140 > > With Opentaps on there, OFBiz enjoys two spots in the top 10. -- James McGill Phoenix AZ

Re: Shuttdown

a login shell. Now I start it up with nohup: cd ~ofbiz nohup sh ./startofbiz.sh 2>&1 > nohup.out & That disconnects it from the login shell. The "screen" terminal program would also work. http://www.oreillynet.com/linux/cmd/cmd.csp?path=s/screen -- James McGill Able Engineering

Re: QuoteId and OrderId sequence, possible race condition?

possible error. As David > suggested, there may be multiple front ends talking to a single > database, so a SQL solution is best. I am merely respectfully > suggesting that it would be better to let SQL do what it does best, and > atomic transactions are the essence of good SQL. > > Hope this helps explain where I am coming from. > I hope you will look at the code in question and I hope you can explain why transactions haven't worked. MySQL5, isolation-level="ReadCommitted". I believe OFBiz is already taking the approach you suggest, relying on SQL transactions to protect a critical section, and it's not working for some reason. Any or all of my assumptions could be wrong. I just need to fix this so it stops shutting us down. -- James McGill Phoenix AZ

Re: QuoteId and OrderId sequence, possible race condition?

For completeness' sake, the XSD Index: framework/minilang/dtd/simple-methods.xsd === --- framework/minilang/dtd/simple-methods.xsd (revision 2187) +++ framework/minilang/dtd/simple-methods.xsd (working copy) @@ -223,6 +223,19 @@

Re: QuoteId and OrderId sequence, possible race condition?

On Thu, May 20, 2010 at 10:46 AM, Adrian Crum wrote: > James, > > I uploaded a patch that might fix your problem: > > Thanks Adrian. Your approach adds JVM-based synchronization to minilang simple methods. I still wonder if this means the create services need to be synchronized and not just the

Re: QuoteId and OrderId sequence, possible race condition?

On Wed, May 19, 2010 at 9:53 PM, David E Jones wrote: > > It's all about locking and blocking... > > The scenario you describe is probably fairly rare Probably, but it has hit us several times, and we don't have a lot of users on this. When it breaks, it stays broken until someone updates Part

Re: QuoteId and OrderId sequence, possible race condition?

ly increments the sequence in PartyAcctgPreference. (And that "someone" is me). I checked the trunk, hoping this had been updated, but it hasn't. I'm surprised everyone doesn't run into this. -- James McGill Phoenix AZ

Re: QuoteId and OrderId sequence, possible race condition?

Does this imply that Transactions might not be protecting against concurrency in other situations? This is a problem that is causing us a great deal of difficulty, because it happens almost every day. -- James McGill Phoenix AZ

Re: QuoteId and OrderId sequence, possible race condition?

e how that is even possible. Could possibly not be writing, but also not throwing an error? -- James McGill Phoenix AZ

QuoteId and OrderId sequence, possible race condition?

race condition, or if there is some transaction integrity problem. But in order to keep Quotes and Orders going, I occasionally have to go into PartyAcctgPreference and force an increment to the sequence. Has anyone else seen this behavior? -- James McGill Phoenix AZ

Re: groove eclipse plugin

On Mon, May 17, 2010 at 2:40 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > I use it but I did not find much, maybe some syntax coloration, not even > sure > > Jacques > I've tried to use it, but it really doesn't do the things I want an IDE to do, such as completing class member na

Re: InventoryTransfer, tracing split back to original Item?

On Sun, May 16, 2010 at 4:46 AM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi, > > Did you solve your issue? > > Jacques > I did, by writing an extra detail record, and by adding a field to InventoryItemDetail. Thanks.

Re: Styling rows in an OFBiz Form

On Thu, May 13, 2010 at 4:57 PM, Scott Gray wrote: > > Use the alt-row-style tag, it's a child of the form tag. > I see; didn't know what that was for. Thanks Scott. -- James McGill Phoenix AZ

Styling rows in an OFBiz Form

Without changing a Form to FTL, I'd like to be able to control the style of a single row of a Form, based on a field. Is this possible? -- James McGill Phoenix AZ

Re: InventoryTransfer, tracing split back to original Item?

If I add an OUT parameter to prepareInventoryTransfer, that's not enough to bring that parameter to the input context of completeInventoryTransfer, so I'm stuck. -- James McGill Phoenix AZ

InventoryTransfer, tracing split back to original Item?

e new item that was created in prepareInventoryTransfer. I wonder if there is something I can do in the -- James McGill Phoenix AZ

Weird error in QuickShipEntireOrder, InvoiceId constraint violation

r by one, but I still need to figure out what went wrong. Any ideas? -- James McGill Phoenix AZ

Tracking InventoryTransfer?

item? Item Issuances write a detail record that allows traceability with an ID and a quantity. Shouldn't Transfer do the same thing? -- James McGill Phoenix AZ

Re: What is the field orderItemSeqId for ?

the same product can appear more than once in an Order, this field is part of its primary key. -- James McGill Phoenix AZ

Re: "Meta product" ordering (e.g., kits)

On Mon, Apr 26, 2010 at 3:35 PM, Scott Gray wrote: > You'll want to look into the Marketing Package ProductType (and it's > subtypes). I'm not sure what the support is like for purchasing as opposed > to sales but even if it isn't there it shouldn't be too hard to implement. > Thank you Scott,

"Meta product" ordering (e.g., kits)

f the (non-inventory) "Kit", but will receive the *components* of the kit into inventory. I have an idea how I will implement this, but I want to again check and see if OFBiz already provides the function I'm describing, and if so, whether it will fit our workflow. -- James McGill Phoenix Arizona

Re: Change Item price on a COMPLETED Purchase Order

On Wed, Apr 21, 2010 at 5:48 PM, BJ Freeman wrote: > you may confused by InventoryItEM and its variance. > see the Datamodel book Vol 1 page 84 > the product is the item you ordered > the inventory item is how many and where located. > Inventtory Item has a variance about how many you actually ha

Re: Change Item price on a COMPLETED Purchase Order

ents, separately. If I just change the price on the product, or just change the price on an OrderItem and InventoryItem, I've lost traceability, right? (Our problem is related to some very particular business logic that applies to aircraft parts -- there are a lot of things we do that won't fit other shops) -- James McGill Phoenix AZ

Re: Change Item price on a COMPLETED Purchase Order

reaking existing OFBiz functionality; thanks! -- James McGill Phoenix AZ

Change Item price on a COMPLETED Purchase Order

t. Please advise. -- James McGill Phoenix AZ

Re: A "Screen" with no display output.

Hit "Send" in my earlier message, oops. My question probably sounds strange, but please let me explain: I have a Screen.xml that renders a PDF via xsl-fo. In the for that screen, I set some fields from parameters, and then execute a

A "Screen" with no display output.

My question probably sounds strange, but please let me explain: I have a Screen.xml that renders a PDF via xsl-fo. In the for that screen, I set some fields from parameters, and then execute a

Re: Barcodes : Left Justify Human Readable Part

14pt false false -- James McGill Phoenix AZ

Barcodes : Left Justify Human Readable Part

nothing in the documentation to indicate how this is done. I searched the Barcode4J mailing lists and the source, and sent a message to the developer. Does anyone in the OFBiz community know how to do this? -- James McGill Phoenix AZ

Re: Use Arial font in fo.ftl?

On Thu, Dec 17, 2009 at 12:21 AM, Brajesh Patel < brajesh.pa...@hotwaxmedia.com> wrote: > Hello James, > > Yes, you can use Arial font in fo.ftl need to use file > "framework/webapp/config/fop.xconf" , this file contain following code that > responsible for font family, change font family acc

Re: Use Arial font in fo.ftl?

On Thu, Dec 17, 2009 at 12:21 AM, Brajesh Patel < brajesh.pa...@hotwaxmedia.com> wrote: > Hello James, > > Yes, you can use Arial font in fo.ftl need to use file > "framework/webapp/config/fop.xconf" > Thank you Brajesh! --James

Use Arial font in fo.ftl?

10pt false false -- James McGill Phoenix AZ

Re: mondrian

On Tue, Dec 15, 2009 at 7:14 AM, Hans Bakker wrote: > Hi Chris... > i do not know what mondrian is > > so i cannot really judge that. > > Regards, > hans Mondrian is a tool for getting datasets into the form needed by Pentaho. This is Business Intelligence software that is used heavily by an

Dealing with service errors from Groovy event.

fields in a graceful way. By "graceful" I mean something besides "org.ofbiz.widget.screen.ScreenRenderException: ... the rollbackOnly was caused by: Error in simple-method [" My simple-method is returning an error, as expected, but how should I deal with it in the groovy and

Seeking help with fo.ftl

ow anyplace else this kind of stylesheet is used. Where do I start if I need to learn this? Soon I am going to have to create rather complex documents that will present challenges for layout, and I think I need to teach myself all there is to know about FO+FTL. Your guidance is appreciated. -- James McGill Phoenix AZ

Re: Force a page break in fo.ftl

On Sat, Nov 21, 2009 at 3:42 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > From > http://xmlgraphics.apache.org/fop/compliance.html#fo-property-keepsbreaks-section > So I suppose break-after="page" > But I did not find any on OFBiz... > Merçi, Jacques. I see that fo-ftl has its ow

Force a page break in fo.ftl

What's the XSL-FO way to force a page break? Thanks. -- James McGill Phoenix AZ

Product Description and Long Description?

How are Long Description and Description entered for a Product? There doesn't seem to be a field for either of these. -- James McGill Phoenix AZ

Purchase Order Supplier Address

rchase Order contact mechs get assigned to the Order so that OrderContactMechValueMaps will be populated? -- James McGill Phoenix AZ

Re: File Attachments

I see; thank you Jacques. On Wed, Nov 4, 2009 at 3:49 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Look at the bottom of the produc content page > for instance > https://localhost:8443/catalog/control/EditProductContent?productId=SV-1000 > > Jacques > James McGill Phoenix AZ

Re: compile java event.

create the build dir? > Make sure your component is loaddd in component-load.xml, and your component's build.xml is included in the filelist in the parent build.xml. Are you working in specialpurpose/yourapp? -- James McGill Phoenix AZ

File Attachments

Does OFBiz have an existing facility to process file attachments? I am in need of file attachment functions like Jira and Confluence have. -- James McGill Phoenix AZ

Re: Entity select "Today's Records"

l, false); > > disclaimer: I didn't test it > > Regards > Scott > > HotWax Media > http://www.hotwaxmedia.com > > > On 4/11/2009, at 3:31 PM, James McGill wrote: > > How about an example of an Entity Condition query to find rows based on a >> timestamp

Entity select "Today's Records"

How about an example of an Entity Condition query to find rows based on a timestamp field "Since midnight today", using Groovy? -- James McGill Phoenix AZ

How to get Inventory to show up as QOH and ATP?

that. We are doing this, but we still seem to be missing a step when putting things into inventory. They don't show up as QOH and ATP, and we can't figure out why from either Ofbiz or Opentaps documentation or looking at code. Can you give another hint? We can get through picking

Quick Ship "Multiple Facilities" error.

What does this mean when trying to Quick Ship? What are the "multiple facilities?" (We think there's only one in this order.) ProductStore AA_PHX_STORE does not reserve inventory cannot use Quick Ship for Multiple Facilities ProductStore AA_PHX_STORE explodes order items cannot use Quick Shi

Order not ready for picking, needs stock move

What are we missing? -- James McGill Phoenix AZ

Separate WorkEffortId for each OrderItem

but I have not been able to figure out what the implications would be if I allow a person to enter these while creating a purchase order. -- James McGill Phoenix AZ

Re: Extending id fields to more than 20 chars

t; + java-type="String"> > > > That works like a charm if you choose to go this route. > However, 20 chars is hardcoded into forms. That's what scared me away from changing fieldtype. -- James McGill Phoenix AZ

Extending id fields to more than 20 chars

D but that would be much less convenient for the users. Please advise. -- James McGill Phoenix AZ

Re: Default theme ?

On Mon, Oct 12, 2009 at 7:19 AM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi, > > I'd like to know what the community thinks about Bizness Time as default > theme. > It is okay, but the fast disappearing error popup is highly annoying. -- James McGill Able Engineering

  1   2   >