NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added a link.

...

  1. Download the DEC match template from Templates and Instructions for Bulk Imports and Matching.  

  2. Populate your copy of the template and populate it with information about the DECs that you want to match. The following table provides instructions for each column in your copy of the DEC match template:

    Column NameInstructions
    Blank ColumnLeave empty. 
    Batch UserEnter a batch user name in each row. You can provide any text in this column. The system does not validate this column. 
    Batch NameEnter a batch name in each row. The combination of Batch User and Batch Name must be unique.
    Batch SequenceSpecify a unique sequence ID in each row.
    DEC NameEnter text for the system to use for matching DEC Names.
    DEC DefinitionEnter text for the system to use for matching DEC Definitions.
    CommentsOptionally, specify 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. 

  3. Use the Microsoft Excel "Save As" feature to save your copy of the template as CSV.  

  4. 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. 

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

    1. Click Go To Data Manager. The DEC Match page reappears.

    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. The system displays one row per DEC.

    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. If there is only one exact match, the system automatically associates the matched result with the imported DEC.

    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.

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

    Column NameDescription
    Batch NameInitially, the Batch Name from your input file. 
    Seq IDThe Batch Sequence from your input file. 
    Date Last ModifiedThe last date a user modified this row. Initially, it is the date you ran DEC Match. 
    Column NameThe DEC Name from your input file. When attempting to find a matching DEC, DEC Match inspects the (TBD) fields.
    User TipA phrase or term for DEC Match to use as a user tip instead of the DEC name from the input file. DEC Match saves only one entry for this DEC, even if it is enumerated. DEC Match does not parse the phrase into individual terms. 
    # MatchedThe number of DECs that DEC Match identified as possibly matching the column. 
    Match within ContextsOne or more Contexts for the system to search for matching DECs.
    Match with Registration StatusThe Registration Status for the system to use to match DECs.
    Model Long NameThe Model for the system to use to match DECs.
    Imported DEC DefinitionThe DEC Definition from your input file.
    CommentsInitially, the Comments from your input file, if any.
    Public IDThe Public ID of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    VersionThe Version of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    DEC Long NameThe Long Name of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    Workflow Status NameThe Workflow Status of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    Registration Status NameThe Registration Status of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    Context NameThe Context of the DEC that DEC Match identified as possibly matching the column, if there was only one.
    Sort DateThe Date Last Modified in an appropriate format for sorting. 
  7. 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:

    1. Click the edit icon in the row you want to edit. A detail page appears for the selected item.

    2. Make your changes:

      • In each text field, you may use any character except single quote ('). 

      • In the Match within Contexts field, enter one or more contexts to search for matching DECs. Separate each DEC with a comma. Do not use spaces between DECs. For example: XXX,CTEP,CCR

    3. Click Save. DEC Match confirms the change.

    4. To view the next DEC from your imported file, click the Go to the next page icon (the triangle icon after Rows x of xxx).
    5. Click Display Values. The list reappears with your changes. 

  8. 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.

  9. Download the results using the Delivery Options feature, as described in Delivering Items.

...