Question

Photo of Jeremy Turgeon

0

Attendance & Main Campus

2

We're having several problems with check-in and they seem to revolve around it not being associated with the main campus. All our check-in configurations work properly but when we want to view live check-in (checkin manager) or view past attendance (attendance analysis) it selects the main campus but doesn't display anything. I can manually uncheck main campus for attendance analysis and data will come up but not in the checkin manager.

Is there some setting to specify what campus different check-in events should use?  In SQL the demo site defaults to Campus = 1 but any new check-in configurations are listed as NULL.

 

  • Photo of Arran France

    0

    Hey Jeremy,

    Have you got this solved or this still an open issue?

  • Photo of Arran France

    0

    Hey Jeremy,

    After looking at your DB at the conference I set up a similar setup on my local Rockit.  This SQL should copy over your location to the campus table and keep the attendence records associated with it.

    You will need to change the ID at the bottom to make it the same as your named location ID.

    INSERT INTO [Campus] (Name, LocationId, IsSystem, Guid)
    SELECT Name, Id, 0, NEWID() 
    FROM [dbo].[Location]
    WHERE Location.Id = YOURIDHERE

    • Jeremy Turgeon

      Jeremy Turgeon

      When copying over the following, I get: Cannot insert the value NULL into column 'Name', table 'Rock.dbo.Campus'; column does not allow nulls.


      INSERT INTO [Campus] (Name, LocationId, IsSystem, Guid)
      SELECT Name, Id, 0, NEWID()
      FROM [dbo].[Location]
      WHERE Location.Id = 1

      • Arran France

        Arran France

        Are you sure your location Id is right? That error message suggests your location has no name which I'm certain your named location campus does?


        It might be worth taking a look through your location table or changing the last line to something like


        WHERE Location.Name = 'Bel Air Campus'

        • Arran France

          Arran France

          Right you want the location ID listed in Named Locations, the campus where all your attendance is. Not the default Main Campus there.