Skip to content Skip to main navigation Skip to footer

Clever

Clever is an optional Alexandria integration. Contact our Sales Team if you’re interested in adding it to your library!

Managing school rosters can be a tedious, time intensive process, made even more difficult when you have to manage multiple educational programs separately. This is where Clever comes in.

Clever is a third-party service used by school districts to facilitate the secure transfer of student rosters between their school information system (SIS) and digital learning applications. Districts maintain complete control over their data, including what they send to Clever and how it is shared. Applications will only receive the data they need, nothing more. Clever only syncs roster data—no grades, attendance, health records, etc.—so you don’t have to worry about the wrong information getting in the wrong hands. It’s even FERPA compliant!

Our partnership with Clever can help you maintain consistent, up-to-date patron records by automatically syncing (importing) your school’s teacher and student rosters to Alexandria on a daily basis. When a student moves from one school to another or changes are made to their school record, the updated information will be synced with your Alexandria patron records, eliminating data entry errors that can occur when you have to update student records in multiple applications.

If your district hasn’t signed up for Clever yet, head on over to www.clever.com to learn more, or check out the Clever Help Center to get started.

Table of Contents

Basically, your district data syncs with Clever, then Clever allows authorized applications to securely access the data you’ve specified. Changes made to your SIS will be synced with Clever, which will then be updated in your authorized applications.

Specifically, Alexandria will automatically check for any updates from Clever and then import those changes to your patron records during Daily Operations. You can also choose to manually initiate a full sync from your Alexandria account at any time in Preferences > Extras > Clever.

Data imported from Clever to Alexandria during a sync will overwrite matching patron data fields. If the imported data does not match an existing record, a new record will be made based on the imported data and Alexandria defaults.

Clever syncs data from your SIS to Alexandria, not from Alexandria to your SIS. Changes made to a patron’s record in Alexandria will only remain changed if that field is not synced with Clever.

The first thing is to sync data from your district’s SIS with Clever, which is the foundation for everything Clever does. If your district is already set up on Clever then this should already be done. Follow these steps to add Alexandria to Clever:

  1. Contact COMPanion to enable support for Clever integration.
  2. Add Alexandria to your Clever dashboard.
  3. Locate your Clever District ID.
  4. Enable Clever in Alexandria.

And that’s it! Alexandria will accept the request to receive data from Clever and begin automatically syncing roster information during Daily Operations.

During the sync, Clever data is associated with Alexandria patrons by matching one or more key identifiers, including GUID, Student #, and Email. Blank fields are never used for matching.

Clever follows Alexandria’s standard patron import rules, specifically those that allow the import (sync) to modify existing records. For more information, go to Import Patrons: The Rules.

Not all fields in your SIS are applicable to Alexandria, so not all student roster fields will be synced. Here’s a list of the fields in Alexandria and the corresponding field in Clever that are matched during import:

Admin/Staff Fields

AlexandriaClever
1200 GUIDSchool/District Admin ID
100 BarcodeNot Mapped/Optional mapping to staff_id
1001 Community IDNot Mapped/Optional mapping to staff_id
1007 First NameSchool/District Admin name.first
1006 Last NameSchool/District Admin name.last
1019 EmailSchool/District Admin email
1050 SiteAlexandria Site Code for the site record with the same GUID as Teacher school
1026 Status1 indicates an “active” status and 4 indicates a “tobedeleted” status. These are equivalent to the “Active” and “Transferred” statuses in Alexandria.

Admin/Staff Fields

AlexandriaClever
1200 GUIDTeacher id
1000 BarcodeNot Mapped/Optional mapping to teacher_number, sis_id, or state_id
1001 Community IDNot Mapped/Optional mapping to teacher_number, sis_id, or state_id
1007 First NameTeacher name.first
1008 Middle NameTeacher name.middle
1006 Last NameTeacher name.last
1019 EmailTeacher email
1052 UsernameTeacher credentials.district_username
1050 SiteAlexandria Site Code for the site record with the same GUID as Teacher school.
1026 Status1 indicates an “active” status and 4 indicates a “tobedeleted” status. These are equivalent to the “Active” and “Transferred” statuses in Alexandria.

Student Fields

