...
Once the file has imported, it will show as Pending in the list of Imports. Click the 
import button to validate and import the file.
Progress will be shown when importing the file 
If the file passes validation and is imported, the Import Status will show as Imported 
If there are any errors, none of the data will be imported.
...
If there are any errors, these will be shown in the same way as when importing and the report will not be generated.
Once the report has been downloaded, it will be removed.
Viewing errors
If there are any errors when validating the file during importing or generating the what if report, the import will show the Error status as above.
...
Error messages may be reviewed on the page or exported to CSV.
Date Formats
Formats can be set on date columns to import different date formats. Select an example from the list or enter a format using the rules below. These are case sensitive.
- d - The day of th month, from 1 to 31
- dd - the day of the month from 01 to 31
- M - the month from 1 to 12
- MM - the month from 01 to 12
- MMM - the abbreviated name of the month (Jan, Feb...)
- MMMM - the full name of the month
- yy - the year from 00 to 99
- yyyy - the year as four digits
- yyyyy - the year as five digits. E.G. 02021
- / - date separator
- Any character not in the following list may be used as a date separator
- d,dd,ddd,dddd,f,ff,fff,ffff,fffff,ffffff,fffffff,F,FF,FFF,FFFF,FFFFF,FFFFFF,FFFFFFF,g,gg,h,hh,H,HH,K,m,mm,M,MM,MMM,MMMM,s,ss,t,tt,y,yy,yyy,yyyy,yyyyy,z,zz,zzz,:,/,%
Invisible Fields
Defined Columns
...