Performing initial load from M3 to ION

During normal processing, events carrying data are generated when a user makes a data change or completes a transaction in M3. The initial load function in M3 generates events without creating corresponding transactions. The events are sent to ION by an M3 program called from EVS002MI. To perform the initial load of M3 data, you must synchronize the ION Document Flow with Data Lake Publisher selected tables to publish.

Take note of the name of the master tables to send to Infor Data Lake.

In M3, select Administration Tools > M3 Metadata Publisher > M3 API Repository > TEST API.
Click the Settings icon.
Specify a value in the Company (cono) field. Standard value is 100.
Click OK.
Specify this information:
Program

Select EVS002MI and then click Select.

Transaction

Select Initiate.

FILE

Specify the table name to trigger publishing of Item master data. For example, specify MITMAS.

DIVI

Specify the division of events, if applicable.
Note: The Division parameter works only if the Division field (DIVI) is a field in the primary key of the table that is specified in FILE.

FRDT

Specify a value in this field and in the TODT field to filter the records registration date (RGDT) in the M3 table.

TODT

Omitting the TODT sends data with a registration date (creation date) from FRDT and higher.

DTLK

Specify 1.

FRTS

Specify a value in (YYYY-MM-DD) or (YYYY-MM-DDTHH:MM:SS.sss) format to define the lowest LMTS to which the data is generated.
Partial load based on LMTS timestamp is useful when loading or reloading data that was updated at a specific time. If the table does not contain LMTS, this message shows:
```
“XFL0003 = Field &1 is missing in table &2“
```
TOTS

Specify a value to define the highest LMTS to which the data is generated.

You can define FRTS and TOTS on day level (YYYY-MM-DD) or a full datetime specification on millisecond level.
Note: Ensure that the FRDT and TODT fields are blank since their values override FRTS and TOTS values.
Click Run.