Class CSVImportEngine

Inheritance

System.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

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: TimeCockpit.Data.Import.CSV

Assembly: TimeCockpit.Data.Import.dll

Syntax

public class CSVImportEngine : ImportEngine

Constructors

CSVImportEngine(DataContext)

Declaration

public CSVImportEngine(DataContext dataContext)

Parameters

Type	Name	Description
DataContext	dataContext

Fields

WorksheetName

Declaration

public static readonly string WorksheetName

Field Value

Type	Description
System.String

Properties

CurrentRowCount

Declaration

public override int CurrentRowCount { get; }

Property Value

Type	Description
System.Int32

Overrides

ImportEngine.CurrentRowCount

Methods

FetchUpdateKeys(ImportColumnDefinition[], ModelEntityBase, Int32)

Declaration

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

Parameters

Type	Name	Description
ImportColumnDefinition[]	keyColumns
ModelEntityBase	targetEntity
System.Int32	defaultHeaderRowNumber

Returns

Type	Description
System.Collections.Generic.Dictionary<System.Int32, System.String>

Overrides

ImportEngine.FetchUpdateKeys(ImportColumnDefinition[], ModelEntityBase, Int32)

GetCellKeyValue(ImportColumnDefinition)

Declaration

public override object GetCellKeyValue(ImportColumnDefinition column)

Parameters

Type	Name	Description
ImportColumnDefinition	column

Returns

Type	Description
System.Object

Overrides

ImportEngine.GetCellKeyValue(ImportColumnDefinition)

GetCellValue(ImportColumnDefinition)

Declaration

public override object GetCellValue(ImportColumnDefinition column)

Parameters

Type	Name	Description
ImportColumnDefinition	column

Returns

Type	Description
System.Object

Overrides

ImportEngine.GetCellValue(ImportColumnDefinition)

GetReportData()

Declaration

public override byte[] GetReportData()

Returns

Type	Description
System.Byte[]

Overrides

ImportEngine.GetReportData()

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

Declaration

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

Parameters

Type	Name	Description
System.String	definitionName
System.DateTime	exportTimestamp
System.String	filename
System.String	mimeType

Overrides

ImportEngine.GetReportMetadata(String, DateTime, out String, out String)

GetSourceMetadata(out String, out String)

Declaration

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

Parameters

Type	Name	Description
System.String	filename
System.String	mimeType

Overrides

ImportEngine.GetSourceMetadata(out String, out String)

HasMoreRows()

Declaration

public override bool HasMoreRows()

Returns

Type	Description
System.Boolean

Overrides

ImportEngine.HasMoreRows()

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

Declaration

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

Parameters

Type	Name	Description
System.Int32	sampleSize
System.Byte[]	sourceData
System.Collections.Generic.Dictionary<System.String, System.Int32>	headerRowNumbers
System.Int32	defaultHeaderRowNumber

Returns

Type	Description
PreviewWorkbook

Overrides

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

MoveToNextRow()

Declaration

public override void MoveToNextRow()

Overrides

ImportEngine.MoveToNextRow()

PrepareImportSheet(ImportSheetDefinition)

Declaration

public override bool PrepareImportSheet(ImportSheetDefinition sheet)

Parameters

Type	Name	Description
ImportSheetDefinition	sheet

Returns

Type	Description
System.Boolean

Overrides

ImportEngine.PrepareImportSheet(ImportSheetDefinition)

PrepareImportWorkbook(ImportBookDefinition)

Declaration

public override bool PrepareImportWorkbook(ImportBookDefinition book)

Parameters

Type	Name	Description
ImportBookDefinition	book

Returns

Type	Description
System.Boolean

Overrides

ImportEngine.PrepareImportWorkbook(ImportBookDefinition)

SavePreviewData(PreviewWorkbook)

Declaration

public override byte[] SavePreviewData(PreviewWorkbook previewWorkbook)

Parameters

Type	Name	Description
PreviewWorkbook	previewWorkbook

Returns

Type	Description
System.Byte[]

Overrides

ImportEngine.SavePreviewData(PreviewWorkbook)

SetRowMessage(ImportSheetDefinition, String, Boolean, Boolean)

Declaration

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

Parameters

Type	Name	Description
ImportSheetDefinition	sheetDefinition
System.String	text
System.Boolean	isError
System.Boolean	isModification

Overrides

ImportEngine.SetRowMessage(ImportSheetDefinition, String, Boolean, Boolean)