Problem/solution: error when opening translation excel file which prevents opening it or importing to ISM

Version 1

    Environment:

    • tested on 2017.3.1 but applicable to previous versions as well

     

    Requires Access To:

    • administrator account of ISM
    • administrator account of application server

     

    Problem:

    When you go to Admin UI > Configure > Organization Profile > Languages and export any of the translation files, upon opening you get this message:

    This prevents you from opening the file at all, and when you will try to import it back again to ISM, you get this:

     

     

    Cause:

    This is happening because by default, the file is blocked by OS which prevents you from modifying the file and when importing back to ISM, it thinks that file is corrupted.

     

    Solution / Workaround:

    1. Export the file as usually.
    2. Before opening go to the download location.
    3. Right click on the file and go to Properties.
    4. On the General page, you will see information on the bottom as below:

    5. If you unblock this, you will be able to open the file and then import will go through as expected: