Page History

...

1. Download the model import template. (Start with a fresh template for each import.) 

2. (When opening your copy of the template, select Enable Macros? TBD)

3. Populate your file with information about the models that you want to import. The following table provides instructions for each column in the model import template. Column names with asterisks are required:

   Column Name	Instructions
   DO NOT USE	Leave empty.
   Batch User	Enter a batch user name in each row. You can provide any text in this column. The system does not validate this column.
   Batch Name	Enter a batch name in each row. The combination of Batch User and Batch Name must be unique.
   Seq ID	Specify a unique sequence ID in each row.
   *Model Name	The Specify the name for the model as assigned by the model owner.
   *Model ID	This is the Specify the unique identifier for the model in caDSR.
   *Model Version	The version Specify the version of the model that is registered in caDSR.
   Element Long  Name	The long Specify the long name for the element in caDSR assigned by the model owner.
   *Element Physical Name	The name Specify the name of the element in the physical database. This is used in the mapping rules and for those needing to write programming language implementations of the rules.
   Element Description	The model Specify the model owner's description of the model element.
   Element Type	The kind Specify the kind of model element this item represents, such as Table, Node, Class. This is usually driven by the type of model being registered.
   Characteristic Long Name	The long Specify the long name of the characteristic with no restrictions on the format.
   *Characteristic Physical Name	The physical Specify the physical name of the characteristic. This should be formatted exactly as it is in the database. This name will be used in the generated transformation rule.
   Characteristic Order	The Specify the preferred order of the characteristic within the element to enable sorting , if you want to sort the list of characteristics by something other than alphabetical order.
   Characteristic Description	The description Specify the description of the characteristic.
   Characteristic Type	The characteristic Specify the characteristic type.
   Characteristic Min Length	The minimum Specify the minimum length of the characteristic.
   Characteristic Max Length	The maximum Specify the maximum length of the characteristic.
   Characteristic Data Type	The data Specify the data type of the characteristic, such as integer or varchar(50).
   Characteristic UOM	The unit Specify the unit of measure of the characteristic.
   Characteristic Mandatory?	Is Specify whether the characteristic is mandatory?.
   Characteristic PK?	Is Specify whether the characteristic is a primary key (or part of a primary key) for the element?.
   Characteristic Default	The Specify the default value for the characteristic.
   CDE IDThe	CDE Specify the CDE public ID.
   CDE Version	The CDE Specify the CDE version number.
   Element Mapping Group	A Specify the element mapping group, which is s high-level alignment of this model element with a common core semantics or meaning of the element. If CDEs are linked with the associated characteristics, the CDE semantics will be used for the characteristic, even if different than mapping group.
   Characteristic FK?	Does Specify whether the characteristic have has a parent via foreign key association?.
   FK Element Name	The Specify the parent element name, if the characteristic is a foreign key.
   FK Element Characteristic Name	The name Specify the name of the foreign key element characteristic.
   CommentsTBD	Enter comments.

   As you populate your file, keep in mind the following points:

   • You may add additional columns to your file for taking/keeping notes after the last template column, but the column names must be unique.

   • You can use your Delete key to clear the contents of one or more individual cells, but do not delete entire rows or columns. 

4. Save the file as CSV. 
5. Log in as described in Logging In.
6. From the Manage menu, select Manage Data. The Manage Data page appears. Select Model Import. The Model Import page appears. (For instructions on adding this page to your favorites, refer to Managing Favorites.)
7. From the Import menu, select Data Object Import. 
8. Import the file, as described in TBD.

...