AlexandriaClever
1200 GUIDStudent id
1000 BarcodeNot MappedOptional mapping to student_number, sis_id, or state_id
1001 Community IDNot MappedOptional mapping to student_number, sis_id, or state_id
1007 First NameStudent name.first
1008 Middle NameStudent name.middle
1006 Last NameStudent name.last
1045 BirthdateStudent dob
1032 SexStudent gender
1011 AddressStudent location.address
1012 CityStudent location.city
1013 StateStudent location.state
1014 Postal CodeStudent location.zip
1019 EmailStudent email
1010 LevelStudent grade
1052 UsernameStudent credentials.district_username
1050 SiteAlexandria Site Code for the site record with the same GUID as Student School.
1026 Status1 indicates an “active” status and 4 indicates a “tobedeleted” status. These are equivalent to the “Active” and “Transferred” statuses in Alexandria.

The Alexandria Community ID is a Terminology field, which means you can customize the field name in Preferences > Setup > Terminology.

  1. Click Sign In to Clever.
  2. Log in with your Clever username and password.
  3. On the main window, go to the Settings tab.
  4. Go to the Instant Login Link under Application Information. Your District ID is at the end of this URL. Click Copy.
  5. Go back to Clever in Alexandria, and then paste the District ID or complete URL into the District ID field.

1. District ID

Enter your Clever District ID or complete login URL in your Clever Settings tab, then click Save.

2. Site Mapping

Your sites must be mapped to sync with Clever. Select a site from the Alexandria list on the left, then select the matching site from the Clever list on the right, and then click Match. Repeat this process with all of your sites. If a site has been matched incorrectly, select the site and click the red X to clear the current match.

When you’re done matching your sites, click OK to close the window, then click Save.

4. Alert

Clever and GG4L/other SIS integrations cannot be enabled at the same time: When you select Begin, Alexandria will disable the other services and clear all related identifiers. The Clever system and identifiers will then be initialized. If you have been using a different SIS integration with Alexandria, select Cancel and call COMPanion’s Customer Support team for help.

To proceed, click Begin.

5. Automatically Update During Daily Operations

Select if you want Student, Teacher, and/or Admin (Staff) data to be synced and updated during Daily Operations.

6. Modify Student Field Mapping (Optional)

Field mapping is automatically configured to match and overwrite fields in Alexandria with fields in Clever. By default, Alexandria’s Community ID and Barcode fields are not mapped with Clever. If you use these fields to identify patrons between systems, click Modify field mapping to customize how they’re mapped with Clever.  

We will not attempt to match these fields unless you map them here.

Students field mapping

Community ID

  • student_number
  • sis_id
  • state_id

Barcode

  • student_number
  • sis_id
  • state_id
Teachers field mapping

Community ID

  • teacher_number
  • sis_id
  • state_id

Barcode

  • teacher_number
  • sis_id
  • state_id
Admin (Staff) field mapping

Community ID

  • staff_id

Barcode

  • staff_id

Be careful! Changing how your data is mapped can help synchronize your database or wreak untold havoc. Please speak with Alexandria Customer Support before making any changes.

7. Sync Now

Save your changes, then click Sync Now.

8. Utility Queued

A dialog will pop up: The Clever Sync Utility has been queued. See Operations Management for details.

Click on the Operations Management link, select the Clever Full Sync operation, and from there you can view and download the log.

1. Sign in to Clever

Under the Clever District ID field, click Sign In to Clever, then log in with your Clever username and password.

2. Request the Alexandria application

    In the sidebar, go to Applications > Add Applications, and then search for Alexandria.

  • Have you already purchased Alexandria for use in your district? Yes
  • Would you like to request a launch date for this application? No Custom Launch Date
  • Click Request Application.

3. Request sent

    On the next screen, click Share data.

4. Choose a sharing type

    Select Share by District.

4. Sharing by District

    Check the box to share all district students and classes with Alexandria.

4. Save Changes

Clever must be approved manually.

Please allow 24-36 hours for us to receive and approve your request. We’ll notify you by email when this process is complete. Then, when you’re ready, either give us a call to walk you through the rest of the process, or proceed by following the steps to enable Clever.

What happens to a patron record in Alexandria when the student is removed from our school roster?

If a student record is deleted from your SIS, the patron record in Alexandria will be marked as Transferred. Your librarian can delete or update those records manually as needed or during end-of-year procedures.

Who do I contact for Clever technical support?

If you can’t find an answer in Clever’s Help Center, fill out this form and a Clever support member will get back to you.