Mapping

View Existing Mapping Configuration

1. Click on the Usage switch (Usage/Account toggle switch) in the navigation pane
2. Click on the Mediation Setup option in the navigation panel. This will expand the sub-menu for Mediation Setup in the Navigation Pane.
3. Click on the Mapping menu option in the navigation panel.
4. This will fetch the existing set of existing mapping configurations and show a line for each mapping configuration on the table.
5.  This is shown in the following screenshot:

View Details of a Specific Mapping Configuration

1. Navigate using “To view existing mapping configuration”. This will show the list of mapping configurations for usage.
2. Select and click the ID link. This will open the drawer and allow you to view and modify the data 

Filter Attributes For The Mapping Configuration

1. Service Type: Filter the mapping configuration using the service type by selecting the value from the drop-down list. Note that a platform can allow different usage record formats for different service types. This is an Exact search filter
2. Source Platform: Filter the mapping configuration using the source platform by selecting the value from the drop-down list. This is an Exact search filter

Sort Attributes For The Mapping Configuration

1. ID: Sort ascending or descending based on the id associated with the mapping configuration.
2. Service Type: Sort ascending or descending based on the service-type associated with the mapping configuration.
3. Source Platform: Sort ascending or descending based on the source platform associated with the mapping configuration. 

Add a New Mapping Configuration

1. Navigate using “To view existing mapping configuration”.
2. Refer to the Quick Notes button in the top right corner of the activity pane.
3. Click the Add Mapping button towards the top-right corner of the activity pane. This will open a drawer to add details of the mapping configuration Add the data as follows:
   1. In the first field, enter a Name (mandatory attribute) for the new mapping configuration.
   2. In the next field, enter a Description (mandatory attribute) for the new mapping configuration
   3. Next, select the Status (mandatory attribute) for the new mapping configuration by selecting the value from the drop-down list. The default status of ACTIVE would be set automatically.
   4. Next, select the Source Platform (mandatory attribute) from the drop-down list of pre-configured source platforms for which the new mapping configuration is being added.
   5. Next, select the Service Type (mandatory attribute) from the drop-down list. The drop-down list is trimmed down for the source platform configured. If the source platform has only one service-type configured, the service type is automatically selected.
   6. Next, select the Service Type (mandatory attribute) from the drop-down list. The drop-down list is trimmed down for the source platform configured. If the source platform has only one service-type configured, the service type is automatically selected.
   7. Next, select the Usage Record Type (mandatory attribute) from the drop-down list. The drop-down list is trimmed down for the source platform and service-type configured. If the Usage record type is only one for a source platform and service-type configured, the usage record type is automatically selected.
   8. Next, the Interface Type is automatically selected as File. In future, more values will be allowed.
   9. Next, the Payload Type is automatically selected as CSV. In future, more values will be allowed.
   10. Next, select the File Type from the drop-down list. The supported types are DELIMITED or POSITION based.
   11. If the File type chosen is DELIMITED, the next field DELIMITER is enabled. Enter the Delimiter used in the file. Please note that you can specify the delimiter at the file level or at record level as well, if different records use a different delimiter.
   12. Refer to the Quick Notes below the set of fields on the right side of the drawer.
   13. Next, press the Add Record button to add a record for the file. Please note that a usage file can have more than one record type in a file. All records would need to be added the same way. Add the following attributes for the record
       1. First, enter the Source File Record (mandatory attribute) value. For standardized data formats may have a record number present in the file. If not, specify any value for reference.
       2. Next, select the Target File Record (mandatory attribute) value from the drop-down list. The possible values are Header, Detail and Trailer. Please note that for now if you have added custom records, you can map custom record attributes to the 25 flexible fields in the Allegro Usage Container DETAIL record.
       3. Next, enter the ‘Record delimiter’ value. By default, the file delimiter is already set as the Record delimiter too.
       4. The next field is display-only and is auto-populated as the table name for storing the raw record. Allegro engine automatically creates the table for the raw record using the mapping configuration.
       5. Next, add the fields for the record in the order they appear in the file using the following step:
          1. The first field is auto populated as an index value of the file in the file starting with value 1.
          2. The next two fields are enabled only if the file type is a position-based file, otherwise disabled for delimited file type.
          3. Enter the Start position for the field in the record as an integer value (e.g., the 2nd field in the file starts from 8th character)
          4. Enter the End position for the field in the record as an integer value (e.g., the 2nd field in the file starts from 8th character and ends at 19th character making it a 12-character field).
          5. Next, enter the name for the field (mandatory attribute). This will be the field name. It is advised that spaces are not used. Allegro will automatically replace spaces with _’ (underscore value).
          6. Next, determine whether the new field is a Unique identifier by selecting the Boolean value from the drop-down list. Note that if the source platform provides a unique identifier attribute, then that attribute can be marked as a unique identifier. Alternatively, one or more attributes together can be marked as a unique identifier as a composite attribute. Allegro will concatenate those attributes and store them as a unique identifier.
          7. Next, For the next attribute ‘Field Type (mandatory), select the data type for the new field by selecting the right value from a drop-down list.
          8. If the data type selected is VARCHAR, the next attribute is enabled for input. Enter the field length of the text string for the new field.
          9. Next, select whether the attribute is a mandatory attribute or not. This automatically adds a validation that some value is always expected for the attribute.
          10. In the last field, map the new field to the container field from the target source record selected earlier by using the drop-down list.
       6. To add more fields for the record, repeat steps-3.m,e until all the field attributes are added.
   14. To add more records for the file, repeat steps-3.m until all the records and its fields are added
4. Click on the SAVE button at the bottom right corner of the drawer. This will push the changes to save the configuration using the backend API.
5. Click on the CANCEL button at the bottom right corner of the drawer to cancel all the data entry and go back to the main activity pane for the currency resources.

Copy to Create a New Mapping Configuration

Many a times the file formats are almost similar and hence a copy-to-create functionality allows to use an existing configuration to create a new mapping configuration. Execute the following steps for a copy-to-create configuration:

1. Navigate using “To view existing mapping configurations”
2. Click the Id link button with the ID highlighted in the Aria Blue color to open the drawer for that mapping configuration.
3. Click on the Copy-To-Create button at the bottom right-hand corner of the drawer. This will open another drawer for the new mapping configuration. It will blank out the mandatory fields that you would require to modify and copy the remaining fields.
4. Review and enter/change the configuration values, same as with creating a new mapping configuration.
5. Click on the SAVE button at the bottom right corner of the drawer. This will push the changes to save the configuration using the backend API.
6. Click on the CANCEL button at the bottom right corner of the drawer to cancel all the data entry and go back to the main activity pane for the custom records.

Modify Existing Mapping Configuration

The steps to modify an existing mapping configuration are:

1. Navigate using “To view existing source platforms”
2. Click the Id link button with the ID highlighted in the Aria Blue color to open the drawer to modify some attribute of an existing source platform.
3. Modify the attributes (the ID field cannot be modified) inline as required.
4. Click on the SAVE button at the bottom right corner of the drawer. This will push the changes to save the configuration using the backend API.
5. Click on the CANCEL button at the bottom right corner of the drawer to cancel all the data entry and go back to the main activity pane for the currency resources.