How to keep the Qlik format when creating CSV reports (Mail & Deploy Version 2)?

How to keep the Qlik format when creating CSV reports (Mail & Deploy Version 2)?

When generating CSV reports from Qlik, you may notice that the formatting (such as date formats, number formats, etc.) is not preserved, and the report loses the Qlik-specific format settings.

Solution:
To ensure that Qlik formatting is maintained when creating CSV reports using Mail & Deploy, follow these steps:

1. Stop the Server and Close All Clients:
  • Before making any changes, stop the server running Mail & Deploy.
  • Close all client applications that are currently connected to the server.
2. Modify the Settings.XML File:
  • Open the Settings.XML file located in the Mail & Deploy installation directory. This file can be found in the following locations:
    • Client: C:\Mail & Deploy\Client\Settings.XML
    • Server: C:\Mail & Deploy\Server\Settings.XML
  • Add the following line to the file inside the <Settings> tag: