1 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: How do I ...Understand import error message

Hi

I have tried to import to R2K2 a file of bird data that i had recently typed up and seemed to be 'clean' - ie in the import process, all the species were correct, the people were correct, the places were correct and the notes about 'adult', 'male', etc were all as in the database. On import, 57 items were rejected, but which ones? I find the messages incomprehensible and there is no reference to the actual field and its contents that are the problems. How can I translate the technical gobbledegook into a message that might help me, the mere user? Examples are:

Failed to insert DSS00171000007KX into SAMPLE
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'SURVEY_EVENT'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------

Failed to insert DSS00171000007KM into SURVEY_EVENT_RECORDER
Access Database Error Message:
Access Status 3201 - You can't add or change a record because a related record is required in table 'SURVEY_EVENT'.
DBI Error Code = Titan (BDE) Error 3201.
--------------------

Any guidance would be very welcome so that I know what to do with the partially imported file.

Thanks in anticipation,

Cheers, Ian

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: How do I ...Understand import error message

Ian, I feel your pain. The import rejects file is an intimidating thing and could seriously do with an overhaul in terms of design in order to make it usable for mere mortals. The one in R6 is worse, because instead of giving you a reason for why something failed, you just get an ODBC -- Call failed message. Mike Weideli showed me how to analyse the file by hand in Access, but it's an extraordinarily laborious process.

Anyway, the two errors in your example would indicate that a Survey Event couldn't be created, which has the knock on effect of preventing the SAMPLE and SURVEY_EVENT_RECORDER and so on (essentially, anything related to that Survey Event) from being created. At the last stage of the import process, did you get any invalid items on the invalid items tab? It's easy to miss items on there if you're not careful. This might explain why the survey event couldn't be created (it might be outside the date range of the survey, or outside of the survey's bounding box, for instance). You can go through the import process again to look for invalid items - it won't do any harm to your database.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: How do I ...Understand import error message

Hi Charles

Many thanks for your reply. When I have tried to find invalid items again, by using the Import Wizard again, I have ended up with multiple copies of valid records in the database (I am puzzled why the referential integrity rules allow this to happen without any kind of message to check if correct) and these take ages to weed out (at least at my knowledge of using R2K2 so far).

I would be interested to know how to do the checks you suggest, without creating duplicate records in the database. Is it easy to explain how? If so, please do!

Thanks, Ian

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: How do I ...Understand import error message

Does the R2K2 import wizard not give you a final 'page' in the import wizard that shows you whether you have invalid items? My memory of the old R2K2 import wizard is sketchy now, but I thought it was the same as the R6 wizard in this respect. Here's a screenshot of the final stage of the R6 wizard. Note the count of invalid items (0 in this case) and the tab for invalid items that will allow you to inspect them. At this stage you can choose to cancel the import, which would prevent the data from being imported.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website