NIH | National Cancer Institute | NCI Wiki  

WIKI MAINTENANCE NOTICE

Please be advised that NCI Wiki will be undergoing maintenance Monday, July 22nd between 1700 ET and 1800 ET and will be unavailable during this period.
Please ensure all work is saved before said time.

If you have any questions or concerns, please contact the CBIIT Atlassian Management Team.

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Revising based on the "DEC Bulk Load Instructions Sprint23 v1.docx" file from the "Templates ..." page.

...

  1. Download the DEC 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 DECs that you want to import. The following table provides instructions for each column in the DEC import template:

    Column NameInstructions
    Do Not UseLeave 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.
    Seq IDSpecify a unique sequence ID in each row.
    Context NameEach cell in this column has a drop-down list of all valid Contexts. Select a value from that list. 
    Optional Specified DEC Long NameTBD
    Optional Specified DEC Short NameTBD
    OC ConceptsTBDSpecify object class concepts. Enter the primary concept last.
    Prop ConceptsTBDSpecify property concepts. Enter the primary concept last.
    DEC CD NameEach 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 IDWhen you select a DEC CD Name in the previous column, the system automatically populates the CD Public ID in this column.
    CommentsTBD

    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. 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. The DEC Import page appears. (For instructions on adding this page to your favorites, refer to Managing Favorites.)
    3. From the Import menu, select Data Object Import
    4. Select the DEC 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. VM Match displays a message with the status of your import.

  6. Generate a list of DECs that match your file:
  7. Generate a list of DECs that match your file:

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

    2. Specify search criteria,

    as described in TBD
    1. 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). 

    2. Click Apply Filter. Search results appear. The system displays one row per DEC.

  8. 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 Validate DEC. Review the Generated DEC name and revise the Concept information as needed. If you make any changes, click Validate DEC again. 
    3. When you have entered the correct OC and Property Concepts and the Generated Name appears as expected, click Create DEC. The system displays the new 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).

Related topics:

...