CarlosRuiz: full meeting

2012-03-21T15:06:24Z

full meeting

New page

⇐
[[IDempiere|Table of Contents]] |
[[IDempiere/Full Meeting Minutes|Full Meeting Minutes]] |
Full Meeting 2012-03-21


'''''CarlosRuiz''''': Hello 
'''''nicolas''''': Hi everyone! 
'''''hengsin''''': hi 
'''''tbayen''''': hi :-) 
'''''CarlosRuiz''''': Hi nicolas - how are the babies? 
'''''nicolas''''': fine ! 
'''''nicolas''''': Kind to ask 
'''''mindbender1''''': Hi all 
'''''nicolas''''': They grow very fast 
'''''CarlosRuiz''''': Hi all - as usual - there is no agenda - if somebody wants to bring a theme we can discuss it 
'''''PedroRozo_SmartJ''''': Good morning everyone ... 
'''''PedroRozo_SmartJ''''': first time on board ... 
'''''CarlosRuiz''''': Hi Pedro, glad to have you here 
'''''hengsin''''': carlos, have you review my pull request ? 
'''''PedroRozo_SmartJ''''': thanks for your invitation ... 
'''''CarlosRuiz''''': not yet hengsin - I was not clear if you wanted my peer review or were going to integrate it 
'''''CarlosRuiz''''': but now I'll schedule to review 
'''''hengsin''''': yeah, please do 
'''''red1''''': hi all .. greetings from Malaysia.. 9pm here 
'''''PedroRozo_SmartJ''''': As requested, we created the Jira ticket related with our financial reporting enhancement last week .. hope you guys like it ...we are trying to create our contributions as modular as possible ... 
'''''red1''''': yes PedroRozo_SmartJ if u make it modular enough and independent is more versatile and easier for higher adoption by other forks 
'''''CarlosRuiz''''': I still haven't reviewed it - but I think hengsin did and has some advices? 
'''''red1''''': integrating GWT is very tough., but i enjoy it as i learnt the asynch callback framework last few days 
'''''hengsin''''': I think most of the enhancement looks similar to what's already in print format item. Pedro, correct me if I'm wrong here. 
'''''PedroRozo_SmartJ''''': not sure about it. Red1 ... because we were nto abel to replicate that look & feel .. just with the print format ... 
'''''red1''''': hm in future we should publish some short statement to check if it saves time to reinvent the wheel then? 
'''''hengsin''''': I think the enhancement is good but it is probably more intuitive if it is implemented by adding additional column just for formatting purpose 
'''''hengsin''''': I haven't look at the implementation yet, just my impression from reading the pdf doc 
'''''red1''''': pedro, you used centralised IDs in your module changes to AD? 
'''''PedroRozo_SmartJ''''': not for now .. I have not seen why we need it ... ebcause we have not done structural changes in the AD. in whcih cases we really need those ID's ? when we create new tables ? 
'''''red1''''': or new columns.. 
'''''red1''''': but it can be done easily via exporting thru 2Pack (with Centralised IDs turned on) 
'''''PedroRozo_SmartJ''''': still is not clear to me in which cases we need to use centralized ID´s .. coudl you guys help me a bit with this topic ? 
'''''red1''''': it is to avoid conflict with others IDs during importing your work into theirs 
'''''red1''''': it does not affect you but affect others 
'''''red1''''': anyway there is a complete WIKI on this 
'''''red1''''': "do your homework" :D 
'''''PedroRozo_SmartJ''''': ok, pleae send em the URL .. and I will check it the real concept nehind that topic ... 
'''''red1''''': but u can ask me anytime 
'''''red1''''': not sure if one page or few pages on this.. but googling in the wiki on the topic should get u there 
'''''CarlosRuiz''''': Pedro - I'm reading SmjReport and SMJReportViewer ..... 
'''''mzuniga_ergio''''': hi Pedro 
'''''PedroRozo_SmartJ''''': as I expressed I read the general wiki there but I don´t fully understand if that centrallized id management is just required when you managed new tables in the AD ... 
'''''mzuniga_ergio''''': my business partner Emiliano Pereyra has this funcionality very clear 
'''''PedroRozo_SmartJ''''': hi marcos .. 
'''''mzuniga_ergio''''': and we all speak spanish, I suggest you to ask him for advice ;-) 
'''''red1''''': short answer Pedro = Yes 
'''''CarlosRuiz''''': and now SmjPdfReport .... trying to understand the approach 
'''''CarlosRuiz''''': ok - Pedro, did you add a column called Smj_reportline somewhere - right? 
'''''CarlosRuiz''''': with values T/L/X/Z/D/S 
'''''PedroRozo_SmartJ''''': sure... 
'''''CarlosRuiz''''': that's what red1 is trying to advice 
'''''CarlosRuiz''''': to add columns you can: 
'''''CarlosRuiz''''': a) contribute it as a 2pack - if it's intended to be kept as extension 
'''''CarlosRuiz''''': or b) use centralized ID if is intended to be included in main product 
'''''CarlosRuiz''''': in this case I see your idea is to have it totally as an extension - so a 2pack adding the new dictionary entries will be fine 
'''''PedroRozo_SmartJ''''': ok. taking note ... 
'''''CarlosRuiz''''': adding new columns / fields and as I see probably a process and button 
'''''PedroRozo_SmartJ''''': that will save some lines from the installation step as well... 
'''''CarlosRuiz''''': yes - the idea is that installation is basically - packin + deploy jar 
'''''CarlosRuiz''''': to ease the way for users - of course I'm just advising - you're free to contribute it without 2pack and giving manual installation instructions 
'''''PedroRozo_SmartJ''''': understood, suggestions are welcome for contribution newcomers like us ... 
'''''PedroRozo_SmartJ''''': we wil have that in mind for future releases ... 
'''''PedroRozo_SmartJ''''': changing the topic, red1 mentioned that some people might have questions regarding the recent relase of SmartPOS .... 
'''''PedroRozo_SmartJ''''': I am open to questions if you want ... 
'''''CarlosRuiz''''': Pedro, about IDEMPIERE-196 I would recommend two paths: 
'''''PedroRozo_SmartJ''''': go ahead .. 
'''''hengsin''''': I think LineType should be more intuitive as "Line" and "Text" and we can have additional formatting column for this. for e.g, for text, we can have isunderline, isstrikethrough, indentation, etc 
'''''CarlosRuiz''''': a) if you want it included on product I think we would need a different approach - idea is great, we would need to integrate it in FinReport directly (not easy task) 
'''''CarlosRuiz''''': maybe a "style" usable from FinReport and PrintFormatItem ?? don't know just thinking in draft 
'''''CarlosRuiz''''': b) but as I see your approach of extension fits very properly with the idea of an OSGi extension 
'''''mindbender1''''': I want the application server to pass db connection info to adempiere of the form postgres-adempiere.domain.com/adempiere. How do I generate the connection string as Setup.java doesn't allow specifying db info without port info 
'''''CarlosRuiz''''': so we could also work towards such goal - try to make it an OSGi extension that is deployable in the OSGi container and voila, you have SmartFR installed 
'''''PedroRozo_SmartJ''''': our hoemwork for next weeks is get up-to-speed to the idempeire work .. including OSGi ... I will ahve that in mind as well for sure .. thaks guys for yoru feedback ... 
'''''mindbender1''''': please I need this advice as I am not too sure how else to pass db info to adempiere apart from Adempiere.properties 
'''''hengsin''''': mindbender1, why no port ? 
'''''mindbender1''''': because the domain will resolve the port number correctly and direct the request to postgres server being hosted 
'''''red1''''': dynamic port? 
'''''tbayen''''': mindbender1, it is possible to start a local client with different ADempiere.properties files. Dos this solve your problem? 
'''''mindbender1''''': the domain does not offer external ip for the postgres server and only gives url info 
'''''CarlosRuiz''''': why not port 80 then? 
'''''hengsin''''': what kind of url info ? example ? 
'''''mindbender1''''': something like postgres-adempiere.jelastic.com/adempiere 
'''''hengsin''''': have you try the default postgresql port ? 
'''''mindbender1''''': yes .. it says error 
'''''mindbender1''''': I didn't try carlos advice maybe I should try port 80.. I tried using setup to generate the Adempiere.properties so that I can pass it as jvm options to the adempiere app when the as is starting it 
'''''hengsin''''': postgres-adempiere.jelastic.com/adempiere is the url to the database server or is something else ? 
'''''mindbender1''''': yes 
'''''mindbender1''''': that is the information needed by adempiere to connect along with username and paa 
'''''hengsin''''': that sounds like postgres-adempiere.jelastic.com is the db server hostname and adempiere is the database name ? 
'''''mindbender1''''': yes hengsin 
'''''hengsin''''': ic, in that case you do need to know what's the port to connect :) 
'''''red1''''': is the server for your instance alone? 
'''''mindbender1''''': but setup.java is not designed to accept such 
'''''red1''''': maybe u can modify the properties after setup 
'''''mindbender1''''': yes it's specific to my instance 
'''''red1''''': the PG database is already setup in that server? 
'''''mindbender1''''': red1: that I tried but the info is mungled 
'''''hengsin''''': why not ? isn't just postgres-adempiere.jelastic.com as the db server hostname and adempiere as the database name ? I don't see how's that different from others. 
'''''mindbender1''''': hengsin: because when you omit port setup.java complains 
'''''hengsin''''': Carlos, my idea to evolve the header detail tab implementation - http://jira.idempiere.com/browse/IDEMPIERE-203 , please comments if you can. 
'''''CarlosRuiz''''': mindbender1, can you connect using psql ? 
'''''hengsin''''': mindbender1, you do need to know what port the postgresql server is listening on. 
'''''mindbender1''''': CarlosRuiz: haven't tried psql 
'''''hengsin''''': pgadmin ? 
'''''mindbender1''''': hengsin: I'm about to try port 80 
'''''hengsin''''': ok but it is unlikely that a postgresql server will listen on port 80 
'''''CarlosRuiz''''': my thinking is because probably is a tunnel 
'''''red1''''': yeah if you setup that PG in the server you should be able to get in using PGAdmin 
'''''hengsin''''': Carlos, if it is tunnel, usually should be ssh 
'''''mindbender1''''': port 80 seems to work.. but there are still some errors 
'''''CarlosRuiz''''': hengsin - in IDEMPIERE-203 - is there possible to have multiple details in this case? 
'''''hengsin''''': yes 
'''''hengsin''''': move the tree tab except the first to bottom 
'''''mindbender1''''': Error JDBC Connection: 
'''''mindbender1''''': (Error connecting: jdbc:postgressql://postgres-adempiere.jelastic.com/template1 - postgres/postgres) 
'''''mindbender1''''': err 
'''''mindbender1''''': (Error connecting: jdbc:postgressql://postgres-adempiere.jelastic.com:80/template1 - postgres/postgres) 
'''''PedroRozo_SmartJ''''': time check , I assume there are not questions about SmartPOS .. right ? for me it is ok, we still have the sourceforge forums: https://sourceforge.net/p/smart-pos/discussion/ 
'''''mindbender1''''': port 5432 doesn't connect at all 
'''''hengsin''''': Pedro, SmartPos is OpenBravo ? 
'''''PedroRozo_SmartJ''''': a fork .. with many structural changes .... 
'''''PedroRozo_SmartJ''''': and it works as a slave of the Adempiere ERP .... 
'''''PedroRozo_SmartJ''''': it doens´t work alone .... 
'''''hengsin''''': ic so your guy will maintain the fork independent from openbravo ? 
'''''red1''''': its not standalone pedro? 
'''''PedroRozo_SmartJ''''': at this moemnt yes ... 
'''''mindbender1''''': is there is a way to modify the connection manually I will like to do so. Can I modify Adempiere.properties directly 
'''''PedroRozo_SmartJ''''': pardon .. it doesn´t work without Adempiere ERP .... 
'''''PedroRozo_SmartJ''''': as docuemtned here: https://sourceforge.net/p/smart-pos/wiki/Frequent%20Answers%20%26%20Questions./ 
'''''red1''''': its tightly coupled to the ERP? 
'''''PedroRozo_SmartJ''''': yes ... like master - slave .... 
'''''red1''''': trifon: take note :D 
'''''PedroRozo_SmartJ''''': tehre is no way to create products , taxes and so on in the POS .... 
'''''mzuniga_ergio''''': Pedro I have a question for you 
'''''PedroRozo_SmartJ''''': go ahead ... 
'''''red1''''': mine is that way too but it can function without the ERP been up and online 
'''''mzuniga_ergio''''': we did some improvements on Adempiere JavaPOS 
'''''PedroRozo_SmartJ''''': sure, but you dontñ support multiple UOM and prices .. and sync approach y different I guess ... 
'''''mzuniga_ergio''''': and we are analyzing the best aproach of POS cash closing 
'''''mzuniga_ergio''''': we need to implement at least one cash Journal per POS 
'''''mzuniga_ergio''''': but 
'''''hengsin''''': mindbender1, you wouldn't be able to get it to work using Adempiere.properties directly if setup can't connect 
'''''mzuniga_ergio''''': cash (here in argentina mean caja) so it is not only cash (efectivo) closing 
'''''mzuniga_ergio''''': we need to include all tender types (check, credict cards, etc) in this closing 
'''''mzuniga_ergio''''': how did you manage that in SmartPOS? 
'''''hengsin''''': mzuniga - use bank account as your cash register! 
'''''mindbender1''''': another ting I observed is that setup uses template1 by default how can I adjust this 
'''''PedroRozo_SmartJ''''': we already have support for check, credit card and so on... and you can configure which account bank (ERP) you want to affect in one of the resources ... 
'''''mzuniga_ergio''''': that is a very good aproach but.. 
'''''mindbender1''''': as you can see from the error msg 
'''''mzuniga_ergio''''': but we need to have a "cash closing" for every POS operator and to 
'''''PedroRozo_SmartJ''''': for exampel cash transactions go to 1000002 (internal adempeire ID) bank account ... and so on... just need admin rigths to modify the resource .... 
'''''mindbender1''''': so how can I get access to template1 
'''''mzuniga_ergio''''': add a funcionality that allows you to transfer your daily "chas" to an central administration, 
'''''mzuniga_ergio''''': and register you initial change 
'''''mindbender1''''': the pass is directly modifiable from setup but not the user 
'''''PedroRozo_SmartJ''''': oir you cant configure all your payment forms to the same bank account ..if up to you (your config changes, once you have created the bank accounts in adempiere) ... 
'''''mzuniga_ergio''''': Pedro i understand your aproach, that allows you to transfer and map you transactions 
'''''mzuniga_ergio''''': i meant: your cash transactions 
'''''PedroRozo_SmartJ''''': yes 
'''''mzuniga_ergio''''': i think we will try your aproach but we are going to add to our roadmap 
'''''mzuniga_ergio''''': to develop a cash closing funcionality. 
'''''PedroRozo_SmartJ''''': we have a resource configuration dictionary document: http://sourceforge.net/projects/smart-pos/files/docs/SmartPOSResourcesReferenceV1-0.pdf/download 
'''''mzuniga_ergio''''': thanks you very much Pedro 
'''''hengsin''''': mzuniga - that's just similar to how bank reconc work :) 
'''''hengsin''''': you have a initial balance, cash closing is the initial balance plus all the cash tender type transaction 
'''''mzuniga_ergio''''': you are right hensin... 
'''''mzuniga_ergio''''': but in Argentina people is very used to work with a "cash closing" for user... so we need to add a little "make up" to 
'''''mzuniga_ergio''''': make that look as a familiar funtionality to users 
'''''hengsin''''': yeah, i know additional work needed, just pointing out it is easier to add that than to fix the half baked cash journal stuff 
'''''mzuniga_ergio''''': you are right, this was a very good advice from you and Pedro 
'''''mzuniga_ergio''''': we were almost to start a new funcionality adding some tables and windows 
'''''mindbender1''''': I can't see the code where Setup.java is executing the test button. I only see the code for file and exit.. any thoughts were to look. I need to supply template1 with correct info 
'''''mzuniga_ergio''''': thank you very much 
'''''CarlosRuiz''''': mindbender1, ConfigurationPanel.java 
'''''mindbender1''''': CarlosRuiz: thanks a lot.. I will study it in detail 
'''''CarlosRuiz''''': indeed what you're looking for is ConfigurationData.testDatabase -> ConfigPostgresql.test 
'''''mindbender1''''': ok thanks a lot.. the culprit is public String getSystemUser() 
'''''mindbender1''''': { 
'''''mindbender1''''': return "postgres"; 
'''''mindbender1''''': } // getSystemUser 
'''''red1''''': bbl 
'''''CarlosRuiz''''': c u later guys - thanks for the meeting

IDempiere/FullMeeting20120321 - Revision history

CarlosRuiz: full meeting