Forum Discussion

FICO's avatar
FICO
Community Manager
2 years ago

Can the CSV file generated by "Export Decision Table" default to Unicode instead of ASCII?

When I am looking at a Decision Table in Fico Blaze Advisor, I am able to click a button for "Export Decision Table" to create a CSV file with the data in the table. When the CSV file is created, it seems to default to ASCII encoding. This is not a problem when working with American-English, but if the Decision Table contains any text from a non-English language the text is corrupted the first time that file is opened with Microsoft Excel. (The "A" in ASCII stands for "American".) While we are able to use Microsoft Excel to unscramble and reformat the text, and re-save the CSV file in Unicode/UTF-8 encoding, it is inconvenient and tedious because it must be done for each individual CSV file each time a Decision Table is exported. It would be very convenient if the "Export Decision Table" button would create CSV files which are already in Unicode/UTF-8 encoding. It may be as easy as adding a Byte-Order-Marker "EF BB BF" to the CSV file. (The Byte-Order-Marker "EF BB BF" would allow Microsoft Excel or similar programs to detect that the CSV file should be read in Unicode/UTF-8 encoding by default instead of ASCII.)

I am using Blaze Advisor version7.8.2 (22075).

3 Replies

  • FICO's avatar
    FICO
    Community Manager

    Please get in touch with FICO product support to raise the enhancement request via the support portal at https://ficoitservices.service-now.com/support.

  • FICO's avatar
    FICO
    Community Manager

    I checked with Product Management, and there is already a related enhancement request, which is a good sign for getting this done sooner than later. The more customer demand there is for an enhancement, the higher its priority.

  • FICO's avatar
    FICO
    Community Manager

    @Tom Travis​ Do you know if the related enhancement request was this one? ⬇️ <https://ficocommunity.ideas.aha.io/ideas/BLZ-I-51>