NBN Forum / XML Query alternative to the NBN Exchange Add In

Graham Hawker · 2010-03-12 15:11:33

I've upload this to the files upload area. We had problems with the Add In not producing the required results without a lot of post processing so Mike Weideli produced this for us using part of some Natural England funding.

I've now used it to extract and submit data and it has helped a great deal. The main advantage is that it handles site data much better by concatenating the location and location name into one column and removes carriage feeds and line returns.

charlesr · 2010-03-12 19:02:07

Thanks Graham (and Mike) - that should come in very handy.

Graham French · 2010-03-24 13:19:44

Hello Graham

Thanks for posting this XML report, this will really help when exporting to the NBN Gateway, when users can't get the Recorder 6 addin to work.

I have had a quick go, and there are a couple of typos in the caption attribute of the column elements which are important to correct
1. "Sensative" should be "Sensitive. This is important to change as otherwise the Gateway will not recognise any records flagged as sensitive as sensitive and so these records will be displayed to the public
2 "Recorders" should be "Recorder". Not changing this means that the Gateway will not recognise recorder names and apply the access controls correctly (they will be treated as an attribute of the record instead with potentially a different access control)

Best wishes

Graham
NBN technical liaison officer

Last edited by Graham French (2010-03-24 13:20:25)

Graham Hawker · 2010-04-01 14:59:51

Thanks Graham.

I've made the changes but cant see any option to remove the existing version before uploading the revised version. Can someone do this for me?

Edit - I've renamed the new version so I can upload it but the old version needs to be removed still.

Last edited by Graham Hawker (2010-04-01 15:07:42)

Graham French · 2010-04-01 16:05:29

Deleted old version

Graham French
NBN Technical Liaison Officer

Graham Hawker · 2010-04-01 16:54:22

Thanks Graham

Announcement

#1 2010-03-12 15:11:33

XML Query alternative to the NBN Exchange Add In

#2 2010-03-12 19:02:07

Re: XML Query alternative to the NBN Exchange Add In

#3 2010-03-24 13:19:44

Re: XML Query alternative to the NBN Exchange Add In

#4 2010-04-01 14:59:51

Re: XML Query alternative to the NBN Exchange Add In

#5 2010-04-01 16:05:29

Re: XML Query alternative to the NBN Exchange Add In

#6 2010-04-01 16:54:22

Re: XML Query alternative to the NBN Exchange Add In

Board footer