1.5.1. CSV Message Format

See: Managing Channels - Manage a Channel

CSV Wizard screen allows you to define your csv message format according to your own file format.

A CSV or comma-separated values file is used for the digital storage of data organized in a table form. Each line in the CSV file corresponds to a row in the table, and within a line, fields are separated by commas (or semicolons, colons or tabs), each field belonging to one column of the source table.

As this is a very common and simple file format, CSV files are often used to move tabular data between different computer programs, such as between a database and a spreadsheet program.

To define a message in CSV format, select an existing template or make a copy of the generic CSV template in the catalogue and following screen will be displayed.

File sample

Following is a sample CSV file.

NAV Date,ISIN,Fund Name,Share Typ,Fund Ccy,NAV in Fund Ccy,Bid Price in Fund Ccy,Offer Price in Fund Ccy,TNA,Outstanding,Publication Ccy,NAV in Publication Ccy,Bid Price in Publication Ccy,Offer Price in Publication Ccy,Equity Profit,WKN Code,Zwischengewinn,TIS,TID
06/13/2008,LU0223208157,HSBC GIF EMERGING EUROPE EQUITY,AC,EUR,15.088,15.088,15.924,12190498.17,807980.236,GBP,11.96,11.96,12.623,37.650,A0ER9A,0.001,,

Wizard screen

When you create a new message format, you must first configure it using the following wizard.

Figure 1.31. CSV Wizard screen

The following parameters must be set up:

You can define your csv message file format either using a sample file or manually.
If you have a sample file, select it using the Browse... button then click on the Upload command. The first 2 lines of the sample file will be displayed in File Content text box.
You may modify or manually enter the columns names directly in File Content text box.
If you message files contain a header line before data lines, check Contains header? option box.
Select the Delimiter used to separate data in your files.
Select the Quote Character used to define text strings in your files.
Select the Encoding used to create your files (UTF-8, ISO-8859-1 or Cp1252).

Edit screen

Once this message format has been saved, or when it is used or copied from a saved format, edit screen appears as follows.

Figure 1.32. CSV Edit screen

See Message Edit Functions for further information on message definition, contextual menu and additional commands available on this screen.

Prev	Up	Next
1.5. Message In	Reference Manual	1.5.2. EDIFACT Message Format