IDempiere/FullMeeting20150506 - Revision history

CarlosRuiz: drop JIRA notifications from log

2015-05-07T01:01:42Z

drop JIRA notifications from log

CarlosRuiz: full meeting

2015-05-07T01:01:24Z

full meeting

New page

⇐
[[IDempiere|Table of Contents]] |
[[IDempiere/Full Meeting Minutes|Full Meeting Minutes]] |
Full Meeting 2015-05-06


'''''miha_''''': Hello everybody. 
'''''CarlosRuiz''''': Good morning 
'''''miha_''''': I have a simple question: were there any efforts to port IDempiere to MS SQL server? 
'''''CarlosRuiz''''': simple answer then :-) no efforts 
'''''miha_''''': ok :) 
'''''CarlosRuiz''''': good news is that iDempiere has a DB translation layer - so it's feasible - I think even it could be done as a plugin 
'''''CarlosRuiz''''': but, unless you're captured by MS - is cheaper just to do it with postgresql or oracle 
'''''miha_''''': I'm poposed a project I planned to use IDempiere as a back bone for, but customer likes to pay Microsoft a lot, so MS SQL is a must. 
'''''miha_''''': ok. In know pretty much on IDempiere project structure and i'm sure I can make it connect to MS SQL database by writing another .db plugin. Can anyone tell me (maybe for own experience) what challenges may I face while porting database? 
'''''miha_''''': porting tables should not be too hard, but functions may take some time... 
'''''CarlosRuiz''''': yes - there are tools to move the database 
'''''CarlosRuiz''''': porting the functions is important 
'''''CarlosRuiz''''': my experience with SQLServer the procedural language was not solid 
'''''CarlosRuiz''''': but that was in 1999 - I guess it must be a lot better now 
'''''CarlosRuiz''''': and the iDempiere functions are little 
'''''CarlosRuiz''''': there are some parts in code where specifically it looks for DB.isOracle or DB.isPostgresSQL - I think working on a third db that must be fixed to make it more extensible 
'''''miha_''''': yea, about 50 functions. Not too much 
'''''CarlosRuiz''''': I think the real hard work is to try to keep up to date your database - because migration scripts are just pushed for oracle and postgresql 
'''''CarlosRuiz''''': maybe you could try to keep applying migration scripts in a pg db - and isolate the changes on 2pack to apply on your sqlserver instance 
'''''druiz''''': Hi everyone :) 
'''''CarlosRuiz''''': Hello druiz 
'''''ocurieles''''': Good Morning 
'''''CarlosRuiz''''': Hi ocurieles 
'''''nmicoud''''': Bonjour 
'''''ocurieles''''': Hi @CarlosRuz 
'''''CarlosRuiz''''': Hi nmicoud 
'''''nmicoud''''': Hello Carlos ; could you have a look at the last comment of jira #581 ? (DetailPane.IsOpen with System) 
'''''miha_''''': Pretty much places where DB.isOracle or DB.isPostgresSQL is used. Error code handling and customizing SQL queries 
'''''nmicoud''''': That make me think that nobody use System ; only SuperUser :) 
'''''CarlosRuiz''''': sure nmicoud - seems is just for oracle - in postgresql is working fine - but is still a PITA as it duplicates the preference records 
'''''nmicoud''''': PITA = ? 
'''''miha_''''': Hi nmicoud, I use System a lot and not SuperUser :) That's my preference 
'''''nmicoud''''': :) 
'''''CarlosRuiz''''': http://www.urbandictionary.com/define.php?term=pita 
'''''nmicoud''''': :D 
'''''ocurieles''''': :D 
'''''nmicoud''''': i only find the bread definition, so it was hard to understand ;) 
'''''CarlosRuiz''''': I don't use System - mostly SuperUser - and when admin account is shared then I create specific person accounts 
'''''ocurieles''''': Carlos Yesterday Saul found another bug in WebServices, I'm putting the patch in a jira Ticket... 
'''''CarlosRuiz''''': good ocurieles - thanks 
'''''tbayen''''': Hi all 
'''''CarlosRuiz''''': Hi tbayen 
'''''ocurieles''''': Hi @tbayen 
'''''CarlosRuiz''''': will start with 581 from nmicoud and then will keep checking peer review queue 
'''''nmicoud''''': thanks 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] globalqss 076e38c - IDEMPIERE-581 Store divider location for window per user / IDEMPIERE-369 / thanks to Nicolas Micoud (nmicoud) 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-581 status set to "Resolved" -resolution set to "Fixed" 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-581 
'''''aguerra''''': buenos dias a todos!!!!! 
'''''CarlosRuiz''''': Hi aguerra 
'''''aguerra''''': hello every body!!! 
'''''aguerra''''': hi CarlosRuiz 
'''''druiz''''': @CarlosRuiz did you check the how to here? 
'''''druiz''''': http://wiki.idempiere.org/en/NF3.0_User_Preference 
'''''druiz''''': is it good like that? 
'''''CarlosRuiz''''': thanks druiz - I think is good 
'''''Not-3656''''': [IDEMPIERE] ocurieles created IDEMPIERE-2609 WebServices - error to Complete Transaction in Composite Interface 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2609 
'''''ocurieles''''': @CarlosRuiz Ready, can you check the Saul jira ticket for Webservices ? all patch are included 
'''''ocurieles''''': :D 
'''''CarlosRuiz''''': good - a NPE 
'''''CarlosRuiz''''': will check it ... 
'''''ocurieles''''': Thanks -- 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2607 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed" 
'''''Not-3656''''': [IDEMPIERE] Thanks, this was integrated into es_CO maintained by GlobalQSS https://bitbucket.org/CarlosRuiz_globalqss/globalqss-idempiere-lco/commits/15f6e9e It will be available in seed in next release 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2607 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] globalqss 24f78e3 - IDEMPIERE-965 the create table process must also create the unique index for the UU column when found - fix issue with oracle index names longer than 30 char 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] sauljabin 21b6d26 - IDEMPIERE-2609 WebServices - error to Complete Transaction in Composite Interface 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2609 status set to "Resolved" -resolution set to "Fixed" 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2609 
'''''Not-3656''''': [IDEMPIERE] hieplq created IDEMPIERE-2610 kill warning 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2610 
'''''norbertbede''''': hi all 
'''''Not-3656''''': [IDEMPIERE] hieplq updated IDEMPIERE-2610 description set to "When run idempiere server, has warning: SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [bundleresource://170.fwk1519877292:1/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [bundleresource://170.fwk1519877292:2/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2610 
'''''norbertbede''''': anybody know our email system able to save sent email to imap mbox ? 
'''''DoctorStan''''': please I have a problem 
'''''DoctorStan''''': maybe you canhelp me 
'''''DoctorStan''''': GardenAdmin 
'''''DoctorStan''''': has been disactivated in my Idmepiere installation 
'''''DoctorStan''''': how ot I reactivate it? 
'''''DoctorStan''''': Hi All 
'''''DoctorStan''''': sorry 
'''''DoctorStan''''': just its urgent 
'''''DoctorStan''''': maybe somebody can help me 
'''''norbertbede''''': try: Reset Locked Account 
'''''DoctorStan''''': OK 
'''''DoctorStan''''': how and where doI do that please 
'''''norbertbede''''': you cant login ? 
'''''DoctorStan''''': thank you norbetede 
'''''DoctorStan''''': I can login 
'''''DoctorStan''''': but one of the users 
'''''DoctorStan''''': had logged in and disactivated 
'''''DoctorStan''''': so I can login but 
'''''DoctorStan''''': I cannot do anything bc 
'''''DoctorStan''''': my role 
'''''DoctorStan''''': is not garden admin 
'''''DoctorStan''''': its system administrator 
'''''DoctorStan''''': I cannot reset it and bring back the user 
'''''DoctorStan''''': Please norbede 
'''''DoctorStan''''': can you help me 
'''''DoctorStan''''': I am helpless infront of a demo 
'''''DoctorStan''''': I can login but garden admin has been disactivated 
'''''DoctorStan''''': so I have only system admin rights 
'''''DoctorStan''''': Please community anybody to help me? 
'''''hieplq_''''': @DoctorStan, if you sure role GardenAdmin is deactived. just reactive it by modify direct database 
'''''ocurieles''''': @DoctorStan try with SuperUser 
'''''ocurieles''''': you can use our demo site https://ingeint.ec/webui 
'''''CarlosRuiz''''': norbertbede, didn't understand your issue with imap email? 
'''''norbertbede''''': hi carlosruiz 
'''''hieplq_''''': i think email always keep in sent folder (i test with gmail) 
'''''norbertbede''''': i looking for option to "store" emails sent by salesman to sent folder - for IMAP server 
'''''norbertbede''''': to IMAP server 
'''''norbertbede''''': other solution i found bcc to own email 
'''''hieplq_''''': norbertbede, idempiere hire email server sent email, so email always keep a copy in sent folder 
'''''CarlosRuiz''''': ah yes - bcc own email - and there is also the possibility to bcc to a fixed email all idempiere mails 
'''''DoctorStan''''': Thanks so much @ocurieless 
'''''ocurieles''''': but bcc email is in System Configurator no ? 
'''''norbertbede''''': never understand why some people bcc-ing emails.... 
'''''norbertbede''''': :) 
'''''norbertbede''''': bcc is available 
'''''norbertbede''''': i see 
'''''ocurieles''''': yes 
'''''ocurieles''''': When enabled the outgoing mails from Adempiere will be sent BCC to the originating user 
'''''ocurieles''''': you're Welcome @DoctorStan :D 
'''''CarlosRuiz''''': hieplq_, AYT? 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] globalqss 81bf41d - IDEMPIERE-1770 Allowing manual entry from Attributes tab on shipment/MR line - fix issue not allowing negative shipments 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1770 
'''''Not-3656''''': [IDEMPIERE] As reported by [~didiber] and [~red1] here: https://groups.google.com/d/msg/idempiere/3K_-KPznBlk/v0YjkiwfyaIJ because of a bug introduced with IDEMPIERE-1770 negative shipments were not allowed (causing negative in POS orders not allowed). Fixed with https://bitbucket.org/idempiere/idempiere/commits/81bf41d 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-1770 
'''''hieplq_''''': hi @CarlosRuiz, i'm here 
'''''CarlosRuiz''''': Hi hieplq_ 
'''''CarlosRuiz''''': are you planning to use experimental for another feature? 
'''''hieplq_''''': yes. at weekend, i will apply css and after that collect issue relate info window. 
'''''CarlosRuiz''''': ah great 
'''''CarlosRuiz''''': I was thinking to use it to experiment something with nmicoud - but better I leave it for your info window tickets - there are a lot 
'''''hieplq_''''': maybe you and nmicoud make other branch. i feel this way is verry better. sync a branch with development is more easy than sync patch. 
'''''CarlosRuiz''''': the issue with nmicoud is minor - I think we can manage it with patches 
'''''aguerra''''': hi somebody know how to change the header when i use the request email process ... ej: http://pastebin.com/fBg8c9zw 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] sauljabin 1777e03 - IDEMPIERE-2604 Use LIKE sentence in webservice queryData / integrate code by Jan Thielemann (jthielemann) https://www.youtube.com/watch?v=04V459i0vR4 
'''''CarlosRuiz''''': aguerra, it sounds like touching code is needed there 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2604 status set to "Resolved" -resolution set to "Fixed" 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2604 
'''''CarlosRuiz''''': hieplq_, noticed you changed IDEMPIERE-2610 to Fixed - but it doesn't have a patch 
'''''CarlosRuiz''''': sometimes I search in JIRA for "resolution = Unresolved" for open tickets 
'''''hieplq_''''': about IDEMPIERE-2610, it's accident, i testing patch, will attach and change status when done. 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2443 status set to "Resolved" -resolution set to "Won't Fix" 
'''''Not-3656''''': [IDEMPIERE] [~hardmax], I think that's the idea of credit check. The binding/non-binding affects stock reservation, not credit check. 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2443 
'''''CarlosRuiz''''': thanks hieplq_ 
'''''CarlosRuiz''''': experimental server is in chinese - I can't understand one word there :-) 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2606 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Cannot Reproduce" 
'''''Not-3656''''': [IDEMPIERE] [~kinerix], I wasn't able to reproduce the issue. I set up a test case copying the Business Partner window and setting up the new copied window as zoom on BP table. Then issued a report for Sales order and both BP and InvoiceBP zoomed correctly to the new window. 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2606 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2605 Attachment set to "IDEMPIERE-2605.patch" 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2605 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2605 
'''''Not-3656''''': [IDEMPIERE] [~creed.gds], after reading the spec of drop shipment from [~jstangeland] and adaxa, I think you're right - the drop ship orders are not intended to be delivered, so they don't need the stock validation. Can you please test the attached patch (I just took your patch from the forums and added the same validation on the qty method). 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2605 
'''''Not-3656''''': [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2605 labels set to "+Patch" 
'''''Not-3656''''': [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2605 
'''''Not-3656''''': [iDempiere] CarlosRuiz_globalqss pushed 1 commit to development [+4/-0/±9] https://bitbucket.org/idempiere/idempiere/commits/ 
'''''Not-3656''''': [iDempiere] globalqss dbc5b93 - hg merge release-2.1 (merge release2.1 into development)

@@ Line 52: / Line 52: @@
 '''''CarlosRuiz''''': will start with 581 from nmicoud  and then will keep checking peer review queue<br>
 '''''nmicoud''''': thanks<br>
 '''''aguerra''''': buenos dias a todos!!!!!<br>
 '''''CarlosRuiz''''': Hi aguerra <br>
@@ Line 64: / Line 60: @@
 '''''druiz''''': is it good like that?<br>
 '''''CarlosRuiz''''': thanks druiz - I think is good<br>
 '''''ocurieles''''': @CarlosRuiz Ready, can you check the Saul jira ticket for Webservices ? all patch are included<br>
 '''''ocurieles''''': :D<br>
@@ Line 71: / Line 65: @@
 '''''CarlosRuiz''''': will check it ...<br>
 '''''ocurieles''''': Thanks --<br>
 '''''norbertbede''''': hi all<br>
 '''''norbertbede''''': anybody know our email system able to save sent email to imap mbox ?<br>
 '''''DoctorStan''''': please I have a problem<br>
@@ Line 136: / Line 117: @@
 '''''ocurieles''''': you're Welcome @DoctorStan :D<br>
 '''''CarlosRuiz''''': hieplq_, AYT?<br>
 '''''hieplq_''''': hi @CarlosRuiz, i'm here<br>
 '''''CarlosRuiz''''': Hi hieplq_ <br>
@@ Line 150: / Line 126: @@
 '''''CarlosRuiz''''': the issue with nmicoud is minor - I think we can manage it with patches<br>
 '''''aguerra''''': hi somebody know how to change the header when i use the request email process ... ej: http://pastebin.com/fBg8c9zw<br>
 '''''CarlosRuiz''''': aguerra, it sounds like touching code is needed there<br>
 '''''CarlosRuiz''''': hieplq_, noticed you changed IDEMPIERE-2610 to Fixed - but it doesn't have a patch<br>
 '''''CarlosRuiz''''': sometimes I search in JIRA for "resolution = Unresolved" for open tickets<br>
 '''''hieplq_''''': about IDEMPIERE-2610, it's accident, i testing patch, will attach and change status when done.<br>
 '''''CarlosRuiz''''': thanks hieplq_ <br>
 '''''CarlosRuiz''''': experimental server is in chinese - I can't understand one word there  :-)<br>