User IDs on Impact Catering System
Is there anyone out there who knows the Impact system quite well?
We need to change the User IDs for almost all of the pupils so that we can link Impact to online payments. The ID needs to be their UPN but when the accounts have been created each year a different format has been used every time! My theory is this:
- Export all user data in a CSV file
- Change the User ID of each pupil to match their UPN
- Delete all records from the database
- Re-import the users from the amended CSV file
Can someone confirm my theory and also tell me how to access the database to create / import the CSVs? I admit I only had a quick look but the only report options I saw are for printing only, not exporting.