Moodle e-learning platform export data and BBB export data -- 2

Job ID: 34591040

Budget: €250 – €750 EUR

I have installed the Moodle e-learning platform version 3.8.2.
I need to export the following data in Italian Language like the attached document in excel or csv file.
I am explaining and showing it to you in English, simply to make a clearer communication with you, but I actually need the full report in Italian.

I need to export the data in the following order:

1. Tax ID code (Alphanumeric 16 characters)
2. First Name (Alphanumeric 100 characters)
3. Last Name (Alphanumeric 100 characters)
4. Role /Type of participant (Ref Table E)
5. Freelance / Employee (Alphanumeric 1 character)
6. Participant recruited (Numeric with 1 whole digit)
7. Sponsor (Alphanumeric 100 characters)
8. Credits acquired (Numeric with 2 integers and 1 decimal)
9. Credit acquisition date (yyyy-mm-dd).
10. Profession (Ref Table F)
11. Discipline (Ref Table E)

Regarding the points 4 and 5, I need to have in the report, into the columns, only its abbreviation even if in Moodle, the title of that data is shown with its full title.

Furthermore,
I need to track the duration presence of the user on course on Big Blue Button (bbb version 2.3) from when he accessed into big blue button till when he leaves the platform and I need to export the data in excel or csv file.
I am explaining and showing it to you in English, simply to make a clearer communication with you, but I actually need the full report in Italian.

I need to export the data in the following order from Big Blue Button:

1. First Name
2. Last Name
3. Email address
4. time login at Big Blue Button (hour;minutes and second)
5. time logout at Big Blue Button (hour;minutes and second)
6. total time connection at Big Blue Button (hour;minutes and second)


Please I need you to develop the following 2 alerts to track time user spent in course on Big Blue Button:
1) The first alert must notify the user the time when the user stops interacting within the course ;
2) the second alert must show to the user that within 2 minutes of inactivity he will be disconnected from the course.
Related categories: PHP MySQL Moodle