Custom connection properties used by the Delimited Text DSC

This topic describes the custom connection properties that are unique to the Delimited Text DSC.

You can specify custom connection properties by adding the MR Init Custom or MR Custom connection property to the connection string.

MR [Init] Custom = "<property name> = <value> (; <property name> = <value>)*"

If the single characters "\" or ";" are used as the CsvFieldDelimiter, then the usage is as follows:

MR Init Custom = "CsvFieldDelimiter = \; ; UseMetaDataValues = 1"
MR Init Custom = "CsvFieldDelimiter = \\ ; UseMetaDataValues = 1"

Use the MR Init Custom property when you connect using the , for example, in DM Query or in a data management (.dms) script. If you are passing connection properties to an Delimited Text DSC object that you have created programmatically, use the MR Custom property.

For a list of all the standard connection properties that are available to the Delimited Text DSC, see Connection properties.

The character that the Delimited Text DSC must use as the delimiter character when reading from or writing to a .csv file. The default is a tab character.

Specifies the CSV file encoding type. Possible values include:

UseMetadataValues is a Long value that specifies the value used when reading or writing the categorical responses.

Reads and write the index value for the MDM category. This is the default value.

Read and write the IElementList_Value property, the MDM mapped value, for the MDM category.

Write the category label. UseMetadataValues = 3 is write‑only; that is, it cannot be used when reading the file.

When working with large datasets, or when reading categorical question values that are written as mapped values, set MR Init Custom='UseMetaDataValues=1' in the connection string. This uses the category name or category mapped value for category questions during data transformation, which improves performance when exporting data.

For more information, see "Single-response categorical variables" in Variable definitions when writing to a .csv file.

GroupType "Have you come with an organized group, with friends, or with family?"
categorical [1..1]
{
Organized "Organized group",
Friends "Friends only",
Family "Family only",
FamilyAndFriends "Family and friends",
NoAnswer "No answer" NA
};

UseMetadataValues	Response written to .csv
0 - Index	1
1 - Value	146
2 - Name	Friends
3 - Label	Friends only