protected void readCsvFile(String filename) { InputStream companiesCsvInput = StockAgent.class.getClassLoader() .getResourceAsStream(filename); ICsvBeanReader csvBeanReader = null; try { csvBeanReader = new CsvBeanReader(new BufferedReader( new InputStreamReader(companiesCsvInput)), CsvPreference.STANDARD_PREFERENCE); final String[] header = csvBeanReader.getHeader(true); CompanyInfo companyInfo; while ((companyInfo = csvBeanReader.read(CompanyInfo.class, header, processors)) != null) { this.stockSymbolMap.put(companyInfo.getName(), companyInfo); } csvBeanReader.close(); } catch (IOException e) { logger.error("Failed to load " + filename + ".", e); } }
csvBeanReader = new CsvBeanReader(csvFile), CsvPreference.EXCEL_NORTH_EUROPE_PREFERENCE); final String[] headersArray = csvBeanReader.getHeader(true); List<String> headers = Arrays.asList(headersArray); List<String> expectedHeaders = Arrays.asList("street", "city"); ProductDetail productDetail = null; while ((productDetail = csvBeanReader.read(ProductDetail.class, headersArray, processors)) != null) { productDetails.add(productDetail); csvBeanReader.close();
throws IOException { if( readRow() ) { if( nameMapping.length != length() ) { throw new IllegalArgumentException(String.format( "the nameMapping array and the number of columns read " + "should be the same size (nameMapping length = %d, columns = %d)", nameMapping.length, length())); processedColumns.addAll(getColumns()); } else { executeProcessors(processedColumns, processors); return populateBean(bean, nameMapping);
CsvBeanReader beanReader=new CsvBeanReader(new StringReader(theString), preferences); beanReader.read(theBean, nameMapping);
@Override public void teardown() { try { csvMapReader.close(); } catch (IOException e) { logger.error("Error while closing csv map reader {}", e.getMessage()); DTThrowable.wrapIfChecked(e); } try { csvBeanReader.close(); } catch (IOException e) { logger.error("Error while closing csv bean reader {}", e.getMessage()); DTThrowable.wrapIfChecked(e); } }
Object obj = csvBeanReader.read(clazz, nameMapping, processors); out.emit(obj); emittedObjectCount++;
@Override public void teardown() { try { csvMapReader.close(); } catch (IOException e) { logger.error("Error while closing csv map reader {}", e.getMessage()); DTThrowable.wrapIfChecked(e); } try { csvBeanReader.close(); } catch (IOException e) { logger.error("Error while closing csv bean reader {}", e.getMessage()); DTThrowable.wrapIfChecked(e); } }
@Override public List<T> read(InputStream is) throws Exception { List<T> elements = new ArrayList<T>(); ICsvBeanReader reader = new CsvBeanReader(new InputStreamReader(is), CsvPreference.EXCEL_PREFERENCE); try { String[] headers = mapHeaderNames(reader.getHeader(true)); T element; while ((element = reader.read(type, headers, cellProcessors)) != null) { elements.add(element); } } finally { reader.close(); } return elements; }
Object obj = csvBeanReader.read(clazz, nameMapping, processors); out.emit(obj); emittedObjectCount++;
@Override public void importStream(InputStream inputStream, OnItemHandler handler, String charSetName) throws Exception { Reader reader = new InputStreamReader(inputStream, charSetName); ICsvBeanReader csvBeanReader = new CsvBeanReader(reader, this.preference); Object obj; while ((obj = csvBeanReader.<T>read(getDataClass(), this.fieldNames, this.processors)) != null) { handler.onItem(obj); } }
@Override public List<T> parse(InputStream inputStream, Class<T> clazz) { checkNotNull(inputStream, "inputStream must not be null"); checkNotNull(clazz, "clazz must not be null"); ICsvBeanReader beanReader = null; List<T> beans = new ArrayList<>(); try { beanReader = new CsvBeanReader(new InputStreamReader(inputStream, template.getCharsetName()), template.getPreferences()); if (template.showHeader()) { beanReader.getHeader(true); } // the header elements are used to map the values to the bean (names must match) final List<CellProcessor> confList = template.getReadingCellProcessors(); final CellProcessor[] processors = confList.toArray(new CellProcessor[confList.size()]); final String[] fields = template.getFields().toArray(new String[template.getFields().size()]); T bean; while ((bean = beanReader.read(clazz, fields, processors)) != null) { beans.add(bean); } } catch (Exception e) { throw SeedException.wrap(e, SuperCsvErrorCode.ERROR_DURING_SUPER_CSV_PARSING) .put(TEMPLATE, template.getName()); } finally { closeQuietly(beanReader); } return beans; }
@Override public List<T> parse(InputStream inputStream, Class<T> clazz) { ICsvBeanReader beanReader = null; List<T> beans = new ArrayList<T>(); // Checks params nullity SeedException.createNew(RendererErrorCode.INCORRECT_PARAM).put(PARAM, "inputStream").throwsIfNull(inputStream); SeedException.createNew(RendererErrorCode.INCORRECT_PARAM).put(PARAM, "clazz").throwsIfNull(clazz); try { beanReader = new CsvBeanReader(new InputStreamReader(inputStream, template.getCharsetName()), template.getPreferences()); if (template.showHeader()) { beanReader.getHeader(true); } // the header elements are used to map the values to the bean (names must match) final List<CellProcessor> confList = template.getReadingCellProcessors(); final CellProcessor[] processors = confList.toArray(new CellProcessor[confList.size()]); final String[] fields = template.getFields().toArray(new String[template.getFields().size()]); T bean; while ((bean = beanReader.read(clazz, fields, processors)) != null) { beans.add(bean); } } catch (Exception e) { throw SeedException.wrap(e, RendererErrorCode.SUPER_CSV_EXCEPTION).put(TEMPLATE_NAME, template.getName()); } finally { closeQuietly(beanReader); } return beans; }
@Override public void setup(OperatorContext context) { delimitedParserSchema = new DelimitedSchema(schema); preference = new CsvPreference.Builder(delimitedParserSchema.getQuoteChar(), delimitedParserSchema.getDelimiterChar(), delimitedParserSchema.getLineDelimiter()).build(); nameMapping = delimitedParserSchema.getFieldNames().toArray( new String[delimitedParserSchema.getFieldNames().size()]); header = StringUtils.join(nameMapping, (char)delimitedParserSchema.getDelimiterChar() + ""); processors = getProcessor(delimitedParserSchema.getFields()); csvStringReader = new ReusableStringReader(); csvMapReader = new CsvMapReader(csvStringReader, preference); csvBeanReader = new CsvBeanReader(csvStringReader, preference); }
@Override public void setup(OperatorContext context) { delimitedParserSchema = new DelimitedSchema(schema); preference = new CsvPreference.Builder(delimitedParserSchema.getQuoteChar(), delimitedParserSchema.getDelimiterChar(), delimitedParserSchema.getLineDelimiter()).build(); nameMapping = delimitedParserSchema.getFieldNames().toArray( new String[delimitedParserSchema.getFieldNames().size()]); header = StringUtils.join(nameMapping, (char)delimitedParserSchema.getDelimiterChar() + ""); processors = getProcessor(delimitedParserSchema.getFields()); csvStringReader = new ReusableStringReader(); csvMapReader = new CsvMapReader(csvStringReader, preference); csvBeanReader = new CsvBeanReader(csvStringReader, preference); }