jadey

Hello people, What is the latest version of jasperreport which is "java 1.4 compatible" ? Regads.

Hello people, I'm having problems dealing with large reports xls export. I used to get an OutOfMemoryError when generating the JasperPrint and the solution was to use JRSwapFileVirtualizer, and that worked fine for me. My problem now is when I'm trying to export the report as described among other things here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=67 and here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=29673 I was wondering if a solution exists as none of the developpers gived an answer on this issue except of increasing JVM memory. Please help. Best regards.

Hello people, I'm using a JRSwapFileVirtualizer for resolving the problem of running out of memory when generating large reports. As it is used the swap file size continues to increase until it reaches 80,896 kb then i get the following exception stack: [04/04/11 15:10:09:765 GMT] 1676250a JRAbstractLRU E net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer Error devirtualizing object [04/04/11 15:10:09:780 GMT] 1676250a JRAbstractLRU E net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer TRAS0014I: L'exception suivante a été consignée : java.io.IOException: Seek failed at java.io.RandomAccessFile.seek(Native Method) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174) at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code)) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code)) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182) at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72) at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) . java.io.IOException: Seek failed at java.io.RandomAccessFile.seek(Native Method) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174) at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code)) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code)) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182) at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72) at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) [04/04/11 15:10:09:796 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource org/apache/struts/action/ActionResources_fr_FR.properties Not Found. [04/04/11 15:10:09:796 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource org/apache/struts/action/ActionResources_fr.properties Not Found. [04/04/11 15:10:09:858 GMT] 1676250a RequestProces W org.apache.struts.action.RequestProcessor Unhandled Exception thrown: class net.sf.jasperreports.engine.JRRuntimeException [04/04/11 15:10:09:858 GMT] 1676250a WebGroup E SRVE0026E: [Erreur de servlet]-[java.io.IOException: Seek failed]: net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: Seek failed at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code)) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code)) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182) at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72) at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) Caused by: java.io.IOException: Seek failed at java.io.RandomAccessFile.seek(Native Method) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190) at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174) at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106) ... 39 more [04/04/11 15:10:09:905 GMT] 1676250a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/penalitesLayout.jsp: init [04/04/11 15:10:10:046 GMT] 1676250a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/header.jsp: init [04/04/11 15:10:10:077 GMT] 1676250a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/quitPopup.jsp: init [04/04/11 15:10:10:187 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/facturation/ressources/ApplicationRessources_fr.properties Not Found. [04/04/11 15:10:10:218 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/common/struts/resources/labelScreen_fr.properties Not Found. [04/04/11 15:10:10:280 GMT] 1676250a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/httpServerError.jsp: init [04/04/11 15:10:10:483 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/common/struts/resources/erreurs_fr.properties Not Found. [04/04/11 15:10:10:483 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/common/struts/resources/commonMessages_fr.properties Not Found. [04/04/11 15:10:10:546 GMT] 1676250a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/footer.jsp: init [04/04/11 15:10:17:015 GMT] 73ae508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /index.jsp: init [04/04/11 15:10:17:218 GMT] 73ae508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/user/sayHello.jsp: init [04/04/11 15:10:17:452 GMT] 73ae508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/DAF/extractionEtatRecap.jsp: init [04/04/11 15:10:55:265 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: InvokerServlet: destroy [04/04/11 15:10:55:265 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: SimpleFileServlet: destroy [04/04/11 15:10:55:265 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: JSP 1.2 Processor: destroy [04/04/11 15:10:55:937 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: JSP 1.2 Processor: init [04/04/11 15:10:56:296 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: FormLoginServlet: init [04/04/11 15:10:56:312 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: FormLogoutServlet: init [04/04/11 15:10:56:312 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: SimpleFileServlet: init [04/04/11 15:10:56:312 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: InvokerServlet: init [04/04/11 15:10:56:327 GMT] 38cce508 WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: action: init [04/04/11 15:10:56:608 GMT] 38cce508 ActionServlet I org.apache.struts.action.ActionServlet Loading chain catalog from wsjar:file:/D:/work in progress/appli/all sources/PROD/JAVA/facturation/FacturationWeb/WebContent/WEB-INF/lib/struts-core-1.3.10.jar!/org/apache/struts/chain/chain-config.xml [04/04/11 15:10:57:577 GMT] 38cce508 TilesPlugin I org.apache.struts.tiles.TilesPlugin Tiles definition factory loaded for module ''. [04/04/11 15:42:02:864 GMT] a27e50a TilesRequestP I org.apache.struts.tiles.TilesRequestProcessor Tiles definition factory found for request processor ''. [04/04/11 15:42:02:896 GMT] a27e50a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/penalitesLayout.jsp: init [04/04/11 15:42:02:927 GMT] a27e50a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/header.jsp: init [04/04/11 15:42:02:974 GMT] a27e50a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/quitPopup.jsp: init [04/04/11 15:42:03:067 GMT] a27e50a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/facturation/ressources/ApplicationRessources_fr.properties Not Found. [04/04/11 15:42:03:083 GMT] a27e50a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/common/struts/resources/labelScreen_fr.properties Not Found. [04/04/11 15:42:03:114 GMT] a27e50a PropertyMessa W org.apache.struts.util.PropertyMessageResources Resource com/maroclear/common/struts/resources/commonMessages_fr.properties Not Found. [04/04/11 15:42:03:161 GMT] a27e50a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/admin/onDemandProdReport.jsp: init [04/04/11 15:42:03:567 GMT] a27e50a WebGroup I SRVE0180I: [FacturationWeb] [/FacturationWeb] [servlet.LOG]: /jsp/nonAuthUser/footer.jsp: init Can anyone help me? Thank you all for your contributions.

For those who might be affected by this issue. The problem actually comes from the variable <<Ignore pagination>> set to TRUE, which was on my reports, and the fact is that I export to XLS format. I guess jasperreport interpreted the data on a single page and continued to write in memory instead of using the swap file. I now find myself with another issue. Who will be on a new post.

Help me pealse ! :)

Any help would by appreciated. /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

Hi there, An excellent post mentions the possibility of using virtualization for resolving the problem of running out of memory when generating large reports. So I modified my code slightly in order to implement this solution. But i did not really feel that this file is used because it is created and remains at 0 kb until the application crashes with a nasty OutOfMemoryError. I like to know why. Thank you all for your contributions. Code: Post Edited by jadey at 03/30/2011 16:02

Add the No Data Band and fill it with your header

Go to your report properties and change the "when no data" to "No Data Section"

Hello people; I have reports where requests ("where") must be dynamic. I would write something like: select t.champ from table t where t.TRADEDATE <= case when $P{datedeb} is null then a.TRADEDATE else $P{datedeb} end but it doesn't work while select t.champ from table t where t.TRADEDATE <= case when $P{datedeb} ='01/01/3000' then a.TRADEDATE else $P{datedeb} end works fine. In short, if a parameter is the an empty string or null then not integrate them as conditions on the "where"I saw that it is permitted to use an object of type "JRDesignQuery" to build the request in java. Two pitfalls for this method: 1 - Forced to recompile each time the report (I've been using the compiled .jasper reports)2 - The real pitfalls: I have a lot of reports and the requests are enormous. It would quickly become unmanageable if report request are in java side. There's also another possibility to pass the request as a parameter to the report. This solution has the same constraints, and is similar in all points to the first. If someone has a solution to propose to me I shall be grateful to him.Thank you for all your contributions.

Hello people I have a report (from the template "coffee" v 3.6.0) which takes its data from a csv file with. But Header Group dont behave the way it should. If anybody can can help, try and explain whether the report behave normaly or not ? Here is the csv file: sample.csv Here is the file jrxml: sample.jrxml Here are Fields that the cvs file contains: SENS;COL1;COL2;ID;COL4;IDFILE;COL6;COL7;COL8;COL9;COL10;COL11;COL12;HEURE;MIN;SEC;MILLSEC;COL17;COL18;COL19;COL20;COL21;COL22;COL23;COL24;NFNAME;COL26;COL27[/code]