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 and can be implemented by SEKO360 Support SEKO 360 Support - Jira Service Management.

How to Manipulate CSV files in Excel for loading into iHub

Please see the user guide below showing how to manipulate CSV files for loading using iHub. Note that you should not use normal Excel functionality for this, you should follow the guide if you wish to use Excel at all. Please note also that only Excel 2019 onwards supports this functionality. If you don’t have access to this or later versions of Excel, it is recommended that you don’t use Excel at all for this. The reason is that it treats fields such as phone numbers as integer values and corrupts them from their original format.

iHub URLs

Production System

https://ihub.supplystream.com/

...

• 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)

Loading CSV Files

...

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

...

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

List of ISO Country Codes

Country Codes List - ISO ALPHA-2, ISO ALPHA-3 and Numerical Country Codes

Example CSV Load Files

Inbound Bookings Data Format (Transfer Order/ASN)

...

NB. Extra information are be added by default:

• Transit Mode: ROAD

• Quantity: PCS

...

...