File Upload Outcomes

Scenario	Action	Flash Message Error Text	Import History Error Text
File successfully uploaded		[100] out of [100] rows have been added or updated
Uploaded file contains duplicates.	Fail only rows with missing required values.	[99] out of [100] rows have been added or updated. Row [55] was not uploaded because it's a duplicate of row [54]	Row 55 was not uploaded because Number is duplicated
Uploaded file has blank cells within one or more required fields.	Fail only rows with missing required values.	[99] out of [100] rows have been added or updated. Row [55] was not uploaded because it contains blank cells: Fiscal Year, Invoice Number, Order ID, Invoice Date, Invoice Amount (list only the fields where the data is missing)	Row 233 was not uploaded because Order Identifier can't be blank
Date format is wrong	Fail only rows with missing required values.	[99] out of [100] rows have been added or updated. Row [55] was not uploaded because Invoice date format must include 4 digit year Row [2] was not uploaded because Invoice Date is not a valid date and can't be blank	Row 2 was not uploaded because Invoice Date format must include 4 digit year  OR Row 2 was not uploaded because Invoice Date is not a valid date and can't be blank (
Fiscal Year format is wrong	Fail only rows with missing required values.	0 out of 2 rows have been added or updated. Row 2 was not uploaded because Fiscal Year format must include 4 digit year Row 3 was not uploaded because Fiscal Year format must include 4 digit year	Row 2 was not uploaded because Fiscal Year format must include 4 digit year
Uploaded file does not have required headers.	Fail the entire file	Upload failed. The template is missing the following required column headers: [list missing column headers]	Upload failed. The template is missing the following required column headers: Invoice Number (required), Order ID (required), Invoice Date (required), Invoice Amount (required), Fiscal Year (required)
Upload file contains one set of quotation mark	Fail the entire file	CSV::MalformedCSVError (Illegal quoting in line 51.) Remove prohibited single quotation mark in one or more lines and retry.