Re: Entity-engine Unique constraint definition?

3 at 17:23, Richard Fleming wrote: > Hi all, > Is there a way to define a database unique constraint when defining an > entity > in the entity-engine.xml file? > It is easy to define a primary key, but I don't see a way to set up a > unique constraint beyond that. > For insta

Re: Entity-engine Unique constraint definition?

Thanks Scott, I'll check that out.. Rick On Thursday, June 22, 2023 at 10:53:11 AM MDT, Scott Gray wrote: Hi Rick, Yes, see the index element:   If you search the code base for 'unique="true"' you should find some examples. Regards Scott On Thu, 22 Jun 2023 at 17:2

Entity-engine Unique constraint definition?

Hi all, Is there a way to define a database unique constraint when defining an entity in the entity-engine.xml file? It is easy to define a primary key, but I don't see a way to set up a unique constraint beyond that. For instance I'd like to define a unique constraint on the productId and

Re: Preserving text formatting info in a service return from an API call

, Richard Fleming wrote: > Hi all, > I have a service that creates a prompt and calls an outside API endpoint. > The return from the API is formatted text.But when I get the return field > from the ofbiz service, the formatting is lost. > Is there a way for ofbiz to keep the

Preserving text formatting info in a service return from an API call

Hi all, I have a service that creates a prompt and calls an outside API endpoint. The return from the API is formatted text.But when I get the return field from the ofbiz service, the formatting is lost. Is there a way for ofbiz to keep the text formatting in the return field? In this case the

Re: Ofbiz Inventory Value and Average Costs Adjustments

rage Costs Adjustments From: Richard Fleming Date: Tue, March 29, 2022 5:11 pm To: "user@ofbiz.apache.org" Product_Average_cost on 17.12. Rick On Tuesday, March 29, 2022, 01:48:07 PM MDT, ja...@productive1.com wrote: Good afternoon All.  Can anyone tell me where a products inve

Re: Ofbiz Inventory Value and Average Costs Adjustments

Product_Average_cost on 17.12. Rick On Tuesday, March 29, 2022, 01:48:07 PM MDT, ja...@productive1.com wrote: Good afternoon All.  Can anyone tell me where a products inventory moving average is stored.  I am assuming this number is used in financial transactions when the system is

Re: Promotions Question

Thanks Jacques -- I guess I didn't ask that question very well :) I was having trouble  mainly because there are three settings that need to bechanged to enable the automatic application of promotions. First, set "User entered" to "N" Second, set "require code" to "N".Third, when using the

Re: Execute custom SQL

Thank you Mandeep and Jacques for your kind replies I will look in that direction -Rick On Sunday, September 13, 2020, 11:26:12 AM MDT, Jacques Le Roux wrote: Hi Rick, Did you try https://localhost:8443/webtools/control/EntitySQLProcessor HTH Jacques Le 13/09/2020 à 16:32,

Re: OFBiz BigFish eCommerce Enhancements [integrate with Postgresql]

this isn't something that we're completely up on. Best Regards, Nick Rosser nros...@salmonllc.com O: 516.742.7888 x221 C: 516.901.1720 On 8/22/2012 11:00 AM, Richard Fleming wrote: Nick, Are you working to get BigFish to run on a Postgresql database? Thanks -Rick

Re: OFBiz BigFish eCommerce Enhancements

Nick, Are you working to get BigFish to run on a Postgresql database? Thanks -Rick From: Nick Rosser nros...@salmonllc.com To: user@ofbiz.apache.org Sent: Wednesday, August 22, 2012 7:19 AM Subject: Re: OFBiz BigFish eCommerce Enhancements Not on our task

Re: webpos - how to over ride price?

I don't think the code in webpos is complete for a lookup on good_identification. The form invokes additem in shoppingcartevents and that method requires the passing of a product_id - it doesn't appear to do any kind of lookup. It seems reasonable to do the lookup first and then call the

Tomcat serving multiple websites

Hi all - There used to be a wiki about using a single instance of tomcat to serve multiple websites in ofbiz. I can't find it anymore. Is there a place I can go to find it? I don't want to use Apache to redirect and it seems to me that about a year ago I got tomcat to serve multiple

Re: SSL certificate installation - *solved*

:1150) Richard Fleming wrote: Hi all- Finally got it working w/ GoDaddy certificate. This is what I did - 1.Create private key file. openssl genrsa -out privkey.pem 4096 2.Create CSR openssl req -new -key privkey.pem -out cert.csr 3.Submit CSR

Re: SSL certificate installation - *solved*

+Production+Setup+Guide GoDaddy.com installation instructions. Richard Fleming [EMAIL PROTECTED] wrote: Joe - Thanks for the reply. First off, according to GoDaddy, thier certificates are downloaded in PKCS#7 format using x.509. First I created the keystore... c:\java\jdk1.5\bin\ keytool -genkey

Re: SSL certificate installation

/display/JETTY/How+to+configure+SSL#HowtoconfigureSSL-step3 to convert them to pkcs12 and load them into a JKS keystore. (may require that you download jetty to use their pcks12 import utility class, depending on your certificate format) -Joe On May 17, 2008, at 3:39 PM, Richard Fleming wrote

SSL certificate installation

Hi all - I've created a keystore and downloaded a signed certificate from Godaddy.com. I've imported both intermediate and new cert into my keystore. I configured the containers.xml to use the new keystore and restarted ofbiz. But still both Firefox and IE see the new cert as issued by me and

Re: Production use of DBCP

My Postgres database is showing quit a few idle connections even though all transactions are either rolled back or comitted. Typically, I'll gain 30 connections a day. I've changed the tcp_keepalives in postgresql.conf and I'll check it in the morning to see if it helps. Hopefully it will and

Re: javax.mail.internet.ParseException when sending email from ofbiz?

Phillip, which ofbiz rev are you using and how have you configured your general.properties file? I've finally gotten the latest rev's to use yahoo's smtp server, but only after configuring several new fields available. Rick Phillip Rhodes [EMAIL PROTECTED] wrote: I am using the ordermgr to

Re: Embedded SMTP server

. These were required in order to support using gmail as the sender's email account --- Richard Fleming wrote: Hi all - Does ofbiz (or will it) have an embedded SMTP server to send order confirmations and the like? I've seen the config file general.properties, but it doesn't allow for a change

Embedded SMTP server

Hi all - Does ofbiz (or will it) have an embedded SMTP server to send order confirmations and the like? I've seen the config file general.properties, but it doesn't allow for a change in ports or SSL - either that or I'm not configuring it right. I was trying to use Yahoo's business mail

Re: PayPal Websites Payments Pro implementation

I'm slammed with other projects. Rick Vince Clark [EMAIL PROTECTED] wrote: Has there been any progress on PayPal Express? Richard Fleming wrote: Hi all - I've just signed up for PayPal Payments Pro(Verisign). 1. Has anyone implemented it yet? 2. How closely related

Entity delegator problem

Hi all - I'm having a problem accessing a delegator from an enitity-condition tag. In the product webapp I've defined the following table: entitymodel.xml: entity entity-name=AppModelNumberTest package-name=org.ofbiz.product.product title=Container Type Entity

Re: Shipping rule for free shipping on orders over $100

Eric, Create a price break rule and then associate the rule to a shipping estimate. Under shipping tab - quantity breaks. Under stores-shipping-estimate associate the break. Rick Eric Crawford [EMAIL PROTECTED] wrote: I understand that it is possible to enter a shipping rule to a particular

Re: PayPal

Eric, I lmplemented the PayPal Payment Gateway last month. As I recall in searching through the code, the payment type paypal was not implemented. The error you get usually means that the request doesn't exist in the controller.xml file of the ecommerce app. In other words, it's not set up to

Re: Display a resultset in an .ftl file

into the where clause. -David Richard Fleming wrote: David - Maybe you can help me... I need to query the products table and return 20 or so possible product ids from the following customer input - I need a maytag belt set for my maytag washer The columns involved in the query

Display a resultset in an .ftl file

Hello all- I've put together a bsh script that puts a java.sql.resultset into the context. How do I create a list tag in my freemarker file to display the resultset? Thanks Rick

Re: Display a resultset in an .ftl file

? Rick Rick Rodrigo Souza [EMAIL PROTECTED] wrote: User delegator to data layer. Not use in .ftl files. 2007/8/6, Richard Fleming : Hello all- I've put together a bsh script that puts a java.sql.resultset into the context. How do I create a list tag in my freemarker file to display

Re: Display a resultset in an .ftl file

... -David Richard Fleming wrote: Rodrigo, Thanks for the reply.. but I can't use the delegator object. I have to use a jdbc connection so that I can query the database with a non standard operator (@@). The delegator doesn't support calling this operator. My life would be much easier

Re: Display a resultset in an .ftl file

the database and find another way for form the query. -David Richard Fleming wrote: David, Thanks for the reply. I'd love to use the entity engine. But because the @@ operator for tsearch's isn't part of the jdbc driver for postgres, I think I'm stuck. Is there a way within the entity engine

entity operator problem

Hi all, I'd need to use the tsearch2 operator @@ in a query like: SELECT * FROM PRODUCT WHERE INFO @@ to_tsquery('maytagbeltwasher') -INFO is a new column which combines several pieces of information about a product and the tsearch function allows a more natural search for users(ie.. I need a

Shipping rules

Jacques, Apache has kicked back the replies I've tried to make to the original subject. Anyways... Thanks for the reply. The shipping rules work great! Rick

Free Shipping

Hi all - I've set up a promo for free shipping. It doesn't work for me. any help would be appreciated. The setup is: conditions: The cart total 75 no action categories. actions: free shipping blank quantity blank amount blank item blank party I added the promo to the web store. There is

Re: PayPal Websites Payments Pro implementation

in the same boat and am hoping someone has some information or can help me with this. Where you able to get things working? We have taken preliminary steps but are a bit stuck. Any help or information would be appreciated. Thanks, Brock Richard Fleming wrote: Hi all - I've just signed up

Single use Payments

Hello all- Is the Single use payment option(s) being worked on? The link in the webcheckout doesn't have a corresponding entry in the controller. Has something replaced the effort? I see some code in checkoutHelper that isn't commented out. I also see a Jira issue opened but no comments

Re: PayPal - Verisign SDK

Brett Palmer wrote: I'm not using Verisign right now but I have used in on other projects. Brett On 7/9/07, Richard Fleming wrote: Brett, Thanks for the reply. We actually do have the .jar path defined in build.xml. And our service compiles and executes fine so long as I don't make any

PayPal - Verisign SDK

Hi all - I'm having some trouble. I've downloaded the Paypal gateway API and have thier command line samples working. I've also created a service paypalccprocess to call to the API. I've put the paypalpro.jar in /applications/accounting/build/lib directory and the java file builds just

Re: PayPal - Verisign SDK

to be in the classpath along with the Jar file but the Verisign docs should explain that. Hope that helps. Brett On 7/9/07, Richard Fleming wrote: David - Here's the log: I can see a no classdef found and I've tried to add a classpath statement and I've copied the .jar files to several

Re: credit card payment setup

Amine, I'm trying to implement the Verisign payment gateway. Ofbiz has code for it already but I'm having a terrible problem with it. I'm picking my way through the code to try and figure it out and although I've posted a couple of notes on the ML, I'm afraid I'm getting a blank stare back.

Entity error

Hi all - I get the following error when I try this: entity-condition entity-name=modelNumber delegator-name=partslookup list-name=models condition-expr field-name=modelValue env-name=modelValue/ order-by field-name=modelnu/

Entity config problem

Hi all- I'm using the opentaps tutorial as an example I need to have ofbiz create tables in a remote database server. I have the following definitions..webapp/hello3/entitydef/ entitymodel.xml - I made no changes. entitygroup.xml - redefined the enities to...

Re: Entity config problem

( findByEntity .getEntityName ( ) , condition , null ) The generic helper is defined in the datasource. what other change is needed? Thanks Rick Richard Fleming [EMAIL PROTECTED] wrote: Hi all- I'm using the opentaps tutorial as an example I need to have ofbiz create

Re: Entity config problem

the rest of the script --- Richard Fleming wrote: Chris, Thanks for the quick reply. You were right, I changed the web.xml file and the entity engine created the tables in the remote database. However, when I go to WebTools and click on the new tables, I get the following error

Entity Engine Config question

Hi all- The advanced framework video has left me a little fuzzy on this.. I have a seperate database computer that is used to find part numbers by model number. Do all the tables in that database need to be modeled in the entity engine before a delegator can access them?

Payment during web checkout

Hi all - During quick checkout(anonymous), payment options(only one set is paypal) won't show up. What am I missing? Is there a configuration that needs to be set up. It works fine when the customer creates a new account. Rick

IE6 DISPLAY PROBLEMS

Hi all - Why does OfBiz display perfectly in Firefox and then go to heck when displaying in IE6? I've added some html markup in the long_description content which displays perfectly in firefox but pull it up in IE and the the markup is sent all the way to the bottom of the page and the

Re: Product summary display

It was just late... In the ecommain.css .productsummary { position: relative; padding: 5px; border-bottom: #999 solid 1px; height: 60px; } I changed the height this isn't dynamic though. Is there a css guru that can shed light on a dynamic height calculation? Rick Richard Fleming [EMAIL

Product summary display

Hi all- I've tweaked the product summary ftl to include a few more product specific items such as long description and a couple of links to content. However, as the amount of space each item takes increases, the line seperators stay in the same place so that the text of the product

Re: New OFBiz Look Submitted

I think it look great! You got my vote. Rick Adrian Crum [EMAIL PROTECTED] wrote: If you subscribe to the dev mailing list, you can skip this message. I submitted a patch to Jira that gives the OFBiz back office apps a new look. You can see it here -

Keyword search

Hi all - I just noticed that inducing keywords forces all keywords to lower case. This breaks the search when the productid - especially - was created in upper case. Is this a bug, or should all productid's be forced to lower case? Thanks Rick

actions tag - bsh script

Hi all How do I access the value of a field, set by the actions tag, in a bsh script? action set field=productId_a value=${idProduct.productId}/ /action I've tried several things in terms of parameters, request, context, session... all to no avail. Help please!

Re: access a particular application by default

Daniel, Check out the Technical Production Setup Guide that is in the docs from Undersun Consulting. It covers mounting a root web app. Rick Daniel Martínez [EMAIL PROTECTED] wrote: Hello, So I have ofbiz running under 80/443 ports in, i.e. my server alpha Is there anyway I can access an

Image Size

Hi all - Is there an optimal image size in pixels for the catalog large, medium, small, detail images? Rick

Database tablespaces

Hi all - Is there any support for database tablespaces in OFBiz. It would be nice to be able to reduce disk contention on large datasets. Rick

Re: Slow Keyword search

Thanks guys, I'll look into the indexing and let you know what I find. Rick Jacopo Cappellato [EMAIL PROTECTED] wrote: Hi Richard, I'd suggest to working with indexes in the database. Jacopo Richard Fleming wrote: Hi all - I ran about 100,000 products (1/10th of our total

Re: Slow Keyword search

Thanks guys, I'll look into the indexing and let you know what I find. Rick Jacopo Cappellato [EMAIL PROTECTED] wrote: Hi Richard, I'd suggest to working with indexes in the database. Jacopo Richard Fleming wrote: Hi all - I ran about 100,000 products (1/10th of our total

Re: POS Enhancement

creation Jacques - Original Message - From: Richard Fleming To: OFBIZUSER Sent: Thursday, February 01, 2007 9:29 PM Subject: POS Enhancement Hi All Is anybody working on the POS system to allow the use of billing accounts and on the fly backorder creation? Rick

Re: Flagging Parts that have been superceded...

, 2007, at 7:50 PM, Richard Fleming wrote: I think I stumbled upon an anwer on my own. Substitutions are big in my industry. For items that sub, we change the require inventory flag to yes. That way when we're out of the old inventory, these items automatically create an error(alert) when

Flagging Parts that have been superceded...

Hello all - Has anyone dealt with supercedures in any nifty way? For instance, Maytag's old belt1 is now replaced with the new and improved belt2. Is there any way to flag or at least alert a user to the change in either sales order or cart checkout? Could a product id type of