IDempiere/FullMeeting20150506

From WikiQSS
Revision as of 21:01, 6 May 2015 by CarlosRuiz (talk | contribs) (full meeting)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

⇐ Table of Contents | 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)

Retrieved from "http://www.globalqss.com/wiki/index.php?title=IDempiere/FullMeeting20150506&oldid=532"