#idempiere IRC log for Tuesday, 2019-04-16

*** muriloht <muriloht!c8a19c33@gateway/web/freenode/ip.200.161.156.51> has joined #idempiere00:05
*** nmicoud <nmicoud!~Nicolas@riv38-2-78-235-108-177.fbx.proxad.net> has joined #idempiere05:18
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere05:43
*** norbertbede <norbertbede!~Adium@94.228.89.101> has joined #idempiere07:05
*** CarlosRuiz <CarlosRuiz!~CarlosRui@aftr-37-201-194-235.unity-media.net> has joined #idempiere08:52
*** norbertbede <norbertbede!~Adium@94.228.89.101> has quit IRC09:33
*** norbertbede <norbertbede!~Adium@94.228.89.101> has joined #idempiere09:38
norbertbedehi team09:57
norbertbedei have the next problem/idea09:57
norbertbedewhen customer asking at beginning "can you anything customise and translate according my requirement ?"  we answer yes. however in cloud/multitenant architecture this is problematic.09:57
norbertbedewe have window customisation, and can translate print formats, but as i know nothing more09:57
norbertbedethe idea is.09:57
norbertbedeadd a new table - e.g. ad_Translation hierarchy, where we can define on tenant level relations eg. ad_element_id=10 mapr to ad_element_id=100023. then a plugin injected into translation rendering - replace terms. to tenant defined terms09:57
norbertbedethis should be applied to elements, messages well.09:57
norbertbedewhen client login then plugin automatically translate - let say apply translation hierarchy. and return modified awaited translations09:57
norbertbedeprobably the hierarchy should be implemented on tenant/role/org/user level09:57
norbertbedewdyt ? can be implementable ?09:57
norbertbedei discussed about that wuth deepak. he has idea simple add additional translation instead replace elements id09:58
norbertbedeand do not implement on role level..09:58
CarlosRuizHi norbertbede - the requirement is not clear for me - do you have an example of something that you want different on tenant and cannot do it with the actual tools?10:38
norbertbedeeg our customer hate pricelist 3 fields10:41
norbertbedehe hate limit price - we understand that can be variose usage. but usuallz 1 companz = 1 meaning e.g. Average Price (we update when recalculate limit field) - so in this case we should change limit price everywhere10:42
norbertbedesecond example same pricing issue - list price something is additional level usage. we implement readonly logic and flag to keep all list price as std price - then no maintenance overhead - later we hide it. in this case he dont like to see standard price but "Sales Price"10:44
norbertbedeim tired to faiting with customer - so atm i decide to found a global solution to have ability for centralised tenant translation10:45
norbertbedewindow customisation is not an option because info windows, forms are still not translated10:45
norbertbedeprint formats can be problematic if we have 30 reports in client 0 shared across tenants then still i need make copy and maintain it separately - instead allow make tenant translation for elements and messages across all places where translation are handled10:47
CarlosRuizso - your idea is that any table that has AD_Element look first for this tenant-element-translated-table10:48
norbertbedeyes, same for messages10:52
CarlosRuizin principle it sounds like a big change - hard to implement in core - because the way core is reading the translations10:53
norbertbedei see. that is not good.10:53
CarlosRuizI'm not very fond about allowing translations per role/user (but that can be done in window customization actually)10:53
CarlosRuizbecause that creates some problems for support10:53
CarlosRuizdifferent users calling to report a problem with a field with different names10:54
CarlosRuizbut anyways10:54
CarlosRuizwhat I'm wondering is10:54
CarlosRuizif in core we could make all the _Trl tables open for tenant records10:55
CarlosRuizjust a draft idea - but maybe that change would be easier to implement10:56
CarlosRuizfor example10:56
CarlosRuizat this moment10:56
CarlosRuizAD_Element_Trl has a primary key with AD_Element_ID+AD_Language10:56
CarlosRuizin my draft idea we would need to change those keys to be  (AD_Element_ID+AD_Client_ID+AD_Language)10:57
CarlosRuizor even adding AD_Org_ID if that's your intention10:57
CarlosRuizand open some window to allow maintenance in tenant for that table10:58
norbertbedeyes. looks same just simplified way10:58
CarlosRuizand then - we need to look for every query in core for table AD_Element_Trl and add proper filters:10:59
CarlosRuizWHERE AD_Client_ID IN (0, #AD_Client_ID)10:59
CarlosRuizORDER BY AD_Client_ID DESC10:59
CarlosRuizsomething like that10:59
CarlosRuizdoesn't sound easy - but sounds easier than your proposal11:00
norbertbededoes this candidate for core or customisation11:00
CarlosRuizthat touches a lot of the core - I think cannot be done in customization11:00
norbertbedecan you estimate effort/price ? looks we need this. depends on price we decide.11:04
norbertbedemaybe in private11:08
CarlosRuizOK ... let me check it and will write you11:16
norbertbedethanks bb11:18
*** muriloht <muriloht!b1346902@gateway/web/freenode/ip.177.52.105.2> has joined #idempiere11:40
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC13:40
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has joined #idempiere13:52
*** norbertbede <norbertbede!~Adium@94.228.89.101> has quit IRC15:12
*** norbertbede <norbertbede!~Adium@94.228.89.101> has joined #idempiere15:12
*** norbertbede <norbertbede!~Adium@94.228.89.101> has quit IRC16:06
*** nmicoud <nmicoud!~Nicolas@riv38-2-78-235-108-177.fbx.proxad.net> has quit IRC17:25
Not[iDempiere] 1 commit to release-6.2 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/19:20
Not[iDempiere] globalqss 2e339e8 - Fix oracle datapump scripts19:20
Not[iDempiere6.2] jenkins build #122 started http://ci.idempiere.org/job/iDempiere6.2/122/19:50
Not[iDempiere6.2] jenkins build #122 completed: success http://ci.idempiere.org/job/iDempiere6.2/122/19:58
*** CarlosRuiz <CarlosRuiz!~CarlosRui@aftr-37-201-194-235.unity-media.net> has quit IRC21:04
*** a42niem <a42niem!~niem@p578b7daf.dip0.t-ipconnect.de> has quit IRC22:31
*** muriloht <muriloht!b1346902@gateway/web/freenode/ip.177.52.105.2> has quit IRC22:53
*** muriloht <muriloht!c8a19c33@gateway/web/freenode/ip.200.161.156.51> has joined #idempiere23:28

Generated by irclog2html.py 2.17.1 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!