Class ColumnMapping

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

Mapping shows which column from the source goes to which column in the destination.

public class ColumnMapping

Inheritance

object

ColumnMapping

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

ColumnMapping()

protected ColumnMapping()

ColumnMapping(Column, Column, int, bool)

Initializes a new instance of the ColumnMapping class.

public ColumnMapping(Column sourceColumn, Column destinationColumn, int id, bool iskey = false)

Parameters

sourceColumn Column

The source column.

destinationColumn Column

The destination column.

id int

The id.

iskey bool

if set to true [iskey].

ColumnMapping(Column, Column, int, bool, bool)

public ColumnMapping(Column sourceColumn, Column destinationColumn, int id, bool iskey, bool useCodeExtension)

Parameters

sourceColumn Column

destinationColumn Column

id int

iskey bool

useCodeExtension bool

ColumnMapping(XmlNode, ISource, IDestination, Table, Table, int)

Initializes a new instance of the ColumnMapping class from an XML node. This constructor parses the output created by the method saveAsXML()

public ColumnMapping(XmlNode xmlNode, ISource source, IDestination destination, Table sourceTable, Table destinationTable, int id)

Parameters

xmlNode XmlNode

The XML node.

source ISource

The source.

destination IDestination

The destination.

sourceTable Table

The source table.

destinationTable Table

The destination table.

id int

The id.

Fields

ScriptType

Defines if scripting for this mapping is static, append, prepend, or none.

public ScriptType ScriptType

Field Value

ScriptType

ScriptValue

defines the value to be added if ScriptType is anything other than "none".

public string ScriptValue

Field Value

string

ScriptValueForInsert

defines whether to use Script value only on insert new rows and skip on update

public bool ScriptValueForInsert

Field Value

bool

Properties

Active

Gets or sets a value indicating whether this ColumnMapping is active.

public virtual bool Active { get; set; }

Property Value

bool

true if active; otherwise, false.

Comment

public string Comment { get; set; }

Property Value

string

DestinationColumn

Gets or sets the destination column.

public virtual Column DestinationColumn { get; set; }

Property Value

Column

The destination column.

FormatCulture

public string FormatCulture { get; set; }

Property Value

string

HasScriptWithValue

public bool HasScriptWithValue { get; }

Property Value

bool

IsKey

Gets or sets a value indicating whether this column mapping is a primary key.

public virtual bool IsKey { get; set; }

Property Value

bool

true if this column mapping is key; otherwise, false.

Mapping

public Mapping Mapping { get; }

Property Value

Mapping

NullEmptyActionType

Null or empty source column value handling type

public NullEmptyActionType NullEmptyActionType { get; set; }

Property Value

NullEmptyActionType

NullEmptyActionValue

The value to use instead of the null or empty source column value

public string NullEmptyActionValue { get; set; }

Property Value

string

OriginalDestinationColumnName

The is used to store the original destination column name fetched from the job file when the destination table does not exists

public string OriginalDestinationColumnName { get; set; }

Property Value

string

OriginalSourceColumnName

The is used to store the original source column name fetched from the job file when the source table does not exists

public string OriginalSourceColumnName { get; set; }

Property Value

string

Sort

public int Sort { get; set; }

Property Value

int

SourceColumn

Gets or sets the source column.

public virtual Column SourceColumn { get; set; }

Property Value

Column

The source column.

UseCodeExtension

public bool UseCodeExtension { get; set; }

Property Value

bool

Methods

ConvertInputValueToOutputValue(object)

public object ConvertInputValueToOutputValue(object inputObject)

Parameters

inputObject object

Returns

object

GetId()

Gets the id of the mapping.

public int GetId()

Returns

int

GetScriptValue()

public string GetScriptValue()

Returns

string