private boolean saveDataToCsvFile() {

    String csv = "/mnt/sdcard/DanceForHealthLog.csv";

    try {
      CSVWriter writer = new CSVWriter(new FileWriter(csv), ',');
      String[] header = {
        "Date", "Type", "Weight", "Post-Dance HR", "Post-Dance Pedometer", "PACE Score(strain)"
      };
      writer.writeNext(header);
      for (Workout w : workoutDataStore) {
        String[] entries = {
          w.getDate(),
          w.getType(),
          "" + w.getWeight(),
          "" + w.getHR(),
          "" + w.getSteps(),
          "" + w.getStrain()
        };
        writer.writeNext(entries);
      }
      writer.close();
      return true;

    } catch (Exception e) {
      e.printStackTrace();
      return false;
    }
  }
예제 #2
0
  @Override
  public File build() {
    try {
      csvWriter.close();
    } catch (IOException e) {
      e.printStackTrace();
    }

    return outputFile;
  }
 public static void stopLogging() throws IOException {
   if (loggingActive) {
     //            try {
     csv_writer.close();
     //            } catch (IOException e) {
     //                e.printStackTrace();
     //            }
     loggingActive = false;
   }
 }
예제 #4
0
  /**
   * Update the ranks in the csv file when the tweet is already in the base but saved with another
   * mark
   *
   * @param mark : note of the tweet
   * @param row : line of the tweet in the base
   * @throws IOException
   */
  public static void updateCSV(int mark, int row) throws IOException {
    CSVReader reader = new CSVReader(new FileReader(AppliSettings.filename), ';');
    List<String[]> csvBody = reader.readAll();
    csvBody.get(row)[4] = Integer.toString(mark);
    reader.close();

    CSVWriter writer = new CSVWriter(new FileWriter(AppliSettings.filename), ';');
    writer.writeAll(csvBody);
    writer.flush();
    writer.close();
  }
  public static void exportToCSV() {

    ArrayList<String> keyList = new ArrayList<>();
    keyList.add(DBAdapter.KEY_ROWID);
    keyList.add(DBAdapter.KEY_EVALUATOR);
    keyList.add(DBAdapter.KEY_HOSPITALID);
    keyList.add(DBAdapter.KEY_DATE);
    keyList.add(DBAdapter.KEY_LANGUAGE);
    for (ItemSection section : DataSource.sections) {
      for (ItemQuestion question : section.questions) {
        if (question.dbKey != null) {
          Collections.addAll(keyList, question.dbKey);
        }
      }
    }

    String[] keys = keyList.toArray(new String[keyList.size()]);

    Cursor cursor = HomeActivity.myDb.getColumns(keys);
    cursor.moveToFirst();

    File path = Environment.getExternalStorageDirectory();
    File filename =
        new File(
            path,
            "/FrailtyAnswers-"
                + cursor.getString(cursor.getColumnIndex(DBAdapter.KEY_HOSPITALID))
                + ".csv");

    try {
      CSVWriter writer = new CSVWriter(new FileWriter(filename), '\t');
      writer.writeNext(new String[] {"sep=\t"});

      writer.writeNext(cursor.getColumnNames());

      if (cursor.moveToFirst()) {
        ArrayList<String> values = new ArrayList<>();
        for (int i = 0; i < cursor.getColumnCount(); i++) {
          values.add(cursor.getString(i));
        }
        String[] stringValues = values.toArray(new String[values.size()]);
        writer.writeNext(stringValues);
      }

      writer.close();
      cursor.close();

    } catch (IOException e) {
      System.err.println("Caught IOException: " + e.getMessage());
    }
  }
예제 #6
0
  private void writeCsvRow(String[] cols) throws FileTooLargeException {
    csvWriter.writeNext(cols);

    if (countingOutputStream.getCount() > maxFileSizeBytes) {
      try {
        csvWriter.close();
      } catch (IOException e) {
        log.error("Caught exception closing csv writer", e);
      }

      delete();
      throw new FileTooLargeException();
    }
  }
예제 #7
0
 /**
  * Method to write a CSV List of Array of String to System Console..
  *
  * @param content the List of Array of String to convert.
  * @param separator the char separator.
  */
 public static void writeCSVDataToConsole(List<String[]> content, char separator) {
   try {
     Writer writer = new OutputStreamWriter(System.out, StringUtilities.UTF_8);
     CSVWriter csvWriter;
     if (StringUtilities.NULL_CHAR2 == separator) {
       csvWriter =
           new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
     } else {
       csvWriter = new CSVWriter(writer, separator, CSVWriter.NO_QUOTE_CHARACTER);
     }
     csvWriter.writeAll(content, false);
     csvWriter.close();
   } catch (IOException e) {
     logger.error("Can't write the CSV to Console -> " + e.getMessage(), e);
   }
 }
예제 #8
0
 /**
  * Method to write a CSV Data List of Array of String to a String.
  *
  * @param content the List of Array of String to convert.
  * @param separator the char separator.
  * @return the String content of the List of Beans.
  */
 public static String writeCSVDataToString(List<String[]> content, char separator) {
   try {
     Writer writer = new StringWriter();
     CSVWriter csvWriter;
     if (StringUtilities.NULL_CHAR2 == separator) {
       csvWriter =
           new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
     } else {
       csvWriter = new CSVWriter(writer, separator, CSVWriter.NO_QUOTE_CHARACTER);
     }
     csvWriter.writeAll(content);
     csvWriter.close();
     return writer.toString();
   } catch (IOException e) {
     logger.error("Can't write the CSV String -> " + e.getMessage(), e);
     return "";
   }
 }
 public void produceBatterRegularSeasonStatsCSV() {
   Set<Player> projectedPlayers = findProjectedBatters();
   List<BatterRegularSeasonStats> rsStats =
       projectedPlayers
           .stream()
           .map(p -> rsStatsRepo.findBySeasonAndPlayer(2015, p)) // find last season's stats
           .filter(
               s -> s != null) // some players may exist in projections but not the previous season
           .collect(Collectors.toList());
   try {
     CSVWriter cw = new CSVWriter(new FileWriter("./output/batters2015.csv"));
     cw.writeNext(getHeaderRow());
     for (BatterStats stats : rsStats) {
       cw.writeNext(toTuple(stats));
     }
     cw.close();
   } catch (IOException ex) {
     throw new RuntimeException(ex);
   }
 }
예제 #10
0
 /**
  * Method to write a CSV File from List of Array of String.
  *
  * @param content the List of Array of String to convert.
  * @param separator the char separator.
  * @param fileOutputCsv the output File Csv to create.
  * @return the File Csv created.
  */
 public static File writeCSVDataToFile(
     List<String[]> content, char separator, File fileOutputCsv) {
   try {
     Writer writer =
         new FileWriter(fileOutputCsv, true); // the true value make append the result...
     CSVWriter csvWriter;
     if (StringUtilities.NULL_CHAR2 == separator) {
       csvWriter =
           new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
     } else {
       csvWriter = new CSVWriter(writer, separator, CSVWriter.NO_QUOTE_CHARACTER);
     }
     csvWriter.writeAll(content);
     csvWriter.close();
     return fileOutputCsv;
   } catch (IOException e) {
     logger.error("Can't write the CSV to File:" + fileOutputCsv + " -> " + e.getMessage(), e);
     return null;
   }
 }
예제 #11
0
  public static void writeAEFile(Map<String, String> aeMap, String outfile) {
    try {

      CSVWriter writer = new CSVWriter(new FileWriter(outfile), ',');

      String[] header = new String[2];
      header[0] = "SKU";
      header[1] = "INVENTORY";
      writer.writeNext(header);

      String[] row = new String[2];
      for (String SKU : aeMap.keySet()) {
        row[0] = SKU;
        row[1] = aeMap.get(SKU);
        writer.writeNext(row);
      }

      writer.close();

    } catch (Exception ex) {
      out.println(ex.getMessage() + " in writeAEFile");
    }
  }
예제 #12
-1
  public void writeText(String filepath) {

    CSVWriter writer;
    try {
      writer = new CSVWriter(new FileWriter(filepath), ',', CSVWriter.NO_QUOTE_CHARACTER);
      // feed in your array (or convert your data to an array)

      writer.writeAll(ioNames.unformattedStrings());
      writer.close();
    } catch (IOException ex) {
      System.out.println("Write text error with " + filepath + " : " + ex.getMessage());
    }
  }