#idempiere IRC log for Wednesday, 2017-06-14

Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25200:22
Not-6102[IDEMPIERE] Hi, i have tested this ticket to export a Excel file from iDempiere and worked fine for me, please if somebody can test would be great. Thanks00:22
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25200:22
*** silphium has joined #idempiere00:23
Not-6102[IDEMPIERE] huangsavin created IDEMPIERE-3395 ReportStarter.java cannot export xls report00:53
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339500:53
Not-6102[IDEMPIERE] huangsavin updated IDEMPIERE-3395 Attachment set to "369661057245134721.jpg"00:54
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339500:54
Not-6102[IDEMPIERE] huangsavin updated IDEMPIERE-3395 Attachment set to "1497401642(1).jpg"00:54
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339500:54
Not-6102[IDEMPIERE] huangsavin updated IDEMPIERE-339500:57
Not-6102[IDEMPIERE] While I add the code: export.setConfiguration(config); it runs OK.00:57
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339500:57
Not-6102[IDEMPIERE] huangsavin updated IDEMPIERE-3395 Attachment set to "None"00:59
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339500:59
*** a42niem has joined #idempiere04:25
Not-6102[iDempiere4.1Daily] jenkins built #75 completed (success) http://ci.idempiere.org/job/iDempiere4.1Daily/75/04:40
*** nmicoud has joined #idempiere05:10
*** nmicoud has quit IRC06:32
*** nmicoud has joined #idempiere06:40
Not-6102[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/06:43
Not-6102[iDempiere] hengsin 23d0efc - IDEMPIERE-3350 Accounting Processor GL postings to "secondary" schema unreliable. Context for AcctProcessor not always setup correctly.06:43
Not-6102[IDEMPIERE] hengsin updated IDEMPIERE-335006:45
Not-6102[IDEMPIERE] Found yet another issue: https://bitbucket.org/idempiere/idempiere/commits/23d0efc Need to ensure the context for AcctProcessor is setup for each run.06:45
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-335006:45
Not-6102[IDEMPIERE] anozimada created IDEMPIERE-3396 Performance Issue in Process' Saved Parameter06:58
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339606:58
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-3396 Attachment set to "IDEMPIERE-3396.patch"07:00
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339607:00
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-3396 labels set to "+Patch"07:00
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339607:00
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-3396 status set to "Peer Review Queue"07:00
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339607:00
Not-6102[iDempiere4.1] jenkins built #119 completed (success) http://ci.idempiere.org/job/iDempiere4.1/119/07:03
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-339607:08
Not-6102[IDEMPIERE] Note in attached patch I construct the X rows at sql string because you can't use it as parameter. Also FETCH FIRST X ROWS ONLY is ANSI SQL but I just test it at postgresql, if someone have oracle instance installed please test it, thanks.07:08
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339607:08
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-339607:10
Not-6102[IDEMPIERE] Note in attached patch I construct the X rows at sql string because you can't use it as parameter. Also FETCH FIRST X ROWS ONLY is ANSI SQL but I only test it at postgresql, if someone have oracle instance installed please test it, thanks.07:10
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339607:10
Not-6102[IDEMPIERE] anozimada updated IDEMPIERE-3392 status set to "Peer Review Queue"07:10
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339207:10
*** a42niem has quit IRC07:25
Not-6102[IDEMPIERE] soo.fang@gmail.com created IDEMPIERE-3397 Matched PO post wrong amount to PPV account for products with costing method=Standard Costing08:18
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339708:18
Not-6102[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±3] https://bitbucket.org/idempiere/idempiere/commits/09:24
Not-6102[iDempiere] hengsin 7725a79 - IDEMPIERE-3350 Accounting Processor GL postings to "secondary" schema unreliable. MAcctSchema.isSkipOrgs should always check the full org tree.09:24
Not-6102[iDempiere4.1] jenkins built #120 completed (success) http://ci.idempiere.org/job/iDempiere4.1/120/09:33
*** gibs has joined #idempiere10:10
Not-6102[iDempiere] CarlosRuiz_globalqss pushed 1 commit to development [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/10:37
Not-6102[iDempiere] globalqss b8434ba - Committing patch sent by druiz - although not used in iDempiere - as a reference in case somebody wants to implement a process with BatchLogin - adapting the batchlogin to the new iDempiere structure (client->role instead of previous role->client)10:37
Not-6102[iDempiere] jenkins built #1841 completed (success) http://ci.idempiere.org/job/iDempiere/1841/10:44
*** aguerra has joined #idempiere10:55
Not-6102[iDempiere] CarlosRuiz_globalqss pushed 1 commit to development [+4/-0/±43] https://bitbucket.org/idempiere/idempiere/commits/11:10
Not-6102[iDempiere] globalqss 6804e3f - hg merge release-4.1 (merge release4.1 into development)11:10
*** gibs has quit IRC11:15
Not-6102[iDempiere] jenkins built #1842 completed (success) http://ci.idempiere.org/job/iDempiere/1842/11:17
*** CarlosRuiz has joined #idempiere12:30
Not-6102[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-252 status set to "Reopened" -assignee set to "Orlando Curieles" -resolution set to "None"12:34
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25212:34
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-252 Attachment set to "ZkJRViewer.patch"12:35
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25212:35
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25212:35
Not-6102[IDEMPIERE] @carlosruiz_globalqss this is my path. [^ZkJRViewer.patch]12:35
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25212:35
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25212:35
Not-6102[IDEMPIERE] @carlosruiz_globalqss this is my patch. [^ZkJRViewer.patch]12:35
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25212:35
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25212:37
Not-6102[IDEMPIERE] This is my Excel generated [^Mayor Analítico Excel Idempiere.xls]12:37
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25212:37
Not-6102[IDEMPIERE] hahmed updated IDEMPIERE-25213:08
Not-6102[IDEMPIERE] If you read the comments above, you can see that the recommended strategy for customizing Jasper properties would be to use jasperreports.properties. The file can be deployed using the same process used to deploy jasper fonts (check the org.adempiere.report.jasper.fonts plugin in source)13:08
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25213:08
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25213:21
Not-6102[IDEMPIERE] hi, you think somebody need a excel file with a white page background ? i think a good practice would be make configurable, but a excel file without this parameters is unusable net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true net.sf.jasperreports.export.xls.detect.cell.type=true13:21
Not-6102net.sf.jasperreports.export.xls.ignore.cell.background=true net.sf.jasperreports.export.xls.ignore.graphics=true net.sf.jasperreports.export.xls.collapse.row.span=true net.sf.jasperreports.export.xls.white.page.background=false13:21
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25213:21
Not-6102[IDEMPIERE] hahmed updated IDEMPIERE-25213:42
Not-6102[IDEMPIERE] Almost everyone using Jasper I know is creating a template report with all the parameters set and using it to create their reports. These changes can be applied per report basis or per server basis (using plugin) without any difficulty and since we are not changing jasper properties in code for anything else, IMO it would be better to keep it as a report developer configurable option. In any case,13:42
Not-6102creation of a jasper report is not an end-user task but a report developer task, who should be familiar with jasper properties and be able to set them per report. It would be more sensible if the reports act in iDempiere exactly the same way they act in Jaspersoft Studio, which will not be the case if we change jasper properties defaults in iDempiere.13:42
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25213:42
Not-6102[IDEMPIERE] orlando.curieles updated IDEMPIERE-25214:44
Not-6102[IDEMPIERE] @hahmed i have maked the changes on my report, i know how make this, but idempiere don't take this changes, why ? or how exactly you are doing that ?14:44
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25214:44
*** nmicoud has quit IRC15:09
*** a42niem has joined #idempiere15:47
Not-6102[IDEMPIERE] hahmed updated IDEMPIERE-252 Attachment set to "Screenshot from 2017-06-14 19-32-16.png"16:37
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25216:37
Not-6102[IDEMPIERE] hahmed updated IDEMPIERE-25216:37
Not-6102[IDEMPIERE] If you're using Jaspersoft Studio then click at the report name, then on the properties tab click "Advanced" and expand "Misc" there you will find properties. Attaching the screenshot with white page background property set to false for XLS export, verified to work in iDempiere as well. !Screenshot from 2017-06-14 19-32-16.png|thumbnail!16:37
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-25216:37
*** victorsuarez has joined #idempiere16:47
Not-6102[IDEMPIERE] hieplq created IDEMPIERE-3398 default "Payment Term" record of new client miss translate19:56
Not-6102[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-339819:56
*** CarlosRuiz has quit IRC20:39
*** a42niem has quit IRC21:23
*** aguerra has quit IRC22:24

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