Topic: Exporting to the NBN Gateway from MR
Has anyone else had an issue when using the "May 2011 v 1-5-11 - Marine Recorder to gateway exporter"?
I get an error message (I would attach screen dump but it won't let me add a PDF or a DOC......):
Run-time error 13 - type mismatch
& it then jumps to the visual basic module OtherFunctions, highlighting a line of code:
"numericAbundance = numericAbundance + 1 + rs!Data"
If I try it on a single survey it runs OK, but I have 152 surveys I need to output.
What frustrates me is that when I ran this tool in June 2012 it worked. I suspect given the message & visual basic script that either the code is trying to place data of the wrong type into a field, or there is an issue with data. I've looked at some of our abundance values and think there are some anomalies but when I exclude the surveys concerned the thing still falls over.
Just curious to know if anyone else is using the exporter & having similar issues?