Thanks Richard,
From our experience of doing the csv export I can see that a web import 
would have advantages over the csv file - I'll be interested to see how 
this works at the User Group meeting. My question is really about why you 
are exporting now that the functionality is in place to record outcomes and 
log comments in the Review screen. Anyway, I think there will be some 
really interesting discussions around how we are all using Aspire for 
reviewing lists.

Annette

--On 01 December 2010 14:38 +0000 "Cross, Richard" 
<[log in to unmask]> wrote:

> Hi Annette
>
> The web import protects the html deep-linking to the Item record, Library
> Catalogue and dx.doi (if you do a full html formatting import) without
> any further wrangling. The web import format also better supports the
> additional macro processes we then carry out on the workbooks. So, for
> us, it works better than a CSV export. (If the question is - why do we
> web import rather than CSV export.)
> We don't currently use the annotation facilities in the Acquisitions
> review screens, as our processing remains spreadsheet driven - with
> Aspire as the authority source for the RLMS data that we process. (If the
> question is - why do we export at all).
> My Acquisitions colleague Dorothy Atherton will be explaining more about
> the hows and whys of this at the Aspire User Group meeting in a couple of
> weeks.
> Regards
>
> Richard Cross
> Resource Discovery and Innovation Manager
> Libraries and Learning Resources
> Hollymount House
> Nottingham Trent University
> Nottingham
> NG1 4BU
> t: +44(0)115 848 4878
> e: [log in to unmask] <mailto:[log in to unmask]>
>
> ________________________________
>
> From: Talis Aspire Users on behalf of Annette Moore
> Sent: Wed 01/12/2010 12:41
> To: [log in to unmask]
> Subject: Re: [LIS-TALIS-ASPIRE] Acquisitions review screen and draft lists
>
> Richard
>
> I'm trying to visualise the resulting excel file you would get from using
> the import web facility within excel.  Do you get actually get any more
> information than is already on the Review screen? In the review screen you
> can click on the LCN identifier to view the item in the catalogue.
>
> Annette
>
> --On 25 November 2010 16:49 +0000 "Cross, Richard"
> <[log in to unmask]> wrote:
>
>>
>>
>> Chris
>>
>>
>>
>> Thanks for that - I'll put it on our API to-review list.
>>
>>
>>
>> Best guess right now is that we'll choose between flipping to a CSV
>> export rebuilt by macro to a close approximation to the extraction we use
>> now; or we'll bolt on some API calls to enrich and extend the data that
>> we're pulling out at the moment.
>>
>>
>>
>> Until, of course, the Acquisitions functionality in Aspire becomes so
>> rich, so sophisticated and so flexible that we don't need pull data out
>> of the application to run the processing we need...
>>
>>
>>
>> Regards
>>
>>
>>
>> Richard Cross
>>
>> Resource Discovery and Innovation Manager
>>
>> Libraries and Learning Resources
>>
>> Hollymount House
>>
>> Nottingham Trent University
>>
>> Nottingham NG1 4BU
>>
>> t: +44(0)115 848 4878
>>
>> m: 07789 983916
>>
>> e: [log in to unmask]
>>
>>
>>
>>
>> From: Talis Aspire Users [mailto:[log in to unmask]] On
>> Behalf Of Chris Clarke
>> Sent: 25 November 2010 16:20
>> To: [log in to unmask]
>> Subject: Re: [LIS-TALIS-ASPIRE] Acquisitions review screen and draft
>> lists
>>
>>
>> Hi Richard,
>>
>>
>>
>> The popup is an overlay called via Javascript, but the content of the
>> popup is HTML - I'd have to check with the dev team on whether there is a
>> permalink for that...
>>
>>
>>
>> Anyway, if you are using the Excel import web content feature you can use
>> the Aspire linked data API to get the resource details irrespective of
>> how this feature is implemented. - e.g.
>>
>>
>>
>> 1. the CSV has the URI of the item, e.g.
>>
>>
>>
>> http://resourcelists.ntu.ac.uk/items/4F595ED5-5A01-9235-3267-D5BBEBF92BE5
>>
>>
>>
>> 2. Simply append .rdf on the end of this to get an XML representation:
>>
>>
>>
>> http://resourcelists.ntu.ac.uk/items/4F595ED5-5A01-9235-3267-D5BBEBF92BE5
>> .rdf
>>
>>
>>
>> 3. That XML contains a link to the resource details, append rdf to that
>> to get an XML representation of the metadata: e.g.
>>
>>
>>
>> http://resourcelists.ntu.ac.uk/resources/18A28523-B604-A265-ADAB-817C32F5
>> C6BB.rdf
>>
>>
>>
>> You should be able to code all of that into a Macro in Excel to retrieve
>> the precise metadata.
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Chris
>>
>>
>>
>>
>> On 25 Nov 2010, at 16:10, Cross, Richard wrote:
>>
>>
>>
>>
>>
>>
>> Chris
>>
>>
>>
>> Is the intention to deliver the metadata and library availability
>> referred to below through JavasScript pop-up calls or other scripting?
>>
>>
>>
>> That's potentially a concern to us because of the way that we extract
>> Acquisitions data from Aspire to populate the spreadsheets that we use
>> for processing. Rather than use the CSV export (which loses all of the
>> deep-link functionality - DOI, LCN and Item link), we use the 'import
>> web content' feature in Excel to pull through all of the html formatted
>> content into our spreadsheets. This means that different library teams
>> can click through to the catalogue and the item, etc., directly from the
>> spreadsheet as it passes through the various stages of processing.
>>
>>
>>
>> We'll be showing how (and why) we do this in the user group meeting
>> Acquisitions session. Effectively it gives us a third way between 'web
>> functionality, but with only the Aspire recording and tracking options'
>> and plain exported .csv data.
>>
>>
>>
>> Will the pop-up be an html page call deliverable as a normal a href
>> request (if we could isolate it from the Javascript open.window call in
>> the spreadsheet)?
>>
>>
>>
>>
>> Regards
>>
>>
>>
>> Richard Cross
>>
>> Resource Discovery and Innovation Manager
>>
>> Libraries and Learning Resources
>>
>> Hollymount House
>>
>> Nottingham Trent University
>>
>> Nottingham NG1 4BU
>>
>> t: +44(0)115 848 4878
>>
>> m: 07789 983916
>>
>> e: [log in to unmask]
>>
>>
>>
>>
>>
>> From: Talis Aspire Users [mailto:[log in to unmask]] On
>> Behalf Of Chris Clarke
>> Sent: 25 November 2010 14:24
>> To: [log in to unmask]
>> Subject: Re: [LIS-TALIS-ASPIRE] Acquisitions review screen and draft
>> lists
>>
>>
>> Hi everyone,
>>
>>
>>
>>
>>
>> I checked back with the developers on my answer to 1) below. In actual
>> fact I was wrong - the upcoming story to enable preview of metadata from
>> the item screen will not work for draft items as it has been implemented
>> so far.
>>
>>
>>
>>
>>
>> Rather than hold this feature back what I propose to do is let the
>> development team release it next week, and then we will follow up in
>> December by enabling the preview for Draft items too. As part of that
>> work we can also enable the item links from the draft lists screen too.
>>
>>
>>
>>
>>
>> Thanks,
>>
>>
>>
>>
>>
>> Chris
>>
>>
>>
>>
>>
>>
>>
>> On 23 Nov 2010, at 16:53, Chris Clarke wrote:
>>
>>
>>
>>
>>
>>
>>
>> Hi Richard,
>>
>>
>>
>>
>>
>> We can of course change the colour scheme with a CSS tweak.
>>
>>
>>
>>
>>
>> There is a subtle but important point to make here that there is no such
>> thing as a review of a draft list and a review of the published list. The
>> review is of the list, and can contain both draft and published items -
>> you'll note that the type of draft items is also shown "Draft - Book"
>> etc. A sort on the type column will group all the draft items in the same
>> place.
>>
>>
>>
>>
>>
>> The answer to question two is in two parts really.
>>
>>
>>
>>
>>
>> 1) From the review screen, we're currently in progress with an Aspire
>> Idea which allows the user to click on the item and instead of being
>> navigated to the item screen, they get a popup with the metadata and
>> library availability instead (I've attached an example of how this would
>> work). This will work for draft and published items (was suggested by
>> Annette Moore).
>>
>>
>>
>>
>>
>> 2) The removal of the links is intended to reinforce the fact that the
>> list is a draft copy. However, if in practice this is actually inhibiting
>> users, we can add links to draft items in the draft list outline view -
>> after all, that's what our iterative development process is all about -
>> try, feedback, adjust. At the moment 3 sites are voting on this in Aspire
>> Ideas - are there any others that would be interested to see this
>> functionality?
>>
>>
>>
>>
>>
>> Thanks,
>>
>>
>>
>>
>>
>> Chris
>>
>>
>>
>>
>>
>> <PastedGraphic-2.tiff>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> <PastedGraphic-1.tiff>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On 23 Nov 2010, at 15:15, Cross, Richard wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>> With lists Publishers now able to submit Draft lists for review (a
>> welcome enhancement which opens up more possible Acquisitions workflows),
>> we're seeing an unanticipated consequence in the Acquisitions review
>> screen.
>>
>>
>>
>>
>>
>> The grey-on-grey appearance of Draft list items in this screen is
>> something which should (hopefully) be fixable through a CSS tweak, as its
>> an unnecessarily difficult read at present. (All we need is an indicator
>> in the review screen that this a 'Draft' list; a different colour
>> scheme seems redundant.) More significant is the fact that the deep-link
>> back to the Item is not active for Draft items, reducing the utility of
>> the Review interface. In other words: "for Draft lists I want to be
>> able to click back to the Item on the list from the Review screen in
>> exactly the same way that I can for Published lists."
>>
>>
>>
>>
>>
>> Two questions arise from this:
>>
>>
>>
>>
>>
>> 1. How significant a request would it be to have Item deep-links
>> activated for Draft list items in the Review screen?
>>
>>
>>
>>
>>
>> 2. Can Talis restate the logic of links in Draft lists not being active
>> in the Full List view in any case? (Feedback we've had from academics
>> indicates that the ability not to see how links on a list will *really*
>> resolve without Publishing is an irritant; it is intended to reinforce
>> the sense that the list is not yet published?).
>>
>>
>>
>>
>>
>> Regards
>>
>>
>>
>>
>>
>> Richard Cross
>>
>>
>> Resource Discovery and Innovation Manager
>>
>>
>> Libraries and Learning Resources
>>
>>
>> Hollymount House
>>
>>
>> Nottingham Trent University
>>
>>
>> Nottingham NG1 4BU
>>
>>
>> t: +44(0)115 848 4878
>>
>>
>> m: 07789 983916
>>
>>
>> e: [log in to unmask]
>>
>>
>>
>>
>>
>>
>>
>> DISCLAIMER:
>> This email is intended solely for the addressee. It may contain private
>> and confidential information. If you are not the intended addressee,
>> please take no action based on it nor show a copy to anyone. In this
>> case, please reply to this email to highlight the error. Opinions and
>> information in this email that do not relate to the official business of
>> Nottingham Trent University shall be understood as neither given nor
>> endorsed by the University.
>>
>> Nottingham Trent University has taken steps to ensure that this email and
>> any attachments are virus-free, but we do advise that the recipient
>> should check that the email and its attachments are actually virus free.
>> This is in keeping with good computing practice.
>>
>>
>>
>> __________________________________________________
>>
>> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
>> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Head of Product
>>
>>
>> Talis Education
>>
>>
>> http://www.talis.com/education
>>
>>
>>
>>
>>
>> Talis Group Limited
>>
>>
>> Knights Court,
>>
>>
>> Solihull Parkway,
>>
>>
>> Birmingham Business Park,
>>
>>
>> United Kingdom
>>
>>
>> B37 7YB
>>
>>
>>
>>
>>
>> Direct Number: +44 (0)870 400 5423
>>
>>
>> Mobile Number: +44 (0)7595 022154
>>
>>
>> Office Number: +44 (0)870 400 5000
>>
>>
>> Email: [log in to unmask]
>>
>>
>> www.talis.com
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Head of Product
>>
>>
>> Talis Education
>>
>>
>> http://www.talis.com/education
>>
>>
>>
>>
>>
>> Talis Group Limited
>>
>>
>> Knights Court,
>>
>>
>> Solihull Parkway,
>>
>>
>> Birmingham Business Park,
>>
>>
>> United Kingdom
>>
>>
>> B37 7YB
>>
>>
>>
>>
>>
>> Direct Number: +44 (0)870 400 5423
>>
>>
>> Mobile Number: +44 (0)7595 022154
>>
>>
>> Office Number: +44 (0)870 400 5000
>>
>>
>> Email: [log in to unmask]
>>
>>
>> www.talis.com
>>
>>
>>
>>
>>
>> __________________________________________________
>>
>>
>> Please consider the environment before printing this email.
>>
>> Find out more about Talis at http://www.talis.com/
>> shared innovation(tm)
>>
>> Any views or personal opinions expressed within this email may not be
>> those of Talis Information Ltd or its employees. The content of this
>> email message and any files that may be attached are confidential, and
>> for the usage of the intended recipient only. If you are not the intended
>> recipient, then please return this message to the sender and delete it.
>> Any use of this e-mail by an unauthorised recipient is prohibited.
>>
>> Talis Information Ltd is a member of the Talis Group of companies and is
>> registered in England No 3638278 with its registered office at Knights
>> Court, Solihull Parkway, Birmingham Business Park, B37 7YB.
>>
>>
>>
>> __________________________________________________
>>
>> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
>> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>>
>>
>>
>> DISCLAIMER:
>> This email is intended solely for the addressee. It may contain private
>> and confidential information. If you are not the intended addressee,
>> please take no action based on it nor show a copy to anyone. In this
>> case, please reply to this email to highlight the error. Opinions and
>> information in this email that do not relate to the official business of
>> Nottingham Trent University shall be understood as neither given nor
>> endorsed by the University.
>>
>> Nottingham Trent University has taken steps to ensure that this email and
>> any attachments are virus-free, but we do advise that the recipient
>> should check that the email and its attachments are actually virus free.
>> This is in keeping with good computing practice.
>>
>>
>>
>> __________________________________________________
>>
>> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
>> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Head of Product
>>
>> Talis Education
>>
>> http://www.talis.com/education
>>
>>
>>
>> Talis Group Limited
>>
>> Knights Court,
>>
>> Solihull Parkway,
>>
>> Birmingham Business Park,
>>
>> United Kingdom
>>
>> B37 7YB
>>
>>
>>
>> Direct Number: +44 (0)870 400 5423
>>
>> Mobile Number: +44 (0)7595 022154
>>
>> Office Number: +44 (0)870 400 5000
>>
>> Email: [log in to unmask]
>>
>> www.talis.com
>>
>>
>>
>>
>>
>> __________________________________________________
>>
>> Please consider the environment before printing this email.
>>
>> Find out more about Talis at http://www.talis.com/
>> shared innovation(tm)
>>
>> Any views or personal opinions expressed within this email may not be
>> those of Talis Information Ltd or its employees. The content of this
>> email message and any files that may be attached are confidential, and
>> for the usage of the intended recipient only. If you are not the intended
>> recipient, then please return this message to the sender and delete it.
>> Any use of this e-mail by an unauthorised recipient is prohibited.
>>
>> Talis Information Ltd is a member of the Talis Group of companies and is
>> registered in England No 3638278 with its registered office at Knights
>> Court, Solihull Parkway, Birmingham Business Park, B37 7YB.
>>
>> Talis North America is Talis Inc., 11400 Branch Ct., Fredericksburg, VA
>> 22408, United States of America.
>>
>>
>>
>> __________________________________________________
>>
>> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
>> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>>
>>
>> DISCLAIMER:
>> This email is intended solely for the addressee. It may contain private
>> and confidential information. If you are not the intended addressee,
>> please take no action based on it nor show a copy to anyone. In this
>> case, please reply to this email to highlight the error. Opinions and
>> information in this email that do not relate to the official business of
>> Nottingham Trent University shall be understood as neither given nor
>> endorsed by the University.
>>
>> Nottingham Trent University has taken steps to ensure that this email and
>> any attachments are virus-free, but we do advise that the recipient
>> should check that the email and its attachments are actually virus free.
>> This is in keeping with good computing practice.
>>
>> __________________________________________________
>>
>> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
>> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>
>
>
> Annette Moore
>
> Technical Services Librarian
>
> Library Building
> University of Sussex
> Falmer
> BRIGHTON
> BN1 9QL
>
> T: 01273 877046
> E: [log in to unmask]
>
>########################################################################
>
> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1
>
>
>
> This email is intended solely for the addressee.  It may contain private
> and confidential information.  If you are not the intended addressee,
> please take no action based on it nor show a copy to anyone.  In this
> case, please reply to this email to highlight the error.  Opinions and
> information in this email that do not relate to the official business of
> Nottingham Trent University shall be understood as neither given nor
> endorsed by the University. Nottingham Trent University has taken steps
> to ensure that this email and any attachments are virus-free, but we do
> advise that the recipient should check that the email and its attachments
> are actually virus free.  This is in keeping with good computing practice.
>
>
>
>########################################################################
>
> To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
> http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1



Annette Moore

Technical Services Librarian

Library Building
University of Sussex
Falmer
BRIGHTON
BN1 9QL

T: 01273 877046
E: [log in to unmask]

########################################################################

To unsubscribe from the LIS-TALIS-ASPIRE list, click the following link:
http://jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LIS-TALIS-ASPIRE&A=1