Hi,
I've run a fairly large import and have 28 failed items - pretty reasonable considering the state of the data, so kudos to CMSImport! However, the error messages for these 28 items don't allow me to identify which lines of data are the problem ones. e.g. The first three errors are:
Error while importing data for property 'price' :Conversion failed when converting the nvarchar value ' ' to data type int.
Error while importing data for property 'price' :Conversion failed when converting the nvarchar value ' ' to data type int.
Error while importing data for property 'price' :Conversion failed when converting the nvarchar value ' ' to data type int.
It would be really handy to have a list of the titles of these failed nodes, or the line numbers in the source data, to be able to identify the failures and manually correct them.
Is there a way to do this? I've looked at the umbraco log table in the database and that flags up the items but doesn't provide any useful way - as far as I can see - to identify them.
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/35447-how-to-identify-erroring-cmsimport-items