1

Topic: Rucksack generator error

Hi
Whilst creating a rucksack from a list of common names using the rucksack generator add-in I managed to cause an error so the generator failed. This appears to have been due to the species Parrot's-feather which initially could not be found (I was missing the hyphen) but then the rucksack creator failed completely when using the name written as above (copied directly from the R6 taxon dictionary). When I remove the apostrophe it works ok again, but obviously is then missing this species from the resultant rucksack.

The error was:
exception class   : EOleException
exception message : Line 1: Incorrect syntax near 's'.


Is this an issue with the apostrophe and SQL syntax? Is there a way to overcome this as apostrophes are part of numerous species names and its not ideal to have to remove them and then add the species manually!

Thanks
Purgle

Purgle Linham
Wiltshire & Swindon Biological Records Centre

2

Re: Rucksack generator error

No doubt the single quote. I didn't allow for this in the Rucksack generator. It can be allowed for and will take a look. Not sure how much work is involved.

Mike Weideli

3

Re: Rucksack generator error

Ok, thanks Mike.

Purgle Linham
Wiltshire & Swindon Biological Records Centre

4

Re: Rucksack generator error

I think I have fixed this. Attached is a  replacement for the OCX. As with any addin first remove the existing addin via Recorder 6.  Unzip the file. Close R6 and then install the new .ocx. If you have problems copy the .ocx into the addins folder of R6 to replace the one that's there and try the install again.

Post's attachments

ProjectRuck3.zip 391.71 kb, 3 downloads since 2013-01-08 

You don't have the permssions to download the attachments of this post.
Mike Weideli

5

Re: Rucksack generator error

That's brilliant, thank you Mike!

Purgle Linham
Wiltshire & Swindon Biological Records Centre