Table Mapping

This tab lets you edit and delete the default existing table column mappings. You can also create, modify, and delete the custom table column mappings.

Figure: Table Mapping

Click "Select Table Definition" drop-down menu to select the table definition, in which you want to create, edit, and delete the table column mappings.

Figure: Select Table Definition

The default table column mappings are available only in "DefaultTableDefinition".

Create Table Mapping

Administrator needs to follow below steps to create a new mapping.

1. Click"Create New Mapping" button. Following pop-up named "Create Table Mapping Wizard" is displayed on the screen.

   

   Figure: Create Table Column Mapping

2. Administrator needs to fill the following details in order to create a new mapping.
   1. Mapping Name :Provide a mapping name.
   2. Campaign Type :Select the Campaign type from the provided drop-down. It contains the following options.
      1. Interactive Voice Application
      2. Outbound Voice Campaign
      3. Interaction Campaign
      4. Parallel Predictive Voice Campaign
      5. IVR Campaign
      6. Voice Blast Campaign
      7. Chat Campaign
   3. Mapping Sequence :By default, the following two mapping sequences are displayed here.
      1.  

         Searchable (Licensable: 5 to 10 fields): It lets you add the searchable and optional columns in the mapping. It is not necessary to create the searchable fields. Through this feature the column on which the searchable field is applied, the column becomes searchable, means a search bar appears on the column which allows the user to search for any of the data.

         Buy the license to increase the number of searchable fields. After purchasing the license, run the following query.
         INSERT INTO system_configuration_parameter(name,type,value,default_value) VALUES ('maxSearchableFieldsAllowed','Integer','<number_of_searchable_fields>','<number_of_searchable_fields>');

         The maximum number of searchable fields (after both license and configuration) is 10. After purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase. Contact either Marketing Department or Services Team of Ameyo.

      2.  

         Phone (Licensable: 5 to 50 fields): It lets you add the mandatory columns in the mapping. It is mandatory for the user to fill these columns.

         Buy the license to increase the number of phone fields. After purchasing the license, run the following query.

         INSERT INTO system_configuration_parameter(name,type,value,default_value) VALUES ('max.phone.allowed','Integer','<number_of_phone_fields>','<number_of_phone_fields>');

         The maximum number of phone fields (after both license and configuration) is 50. After purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase. Contact either Marketing Department or Services Team of Ameyo.

   4. ilterable: It lets you add the filterable columns in the mapping. The user can leave these columns blank. Through this feature the administrator now have another filter field through which he can filter for the required voicelogs.

      Buy the license to increase the number of filterable fields. After purchasing the license, run the following query.
      INSERT INTO system_configuration_parameter(name,type,value,default_value) VALUES ('maxFilterableFieldsAllowed','Integer','<number_of_filterable_fields>','<number_of_filterable_fields>');

      The maximum number of filterable fields (after both license and configuration) is 10. After purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase. Contact either Marketing Department or Services Team of Ameyo.

3. You have to click "Add" for a Mapping Sequence to add its column.

   You cannot edit or delete the column mappings here.

4. Attribute : User can select the attributes for the added column mappings. It has the following options.
   1. twitter
   2. timezone
   3. facebook
   4. name
   5. phone1
   6. phone2
   7. phone3
   8. phone4
   9. phone5
   10. email
5. Type: You have to select the types of these attributes for the added column mappings.

Following screenshot shows the sample table mapping for a custom "Test1" table definition.

Figure: Sample Table Mapping

• Click "Save" to create the table mapping.
  Alternatively, you can click "Cancel" to discard the changes.
  Following screenshot shows two newly created table mappings.

  

  Figure: Table Mappings

• Modify Table Mapping

  Perform the following steps to edit a table mapping.

  1. Select the table definition in "Select Table Definition" drop-down menu. The mappings of selected definition are displayed.
  2. Select a table and click "Edit".

     

     Figure: Edit a Table Column Mapping

  3. You can change the following fields here.
     1. Mapping Name: Change the name of the mapping.
     2. Mapping of Attributes: You can change the mapping of attributes.
  4. Click "Save" to save and apply the changes.

     You cannot change the table definition name and campaign type. Attributes cannot be added, edited, or deleted.

  Delete Table Column Mapping

  Perform the following steps to delete a table column mapping.

  It is recommended not to delete the default table column mappings available in the default table definition (DefaultTableDefintion).

  1. Select the table definition in "Select Table Definition" drop-down menu.
  2. Select the mapping and click "Delete". It shows the following warning message.

     

     Figure: Asking to delete a Table Column Mapping

  3. Click "Yes" to delete the selected mapping.
     You can click "No" to not delete the mapping.