Re: Partially unsuccessful import with no error messages
Hi
I have been beavering away importing data for 2007 in order to prepare our bird report for that year. Most import files have been less than 1000 records. Today, I imported a file of 3704 records and the import appeared to go well.
However, I checked the Observations as I wished to see that some data for tetrads had imported as I wanted. Sadly, I found a range of errors, none of which had caused an error message.
- Data for at least one place so far, 'Penycae, E', has duplicate entries for each day that place had records.
- Data for at least one other place 'Wrexham, Gatewen' have been imported without dates and are listed at the top of my observations list with date as 'Unknown'.
- There are some locations that have only had some of the records from that date imported to the record with the date.
This is a complete pain in the backside, as it requires hours of work to sort out. So far I have been:
- deleting dated duplicates from R6.
- checking the data in R6 against the import file to delete from a new version of the import file those records that have been successfully and correctly imported.
- editing the unknown date to the correct date, where all the records for that date are present (otherwise I delete the records with unknown date from R6).
Is this a known problem? Have others experienced it? How can it be avoided?
My first guess is that the number of records for each import file will need to be restricted, say to less than 1000. This is a minor inconvenience compared to what I am having to do, but is it really necessary? If there is a way to import from large files and avoid these errors I would love to know what to do.
This the first hiccup I have had with R6 for several months (hence my silence on the forum). Sorry to hear that Sarah is leaving and I send my best wishes and thanks for the help you have given in the past! Bon voyage!
I look forward to any tips.
Best wishes, Ian