Using the CSV Record Wizard

InterSystems IRIS provides a wizard to help automate the process of creating a record map from a sample file that contains comma separated values (CSV). You initiate the CSV Record Wizard either by choosing it on the InterSystems IRIS Build submenu or by clicking CSV Wizard from the ribbon bar on the Record Mapper page. The wizard handles only files with a single level of separator and does not handle leading data.

From the wizard, you enter values for the following fields:

Sample file

Either enter the complete path with filename of your sample or click Select file to navigate and choose your sample file.

RecordMap name

Enter the name of the record map to generate from your sample file.

Separator

Separator character used in the sample file. You must enter control characters in hexadecimal; see Common Control Characters.

Record Terminator

Specify how the sample file terminates a record. Choose one of the following:

CRLF — each record ends with a carriage return, followed by a line feed.
CR — each record ends with only a carriage return.
LF — each record ends with only a line feed.
Other — each record ends with control characters. Enter control character values in hexadecimal; see Common Control Characters.

Character Encoding

Select the type of character encoding used in the sample file.

Sample has header row

Select this check box if the sample file you provide contains a header row.

In this case, InterSystems IRIS removes any punctuation and white space from values in the header row, and then uses the resulting values as property names in the record map. (If you do not select this option, InterSystems IRIS specifies the property names as Property1, Property2, and so on.)

Keep SQL Column order

Select this check box to keep the SQL column order in the generated object.

Quote-style escaping in use

Select this check box and the quote character if the sample file uses quote-style escaping of the separator.

When you are finished filling out the wizard form, click Create RecordMap to generate a new record map from your sample file and return to the Record Mapper page. You can now refine your record map to add detail to the generated properties. See Editing the Record Map Properties for details.

Record Map Class Structure

Creating and Editing a Record Map