Examples of JRCsvDataSource

net.sf.jasperreports.engine.data.JRCsvDataSource
This datasource implementation reads a CSV stream. Datasource rows are separated by a record delimiter string and fields inside a row are separated by a field delimiter character. Fields containing delimiter characters can be placed inside quotes. If fields contain quotes themselves, these are duplicated (example: "John ""Doe""" will be displayed as John "Doe").
Since CSV does not specify column names, the default naming convention is to name report fields COLUMN_x and map each column with the field found at index x in each row (these indices start with 0). To avoid this situation, users can either specify a collection of column names or set a flag to read the column names from the first row of the CSV file. @author Ionut Nedelcu (ionutned@users.sourceforge.net) @version $Id: JRCsvDataSource.java 4225 2011-03-03 12:06:38Z shertage $

Examples of net.sf.jasperreports.engine.data.JRCsvDataSource

429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529    */ public static final void putDataSources(Map parameters) throws JRException {     try     {       JRCsvDataSource cds1 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds1.setRecordDelimiter("\r\n");       cds1.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource1", cds1);             JRCsvDataSource cds2 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds2.setRecordDelimiter("\r\n");       cds2.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource2", cds2);             JRCsvDataSource cds3 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds3.setRecordDelimiter("\r\n");       cds3.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource3", cds3);             JRCsvDataSource cds4 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds4.setRecordDelimiter("\r\n");       cds4.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource4", cds4);             JRCsvDataSource cds5 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds5.setRecordDelimiter("\r\n");       cds5.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource5", cds5);             JRCsvDataSource cds6 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds6.setRecordDelimiter("\r\n");       cds6.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource6", cds6);             JRCsvDataSource cds7 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/categoryDatasource.csv"), "UTF-8");       cds7.setRecordDelimiter("\r\n");       cds7.setUseFirstRowAsHeader(true);       parameters.put("categoryDatasource7", cds7);             JRCsvDataSource pds1 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/pieDatasource.csv"), "UTF-8");       pds1.setRecordDelimiter("\r\n");       pds1.setUseFirstRowAsHeader(true);       parameters.put("pieDatasource1", pds1);             JRCsvDataSource pds2 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/pieDatasource.csv"), "UTF-8");       pds2.setRecordDelimiter("\r\n");       pds2.setUseFirstRowAsHeader(true);       parameters.put("pieDatasource2", pds2);             JRCsvDataSource tpds1 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/timePeriodDatasource.csv"), "UTF-8");       tpds1.setRecordDelimiter("\r\n");       tpds1.setUseFirstRowAsHeader(true);       parameters.put("timePeriodDatasource1", tpds1);             JRCsvDataSource tsds1 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/timeSeriesDatasource.csv"), "UTF-8");       tsds1.setRecordDelimiter("\r\n");       tsds1.setUseFirstRowAsHeader(true);       tsds1.setDateFormat(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"));       parameters.put("timeSeriesDatasource1", tsds1);             JRCsvDataSource tsds2 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/timeSeriesDatasource.csv"), "UTF-8");       tsds2.setRecordDelimiter("\r\n");       tsds2.setUseFirstRowAsHeader(true);       tsds2.setDateFormat(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"));       parameters.put("timeSeriesDatasource2", tsds2);             JRCsvDataSource tsds3 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/timeSeriesDatasource.csv"), "UTF-8");       tsds3.setRecordDelimiter("\r\n");       tsds3.setUseFirstRowAsHeader(true);       tsds3.setDateFormat(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"));       parameters.put("timeSeriesDatasource3", tsds3);             JRCsvDataSource xyds1 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/xyDatasource.csv"), "UTF-8");       xyds1.setRecordDelimiter("\r\n");       xyds1.setUseFirstRowAsHeader(true);       parameters.put("xyDatasource1", xyds1);             JRCsvDataSource xyds2 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/xyDatasource.csv"), "UTF-8");       xyds2.setRecordDelimiter("\r\n");       xyds2.setUseFirstRowAsHeader(true);       parameters.put("xyDatasource2", xyds2);             JRCsvDataSource xyds3 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/xyDatasource.csv"), "UTF-8");       xyds3.setRecordDelimiter("\r\n");       xyds3.setUseFirstRowAsHeader(true);       parameters.put("xyDatasource3", xyds3);             JRCsvDataSource xyds4 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/xyDatasource.csv"), "UTF-8");       xyds4.setRecordDelimiter("\r\n");       xyds4.setUseFirstRowAsHeader(true);       parameters.put("xyDatasource4", xyds4);             JRCsvDataSource xyds5 = new JRCsvDataSource(JRLoader.getLocationInputStream("data/xyDatasource.csv"), "UTF-8");       xyds5.setRecordDelimiter("\r\n");       xyds5.setUseFirstRowAsHeader(true);       parameters.put("xyDatasource5", xyds5);     }     catch (UnsupportedEncodingException e)     {       throw new JRException(e);

View Full Code Here

Examples of net.sf.jasperreports.engine.data.JRCsvDataSource

69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110     String csvCharset = getStringParameterOrProperty(JRCsvQueryExecuterFactory.CSV_ENCODING);         try {       Reader csvReader = (Reader) getParameterValue(JRCsvQueryExecuterFactory.CSV_READER);       if (csvReader != null) {         datasource = new JRCsvDataSource(csvReader);       } else {         InputStream csvInputStream = (InputStream) getParameterValue(JRCsvQueryExecuterFactory.CSV_INPUT_STREAM);         if (csvInputStream != null) {           if (csvCharset != null) {             datasource = new JRCsvDataSource(csvInputStream, csvCharset);           } else {             datasource = new JRCsvDataSource(csvInputStream);           }         } else {           File csvFile = (File) getParameterValue(JRCsvQueryExecuterFactory.CSV_FILE);           if (csvFile != null) {             if (csvCharset != null) {               datasource = new JRCsvDataSource(csvFile, csvCharset);             } else {               datasource = new JRCsvDataSource(csvFile);             }           } else {             URL csvUrl = (URL) getParameterValue(JRCsvQueryExecuterFactory.CSV_URL);             if (csvUrl != null) {               if (csvCharset != null) {                 datasource = new JRCsvDataSource(csvUrl, csvCharset);               } else {                 datasource = new JRCsvDataSource(csvUrl);               }             } else {               String csvSource = getStringParameterOrProperty(JRCsvQueryExecuterFactory.CSV_SOURCE);               if (csvSource != null) {                 if (csvCharset != null) {                   datasource = new JRCsvDataSource(csvSource, csvCharset);                 } else {                   datasource = new JRCsvDataSource(csvSource);                 }               } else {                 if (log.isWarnEnabled()){                   log.warn("No CSV source was provided.");                 }

View Full Code Here

Examples of net.sf.jasperreports.engine.data.JRCsvDataSource

93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111    */ public void fill() throws JRException {     long start = System.currentTimeMillis();         JRCsvDataSource cds = null;     try     {       String[] columnNames = new String[]{"value", "series", "category"};       cds = new JRCsvDataSource(JRLoader.getLocationInputStream("data/spiderDatasource.csv"), "UTF-8");       cds.setRecordDelimiter("\n");       cds.setUseFirstRowAsHeader(false);       cds.setColumnNames(columnNames);     }     catch (UnsupportedEncodingException e)     {       throw new JRException(e);     }

View Full Code Here

Examples of net.sf.jasperreports.engine.data.JRCsvDataSource

105 106 107 108 109 110 111 112 113 114 115 116 117 118       states.add("Active");       states.add("Trial");       parameters.put("IncludedStates", states);       String[] columnNames = new String[]{"city", "id", "name", "address", "state"};       JRCsvDataSource dataSource = new JRCsvDataSource(JRLoader.getLocationInputStream("data/CsvDataSource.txt"));       dataSource.setRecordDelimiter("\r\n"); //        dataSource.setUseFirstRowAsHeader(true);       dataSource.setColumnNames(columnNames);             JasperFillManager.fillReportToFile("build/reports/CsvDataSourceReport.jasper", parameters, dataSource);       System.err.println("Report : CsvDataSourceReport.jasper. Filling time : " + (System.currentTimeMillis() - start));     }

View Full Code Here

Examples of net.sf.jasperreports.engine.data.JRCsvDataSource

368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391     protected JRDataSource getJrDataSource() throws IOException, JRException {         if (resource != null) {             final String res = resource.toLowerCase();             resourceInputStream = ItemReaderWriterBase.getInputStream(resource, false);             if (res.endsWith(".csv")) {                 final JRCsvDataSource csvDataSource = charset == null ? new JRCsvDataSource(resourceInputStream) :                         new JRCsvDataSource(resourceInputStream, charset);                 setCommonJRDataSourceProperties(csvDataSource);                 if (useFirstRowAsHeader != null) {                     csvDataSource.setUseFirstRowAsHeader(Boolean.parseBoolean(useFirstRowAsHeader));                 }                 if (recordDelimiter != null) {                     csvDataSource.setRecordDelimiter(recordDelimiter);                 }                 if (fieldDelimiter != null) {                     csvDataSource.setFieldDelimiter(fieldDelimiter.trim().charAt(0));                 }                 if (columnNames != null) {                     csvDataSource.setColumnNames(columnNames);                 }                 return csvDataSource;             }             if (res.endsWith(".xls")) {                 final XlsDataSource xlsDataSource = new XlsDataSource(resourceInputStream);

View Full Code Here

TOP

Copyright © 2018 www.massapi.com. All rights reserved.

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.