Category

All Imports

Use Data Validation

1. Please always start with a fresh Template with Data Validation to help avoid uncaught errors due to invalid manually entered data.  We have added a lot more error handling in this release, but it's not perfect yet, in particular when invalid or retired concepts are used.

Delete/Purge

2. When reimporting, it is safest to select all the rows and "Delete", the select "Purge", then select all rows and “Purge Records"

Unique Column Names

3. You may add additional columns to the template for taking/keep notes after the last template column, but the column names must be unique.

Invalid or Retired Concepts

4. Invalid VM Concepts on import are not saved it the system and can create a GAP in the concept drop down. If the invalid concepts is the last qualifier concept, the system will not be able to detect it. Curators should fix all Concept Errors reported on Import BEFORE Validating. In Sprint 37 we will keep the Import Message visible after Validate to make it easier not to miss this important information.

Concept Formatting

5. Concept String should not contain commas, tabs or or other hidden characters. Always "Paste Values" in order to avoid issues.

CSV Files!!

6. Template must be saved as csv for importing. Other file types will cause an error.

Seq ID Rules

7. Seq ID must be an integer

Import Excpetions

8. Missing Batch User, Batch Name, Seq ID will cause Exception

Except Row Number

9. Multiple missing required fields may not report the correct row number in the Exception Message.  Inspect the template for empty cells.

Save / Revalidate

10. If making changes through front-end, Save and Revalidate.This will refresh the messages.

CDE Imports

CDE Date Created

1. Newly created CDEs have Date Created includes the timestamp. 09/15/2022 21:04:03.000000000 This will be fixed in Sprint 37 - 2147.

Duplicates in File

2. Duplicates rows within the imported file are not caught on Import. Improve in Sprint 37 - 2151

DEC Imports

Constrain CD Popup

1. CD Popup need to be constrained by Context in addition to workflow status - Fixed in Sprint 37 - 2114

Validating Lots of Rows

2. Sometimes the system throws an error when attempting to validate more than 4 rows at a time. If that happens try validating a few rows at a time.

VD Imports

Constrain CD Popup

1. CD Popup need to be constrained by Context in addition to workflow status - Fixed in Sprint 37 - 2114

PV VM Imports

Specified VM Definition

1. Optional Specified VM Definition is only used if the VM Type is "TEXT". The system will not throw an error but it won't be added to the VM. The Caption and column heading in the template will be changed in Sprint 37 - 2131

Message for Non-Enumerated

2. VD error improvement, if VD is non-enumerated it reports "VD is either invalid, retired or non-enumerated", but if VD is retired it reports "VD is Retired" - Fixed in Sprint 37 - 2132

Extraneous Missing Alt Name

3. Extraneous warning "WARNING: Missing Alt Name, Alt Name will not be created." VM Alt Name is optional, but this message is issued for Seq IDs when there is no Alt Name details provided. - Fixed in Sprint 37 - 2168

Possible Timeout

4. Validate/Create will timeout if more than 5 minutes. Try batches of 100 until we can redesign the code. - Watch

VM Reuse

5. In Sprint 36, if a Text VM is specified and an existing VM with the exact name is found, it will be reused, even if it has concepts. The Validation message will indicate that existing VM is being used (need to fix spacing). Is this ok?

Designation Imports

Import Exceptions

1. If AI ID, AI Version, AI Type or Alt Name are missing it will throw an Exception. The redesign to import without any validation will solve this problem. - Fix in Sprint 38 - 2193

Consistency Checking

2. If AI Long Name does not match the specified AI Public ID Long Name, the system will show an error. We are requesting AI Long Name and AI Type to ensure Alt names are not inadvertently add to the wrong AI. There currently is no validation step, just import, create. Public IDs are very similar, typos are easy to make. If this becomes onerous we could add a Validate Step to display the AI Long Name and AI Type for curator to see and visually verify before selecting Create.