Re: How to set 'offset' for selecting entities

2008-09-11 Thread Jacques Le Roux
I don't think it's in the Entity Engine since offset clause is not supported by all DB systems. Jacques From: "ian tabangay" <[EMAIL PROTECTED]> Hi. When using the GenericDelegator, how do I set the 'offset' of my select statements? ~ ian

Re: view-entity column seperator

2008-09-11 Thread BJ Freeman
actually it was one of my senior moments when I said to myself. Just since this is a view type it must have formatting. :) I created method to format CSV, Tab are the two so far. so I am happy. :) Jacques Le Roux sent the following on 9/11/2008 2:11 PM: > I think you speak about the rendering in

ProductSearch - Sort by product price bug/enhancement

2008-09-11 Thread Ritesh Trivedi
Hi, In ProductSearch - SortProductPrice is only taking into account product_price_type_id and not product_price_purpose_id. price type e.g. DEFAULT_PRICE can be for different purposes eg. Purchase and Component price. This messes up the order of the products returned in the list. -- View this me

Re: content application

2008-09-11 Thread Jacques Le Roux
I had a look but no solution so far (the pb I looked for is : entityname is empty in the clip URL) Jacques From: "Jacques Le Roux" <[EMAIL PROTECTED]> From: "Adrian Crum" <[EMAIL PROTECTED]> Fixed, rev 693881. But it looks like there are more problems with it and I don't have the time to fix

Re: view-entity column seperator

2008-09-11 Thread Jacques Le Roux
I think you speak about the rendering in Webtools entity maint. There was a column separator before but I believe it has gone since we use CSS style Jacques From: "BJ Freeman" <[EMAIL PROTECTED]> so your saying indirectly that formating is done outside the view entity. David E Jones sent the

Re: [RESOLVED] Re: "Quick Ship Entire Order" in order manager not working

2008-09-11 Thread JohnBrown
The data appears to be correct for me (I am fine with ofbiz default values there) but I still get this error periodically based on rev.655515 ? What other places to look at? Thanks for any tips in advance. Raj Saini wrote: > > Look into the DemoGlSetupData.xml file in accounting application. Mo

Re: view-entity column seperator

2008-09-11 Thread BJ Freeman
so your saying indirectly that formating is done outside the view entity. David E Jones sent the following on 9/11/2008 12:18 PM: > > What do those have to do with a view-entity? > > -David > > > On Sep 11, 2008, at 1:14 PM, BJ Freeman wrote: > >> is there a way in the view-entity to define

Re: view-entity column seperator

2008-09-11 Thread David E Jones
What do those have to do with a view-entity? -David On Sep 11, 2008, at 1:14 PM, BJ Freeman wrote: is there a way in the view-entity to define a column separator and if they are quoted? so you would have "ProductID", "thruDate" "Widget","2008-09-11 12:03:58"

view-entity column seperator

2008-09-11 Thread BJ Freeman
is there a way in the view-entity to define a column separator and if they are quoted? so you would have "ProductID", "thruDate" "Widget","2008-09-11 12:03:58"

how to acess context request?

2008-09-11 Thread jjmbconquista
i am need to acess the context request. someone knows how to do this? -- View this message in context: http://www.nabble.com/how-to-acess-context-request--tp19441418p19441418.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: ant run-install-seed admin login

