MCCC Knowledge Base

Creating a formatted List of IDs for Use in a CROA Filter

2017

Creating a formatted List of IDs for Use in a CROA Filter

 

When you want to select a specific set of IDs in CROA, they must be formatted with a ‘;’ between the IDs in the list. Here are the steps to get the list into that format.

These instructions assume you have already exported a list of ID numbers from Colleague

 

1. Open the Excel grid and highlight the column of ids you want to use in your CROA report.  
2. Select and Copy the ID numbers  
3. Open a blank Word document  

4. Right click in the body of the blank document a do a “Paste”, selecting the “Keep Text Only” option.

If there were any headers, column sum or counts, delete them from the document. Your document should look something like this:

 

5. Click   from the Home tab of the Ribbon to find all paragraph marks and replace with ;
  • Find what = ^p
  • Replace with = ;
 
6. Click Replace All
  • Your document should now look like this:
 
7. Select All (Ctrl+A)  
8. Copy (Ctrl+C)  
9. Open the appropriate report in CROA  
10. Paste the copied IDs into the report query filter or filter prompt  
   
0 (0)
Article Rating (No Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
CROA Report - Active Program by Term
Viewed 6790 times since Thu, Apr 14, 2016
CROA - Viewing Crystal reports
Viewed 18737 times since Thu, Jul 9, 2015
CROA - Viewing Web Intelligence documents
Viewed 8066 times since Thu, Jul 9, 2015
CROA - How to customize a table in the report
Viewed 7368 times since Wed, Jul 8, 2015
CROA - Quick access to content objects
Viewed 8341 times since Thu, Jul 9, 2015
Starfish Attendance Term Exporting
Viewed 22175 times since Thu, Dec 17, 2015
CROA - Working with content objects
Viewed 8504 times since Thu, Jul 9, 2015
CROA - To save the document in PDF format
Viewed 6670 times since Wed, Jul 8, 2015
CROA Basics Overview
Viewed 7429 times since Fri, Feb 1, 2019
Logging into CROA
Viewed 5449 times since Wed, Jun 22, 2016

Need Help?