Page History

...

1. Download the DEC match template and populate it with information about the DECs that you want to match. The following table provides instructions for each column in the DEC match template:

   Column Name	Instructions
   Blank Column	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.
   Batch Sequence	Specify a unique sequence ID in each row.
   DEC Name	Enter text for the system to use for matching DEC Names.
   DEC Definition	Enter text for the system to use for matching DEC Definitions.
   Comments	TBD

   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. 

2. Save the file as CSV. 

3. Import the file into OneData:

   1. Log in as described in Logging In.

   2. From the Manage menu, select Manage Data. The Manage Data page appears. Select DEC Match. The DEC Match page appears. (For instructions on adding this page to your favorites, refer to Managing Favorites.)

   3. From the Import menu, select Conceptual Object Import. 

   4. Select the DEC Match Import row and click Import (between Add New Mapping and Go To Data Manager). 

   5. Under Source Information, in the Import from File row, click Choose File. Navigate to and select your CSV file from your desktop. 

   6. Click Import at the bottom of the page. DEC Match displays a message with the status of your import. 

4. Generate a list of DECs that match your file:

   1. From the Manage menu, select Manage Data. The Manage Data page appears. Select DEC Match. The DEC Match page appears.

   2. Specify search criteria, such as all or part of your Batch Name. The format for the Date Last Modified field is MM/DD/YY (such as 03/05/22). 

   3. Click Apply Filter. Search results appear. 

   4. Select the checkbox for the rows you want to match. Click Run DEC Match. DEC Match starts checking all the input columns from your CSV file against the caDSR DECs for possible matches. The process can take a while to run. DEC Match begins to fill in the number of matched DECs for each DEC Name in your CSV file. 

   5. You can navigate away from DEC Match and come back later to check whether it’s finished running. You can refresh the list of results by clicking Display Values.

5. Review the DECs that match your file. The following table describes the columns in the list of values: 

   Column Name	Description
   Batch Name	The Batch Name from your input file.
   Seq ID	The Batch Sequence from your input file.
   Date Last Modified	The last date a user modified this row. Initially, it is the date you ran DEC Match.
   Column Name	The DEC Name from your input file. When attempting to find a matching DEC, DEC Match inspects the (TBD) fields.
   User Tip	A phrase or term for DEC Match to use as a user tip instead of the column name. DEC Match saves only one entry for this column, even if this column is enumerated. DEC Match does not parse the phrase into individual terms.
   # Matched	The number of DECs that DEC Match identified as possibly matching the column.
   Match within Contexts	The Contexts for the system to use to match DECs.
   Match with Registration Status	The Registration Status for the system to use to match DECs.
   Model Long Name	The Model for the system to use to match DECs.
   Imported DEC Definition	The DEC Definition from your input file.
   Comments	The Comments from your input file.
   Public ID	The Public ID of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   Version	The Version of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   DEC Long Name	The Long Name of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   Workflow Status Name	The Workflow Status of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   Registration Status Name	The Registration Status of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   Context Name	The Context of the DEC that DEC Match identified as possibly matching the column, if there was only one.
   Sort Date	The Date Last Modified in an appropriate format for sorting.

6. To edit values in the Batch User, Batch Name, User Tip, Match within Contexts, Match with Registration Status, Match to Model, Comments, and Matched DEC columns, click the edit icon in the row you want to edit. A detail page appears for the selected item. In each text field, you may use any character except single quote ('). Make your changes and click Save. DEC Match confirms the change. Click Display Values. The list reappears with your changes. 

7. To review the matched DECs, click the edit icon in the row you want to review. A detail page appears for the selected item. Click the DEC Matched Results node. Select a row and click Set Preferred.

Tips for DEC Match

Related topics:

• Importing Items

• Mapping Models

• Exporting Items

• Troubleshooting Imports

...