Excel Import

This page was generated by EarthCape v 20.4.84.0 based on database on 2020.9.4.

Import from Excel/csv files is performed through defining and reusing column map templates. Templates are stored as database records and are accessible to all users with enough security permissions. Access them under Settings/Excel Import section. More info

All fields

Dropped Files (field: DroppedFiles, type: DroppedFile **)
Auto Imported Files (field: AutoImportedFiles, type: AutoImportedFile **)
Import Strategy (field: ImportStrategy, type: ImportStrategy Controls how main objects are created)
Abort Threshold (field: AbortThreshold, type: Int32] **)
Header Rows (field: HeaderRows, type: Int32 **)
Validation Contexts (field: ValidationContexts, type: String **)
Auto Import From (field: AutoImportFrom, type: String **)
Auto Import Regex (field: AutoImportRegex, type: String **)
Name (field: Name, type: String **)
Sheet Name (field: SheetName, type: String **)
Column Mapping Regex Pattern (field: ColumnMappingRegexPattern, type: String **)
File (field: File, type: XpandFileData **)
Excel Column Maps (field: ExcelColumnMaps, type: ExcelColumnMap **)
Type (field: Type, type: Type **)
Failed Results (field: FailedResults, type: FailedImportResult **)
Column Mapping Replacement (field: ColumnMappingReplacement, type: String **)
Stop Auto Import On Failure (field: StopAutoImportOnFailure, type: Boolean **)
Auto Import Search Type (field: AutoImportSearchType, type: SearchOption **)
Auto Import Notification (field: AutoImportNotification, type: AutoImportNotification **)

Collections

Key Maps (collection: KeyMaps, type: ExcelImportKeyMap **)

ListView: Excel Import

Visible

Name (field: Name, type: String **)
Sheet Name (field: SheetName, type: String **)
Abort Threshold (field: AbortThreshold, type: Int32] **)

Hidden

Auto Import From (field: AutoImportFrom, type: String **)
Auto Import Notification (field: AutoImportNotification, type: AutoImportNotification **)
Auto Import Regex (field: AutoImportRegex, type: String **)
Auto Import Search Type (field: AutoImportSearchType, type: SearchOption **)
Column Mapping Regex Pattern (field: ColumnMappingRegexPattern, type: String **)
Column Mapping Replacement (field: ColumnMappingReplacement, type: String **)
File (field: File, type: XpandFileData **)
Header Rows (field: HeaderRows, type: Int32 **)
Import Strategy (field: ImportStrategy, type: ImportStrategy Controls how main objects are created)
Stop Auto Import On Failure (field: StopAutoImportOnFailure, type: Boolean **)
Type (field: Type, type: Type **)
Validation Contexts (field: ValidationContexts, type: String **)

DetailView: Excel Import

Abort Threshold (datafield: AbortThreshold, type: Nullable`1 )
Auto Imported Files (datafield: AutoImportedFiles, type: XPCollection`1 )
Auto Import From (datafield: AutoImportFrom, type: String )
Auto Import Notification (datafield: AutoImportNotification, type: AutoImportNotification )
Auto Import Regex (datafield: AutoImportRegex, type: String )
Auto Import Search Type (datafield: AutoImportSearchType, type: SearchOption )
Column Mapping Regex Pattern (datafield: ColumnMappingRegexPattern, type: String )
Column Mapping Replacement (datafield: ColumnMappingReplacement, type: String )
Dropped Files (datafield: DroppedFiles, type: XPCollection`1 )
Excel Column Maps (datafield: ExcelColumnMaps, type: XPCollection`1 )
Failed Results (datafield: FailedResults, type: XPCollection`1 )
File (datafield: File, type: XpandFileData )
Header Rows (datafield: HeaderRows, type: Int32 )
Import Strategy (datafield: ImportStrategy, type: ImportStrategy Controls how main objects are created)
Key Maps (datafield: KeyMaps, type: XPCollection`1 )
Name (datafield: Name, type: String )
Sheet Name (datafield: SheetName, type: String )
Stop Auto Import On Failure (datafield: StopAutoImportOnFailure, type: Boolean )
Type (datafield: Type, type: Type )
Validation Contexts (datafield: ValidationContexts, type: String )