2008-09-11 Thread BJ Freeman
development and new deployment where all the data is imported through excel imports. and your starting with a minimum (seed) data. So you can run the system to do the imports. Eric DE MAULDE sent the following on 9/11/2008 9:46 AM: > Hi, > I tried several times "ant run-install-seed" (with Postg

Re: ant run-install-seed admin login

2008-09-11 Thread Eric DE MAULDE
Hi, I tried several times "ant run-install-seed" (with PostgreSql) and I always conserve my new admin password What case have I to load a clean option in ? To upgrade the new changes into the database http://docs.ofbiz.org/display/OFBTECH/Upgrading+OFBiz+from+earlier+revisions without reset the

Re: Inactivating the product in search

2008-09-11 Thread Raj Saini
Better way is to setup special search category. Add all your you want to be searched in this category. If you want to exclude a product from search result, just remove it from this category. Thanks, Raj Alex Melnik wrote: Hello, I've inactivated a product in the product_category_member tabl

Re: Differents currencies in one webstore

2008-09-11 Thread Jacques Le Roux
Yes, David is right. My anwser was for OFBiz OOTB. If you want to customise to allow user to choose his/her currency have a look at setSessionCurrencyUom Jacaques From: "Amine Benkirane" <[EMAIL PROTECTED]> Thanks for your answer but, I have another question : what parameter or variable have I

RE: Differents currencies in one webstore

2008-09-11 Thread Amine Benkirane
Thanks for your answer but, I have another question : what parameter or variable have I to set in order to indicate that the webstore is in the currency the user select ? Regards, Amine > From: [EMAIL PROTECTED] > To: user@ofbiz.apache.org > Subject: Re: Differents currencies in one webstore

Re: Build to update a production database

2008-09-11 Thread Jacques Le Roux
Please Eric, for the sake of thread continuity, create a new message when the topic is unrelated. I did the same error in the past when I joigned the list and now I better understand how it can be annoying when browsing old threads (in Nabble for instance). About your question, you might be i

Inactivating the product in search

2008-09-11 Thread Alex Melnik
Hello, I've inactivated a product in the product_category_member table by setting the thru date to something before the current date. The product is not showing up in the catalog through browsing. But the product is still showing up in a search and can be added to the shopping cart. Is there

Re: Differents currencies in one webstore

2008-09-11 Thread David E Jones
Actually, you don't have to have one ProductStore per currency. The currency setting on the store is only the default currency. If you add something to the UI to change the currency then it should work fine. On the other hand you do have to have a ProductPrice record for each currency you

Build to update a production database

2008-09-11 Thread Eric DE MAULDE
Hi, After the local repository update from the official Trunk, waht's good compilation to update the production database (ex. PostgreSql) ? if there're a new table, new initial data ... ${ofbizDirectory}/ ant run-install-seed Thanks Eric - Original Message - From: "Jacques Le Roux" <

Re: Differents currencies in one webstore

2008-09-11 Thread Jacques Le Roux
One webstore per currency is required Jacques From: "Amine Benkirane" <[EMAIL PROTECTED]> Hi, Is it possible to have products which prices are in differents currencies in one webstore ? Or we have to create one webstore for each currency we use ? In my case, we want to bought product for fr

Differents currencies in one webstore

2008-09-11 Thread Amine Benkirane
Hi, Is it possible to have products which prices are in differents currencies in one webstore ? Or we have to create one webstore for each currency we use ? In my case, we want to bought product for france and poland from one ofbiz instance. This instance will permit to sale products from fra

Re: two virtual hosts with the same context.

2008-09-11 Thread Jacques Le Roux
Mark, Following Raj's suggestion, have a look at http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Howtousemodproxyajp Jacques From: "Raj Saini" <[EMAIL PROTECTED]> One way is to use the Apache web server virtual hosts. You can use mod_

Re: Error in group-by in view-entity

2008-09-11 Thread ian tabangay
Found it. should be ~ ian On Thu, Sep 11, 2008 at 1:25 PM, ian tabangay <[EMAIL PROTECTED]> wrote: > Hi. I have this view-entity: > >package-name="ph.ati.ofbiz.order"> > > > > function="sum"/> > > > > > > > > > What I wanted to have

Re: content and newsletter

2008-09-11 Thread Florin Popa
For the html based content of a category, I thought there is a simple solution directly from ofbiz as long as very nice content could be created in other places... But a header of a category seems poor right now thanks, Florin I got a word document from my client then made and ftl to create th