Providing a spreadsheet file (CSV or XLS) as input with one or more blank rows can cause unhelpful exceptions to be raised. The service should be able to process or skip blank rows without raising an error.
๐ To Reproduce
Steps to reproduce the behavior:
Submit the attached XLS spreadsheet to the service via the reserve action
Observe that the following exception is raised: pds_doi_service.core.input.exceptions.CriticalDOIException: 'NaTType' object has no attribute 'lower'
๐ต๏ธ Expected behavior
Service should process the spreadsheet with blank rows without raising an exception.
๐ Describe the bug
Providing a spreadsheet file (CSV or XLS) as input with one or more blank rows can cause unhelpful exceptions to be raised. The service should be able to process or skip blank rows without raising an error.
๐ To Reproduce
Steps to reproduce the behavior:
pds_doi_service.core.input.exceptions.CriticalDOIException: 'NaTType' object has no attribute 'lower'
๐ต๏ธ Expected behavior
Service should process the spreadsheet with blank rows without raising an exception.
๐ Version of Software Used
v2.1.0
๐ฉบ Test Data / Additional context
DOI_reserve_M2020_IMG_Release2_v2.xlsx
๐Screenshots
๐ฅ System Info
๐ฆ Related requirements
โ๏ธ Engineering Details