About four fields auto-added by OFBiz

2009-03-04 Thread Jack Liu
Hi, all OFBiz will add four fields below automatically when creating tables: LAST_UPDATED_STAMP LAST_UPDATED_TX_STAMP CREATED_ STAMP CREATED_TX_STAMP If these fields are dropped, then OFBiz will not work properly. Can we have these fields dropped while it will not affect OFBiz? Thank you!

Re: About Country Currency

2009-03-04 Thread BJ Freeman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Normally the Currency is set by the product store. however if you want a finer grain best place to find out is looking at the entity definitions or use the webtools. https://demo.hotwaxmedia.com/webtools/control/ViewRelations?entityName=Uom if you

Re: About four fields auto-added by OFBiz

2009-03-04 Thread BJ Freeman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes it will break ofbiz These are used by the tranactional code when updating the DB. they should not be removed. Jack Liu sent the following on 3/4/2009 1:58 AM: Hi, all OFBiz will add four fields below automatically when creating tables:

Re: About four fields auto-added by OFBiz

2009-03-04 Thread Jacques Le Roux
You can remove these fields using no-auto-stamp in entities definitions. This means change that for all definitions. Note that there are no entities using this attribute OOTB... They are mostly use for entities synchronisation and maybe you will need them at a time. Of course you can imagine

View-Entities Group by month

2009-03-04 Thread madppiper
Hey everyone, If I was to create the following statement: SELECT ORDER_HEADER.*,MONTH(created_stamp) as month, count(order_id) as ordersum FROM ORDER_HEADER GROUP BY Year(ORDER_HEADER.CREATED_STAMP), Month(ORDER_HEADER.CREATED_STAMP) Which is basically a simple View on the Order Header data

Re: View-Entities Group by month

2009-03-04 Thread BJ Freeman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 the view-entity is basically for grouping entities then you use a findlist to get the data you want. madppiper sent the following on 3/4/2009 2:39 AM: Hey everyone, If I was to create the following statement: SELECT

what are the consequences for the modification of the entity postalAddress?

2009-03-04 Thread jjmbconquista
I am adapting the ofbiz for use in Brazil and I need to modify table postal_address, specifically the address1 column, this column stores the number and street, and I need to put street numbers on different fields, I will create new fields in the table. The problem is that the address1 field is

Re: PaymentMethod entity

2009-03-04 Thread Jacek Wagner
I am not sure I understand data stored in entity format statement, but I am talking about PaymentMethod table in the ofbiz database. -- J BJ Freeman wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please clarify what ever growing entity means. are you speaking of the entity in the xml or

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Stephen Rufle
I think I have a related issue to this. I have .properties files with table headings in them. I used to be able to put a br tag br in the content of my labels to break two words. ex. Cust.brOrder# would turn into Cust. Order# on my display, now it sends it literally. How do I get the old

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Jacques Le Roux
As David explains below you have to embed the String you create (I suppose reading the property) into a StringBuilder Jacques From: Stephen Rufle sru...@salmonllc.com I think I have a related issue to this. I have .properties files with table headings in them. I used to be able to put a br

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Stephen Rufle
In the ftl I use ${uiXXXLabelMap.CUSTOMER_ORDER_NUMBER} Does this process get passed through some class that I can change and send a patch for? Then all properties could embed HTML Jacques Le Roux wrote: As David explains below you have to embed the String you create (I suppose reading the

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Jacques Le Roux
1st thing : OFBiz trunk no longer uses .properties files but .xml files 2d thing : we don't allow HTML in labels (actually there are still some, but it should not at term apart some special cases like the famous CommonEmpty) I think you will have to create a specific worker for that, ie no

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Stephen Rufle
Ok, If I convert to using XXX.xml instead of XXX.properties will be able to embed the HTML, or is the general rule that no properties are allowed to have HTML in them otherwise they get encoded on the way out to the screen? Using /ofbiz/framework/common/config/CommonUiLabels.xml as my example to

Re: PaymentMethod entity

2009-03-04 Thread BJ Freeman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 looking at the entity definition and/or https://demo.hotwaxmedia.com/webtools/control/ViewRelations?entityName=PaymentMethod shows you all the uses for PaymentMethod . if I understand your question correct, Yes it keeps having more data added it by

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Jacques Le Roux
Maybe an option for you is to try to comment out lines 71-73 of HtmlWidget.java Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com 1st thing : OFBiz trunk no longer uses .properties files but .xml files 2d thing : we don't allow HTML in labels (actually there are still some, but it

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Adrian Crum
Keeping HTML out of UI labels isn't a rule - it is a best practice. The reason is reusability - you can reuse the UI label in a non-HTML environment. -Adrian Stephen Rufle wrote: Ok, If I convert to using XXX.xml instead of XXX.properties will be able to embed the HTML, or is the general

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread Jacques Le Roux
Ok, it's late here so don't expect an answer before some hours... Which Release.revision are you using, trunk I guess ? Jacques PS : see also my suggestion about StringHtmlWrapperForFtl, and maybe make it works for you ;o) From: Stephen Rufle sru...@salmonllc.com Ok, If I convert to using

Re: Javascript is parsed to HTML (Freemarker ?)

2009-03-04 Thread David E Jones
There is a solution to this already in place, and it is used in a few places. Take a look at the promotiondetails.ftl file, especially the expression: ${StringUtil.wrapString(productPromo.promoText?if_exists)} BTW, this should ONLY be used for very trusted fields, ie fields that never

Re: what are the consequences for the modification of the entity postalAddress?

2009-03-04 Thread BJ Freeman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 you can use the extend-entity if you want to add fields for your requirements to the postalAdress entity. the way ofbiz works all forms that use the postalAddress entity will show the additional fields. jjmbconquista sent the following on 3/4/2009