Transferring data to a delimited text file

Professional > Data management scripting > Transferring data using a DMS file > Writing data > Transferring data to a delimited text file

You can transfer case data to a text file that contains tab-delimited, variable length records. The text file typically has a .csv extension and can be imported in to Microsoft Excel. For more information, see Delimited Text DSC.

Writing to a new file

If the delimited text file you specify in the OutputDataSource section does not exist, the Delimited Text DSC will create a new file.

Writing to an existing file

The Delimited Text DSC will append data to an existing file that has the same name as the delimited text file to be written, but does not attempt to check whether the structure of the existing data and the new data are the same.

How do I specify an export to a delimited text file?

In the connection string in the OutputDataSource section, specify mrCsvDsc for the Data Source connection property. Then specify the name and location of the delimited text file, which will normally have a .csv extension, for the Location connection property, as shown below.

OutputDataSource(Output, "The output data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source = mrCsvDsc; _
    Location = <Name and location of .csv file>"
End OutputDataSource

Example

This example OutputDataSource section creates a delimited text file and an output metadata document (.mdd) file:

OutputDataSource(Output)
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrCsvDsc; _
    Location=C:\Program Files\UNICOM\Intelligence\
      <version>\DDL\Output\MyDelimTextFile.csv"
  MetaDataOutputName = "C:\Program Files\UNICOM\Intelligence\
    <version>\DDL\Output\MyDelimTextFile.mdd"
End OutputDataSource

A similar example is provided as a sample file called CreateCSVAndCategoryMap.dms, which is installed with the UNICOM Intelligence Developer Documentation Library. For more information, see Sample DMS files.