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;
}
}
@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;
}
}
/**
* 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());
}
}
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();
}
}
/**
* 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);
}
}
/**
* 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);
}
}
/**
* 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;
}
}
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");
}
}
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());
}
}
