Example: Importing a profile for a record layout

You can use an import profile to create a record layout from a simple schema specification.

The following specification (spreadsheet) is used:

Schemaname Financial
Fieldname Fieldtype Is Required Length
customerData
nameLast String man 22
nameFirst String man 16
accountData
acctNum String man 12
acctType String man 12
acctBal Double man 10
transactionData
transID String man 9
transDate Date man 8
transAmount Double man 10
transType Double man 3

And the following rules are applied:

The rules that are shown take the following actions on the content of the spreadsheet:

  • The content of the cell found to the right of "Schemaname" is used as the name of the new layout.
  • The column that contains the "Fieldname" cell is specified as containing the "Name" fields the layout.
  • The column that contains the "Fieldtype" cell is specified as containing the "Type" fields the layout.
  • The column that contains the "Is Required" cell is specified as containing the "Inclusion" fields the layout.
  • The column that contains the "Length" cell is specified as containing the "Length" fields the layout.
  • The Row Content = ^([^\t]+) matches the first column and create record groupings that use the matched text (three found).
  • Every row in the spreadsheet that is used to create a field in the layout contains "man" in the "Is Required" column. This field is used to designate that the column mapping rules are to be run on every row that contains "man" in that column.

The resulting layout, created according to the import profile and selected spreadsheet, is shown:

Schemas

Applying schemas and formats to messages

Changing schemas

Analyzing schemas

Creating file schemas

Record layouts