Professional > Data management scripting > Transferring data using a DMS file > Writing data > Transferring data to a delimited text file
 
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.
See also
Transferring data using a DMS file
Writing data