NIH | National Cancer Institute | NCI Wiki  


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

  2. Populate your copy of the template with information about the DECs that you want to import or update. The following table provides instructions for each column in your copy of the template:

    Column NameRequired?Instructions
    Do Not UseNo.Leave empty. 
    Batch UserYes, for all imports and updates.Enter a batch user name in each row. You can provide any text in this column. The system does not validate this column. 
    Batch NameYes, for all imports and updates.Enter a batch name in each row. The combination of Batch User and Batch Name must be unique.
    Seq IDYes, for all imports and updates.Specify a unique sequence ID in each row. 
    Context NameYes, for all DEC imports and updates.Each cell in this column has a drop-down list of all valid Contexts. Select a value from that list. 
    DEC ID (Update Only)Yes, for all DEC updates.Specify the public ID of the DEC you want to update. 
    DEC Version (Update Only)Yes, for all DEC updates.Specify the version of the DEC you want to update. 
    Optional Specified DEC Long NameNo.Specify the long name of the DEC. 
    Optional Specified DEC Short NameNo.Specify the short name of the DEC.
    OC ConceptsYes, for all DEC imports and updates.Specify object class concepts. Enter the primary concept last. 
    Prop ConceptsYes, for all DEC imports and updates.Specify property concepts. Enter the primary concept last. 
    DEC CD NameYes, for all DEC imports.Each cell in this column has a drop-down list of all Standard Conceptual Domain Names. Select a value from that list. The system automatically populates the CD Public ID in the next column. 
    CD Public IDYes, for all DEC imports.When you select a DEC CD Name in the previous column, the system automatically populates the CD Public ID in this column. 
    Optional DEC OriginNo.Each cell in this column has a drop-down list of all DEC origins. Select a value from the list.
    CommentsNo.Specify comments.

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

    • To create new DECs, complete the columns for:
      • Batch User
      • Batch Name
      • Seq ID
      • Context Name
      • Object Class Concepts
      • Property Concepts
      • DEC Conceptual Domain Name
      • DEC Conceptual Domain ID
    • To update existing DECs, complete the columns for:
      • Batch User
      • Batch Name
      • Seq ID
      • Context Name
      • DEC ID
      • DEC Version
      • Object Class Concepts
      • Property Concepts
    • For an update:
      • If you populate any other columns, this update process treats them as changes to the existing DEC.
      • This update process cannot update retired DECs.
      • This update process sets the DEC Workflow Status to DRAFT NEW.
    • 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 Import - Update. The DEC Import - Update page appears. (For instructions on adding this page to your favorites, refer to Managing Your Favorites.)
    3. From the Import menu, select Data Object Import. 

    4. Select the DEC Import v1 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. The system displays a message with the status of your import.

  5. Generate a list of DECs from your file:

    1. Click Go To Data Manager. The DEC Import - Update 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.

  6. To edit values:
    1. Click the edit icon in the row you want to edit. A detail page appears for the selected item.
    2. Click DEC Import - Update Command > Validate DEC. Review the Generated DEC name and revise the Concept information as needed. If you make any changes, click Save and click Validate DEC again. 
    3. When validation passes, click DEC Import - Update Command > Create DEC or Update DEC. The system displays the new or updated DEC ID. 
    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).


  • No labels