Hi Aditya , Suppose the seed,seed-initial,demo data is already loaded.
Question is under current stable version , what options does an end user have if he/she has to change a property value like currency.uom.id.default ? regds mallah. On Fri, Sep 1, 2017 at 12:16 PM, Aditya Sharma < [email protected]> wrote: > Hello Rajesh, > > I think you misunderstood that. > > (1) I observed that when I changed the file system configuration > > settings the restarted the server the value in SystemProperty > > remained the same. I am not sure if this is the expected behaviour. > > System configuration file will not change SystemProperty value. > > Values in SystemProperty entity overrides file system configuration > settings. > > For Example, CurrencyUomId in configuration file is USD & SystemProperty > entity is IN. It will pick IN as current setting. > > Thanks and Regards, > > *Aditya Sharma* | Enterprise Software Engineer > HotWax Systems <http://www.hotwaxsystems.com/> > <https://www.linkedin.com/in/aditya-sharma-78291810a/> > > On Fri, Sep 1, 2017 at 11:38 AM, mallah.rajesh <[email protected]> > wrote: > > > > > Changes to the general.properties files were not getting picked . As > > mentioned in past email The value in the rdbms were remaining the same . > > I do not know about the proper usage Of that file. An end user will > > definitely Be confounded by this. > > The idea of changing the file came from searching ml archives. May be > some > > of those info is outdated. > > RegdsMallah > > > > > > > > > > Sent from my Samsung Galaxy smartphone. > > -------- Original message --------From: Arun Patidar < > > [email protected]> Date: 9/1/17 10:36 (GMT+05:30) To: > > [email protected] Cc: [email protected] Subject: Re: setting up > > TAX in ofbiz [ SOLVED ] > > Hi Rajesh, > > > > Both ways are alternative to each other and not auto linked. You may need > > to use either file system configuration or SystemProperty data > > configuration. Usually, data configuration is essential with multi > tenancy > > environment. > > > > > > > > -- > > Thanks & Regards > > --- > > Arun Patidar > > Manager, Enterprise Software Development > > > > HotWax Systems Pvt Ltd. > > > > www.hotwaxsystems.com > > > > > > On Thu, Aug 31, 2017 at 8:07 PM, Rajesh Mallah <[email protected]> > > wrote: > > > > > Dear Arun , > > > > > > Thanks for clarifying that . > > > > > > (1) I observed that when I changed the file system configuration > > > settings the restarted the server the value in SystemProperty > > > remained the same. I am not sure if this is the expected behaviour. > > > > > > In My setup I use a remote postgresql server . > > > > > > I verified (1) just now. > > > > > > regds > > > mallah. > > > > > > > > > > > > > > > > > > > > > On Thu, Aug 31, 2017 at 7:46 PM, Arun Patidar < > > > [email protected]> wrote: > > > > > > > Hi Rajesh, > > > > > > > > SystemProperty entity is used to override file system configuration > > > > settings. This also gives flexibility of changing values on runtime > > > without > > > > restart. System, first checks in the database and then go to file > > system > > > if > > > > value not found. > > > > > > > > > > > > -- > > > > Thanks & Regards > > > > --- > > > > Arun Patidar > > > > Manager, Enterprise Software Development > > > > > > > > HotWax Systems Pvt Ltd. > > > > > > > > www.hotwaxsystems.com > > > > > > > > > > > > On Thu, Aug 31, 2017 at 6:41 PM, Rajesh Mallah < > > [email protected]> > > > > wrote: > > > > > > > > > Hi List , > > > > > > > > > > At last I managed to get my setup pick up the prices specified in > > > > non-USD > > > > > currency (i.e INR in my case) . > > > > > > > > > > From what I could understand , the system attempts to get the the > > > > > value of "currency of handling" from multiple sources as currency > > > > attribute > > > > > itself can be specified at multiple places. > > > > > > > > > > [ Source of above info: > > > > > ./applications/product/src/main/java/org/apache/ofbiz/ > > > > > product/price/PriceServices.java > > > > > Lines: 80-567, Func: calculateProductPrice ] > > > > > > > > > > If for whatever reasons (or set of reasons) the currency could not > > > > > be determined > > > > > > > > > > (1) it attempts to get the value of property > > > 'currency.uom.id.default' > > > > in > > > > > general resource/category , > > > > > (1.1) if that also cannot be got it uses the hard coded > default > > > > USD [ > > > > > PriceServices.java:148 ] > > > > > > > > > > 142 String currencyDefaultUomId = (String) > > > > > context.get("currencyUomId"); > > > > > 143 String currencyUomIdTo = (String) > > > > > context.get("currencyUomIdTo"); > > > > > 144 if (UtilValidate.isEmpty(currencyDefaultUomId)) { > > > > > 145 if (productStore != null && > > > > > UtilValidate.isNotEmpty(productStore.getString(" > > > defaultCurrencyUomId"))) > > > > { > > > > > 146 currencyDefaultUomId = > > > > > productStore.getString("defaultCurrencyUomId"); > > > > > 147 } else { > > > > > 148 currencyDefaultUomId = > > > > > EntityUtilProperties.getPropertyValue("general", > > > > > "currency.uom.id.default", > > > > > "USD", delegator); > > > > > 149 } > > > > > 150 } > > > > > > > > > > > > > > > The reason why it took so long to track it down is that > > > > > the system property 'currency.uom.id.default' itself can be > > specified > > > > > in 2 places: > > > > > > > > > > (1) ./framework/common/config/general.properties > > > > > (2) ./framework/common/data/CommonSystemPropertyData.xml > > > > > > > > > > and the entity table (RDBMS) is : SYSTEM_PROPERTY > > > > > which seems to be loaded from (2) only and not (1) > > > > > ( at least for the property currency.uom.id.default ) > > > > > > > > > > I had been making changes to (1) and expecting the system to > > > > > use it. However the system uses the table SYSTEM_PROPERTY > > > > > that seems to be getting loaded only from (2). > > > > > > > > > > > > > > > Although i have marked this thread as solved , I am yet to analyze > > > > > why at all the flow control reached to the stage of last resort for > > > > > determining the handling currency from system property > > > > > currency.uom.id.default > > > > > > > > > > It should have been determined much earlier through information > > > provided > > > > > end user using WEB-UI controls. > > > > > > > > > > > > > > > I would update this thread at a later time when i am able to > > > investigate > > > > > that. > > > > > > > > > > regds > > > > > mallah. > > > > > > > > > > > > > > > > > > > > On Thu, Aug 31, 2017 at 11:39 AM, Rajesh Mallah < > > > [email protected] > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > > > > I wonder why a query on a table should be run looking for > > > > > > rows where the primary key of table is null. > > > > > > > > > > > > the sole filter on the below query on ProductStore is: > > > > > > WHERE ((PRODUCT_STORE_ID IS NULL)) > > > > > > > > > > > > Note: this query is just run *before* looking in the ProductPrice > > > > > > table. > > > > > > > > > > > > more context here: https://pastebin.com/raw/sSh1sNWb > > > > > > > > > > > > BTW: what is the way of altering logging config in OfBiz > > > > > > to include Filenames and Line number? > > > > > > > > > > > > regds > > > > > > mallah. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2017-08-31 10:45:18,180 |http-nio-8080-exec-5 > > > > > > |GenericDAO |T| Ran query in 3 milli-seconds: > > > > > > EntityName: ProductStore Sql: SELECT PRODUCT_STORE_ID, > > > > > > PRIMARY_STORE_GROUP_ID, STORE_NAME, COMPANY_NAME, TITLE, > SUBTITLE, > > > > > > PAY_TO_PARTY_ID, DAYS_TO_CANCEL_NON_PAY, MANUAL_AUTH_IS_CAPTURE, > > > > > > PRORATE_SHIPPING, PRORATE_TAXES, VIEW_CART_ON_ADD, > AUTO_SAVE_CART, > > > > > > AUTO_APPROVE_REVIEWS, IS_DEMO_STORE, IS_IMMEDIATELY_FULFILLED, > > > > > > INVENTORY_FACILITY_ID, ONE_INVENTORY_FACILITY, CHECK_INVENTORY, > > > > > > RESERVE_INVENTORY, RESERVE_ORDER_ENUM_ID, REQUIRE_INVENTORY, > > > > > > BALANCE_RES_ON_ORDER_CREATION, REQUIREMENT_METHOD_ENUM_ID, > > > > > > ORDER_NUMBER_PREFIX, DEFAULT_LOCALE_STRING, > > DEFAULT_CURRENCY_UOM_ID, > > > > > > DEFAULT_TIME_ZONE_STRING, DEFAULT_SALES_CHANNEL_ENUM_ID, > > > > ALLOW_PASSWORD, > > > > > > DEFAULT_PASSWORD, EXPLODE_ORDER_ITEMS, CHECK_GC_BALANCE, > > > > > > RETRY_FAILED_AUTHS, HEADER_APPROVED_STATUS, ITEM_APPROVED_STATUS, > > > > > > DIGITAL_ITEM_APPROVED_STATUS, HEADER_DECLINED_STATUS, > > > > > ITEM_DECLINED_STATUS, > > > > > > HEADER_CANCEL_STATUS, ITEM_CANCEL_STATUS, AUTH_DECLINED_MESSAGE, > > > > > > AUTH_FRAUD_MESSAGE, AUTH_ERROR_MESSAGE, VISUAL_THEME_ID, > > > > > > STORE_CREDIT_ACCOUNT_ENUM_ID, USE_PRIMARY_EMAIL_USERNAME, > > > > > > REQUIRE_CUSTOMER_ROLE, AUTO_INVOICE_DIGITAL_ITEMS, > > > > > > REQ_SHIP_ADDR_FOR_DIG_ITEMS, SHOW_CHECKOUT_GIFT_OPTIONS, > > > > > > SELECT_PAYMENT_TYPE_PER_ITEM, SHOW_PRICES_WITH_VAT_TAX, > > > > > SHOW_TAX_IS_EXEMPT, > > > > > > VAT_TAX_AUTH_GEO_ID, VAT_TAX_AUTH_PARTY_ID, > > > > ENABLE_AUTO_SUGGESTION_LIST, > > > > > > ENABLE_DIG_PROD_UPLOAD, PROD_SEARCH_EXCLUDE_VARIANTS, > > > > > > DIG_PROD_UPLOAD_CATEGORY_ID, AUTO_ORDER_CC_TRY_EXP, > > > > > > AUTO_ORDER_CC_TRY_OTHER_CARDS, AUTO_ORDER_CC_TRY_LATER_NSF, > > > > > > AUTO_ORDER_CC_TRY_LATER_MAX, STORE_CREDIT_VALID_DAYS, > > > > > AUTO_APPROVE_INVOICE, > > > > > > AUTO_APPROVE_ORDER, SHIP_IF_CAPTURE_FAILS, > SET_OWNER_UPON_ISSUANCE, > > > > > > REQ_RETURN_INVENTORY_RECEIVE, ADD_TO_CART_REMOVE_INCOMPAT, > > > > > > ADD_TO_CART_REPLACE_UPSELL, SPLIT_PAY_PREF_PER_SHP_GRP, > > > MANAGED_BY_LOT, > > > > > > SHOW_OUT_OF_STOCK_PRODUCTS, ORDER_DECIMAL_QUANTITY, > ALLOW_COMMENT, > > > > > > STYLE_SHEET, HEADER_LOGO, HEADER_MIDDLE_BACKGROUND, > > > > > > HEADER_RIGHT_BACKGROUND, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, > > > > > > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_STORE WHERE > > > > > > ((PRODUCT_STORE_ID IS NULL)) where clause:[] > > > > > > > > > > > > > > > > > > > > > > > > On Thu, Aug 31, 2017 at 11:23 AM, Rajesh Mallah < > > > > [email protected] > > > > > > > > > > > > wrote: > > > > > > > > > > > >> Hi Arun , > > > > > >> > > > > > >> I checked PartyAcctgPreference which was USD and changed it to > INR > > > > > >> yesterday only. After changes i do logout and login and restart > > the > > > > > tomcat > > > > > >> to ensure there are no caching issues. > > > > > >> > > > > > >> > > > > > >> ofbiz_redgrape=> SELECT PTYACCPREF.PARTY_ID, > > > > > >> PTYACCPREF.BASE_CURRENCY_UOM_ID, PTYGROUP.GROUP_NAME, > > > > > >> PTYROLE.ROLE_TYPE_ID FROM (ofbiz.PARTY_ACCTG_PREFERENCE > PTYACCPREF > > > > INNER > > > > > >> JOIN ofbiz.PARTY_GROUP PTYGROUP ON PTYACCPREF.PARTY_ID = > > > > > PTYGROUP.PARTY_ID) > > > > > >> INNER JOIN ofbiz.PARTY_ROLE PTYROLE ON PTYACCPREF.PARTY_ID = > > > > > >> PTYROLE.PARTY_ID WHERE (((PTYROLE.ROLE_TYPE_ID = > > > > > 'INTERNAL_ORGANIZATIO'))); > > > > > >> > > > > > >> -[ RECORD 1 ]--------+---------------------------------- > > > > > >> party_id | Company > > > > > >> base_currency_uom_id | INR > > > > > >> group_name | REDGRAPE TECHNOLOGIES PRIVATE LTD > > > > > >> role_type_id | INTERNAL_ORGANIZATIO > > > > > >> > > > > > >> > > > > > >> > > > > > >> The relevant field ProductStore is also INR > > > > > >> > > > > > >> https://pastebin.com/raw/mM2j6kiE > > > > > >> > > > > > >> ...... > > > > > >> > > > > > >> requirement_method_enum_id | > > > > > >> order_number_prefix | > > > > > >> default_locale_string | en_US > > > > > >> default_currency_uom_id | INR > > > > > >> default_time_zone_string | Asia/Kolkata > > > > > >> default_sales_channel_enum_id | > > > > > >> allow_password | Y > > > > > >> > > > > > >> ......... > > > > > >> > > > > > >> regds > > > > > >> mallah. > > > > > >> > > > > > >> > > > > > >> On Thu, Aug 31, 2017 at 11:05 AM, Arun Patidar < > > > > > >> [email protected]> wrote: > > > > > >> > > > > > >>> Hello Rajesh, > > > > > >>> > > > > > >>> ProductStore and PartyAcctgPreference entities also have fields > > to > > > > > store > > > > > >>> currency UOM. > > > > > >>> > > > > > >>> -- > > > > > >>> Thanks & Regards > > > > > >>> --- > > > > > >>> Arun Patidar > > > > > >>> Manager, Enterprise Software Development > > > > > >>> > > > > > >>> HotWax Systems Pvt Ltd. > > > > > >>> > > > > > >>> www.hotwaxsystems.com > > > > > >>> > > > > > >>> > > > > > >>> On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah < > > > > > [email protected]> > > > > > >>> wrote: > > > > > >>> > > > > > >>> > looks like too many messages has already been > > > > > >>> > exchanged in past at various point in time. > > > > > >>> > > > > > > >>> > http://ofbiz.markmail.org/search/?q=changing+default+ > > > > > >>> > currency#query:changing%20default%20currency > > > > > >>> > > > > > > >>> > it will be beneficial to new users if it is given attention > . > > > > > >>> > > > > > > >>> > regds > > > > > >>> > mallah. > > > > > >>> > > > > > > >>> > > > > > > >>> > On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah < > > > > > >>> [email protected]> > > > > > >>> > wrote: > > > > > >>> > > > > > > >>> > > > > > > > >>> > > > > > > > >>> > > > > > > > >>> > > @Deepak , @Rishi / List , > > > > > >>> > > > > > > > >>> > > Additional SQL tracing reveals that the ProductPricing > > > > > >>> > > entities are being queried with CURRENCY_UOM_ID=USD > > > > > >>> > > and hence the USD pricing is being picked up. I am not sure > > > > > >>> > > why USD currency is being picked. I have changed in almost > > > > > >>> > > all places including properties file. > > > > > >>> > > > > > > > >>> > > -- ./framework/common/config/general.properties > > > > > >>> > > > > > > > >>> > > # -- unique instance id (20 char max) > > > > > >>> > > unique.instanceId=ofbiz1 > > > > > >>> > > # -- the default currency to use for prices, etc > > > > > >>> > > currency.uom.id.default=INR > > > > > >>> > > # These values override the _NA_ DEFAULT values in user > > > > preferences > > > > > >>> for > > > > > >>> > > the GLOBAL_PREFERENCES userPrefGroupTypeId > > > > > >>> > > # -- the default organizationPartyId for used in dropdowns > > and > > > > > >>> reports > > > > > >>> > > > > > > > >>> > > > > > > > >>> > > 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO > > > > > >>> > > |T| Ran query in 1 milli-seconds: EntityName: ProductPrice > > > > > >>> > > Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, > > > > > >>> PRODUCT_PRICE_PURPOSE_ID, > > > > > >>> > > CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, > > THRU_DATE, > > > > > >>> PRICE, > > > > > >>> > > TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, > > > > > >>> > PRICE_WITH_TAX, > > > > > >>> > > TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, > > TAX_AUTH_GEO_ID, > > > > > >>> > TAX_IN_PRICE, > > > > > >>> > > CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, > > > > > >>> > > LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, > > > > > >>> LAST_UPDATED_TX_STAMP, > > > > > >>> > > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE > > WHERE > > > > > >>> > > ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR > > > > > >>> > PRODUCT_PRICE_PURPOSE_ID IS NULL) > > > > > >>> > > AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?)) > > > > > >>> > > ORDER BY FROM_DATE DESC > > > > > >>> > > > > > > > >>> > > where clause:[PRODUCT_ID=10000, PRODUCT_PRICE_PURPOSE_ID= > > > > > PURCHASE, > > > > > >>> > > CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_] > > > > > >>> > > > > > > > >>> > > Full Log: > > > > > >>> > > https://pastebin.com/raw/smdQX84B > > > > > >>> > > > > > > > >>> > > > > > > > >>> > > Looking forward to further comments and > > > > > >>> > > guidance. > > > > > >>> > > > > > > > >>> > > ​regds > > > > > >>> > > mallah. > > > > > >>> > > > > > > > >>> > > > > > > >>> > > > > > >> > > > > > >> > > > > > > > > > > > > > > > > > > > > >
