public static CsvReader CreateCsvReaderInstance(Stream CSVFileStream, ImportCSVSettings importCsvSettings)
{
var result = new CsvReader(
new StreamReader(CSVFileStream, importCsvSettings.Encoding, true),
importCsvSettings.HasHeader, importCsvSettings.DelimiterCharacter, importCsvSettings.QuoteType, '"', '#', ValueTrimmingOptions.UnquotedOnly) { SkipEmptyLines = true, SupportsMultiline = true, DefaultParseErrorAction = ParseErrorAction.AdvanceToNextLine, MissingFieldAction = MissingFieldAction.ReplaceByEmpty };
return result;
}
public static CsvReader CreateCsvReaderInstance(Stream CSVFileStream, ImportCSVSettings importCsvSettings)
{
var result = new CsvReader(
new StreamReader(CSVFileStream, importCsvSettings.Encoding, true),
importCsvSettings.HasHeader, importCsvSettings.DelimiterCharacter, importCsvSettings.QuoteType, '"', '#', ValueTrimmingOptions.UnquotedOnly)
{
SkipEmptyLines = true, SupportsMultiline = true, DefaultParseErrorAction = ParseErrorAction.AdvanceToNextLine, MissingFieldAction = MissingFieldAction.ReplaceByEmpty
};
return(result);
}
public void Configure(EntityType entityType,
string CSVFileURI,
string importSettingsJSON)
{
_entityType = entityType;
_csvFileURI = CSVFileURI;
if (!String.IsNullOrEmpty(importSettingsJSON))
{
_importSettings = new ImportCSVSettings(importSettingsJSON);
}
_IsConfigure = true;
}
public static String GetRow(Stream CSVFileStream, int index, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
using (CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings))
{
int countRows = 0;
index++;
while (countRows++ != index && csv.ReadNextRecord()) ;
return new JObject(new JProperty("data", new JArray(csv.GetCurrentRowFields(false).ToArray())),
new JProperty("isMaxIndex", csv.EndOfStream)).ToString();
}
}
public ImportDataOperation(EntityType entityType, String CSVFileURI, String importSettingsJSON)
{
_CSVFileURI = CSVFileURI;
_dataStore = Global.GetStore();
_tenantID = TenantProvider.CurrentTenantID;
_daoFactory = Global.DaoFactory;
_entityType = entityType;
Id = String.Format("{0}_{1}", TenantProvider.CurrentTenantID, (int)_entityType);
_log = LogManager.GetLogger("ASC.CRM");
if (!String.IsNullOrEmpty(importSettingsJSON))
{
_importSettings = new ImportCSVSettings(importSettingsJSON);
}
}
public ImportDataOperation(EntityType entityType, String CSVFileURI, String importSettingsJSON)
{
_CSVFileURI = CSVFileURI;
_dataStore = Global.GetStore();
_tenantID = TenantProvider.CurrentTenantID;
_daoFactory = Global.DaoFactory;
_entityType = entityType;
_author = SecurityContext.CurrentAccount;
_notifyClient = NotifyClient.Instance;
Id = String.Format("{0}_{1}", TenantProvider.CurrentTenantID, (int)_entityType);
_log = LogManager.GetLogger("ASC.CRM");
if (!String.IsNullOrEmpty(importSettingsJSON))
_importSettings = new ImportCSVSettings(importSettingsJSON);
}
public static String GetRow(Stream CSVFileStream, int index, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
using (CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings))
{
int countRows = 0;
index++;
while (countRows++ != index && csv.ReadNextRecord())
{
;
}
return(new JObject(new JProperty("data", new JArray(csv.GetCurrentRowFields(false).ToArray())),
new JProperty("isMaxIndex", csv.EndOfStream)).ToString());
}
}
public ImportDataOperation(EntityType entityType, String CSVFileURI, String importSettingsJSON)
{
_CSVFileURI = CSVFileURI;
_dataStore = Global.GetStore();
_tenantID = TenantProvider.CurrentTenantID;
_entityType = entityType;
_author = SecurityContext.CurrentAccount;
_notifyClient = NotifyClient.Instance;
Id = String.Format("{0}_{1}", TenantProvider.CurrentTenantID, (int)_entityType);
_log = LogManager.GetLogger("ASC.CRM");
if (!String.IsNullOrEmpty(importSettingsJSON))
{
_importSettings = new ImportCSVSettings(importSettingsJSON);
}
}
public String GetRow(Stream CSVFileStream, int index, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings);
int countRows = 0;
index++;
while (countRows++ != index && csv.ReadNextRecord())
{
;
}
return(JsonSerializer.Serialize(new
{
data = csv.GetCurrentRowFields(false).ToArray(),
isMaxIndex = csv.EndOfStream
}));
}
public static JObject GetInfo(Stream CSVFileStream, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
using (CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings))
{
csv.ReadNextRecord();
var firstRowFields = csv.GetCurrentRowFields(false);
String[] headerRowFields = csv.GetFieldHeaders().ToArray();
if (!importCSVSettings.HasHeader)
headerRowFields = firstRowFields;
return new JObject(
new JProperty("headerColumns", new JArray(headerRowFields)),
new JProperty("firstContactFields", new JArray(firstRowFields)),
new JProperty("isMaxIndex", csv.EndOfStream)
);
}
}
public static JObject GetInfo(Stream CSVFileStream, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
using (CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings))
{
csv.ReadNextRecord();
var firstRowFields = csv.GetCurrentRowFields(false);
String[] headerRowFields = csv.GetFieldHeaders().ToArray();
if (!importCSVSettings.HasHeader)
{
headerRowFields = firstRowFields;
}
return(new JObject(
new JProperty("headerColumns", new JArray(headerRowFields)),
new JProperty("firstContactFields", new JArray(firstRowFields)),
new JProperty("isMaxIndex", csv.EndOfStream)
));
}
}
public JsonDocument GetInfo(Stream CSVFileStream, String jsonSettings)
{
var importCSVSettings = new ImportCSVSettings(jsonSettings);
CsvReader csv = CreateCsvReaderInstance(CSVFileStream, importCSVSettings);
csv.ReadNextRecord();
var firstRowFields = csv.GetCurrentRowFields(false);
String[] headerRowFields = csv.GetFieldHeaders().ToArray();
if (!importCSVSettings.HasHeader)
{
headerRowFields = firstRowFields;
}
return(JsonDocument.Parse(JsonSerializer.Serialize(new
{
headerColumns = headerRowFields,
firstContactFields = firstRowFields,
isMaxIndex = csv.EndOfStream
})));
}