Re: Spreadsheet import
I have a contractor entering data. They seem to be using Version 4.16 with Windows Vista and have successfully imported 3 spreadsheets to a survey, but have a further 5 spreadsheets to import to the same survey. However, my contractor reports that they:
"have managed to import 3 of the spreadsheets and all of the species names are correct but when i try and import the remaining spreadsheets the same error message is coming up for all of them - that the sample reference already exsists - values must be unique. When i change the sample reference number by adding a zero or underscore or letter or changing the number entirely to make it unique, the spreadsheet is accepted initially but the import is not completed due to an error box that pops up saying tat the application cannot continue due to a runtime error and shuts down.
This is happening everytime, and when i try importing again the error again pops up saying the sample reference already exsists and i have to start again by changing the sample ref number trying to upload it and it failing due to a runtime error!"
My contractor insists they have checked and rechecked sample reference values for uniqueness. I understand that there are a total of 157 samples between the 8 spreadsheets.
Does anybody know if there is a maximum number of samples that can be attached to a survey or an individual survey event? Or has anybody had similar problems?
Meantime I've advised the contractor to upgrade to version 4.42 to see if that makes a difference, but I'm not aware that the version changes 4.17 & 4.40 to 4.42 were designed to solve spreadsheet import problems; so I'm not convinced that this will solve the problem.