[bug] : CSV importer interpretes cell containing only whitespace as valid input

[isuscott]

CSV importer interprets cell containing only whitespace as valid input

• similar to Doesn't handle whitespace in email addresses in CSV imports #22

bug 🪳

• CSV importer interprets Article title cells with only whitespace as content as a valid Article
  • tends to be difficult to debug because errors can point to any other column
• whitespace cells in other columns also trigger errors
  e.g. error received that an invalid Stage was entered for "empty" cells

recommendation

• ignore cells containing only whitespace (space, tab, line feed (newline), carriage return, form feed, and vertical tab)

[ajrbyers]

Backlog Refinement: Add required field validation:

• Identify all required fields (this is well documented already)
• Required fields should be stripped of extra white space
• If this results in a null, none or blank field report this to the user and don't allow them to continue with the import