Topic: Problem with import
I have just tried to do an import to Recorder, not too big (c4,700 rec) and on pressing the final GO it crashed and the error was string or binary will be truncated, but no indication of which field is causing the problem!
The three obvious are:
Observers: max length is 77 chars
Location Name: max length is 56 characters
Abundance: max length is 66 chars
Firstly, is any of these too long for the import? - if these are OK what other potential fields can cause this error?
Secondly, why didn't it check this BEFORE actually starting the import process, it should be part of the initial validation
Craig
Staffordshire Ecological Record