#idempiere IRC log for Wednesday, 2015-05-06

*** is-mw has joined #idempiere01:36
*** is-mw2 has quit IRC01:38
*** jmpiloq has quit IRC04:32
*** a42niem has joined #idempiere05:14
*** nmicoud has joined #idempiere05:34
*** nmicoud has quit IRC05:53
*** nmicoud has joined #idempiere05:58
*** KermitTheFragger has joined #idempiere06:37
*** hieplq has quit IRC09:07
*** ngordon7000 has joined #idempiere12:11
*** RD_ has joined #idempiere12:31
*** RD_ is now known as Guest8089112:31
*** CarlosRuiz has joined #idempiere12:58
*** ChanServ sets mode: +o CarlosRuiz12:58
*** HideakiHagiwara has joined #idempiere12:59
*** muriloht has joined #idempiere13:00
*** miha_ has joined #idempiere13:08
miha_Hello everybody.13:08
CarlosRuizGood morning13:08
miha_I have a simple question: were there any efforts to port IDempiere to MS SQL server?13:09
CarlosRuizsimple answer then  :-)  no efforts13:09
miha_ok :)13:10
CarlosRuizgood news is that iDempiere has a DB translation layer - so it's feasible - I think even it could be done as a plugin13:10
CarlosRuizbut, unless you're captured by MS - is cheaper just to do it with postgresql or oracle13:11
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.13:11
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?13:13
*** gabrielss has joined #idempiere13:13
miha_porting tables should not be too hard, but functions may take some time...13:14
CarlosRuizyes - there are tools to move the database13:15
CarlosRuizporting the functions is important13:15
CarlosRuizmy experience with SQLServer the procedural language was not solid13:15
CarlosRuizbut that was in 1999 - I guess it must be a lot better now13:16
*** Lucas_ has joined #idempiere13:16
CarlosRuizand the iDempiere functions are little13:16
*** Lucas_ has left #idempiere13:16
CarlosRuizthere 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 extensible13:17
miha_yea, about 50 functions. Not too much13:18
CarlosRuizI think the real hard work is to try to keep up to date your database - because migration scripts are just pushed for oracle and postgresql13:18
CarlosRuizmaybe you could try to keep applying migration scripts in a pg db - and isolate the changes on 2pack to apply on your sqlserver instance13:19
*** druiz has joined #idempiere13:19
druizHi everyone :)13:20
CarlosRuizHello druiz13:20
*** ocurieles has joined #idempiere13:21
ocurielesGood Morning13:21
CarlosRuizHi ocurieles13:21
nmicoudBonjour13:21
ocurielesHi @CarlosRuz13:22
CarlosRuizHi nmicoud13:22
nmicoudHello Carlos ; could you have a look at the last comment of jira #581 ? (DetailPane.IsOpen with System)13:22
*** tbayen has joined #idempiere13:22
miha_Pretty much places where DB.isOracle or DB.isPostgresSQL is used. Error code handling and customizing SQL queries13:23
nmicoudThat make me think that nobody use System ; only SuperUser :)13:23
CarlosRuizsure nmicoud - seems is just for oracle - in postgresql is working fine - but is still a PITA as it duplicates the preference records13:25
nmicoudPITA = ?13:26
miha_Hi nmicoud, I use System a lot and not SuperUser :) That's my preference13:26
nmicoud:)13:26
CarlosRuizhttp://www.urbandictionary.com/define.php?term=pita13:26
nmicoud:D13:26
ocurieles:D13:27
nmicoudi only find the bread definition, so it was hard to understand ;)13:27
CarlosRuizI don't use System - mostly SuperUser - and when admin account is shared then I create specific person accounts13:28
ocurielesCarlos Yesterday Saul found another bug in WebServices, I'm putting the patch in a jira Ticket...13:28
CarlosRuizgood ocurieles - thanks13:28
tbayenHi all13:30
CarlosRuizHi tbayen13:30
ocurielesHi @tbayen13:37
CarlosRuizwill start with 581 from nmicoud  and then will keep checking peer review queue13:40
nmicoudthanks13:41
*** miha_ has quit IRC13:56
*** aguerra has joined #idempiere14:01
Not-3656[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/14:01
Not-3656[iDempiere] globalqss 076e38c - IDEMPIERE-581 Store divider location for window per user / IDEMPIERE-369 / thanks to Nicolas Micoud (nmicoud)14:01
*** aguerra has quit IRC14:01
Not-3656[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-581 status set to "Resolved" -resolution set to "Fixed"14:01
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-58114:01
*** aguerra has joined #idempiere14:02
aguerrabuenos dias a todos!!!!!14:02
CarlosRuizHi aguerra14:02
aguerrahello every body!!!14:02
aguerrahi CarlosRuiz14:02
*** muriloht has quit IRC14:03
*** a_ has joined #idempiere14:15
*** a_ has left #idempiere14:16
*** lucasb has joined #idempiere14:17
*** lucasb has quit IRC14:18
druiz@CarlosRuiz did you check the how to here?14:21
druizhttp://wiki.idempiere.org/en/NF3.0_User_Preference14:21
druizis it good like that?14:21
CarlosRuizthanks druiz - I think is good14:21
Not-3656[IDEMPIERE] ocurieles created IDEMPIERE-2609 WebServices - error to Complete Transaction in Composite Interface14:25
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-260914:25
ocurieles@CarlosRuiz Ready, can you check the Saul jira ticket for Webservices ? all patch are included14:27
ocurieles:D14:27
CarlosRuizgood - a NPE14:28
CarlosRuizwill check it ...14:28
*** hieplq has joined #idempiere14:42
*** gabrielss has quit IRC14:43
ocurielesThanks --15:02
*** nmicoud has quit IRC15:11
*** KermitTheFragger has quit IRC15:20
*** ngordon7000 has quit IRC15:26
*** HideakiHagiwara has quit IRC15:30
*** ocuriele_ has joined #idempiere15:37
Not-3656[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2607 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed"15:38
*** ocurieles has quit IRC15:38
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 release15:38
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-260715:38
*** ocuriele_ has quit IRC15:44
*** ocurieles has joined #idempiere15:44
*** jmpiloq has joined #idempiere16:35
Not-3656[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/17:03
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 char17:03
Not-3656[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/17:19
Not-3656[iDempiere] sauljabin 21b6d26 - IDEMPIERE-2609 WebServices - error to Complete Transaction in Composite Interface17:19
Not-3656[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2609 status set to "Resolved" -resolution set to "Fixed"17:20
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-260917:20
*** Guest80891 has quit IRC18:31
Not-3656[IDEMPIERE] hieplq created IDEMPIERE-2610 kill warning18:36
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-261018:36
*** norbertbede has joined #idempiere18:38
norbertbedehi all18:38
*** hieplq has quit IRC18:41
*** hieplq_ has joined #idempiere18:41
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: Actual19:04
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-261019:04
norbertbedeanybody know our email system able to save sent email to imap mbox ?19:33
*** molander has left #idempiere19:53
*** DoctorStan has joined #idempiere20:11
DoctorStanplease I have a problem20:11
DoctorStanmaybe you canhelp me20:11
DoctorStanGardenAdmin20:11
DoctorStanhas been disactivated in my Idmepiere installation20:12
DoctorStanhow ot I reactivate it?20:12
DoctorStanHi All20:12
DoctorStansorry20:12
DoctorStanjust its urgent20:12
DoctorStanmaybe somebody can help me20:12
norbertbedetry: Reset Locked Account20:16
DoctorStanOK20:17
DoctorStanhow and where doI do that please20:17
norbertbedeyou cant login ?20:17
DoctorStanthank you norbetede20:18
DoctorStanI can login20:18
DoctorStanbut one of the users20:18
DoctorStanhad logged in and disactivated20:18
DoctorStanso I can login but20:18
DoctorStanI cannot do anything bc20:18
DoctorStanmy role20:18
DoctorStanis not garden admin20:18
DoctorStanits system administrator20:18
DoctorStanI cannot reset it and bring back the user20:23
DoctorStanPlease norbede20:28
DoctorStancan you help me20:28
DoctorStanI am helpless infront of a demo20:28
DoctorStanI can login but garden admin has been disactivated20:28
DoctorStanso I have only system admin rights20:29
DoctorStanPlease community anybody to help me?20:30
*** a42niem has quit IRC20:32
hieplq_@DoctorStan, if you sure role GardenAdmin is deactived. just reactive it by modify direct database21:14
ocurieles@DoctorStan try with SuperUser21:15
ocurielesyou can use our demo site https://ingeint.ec/webui21:17
CarlosRuiznorbertbede, didn't understand your issue with imap email?21:17
norbertbedehi carlosruiz21:19
hieplq_i think email always keep in sent folder (i test with gmail)21:19
norbertbedei looking for option to "store" emails sent by salesman to sent folder - for IMAP server21:20
norbertbedeto IMAP server21:20
norbertbedeother solution i found bcc to own email21:20
hieplq_norbertbede, idempiere hire email server sent email, so email always keep a copy in sent folder21:21
CarlosRuizah yes - bcc own email - and there is also the possibility to bcc to a fixed email all idempiere mails21:21
DoctorStanThanks so much @ocurieless21:29
ocurielesbut bcc email is in System Configurator no ?21:32
norbertbedenever understand why some people bcc-ing emails....21:33
norbertbede:)21:34
norbertbedebcc is available21:34
norbertbedei see21:34
ocurielesyes21:36
ocurielesWhen enabled the outgoing mails from Adempiere will be sent BCC to the originating user21:37
ocurielesyou're Welcome @DoctorStan :D21:37
CarlosRuizhieplq_, AYT?21:38
Not-3656[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/21:39
Not-3656[iDempiere] globalqss 81bf41d - IDEMPIERE-1770 Allowing manual entry from Attributes tab on shipment/MR line - fix issue not allowing negative shipments21:39
Not-3656[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-177021:41
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/81bf41d21:41
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-177021:41
hieplq_hi @CarlosRuiz, i'm here21:46
CarlosRuizHi hieplq_21:53
CarlosRuizare you planning to use experimental for another feature?21:53
hieplq_yes. at weekend, i will apply css and after that collect issue relate info window.21:56
CarlosRuizah great21:56
CarlosRuizI was thinking to use it to experiment something with nmicoud - but better I leave it for your info window tickets - there are a lot21:56
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.21:59
CarlosRuizthe issue with nmicoud is minor - I think we can manage it with patches22:06
aguerrahi somebody know how to change the header when i use the request email process ... ej: http://pastebin.com/fBg8c9zw22:11
Not-3656[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/22:25
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=04V459i0vR422:25
CarlosRuizaguerra, it sounds like touching code is needed there22:26
Not-3656[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2604 status set to "Resolved" -resolution set to "Fixed"22:26
Not-3656[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-260422:26
*** ocurieles has quit IRC22:35
CarlosRuizhieplq_, noticed you changed IDEMPIERE-2610 to Fixed - but it doesn't have a patch22:37
*** carlos_ has joined #idempiere22:42
*** CarlosRuiz has quit IRC22:42
*** carlos_ has quit IRC22:42
*** CarlosRuiz has joined #idempiere22:42
*** ChanServ sets mode: +o CarlosRuiz22:42
CarlosRuizsometimes I search in JIRA for "resolution = Unresolved" for open tickets22:43
*** aguerra has quit IRC23:33
*** DoctorStan has quit IRC23:39
hieplq_about IDEMPIERE-2610, it's accident, i testing patch, will attach and change status when done.23:59

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!