Interactive Content – H5P
Maintained by
Frode Petterson, Maris Akmentins, Thomas Marstrander, Pål Jørgensen, Svein-Tore Griff With
Create and add rich content inside your LMS for free. Some examples of what you
get with H5P are Interactive Video, Quizzes, Collage and Timeline.
Comments
Comments are no longer open for new posts. Existing comments remain available to read.
Question: Is there a plan to put in a due date for the activity? Would be nice for it to show up in the calendar..
I just tested H5P with the "Moove" theme, and it looks like normal H5Ps works just fine, could you be more specific about what is failing, and create an issue for it in the H5P.org forums: https://h5p.org/forum/11, which is better suited for handling support requests then this comment field. H5P should be built to be compatible with most themes.
Thanks, Thomas
At first glance it seems reasonable that the groupby should contain the same fields as the select, however I'd like to have a closer look at this to see if the details makes sense.
Could you please make a pull request for this at the github page for the H5P Moodle plugin ( https://github.com/h5p/h5p-moodle-plugin ), or post in our bug request forum (on h5p.org) which is a more suitable medium for resolving the issue than this comment field. I'll make an issue for reviewing and fixing this when it is into the system.
The results are stored using the Gradebook, so they must be accessed from there as well. Is there a particular reason why you would not want to go through the gradebook ?
Thanks for reporting this, and best regards, Thomas.
Infrastructure:
- Moodle 3.4.1
- php-7.1
- oracle 11g
- H5P (mod_hvp_moodle34_2018012200.zip)
We found an error at the time of performing the SQL query to show the results: Error: ORA-00979 (http://www.dba-oracle.com/t_ora_00979_not_a_group_by_expression.htm)
And we have modified the following lines: /hvp/classes/results.php
> IN LINE 194:
// parser $fields
$fieldsgroup = preg_replace("/AS [a-zA-Z_]*\, /", ", " ,$fields);
> IN LINE 199
//$groupby = ' GROUP BY g.id, u.id, i.iteminstance, x.id';
$groupby = ' GROUP BY g.id, '. $fieldsgroup .' g.rawgrade, g.rawgrademax, g.timemodified, x.id, i.iteminstance';
> IN LINE 212
x.id as xapiid,
i.iteminstance
The modifications would look like this:
--
// parser $fields
$fieldsgroup = preg_replace("/AS [a-zA-Z_]*\, /", ", " ,$fields);
// Join on xAPI results.
$join .= ' LEFT JOIN {hvp_xapi_results} x ON i.iteminstance = x.content_id AND g.userid = x.user_id';
//$groupby = ' GROUP BY g.id, u.id, i.iteminstance, x.id';
$groupby = ' GROUP BY g.id, '. $fieldsgroup .' g.rawgrade, g.rawgrademax, g.timemodified, x.id, i.iteminstance';
// Get from statement.
$from = $this->get_from_sql();
// Execute query and get results.
return $this->get_sql_results("
SELECT g.id,
{$fields}
g.rawgrade,
g.rawgrademax,
g.timemodified,
x.id as xapiid,
i.iteminstance
{$from}
{$join}
{$where}
{$groupby}
{$orderby}
", $args,
$this->offset,
$this->limit);
}
--
We would like the H5P team to review the code, confirm that the modification is correct (if there is another more optimal query, we would appreciate being told) and that it will be applied for future versions.
Thank you so much for everything.
Sincerely,
Iván Sibillà
P.S. Is there any way to access the results without having to go through the "Gradebook"?
Here is our senario.. We use vimeo (pro) account.. we hide our videos on our account and allow access only to our moodle site url. When we paste the vimeo direct url the plugin comes back with Unknown Video format. We are trying to avoid direct upload to our moodle instance. checked the link you provide (thank you) but not very helpful. Can our senario work?
Will H5P support vimeo links in the future or just Youtube?