Current workflow is
1) to find the course in ORB and export users
2) put users in a sheet, then export the barcode & card number field as CSV
3) add in commas to those who only have barcodes and re-import to sheet
4) copy and paste all barcodes in checkout table to a separate table in sheet
5) compare barcodes to that table and create a field to say if it’s found
6) concatenate the user first and last names to one field
7) sort the sheet by found, copy only the student full name, email and barcode of students without found barcodes and paste into checkout ‘Import Users’ field
Tom: We shouldn’t be using orb as a data source at all, we should create an API that can add users and update them
from Matt:
Current workflow is 1) to find the course in ORB and export users 2) put users in a sheet, then export the barcode & card number field as CSV 3) add in commas to those who only have barcodes and re-import to sheet 4) copy and paste all barcodes in checkout table to a separate table in sheet 5) compare barcodes to that table and create a field to say if it’s found 6) concatenate the user first and last names to one field 7) sort the sheet by found, copy only the student full name, email and barcode of students without found barcodes and paste into checkout ‘Import Users’ field
Tom: We shouldn’t be using orb as a data source at all, we should create an API that can add users and update them