1 Reply by mhorlock

  • mhorlock
  • Member
  • Offline
  • From: Norwich
  • Registered: 07-01-2009
  • Posts: 17

Re: Import wizard error

Hi

I have been trying to use the wizard to import an excel spreadsheet and keep getting the following error:

The import process failed to insert an output record in table rule 'Survey_Event' the import job was aborted

The error that occurred was:

String or binary data would be truncated

This is probably due to an error in definition of the import process

I have tried leaving out the fields that I thought might suffer from truncation but to no avail. Does anyone have any suggestions?

Regards
Martin

Martin Horlock
Norfolk Biodiversity information Service

mhorlock's Website

2 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Import wizard error

The import wizard looks down the spreadsheet and creates a max length for each field based on the records in the first set of rows (not sure how many exactly but certainly not all of them unless you don't have many). So the way to get round potential truncation is to move some of the rows with the longest entries in the fields towards the top (or at the top to be safe). This will then set the field length to a larger number and should reduce/eliminate truncation. In particular those related to Survey_Event. I presume that you are on the latest version of Recorder - 6.13.3?

Hope this helps,
Lynn

3 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Import wizard error

Does this post help? http://forums.nbn.org.uk/viewtopic.php?pid=4053#p4053

A Google site search finds other references to this error, i.e. searching for
site:forums.nbn.org.uk String or binary data would be truncated

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687