Skip to main content

Importing Bulk Load from IMM_BulkMovements Table

When the 'IMM_BulkMovement' table is filled by transfer data, its content can be shared by all the IMM users in order to perform transfer bulk load operations (e.g. recurring transfer declaration on a daily basis).

The table below explains each column and how it should be filled.

IMM_BulkMovements table columns

ColumnDescription
DisplayNameIMM display name (without .PDI file extension) at which the transfer is related.When the Bulk Load is requested from IMM client add-in then, all the transfers matching the DisplayName with the current IMM Display and all the transfers having DisplayName empty will be loaded.DisplayName can be empty.
SourceInitial transfer source element.
Node 11st Intermediate element (can be empty).
Node 22nd Intermediate element (can be empty).
Node 33rd Intermediate element (can be empty).
Node 44th Intermediate element (can be empty).
Node 55th Intermediate element (can be empty).
DestinationFinal transfer destination element.
MaterialMaterial code carried by the transfer.
StartTimeTransfer Start Time.This value can be specified using a relative time formats like ("", "T", "-1h").It is suggested to use the relative time format in order to have the correct transfer StartTime every day.
EndTimeTransfer End Time.This value can be specified using a relative time formats like ("", "T", "-1h").It is suggested to use the relative time format in order to have the correct transfer EndTime every day. Not required in Case the transfer status is ACTIVE.
MassMass value according the configured UOM
VolumeVolume value according the configured UOM
RateFlow rate value according the configured UOM
DensityDensity value according the configured UOM
StatusTransfer status according the following list of string values:ACTIVEAPPROVEDCLOSEDPLANNED

The Node 1 through Node 5 columns allow you to declare up to five (5) intermediate elements, by avoiding intermediate transfers one by one. IMM creates each of the requested transfers with the same data (StartTime, EndTime, Mass, etc.) and Source/Destination, based on the configured sequence.

ClosedEXAMPLE: IMM_BulkMovements table

The following is an example of the IMM_BulkMovements table in IMM.Figure 1616: IMM_BulkMovements table example

General Assumptions​

The following are some general assumptions to keep in mind when importing data.

IMM_BulkMovements configured UOMs:

  • Mass = tons
  • Volume = m3
  • Rate = t/h
  • Density = kg/m3

SF_TransferTemplate configured UOMs:

  • MeasuredMass = Kg
  • NetVolume = m3
  • Density = kg/m3

Example Case Assumptions​

Assumption - Case 1​

The transfer information assumptions are as follows:

  • The current Date time is 8 December 2017 10:00 AM
  • The IMM user is importing transfer data from GASOLINES_AREA.PDI
  • The 'Autofill' checkbox is checked

With these transfer information assumptions, the following is the results.

  • Only the first row of data is loaded.Figure 1617: Assumption Case 1 - First Row Data

    Where:

  • The transfer StartTime will be 12/7/2017 00:00:00

  • The transfer EndTime will be 12/8/2017 00:00:00

  • The Mass will be 100 t.

  • The Volume will be 125,7861m3

  • The Rate will be 4,1666 t/h

  • The Density will be 0,795 Kg/L

  • One transfer is created containing the following data:

  • Source = TK100

  • Destination = TRUCKS_SHIPMENT

  • StartTime = 12/7/2017 00:00:00

  • EndTime = 12/8/2017 00:00:00

  • MeasuredMass = 100,000 Kg.

  • NetVolume = 125.7861m3

  • Density = 795 Kg/m3

Assumption - Case 2​

The transfer information assumptions are as follows:

  • The current Date time is 10 December 2017 10:00 AM
  • The IMM user is importing transfer data from KERO_AREA.PDI
  • The 'Autofill' checkbox is checked

With these transfer information assumptions, the following is the results.

  • Only the second row of data is loaded.Figure 1618: Assumption Case 2 - Second Row Data

  • Three transfers are created containing the following data.

    First transfer:

  • Source = TK110

  • Destination = NODE_PIPE1

  • StartTime = 12/7/2017 00:00:00

  • EndTime = 12/8/2017 00:00:00

  • MeasuredMass = 100,000 Kg.

  • NetVolume = 125.7861m3

  • Density = 795 Kg/m3

    Second transfer:

  • Source = NODE_PIPE1

  • Destination = PIPE1

    Third transfer:

  • Source =PIPE1

  • Destination = PIPELINE_SHIPMENT

    All three transfers have the same data:

  • StartTime = 12/9/2017 00:00:00

  • EndTime = 12/10/2017 00:00:00

  • MeasuredMass = 2,000,000 Kg.

  • NetVolume = 2,614.379 m3

  • Density = 765 Kg/m3