Skip to content

Data Migration Procedures

Usage

Procedures describes the bahaviour of a Data Migration Job. These behaviours can be divided in to 4 main types as File Migration, Source Migration, Excel Migration and Import Export.

All procedures must be pre-defined in the package Intface_Util_API and will be inserted here during installation of the FNDMIG module. No customized procedures are allowed.

Procedure Name Comment Migration Type/Direction
CHECK_BY_METHOD_NEW Reads data from a file, using the standard IFS business logic through a New__ method, invoking it with CheckOption which means that the data will be validated only, and not inserted it into the database. Target LU is derived from specified ViewName.

File In
CREATE_OUTPUT_FILE Used to write data to file. IFS/Data Migration can retrieve data from any view and write it to a file according to definition in the formatting tab.

File Out
CREATE_TABLE_FROM_FILE Reads data from file and stores them in a table in the database.

File In
INSERT_BY_METHOD_NEW Reads data from a file and insert them directly into IFS using the standard IFS business logic through a New__ method. Target LU is derived from specified ViewName

File In
INSERT_OR_UPDATE Same as previous, but checks if the row exists in the database first. If this is the case, a Modify__ will be performed instead of New__.

File In
FNDMIG_EXPORT Writes all basic data for one or more migration jobs to a special formatted file.
Just specify file information and a WhereClause if you want to limit the selection.

You will find a pre-installed job using this procedure. Read the comments on the job header carefully.

File Out
FNDMIG_IMPORT Reads data file created by previous procedure, and inserts all basic data
(i.e. header, column details, method list, rules, groups and conversion lists)

You will find a pre-installed job using this procedure. Read the comments on the job header carefully.

File In
MIGRATE_SOURCE_DATA Used to migrate data from an Oracle source (table, view, db-links) into IFS using valid IFS business logic.
Source Migration
REPLICATION Used to replicate data within a Logical Unit, from one Company/Contract to one or more Companies/Contracts Source Migration
REPLIC_DATA_OUT Replicate Data Structures.( outbound messages to IFS/Connect) ReplicStructure