CSV Files (iHub)

Using iHub for Loading Bookings

 It is possible to use iHub (short for Integration Hub) to load the bookings into the White Glove system. This needs a different registration to being a user of the White Glove system.

iHub URLs

Production System

https://ihub.supplystream.com/

User Acceptance Testing System

https://ihub.supplystream.com/

Registration for iHub

In order to use IHub you must be registered by the Support team so need to raise a request by going through Help on SEKO 360.

You should provide the following information:

  • The email address of the people you wish to add

  • The Clients for which you wish to register

  • The functionality you wish for each client

  • Register for Production (Live)

  • Register for UAT (for testing)

 

Email Address

Client

Function

Production

UAT

email.address@company.com

ROOM

Upload Inbound Bookings

Yes

Yes

email.address@company.com

ROOM

Upload Outbound Bookings

Yes

Yes

 

Loading CSV Files

 

Any items you can load will be show in green tiles underneath the “Step 1” shown above.

Bookings CSV file

The columns of Bookings CSV files are mapped to the column header of the CSV file. Here are the things to take note of:

·         The column headers should always be on the first row.

·         It doesn’t matter how many columns there are. Some columns can be missing.

·         It does matter that the column names match exactly, including the case of the letters.

Inbound Bookings Data Format (Transfer Order/ASN)

Inbound bookings are mapped with the following columns
Document Number
Item
Display Name
Quantity
To Location
Ex-Factory Date
Carrier
Location
Internal ID
Estimated Receipt Date

Inbound bookings are mapped with the following columns
Document Number
Item
Display Name
Quantity
To Location
Ex-Factory Date
Carrier
Location
Internal ID
Estimated Receipt Date

 

NB. Extra information are be added by default:

  • Transit Mode: ROAD

  • Quantity: PCS

Outbound Bookings Data Format

Document Number
Transfer Order Reference #
Shipping Instructions
Company Name
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State/Province
Shipping Zip
Shipping Country (Country ISO CODE, NOT Country Name)
First Name
Last Name
Phone Number
Delivery Contact Email
Quantity
Item
KIT BOX 1
KIT BOX 2
KIT BOX 3
KIT BOX 4
KIT BOX 5
KIT BOX 6
KIT BOX 7
KIT BOX 8
KIT BOX 9
KIT BOX 10
KIT BOX 11
KIT BOX 12
KIT BOX 13
KIT BOX 14
KIT BOX 15
KIT BOX 16
KIT BOX 17
KIT BOX 18
KIT BOX 19
KIT BOX 20
KIT BOX 21
KIT BOX 22
KIT BOX 23
Estimated Ship Date
Customer Deliver by Date
Carrier
Internal ID
Order Type
Location
Assembly?
TransitMode
QuantityUnit

Document Number
Transfer Order Reference #
Shipping Instructions
Company Name
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State/Province
Shipping Zip
Shipping Country (Country ISO CODE, NOT Country Name)
First Name
Last Name
Phone Number
Delivery Contact Email
Quantity
Item
KIT BOX 1
KIT BOX 2
KIT BOX 3
KIT BOX 4
KIT BOX 5
KIT BOX 6
KIT BOX 7
KIT BOX 8
KIT BOX 9
KIT BOX 10
KIT BOX 11
KIT BOX 12
KIT BOX 13
KIT BOX 14
KIT BOX 15
KIT BOX 16
KIT BOX 17
KIT BOX 18
KIT BOX 19
KIT BOX 20
KIT BOX 21
KIT BOX 22
KIT BOX 23
Estimated Ship Date
Customer Deliver by Date
Carrier
Internal ID
Order Type
Location
Assembly?
TransitMode
QuantityUnit

How to observe feedback from the Import

The import activity information is shown in the Activities section, selected on the menu as shown here:

 

Example of a successful import

 

 

Example of a failed import