I was under the impression you need the right schema to open an xml document in a readable form. Does anyone know if the correct one is downloadable from the FISH website? Unfortunately I can't check until I get home tonight as it's a blocked website because it contains the word forum in its URL! Best wishes Sarah Sarah MacLean Historic Records Officer Conservation Team Community and Environmental Services Northumberland County Council County Hall Morpeth NE61 2EF Telephone: 01670 534060 Fax: 01670 533086 E-mail: [log in to unmask] Website: http://www.northumberland.gov.uk & www.keystothepast.info -----Original Message----- From: Issues related to Historic Environment Records [mailto:[log in to unmask]] On Behalf Of Emily Brants Sent: 26 September 2005 15:30 To: [log in to unmask] Subject: Re: [HERFORUM] Listed buildings data [No Viruses detected] Hello Tim, We're in a similar situation to you - although our in-house database is in MS Access 2000. I've run the data past our IT department and apparently its fairly easy to import XML into MS Access 2003, so they are currently looking into this option. If possible I'm hoping we can turn it into a MS Excel spreadsheet which I can then amend and import back into MS Access 2000. Presumably a similar thing could be done and imported into Oracle instead? I'll let you know if we have any success..... Regards, Emily Emily Brants Surrey SMR Officer Conservation Group Surrey County Council County Hall Kingston-Upon-Thames Surrey KT1 2DY Tel: 020 8541 9083 "GRUBB, Tim" <tim.grubb@gloucestersh To: [log in to unmask] ire.gov.uk> cc: Sent by: Issues related Subject: Re: [HERFORUM] Listed buildings data to Historic Environment Records <[log in to unmask] k> 23/09/05 09:52 Please respond to Issues related to Historic Environment Records Thanks Chris Unfortunately I don't know any xml techniques and can't write Perl scripts which leaves me in a bit of a pickle!! Maybe I could get HLF funding for somebody to cut and paste the text into the SMR/GIS. Tim +++++++++++++++++++++++++++++++++++++++++++++++++++ Tim Grubb - SMR Officer Gloucestershire County Council Archaeology Service Environment Dept. Shire Hall Gloucester GL1 2TH Tel: (01452) 425705 Fax: (01452) 425356 Email: [log in to unmask] Web: http://www.gloucestershire.gov.uk/archaeology/ +++++++++++++++++++++++++++++++++++++++++++++++++++ -----Original Message----- From: Issues related to Historic Environment Records [mailto:[log in to unmask]]On Behalf Of Chris Webster Sent: 23 September 2005 09:41 To: [log in to unmask] Subject: Re: [HERFORUM] Listed buildings data The problem with converting xml data to the format that you suggest is that it represents a more complex structure that can't easily be 'flattened'. It is relatively easy to extract individual pieces of data, either by using xml techniques (such as xslt) or simple programs, but you do have to hand-craft them to meet specific requirements. I've used perl scripts to extract bits such as post-code that we didn't have already. Even if you had an import routine, you would have to be careful what it did (by way of overwriting/adding to existing records and problems like that). -- Chris Webster Somerset Historic Environment Record Somerset County Council County Hall Taunton TA1 4DY 01823 355620 -----Original Message----- From: Issues related to Historic Environment Records [mailto:[log in to unmask]]On Behalf Of GRUBB, Tim Sent: 23 September 2005 09:30 To: [log in to unmask] Subject: [HERFORUM] Listed buildings data Hi I know this was discussed a week or two back but am I the only one who can't do anything with the xml data on the EH Listed Buildings cd? As an Oracle user who won't benefit from the free import tool for Exegesis users I am at a complete loss as to what to do with it. Anyone out there who can help convert it to a useable format for me? Something old fashioned like .dbf or .xls ................At least that way I can load it into ArcMap. Thanks Tim ++++++++++++++++++++++++++++++++++++++++++++++++ Tim Grubb - SMR Officer Gloucestershire County Council Archaeology Service Environment Dept. Shire Hall Gloucester GL1 2TH Tel: (01452) 425705 Fax: (01452) 425356 Email: [log in to unmask] Web: http://www.gloucestershire.gov.uk/archaeology/ +++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------------------------------------------ -------------------- Think before you print - only print this email if it is absolutely necessary This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and Gloucestershire County Council accepts no liability in connection therewith. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [log in to unmask] Individuals are advised that by replying to, or sending an e-mail message to Somerset County Council, you accept that you have no explicit or implicit expectation of privacy. In line with the Surveillance and Monitoring Policy, any e-mail messages (and attachments) transmitted over the Council's network may be subject to scrutiny. ------------------------------------------------------------------------ -------------------- Think before you print - only print this email if it is absolutely necessary This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and Gloucestershire County Council accepts no liability in connection therewith. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This email and any attachments with it are intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. If you have received this email in error please notify the sender or [log in to unmask] The content may be personal or contain personal opinions and cannot be taken as an expression of the County Council's position. Surrey County Council reserves the right to monitor all incoming and outgoing mail. Whilst every care has been taken to check this outgoing e-mail for viruses, it is your responsibility to carry out any checks upon receipt. Visit the Surrey County Council website - http://www.surreycc.gov.uk * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * "MMS <northumberland.gov.uk>" made the following annotations. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 100% of the electricity used by Northumberland County Council comes from renewable sources. ######################################################################## If this is delivered to you in error would you please destroy all copies of it immediately and contact the sender. =========================================================================