Question

Photo of Hatim Motiwala

0

Attendance upload in Bulk

3

I am evaluating different ChMS to select one suitable for our organization.  With regards to attendance tracking, we use simple barcode scanner(s) as a self check-in attendance recorders.  It records members unique ID scanned from a key tag.  Does RockRMS allow uploading attendance data in bulk (say using a csv file) where a unique ID identifies each invdividual.  We simply want to record attendance of members who are already on our list and have been issued an id, and the stand alone barcode scanners work very efficiently for this purpose. The barcode scanners record the ID and timestamp for each scan.

  • Photo of Daniel Hazelbaker

    0

    I don't think there is a specifically written for importing attendance data from a CSV file.  There are some options available, but they would require some effort to get working.

    1. There is a plugin available in the Rock Shop that allows for importing CSV data to any table. Because Attendance data is a bit complex, this may or may not work and would require quite a bit of trial and error to figure out how to do it properly.

    2. You could convert the CSV data into SQL statements to insert the attendance data directly into the database (you would have similar hurdles as above to overcome).

    3. You could build something yourself to do this and/or pay developer to build it for you. You could also check with other churches to see if others have this same need and could share cost.

    Hopefully this helps!

  • Photo of Lee Peterson

    0

    Rock can use a barcode scanner as a check-in input device, so if your scanner can act as a keyboard wedge, you could check people directly into Rock. Or you could purchase new barcode scanners (I don't think they're very expensive). You should even be able to use your current id codes, I would think, if that's helpful.
  • Photo of Hatim Motiwala

    0

    Thanks for the prompt responses.  We currently use scanners which save the scans in their own internal memory which can later be downloaded to PC via USB. This makes it very convenient as no PC or tablet is required at scan stations.
    I was not aware that it is possible to run custom SQL queries.  If an SQL update/insert query can be run against relevant tables then it should be possible to write a script/procedure to do a bulk update. Thanks for the replies.