1

Topic: Problem exporting to NBN Exchange format

This is obviously only a problem which arises every six months ;)

I can run an export to the V3_NBN_Exchange without any problems, BUT if I try to run a second one Recorder crashes with an error along the lines of field (or table) #nbnxxxxxx exists - sorry I forgot to save the error last time it appeared, once I've got my NBN upload out of the way I'll reproduce the error and post it to the thread.

Closing Recorder and re-opening it allows the second export to be run without error, but this has to be done for EVERY export to NBN Exchange. The NBN export is obviously not cleaning itself out of the system properly when it finishes

Craig

Craig Slawson
Staffordshire Ecological Record

2

Re: Problem exporting to NBN Exchange format

I am looking to see what will be involved in fixing this, but in the meantime sored procedure [dbo].[nbn_exchange_drop_tables] will drop the tables involved so this could run this after each export.

Mike Weideli