SYMPTOM
Newly created CSV Subscriptions or modified CSV Subscriptions in 10.6 and above will automatically enclose the values with Double Quotations. With the introduction of Strategy 10.6, Strategy changed a default configuration in relation to CSV files. This setting is designed so that CSV subscription entries are contained within double quotations as that is required if the value of the CSV contains a comma itself. This is opposed to the old methodology where if the values contained commas it had to be set for every Report. With the setting enabled the XML tags for the definition of the subscription to contain the following sequence:
<ept daf="F" hex=""" hox=""" vex=""" vox="""/>
This setting will take effect on any edited or newly created subscription so a subscription that has not changed since the upgrade to 10.6 or above they will have been sending with the old format of having no enclosure characters.
ACTION
If this behavior is not desired then it can be configured back to the pre-10.6 behavior by editing a configuration file for the Web Server deployment and for any Command Manager client machines.
In order to change this default back to the original default then we do need to make an adjustment to the sys_default.xml file for the Web Server. Inside of this file there are two lines that will need to be removed:
<pr des="Whether to enable the configuration of prepostfix for subscription" n="enable_prepostfix_ds" scp="server" v="1"/>
<pr des="The prepostfix for subscription" n="prepostfix_ds" scp="server" v="""/>
After they have been removed from the sys_default.xml the Web Server service will need to be restarted. Once this has happened any new subscriptions that include a CSV file or any subscriptions that had the problem and is then edited should be defaulting back to the no enclosure format. For any specific instances where the CSV requires the double quotation enclosure, it can be set at the Report level. Under the Data tab in the Report Editor, we will need to access 'Export Options'. From there we can alter the Application drop down to be 'Text File' and select 'Advanced Options' and the enclosure options will be set here.
Within a Strategy client machine, there is a resource bundle called WebApp.jar in the location of the Common Files for the Strategy Secure Enterprise installation. By default in a Windows environmen,t this is C:\Program Files (x86)\Common Files\Strategy\WebApp.jar and for Linux/UNIX /opt/Strategy/jar/WebApp.jar.
Inside of this JAR file, there are a number of configuration files for some of our local client machine utilities with the sys_defaults.xml being the major component for this behavior. Within the sys_defaults.xml file there are two options that will need to be either commented out <!--...--> or removed. These steps will need to be conducted for any machines that you are using to run these Command Manager scripts that are producing the behavior.
Since this is a low level configuration change please make sure that whenever this alteration is made that any Strategy processes are not being executed when the change is made and Technical Support recommends having a backup of the WebApp.jar file created before any changes are made.
- After the backup is made and the processes are shutdown navigate to the location of the WebApp.jar
- Using the archive utility of your choice extract the sys_defaults.xml file from the WebApp.jar file to a writable location.
- Edit the sys_defaults.xml file and remove or comment out the following two lines:
<pr des="Whether to enable the configuration of prepostfix for subscription" n="enable_prepostfix_ds" scp="server" v="1"/>
<pr des="The prepostfix for subscription" n="prepostfix_ds" scp="server" v="""/>
- Save the new copy of the sys_defaults.xml
- Using the archive utility merge the updated sys_defaults.xml file back into the WebApp.jar file and overwrite the currently bundled file.
- Restart any Strategy processes once the change has been made.
KB441284
