MARIInterface API for MARIProject
MARIInterface
MPInterface Class
MPInterface Methods
AttendanceDayInfo Method
bDeleteERPProductTree Method
bDeleteImportedItems Method
bDeleteItemBookingLine Method
bDeleteSupportTicket Method
bDeleteSupportTicketAttachment Method
bDeleteTimeKeepingLine Method
bGetLoginBySBOUser Method
bImportAttendanceDayActivity Method
bImportAttendanceDayActivityByAccesDatabase Method
bImportBook Method
bImportBookPage Method
bImportBPAuditPlan Method
bImportBPAuditPlanByAccess Method
bImportBPAuditTask Method
bImportBPAuditTaskByAccess Method
bImportBPAuditTaskResource Method
bImportBPAuditTaskResourceByAccess Method
bImportBPAuditTemplate Method
bImportBPAuditTemplateByAccess Method
bImportBPGroup Method
bImportBusinessPartner Method
bImportBusinessPartnerContactPerson Method
bImportBusinessPartnerMasterByAccessDatabase Method
bImportBusinessUnit Method
bImportBusinessUnitByAccessDatabase Method
bImportBusinessUnitCollection Method
bImportBusinessUnitMatrixByAccessDatabase Method
bImportBusinessUnitSettingsByAccessDatabase Method
bImportByAccessTable Method
bImportClassNotificationEventLink Method
bImportClassNotificationText Method
bImportCommissionInitByAccess Method
bImportCompanySettingsByAccessDatabase Method
bImportContract Method
bImportContractPosition Method
bImportContractPositionAccountingPos Method
bImportContractPositionList Method
bImportContractPositionsByAccessDatabase Method
bImportContractsByAccessDatabase Method
bImportContractsCollection Method
bImportCustomerLocationTree Method
bImportCustomerLocationTreeByAccess Method
bImportCustomerLocationTreeElement Method
bImportCustomerLocationTreeElementByAccess Method
bImportCustomerServiceObject Method
bImportCustomerServiceObjectByAccesDatabase Method
bImportCustomerServiceObjectCategory Method
bImportCustomerServiceObjectCategoryByAccesDatabase Method
bImportCustomerServiceObjectLocation Method
bImportCustomerServiceObjectLocationByAccesDatabase Method
bImportCustomerServiceObjectPart Method
bImportCustomerServiceObjectPartsByAccesDatabase Method
bImportDocument Method
bImportDraftDocument Method
bImportEmail Method
bImportEmailAttachment Method
bImportEmployee Method
bImportEmployeeAbsense Method
bImportEmployeeAnnualVacation Method
bImportEmployeeCollection Method
bImportEmployeeCostRates Method
bImportEmployeeCostRatesProject Method
bImportEmployeeMaster Method
bImportEmployeeOrganisation Method
bImportEmployeePeriod Method
bImportEmployeePoolLink Method
bImportEmployeeProjectLink Method
bImportEmployeesByAccessDatabase Method
bImportEmployeeServiceLink Method
bImportEmployeeSkillLink Method
bImportEmployeeSkillLinkByAccessDatabase Method
bImportEquipmentBooking Method
bImportEquipmentBookingsByAccessDatabase Method
bImportEquipmentCategoriesByAccessDatabase Method
bImportEquipmentCategory Method
bImportEquipmentCategoryAdditionalSubjects Method
bImportEquipmentCategoryAdditionalSubjectsByAccessDatabase Method
bImportEquipmentCategoryBPCatalog Method
bImportEquipmentCategoryBPCatalogByAccessDatabase Method
bImportEquipmentCategoryPart Method
bImportEquipmentCategoryPartsByAccessDatabase Method
bImportEquipmentLocation Method
bImportEquipmentLocationByAccessDatabase Method
bImportEquipmentMaster Method
bImportEquipmentMasterAssemblyLink Method
bImportEquipmentMasterAssemblyLinkByAccessDatabase Method
bImportEquipmentMasterByAccessDatabase Method
bImportEquipmentMasterParts Method
bImportEquipmentMasterPartsByAccessDatabase Method
bImportERPDocument Method
bImportERPItem Method
bImportERPPayment Method
bImportERPProductTree Method
bImportERPProjectCode Method
bImportERPResource Method
bImportExchangeRateForPlanning Method
bImportExchangeRateSBO Method
bImportFile Method
bImportFolderNotesByAccess Method
bImportGroup Method
bImportGroupsByAccessDatabase Method
bImportItemBookingLine Method
bImportItemBookingLinesCollection Method
bImportItemBookingsByAccessDatabase Method
bImportItemByAccessDatabase Method
bImportKnowledgeBaseEntry Method
bImportKnowledgeBaseEntryByAccess Method
bImportKnowledgeBaseEntryLanguage Method
bImportKnowledgeBaseEntryLanguageByAccess Method
bImportMARIUser Method
bImportMenuRightsByAccess Method
bImportPhase Method
bImportPhaseCollection Method
bImportPhasePredecessor Method
bImportPhasesByAccessDatabase Method
bImportPlanning Method
bImportProject Method
bImportProjectCollection Method
bImportProjectGroup Method
bImportProjectsByAccessDatabase Method
bImportPurchaseProcess Method
bImportPurchaseProcessByAccessDatabase Method
bImportPurchaseProcessDocument Method
bImportPurchaseProcessDocumentsByAccess Method
bImportPurchaseProcessPosition Method
bImportPurchaseProcessPositonsByAccessDatabase Method
bImportQualification Method
bImportQualificationByAccess Method
bImportQualificationPlan Method
bImportQualificationPlanByAccess Method
bImportQualificationTask Method
bImportQualificationTaskByAccess Method
bImportQualificationTaskPositionsByAccess Method
bImportQualificationTaskResource Method
bImportQualificationTaskResourceByAccess Method
bImportQualificationTasksPosition Method
bImportQualityProcess Method
bImportQualityProcessesByAccessDatabase Method
bImportQualityProcessQuestion Method
bImportQualityProcessQuestionLimits Method
bImportQualityProcessQuestionLimitsByAccessDatabase Method
bImportQualityProcessQuestionsByAccessDatabase Method
bImportResourcePool Method
bImportResourcePoolCollection Method
bImportResourcePoolsByAccessDatabase Method
bImportSalesContractDocument Method
bImportSalesContractDocumentsByAccess Method
bImportService Method
bImportServicePlan Method
bImportServicePlanByAccess Method
bImportServicePlanPosition Method
bImportServicePlanPositionByAccess Method
bImportServicePlanTemplate Method
bImportServicePlanTemplateByAccess Method
bImportServicePlanTemplatePosition Method
bImportServicePlanTemplatePositionByAccess Method
bImportServicesesByAccess Method
bImportServiceTask Method
bImportServiceTaskPositionsByAccess Method
bImportServiceTaskResults Method
bImportServiceTaskResultsByAccess Method
bImportServiceTasksByAccess Method
bImportServiceTasksPositions Method
bImportServiceTasksResources Method
bImportServiceTasksResourcesByAccess Method
bImportServiceTasksRessourcesByAccess Method
bImportServiceTaskStatus Method
bImportSkill Method
bImportSkillByAccessDatabase Method
bImportSupportIssue Method
bImportSupportIssueAttachment Method
bImportSupportIssueAttachmentByAccessDatabase Method
bImportSupportIssueByAccessDatabase Method
bImportSysMasterProperty Method
bImportTenantAction Method
bImportTenantBatchLog Method
bImportTenantCustomer Method
bImportTenantEnvironment Method
bImportTenantMonitorAppInstallation Method
bImportTenantMonitorAppInstallations Method
bImportTenantMonitorDatabase Method
bImportTenantMonitorDatabases Method
bImportTenantMonitorEnvironment Method
bImportTenantMonitorMachine Method
bImportTenantMonitorMachines Method
bImportTextModulesByAccess Method
bImportTimeKeepingByAccessDatabase Method
bImportTimeKeepingLine Method
bImportTimeKeepingLinesCollection Method
bImportTrainingCourse Method
bImportTrainingCourseOption Method
bImportTrainingCoursePosition Method
bImportTrainingCourseResources Method
bImportTrainingCourseScheduleDate Method
bImportTrainingParticipant Method
bImportTrainingRegistration Method
bImportTravelCategoryAccountByAccessDatabase Method
bImportTravelCategoryByAccessDatabase Method
bImportUserDefinedField Method
bImportUserDefinedFieldsByAccess Method
bImportUserGroupsByAccess Method
bInit Method
bInitERPConnect Method
bInitInterface Method
bInitInterfaceFromRestService Method
bInitInterfaceFromWebService Method
bLoadImportObjectFromRow Method
bReadBusinessUnitMasterFromDBAndSaveInAccess Method
bReadBusinessUnitSettingsMasterFromDB2Batch Method
bReadBusinessUnitSettingsMasterFromDBAndSaveInAccess Method
bReadBusinessUnitSettingsMatrixMasterFromDB2Batch Method
bReadBusinessUnitSettingsMatrixMasterFromDBAndSaveInAccess Method
bReadCardCodeFromDBAndSaveInAccess Method
bReadClassNotificationDB2Batch Method
bReadCompanySettingsMasterFromDB2Batch Method
bReadCompanySettingsMasterFromDBAndSaveInAccess Method
bReadContractPositionsMasterFromDBAndSaveInAccess Method
bReadContractsMasterFromDBAndSaveInAccess Method
bReadCustomerLocationTreeElementFromDB2Batch Method
bReadCustomerLocationTreeFromDB2Batch Method
bReadCustomerServiceObjectsFromDB2Batch Method
bReadEmployeeAnnualVacationFromDB2Batch Method
bReadEmployeeCostRatesFromDB2Batch Method
bReadEmployeeCostRatesProjectFromDB2Batch Method
bReadEmployeeMasterFromDB2Batch Method
bReadEmployeeMasterFromDBAndSaveInAccess Method
bReadEmployeeOrganisationFromDB2Batch Method
bReadEmployeePeriodFromDB2Batch Method
bReadEmployeeProjectLinkFromDB2Batch Method
bReadEmployeeServiceLinkFromDB2Batch Method
bReadEmployeeTravelMilageFromDB2Batch Method
bReadEquipmentCategoryBPCatalogFromDB2Batch Method
bReadEquipmentLocationFromDB2Batch Method
bReadEquipmentMasterAssemblyLinkFromDB2Batch Method
bReadFormRightsMasterFromDB2Batch Method
bReadFormRightsMasterFromDBAndSaveInAccess Method
bReadItemBookingFromDBAndSaveInAccess Method
bReadItemMasterFromDBAndSaveInAccess Method
bReadMenuRightsMasterFromDB2Batch Method
bReadMenuRightsMasterFromDBAndSaveInAccess Method
bReadProjectContractPositionFromDB2Batch Method
bReadProjectMasterFromDBAndSaveInAccess Method
bReadProjectPhasePredecessorFromDB2Batch Method
bReadProjectPhasesMasterFromDB2Batch Method
bReadProjectPhasesMasterFromDBAndSaveInAccess Method
bReadProjectPurchaseProcessPositonsFromDB2Batch Method
bReadResourcePoolLinkFromDBAndSaveInAccess Method
bReadResourcePoolsMasterFromDBAndSaveInAccess Method
bReadServiceObjectCategoryFromDB2Batch Method
bReadServicesesMasterFromDBAndSaveInAccess Method
bReadTimeKeepingMasterFromDBAndSaveInAccess Method
bReadTrainingCourseFromDB2Batch Method
bReadTrainingCoursePosFromDB2Batch Method
bReadTrainingParticipantFromDB2Batch Method
bReadTrainingResourcesFromDB2Batch Method
bReadTravelCategoriesAccountFromDBAndSaveInAccess Method
bReadTravelCategoriesFromDBAndSaveInAccess Method
bReadUserGroupsMasterFromDBAndSaveInAccess Method
bRequestMapGeoCoordinates Method
bSaveLine Method
bUserLogin Method
bUserLoginDomain Method
CheckCustomerLogin Method
ClearBusinessLogicBusyCash Method
CloseERPDocument Method
CreatePurchaseDocumentFromPurchaseProcess Method
CreateSalesDocumentFromSalesContract Method
EmployeeNumber Method
GetDocEntriesByImportEnt Method
GetDocEntryByDocNum Method
GetGetOpenPaymentValue Method
GetTenantEnvironment Method
ImportBasePropertyImportable Method
lDate2Period Method
LoadImportDefinition Method
Logout Method
maGetSystemTime Method
MARIContractBOMPosImport Method
MARISyncSupportAttachment Method
MARISyncSupportMapping Method
MARISyncSupportTicket Method
MoveBookedEntriesInHistory Method
MPInternCheckFunction Method
nGetDeviceFromERPDatabaseServer Method
nLoginSBOMandant Method
oColIssues Method
oColIssuesExcludeStatus Method
oGetAttachments Method
oGetBusinessPartner Method
oGetDocument Method
oGetGroups Method
oGetIssue Method
oGetItem Method
oGetListContractToProject Method
oGetListFolderGroupsByClassID Method
oGetListFolderGroupsByDataType Method
oGetListFolderGroupsForProjects Method
oGetListOfDocumentsInFolder Method
oGetListOpenItems Method
oGetListPhasesOfProjectForPlanning Method
oGetListPhasesOfProjectForPlanningWithoutClosed Method
oGetListPhasesOfProjectForTimeBooking Method
oGetListPositionsOfContractByItemCode Method
oGetListPositionsOfContractForPlanning Method
oGetListProjectsForFolderImport Method
oGetListProjectsForPlanning Method
oGetListProjectsForTimeBooking Method
oGetListPurchaseProcessesToProject Method
oGetListTrainingCources Method
oGetProjectCode Method
PrepareForBatchImport Method
ReadDataFromDB Method
SAPVersionNumber Method
sConnectionInfo Method
sConnectionInfoWithID Method
sEngineFirstDatabaseLink Method
sEngineFirstDatabaseLinkDescription Method
sGetNewContractNumber Method
sGetNewEmployeeNumber Method
sGetNewParticipantNumber Method
sGetNewPreliminaryProjectNumber Method
sGetNewProjectNumber Method
sGetNewPurchaseProcessNumber Method
sInfoContracts Method
sInfoContractsPositionsEmployees Method
sInfoEmployees Method
sInfoPhases Method
sInfoProjects Method
sLanguages Method
sPrintErrors Method
sVersionInfoEngine Method
sVersionInfoInterface Method
TenantExecuteLocalAction Method
TenantExecuteLocalActionBatch Method
TenantExecuteQueueAction Method
TenantProcessResultAction Method
TenantProcessResultsOfAction Method
TrainingCourseFromScheduleDates Method
TrainingCourseWebFrontEndHandshake Method
vTranslateContent Method
Click or drag to resize

MPInterfacebImportSkillByAccessDatabase Method

Reads the MARIProjektImportData.mdb and the tables MARIProjektImportSkills. See clsImportSkill.

Namespace:  MARIInterface
Assembly:  MARIInterface (in MARIInterface.dll) Version: 8.0.0.100
Syntax
Copy
public bool bImportSkillByAccessDatabase(
	string sDatabaseFileName,
	clsImportBaseeImportMode nImportMode,
	ref int lCountByRef,
	ref int lCountImportedByRef
)

Parameters

sDatabaseFileName
Type: SystemString
Path and filename
nImportMode
Type: MARIInterfaceclsImportBaseeImportMode
Type of validation. See eImportMode for details.
lCountByRef
Type: SystemInt32
Indicates total rows in the given table
lCountImportedByRef
Type: SystemInt32
Indicates total imported rows in MARIProject

Return Value

Type: Boolean
sngCount,lCountImported and true if no error
See Also