We have just received an XML export from one of our data suppliers' copy of Recorder. When I try and import it at our end, 733 records are rejected because of an XML tag error, which states that the spatial_ref tag is invalid with the error message "The spatial reference system cannot be recognised". The tag attribute "system" is set to OSGB, which is fine.

The only problem I can see is that there are spaces in the grid reference, e.g. SH 1234 5678 - not ideal, but fairly easy for the Import Wizard to deal with, you might have thought. Is there any way, without manually correcting the 1466 entries in the XML file, that this can be dealt with? Alternatively, is there a script available that can be run on the original database to correct these issues?

Any suggestions gratefully received!

Tim