csvWriter = new CsvListWriter(response.getWriter(), CsvPreference.STANDARD_PREFERENCE);
public static String addTimestampColumnFromCsv(String timeStr, String inputPath, String outputPath) { File inputFile = new File(inputPath); File outputFile = new File(outputPath); CsvListReader reader = null; CsvListWriter writer = null; try { CsvPreference csvPreference = new CsvPreference.Builder('"', ',', "\r\n") .ignoreEmptyLines(false) .build(); reader = new CsvListReader(new FileReader(inputFile), csvPreference); writer = new CsvListWriter(new FileWriter(outputFile), csvPreference); List<String> columns; while ((columns = reader.read()) != null) { columns.add(timeStr); writer.write(columns); } } catch (IOException e) { throw new MetatronException("Fail to transform csv file :" + e.getMessage()); } finally { try { if (reader != null) reader.close(); if (writer != null) writer.close(); } catch (IOException e) {} } return outputFile.getAbsolutePath(); }
private String getHeaderString() { if(this.header == null) { return null; } ByteArrayOutputStream baos = new ByteArrayOutputStream(); try { CsvListWriter csvListWriter = new CsvListWriter(new OutputStreamWriter(baos), CsvPreference.TAB_PREFERENCE); csvListWriter.write(this.header); csvListWriter.flush(); csvListWriter.close(); return baos.toString("utf-8"); } catch (Exception e) { throw new RuntimeException(e); } }
public void addToken(String wordid, String originalContent, String word, String label, String continuationId) { if (label != null) { if (csvListWriter == null) { outputFile = new File(context.getOutputDirectory(), name + ".csv"); try { csvListWriter = new CsvListWriter(new FileWriter(outputFile), CsvPreference.STANDARD_PREFERENCE); csvListWriter.writeHeader(header); } catch (IOException e) { throw new IllegalStateException( "Could not open CSV writer for file " + outputFile.getAbsolutePath(), e); } } try { String continuationIdStr = ""; if (continuationId != null) { continuationIdStr = continuationId; } csvListWriter.write(wordid, originalContent, word, label, continuationIdStr); } catch (IOException e) { throw new IllegalStateException("Could not write to CSV writer for file " + outputFile.getAbsolutePath(), e); } } }
private String getFormattedStr(String[] vals) { StringWriter strWriter = new StringWriter(); CsvListWriter writer = new CsvListWriter(strWriter, getCsvPreference()); if (vals.length > 0) { try { writer.write(vals); } catch (IOException e) { beeLine.error(e); } finally { IOUtils.closeStream(writer); } } return strWriter.toString(); }
public void writeMatches(Config config, WikiBrainShapeFile shapeFile) throws IOException, ConfigurationException, DaoException { Map<String, MappingInfo> existing = readExisting(shapeFile); File newFile = File.createTempFile("wbmapping", "csv"); CsvListWriter csv = new CsvListWriter(WpIOUtils.openWriter(newFile), CsvPreference.STANDARD_PREFERENCE); csv.close();
private void writeHeader(CsvListWriter writer, List<String> extraFields) throws IOException { List<String> fields = new ArrayList<String>(); fields.add("WB_ID"); fields.add("WB_KEY"); fields.add("WB_UPDATED"); fields.add("WB_STATUS"); fields.add("WB_TITLE"); fields.add("WB_GUESS1"); fields.add("WB_GUESS2"); fields.add("WB_GUESS3"); fields.add("WB_SCORE"); fields.addAll(extraFields); writer.write(fields); }
CsvListReader reader = new CsvListReader(new FileReader(inputCsv), CsvPreference.STANDARD_PREFERENCE); CsvListWriter writer = new CsvListWriter(new FileWriter(outputCsv), CsvPreference.STANDARD_PREFERENCE); List<String> columns; while ((columns = reader.read()) != null) { System.out.println("Input: " + columns); // Add new columns columns.add(1, "Column_2"); columns.add("Last_column"); System.out.println("Output: " + columns); writer.write(columns); } reader.close(); writer.close();
w = new CsvListWriter(new FileWriter(reader == null ? res.getFile() : writerFile), pref); if (headers != null && !headers.isEmpty()) { w.writeHeader(headers.keySet().toArray(new String[headers.size()]));
/** * Close the reader, then close the shadow writer and replace the original * file if necessary. */ @Override public void close() throws IOException { try { if (reader != null) { reader.close(); } } finally { if (writer != null) { // dump the last row to the writer try { writeRow(); writer.flush(); } finally { try { writer.close(); } finally { renameFiles(); } } } } }
public void close() { try { if (csvListWriter != null) { csvListWriter.close(); } } catch (IOException e) { throw new IllegalStateException("Could not close CSV writer for file " + outputFile.getAbsolutePath(), e); } }
@Override public void flush() throws IOException { if (writer != null) { writer.flush(); } }
public void writeAllData(String path) throws IOException { CsvListWriter writer = new CsvListWriter(WpIOUtils.openWriter(path), CsvPreference.STANDARD_PREFERENCE); writer.write(Arrays.asList("stage", "singleCoreSpeed", "multiCoreSpeed", "numLinks", "numArticles", "elapsed")); for (StageDiagnostic diagnostic : diagnostics) { int numArticles = 0; int numLinks = 0; for (Language l : diagnostic.getLangs()) { numLinks += LanguageInfo.getByLanguage(l).getNumLinks(); numArticles += LanguageInfo.getByLanguage(l).getNumArticles(); } writer.write(Arrays.asList( diagnostic.getStage(), diagnostic.getSingleCoreSpeed(), diagnostic.getMultiCoreSpeed(), numLinks, numArticles, diagnostic.getElapsedSeconds() )); } writer.close(); }
CsvListWriter writer = new CsvListWriter(osw, CsvPreference.STANDARD_PREFERENCE); writer.writeHeader(header); raw[i] = point.getY(); writer.write((Object[]) raw); writer.flush(); writer.close();
Path csvFile = Paths.get(workflowStatesFolder.toString(), SERIALIZED_STATES_FILENAME); try (FileWriter fileWriter = new FileWriter(csvFile.toFile()); CsvListWriter csvWriter = new CsvListWriter(fileWriter, new CsvPreference.Builder('"', ';', "\r\n").build())) { boolean printHeaders = true; for (Integer stateId : workflowStates.keySet()) { headersList.add("state"); headersList.addAll(Arrays.asList(headers.toArray(new String[]{}))); csvWriter.writeHeader(headersList.toArray(new String[]{})); printHeaders = false; valuesList.add(stateId); valuesList.addAll(Arrays.asList(networkValues.values().toArray())); csvWriter.write(valuesList.toArray());
private String getFormattedStr(String[] vals) { StringWriter strWriter = new StringWriter(); CsvListWriter writer = new CsvListWriter(strWriter, getCsvPreference()); if (vals.length > 0) { try { writer.write(vals); } catch (IOException e) { beeLine.error(e); } finally { IOUtils.closeStream(writer); } } return strWriter.toString(); }
public void writeMatches(Config config, WikiBrainShapeFile shapeFile) throws IOException, ConfigurationException, DaoException { Map<String, MappingInfo> existing = readExisting(shapeFile); File newFile = File.createTempFile("wbmapping", "csv"); CsvListWriter csv = new CsvListWriter(WpIOUtils.openWriter(newFile), CsvPreference.STANDARD_PREFERENCE); csv.close();
private void writeHeader(CsvListWriter writer, List<String> extraFields) throws IOException { List<String> fields = new ArrayList<String>(); fields.add("WB_ID"); fields.add("WB_KEY"); fields.add("WB_UPDATED"); fields.add("WB_STATUS"); fields.add("WB_TITLE"); fields.add("WB_GUESS1"); fields.add("WB_GUESS2"); fields.add("WB_GUESS3"); fields.add("WB_SCORE"); fields.addAll(extraFields); writer.write(fields); }
@Override public void allDone() { try { csvWriter.flush(); super.allDone(); List<File> batch = ExternalSort.sortInBatch( new File(tmpFile), defaultcomparator, ExternalSort.DEFAULTMAXTEMPFILES, Charset.forName("utf8"), null, true); ExternalSort.mergeSortedFiles(batch, new File(outFile), defaultcomparator, Charset.forName("utf-8"), true, false, false, getHeaderString()); new File(tmpFile).delete(); } catch (IOException e) { throw new RuntimeException(e); } }