Integrator Settings - Custom Tables

The Customer Self Service eCommerce Platform Integrator is capable of handling tables that are not part of standard integration functionality. 

Custom tables and fields can be specified on the Integrator Settings 'Custom Tables' tab.  Multiple tables can be included, along with filter queries for each. 

Step-by-step guide

To Configure the Integration of Custom Tables:

1. Open the Integrator Client.
2. Click the 'Settings' icon.
3. Click the 'Custom Tables' tab.
4. Enter the PRONTO table name into the 'Table' field.
5. Enter the corresponding Web table name into the 'CSS Table' field.
6. Enter the Filter (or where clause) into the 'Filter' field and click 'Add'.
   • Note - leave the 'where' keyword out of the filter; simply follow the format: fieldName1='fieldValue1' and fieldName2 = 'fieldValue2' etc.
7. Enter the first field name into the 'Field' field and click 'Add'.
8. Enter the corresponding Web field name into the 'CSS Field' field.
9. Repeat steps 6 - 8 until all fields to be integrated from the table have been added.
10. • One of the fields should be a 'Date Time' field used to identify changes to the record; select the field and click 'Set' to identify it as the 'Update Field'. If the 'Update Field' is left blank, all records on the table will be sent. 
11. Click 'OK' to save changes.

Related help

• Page:
  PRONTO - Data Integration Guide