1 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Importing XML exports

I have been trying to import a dataset that was provided to me in 'NBN Data xml' format, but Recorder does not recognise it as a valid xml file. I'm struggling because I do not understand the XML format.
There are two files, the first containing what looks like XML with headers etc, and the second file is a txt file that looks like a standard NBN Gateway upload.
As a test, I tried exporting a small dataset in NBN Data XML format, which produced the same two file structures, and I couldn't get this to re-import either!

So the question is, can this be imported into Recorder, and if so how? Or am I simply wasting my time and should try (again) to get the data in zipped access format?

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

2 Reply by DaveSlade (edited by DaveSlade 01-02-2011 10:05:57)

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Importing XML exports

I think I've one problem. Recorder will happily export all sorts of characters, some of which are invalid in XML (eg '&'). Finding and replacing these seems to be the key.
However, Recorder still says it's not a valid xml file - and internet explorer agrees.

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

3 Reply by Graham French (edited by Graham French 02-02-2011 12:09:36)

  • Graham French
  • Administrator
  • Offline
  • Registered: 23-05-2006
  • Posts: 430

Re: Importing XML exports

Hello Dave

Is it a Recorder NBN Data XML export? The NBN Exchange Format export produces 2 files, a xml metadata file and text file containing the records. From what you describe it sounds like this is what you have got. If so I don't think you can import this into Recorder. I would double check how the export was produced

Best wishes

Graham
NBN Technical Liaison Officer

Graham French's Website

4 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Importing XML exports

Thanks Graham. I thought this might be the case, and yes it was the NBN Exchange Format.

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk