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.
=========================================================================
|