clsImportBase Class |
Base class for all import core data classes. Manages the Import and Validation Process.
Inheritance HierarchyNamespace: MARIInterface
Assembly: MARIInterface (in MARIInterface.dll) Version: 8.0.0.100
SyntaxThe clsImportBase type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | clsImportBase |
The constructor will create a clsErrors class to store all errors or messages per object.
|
Properties| Name | Description | |
|---|---|---|
 | EXPORT_INFO | Special column during the export for better understanding in the excel file. Not used for import |
| EXTERNAL_Key1 |
This field is free to use for your own refrence. Not used by MARIInterface
|
| EXTERNAL_Key2 |
This field is free to use for your own refrence. Not used by MARIInterface
|
| IMPORT_ErrorMessage |
Stores the validation messages
|
| IMPORT_Feedback |
Indicates the feedback of the import process
|
| oErrors | |
| UserDefinedFieldValues |
Stored the value for the user defined fields. Use SetUserDefinedFieldValue(String, Object) to fill the data.
|
Methods| Name | Description | |
|---|---|---|
 | bIsNil | |
| bReadFromDB |
Reading from the MARIProject Database into the clsImport...Class. (Used to save the data into the Access database)
Only for internal use !! For reading data please use your own SQL !
|
| bSaveRSToMDB |
This function will save the content of the class in to the MS Access mdb database table
|
| bValidateAndRemove |
For some selected dimensions, removing the master data is implemented
|
| bValidateClassNumber |
Checks the given class number whether the key string conforms the MARIProject settings i.e. Project number, Employee number etc.
|
| GetListUserDefinedFields |
Returns the user defined field for the master data dimensions. The fields have to be defined directly in MARIProject.
|
| GetUserDefinedFieldValue | |
| PrintChangeValues |
For debugging, shows the properties set.
|
| SetUserDefinedFieldValue |
Stores a value for the user defined field for the import. User GetListUserDefinedFields to get all fields.
|
| sGetClassNummer |
Create new identifier for employees, projects.. based on a given filter like "M1*"
|
| sGetFreeClassNummer |
Creates a new class number i.e. Project, Employee etc. considering the identifier format.
|
| sKeyMatchcode | |
| ValidateUser |
See AlsoReference
Inheritance HierarchySystemObject
MARIInterfaceclsImportBase
MARIInterfaceclsImportAttendanceDayActivity
MARIInterfaceclsImportBaseERP
MARIInterfaceclsImportBook
MARIInterfaceclsImportBookPage
MARIInterfaceclsImportBookPageElementBase
MARIInterfaceclsImportBPAuditPlan
MARIInterfaceclsImportBPAuditTask
MARIInterfaceclsImportBPAuditTemplate
MARIInterfaceclsImportBPGroup
MARIInterfaceclsImportClassNotification
MARIInterfaceclsImportClassNotificationText
MARIInterfaceclsImportClassNotificationTextLang
MARIInterfaceclsImportCommissionInitial
MARIInterfaceclsImportContractAnzahlungen
MARIInterfaceclsImportCustomerLocationTree
MARIInterfaceclsImportCustomerLocationTreeElement
MARIInterfaceclsImportCustomerServiceObject
MARIInterfaceclsImportCustomerServiceObjectCategory
MARIInterfaceclsImportCustomerServiceObjectLocation
MARIInterfaceclsImportCustomerServiceObjectPart
MARIInterfaceclsImportDocument
MARIInterfaceclsImportDraftDocument
MARIInterfaceclsImportDraftDocumentPos
MARIInterfaceclsImportDraftDocumentPosLink
MARIInterfaceclsImportEmail
MARIInterfaceclsImportEMailAttachment
MARIInterfaceclsImportEmployee
MARIInterfaceclsImportEmployeeAbsence
MARIInterfaceclsImportEmployeeAbsenceLine
MARIInterfaceclsImportEmployeeAnnualVacation
MARIInterfaceclsImportEmployeeCostRates
MARIInterfaceclsImportEmployeeCostRatesProject
MARIInterfaceclsImportEmployeeMaster
MARIInterfaceclsImportEmployeeOrganisation
MARIInterfaceclsImportEmployeePeriod
MARIInterfaceclsImportEmployeePoolLink
MARIInterfaceclsImportEmployeeProjectLink
MARIInterfaceclsImportEmployeeServiceLink
MARIInterfaceclsImportEmployeeSkillLink
MARIInterfaceclsImportEmployeesTravelMilage
MARIInterfaceclsImportEquipmentBookings
MARIInterfaceclsImportEquipmentCategory
MARIInterfaceclsImportEquipmentCategoryBPCatalog
MARIInterfaceclsImportEquipmentCategoryPart
MARIInterfaceclsImportEquipmentCategorySubject
MARIInterfaceclsImportEquipmentCategorySubjectRate
MARIInterfaceclsImportEquipmentLocation
MARIInterfaceclsImportEquipmentMaster
MARIInterfaceclsImportEquipmentMasterAssemblyLink
MARIInterfaceclsImportEquipmentMasterPart
MARIInterfaceclsImportERPDocument
MARIInterfaceclsImportERPProfitCenterclsImportERPProfitCenter
MARIInterfaceclsImportERPProjectCode
MARIInterfaceclsImportExchangeRateForPlanning
MARIInterfaceclsImportExchangeRateSBO
MARIInterfaceclsImportFile
MARIInterfaceclsImportGroups
MARIInterfaceclsImportItemBooking
MARIInterfaceclsImportKnowledgeBaseEntry
MARIInterfaceclsImportKnowledgeBaseEntryLanguage
MARIInterfaceclsImportLine
MARIInterfaceclsImportMARIUser
MARIInterfaceclsImportNewsletterMaster
MARIInterfaceclsImportPayment
MARIInterfaceclsImportPhase
MARIInterfaceclsImportPhasePredecessor
MARIInterfaceclsImportPlanning
MARIInterfaceclsImportProject
MARIInterfaceclsImportProjectContract
MARIInterfaceclsImportProjectContractPosition
MARIInterfaceclsImportProjectContractPositionAccountingPos
MARIInterfaceclsImportProjectGroups
MARIInterfaceclsImportQualification
MARIInterfaceclsImportQualificationPlan
MARIInterfaceclsImportQualificationTask
MARIInterfaceclsImportQualityProcess
MARIInterfaceclsImportQualityProcessQuestion
MARIInterfaceclsImportQualityProcessQuestionLimits
MARIInterfaceclsImportResourcePool
MARIInterfaceclsImportResourcePoolCostRates
MARIInterfaceclsImportSalesContractDocument
MARIInterfaceclsImportSalesContractDocumentPositionBatch
MARIInterfaceclsImportSalesContractDocumentPositions
MARIInterfaceclsImportSalesContractDocumentPositionSerialNumber
MARIInterfaceclsImportService
MARIInterfaceclsImportServicePoolLink
MARIInterfaceclsImportServicePosition
MARIInterfaceclsImportSetupBUSettings
MARIInterfaceclsImportSetupBUSettingsMatrix
MARIInterfaceclsImportSetupBusinessUnits
MARIInterfaceclsImportSetupCompanySettings
MARIInterfaceclsImportSetupFormRights
MARIInterfaceclsImportSetupMenuRights
MARIInterfaceclsImportSetupUserGroups
MARIInterfaceclsImportSkill
MARIInterfaceclsImportSupportIssue
MARIInterfaceclsImportSupportIssueAttachment
MARIInterfaceclsImportSysCustomerLanguages
MARIInterfaceclsImportSysCustomerLanguagesCompany
MARIInterfaceclsImportSysMasterProperties
MARIInterfaceclsImportSysMasterPropertyLink
MARIInterfaceclsImportSysMasterPropertyStack
MARIInterfaceclsImportSysUserQueryGroup
MARIInterfaceclsImportTenantAction
MARIInterfaceclsImportTenantBatchLog
MARIInterfaceclsImportTenantCustomer
MARIInterfaceclsImportTenantDatabase
MARIInterfaceclsImportTenantEnvironment
MARIInterfaceclsImportTenantMonitorAppInstallation
MARIInterfaceclsImportTenantMonitorAppUser
MARIInterfaceclsImportTenantMonitorAppUserGroup
MARIInterfaceclsImportTenantMonitorDatabase
MARIInterfaceclsImportTenantMonitorEnvironment
MARIInterfaceclsImportTenantMonitorMachine
MARIInterfaceclsImportTenantMonitorSysLogDebug
MARIInterfaceclsImportTenantUser
MARIInterfaceclsImportTenantUsersDBLink
MARIInterfaceclsImportTextModules
MARIInterfaceclsImportTrainingParticipant
MARIInterfaceclsImportTrainingRegistration
MARIInterfaceclsImportTrainingRegistrationContractLink
MARIInterfaceclsImportTrainingRegistrationOptionLink
MARIInterfaceclsImportTravelCategory
MARIInterfaceclsImportTravelCategoryAccount
MARIInterfaceclsImportUserDefinedField
MARIInterfaceclsImportWorkItemPosBase
MARIInterfaceclsImportWorkitemResBase
MARIInterfaceclsImportWorkItemScheduleDatesBase
MARIInterfaceclsImportWorkItemServicePlan
MARIInterfaceclsImportWorkItemServicePlanTemplate
MARIInterfaceclsImportWorkItemServicePlanTemplatePosition
MARIInterfaceclsImportWorkItemServiceTask
MARIInterfaceclsImportWorkItemServiceTaskResults
MARIInterfaceclsImportWorkItemServiceTaskStatus
MARIInterfaceclsImportWorkItemTrainingCourse
MARIInterfaceclsImportWorkItemTrainingOption
MARIInterfaceclsImportBase
MARIInterfaceclsImportAttendanceDayActivity
MARIInterfaceclsImportBaseERP
MARIInterfaceclsImportBook
MARIInterfaceclsImportBookPage
MARIInterfaceclsImportBookPageElementBase
MARIInterfaceclsImportBPAuditPlan
MARIInterfaceclsImportBPAuditTask
MARIInterfaceclsImportBPAuditTemplate
MARIInterfaceclsImportBPGroup
MARIInterfaceclsImportClassNotification
MARIInterfaceclsImportClassNotificationText
MARIInterfaceclsImportClassNotificationTextLang
MARIInterfaceclsImportCommissionInitial
MARIInterfaceclsImportContractAnzahlungen
MARIInterfaceclsImportCustomerLocationTree
MARIInterfaceclsImportCustomerLocationTreeElement
MARIInterfaceclsImportCustomerServiceObject
MARIInterfaceclsImportCustomerServiceObjectCategory
MARIInterfaceclsImportCustomerServiceObjectLocation
MARIInterfaceclsImportCustomerServiceObjectPart
MARIInterfaceclsImportDocument
MARIInterfaceclsImportDraftDocument
MARIInterfaceclsImportDraftDocumentPos
MARIInterfaceclsImportDraftDocumentPosLink
MARIInterfaceclsImportEmail
MARIInterfaceclsImportEMailAttachment
MARIInterfaceclsImportEmployee
MARIInterfaceclsImportEmployeeAbsence
MARIInterfaceclsImportEmployeeAbsenceLine
MARIInterfaceclsImportEmployeeAnnualVacation
MARIInterfaceclsImportEmployeeCostRates
MARIInterfaceclsImportEmployeeCostRatesProject
MARIInterfaceclsImportEmployeeMaster
MARIInterfaceclsImportEmployeeOrganisation
MARIInterfaceclsImportEmployeePeriod
MARIInterfaceclsImportEmployeePoolLink
MARIInterfaceclsImportEmployeeProjectLink
MARIInterfaceclsImportEmployeeServiceLink
MARIInterfaceclsImportEmployeeSkillLink
MARIInterfaceclsImportEmployeesTravelMilage
MARIInterfaceclsImportEquipmentBookings
MARIInterfaceclsImportEquipmentCategory
MARIInterfaceclsImportEquipmentCategoryBPCatalog
MARIInterfaceclsImportEquipmentCategoryPart
MARIInterfaceclsImportEquipmentCategorySubject
MARIInterfaceclsImportEquipmentCategorySubjectRate
MARIInterfaceclsImportEquipmentLocation
MARIInterfaceclsImportEquipmentMaster
MARIInterfaceclsImportEquipmentMasterAssemblyLink
MARIInterfaceclsImportEquipmentMasterPart
MARIInterfaceclsImportERPDocument
MARIInterfaceclsImportERPProfitCenterclsImportERPProfitCenter
MARIInterfaceclsImportERPProjectCode
MARIInterfaceclsImportExchangeRateForPlanning
MARIInterfaceclsImportExchangeRateSBO
MARIInterfaceclsImportFile
MARIInterfaceclsImportGroups
MARIInterfaceclsImportItemBooking
MARIInterfaceclsImportKnowledgeBaseEntry
MARIInterfaceclsImportKnowledgeBaseEntryLanguage
MARIInterfaceclsImportLine
MARIInterfaceclsImportMARIUser
MARIInterfaceclsImportNewsletterMaster
MARIInterfaceclsImportPayment
MARIInterfaceclsImportPhase
MARIInterfaceclsImportPhasePredecessor
MARIInterfaceclsImportPlanning
MARIInterfaceclsImportProject
MARIInterfaceclsImportProjectContract
MARIInterfaceclsImportProjectContractPosition
MARIInterfaceclsImportProjectContractPositionAccountingPos
MARIInterfaceclsImportProjectGroups
MARIInterfaceclsImportQualification
MARIInterfaceclsImportQualificationPlan
MARIInterfaceclsImportQualificationTask
MARIInterfaceclsImportQualityProcess
MARIInterfaceclsImportQualityProcessQuestion
MARIInterfaceclsImportQualityProcessQuestionLimits
MARIInterfaceclsImportResourcePool
MARIInterfaceclsImportResourcePoolCostRates
MARIInterfaceclsImportSalesContractDocument
MARIInterfaceclsImportSalesContractDocumentPositionBatch
MARIInterfaceclsImportSalesContractDocumentPositions
MARIInterfaceclsImportSalesContractDocumentPositionSerialNumber
MARIInterfaceclsImportService
MARIInterfaceclsImportServicePoolLink
MARIInterfaceclsImportServicePosition
MARIInterfaceclsImportSetupBUSettings
MARIInterfaceclsImportSetupBUSettingsMatrix
MARIInterfaceclsImportSetupBusinessUnits
MARIInterfaceclsImportSetupCompanySettings
MARIInterfaceclsImportSetupFormRights
MARIInterfaceclsImportSetupMenuRights
MARIInterfaceclsImportSetupUserGroups
MARIInterfaceclsImportSkill
MARIInterfaceclsImportSupportIssue
MARIInterfaceclsImportSupportIssueAttachment
MARIInterfaceclsImportSysCustomerLanguages
MARIInterfaceclsImportSysCustomerLanguagesCompany
MARIInterfaceclsImportSysMasterProperties
MARIInterfaceclsImportSysMasterPropertyLink
MARIInterfaceclsImportSysMasterPropertyStack
MARIInterfaceclsImportSysUserQueryGroup
MARIInterfaceclsImportTenantAction
MARIInterfaceclsImportTenantBatchLog
MARIInterfaceclsImportTenantCustomer
MARIInterfaceclsImportTenantDatabase
MARIInterfaceclsImportTenantEnvironment
MARIInterfaceclsImportTenantMonitorAppInstallation
MARIInterfaceclsImportTenantMonitorAppUser
MARIInterfaceclsImportTenantMonitorAppUserGroup
MARIInterfaceclsImportTenantMonitorDatabase
MARIInterfaceclsImportTenantMonitorEnvironment
MARIInterfaceclsImportTenantMonitorMachine
MARIInterfaceclsImportTenantMonitorSysLogDebug
MARIInterfaceclsImportTenantUser
MARIInterfaceclsImportTenantUsersDBLink
MARIInterfaceclsImportTextModules
MARIInterfaceclsImportTrainingParticipant
MARIInterfaceclsImportTrainingRegistration
MARIInterfaceclsImportTrainingRegistrationContractLink
MARIInterfaceclsImportTrainingRegistrationOptionLink
MARIInterfaceclsImportTravelCategory
MARIInterfaceclsImportTravelCategoryAccount
MARIInterfaceclsImportUserDefinedField
MARIInterfaceclsImportWorkItemPosBase
MARIInterfaceclsImportWorkitemResBase
MARIInterfaceclsImportWorkItemScheduleDatesBase
MARIInterfaceclsImportWorkItemServicePlan
MARIInterfaceclsImportWorkItemServicePlanTemplate
MARIInterfaceclsImportWorkItemServicePlanTemplatePosition
MARIInterfaceclsImportWorkItemServiceTask
MARIInterfaceclsImportWorkItemServiceTaskResults
MARIInterfaceclsImportWorkItemServiceTaskStatus
MARIInterfaceclsImportWorkItemTrainingCourse
MARIInterfaceclsImportWorkItemTrainingOption