Run the macro “InvoegenLegeRijenMetInterval” (=> insert empty row whit interval). Sub InvoegenLegeRijenMetInterval() Dim Rng As Range Dim xInterval As Integer Dim xRows As Integer Dim xRowsCount As Integer Dim xNum1 As Integer Dim xNum2 As Integer Dim WorkRng As Range Dim xWs As Worksheet xTitleId = "Theo Schipper - Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) xRowsCount = xInterval = Application.InputBox("Interval rijen ", xTitleId, 1, Type:=1) xRows = Application.InputBox("Hoeveel rijen invoegen na de interval? ", xTitleId, 1, Type:=1) xNum1 = WorkRng.Row + xInterval xNum2 = xRows + xInterval Set xWs = WorkRng.Parent For i = 1 To Int(xRowsCount / xInterval) xWs.Range(xWs.Cells(xNum1, WorkRng.Column), xWs.Cells(xNum1 + xRows - 1, WorkRng.Column)).Select xNum1 = xNum1 + xNum2 Next End SubĬopy H4 and I4 and all the cells under them to the second tab. I used a macro to insert blank lines I found online (Thank you Theo Schipper). But they are next to each other and we need them in a list. All the URL’s you need to download all your content are now produced. (starting on line 4) Put course and ID of the COURSE_MODULES in column D/E Delete all cells of columns D and E where C and D are not the same Put InstanceID and ID of CONTEXT in column F/Gĭelete all cells of columns F and G where E and F are not the same Now drag cell H4 and I4 to the end of the cells or double click the little black square in the corner. Put slug, ID and Course of the HVP table in column A/B/C. unfortantelly, I can't attach him but I took a screenshot to illustrate (attached) Prepare an excelfile: in cell H1 => URL of your Moodle site (I use phpmyadmin) I made an excel to make it a bit easier. So download csv for excel HVP, COURSE_MODULES and CONTEXT. Therefore, we need a third table (COURSE MODULES), where course (as in HVP table) and ID (as in CONTEXT table) are connected. Unfortunately, there is no reference in those tables connecting them. The xxx and yyy are InstanceID and ID as found in the CONTEXT table. The zzz (name of the resulting file) is the slug as found in the HVP table. You need to have access to your Database. OF YOUR MOODLE/pluginfile.php/yyy/mod_hvp/exports/zzz.h5p OF YOUR MOODLE/mod/hvp/view.php?id=xxx The second url is: The first url (you can see while visiting the page) is: I tried to attach the excell and automator script but that is not allowed. I will explain how you can use excell to make a list of url's to download your h5p files and how to loop trough them with an Autiomator script. What actually is happening, is that 2 php files are called with the appropriate variables. h5p file” are the tools you use to manually download your. If you visit your course, the “reuse” button and the “download as an. If you created your h5p content on a Moodle site, it is possible to ‘bulk download your h5p files in an automated script.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |