Re: google base or google products
But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a "export" button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > You have only to configure the file googleBaseExport.properties into the > google base application and from there you will be able to export your > products created in OFBiz into google base. > > Marco > > - > > Hello, > > I downloaded the "google base" software for ofbiz in the "specialpurpose". > > But how to implement now the google support in ofbiz? > > Can anyone help me? > > thanks, > Heidi > >
Re: http://ofbizwiki.go-integral.com/Wiki.jsp
BJ: The link you sent, doesn't work. Ajay BJ Freeman wrote: > is there a way I can help move the faq over. > http://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ21 > >
Re: Error when creating order.
Hello, thank you for you reply. There are no rows where order_type_id is null. There is however one order where the CURRENCY_UOM and PRODUCT_STORE_ID is null. I deleted this item, but still same error... On Mon, Apr 21, 2008 at 4:07 PM, ladroge <[EMAIL PROTECTED]> wrote: > > I suggest you to do something on your database: > Go in the table an make a select* from order_header. > If you have some table with order_type_id null you have to delete these > table making : > Delete from order_header where order_type_id is null > > Thanks > > > Christoffer Munck wrote: > > > > Hi. I get following error when finalizing an order. I am using an MSSQL > > database as engine. The end of the error looks like there could be a > > problem > > with this: (Error converting data type nvarchar to decimal.). > > > > Does anybody have experiences with this. I would like to know where to > > look. > > A database error, or if it is something I setup wrong in the system. > > > > B.R > > > > Christoffer > > > > > > -- ERROR DUMP > > Problem occurred in tax service (Could not commit transaction for > service > > [calcTax] call: Roll back error, could not commit transaction, was > rolled > > back instead because of: Failure in findByCondition operation for entity > > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: > > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > (Could not commit transaction for service [calcTax] call: Roll back > error, > > could not commit transaction, was rolled back instead because of: > Failure > > in > > findByCondition operation for entity [TaxAuthorityRateProduct]: > > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing > > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, > MIN_PURCHASE, > > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP > > FROM dbo.TAX_AUTHORITY_RATE_PRODU
Re: OrderReadHelper doubling some of the item subtotal calculations????
Anne, > So it is worth me making some effort to make my code good enough to be > integrated. I'm sure your codes will be good enough to be integrated; good codes make bug-catching easier, so that's a powerful incentive. As you mentioned in another post, you're finding [integrating your codes with OFBiz's] not as easy as you hoped (especially shipping inc tax). I did start out trying to retain as much of OFBiz codes (in some areas like invoicing and taxes) as possible. But I find myself writing a whole new chunk parallel to existing OFBiz codes, rather than neatly splicing in enhancements. Well, at least my new chunks use almost exactly the same coding style and methodologies as existing codes, so that's "in line with OFBiz". The problem is that many codes in OFBiz are themselves "parallel chunks of repeated codes". Hard to splice in enhancements in a central location; only possibly to riddle the enhancements into existing codes. Is "parallel chunks of repeated codes" wrong? I think not really. Over time, all my codes do end up like that, until I have time to refactor (put common factors into reusable chunks). Just don't get disheartened. Some of us here start off with huge refactoring projects, and get really tired quickly. Whatever codes work for you, use them. I find making a refactoring TODO list more cost-effective than actually doing the refactoring. I get to meet my deadlines, while still clearly documenting potential problems so I catch bugs easier if they occur. As my bosses always say: "Get the job done, now!" :) Jonathon Anne wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jon Thanks for the tips. If I can, I'd like to make the changes general enough that at least some of them can be incorporated into the main code base. You are working full-time for a company? :) Yes. My company. :-) Though I'm not the only employee. I don't have that luxury. I just build the codes needed by my clients, and leave it at that. Massaging those codes to fit into OFBiz will cost me too much. Many parts in OFBiz are not neatly structured enough (need further refactoring) to plug in enhancements. That particular Java file you mentioned is one of them. In many areas this is what I also will be doing, because I just can't justify the time to make the functionality general. However I figure that if a change I make can be incorporated into the main code base, then I'll benefit as upgrading will be easier. Also, if something I write has a bug (heaven forbid!) that someone else finds and fixes, or if the functionality is extended further by someone else, I benefit from that too. So it is worth me making some effort to make my code good enough to be integrated. Some parts of OFBiz are truly truly neat, though. Yes, I'm noticing. OFBiz is a great system. I'm impressed with the careful design and amount of thought that has obviously gone into it. It has its warts, but what software doesn't? At least, being open source, I can do something about the warts. Cheers, Anne. - -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Phone: (03) 9585 6788 Fax: (03) 9585 1086 Web: http://www.cohsoft.com.au/ Email: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFICsVPtgv4pchABrERAiHWAKCYco66lMYUcUNDg/ag5GhAfKnrNgCgjhkM w6Sbh29ycr/wAy2gFh4HdvU= =TuON -END PGP SIGNATURE-
RE: Rounding Errors
Scott Yes, it would. What I was wondering however was whether it was best to change the definition of both currency-precise (to NUMERIC(18,4) and currency-amount (to NUMERIC(18,3)), or instead, modify each of the data definitions for OrderItem, OrderItemBilling, and InventoryItem individually and change the affected fields (amount and such) to be currency-precise. I tried the former (changing the currency-amount definition) and it seems to work ok. I will then however have to redo a complete alpha test to be sure nothing unexpected happens. On the bright side, BigDecimal rounding does not seem to be an issue. On the other hand, I am worried that I might miss a data definition that won't show up until a beta test with the customer next week. Skip -Original Message- From: Scott Gray [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 5:51 PM To: user@ofbiz.apache.org Subject: Re: Rounding Errors currency-precise should solve the problem Regards Scott On 22/04/2008, BJ Freeman <[EMAIL PROTECTED]> wrote: > > there has been discussion about this. > the consensus as I remember it was leave rounding to the last. > this mean mapping flow to find the final end point where this is going > to be rounded. > This I would think would be in the Accounting module. so the GL will > balance. > > > [EMAIL PROTECTED] sent the following on 4/21/2008 5:23 PM: > > > I am importing orders (and writing them from scratch) with item costs at > > three decimal digits. I have changed order.decimals to 3. > > > > However, I end up with amounts like .466 truncated to .46 > > > > I looked at OrderItem and OrderItemBilling definitions and amount is a > > currency-amount which is defined as NUMERIC(18,2) > > > > I am wondering what is the best way to solve this problem. I am > thinking of > > changing the schema for OrderItem and OrderItemBilling to be > floating-point. > > I could also change the fieldtypepostgres.xml to be > NUMERIC(18,3). However, > > I only want the sold item prices to be three decimal digits, and not the > > totals and so forth. > > > > Anyone have any advice? > > > > Skip > > 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 > > > > > > > > > > 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
Re: Two root category
Divide your product in general categories. And use the parties tab to add manufacturer role to a product. You can use get a list of manufacturers from the product and role association entity (I don't remember exactly but I think it is ProductRole ). Thanks, Raj shristhi sharma wrote: I am trying to configure ofbiz for auto parts store. I wish to classify products into two major categories. General category (Wheels for example) and brands (Bridgestone). I am looking sidedeepcategory.bsh, CommonScreens.xml and CategoryWorker.java Guys, i donno the efficient way of doing this .. i am afraid it will be a big mess at the end. Any suggestion will be great. Thanks
Re: Problems while PUSH and PULL entity sync process in POS
The default keystore in jndi container does not have any valid certificates. You can use keystore utility to get a list of available certificates in a keystore. Look at the keystore command line help on how to use this utility. You can change the keystore to the ssl keystore of the ofbiz and it should work. Reminder for Linux user: You will need to give full absolute path of the keystore command, I found it does not work when just command name is given and your even your JDK binaries are in PATH. Thanks, Raj Vince M. Clark wrote: I think the key line in your trace is Message: RMI Invocation Error (error during JRMP connection establishment; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: No trusted certificate found) Unfortunately it has been a while since I have generated a certificate but it is documented somewhere on the wiki. I'm pretty sure we have gotten synchronization working in the past without needing to generate our own cert, but it is possible something has changed since then. Anyone else please speak up on this. - Original Message - From: "Pradeep Kumar" <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Sunday, April 20, 2008 5:50:30 PM (GMT-0700) America/Denver Subject: Re: Problems while PUSH and PULL entity sync process in POS Hi Vince, Thanx again for your prompt reply. Sorry, the log file was updated with processes when I attached that with my mail. This one I'm sending you is a part of log that contains the exception. The service is running and being scheduled perfectly but after sometime always its turned to be pending, re-scheduling and at the last crashing. Please suggest me the needful. Regards, Pradeep Kumar On Mon, Apr 21, 2008 at 3:15 AM, Vince M. Clark < [EMAIL PROTECTED] > wrote: I don't see any errors in the log file. Can you send another, and specify the line where the error occurs? Make sure you have set RMIIF environment variable in startup script. - Original Message - From: "Pradeep Kumar" < [EMAIL PROTECTED] > To: user@ofbiz.apache.org Sent: Sunday, April 20, 2008 3:42:33 PM (GMT-0700) America/Denver Subject: Problems while PUSH and PULL entity sync process in POS Thanx vince, Now I've separated my application, I've configured the application on two places, one that will hold POS and PSS (my PC and the other is MCS (a PC in our LAN). I've connected both application with separate databases installed locally on each system. I also modified the sync services so that only two kind of flow will be there from MCS to PSS+POS (as they re on same PC) and from POS+PSS to MCS. Both application are having the same information in their PosSyncSettings.xml. Only MCS application's RMI configuration is set to localhost. Now, when I created some orders through POS, the sysnc services are trying to run and scheduled successfully but exception is coming in the log file and entities are not being synchronized on MCS database. SSL and JRML exception is coming. I'm sending you the respective files so that you can check and suggest me the solution. Also, should i make any modification in EntityScheduledServices.xml file? Thanx Vince for every support. Pradeep Kumar. With regards, S K Pradeep kumar
Re: Rounding Errors
currency-precise should solve the problem Regards Scott On 22/04/2008, BJ Freeman <[EMAIL PROTECTED]> wrote: > > there has been discussion about this. > the consensus as I remember it was leave rounding to the last. > this mean mapping flow to find the final end point where this is going > to be rounded. > This I would think would be in the Accounting module. so the GL will > balance. > > > [EMAIL PROTECTED] sent the following on 4/21/2008 5:23 PM: > > > I am importing orders (and writing them from scratch) with item costs at > > three decimal digits. I have changed order.decimals to 3. > > > > However, I end up with amounts like .466 truncated to .46 > > > > I looked at OrderItem and OrderItemBilling definitions and amount is a > > currency-amount which is defined as NUMERIC(18,2) > > > > I am wondering what is the best way to solve this problem. I am > thinking of > > changing the schema for OrderItem and OrderItemBilling to be > floating-point. > > I could also change the fieldtypepostgres.xml to be > NUMERIC(18,3). However, > > I only want the sold item prices to be three decimal digits, and not the > > totals and so forth. > > > > Anyone have any advice? > > > > Skip > > 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 > > > > > > > > > >
Re: Rounding Errors
there has been discussion about this. the consensus as I remember it was leave rounding to the last. this mean mapping flow to find the final end point where this is going to be rounded. This I would think would be in the Accounting module. so the GL will balance. [EMAIL PROTECTED] sent the following on 4/21/2008 5:23 PM: > I am importing orders (and writing them from scratch) with item costs at > three decimal digits. I have changed order.decimals to 3. > > However, I end up with amounts like .466 truncated to .46 > > I looked at OrderItem and OrderItemBilling definitions and amount is a > currency-amount which is defined as NUMERIC(18,2) > > I am wondering what is the best way to solve this problem. I am thinking of > changing the schema for OrderItem and OrderItemBilling to be floating-point. > I could also change the fieldtypepostgres.xml to be NUMERIC(18,3). However, > I only want the sold item prices to be three decimal digits, and not the > totals and so forth. > > Anyone have any advice? > > Skip > 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 > > > >
Rounding Errors
I am importing orders (and writing them from scratch) with item costs at three decimal digits. I have changed order.decimals to 3. However, I end up with amounts like .466 truncated to .46 I looked at OrderItem and OrderItemBilling definitions and amount is a currency-amount which is defined as NUMERIC(18,2) I am wondering what is the best way to solve this problem. I am thinking of changing the schema for OrderItem and OrderItemBilling to be floating-point. I could also change the fieldtypepostgres.xml to be NUMERIC(18,3). However, I only want the sold item prices to be three decimal digits, and not the totals and so forth. Anyone have any advice? Skip 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
Two root category
I am trying to configure ofbiz for auto parts store. I wish to classify products into two major categories. General category (Wheels for example) and brands (Bridgestone). I am looking sidedeepcategory.bsh, CommonScreens.xml and CategoryWorker.java Guys, i donno the efficient way of doing this .. i am afraid it will be a big mess at the end. Any suggestion will be great. Thanks
Re: http://ofbizwiki.go-integral.com/Wiki.jsp
Hi BJ, It's late here, I will tell you more tomorrow... In the meantime you may put a comment at bottom of http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo (if we speak about the same thing) Also you need to use http://web.archive.org/web/20070811060319/http://ofbizwiki.go-integral.com/ (not always easy, you have to peek and poke there) Jacques From: "BJ Freeman" <[EMAIL PROTECTED]> is there a way I can help move the faq over. http://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ21
http://ofbizwiki.go-integral.com/Wiki.jsp
is there a way I can help move the faq over. http://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ21
Re: Problems while PUSH and PULL entity sync process in POS
Pradeep Your settings looked fine in PosSyncSettings.xml. I have the impression from your thread so far that you understand the setup when eliminating the PSS and using the POS terminal to go directly to MCS. This is the setup we have used as well so we're on the same page with that configuration. It can get a little tricky knowing what config to load on what server (POS or MCS.) I have some notes at the top of my custom PosSyncSettings.xml that I will send in a follow up message. Unfortunately I have to boot another computer to get to them. But they go step by step on what to load where. - Original Message - From: "Jacques Le Roux" <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Monday, April 21, 2008 3:45:47 AM (GMT-0700) America/Denver Subject: Re: Problems while PUSH and PULL entity sync process in POS > Hi Vince, > > Sorry I forgot to ask one importnt thing. The RMIIF environment variable is > defined in startup script startofbiz.sh. But I'm using the windows > environment to test it. Now in this case how can I set this RMIIF in our > environment variable. Simply tranpose to Windows this is a param tpo pass to JVM : -Djava.rmi.server.hostname=" > Also, will there be any difference in the contents of PosSyncSeetings.xml on > PSS+POS System and MCS System as I'm calling same two services on both > system. This i the place where I'm a bit confused. Are you using 2 different DBs on the PSS+POS System (one for each OFBiz instance) ? Are you relaying through PSS when you send from POS to MCS (this is the intended basic scheme, of course you can build your own...) ? Jacques > -- > With regards, > S K Pradeep kumar >
Re: Problems while PUSH and PULL entity sync process in POS
I think the key line in your trace is Message: RMI Invocation Error (error during JRMP connection establishment; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: No trusted certificate found) Unfortunately it has been a while since I have generated a certificate but it is documented somewhere on the wiki. I'm pretty sure we have gotten synchronization working in the past without needing to generate our own cert, but it is possible something has changed since then. Anyone else please speak up on this. - Original Message - From: "Pradeep Kumar" <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Sunday, April 20, 2008 5:50:30 PM (GMT-0700) America/Denver Subject: Re: Problems while PUSH and PULL entity sync process in POS Hi Vince, Thanx again for your prompt reply. Sorry, the log file was updated with processes when I attached that with my mail. This one I'm sending you is a part of log that contains the exception. The service is running and being scheduled perfectly but after sometime always its turned to be pending, re-scheduling and at the last crashing. Please suggest me the needful. Regards, Pradeep Kumar On Mon, Apr 21, 2008 at 3:15 AM, Vince M. Clark < [EMAIL PROTECTED] > wrote: I don't see any errors in the log file. Can you send another, and specify the line where the error occurs? Make sure you have set RMIIF environment variable in startup script. - Original Message - From: "Pradeep Kumar" < [EMAIL PROTECTED] > To: user@ofbiz.apache.org Sent: Sunday, April 20, 2008 3:42:33 PM (GMT-0700) America/Denver Subject: Problems while PUSH and PULL entity sync process in POS Thanx vince, Now I've separated my application, I've configured the application on two places, one that will hold POS and PSS (my PC and the other is MCS (a PC in our LAN). I've connected both application with separate databases installed locally on each system. I also modified the sync services so that only two kind of flow will be there from MCS to PSS+POS (as they re on same PC) and from POS+PSS to MCS. Both application are having the same information in their PosSyncSettings.xml. Only MCS application's RMI configuration is set to localhost. Now, when I created some orders through POS, the sysnc services are trying to run and scheduled successfully but exception is coming in the log file and entities are not being synchronized on MCS database. SSL and JRML exception is coming. I'm sending you the respective files so that you can check and suggest me the solution. Also, should i make any modification in EntityScheduledServices.xml file? Thanx Vince for every support. Pradeep Kumar. With regards, S K Pradeep kumar -- With regards, S K Pradeep kumar
Re:google base or google products
You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the "google base" software for ofbiz in the "specialpurpose". But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
google base or google products
Hello, I downloaded the "google base" software for ofbiz in the "specialpurpose". But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Advice configuring products
Hi' I am configuring the demo data to fit my needs. I need some thoughts about configuring products for recurring charge. I have several products which are all very similar. They vary in design, but costs the exact same always, and I always buy from the same suppliers in this product category. I want to sell each design in different timespans (design1 in january, design2 in february etc.). Would it be possible to add a product features like "January Design 2009", and still distinguish them somehow in inventory, and place them in different positions in the warehouse? Another reason why I would like it to be same product is that i am thinking of making a recurring charge (subscription service) on these products. If I split them up to different product, I am guessing it would be difficult for me to make recurring charge (that the customer automatically get charged $XXX). I would have to set up my own schedule to create orders, and I would have to save cc info, which I really don't want to do because of security reasons and rules. -- Best regards Christoffer Munck
Re: How to change an ecommerce .ftl file reusing the whole
Great!! Luckily, I was wrong ;) -- Daniel Martínez Bruno Busco escribió: At the moment I have configured my controller.xml like this: "http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=" http://ofbiz.apache.org/dtds/site-conf.xsd"> OFBiz: Cloned eCommerce Controller Configuration File and it seems that the tag overload does work! I have not changed the ecommerce controller.xml and the main and category requests are now served with my local CatalogScreens.xml -Bruno 2008/4/20, Daniel Martínez <[EMAIL PROTECTED]>: Guess this is a message for the user's mailing list Anyway, there goes my two cents: I think you already have the answer. AFAIK there is no mechanism in OfBiz to "overload" a request-map/view-map (which you'd need to change the location of the widget XML file) If I am not wrong you have two options: 1- Copy over the controller.xml file from ecommerce and make your local changes. 2- Use a different request name for your modified screen than the original. regards, -- Daniel Martínez Bruno Busco escribió: Hi, as long as I go deeper and deeper in ofbiz I can appreciate the very good design of this application. Now I need to make a my own eshop module and I want to be sure I am using all the re-use mechanism you have designed. - I have created an eshop application under the hot-deploy, here I have all my data files using the "ext" reader, with the data file I have defined my show, website, facilities, catalogs and categories. - In my eshop application, I have the controller.xml file that (as seen in ecommerce clone example) includes the ecommerce application controller with the line - In my eshop application there is also the images folder with a modified copy of the ecommerce.css file and all required gif Now I need little changes in some of the .ftl files. I want not to modify the original files of the ecommerce application so that I can better follow the development and update without conflicts. Is there a mechanism that let me have one or more additional .ftl files in my application and all standard .ftl under the original ecommerce? For example: I have changed the minilastviewedcategories.ftl. I would like to have a modified copy of this file in my own application. I can create a copy in my application but in order to make ofbiz using it I need to local copy also all the other files in the chain that are: CatalogScreens.xml, CommonScreens.xml and the controller.xml Could anyone make some light for me on this?
Whats the purpose of Amount box in the configurable PC in ecommerce
Hi, Whats the purpose of Amount box in the configurable PC in ecommerce? Thanks in advance. -- Regards Alex D. Fleming
Re: Line of Credit
OK, so I guess I have to *create a billing account, **define it's limit, **Enter my own company in "Party Billed To" *In Roles add some entries such as **Supplier party with role "Bill-From-Vendor" **Supplier party with role "Supplier Agent" And when processing the purchase invoice I'll have to do something like: *Create outgoing payment **Set my own company in "Organization Party Id" **Set the supplier Party in "To Party Id" **Set "Payment Type Id" to Vendor Payment ** Set "Payment Method Type" to Billing Account *Apply payment to invoice After doing this I see no decrement in the corresponding Billing Account balance. What am I missing ? regards, Daniel Riquelme On Mon, Apr 21, 2008 at 12:16 PM, David E Jones <[EMAIL PROTECTED]> wrote: > > Yes, it's on the Billing Account (entity name is BillingAccount) and it's > administered in the Accounting Manager. > > -David > > > > On Apr 21, 2008, at 10:12 AM, Daniel Riquelme wrote: > > > Does OFBiz support the Line of Credit concept ? > > > > How does OFBiz manages credit purchases to suppliers. > > Is it possible to define an account limit so that it will not be > > possible to > > create orders beyond that limit ? > > > > regards, > > Daniel Riquelme > > > >
Re: Line of Credit
Yes, it's on the Billing Account (entity name is BillingAccount) and it's administered in the Accounting Manager. -David On Apr 21, 2008, at 10:12 AM, Daniel Riquelme wrote: Does OFBiz support the Line of Credit concept ? How does OFBiz manages credit purchases to suppliers. Is it possible to define an account limit so that it will not be possible to create orders beyond that limit ? regards, Daniel Riquelme
Line of Credit
Does OFBiz support the Line of Credit concept ? How does OFBiz manages credit purchases to suppliers. Is it possible to define an account limit so that it will not be possible to create orders beyond that limit ? regards, Daniel Riquelme
Re: Error when creating order.
I suggest you to do something on your database: Go in the table an make a select* from order_header. If you have some table with order_type_id null you have to delete these table making : Delete from order_header where order_type_id is null Thanks Christoffer Munck wrote: > > Hi. I get following error when finalizing an order. I am using an MSSQL > database as engine. The end of the error looks like there could be a > problem > with this: (Error converting data type nvarchar to decimal.). > > Does anybody have experiences with this. I would like to know where to > look. > A database error, or if it is something I setup wrong in the system. > > B.R > > Christoffer > > > -- ERROR DUMP > Problem occurred in tax service (Could not commit transaction for service > [calcTax] call: Roll back error, could not commit transaction, was rolled > back instead because of: Failure in findByCondition operation for entity > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: > SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID > = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, > ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID > = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, > ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) (SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID > = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, > ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > (Could not commit transaction for service [calcTax] call: Roll back error, > could not commit transaction, was rolled back instead because of: Failure > in > findByCondition operation for entity [TaxAuthorityRateProduct]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP > FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR > PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID > = > ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND > (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) > AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS > NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, > FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling > back tran
Re: Query entity
Skip and Mridul Thanks very much for your help. My mistake is I have field name="id" as my primary key. But field which I need to query is not a primary key. So If I need to query field from another table, I need to query by primary key only. I set the field which I need to query as primary key. Then I can solve this problem. Nattanicha Mridul Pathak wrote: 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 and maybe if asset_itemid is not always unique -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: I want to show it by using form, I do like this: itemid"> number"> 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: .. .. 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
terms and conditions of sale
Hi all, How can we configure terms and conditions so that at the time of sale of any product, we can attach these t&c with the product sold? Is it possible to define Terms and Conditions for a specific product, and include that T&C in the invoice at the time of sale if that particular product ? Any suggestion will be appreciated. Thanks.. Ajay
FAQ Contents
Hello All, Can anybody has any idea about how to configure FAQ contents so that theycan be seen on "ecommerce/control/main" page? Thanks beforehand. Ajay
Re: Error when creating order.
Hi' I am really sorry about the late response time. Did not see the response. I am using ver 4.0 from the release library. Rev: 629279 B.R Christoffer On Tue, Apr 15, 2008 at 3:36 PM, BJ Freeman <[EMAIL PROTECTED]> wrote: > Can you specify which SVN (Trunk or Ver4.0) and the version. > it would help track down the error. > Since all numbers are VarChar, there must be something that is not > converting properly. > > > > > Christoffer Munck sent the following on 4/14/2008 10:26 PM: > > Hi. I get following error when finalizing an order. I am using an MSSQL > > database as engine. The end of the error looks like there could be a > problem > > with this: (Error converting data type nvarchar to decimal.). > > > > Does anybody have experiences with this. I would like to know where to > look. > > A database error, or if it is something I setup wrong in the system. > > > > B.R > > > > Christoffer > > > > > > -- ERROR DUMP > > Problem occurred in tax service (Could not commit transaction for > service > > [calcTax] call: Roll back error, could not commit transaction, was > rolled > > back instead because of: Failure in findByCondition operation for entity > > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > (Could not commit transaction for service [calcTax] call: Roll back > error, > > could not commit transaction, was rolled back instead because of: > Failure in > > findByCondition operation for entity [TaxAuthorityRateProduct]: > > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing > > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, > MIN_PURCHASE, > > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP > > FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR > > PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > >
Re: recommended memory setting for low traffic ofbiz install?
It even runs whit 384Mo (on Linux) see http://docs.ofbiz.org/display/OFBIZ/Alternative+Demo+Servers#AlternativeDemoServers-Release4.0 for instance Remember that the OFBiz project began in 2001... You remember the machines at this time ? Jacques From: "BJ Freeman" <[EMAIL PROTECTED]> I have run ofbiz on 512 no problem for very active sites I have use 1-2 gigs and move the DB to a companion server. More for CPU usage than memory. phillip rhodes sent the following on 4/20/2008 7:45 PM: Hi, Sorry for the question, but I am running ofbiz on a server with tons of memory available to it, and I never had to put tomcat on a diet before (just give it a 1Gb and forget about it). I am moving everything to a VPS server (I think with RIMU hosting) and would like to buy the extra memory now if I need it. Thanks. Phillip
Re: Problems while PUSH and PULL entity sync process in POS
Hi Vince, Sorry I forgot to ask one importnt thing. The RMIIF environment variable is defined in startup script startofbiz.sh. But I'm using the windows environment to test it. Now in this case how can I set this RMIIF in our environment variable. Simply tranpose to Windows this is a param tpo pass to JVM : -Djava.rmi.server.hostname=" Also, will there be any difference in the contents of PosSyncSeetings.xml on PSS+POS System and MCS System as I'm calling same two services on both system. This i the place where I'm a bit confused. Are you using 2 different DBs on the PSS+POS System (one for each OFBiz instance) ? Are you relaying through PSS when you send from POS to MCS (this is the intended basic scheme, of course you can build your own...) ? Jacques -- With regards, S K Pradeep kumar
Re: recommended memory setting for low traffic ofbiz install?
Hi, It also depends on the modules that you are using. For suppose if you donnot want to use all the modules provided in Ofbiz ERP you can try by not starting those modules.i donnot remember the exact XML file but i think its somthing like applications.xml. where you will define the applications start up. Note : There is intermodule dependency be careful while trying .. Regards Phanindra. On Mon, Apr 21, 2008 at 8:15 AM, phillip rhodes <[EMAIL PROTECTED]> wrote: > Hi, > Sorry for the question, but I am running ofbiz on a server with tons of > memory available to it, and I never had to put tomcat on a diet before (just > give it a 1Gb and forget about it). I am moving everything to a VPS server > (I think with RIMU hosting) and would like to buy the extra memory now if I > need it. > > Thanks. > Phillip > > -- G.Venkata Phanindra Mob:: 9849852989
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
>
>
>
> and maybe if asset_itemid is not always unique
>
>
>
> -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-name="DepreciationTrans" title="Keeps depreication record from
> > depreciation table which created in each period">
> >
> >
> >
> >
> >
> >
> > I want to show it by using form, I do like this:
> >
> > > paginate-target="ShowDepreTable">
> >
> > > field-name="calculate_date"/>
> >
> >
> >
> >
> >
> >
> >
> > 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:
> >
> > ..
> >
> > > description="${asset_item_desc}"
> > key-field-name="asset_itemid">
> >
> > ..
> >
> > 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]
