IDempiere/FullMeeting20150506

From WikiQSS

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
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
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 --
norbertbede: hi all
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?
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
CarlosRuiz: aguerra, it sounds like touching code is needed there
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.
CarlosRuiz: thanks hieplq_
CarlosRuiz: experimental server is in chinese - I can't understand one word there :-)