[Wactclc-alma] Create the report based on Excel file
Guidry, Wade
WadeG at bigbend.edu
Tue Aug 8 09:57:04 PDT 2017
Just a quick follow-up...
In a nutshell, you can include multiple values in the 'is equal to / is contained in' filter, separated by ; (see screenshot below).
So, if you just paste in a text string a filter comparison, something like.... "123456789;012345678", the result will bring back matches for each of those id's.
(This works with any field, not just primary ID).
So, get a list of the id's you want, do a change all to change the line breaks to " ; " (if you're not sure how, just google how to do it in whatever editing tool you use), and then paste into the analytics filter.
[cid:image001.png at 01D3102C.AE884D10]
Wade Guidry
Library Consortium Services Manager
Big Bend Community College
wadeg at bigbend.edu
509.760.4474
www.bigbend.edu
Big Bend Community College * 7662 Chanute Street NE * Moses Lake, WA 98837-3299
-----Original Message-----
From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Nadine Pavlov
Sent: Monday, August 7, 2017 6:20 PM
To: wactclc-alma at lists.ctc.edu
Subject: Re: [Wactclc-alma] Create the report based on Excel file
Thank you much!
Shellie, thanks for the file! This is what I was looking for. I am trying to do it but not successful yet... Will play with it more. if not, then I will do what Paula suggested - export the report to Excel and will use Access to match the IDs.
Paula, thanks for the suggestions! Yes, I will need to do a batch at once. It is so many IDs I will need to check. So, I will probably go with Access... But I will keep the "prompt" idea for the other reports :-)
Thanks,
Nadine
-----Original Message-----
From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of wactclc-alma-request at lists.ctc.edu<mailto:wactclc-alma-request at lists.ctc.edu>
Sent: Friday, August 04, 2017 12:00 PM
To: wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>
Subject: Wactclc-alma Digest, Vol 12, Issue 3
Send Wactclc-alma mailing list submissions to
wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.ctc.edu/mailman/listinfo/wactclc-alma_lists.ctc.edu
or, via email, send a message with subject or body 'help' to
wactclc-alma-request at lists.ctc.edu<mailto:wactclc-alma-request at lists.ctc.edu>
You can reach the person managing the list at
wactclc-alma-owner at lists.ctc.edu<mailto:wactclc-alma-owner at lists.ctc.edu>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Wactclc-alma digest..."
Today's Topics:
1. Create the report based on Excel file? (Nadine Pavlov)
2. Re: Create the report based on Excel file? (Paula Laine)
3. Re: Create the report based on Excel file? (Whittaker, Shellie)
4. Re: Create the report based on Excel file? (Paula Laine)
----------------------------------------------------------------------
Message: 1
Date: Thu, 3 Aug 2017 21:35:24 +0000
From: Nadine Pavlov <NPavlov at greenriver.edu<mailto:NPavlov at greenriver.edu>>
To: "wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>" <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Create the report based on Excel file?
Message-ID:
<CY4PR06MB3367337DD570157610C5C62FDDB10 at CY4PR06MB3367.namprd06.prod.outlook.com<mailto:CY4PR06MB3367337DD570157610C5C62FDDB10 at CY4PR06MB3367.namprd06.prod.outlook.com>>
Content-Type: text/plain; charset="us-ascii"
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/80d37940/attachment-0001.html>
------------------------------
Message: 2
Date: Thu, 3 Aug 2017 22:24:11 +0000
From: Paula Laine <plaine at bellevuecollege.edu<mailto:plaine at bellevuecollege.edu>>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Create the report based on Excel file?
Message-ID:
<CY1PR08MB1429C2BF51127234EBB813F8D0B10 at CY1PR08MB1429.namprd08.prod.outlook.com<mailto:CY1PR08MB1429C2BF51127234EBB813F8D0B10 at CY1PR08MB1429.namprd08.prod.outlook.com>>
Content-Type: text/plain; charset="us-ascii"
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<mailto: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-0001.html>
------------------------------
Message: 3
Date: Thu, 3 Aug 2017 22:28:04 +0000
From: "Whittaker, Shellie" <ShellieW at bigbend.edu<mailto:ShellieW at bigbend.edu>>
To: "WACTCLC Alma Discussion (wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>)"
<wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Create the report based on Excel file?
Message-ID: <7132612e4c6f4fb3a985a4874a9e9284 at Exch2013-01.bigbend.edu<mailto:7132612e4c6f4fb3a985a4874a9e9284 at Exch2013-01.bigbend.edu>>
Content-Type: text/plain; charset="us-ascii"
Hi Nadine,
I've never attempted to use an Excel file (or csv file) in/with Analytics, but I think it is possible. Or maybe, more specifically, it might be possible to use data from an Excel file as criteria for a filter in an Analytics query.
I found a how-to document that might lead us in the right direction. It's not focused exactly on what you are doing, but it might work.
See attached. I found it here<https://knowledge.exlibrisgroup.com/Special:Search?search=csv+file+in+analytics&path=Alma&product=Alma>.
Shellie
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<mailto: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/427a0caf/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Analytics - How to use a list of MMSIDs (or any other value) from an Excel csv file as input in Alma Analytics (1).docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 271258 bytes
Desc: Analytics - How to use a list of MMSIDs (or any other value) from an Excel csv file as input in Alma Analytics (1).docx
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170803/427a0caf/attachment-0001.docx>
------------------------------
Message: 4
Date: Thu, 3 Aug 2017 22:28:52 +0000
From: Paula Laine <plaine at bellevuecollege.edu<mailto:plaine at bellevuecollege.edu>>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Create the report based on Excel file?
Message-ID:
<CY1PR08MB1429F028854434EC984A5E14D0B10 at CY1PR08MB1429.namprd08.prod.outlook.com<mailto:CY1PR08MB1429F028854434EC984A5E14D0B10 at CY1PR08MB1429.namprd08.prod.outlook.com>>
Content-Type: text/plain; charset="us-ascii"
Another thought. I see you want to do a batch at once. I think in that case I would export the patrons w/ fines-fees records to Excel and then use Access to match the ID fields from the specific patron list you have to the ALMA list of patrons who owe fines and fees.
Paula
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<mailto: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/ee8058ca/attachment-0001.html>
End of Wactclc-alma Digest, Vol 12, Issue 3
*******************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170808/513dafac/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 55824 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170808/513dafac/attachment-0002.png>
More information about the Wactclc-alma
mailing list