User GuideReference ManualIntegration Scenarios
 

2.4.4. Automatic Population of Lookup Tables

See: Managing Channels - Advanced Channel Functions

Automatic Population of Lookup Tables allow you to import the lookup tables data from outside data source.

After creation of lookup table you can create data import channel by click on Create a lookup table data import Channel as illustrated below:

Create a lookup table data import Channel

Figure 2.50. Create a lookup table data import Channel


This will automatically create a data import channel in your account with predefined gateways and message definitions

You can upload your CSV file directly from the created web gateway like the following example or you can modify the channel to meets your requirements.

Lookup Tables Data Import Channel

Figure 2.51. Lookup Tables Data Import Channel


In this example we have two fields (Supplier Code, Buyer Code)

And this the uploaded CSV file

1,1001
2,1002
3,1003
4,1004