SUMMARY:
In Strategy 9.x, while performing a "Send Now" with the delivery format set to "CSV", the data fields are not enclosed by double quotes. In order to enable quoting of data fields for CSV while performing a "Send Now", follow the steps below:
1. On the Strategy Web 9.x server, locate the sys_defaults.xml file. On Windows this is located by default in C:\Program Files\Strategy\Web ASPx\WEB-INF\xml, look in "Program Files (x86)" for 64-bit versions of Windows.
2. Make a backup of this configuration file. NOTE: Making this change is system wide. This will affect all existing and future CSV files.
3. Edit the sys_defaults.xml file. Add the following two lines to the end of the file:
<pr des="" n="enable_prepostfix_ds" scp="system" v="1"/>
<pr des="" n="prepostfix_ds" scp="system" v="""/>
4. Save and close the file.
5. Restart the Web server.
The Send Now will now have quotes around all fields as shown below:
"Sawer" "Leanne" "302,400" "1"
"Kelly" "Laura" "278,238" "2"
"Kieferson" "Jack" "263,247" "3"
"Sonder" "Melanie" "40,258" "4"