Check-in using CSV or XLS import

Trying to test your instructions re bulk changes to check-in status...

1. Go to Events Booking -> Registrants
2. Select the event from the event filter dropdown (so that only registrants from that event will be exported)
3. Click on Export button in the toolbar to export registrants of that selected event
4. Remove all columns from the file, only keep ID and Checked In column
5. Change value of column header to id and checked_in (name of fields in database table)
6. Change value of checked_in column to 0 (for all records)
7. Import it back into the system

I tried to import this CSV (three lines only)...
id,checked_in
1203,1
1270,1

It kept saying "0 registrants code imported". The checkin status did not change for those two records.

Ah, guess we need event_id column and few other columns as well, need to check the code to confirm

However, I don't think it is needed anymore. In latest version, we implement the Check-in feature to allow checkin multiple records. You can go to Events Booking -> Registrants, select the registration records you want and press Check-in button in the toolbar to checkin the selected registrants. There is also button to allow un-checkin, too

Regards,

Tuan

Hi Than

Thanks. I would appreciate knowing the correct format of the import file as the other method will take far too long.

Peter

Hi Peter

Below are list of required fields for your purpose:
id
event_id
register_date
payment_method
checked_in

Try that and it should work

Regards,

Tuan