Hi,
Any help/opinions with this would be great.
We have "integrated" Moodle with IMIS (a CRM). This takes the form of user and course enrolment data being pushed from IMIS over to Moodle at midnight each night via a series of Access queries (obviously this rather clunky system pre dates my involvement!) ie new users are added, some users are marked as deleted and users are enrolled or unenrolled from courses.
Current Moodle is 2.1.1 and tables written by our Access queries are things like: mdl_user, mdl_cohort_members, mdl_enrol, mdl_user_enrolment
Also we have a large amount of data in the a Moodle Database Activity, would that make it over? It uses tables like mdl_data, mdl_data_content, mdl_data_fields, mdl_data_records.
Essentially is there a list of tables which change from version to version so I can check if the tables we use have changed from 2.1 to 2.2 then to 2.5? There seem to be various changes in enrolment methods in 2.5, might our Access queries corrupt the backend tables?
The worry is that we upgrade to say 2.2 and then because either methods of enrolment or tables have changed when the data gets pushed over it corrupts tables etc...
Equally it would be very problematic if the data from the Database Activity didn't get passed over.
Any help would be greatly appreciated.
Thanks,
Alex