Export a Conditional Mapping from a Routing Rule to a CSV / Spreadsheet

Introduction:

Copy/Pasting from a conditional mapping table produces a column of values. If there is a need to edit a certain amount of lines in a conditional mapping, you can do it by exporting the conditional mapping from a Routing Rule to a CSV/Spreadsheet for reviewing, and the output will be usable for a spreadsheet application, e.g., MS Excel or Google Sheets.

You can also Exporting Spreadsheet Data to a Routing Rule's Conditional Mapping.

Step-by-Step:

Step 1: Export the .json routing rule configuration file.

When you click on the export button, the .json file will be downloaded automatically.

Step 2: Identify the Translation Table in question.

Copy the data between the brackets from the identified TranslationTable element.

Step 3: Use your tool of preference to convert the dedicated translationTable element from the JSON file to CSV.

Note: There are many different tools available or create your own.

Additional Information about null / blank values:

If the conditional mapping contains any null or regex "match" mappings these would need to be replaced with something that would make sense for the spreadsheet.

For example, a null can be replaced with {"value":"NO VALUE"}, a "match" can be replaced with "value".

In this example, we change target blank value from:

{
    "source" : [
        {
            "value" : "Default"
        },
        {
            "match" : "ANY"
        },
        {
            "match" : "ANY"
        }
    ],
    "target" : [
        {
            "value" : " "
        },
        {
            "value" : "X_Y_Z"
        }
    ]
}

to "NO VALUE"

{
    "source" : [
        {
            "value" : "Default"
        },
        {
            "match" : "ANY"
        },
        {
            "match" : "ANY"
        }
    ],
    "target" : [
        {
            "value" : "NO VALUE"
        },
        {
            "value" : "X_Y_Z"
        }
    ]
}