/// <summary>
/// Write database records to text based file format.
/// </summary>
/// <param name="path">The fields file path.</param>
/// <param name="fs">The file system.</param>
/// <param name="database">The source records database.</param>
void ITextFieldWriter <XDatabase> .Write(string path, IFileSystem fs, XDatabase database)
{
using (var writer = new System.IO.StringWriter())
{
var configuration = new CSV.Configuration.CsvConfiguration();
configuration.Delimiter = CultureInfo.CurrentCulture.TextInfo.ListSeparator;
configuration.CultureInfo = CultureInfo.CurrentCulture;
using (var csv = new CSV.CsvWriter(writer, configuration))
{
// columns
csv.WriteField(database.IdColumnName);
foreach (var column in database.Columns)
{
csv.WriteField(column.Name);
}
csv.NextRecord();
// records
foreach (var record in database.Records)
{
csv.WriteField(record.Id.ToString());
foreach (var value in record.Values)
{
csv.WriteField(value.Content);
}
csv.NextRecord();
}
}
fs.WriteUtf8Text(path, writer.ToString());
}
}
/// <summary>
///
/// </summary>
/// <param name="bindings"></param>
private static void OutputToFile(List <Binding> bindings)
{
using (FileStream fileStream = new FileStream(Path.Combine(fclp.Object.Output, "wmi-parser.tsv"), FileMode.Create, FileAccess.Write))
using (StreamWriter streamWriter = new StreamWriter(fileStream))
using (CsvWriter cw = new CsvHelper.CsvWriter(streamWriter))
{
cw.Configuration.Delimiter = "\t";
// Write out the file headers
cw.WriteField("Name");
cw.WriteField("Type");
cw.WriteField("Arguments");
cw.WriteField("Filter Name");
cw.WriteField("Filter Query");
cw.NextRecord();
foreach (var b in bindings)
{
cw.WriteField(b.Name);
cw.WriteField(b.Type);
cw.WriteField(b.Arguments);
cw.WriteField(b.Filter);
cw.WriteField(b.Query);
cw.NextRecord();;
}
}
}
public static string CreateCSV(IEnumerable <StringTableEntry> entries)
{
using (var textWriter = new System.IO.StringWriter())
{
// Generate the localised .csv file
// Use the invariant culture when writing the CSV
var csv = new CsvHelper.CsvWriter(
textWriter, // write into this stream
GetConfiguration() // use this configuration
);
var fieldNames = new[] {
"language",
"id",
"text",
"file",
"node",
"lineNumber",
"lock",
"comment",
};
foreach (var field in fieldNames)
{
csv.WriteField(field);
}
csv.NextRecord();
foreach (var entry in entries)
{
var values = new[] {
entry.Language,
entry.ID,
entry.Text,
entry.File,
entry.Node,
entry.LineNumber,
entry.Lock,
entry.Comment,
};
foreach (var value in values)
{
csv.WriteField(value);
}
csv.NextRecord();
}
return(textWriter.ToString());
}
}
protected override void DoPostWorkCompleted()
{
// write the item feed status into the CSV file
var resultFilePath = string.Format("{0}\\eBayProductsEndItemResults{1}.csv", _resultFileDirecctory, _systemJob.Id);
// write into the file
using (var streamWriter = new StreamWriter(resultFilePath))
{
var writer = new CsvHelper.CsvWriter(streamWriter);
// write the column headers
writer.WriteField("EisSKU");
writer.WriteField("ItemId");
writer.WriteField("Status");
writer.WriteField("Message");
writer.NextRecord();
foreach (var item in _itemFeeds)
{
writer.WriteField(item.EisSKU);
writer.WriteField(item.ItemId);
writer.WriteField(item.Status);
writer.WriteField(item.Message);
// move to the next row
writer.NextRecord();
}
}
// update the system job parameters out for the file path of the result file
_jobRepository.UpdateSystemJobParametersOut(_systemJob.Id, resultFilePath);
}
public static void WriteObjectToCsv(Metrics metrics, Type classtype, string filename)
{
using (var sw = new StreamWriter(filename))
{
var csvHelper = new CsvHelper.CsvWriter(sw);
csvHelper.WriteHeader(classtype);
csvHelper.NextRecord();
csvHelper.WriteField(metrics.Distance);
csvHelper.WriteField(metrics.Number);
sw.Flush();
csvHelper.Flush();
}
}
public string GetAsCSV()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
var m = new StringWriter(sb);
TextWriter tw = m;
var config = new CsvConfiguration(CultureInfo.CurrentCulture);
config.Delimiter = ColumnDelimiter;
var p = new CsvHelper.CsvWriter(tw, config);
//CSVLine Line;
foreach (var line in Lines)
{
foreach (var c in line.Columns)
{
p.WriteField(c);
}
p.NextRecord();
}
p.Flush();
return(sb.ToString());
}
/// <summary>
/// Writes a csv header from a datatable
/// </summary>
/// <param name="queue"></param>
/// <param name="csvWriter"></param>
public static void WriteCSVHeader(DataTable queue, CsvHelper.CsvWriter csvWriter)
{
foreach (DataColumn column in queue.Columns)
{
csvWriter.WriteField(column.ColumnName);
}
csvWriter.NextRecord();
}
public void Write(Stream stream, DatabaseViewModel?database)
{
if (database is null)
{
return;
}
using var writer = new StringWriter();
var configuration = new CSV.Configuration.CsvConfiguration(CultureInfo.CurrentCulture)
{
Delimiter = CultureInfo.CurrentCulture.TextInfo.ListSeparator
};
using (var csvWriter = new CSV.CsvWriter(writer, configuration))
{
// Columns
csvWriter.WriteField(database.IdColumnName);
foreach (var column in database.Columns)
{
csvWriter.WriteField(column.Name);
}
csvWriter.NextRecord();
// Records
foreach (var record in database.Records)
{
csvWriter.WriteField(record.Id);
foreach (var value in record.Values)
{
csvWriter.WriteField(value.Content);
}
csvWriter.NextRecord();
}
}
var csv = writer.ToString();
var fileSystem = _serviceProvider.GetService <IFileSystem>();
fileSystem?.WriteUtf8Text(stream, csv);
}
/// <summary>
/// Creates CSV-file to given path using Exportmodel as configurations and measurementModels as data.
/// </summary>
/// <param name="fullPath"></param>
/// <param name="options"></param>
/// <param name="measurements"></param>
public void CreateCsvFile(string filename, string directoryPath, ExportModel options, List <MeasurementModel> measurements)
{
_measurements = measurements;
try
{
if (!Directory.Exists(directoryPath))
{
Directory.CreateDirectory(directoryPath);
}
using (TextWriter tw = new StreamWriter(directoryPath + filename))
{
using (var writer = new CsvHelper.CsvWriter(tw))
{
if (!string.IsNullOrEmpty(options.ColumnDelimeter))
{
writer.Configuration.Delimiter = options.ColumnDelimeter;
}
writer.Configuration.HasHeaderRecord = options.ShowHeaders;
var selected = CreateSelectedValueList(options);
if (options.ShowHeaders)
{
var headers = CreateHeaders(measurements, selected);
foreach (var h in headers)
{
writer.WriteField(h);
}
writer.NextRecord();
}
var functions = CreateDataValueFunctions(selected);
for (mIndex = 0; mIndex < measurements.Count; mIndex++)
{
writer.WriteField(measurements[mIndex].Object);
writer.WriteField(measurements[mIndex].Tag);
writer.WriteField(measurements[mIndex].Timestamp.ToString(options.Datetimeformat));
writer.WriteField(measurements[mIndex] != null ? measurements[mIndex].Location?.ToString() : "");
writer.WriteField(measurements[mIndex].Note);
for (dIndex = 0; dIndex < measurements[mIndex].Data.Count; dIndex++)
{
foreach (var f in functions)
{
var result = f.Invoke();
writer.WriteField((object)result ?? (object)string.Empty);
}
}
writer.NextRecord();
}
}
}
}
catch (Exception)
{
throw;
}
}
bool ExportPrices(Message message)
{
try
{
string fileName = $"C:\\temp\\price_{DateTime.Now.ToString("ddMMyyyyhh")}.csv";
using (var sw = new StreamWriter(fileName, File.Exists(fileName)))
{
var writer = new CsvHelper.CsvWriter(sw, _csvConfig);
var result = JsonConvert.DeserializeObject <PDLPRCP>(Encoding.UTF8.GetString(message.Body));
writer.WriteField(result.StyleNumber);
writer.WriteField(result.ColourCode);
writer.WriteField(result.SizeCode);
writer.WriteField(result.CountryCode);
writer.WriteField(result.BaseCcyCurrentRet);
writer.WriteField(result.BaseCcyOriginalRet);
writer.NextRecord();
}
//if (!File.Exists(fileName))
//{
// using (var sw = new StreamWriter(fileName))
// {
// var writer = new CsvHelper.CsvWriter(sw, _csvConfig);
// var result = JsonConvert.DeserializeObject<PDLPRCP>(Encoding.UTF8.GetString(message.Body));
// writer.WriteField(result.StyleNumber);
// writer.WriteField(result.ColourCode);
// writer.WriteField(result.SizeCode);
// writer.WriteField(result.CountryCode);
// writer.WriteField(result.BaseCcyCurrentRet);
// writer.WriteField(result.BaseCcyOriginalRet);
// writer.NextRecord();
// }
//}
//else
//{
// using (var sw = new StreamWriter(fileName,true))
// {
// var writer = new CsvHelper.CsvWriter(sw, _csvConfig);
// writer.NextRecord();
// var result = JsonConvert.DeserializeObject<PDLPRCP>(Encoding.UTF8.GetString(message.Body));
// writer.WriteField(result.StyleNumber);
// writer.WriteField(result.ColourCode);
// writer.WriteField(result.SizeCode);
// writer.WriteField(result.CountryCode);
// writer.WriteField(result.BaseCcyCurrentRet);
// writer.WriteField(result.BaseCcyOriginalRet);
// writer.NextRecord();
// }
//}
return(true);
}
catch (Exception ex)
{
log.Error("Export prices: ", ex);
}
return(false);
}
static void SkapaIntCSV(List <OmniArtikel> artiklar, string path)
{
using (var stream = File.OpenWrite(path))
using (var writer = new StreamWriter(stream, Encoding.UTF8))
using (var csvWriter = new CsvHelper.CsvWriter(writer))
{
csvWriter.Configuration.Delimiter = ",";
csvWriter.Configuration.HasHeaderRecord = false;
// Headers
csvWriter.WriteField("x");
csvWriter.WriteField("y");
csvWriter.NextRecord();
foreach (var artikel in artiklar)
{
csvWriter.WriteField(TextTillIndexArray(artikel.Text.Trim()));
csvWriter.WriteField(KategorierTillIndexArray(artikel.Taggar.Select(t => t.TopicId).ToArray()));
csvWriter.NextRecord();
}
}
}
public string GetCSVLine(string Delimiter = ",")
{
var sb = new StringBuilder();
var m = new StringWriter(sb);
TextWriter tw = m; // new StreamWriter(m);
var config = new CsvConfiguration(CultureInfo.CurrentCulture); //.Configuration();
config.Delimiter = Delimiter;
var p = new CsvHelper.CsvWriter(tw, config);
foreach (var c in Columns)
{
p.WriteField(c);
}
p.NextRecord();
p.Flush();
return(sb.ToString());
//var dbq = "\"";
//System.Text.StringBuilder sb = new System.Text.StringBuilder();
////string s;
//bool First = true;
//if (m_Columns == null)
//{
// m_Columns = new List<string>();
//}
//foreach (var s in Columns)
//{
// if (!First)
// sb.Append(Delimiter);
// else
// First = false;
// sb.Append(dbq + s.Replace(dbq, dbq + dbq) + dbq);
//}
//return sb.ToString();
}
public ActionResult DownloadCareHomes()
{
using (var writer = new System.IO.StreamWriter(Response.OutputStream, Encoding.GetEncoding("Shift-JIS")))
using (var csv = new CsvHelper.CsvWriter(writer))
{
csv.WriteField("事業所ID");
csv.WriteField("事業所名");
csv.WriteField("登録者氏名");
csv.WriteField("登録者メールアドレス");
csv.NextRecord();
foreach (var c in db.CareHomes.Where(h => h.UserId != null && !h.Deactivated && h.Email != null).Include(h => h.User))
{
csv.WriteField(c.CareHomeCode);
csv.WriteField(c.Name);
csv.WriteField(c.User.Name);
csv.WriteField(c.Email);
csv.NextRecord();
}
}
Response.ContentType = "text/csv";
Log(LogType.Admin, "CSVで事業所一覧をダウンロードしました。");
return(null);
}
private string writeSuggestesCategoriesToFile(List <eBayCategoryResult> categoryResults)
{
// create the file to save the product categories
var fileFullPath = string.Format("{0}\\eBaySuggestedCateories_{1:yyyyMMdd_HHmmss}.csv", _systemJobDirectory, DateTime.Now);
// write into the file
using (var streamWriter = new StreamWriter(fileFullPath))
{
var writer = new CsvHelper.CsvWriter(streamWriter);
// let's write first the column's header for the file
writer.WriteField("EisSKU");
for (var i = 1; i <= 10; i++)
{
writer.WriteField(string.Format("eBayCategory{0}", i));
writer.WriteField(string.Format("FullPath{0}", i));
}
// let's move to next row
writer.NextRecord();
// then le't write its content
foreach (var result in categoryResults)
{
writer.WriteField(result.EisSKU);
foreach (var category in result.Categories)
{
writer.WriteField(category.Id);
writer.WriteField(category.OptionName);
}
writer.NextRecord();
}
}
return(fileFullPath);
}
/// <summary>
///
/// </summary>
/// <param name="options"></param>
/// <param name="hits"></param>
private static void PrintHits(Options options, List <Hit> hits)
{
try
{
CsvHelper.CsvWriterOptions csvWriterOptions = SetCsvWriterConfig(options);
using (MemoryStream memoryStream = new MemoryStream())
using (StreamWriter streamWriter = new StreamWriter(memoryStream))
using (CsvHelper.CsvWriter csvWriter = new CsvHelper.CsvWriter(streamWriter, csvWriterOptions))
{
// Write out the file headers
csvWriter.WriteField("Last Modified");
csvWriter.WriteField("Last Update");
csvWriter.WriteField("Path");
csvWriter.WriteField("File Size");
csvWriter.WriteField("Process Exec Flag");
csvWriter.NextRecord();
var sorted = GetSortedHits(options, hits);
foreach (Hit hit in sorted)
{
switch (hit.Type)
{
case Global.CacheType.CacheEntryXp: // Windows XP Shim Cache
csvWriter.WriteField(hit.LastModified.ToShortDateString() + " " + hit.LastModified.ToShortTimeString());
csvWriter.WriteField(hit.LastUpdate.ToShortDateString() + " " + hit.LastUpdate.ToShortTimeString());
csvWriter.WriteField(hit.Path);
csvWriter.WriteField(hit.FileSize.ToString());
csvWriter.WriteField(hit.ProcessExecFlag);
csvWriter.NextRecord();
break;
case Global.CacheType.CacheEntryNt5: // Windows 2k3/Vista/2k8 Shim Cache
case Global.CacheType.CacheEntryNt6: // Windows 7/2k8-R2 Shim Cache
csvWriter.WriteField(hit.LastModified.ToShortDateString() + " " + hit.LastModified.ToShortTimeString());
csvWriter.WriteField("N/A");
csvWriter.WriteField(hit.Path);
csvWriter.WriteField("N/A");
csvWriter.WriteField(hit.ProcessExecFlag);
csvWriter.NextRecord();
break;
}
}
string output = string.Empty;
memoryStream.Position = 0;
using (StreamReader streamReader = new StreamReader(memoryStream))
{
output = streamReader.ReadToEnd();
}
Console.Write(output);
if (options.Output.Length > 0)
{
string ret = IO.WriteUnicodeTextToFile(output, options.Output, false);
if (ret.Length > 0)
{
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("An error occurred: " + ex.Message);
}
}
public ActionResult DownloadCareManagers()
{
using (var writer = new System.IO.StreamWriter(Response.OutputStream, Encoding.GetEncoding("Shift-JIS")))
using (var csv = new CsvHelper.CsvWriter(writer))
{
csv.WriteField("事業所ID");
csv.WriteField("ケアマネID");
csv.WriteField("氏名");
csv.WriteField("登録者メールアドレス");
csv.WriteField("生年月日");
csv.WriteField("性別");
csv.WriteField("資格取得年月日");
csv.NextRecord();
foreach (var m in db.CareManagers.Where(m => m.UserId != null && m.Email != null).Include(m => m.CareHome).Include(m => m.User))
{
csv.WriteField(m.CareHome.CareHomeCode);
csv.WriteField(m.CareManagerId);
csv.WriteField(m.Name);
csv.WriteField(m.Email);
csv.WriteField(m.Birthday);
csv.WriteField(m.Gender);
csv.WriteField(m.Licensed);
//csv.WriteField(m.Licenses);
csv.NextRecord();
}
}
Response.ContentType = "text/csv";
Log(LogType.Admin, "CSVでケアマネ一覧をダウンロードしました。");
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="options"></param>
/// <param name="cacheEntries"></param>
private static void PrintCacheEntries(Options options, List<CacheEntry> cacheEntries)
{
try
{
CsvHelper.CsvWriterOptions csvWriterOptions = SetCsvWriterConfig(options);
using (MemoryStream memoryStream = new MemoryStream())
using (StreamWriter streamWriter = new StreamWriter(memoryStream))
using (CsvHelper.CsvWriter csvWriter = new CsvHelper.CsvWriter(streamWriter, csvWriterOptions))
{
// Write out the file headers
csvWriter.WriteField("File Path");
csvWriter.WriteField("File Name");
csvWriter.WriteField("URL");
csvWriter.WriteField("Codebase IP");
csvWriter.WriteField("Headers");
csvWriter.WriteField("Content Length");
csvWriter.WriteField("Modified");
csvWriter.WriteField("Expiration");
csvWriter.WriteField("Validation");
csvWriter.NextRecord();
var sorted = GetSortedCacheEntries(options, cacheEntries);
StringBuilder text = new StringBuilder();
foreach (CacheEntry cacheEntry in sorted)
{
text.AppendFormat("File Path: {0}{1}", cacheEntry.FilePath, Environment.NewLine);
text.AppendFormat("File Name: {0}{1}", cacheEntry.FileName, Environment.NewLine);
text.AppendFormat("URL: {0}{1}", cacheEntry.Url, Environment.NewLine);
text.AppendFormat("Codebase IP: {0}{1}", cacheEntry.CodebaseIp, Environment.NewLine);
text.AppendFormat("Headers: {1}{0}", cacheEntry.HeadersText, Environment.NewLine);
text.AppendFormat("Content Length: {0}{1}", cacheEntry.ContentLength, Environment.NewLine);
if (cacheEntry.LastModified.Year == 1970 | cacheEntry.LastModified.Year == 0001)
{
text.AppendFormat("Modified: {0}{1}", string.Empty, Environment.NewLine);
}
else
{
text.AppendFormat("Modified: {0}{1}", cacheEntry.LastModified.ToShortDateString() + " " + cacheEntry.LastModified.ToShortTimeString(), Environment.NewLine);
}
if (cacheEntry.ExpirationDate.Year == 1970 | cacheEntry.ExpirationDate.Year == 0001)
{
text.AppendFormat("Expiration: {0}{1}", string.Empty, Environment.NewLine);
}
else
{
text.AppendFormat("Expiration: {0}{1}", cacheEntry.ExpirationDate.ToShortDateString() + " " + cacheEntry.ExpirationDate.ToShortTimeString(), Environment.NewLine);
}
if (cacheEntry.ValidationTimestamp.Year == 1970 | cacheEntry.ValidationTimestamp.Year == 0001)
{
text.AppendFormat("Validation: {0}{1}", string.Empty, Environment.NewLine);
}
else
{
text.AppendFormat("Validation: {0}{1}", cacheEntry.ValidationTimestamp.ToShortDateString() + " " + cacheEntry.ValidationTimestamp.ToShortTimeString(), Environment.NewLine);
}
text.AppendLine(string.Empty);
csvWriter.WriteField(cacheEntry.FilePath);
csvWriter.WriteField(cacheEntry.FileName);
csvWriter.WriteField(cacheEntry.CodebaseIp);
csvWriter.WriteField(cacheEntry.Url);
csvWriter.WriteField(cacheEntry.HeadersText);
csvWriter.WriteField(cacheEntry.ContentLength);
if (cacheEntry.LastModified.Year == 1970 | cacheEntry.LastModified.Year == 0001)
{
csvWriter.WriteField(string.Empty);
}
else
{
csvWriter.WriteField(cacheEntry.LastModified.ToShortDateString() + " " + cacheEntry.LastModified.ToShortTimeString());
}
if (cacheEntry.ExpirationDate.Year == 1970 | cacheEntry.ExpirationDate.Year == 0001)
{
csvWriter.WriteField(string.Empty);
}
else
{
csvWriter.WriteField(cacheEntry.ExpirationDate.ToShortDateString() + " " + cacheEntry.ExpirationDate.ToShortTimeString());
}
if (cacheEntry.ValidationTimestamp.Year == 1970 | cacheEntry.ValidationTimestamp.Year == 0001)
{
csvWriter.WriteField(string.Empty);
}
else
{
csvWriter.WriteField(cacheEntry.ValidationTimestamp.ToShortDateString() + " " + cacheEntry.ValidationTimestamp.ToShortTimeString());
}
csvWriter.NextRecord();
}
string output = string.Empty;
memoryStream.Position = 0;
using (StreamReader streamReader = new StreamReader(memoryStream))
{
output = streamReader.ReadToEnd();
}
Console.Write(text);
if (options.Output.Length > 0)
{
string ret = IO.WriteTextToFile(output, options.Output, false);
if (ret.Length > 0)
{
Console.Write("An error occurred whilst outputting the CSV/TSV file: " + ret);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("An error occurred: " + ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="options"></param>
/// <param name="hits"></param>
private static void PrintHits(Options options, List<Hit> hits)
{
try
{
CsvHelper.CsvWriterOptions csvWriterOptions = SetCsvWriterConfig(options);
using (MemoryStream memoryStream = new MemoryStream())
using (StreamWriter streamWriter = new StreamWriter(memoryStream))
using (CsvHelper.CsvWriter csvWriter = new CsvHelper.CsvWriter(streamWriter, csvWriterOptions))
{
// Write out the file headers
csvWriter.WriteField("Last Modified");
csvWriter.WriteField("Last Update");
csvWriter.WriteField("Path");
csvWriter.WriteField("File Size");
csvWriter.WriteField("Process Exec Flag");
csvWriter.NextRecord();
var sorted = GetSortedHits(options, hits);
foreach (Hit hit in sorted)
{
switch (hit.Type)
{
case Global.CacheType.CacheEntryXp: // Windows XP Shim Cache
csvWriter.WriteField(hit.LastModified.ToShortDateString() + " " + hit.LastModified.ToShortTimeString());
csvWriter.WriteField(hit.LastUpdate.ToShortDateString() + " " + hit.LastUpdate.ToShortTimeString());
csvWriter.WriteField(hit.Path);
csvWriter.WriteField(hit.FileSize.ToString());
csvWriter.WriteField(hit.ProcessExecFlag);
csvWriter.NextRecord();
break;
case Global.CacheType.CacheEntryNt5: // Windows 2k3/Vista/2k8 Shim Cache
case Global.CacheType.CacheEntryNt6: // Windows 7/2k8-R2 Shim Cache
csvWriter.WriteField(hit.LastModified.ToShortDateString() + " " + hit.LastModified.ToShortTimeString());
csvWriter.WriteField("N/A");
csvWriter.WriteField(hit.Path);
csvWriter.WriteField("N/A");
csvWriter.WriteField(hit.ProcessExecFlag);
csvWriter.NextRecord();
break;
}
}
string output = string.Empty;
memoryStream.Position = 0;
using (StreamReader streamReader = new StreamReader(memoryStream))
{
output = streamReader.ReadToEnd();
}
Console.Write(output);
if (options.Output.Length > 0)
{
string ret = IO.WriteUnicodeTextToFile(output, options.Output, false);
if (ret.Length > 0)
{
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("An error occurred: " + ex.Message);
}
}