CarlosRuiz: full meeting

2013-06-05T16:24:56Z

full meeting

New page

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


'''''tbayen_''''': Hi xolali! ;-) Whats Up? 
'''''xolali''''': Haloo Thomas 
'''''tbayen''''': I installed your present for todays meeting. :-) Look into my facebook. 
'''''CarlosRuiz''''': :-) I want a mug like that :-) 
'''''tbayen''''': It brand new. Just got it from the store. I was so proud I had to take a photo. 
'''''xolali''''': wow, ok 
'''''PedroRozo''''': good morning team ..... 
'''''CarlosRuiz''''': Good morning 
'''''tbayen''''': I will bring one if I visit you and we will fill it with Eierlikör. 
'''''nmicoud''''': Bonjour 
'''''CarlosRuiz''''': gr8 
'''''a42niem''''': guten tag 
'''''Deepak''''': Good morning/Evening 
'''''tbayen''''': Daarestiet 
'''''xolali''''': Thomas the cups were not ready for the conference 
'''''xolali''''': i need one too, i mean the mug 
'''''CarlosRuiz''''': nmicoud, Richard posted a patch for the IDEMPIERE-950 - will try it 
'''''CarlosRuiz''''': I didn't understand your comment on that ticket :-( 
'''''nmicoud''''': let me check 
'''''tbayen''''': Someone asked me to help him with manufacturing. He needs only a small bom and wants to have inventory for raw materials and finished products. Does this work with idempiere? It seems to me that there are so many different ways of adempiere manufacturing. Is the idempiere menu still the compiere functionality? Where do I find the right documentation? 
'''''nmicoud''''': Richard upload a 1st patch yesterday and i've seen that he tested if tree.getTreecols() was null to create new Treecols 
'''''CarlosRuiz''''': ah - your comment is about Richard's patch - that's why I didn't find it in code :-) thanks - will check it 
'''''nmicoud''''': yes 
'''''CarlosRuiz''''': tbayen, yes, bom and inventories are ok out of the box 
'''''nmicoud''''': it omit to precise it 
'''''nmicoud''''': and for ticket 950 ; wondering what will be the result if we put a tree on the BPartner tab of BP Group window 
'''''CarlosRuiz''''': the mfg light howto from adaxa is helpful as documentation 
'''''nmicoud''''': Will the tree be reloaded when changing groups ? 
'''''CarlosRuiz''''': good test case 
'''''nmicoud''''': i think the reloading should be done when ad_tree_id or the parent link column change 
'''''CarlosRuiz''''': I advised Richard to follow same swing approach 
'''''nmicoud''''': ok 
'''''CarlosRuiz''''': but haven't checked if he did :-) 
'''''nmicoud''''': :)) 
'''''CarlosRuiz''''': your suggested test on bp group working fine 
'''''nmicoud''''': ah great ! 
'''''tbayen''''': CarlosRuiz, thanks for giving me a direction in the manufacturing jungle. :-) 
'''''CarlosRuiz''''': but -as you imagined - is reloading the tree when is not needed :-) 
'''''nmicoud''''': maybe we could store the current tree_id and compare it with the new 
'''''nmicoud''''': and if different, reload 
'''''CarlosRuiz''''': nmicoud, question 
'''''CarlosRuiz''''': not challenging your advise - just want to understand it 
'''''CarlosRuiz''''': why do you think is better to detach the treecols and create them new? 
'''''nmicoud''''': i have no idea ; i just search where this kind of thing was done. And i've find WTreeMaintenance (which reload trees, when you change the selected item from a listbox). And it is done this way 
'''''CarlosRuiz''''': ah - I see - thanks for pointing me there 
'''''nmicoud''''': it seems there is at least 2 way of doing the same thing. But can't say what is the best 
'''''nmicoud''''': Is anyone is familiar with JasperReports in iDempiere. If so, can you please have a look here: https://groups.google.com/forum/#!topic/idempiere/YXZVLT9GX1c 
'''''tbayen''''': I played with Jasper one year ago in adempiere. It is not easy to insert external files like images and subreports. Every handler (file, attachment, classpath, etc.) has a slightly different implementation and different filename mappings. To be sure you have to read the source how it deals with this. This is on my list of things I want to recreate when there is time. 
'''''xolali''''': i use jasper reports a lot 
'''''CarlosRuiz''''': but nmicoud - your error sounds like your jasper image url is pointing to your drive 
'''''xolali''''': my prefered deployment is to place all files under a directory called reports 
'''''nmicoud''''': i agree, but i can't find any reference to my local drive 
'''''xolali''''': u could have place images in a sub-folder images and it works, 
'''''tbayen''''': I did not use http, but your file is searched in "temp". In the classpath handler all needed files were to be copied to tmp before starting jasper. Because the JasperReport class could not know which files are needed it copied only some standard filenames like "*_subreport1.jasper" and such. I could not manage to load images with that. 
'''''tbayen''''': I used images but I had to read them from the database, not the classpath. 
'''''nmicoud''''': after some debug i found that the resourcePath is set C:\Users\Nico\AppData\Local\Temp/ 
'''''xolali''''': Thomas maybe you should try a simpler way of deployment 
'''''nmicoud''''': But the JasperReport field in AD_Process is http://localhost:8080/JasperReportFiles/test.jrxml 
'''''tbayen''''': All files are first copied to temp and then the jasper library is called. The problem is that adempiere does not know what "all files" should be. 
'''''nmicoud''''': on adempiere, there was a jasperReport.war which contains 'all files' ; right ? 
'''''nmicoud''''': this is no more available ? 
'''''xolali''''': nmicoud in adempiere there are about four different ways of deploying 
'''''CarlosRuiz''''': yes, I think the war approach is what hengsin talked on the forum thread 
'''''tbayen''''': No. adempiere does not know what to copy from the *.war. The problem I talk of is with the classpath. If you use file urls it should work. I believe xolali uses file urls??? 
'''''nmicoud''''': he talked of a fragment which contains resources 
'''''nmicoud''''': but he don't mention images 
'''''xolali''''': the good thing about using the folder approach is that once it works fine and load resources in iReport, it WILL work in adempiere/idempiere 
'''''tbayen''''': The Jasper Library can not deal with four different wys of deploying. This is the invention of adempiere. And it does it with some (file) in a "natural" way and gives jasper the url and with some (classpath) by first copying everything to temp and then giving hjasper the temp url. 
'''''nmicoud''''': xolali, when you mention folder approach, it is put jrxml and image on the same folder ? 
'''''xolali''''': yes, either in same folder or in sub-folder. you just have to use relative path the way its done in html 
'''''xolali''''': to point to you resource 
'''''nmicoud''''': just wondering if idempiere looks for local because it is tested from Eclipse 
'''''nmicoud''''': will try to deploy it to an running idempiere instance 
'''''xolali''''': yes it looks for the reports folder from the adempiere_home which will be your development home or your deployment home 
'''''nmicoud''''': ok thanks 
'''''xolali''''': when i run from eclipse, it looks in my development home for the folder reports 
'''''nmicoud''''': so i need to copy the resources (images, subreports...) in this directory 
'''''tbayen''''': I just looked into the actual source. It seems like its the same I looked into last year. 
'''''xolali''''': yes. all reports and resources should be in that folder 
'''''tbayen''''': If you can use local folders it will work best with images. If not my best approach was to get images from the database. 
'''''Edwin_Ang''''': hi everyone 
'''''xolali''''': this way you can change reports anytime without creating and uploading a new WAR each time 
'''''CarlosRuiz''''': attachment approach sounds easy too - that's the one I tested 
'''''CarlosRuiz''''': Hi Edwin_Ang 
'''''nmicoud''''': ok, will also try the attachment way 
'''''Edwin_Ang''''': hi CarlosRuiz 
'''''Edwin_Ang''''': what is this? jasper report deployment? 
'''''tbayen''''': CarlosRuiz, Are you sure that you can use images from an attachment? (I mean: images attached in the same space like the report itself?) 
'''''CarlosRuiz''''': yes - subreports and images - is just to attach them also besides the main report 
'''''CarlosRuiz''''': the test I use to play in demo has two images 
'''''nmicoud''''': Hi Edwin, yep, i'm struggling with jasper report deployment :) 
'''''tbayen''''': Hmmm... have to dig the source to understand that better. 
'''''Edwin_Ang''''': hi nicolas.. well.. that's also on my pending list :) 
'''''nmicoud''''': i guess we all share the same list :) 
'''''Edwin_Ang''''': haven't been able to run report using the fragment project way 
'''''xolali''''': Carlos does that mean i have to attach the logo each time for the report or i can attach it somewhere once 
'''''CarlosRuiz''''': on the process window - you attach the main report and the images 
'''''Edwin_Ang''''': any idea how to use amtinwords? 
'''''CarlosRuiz''''': let me create one on demo to show you how ... 
'''''CarlosRuiz''''': ah - seems like demo is down 
'''''tbayen''''': Ah! "attachment:" urls work with jrxml, jasper, jpg and png files. These are all copied. With classpaths urls does not work because the first stage can not do a directory listing to identify them. 
'''''tbayen''''': To be short: Attachments should also work with subreports and jpg and png. 
'''''xolali''''': Carlos whilst we are on jasper reports, there are some issues with the table componet in jasper library 4.6 
'''''xolali''''': so i upgraded to version 5.1 and it works fine 
'''''tbayen''''': xolali, could you contribute this upgrade? 
'''''xolali''''': Yes, but i just updated the jar files and the manifest accordingly no code changes. I dont know which to contribute, manifest?? 
'''''xolali''''': i have actually opened a ticket in jira 
'''''xolali''''': http://jira.idempiere.com/browse/IDEMPIERE-1019 
'''''CarlosRuiz''''': xolali - usually upgrading jasper implies upgrading barbecue and other libraries 
'''''CarlosRuiz''''': and sometimes it has implications on other projects 
'''''CarlosRuiz''''': probably with OSGi we can isolate it now - not sure if it's done 
'''''tbayen''''': I think you should only update the manifest. Then it should be buckminsters task to get the right jarfile. I believe the upgrading user has to start buckminster somehow. I never tried that. Would be nice to have this documented. 
'''''tbayen''''': CarlosRuiz, if this is not isolated I don't know what all the OSGi work was for. ;-) 
'''''xolali''''': Yes i guess OSGi handles this because jasper is a seperate bundle, so far am runing my eclipse with the new jars and it looks good 
'''''tbayen''''': The dependend libs like barbecue should be upgraded but only in the jasper plugin. 
'''''CarlosRuiz''''': yes - seems like org.adempiere.report.jasper.library do the trick 
'''''CarlosRuiz''''': xolali - you won't notice the problem with not upgrading some libraries if you don't use it on your reports 
'''''CarlosRuiz''''': for example barcodes 
'''''tbayen''''': I think buckminster will solve all these dependencies the right way if you use it. Exchanging a jar file by hand seems a no-go. Am I right? 
'''''CarlosRuiz''''': it depends how you configure it 
'''''CarlosRuiz''''': barcode4j-2.0.jar is on org.adempiere.report.jasper.library - not downloaded on the fly 
'''''CarlosRuiz''''': org.apache.poi also represents a dependency on jasper - you'll notice if you export a report to excel 
'''''xolali''''': ok is there a way i could test this, because i think the upgrade is necessary because of the issues with has been solved in subsequent versions 
'''''CarlosRuiz''''': sure xolali - keeping up to date with jasper is important - and as tbayen said - it will be good to have documentation about how to do that and what to test 
'''''CarlosRuiz''''': I think somewhere in adempiere forums we talked about the libraries involved 
'''''xolali''''': ok i'll check this and come up with some wrtite up 
'''''Edwin_Ang''''': CarlosRuiz: i tried to develop a window similar with Account Element.. but then some class in the core like TreeMaintenance need to be modified 
'''''xolali''''': write up 
'''''Edwin_Ang''''': any idea how to extend them to a custom plugin? 
'''''tbayen''''': This should all be documented on the jasper website. Important is to see whether all the dependencies are resolved the right way. It seems that some are automatic and some are fixed in the trunk. 
'''''CarlosRuiz''''': Edwin_Ang, window similar to? 
'''''CarlosRuiz''''': demo was updated and restarted 
'''''Edwin_Ang''''': Account Element 
'''''Edwin_Ang''''': i need to have a tree with a parent tab 
'''''CarlosRuiz''''': if somebody wants to help checking memory problems there are two heaps captured: 
'''''CarlosRuiz''''': https://demo.idempiere.com:8443/idempiereMonitor?Trace=/opt/idempiere-server/log/java_pid3946.hprof.tbz 
'''''CarlosRuiz''''': https://demo.idempiere.com:8443/idempiereMonitor?Trace=/opt/idempiere-server/log/java_pid10281.hprof.tbz 
'''''CarlosRuiz''''': Edwin_Ang, we were talking about that at the start of the meeting 
'''''CarlosRuiz''''': testing the patch of IDEMPIERE-950 
'''''Edwin_Ang''''': ah.. any place i can see the log? 
'''''CarlosRuiz''''': not too much - just said that I was testing it and Nicolas explaining me his comment 
'''''Edwin_Ang''''': you mean IDEMPIERE-950? 
'''''CarlosRuiz''''': yep 
'''''Edwin_Ang''''': well.. i actually talking about how can i create a custom tree like C_ElementValue 
'''''Edwin_Ang''''': i am trying to develop window Project WBS (Work Breakdown Structure) 
'''''tbayen''''': gtg, thanks! 
'''''Edwin_Ang''''': i intend to have Project as the top tab 
'''''CarlosRuiz''''': bye tbayen 
'''''Edwin_Ang''''': and project activity as the child tab.. the project activity tab should have a tree.. 
'''''CarlosRuiz''''': do you mean you want to implement generic trees - the ability to create a tree on any table 
'''''Edwin_Ang''''': yepp 
'''''CarlosRuiz''''': ah ok - I think that was done on compiere - maybe you can take a look to their approach 
'''''Edwin_Ang''''': can i access their code? 
'''''CarlosRuiz''''': I downloaded 330 
'''''CarlosRuiz''''': to access latest I think you need to sign up and they're being picky :-) 
'''''nmicoud''''': Coming back to Jasper... i've added this line in ReportStarter : params.put("RESOURCE_DIR_1", reportPath.substring(0, reportPath.lastIndexOf("/")) + "/"); Then in my report, i set the image expression as $P{RESOURCE_DIR_1} + "Header.jpg". And it works fine ! It doesn't look anymore on the local drive 
'''''CarlosRuiz''''': good 
'''''nmicoud''''': Should i provide a patch ? i think it is useful 
'''''CarlosRuiz''''': didn't RESOURCE_DIR work? 
'''''nmicoud''''': nope, RESOURCE_DIR point to my local drive 
'''''nmicoud''''': from Eclipse and idempiere 
'''''nmicoud''''': That's why i search for creating a new one 
'''''CarlosRuiz''''': ok - Juan just found a problem testing IDEMPIERE-950 - so we'll hold it until solved 
'''''nmicoud''''': what problem ? 
'''''CarlosRuiz''''': if the tree is empty and you navigate to another element with tree - is messed up 
'''''nmicoud''''': i see 
'''''CarlosRuiz''''': Edwin_Ang, sources of compiere 330 are here http://sourceforge.net/projects/compiere/files/Compiere/R3.3.0/ 
'''''Edwin_Ang''''': ah.. thx 
'''''Edwin_Ang''''': i registered but nothing happens yet 
'''''CarlosRuiz''''': ah, if they read this minutes they'll reject your application - hehehe 
'''''CarlosRuiz''''': strange open source 
'''''Edwin_Ang''''': 330 has code for the generic tree? 
'''''CarlosRuiz''''': yes - I think so 
'''''CarlosRuiz''''': nmicoud, instead of RESOURCE_DIR_1 maybe call that REPORT_DIR ? 
'''''CarlosRuiz''''': and it just works for http or file 
'''''nmicoud''''': yes 
'''''nmicoud''''': i've only try with img 
'''''CarlosRuiz''''': and maybe you need to check also if is windows ending with \\ 
'''''nmicoud''''': something like line 421 of REportStarter ? 
'''''CarlosRuiz''''': yep - tricky when file separator is \\ 
'''''nmicoud''''': ok, i'll do this 
'''''nmicoud''''': i'll upload a patch tonight or tomorrow ; will have to go soon 
'''''CarlosRuiz''''': thanks 
'''''nmicoud''''': While working on trees, i noticed http://jira.idempiere.com/browse/IDEMPIERE-1016. Seems that is related to http://jira.idempiere.com/browse/IDEMPIERE-1015 
'''''nmicoud''''': i think this has bee n introduced recently 
'''''CarlosRuiz''''': :-) didn't notice - thanks for reporting 
'''''nmicoud''''': :) cu 
'''''CarlosRuiz''''': bye nicolas 
'''''Edwin_Ang''''': got to go now 
'''''CarlosRuiz''''': thanks Edwin_Ang - bye 
'''''Edwin_Ang''''': CarlosRuiz: thx for the hint 
'''''Edwin_Ang''''': bye :) 
'''''xolali''''': bye everybody

IDempiere/FullMeeting20130605 - Revision history

CarlosRuiz: full meeting