[hbsmrusers] Heritage List reference concordance

Wed May 11 11:13:47 BST 2011

Hi Ingrid,
I've just been working on this myself. I'm sure there is a quicker way, but I used a make table query to create a new table mirroring the Associated Files table with the appropriate DesigUIDs in. Used an update query to populate the empty fields. I generated the http link them using the following in the update query "#http://list.english-heritage.org.uk/resultsingle.aspx?uid="+[DesignationTbl].[PrefRef]+"#". Finally I appended the new table to the Associated Files table.
I hope this helps (hope I'm right!!)
Best wishes
Rob

Rob Edwards
Historic Environment Records Officer, Archaeology Planning Advisory Service
Cheshire Shared Services

Tel: 01244 973667
Email: robert.edwards at cheshirewestandchester.gov.uk<mailto:robert.j.edwards at cheshirewestandchester.gov.uk>
Location: Backford Hall, Backford, Chester Cheshire. CH1 6PZ.

From: hbsmrusers-bounces at britarch.net [mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Peckham, Ingrid
Sent: 11 May 2011 11:01
To: List for users of the HBSMR software
Subject: Re: [hbsmrusers] Heritage List reference concordance

Hi Crispin,

(Belatedly joining this discussion.)  Some instructions on how to create the Assoc File hyperlink would be useful.  I've tried to do this, and populated the relevant field in the Assoc File table, but the hyperlinks don't work.  They only seem to work if added via the button on the Designation Form.

Best wishes
Ingrid

Ingrid Peckham
Historic Environment Record Officer
Historic Environment Team
Planning and Sustainability Division
Southampton City Council
Tel: 023 8083 2850
This email is confidential but may have to be disclosed under the Freedom of Information Act 2000, the Data Protection Act 1998 or the Environmental Information Regulations 2004. If you are not the person or organisation it was meant for, apologies, please ignore it, delete it and notify us. SCC does not make legally binding agreements or accept formal notices/proceedings by email. E-mails may be monitored.

________________________________
From: hbsmrusers-bounces at britarch.net [mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Sarah Poppy
Sent: 18 April 2011 13:04
To: 'List for users of the HBSMR software'
Subject: Re: [hbsmrusers] Heritage List reference concordance

Crispin, I was mid email on exactly the same thing and agree totally!

Those using SHINE will have an example in their ini files of how to pass an assoc file into your GIS, which you can modify for use with other designations.

A set of instructions would be really helpful....

Sarah.

________________________________
From: hbsmrusers-bounces at britarch.net [mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Crispin Flower
Sent: 18 April 2011 13:01
To: List for users of the HBSMR software
Subject: Re: [hbsmrusers] Heritage List reference concordance
Hi Sarah
This is what Associated Files is for (OK the name does not quite reflect this use, but basically it is links to anything that can be hyperlinked!).
This can be auto-populated with hyperlinks to the new web site, from the identifiers (assuming these can be matched up with existing records).
And once there, it can be passed into GIS too.
We will be able to help with this during service visits, but could also put some self-help instructions out if people want (on how to create Assoc File hyperlink record from NationalRef).
Yours
Crispin

From: hbsmrusers-bounces at britarch.net [mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Sarah Orr
Sent: 18 April 2011 12:15
To: List for users of the HBSMR software
Subject: Re: [hbsmrusers] Heritage List reference concordance

Hi Lucy and others

Continuing the debate about how everyone is going to concord in a concordantly way... I would like to have a field in Designation table with the hyperlink in it eg http://list.english-heritage.org.uk/resultsingle.aspx?uid=1117195  and I'd want this to go through to GIS pgdb table also.  Too long (65 characters) to fit into Pref Ref/National Ref fields though this might be where I would like it, and most of my User fields seem to be full!  Crispin/Richard, is it possible/ sensible to add this to Designations somewhere?

Thanks

Sarah Orr
Historic Environment Record Officer
Archaeology Service
West Berkshire Council
West Street House
West Street
Newbury
RG14 1BZ

Tel 01635 519805
Fax 01635 519811

sorr at westberks.gov.uk<blocked::mailto:sorr at westberks.gov.uk>
www.westberks.gov.uk/archaeology<http://www.westberks.gov.uk/archaeology>

________________________________
From: hbsmrusers-bounces at britarch.net [mailto:hbsmrusers-bounces at britarch.net] On Behalf Of Dingwall, Lucie
Sent: 14 April 2011 09:38
To: List for users of the HBSMR software
Subject: [hbsmrusers] Heritage List reference concordance

Hi All

Now that we have the concordance list, can I just check what everyone is doing to make sure that I am thinking sensibly/being consistent with everyone else. Is it best to put the new List Entry number in the Pref Ref/National Ref fields, and then move the legacy UID into one of the currently unused fields ? At the moment, for Listed Buildings we transfer the National Ref and Other Ref (old greenback number) to the GIS table, and for Scheduled Monuments we transfer the National Ref to the GIS table. I think I would need to continue to make the legacy UID available in the GIS table so would need to transfer an additional field across if that is where the legacy UID gets stored. Changing the data in these GIS tables will have a knock-on effect with our correlation to our planning system, so I want to make sure that this is sensible before I do it. Any alternative ideas/suggestions gratefully received.

Thanks

Lucie

Lucie Dingwall BA MSc MIFA
Sites and Monuments Record Officer
Herefordshire Archaeology
Planning and Transportation Services
Herefordshire Council
PO Box 230
Blueschool House
Blueschool Street
HEREFORD
HR1 2ZB

Tel: 01432 260130
Fax: 01432 261802
E-mail: ldingwall at herefordshire.gov.uk<mailto:ldingwall at herefordshire.gov.uk>
web: www.herefordshire.gov.uk/htt/<http://www.herefordshire.gov.uk/htt/>

________________________________
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed may not necessarily represent those of West Berkshire Council.

If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this e-mail in error.

All communication sent to or from West Berkshire Council may be subject to recording and or monitoring in accordance with UK legislation, are subject to the requirements of the Freedom of Information Act 2000 and may therefore be disclosed to a third party on request.

Emails sent to and from this organisation will be monitored in accordance
with the law to ensure compliance with policies and to minimise any
security risks.
The information contained in this email or any of its attachments may
be privileged or confidential and is intended for the exclusive use of
the addressee. Any unauthorised use may be unlawful. If you receive
this email by mistake, please advise the sender immediately by using
the reply facility in your email software.
************************************************************************
Note: This E-Mail is intended for the addressee only and may include 
confidential information.

Unauthorised recipients are requested to please advise the sender immediately 
by telephone and then delete the message without copying or storing it or 
disclosing its contents to any other person. 

We have taken all reasonable precautions to ensure that no viruses are 
transmitted from the Authority to any third party. Copyright in this 
e-mail and attachments created by us unless stated to the contrary belongs to the Council.

Any liability (in negligence or otherwise) arising from any party acting, 
or refraining from acting on any information contained in this e mail is
hereby excluded. 

Should you communicate with anyone at the Council by e-mail,
you consent to us monitoring and reading any such correspondence. 

Printing this email? Please think environmentally and only print when essential!
************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.britarch.net/pipermail/hbsmrusers/attachments/20110511/ac9d3bff/attachment-0001.htm>