Class CSVImportEngine

Namespace

TimeCockpit.Data.Import.CSV

Assembly

TimeCockpit.Data.Import.dll

public class CSVImportEngine : ImportEngine

Inheritance

Object

ImportEngine

CSVImportEngine

Inherited Members

ImportEngine.FormatStatusMessage(Int32, Boolean)

ImportEngine.PreprocessValue(DataContext, ModelEntityBase, ImportColumnDefinition, Object)

ImportEngine.PerformPostProcessExpressions(DataContext, EntityObject, IEnumerable<ImportColumnDefinition>, Boolean)

ImportEngine.PerformImport(ImportBookDefinition, Boolean, Byte[], String, Guid, Nullable<Guid>, Nullable<CancellationToken>)

ImportEngine.ImportSheet(ImportSheetDefinition)

ImportEngine.ImportRow(ImportColumnDefinition[], EntityObject, Boolean)

ImportEngine.GetKeyValue(DataContext, ModelEntityBase, Dictionary<ImportColumnDefinition, Int32>, ImportColumnDefinition, Dictionary<ImportColumnDefinition, ModelProperty>, Object)

ImportEngine.TryFindRelation(ImportColumnDefinition, Relation, String, Boolean, EntityObject)

ImportEngine.TrySetProperty(ImportColumnDefinition, ModelProperty, EntityObject, Object)

ImportEngine.IsCellEmpty(Object)

ImportEngine.GetCellValueString(Object, String)

ImportEngine.GetCellValueDateTime(Object, DateTime)

ImportEngine.GetCellValueGuid(Object, Guid)

ImportEngine.GetCellValueDecimal(Object, Decimal)

ImportEngine.GetCellValueBoolean(Object, Boolean)

ImportEngine.AddMessage(ImportMessage.Kind, String)

ImportEngine.AddMessage(Exception)

ImportEngine.ImportColumn(ImportColumnDefinition, Object, EntityObject, Boolean)

ImportEngine.MessageCount

ImportEngine.SourceFileName

ImportEngine.OriginalSource

ImportEngine.DataContext

ImportEngine.DefinitionName

ImportEngine.OnProgress

ImportEngine.OnMessage

ImportEngine.OnReportFinished

ImportEngine.OnEntityObjectSaved

Object.ToString()

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Constructors

CSVImportEngine(DataContext)

public CSVImportEngine(DataContext dataContext)

Parameters

dataContext DataContext

Fields

WorksheetName

public static readonly string WorksheetName

Field Value

String

Properties

CurrentRowCount

public override int CurrentRowCount { get; }

Property Value

Int32

Methods

FetchUpdateKeys(ImportColumnDefinition[], ModelEntityBase, Int32)

protected override Dictionary<int, string> FetchUpdateKeys(ImportColumnDefinition[] keyColumns, ModelEntityBase targetEntity, int defaultHeaderRowNumber = 1)

Parameters

keyColumns ImportColumnDefinition[]

targetEntity ModelEntityBase

defaultHeaderRowNumber Int32

Returns

Dictionary<Int32, String>

GetCellKeyValue(ImportColumnDefinition)

public override object GetCellKeyValue(ImportColumnDefinition column)

Parameters

column ImportColumnDefinition

Returns

Object

GetCellValue(ImportColumnDefinition)

public override object GetCellValue(ImportColumnDefinition column)

Parameters

column ImportColumnDefinition

Returns

Object

GetReportData()

public override byte[] GetReportData()

Returns

Byte[]

GetReportMetadata(String, DateTime, out String, out String)

public override void GetReportMetadata(string definitionName, DateTime exportTimestamp, out string filename, out string mimeType)

Parameters

definitionName String

exportTimestamp DateTime

filename String

mimeType String

GetSourceMetadata(out String, out String)

public override void GetSourceMetadata(out string filename, out string mimeType)

Parameters

filename String

mimeType String

HasMoreRows()

public override bool HasMoreRows()

Returns

Boolean

LoadPreviewData(Int32, Byte[], Dictionary<String, Int32>, Int32)

public override PreviewWorkbook LoadPreviewData(int sampleSize, byte[] sourceData, Dictionary<string, int> headerRowNumbers = null, int defaultHeaderRowNumber = 1)

Parameters

sampleSize Int32

sourceData Byte[]

headerRowNumbers Dictionary<String, Int32>

defaultHeaderRowNumber Int32

Returns

PreviewWorkbook

MoveToNextRow()

public override void MoveToNextRow()

PrepareImportSheet(ImportSheetDefinition)

public override bool PrepareImportSheet(ImportSheetDefinition sheet)

Parameters

sheet ImportSheetDefinition

Returns

Boolean

PrepareImportWorkbook(ImportBookDefinition)

public override bool PrepareImportWorkbook(ImportBookDefinition book)

Parameters

book ImportBookDefinition

Returns

Boolean

SavePreviewData(PreviewWorkbook)

public override byte[] SavePreviewData(PreviewWorkbook previewWorkbook)

Parameters

previewWorkbook PreviewWorkbook

Returns

Byte[]

SetRowMessage(ImportSheetDefinition, String, Boolean, Boolean)

public override void SetRowMessage(ImportSheetDefinition sheetDefinition, string text, bool isError, bool isModification)

Parameters

sheetDefinition ImportSheetDefinition

text String

isError Boolean

isModification Boolean