Bundt User's Manual · Bundt Toolset version 1.0.1.0

Import Data dialog box

This dialog box helps you define a data import specification so data can be imported from a text file into an instance model.

Elements

Source file name text box Enter the file name where data to be imported will be read from.
Check button Verifies that the file is readable and that it conforms to the import specification. Then attempts to infer column mappings from its contents.
Browse button Allows you to browse for a source file name.
Target class dropdown list Select the class that will receive the objects to be imported.
Column mappings panel
(list) list Displays the columns that will be imported from the file. For each column, the title and the mapped feature are given.
Add New button Shows the Add New Column Mapping dialog box to create a new column mapping.
Infer button Automatically infers column mappings for the selected source file and target class, using the specified options. You can select whether you want column mappings for attributes, semi-associations, or all features.
Delete button Deletes column mappings. You can select whether you want to delete only the selected column mapping or all column mappings for attributes, semi-associations, or all features.
Move Up button Moves the selected column mapping up in the list. If column headers are being used (see below), then this is not available, as column order is provided by the file format.
Move Down button Moves the selected column mapping down in the list. If column headers are being used (see below), then this is not available, as column order is provided by the file format.
Properties button Shows the Column Mapping Properties dialog box to modify the selected column mapping.
Options panel
Use column headers check box Check this box to indicate that the source file contains column headers as a top row; leave it unchecked if it doesn't include a headers row.
Use row object identifiers check box Check this box to indicate that the source file contains object identifiers as a leftmost column; leave it unchecked if it doesn't include an identifiers column.
Use multilingual texts check box Check this box to indicate that the source file contains multilingual texts; leave it unchecked if it only contains single default-language texts.
Default perspective qualifier qualifier picker Pick a perspective qualifier to use as default when the source data contains perspectives, or leave blank for unspecified.
Default phase qualifier qualifier picker Pick a phase qualifier to use as default when the source data contains phases, or leave blank for unspecified.
Column separator combo box Select or enter the text that the source file uses as column separator.
Value delimiter begin combo box Select or enter the text that the source file uses as begin delimiter for data values, or none for non-delimited values.
Value delimiter end combo box Select or enter the text that the source file uses as end delimiter for data values, or none for non-delimited values.
Collection separator combo box Select or enter the text that the source file uses as a separator within data values when these are composed of multiple contents.
Language separator combo box Select or enter the text that the source file uses as a separator within data contents when these are multilingual.

Proceed

As soon as you click OK, ModelDesigner attempts to:

  1. Read from the specified file
  2. Iterate over each read row of data
  3. Extract data contents according to the specified column mappings and the selected options
  4. Create a new object of the selected target class
  5. Update the object with the extracted data

See Also


Contents distributed under a Creative Commons Attribution 4.0 International License · About · Terms of Use · Contact Us · last updated on 08 October 2020