IDempiere/FullMeeting20140507

⇐ Table of Contents | Full Meeting Minutes | Full Meeting 2014-05-07

CarlosRuiz: Good morning
hieplq: hi CarlosRuiz. on time :)
Deepak: Good Morning
Deepak: hengsin / Carlos, Any chance to review IDEMPIERE-1770?
armenrz: Hello all
red1: Hola all.. sorry i am late
red1: Nice to see you armenrz :D
red1: Apa khabar?
armenrz: hi Red1, baik :)
red1: Out of topic, but do you know our MH370 flew around west of Sumatera?
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1936
Not-6d9: [IDEMPIERE] this seems closely related to IDEMPIERE-1062, there I was proposing that on dates we could allow entering an integer, meaning the number of days relative to the date
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1936
red1: Also armen, i just finished a Sales Forecast feature for the Budget module
red1: i am trying to port it for ADempiere360 too but the migrations scripts or 2Pack cannot work back there
red1: have to rebuild the AD changes by hand
red1: Here is the link if you want to see http://red1.org/adempiere/viewtopic.php?f=45&t=1798&p=8599#p8599
CarlosRuiz: backporting to AD is a nightmare after you have seen the light with the new 2pack and OSGi :-)
red1: Only the raw tables got in the DB.. not the AD_*
red1: But its good to visit back and test how the new code still works easily
red1: It proves that OSGi has no impact on business logic
armenrz: red1, it's fantastic
red1: This idea was given by Thomas Bayen just last night here and i realised it is a great idea that is easily extended in the budget module
armenrz: yes, actually sales target works almost the same way as budget
red1: You can set a target just like a budget but using the Sales Trx arg
red1: and if so the system will not stop if excess but log it in Notice
red1: and u can allow the target to change according to months or years of performance analysis
red1: Now i need another good idea what best reporting for it
red1: I am thinking Budget line relate to FactAccts difference
red1: of same criteria
red1: So u can see how far you are from your targets and budget limits every time
armenrz: red1, I just skim to read your link...can we do something like budget reviewing...i mean usually in the mid year, they like to review and change the budget ?
armenrz: or perhaps a what-if operation ? :)
norbertbede: hi all
CarlosRuiz: Hi norbertbede
CarlosRuiz: Deepak, I have not reviewed it yet
red1: armenrz: can u give me more description?
red1: so i can figure it out
red1: u can give me some pseudo design of the type of report
red1: i think the review can go through like i said but break down for each month
red1: under each rule
red1: of how many percent they are reaching to the target or limit
red1: if u can help test i should be exporting the plugin soon
red1: the code is ready and i putting in bitbucket
CarlosRuiz: hieplq, about IDEMPIERE-1935 - which password window? the "forgot my password" link? or the "reset password" form?
CarlosRuiz: ah got it - the "forgot" link
hieplq: ok :)
Deepak: CarlosRuiz, I think hengsin picket it up.
red1: yes armenrz the Generate Budget is sort of a preiodic review
red1: Anyone remember how to launch ADempiere 361?
red1: From Eclipse source
red1: And launching the Server?
red1: Ah working
red1: and hitting modelvalidator not found
CarlosRuiz: hieplq, I applied the patch for IDEMPIERE-1935 - but still enter key is stagnated at "Processing..."
hieplq: huh. i test it ok. in local and my server
hieplq: you test with case USER_LOCKING_MAX_PASSWORD_AGE_DAY
CarlosRuiz: no, forgot my password link
CarlosRuiz: on second screen it asks for email and I entered the email and pushed enter
hieplq: forgot my password link is ok in my side
hieplq: i will retest "forgot my password" my patch is for screen "change passs"
CarlosRuiz: ok - testing that one
CarlosRuiz: seems I found is a different bug similar
hieplq: ok. let me check it
hieplq: yes. similar bug, similar solution
CarlosRuiz: ok - tested and worked - thanks hieplq
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1935
Not-6d9: [IDEMPIERE] Thanks [~hieplq], committed your patch with https://bitbucket.org/idempiere/idempiere/commits/47c5dc3 As we talked in meeting found a similar issue with forgot my link password waiting on enter on the email field.
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1935
Not-6d9: [IDEMPIERE] hieplq updated IDEMPIERE-1935 Attachment set to " IDEMPIERE-1935-forgot.patch"
Not-6d9: [IDEMPIERE] Hi [~carlosruiz_globalqss] i attach patch for "forget password"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1935
hieplq: hi CarlosRuiz, https://idempiere.atlassian.net/browse/IDEMPIERE-1540 is ok to integrate to trunk or make a plug-in?
CarlosRuiz: I think that must be trunk - is configurable anyways
hieplq: thanks, I will try implement it.
hieplq: with time zone, my case is: time in server is 7-5, time in my local is 6-5, when i make new "move inventory", default value of "move date" is 7-5, same server time.
CarlosRuiz: the demo server is in Germany UTC+1 - could you please explain me the issue with that server?
norbertbede: are we talking about this https://idempiere.atlassian.net/browse/IDEMPIERE-1933
norbertbede: hiep
hieplq: yes.
norbertbede: Carlos did you read pls the menitoned issue/improvement
hieplq: UTC+1 = GMT + 1?
CarlosRuiz: I just created an inventory move record there "test"
CarlosRuiz: the Created is shown as May 7, 2014 5:15:49 PM CEST
CarlosRuiz: which is fine - that's the time of the server
CarlosRuiz: is 10:15:40 AM here
norbertbede: im in slovakia now same timezone as in germany
norbertbede: lets say i will create a record with 05-19 now
norbertbede: how the system will know that record was created in your timezone 10.15
CarlosRuiz: as it is actually the system doesn't know - because all the times on the database are using server timezone
norbertbede: so if my friend will work in USA - wake up take a caffe he will prefer to say oh my friedn has bencreate a record 10.19 my time
norbertbede: that is what about this issue is
CarlosRuiz: is it a presentation issue?
norbertbede: i suggest in issue to implement for client/org/iser timezone
norbertbede: then we can render for each user his timezone
norbertbede: server zone +/- user zone = real timestamp in logged in user zone
norbertbede: can imagine if we will improve chatt app
norbertbede: or activity stream
norbertbede: i would be glad to implement it
norbertbede: its de-facto standard in all cloud running apps
norbertbede: dont know it is hard or nor
CarlosRuiz: my question is trying to check the complexity of the solution
norbertbede: to improve
CarlosRuiz: if is a presentation issue can be easy to fix
CarlosRuiz: but implementing timezone in database sounds big impact
norbertbede: i means it is about presentation issue.
norbertbede: no-no database is only 1 time
norbertbede: i server-or cluster
norbertbede: that prerequests some changes areund adding fields timezone to client/org/user
norbertbede: then improve all fields/layouts where we render time
norbertbede: consider user zone
norbertbede: we wrote about that with hiep. we can prepare patch
norbertbede: resp. i can manage he can make investigation in code and prepare patches
CarlosRuiz: is it really userzone necessary? I think the system can figure out the timezone of the browser easily
CarlosRuiz: and that can be helpful if you're traveling
norbertbede: browser easily ?
norbertbede: what you mena
norbertbede: mean
CarlosRuiz: nevermind - maybe is not that easy :-)
CarlosRuiz: ah yes
CarlosRuiz: sorry
CarlosRuiz: is easy
CarlosRuiz: actually the timezone is being saved on AD_Session.Description
CarlosRuiz: I mean - the client timezone
CarlosRuiz: so, it can be as google - if the user has a preference it uses the preference - otherwise it shows the browser timezone
norbertbede: good. so my concept is acceptable just would be improved by browser session behaviour
hieplq: with input and display it can easy, but report, print is other story
CarlosRuiz: well - just showing the browser timezone will be an interesting improvement
CarlosRuiz: but your idea sounds good - allow the user to set a preference
hieplq: we must input timezone to jasper
norbertbede: you mean properly view time also in jasper docs too
hieplq: yes. use push print button, pass timezone to report, report print time of local not time of server and print timezone info (ex: +7)
norbertbede: but that is same is on normal reports - its one presentation "interface"
CarlosRuiz: is that a property of the formatting of the field on jasper?
norbertbede: im not familiar with jasper, know but dont like. not enoug h experience. hiep ?
hieplq: timezone it's a auto parameter (same record_id) and resper design will take care this paramete
hieplq: he can ofset all time column with this paramete
hieplq: @nobertbede just think it as a report.
norbertbede: i doun that http://community.jaspersoft.com/questions/517926/date-field-timezone-locale-na
norbertbede: don know its enough to folow or help
norbertbede: so if it will works can we get it to base Carlos ?
hieplq: help a bit :) just time make by jasper. with column time from db, he must manual offset
norbertbede: i cant imagine it as plugin, othwerwise no reason to investigate
CarlosRuiz: yep - that sounds for core
CarlosRuiz: as usual make it configurable ( as suggested by norbertbede )
norbertbede: thanks well
norbertbede: Carlos can we discuss the last issue for me ?
norbertbede: its https://idempiere.atlassian.net/browse/IDEMPIERE-1788
norbertbede: Value preference for info window process parameters
hieplq: I see other case. in this time i deploy server at usa, date is save by usa zone. next year i move server to vietnam, difference time zone make issue.
hieplq: work-around is set timezone 2 server to same
hieplq: but it can is good when adjust all time to GMT+0
norbertbede: you can run server in USA with vietnam zone
norbertbede:
norbertbede: its question for linux time settings
norbertbede: if you are administer server from vietnam in USA then no reason to run linux with USA time
hieplq: yes. it's work-around
norbertbede: or i can imagine a process to change update all date/time fields once on migration …..that need more investiation
hieplq: @CarlosRuiz, I add new patch for "forget password" window for ticket IDEMPIERE-1935, please review it.
CarlosRuiz: ok
norbertbede: Carlos can we discuss the last issue for me ?
norbertbede: its https://idempiere.atlassian.net/browse/IDEMPIERE-1788
norbertbede: Value preference for info window process parameters
norbertbede: that looks me big help to get less erros in database
norbertbede: from normal data entry
norbertbede: i classify it as important, what you mean
norbertbede: pls
CarlosRuiz: yep
norbertbede: what you mean implement value preferences - benefit/effor
norbertbede: t
CarlosRuiz: I think there is another similar suggestion from Chuck
CarlosRuiz: yep - you already linked it
CarlosRuiz: checking complexity ....
CarlosRuiz: well - if using ad_preference we would need to add AD_Preference.AD_Process_ID
CarlosRuiz: and then it seems to be straight
CarlosRuiz: thinking in Chuck's case (IDEMPIERE-1815) it could be possible also to implement something similar with AD_Form_ID
norbertbede: i agree with that, replace all forms with info window
norbertbede: much more better approach
norbertbede: we can take some windows to convert
norbertbede: i will create list of windows to replace
norbertbede: would be this way to handle as a small project
CarlosRuiz: ah - in such case we would need AD_InfoWindow_ID there
norbertbede: ok will contact chuck to talk his ideas
norbertbede: thanks anyway
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.0 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] hieplq 6e56602 - IDEMPIERE-1935:in changepassword window, push "enter" key make waiting window never end
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1935 status set to "Resolved" -assignee set to "hieplq" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1935
Not-6d9: [IDEMPIERE] hieplq created IDEMPIERE-1937 zk7: NPE when click cancel from screen "change role" when login and "forget password"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1937
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1931
Not-6d9: [IDEMPIERE] [~acanaveral], I don't get what's the issue. The IsPrepayment field is read-only and set just on beforeSave. Seems like your suggestion is supposing the IsPrepayment field is not readonly but set by the user. Regards, Carlos Ruiz
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1931
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1922 summary set to "Extend Window Customisation by Context Help Field"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] So, actually you can customize help for a field on AD_Field, AD_Field_Trl, AD_UserDef_Field. And also you can provide explanation for a tab (i.e. how to fill the fields using the context help for the tab. What is the requirement here? Ability to set up a context help for a specific field? Are the options above enough?
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] norbert.bede updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] The main point is to give ability to define by CLIENT Admin e.g. GardenAdmin (not SuperUser) to create custom helps for his users. by Context Helps. installation System (general helps) Client 1 (unique/client specific helps) Client 2 (unique/client specific helps) I cant find out this solution now in latest version.
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] hieplq updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] we can define each client one language. example english 1, english 2 ?
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] norbert.bede updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] each client has own default language. context helps are multilingual. means if you then attach a context help to an english window customisation or e.g. a vietnam window customisation - the translations must be handled automatically.
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1923
Not-6d9: [IDEMPIERE] The context help was designed to be tenant modifiable - Context Help window is available for tenants - and it overrides the definition of System. Just made the test with Sales Order tab on demo. Regards, Carlos Ruiz
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1923
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] is it the same purpose of IDEMPIERE-1923 - I just answered there that context help is multi-tenant designed
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] norbert.bede updated IDEMPIERE-1923
Not-6d9: [IDEMPIERE] i see what you mean. anyway you do that as SuperUser. Means you can do that as SuperUser in System Client. this way you replace on sales order for all clients in multi tenant system. i suggest delegate this task for client admins. means no SuperUser right required to manage context helps only for 1 client. GardenAdmin will create his helps only for GardenWorld client. is it possible or i something miss ? norbert
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1923
Not-6d9: [IDEMPIERE] norbert.bede updated IDEMPIERE-1922
Not-6d9: [IDEMPIERE] https://idempiere.atlassian.net/browse/IDEMPIERE-1923 answered this response.
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1922
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1923
Not-6d9: [IDEMPIERE] You can do that as GardenAdmin, open the Context Help window, search the context help you want to customize for the tenant, go to second tab (Message) and add your custom message, you can also add translations for multi-lang. Regards, Carlos Ruiz
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1923
Not-6d9: [IDEMPIERE] norbert.bede updated IDEMPIERE-1923
Not-6d9: [IDEMPIERE] i got it see. that is very-very hidden approach. anyway technically is possible as disadvantage in first moment i see. if no context help defined system wide, then client can't add his. i can't decide now my request is still valid. maybe just i need to understand power. i will come back later to comment it. THANKS for detailed explanation. n
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1923
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1916
Not-6d9: [IDEMPIERE] This is suggested to be developed as a plugin - and adviced to take into account security considerations as the change audit is showing obscured fields plain.
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1916
aguerra_: hi every body
aguerra_: pls some help!!!
aguerra_: In the type of tax, have an option Document Level ... As I can know if it is at the document level or line?
aguerra_: in the table c_invoice_linetax?
aguerra_: sorry .. in c_invoiceTax
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.0 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] globalqss b778b01 - IDEMPIERE-709 All Created and Updated columns must be not null default statement_timestamp() in database / packin failed creating Created column with default SYSDATE
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1901
Not-6d9: [IDEMPIERE] Hi [~nmicoud], I think the creation of the composite primary key is not consistent in the app. * if you use packin to create a new table with composite key - then the primary key is not created * if you create a table with a few columns not parent and push synchronize - the primary key is not created * if you push the synchronize column with all the parent columns created - the primary key is created * if you push the synchronize column wi
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1901
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1843 status set to "Resolved" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1843
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.0 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] nmicoud 2322f9a - IDEMPIERE-1843 Tabs and Fields not translated in Help
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 2 commits to release-2.0 [+2/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] nmicoud 314efd1 - IDEMPIERE-1843 Tabs and Fields not translated in Help
Not-6d9: [iDempiere] globalqss 3d0dc60 - IDEMPIERE-1894 Missing SeqNoGrid when generating Fields in a Tab (TabCreateFields.java) / based on patch from Jan Thielemann
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1894 status set to "Resolved" -assignee set to "Jan Thielemann" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1894
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1726 summary set to "Error in report when there are filters (historical records)"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1726
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.0 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] globalqss 121e59e - IDEMPIERE-1726 Error in report when there are filters (historical records)
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1726 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1726
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1763 Attachment set to "wrong_invoice.png"
Not-6d9: [IDEMPIERE] Yep, definitely the formats are being shown wrongly, this is from the seed invoice format: !wrong_invoice.png!
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1763
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.0 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] globalqss f5ff704 - IDEMPIERE-1763 Reporting engine fixes / fix the fixed width problem for null values - backward compatible with existing formats
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1763 status set to "Resolved" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1763
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1412 status set to "Closed" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Duplicate"
Not-6d9: [IDEMPIERE] closing this as duplicate of IDEMPIERE-1898 as that ticket has better research from [~hieplq]
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1412
Not-6d9: [IDEMPIERE] hieplq created IDEMPIERE-1938 zk7:warning about ArrayIndexOutOfBoundsException of sun.awt.X11.XEvent
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1938
Not-6d9: [iDempiere] CarlosRuiz_globalqss pushed 2 commits to development [+6/-0/±26] https://bitbucket.org/idempiere/idempiere/commits/
Not-6d9: [iDempiere] globalqss ea93ba6 - IDEMPIERE-1898 When save a new record, row select is change to latest record / IDEMPIERE-1412 Creating a new record on window access moves to wrong position
Not-6d9: [iDempiere] globalqss 940400b - hg merge release-2.0 (merge release2 into development)
Not-6d9: [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1898 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed"
Not-6d9: [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1898