...
...
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.
View file | ||
---|---|---|
|
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 |
youremailaddress@yourcompany.com | Your SEKO 360 Client | Upload Inbound Bookings | Yes | Yes |
Your SEKO 360 Client | 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.
List of ISO Country Codes
Country Codes List - ISO ALPHA-2, ISO ALPHA-3 and Numerical Country Codes
Example CSV Load Files
View file | ||
---|---|---|
|
View file | ||
---|---|---|
|
Inbound Bookings Data Format (Transfer Order/ASN)
Inbound bookings are mapped with the following columns |
---|
NB. Extra information are added by default:
Transit Mode: ROAD
Quantity: PCS
Outbound Bookings Data Format
Document Number |
---|
, NOT |
---|
Country Name- see link above) |
---|
Transfer Order/ASN
9 columns
...
Item
Display Name
Quantity
To Location
Ex-Factory Date
Carrier
From Location
Internal ID
Estimated Receipt Date
NB. Extra information to be added by default:
...
Transit Mode: ROAD
...
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
...