On this page


Using UML properties upon import

If you want to use UML properties when importing a file, you can do by updating the system properties file.


To use UML properties upon import

  1. Go to the <modeling_tool_installation_dir>\bin\ and open the <modeling_tool>.properties file for editing.
  2. In the file, find the JAVA_ARGS line and add -DUSE_UML_TYPES_IN_EXCELSYNC=true as one of the values.
  3. Save the file and re-open the modeling tool.

Skipping empty rows and/or columns upon import

By default, the import of the Excel sheet's data is stopped if an empty row or column is encountered. If your Excel sheet contains purposefully created empty rows or columns and you do not want the reading of the file to be stopped by them, you need to specify that in the tool. You can do so either by updating the system properties file or an appropriate table tag. By indicating the number of consecutive empty rows or columns that should be skipped, the file's data is continued to be read after the empty rows/columns.

  • If the options for skipping empty rows/columns are set both via the system properties file and the table tag, but they have different numeric values, the table tag value overrides the one set via the system properties file.
  • The empty rows/columns themselves cannot be imported from the file to the modeling tool's table; they can either be treated as the end of the file (default) or skipped (see procedures below).

To skip empty rows/columns via table tag

  1. Open the Specification window of the table.
  2. In the property groups list, select Tags. If you cannot see the Tags group, make sure the Properties mode is set to All.
  3. Select the numberEmptyRowsSkip tag of the «MapToDataSource» stereotype and click the Create Value button.
  4. On the right side of the window, input a numeric value of consecutive empty rows to be skipped.
  5. Select the numberEmptyColumnsSkip tag of the «MapToDataSource»  stereotype and click the Create Value button.
  6. On the right side of the window, input a numeric value of consecutive empty columns to be skipped.
  7. Click Close.


To skip empty rows/columns via the system properties file 

  1. Go to the <modeling_tool_installation_dir>\bin\ and open the <modeling_tool>.properties file for editing.

  2. In the file, find the JAVA_ARGS line, add the following values, and replace POSITIVE_NUMBER with a numeric value of consecutive empty rows/columns to be skipped:

    -Dnumber.empty.rows.skip=POSITIVE_NUMBER
-Dnumber.empty.columns.skip=POSITIVE_NUMBER
  3. Save the file and re-open the modeling tool.

Mapping elements by ID upon export

By default, exporting table data to a synced file removes any previously existing content in the file. If you want to export table data to a synced file while keeping any existing data in the file, you can do so either by updating the system properties file or an appropriate table tag. This way, elements are mapped by ID, and the new data is added to the file.

If mapping options are set both via the system properties file and the table tag, but they have different boolean values, the table tag value overrides the one set via the system properties file.

To map elements by ID via table tag

  1. Open the Specification window of the table.
  2. In the property groups list, select Tags. If you cannot see the Tags group, make sure the Properties mode is set to All.
  3. Select the exportByIdentificationProperty tag of the «MapToDataSource» stereotype and click the Create Value button. 
  4. On the right side of the window, click the Edit edit_button.png button to set the tag value to true.
  5. Click Close.


To map elements by ID via the system properties file 

  1. Go to the <modeling_tool_installation_dir>\bin\ and open the <modeling_tool>.properties file for editing.
  2. In the file, find the JAVA_ARGS line and add -Dexport.table.by.identification.property=true as one of the values.
  3. Save the file and re-open the modeling tool.

Color marking modified data upon export

If you want to color-mark exported table data based on its changes (added/updated/removed, same as in the modeling tool's table), you can do so either by updating the system properties file or appropriate table tags. This allows you to easily review data changes and make any necessary adjustments based on this information.

  • If color marking options are set both via the system properties file and the table tag, but they have different boolean values, the table tag value overrides the one set via the system properties file.
  • To apply color marking, mapping elements by ID must be enabled first.
  • Any data deleted in the table is marked in red in the exported Excel file. If, upon the file's review, you deem this data truly unnecessary, make sure to remove it from the Excel file. Otherwise, this data will be imported back into the table upon Read From File action. 

To color mark modified data via table tag

  1. Open the Specification window of the table.
  2. In the property groups list, select Tags. If you cannot see the Tags group, make sure the Properties mode is set to All.
  3. Select the markExportedRows tag of the «MapToDataSource» stereotype and click the Create Value button.
  4. On the right side of the window, click the Edit edit_button.png button to set the tag value to true.
  5. Click Close.


To color mark modified data via the system properties file 

  1. Go to the <modeling_tool_installation_dir>\bin\ and open the <modeling_tool>.properties file for editing.
  2. In the file, find the JAVA_ARGS line and add -Dexport.table.mark.exported.rows=true as one of the values.
  3. Save the file and re-open the modeling tool.


As a result, the cells of the exported table are marked based on their changes in comparison to the data stored in the file prior to its export. The colors used for the marking and their meanings:

  • Red - removed
  • Blue - updated
  • Green - added

Opening linked Excel/CSV file with the table

To open a linked Excel and/or CSV file directly from a modeling tool table

  1. On the table toolbar, click .
  2. Select Excel/CSV File > Open File.
    The linked file is opened.

Removing the reference between the Excel/CSV file and the table

If you linked the Excel/CSV file with modeling tool table, the reference between them is created. Read step #3 to link Excel or CSV file with the table >>

To remove it, follow the procedure below. 

To remove a reference between a Excel/CSV file and a modeling tool table

  1. On the table toolbar, click .
  2. Select Excel/CSV File > Clear Selection.
    The reference between tables is removed.