[Wactclc-alma] Create the report based on Excel file?

[Paula Laine]

I just tried this, and it worked. Create a column prompt on the Primary Identifier field. (Be sure to have the "user input" set to text.)  Save the query again. You won't see the prompt if you click the "results" button, you have to close the query and "open" it. Then you will get your prompt where you can enter the patron ID and see what &why they owe.

Is this what you are trying to do? If you don't want to do it one-by one I don't know how (or if) you can link an external table of IDs to ALMA. We could do it with VGER easily enough.

Paula Laine
Bellevue College
From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Nadine Pavlov
Sent: Thursday, August 3, 2017 2:35 PM
To: wactclc-alma at lists.ctc.edu
Subject: [Wactclc-alma] Create the report based on Excel file?

Hi,
We have a list of the students that we need to see if they have any fines and how much do they have.  We do have an analytics report that shows the fines and fees the students have. BUT, how can I filter it to see the fines for the specific students? Those filter's options that exists, don't really help me because the list I have is so irregular (those students might have different fines, the fines could be created at different times, etc...) So, I can't really filter it.. But I have the excel file with those ID numbers. Is it possible to filter the results by uploading the file?

Regards,

Nadine Pavlov
Circulation Supervisor
Holman Library
(253) 833-9111 Ext. 2088

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170803/9e6004a9/attachment-0002.html>