EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB44499: How to add double-quotes around all data fields for CSV while perfoming a Send Now in MicroStrategy.


Community Admin

• Strategy


How to add double-quotes around all data fields for CSV while perfoming a Send Now in MicroStrategy.

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" 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017