I have just opened the link above in Mikes post and it definitely contains two files

Hello,

I just saved the zipped file (NBNExchangeAddinNU.zip) within this link again:

http://forums.nbn.org.uk/viewtopic.php?pid=18483#p18483

I then extracted all files from within this zip file and this created a folder called NBNExchangeAddinNu but only produced one file called 'NBNExchangeAddinNu'

I then attempted to install the addin again but when I point to this newly created folder there is nothing within.  I wonder if the zipped file could be corrupt?

Would it be possible to have the files emailed to us directly?

Thank you,
Christine

Hi Rob,

No.  If I try to open the file I get the error message 'The Compressed (zipped) Folder is invalid or corrupted.'  If I save the file, then I just get an empty folder. 

Have you any idea why you might be able to open it, but I can't?

Many thanks,

Christine

Hi Rob,

We are on Windows XP and are using WinZip to extract zipped files.

Thanks,
Christine

Thanks for this. I'm just waiting for the ICT department to do the installation.

The attached test addin can be installed just to check that there is no general  problems with installing addins. It just adds a button called 'Test' to the observation hierarchy.  Assuming that this  addins can be installed without problems, it would seem that the problems with the NBNExchange addin are caused by the install process  trying to add new stored procedures to the database. Permission issues on the database and on the files may be casuing the problem.  In order to test this  I have taken this part of the process out of the addin and a new version is attached to confirm this. This uses just the one file (NBNExchangeAddinNu.dll).

If you are unsure whether or not other addins install then

1. Unzip the test addin and copy the file into the Addin folder of R6.
2. Install the Test addin   using Tools Addin Modules

If this install OK or you know other addins will install then 

1. Check that the NBNExchange addin is not installed using Tools Addin Modules, Install. Remove the addin if it is already there. Then close Recorder -(important).
2. Unzip the NBNExchange addin file and copy this into the Addin folder of R6. Overwrite the file if it is already there.     
3. Open Recorder and install the addin using Tools, Addin Modules.

If the addin installs correctly, then we have identified the problem. The update to the database can them be run by installing the SQL  using Mangement Studio tools.

Please report the steps you take and what happens so that we can investigate further if required.

Hi Eleanor

Thank you very much for your help with this. You could try installing the version in the above post (NBNExchangeAddinNu.zip 365.44 kb)  on your machine. This doesn't include the procedure which updates database which I think has been causing  the installation problems with earlier versions. The database update would have been done by the Server install so this part of the process isn't required in subsequent installs.

Hi Mike,

Our IT dept have tested your latest test add-in and I have been asked to pass on the following:

On Friday I managed to extract the test addin, 'jvbtestproject.zip'.
However, when I attempted to install it using the 'add-in configuration' tool in R6, I browsed to the folder that contained the add-in but it was not visable.  Whereas, if I browse to the folder using windows explorer the file is visable.  So I am guessing that the R6 is not recognising this file as an addin.

Also, when I tried to extract the other addin 'NBNExchangeAddinNu.zip', I got the message 'The archive is corrupt'.  The file extracts but shows as being 0kb.

Kind regards,
Christine Oines

So far this is working but you can't do more than on extraction without closing recorder. It says the table "## NBN Exchange Obs" already exists unless i restart Recorder.

Hello Mike

This worked fine for me other than Graham's issue above. However, could you consider increasing the width of the abundance field?  I had several records with multi-value abundances where it did not export the abundance data.

Thanks

Alison

This is still work in progress.  I think I can see where the problem with abundances is and will fix. Can not yet get the automated zip working and would like to fix this before releasing a new version.