Who is this article for?

All Ideagen Quality Management Admins with workflow permissions.

Ideagen Quality Management site accessis needed.

Customers may encounter issues importing data into Ideagen Quality Management with the workflow import feature. 

To make troubleshooting this issue easier to learn, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are finding:

1. Issue Experienced
2. Resolution
3. Further Reading

1. Issue Experienced

This section will explain what occurs when the customer is experiencing the issue.

The customer will have noticed that when they used workflow import, new workflow instances were not created in Ideagen Quality Management. An entry similar to the following will be in the Ideagen Quality Management error logs. 

Exception message: Value "yes" not found in List Field "Request Accepted".
Value "36 inch Ruler (S/N ACS04914-1)" not found in List Field "Tools ".

Value "product" not found in List Field "Action item type".

Exception stack trace:

at Ideagen Quality Management.Tools.WorkflowInstanceImporter.Validation.FieldValueValidator.ValidateFieldValues(IEnumerable`1 workflowFields, DataTable importData)
at Ideagen Quality Management.Tools.WorkflowInstanceImporter.Services.WorkflowInstanceImportService.Import(WorkflowInstanceImportSettings settings)

2. Resolution 

This section will provide the resolution for why the workflow import did not create new instances. For a successful import to occur the case must match the list field as it has been created in custom fields (lowercase or uppercase). For example, if a value of "yes" was used instead of "Yes" in a list field, the data in the Excel spreadsheet would have to be lowercase. 

3. Further Reading

This section will provide important links to further troubleshooting and resources.