5.23. Download a ZIP (and upload it in Moodle)

Log into the platform, open a workflow that contains data and a personalized action, click in the Actions link in the top menu.

The personalized text actions allow you to define a text with parts that are included/excluded depending on the value of the conditions. OnTask then allows you to send those texts as individual emails. However, you may want to extract those texts in HTML and process them with a different platform (for example Moodle). You can do this clicking in the Zip button shown in the Operations column for some of the actions.

Click in this button for any of the personalized text action. The next page includes a form to collect the following information:

../../_images/tutorial_action_zip.png
  1. One of the key columns (unique values in all rows) to use as file name prefix.
  2. Second (optional) column to use in the file name.
  3. The file name suffix. If it is left empty feedback.html will be used.
  4. Check the next field if the ZIP is going to be used to be uploaded as Moodle feedback.
  5. Check the last field if you want to review the users for which the file will be included in the ZIP (see Final look before pushing the GO button).

Click in the button Preview at the bottom of the page to see the final appearance of the text in the file and the values of the columns used to configure the text. Click in the arrows next to the Close button to traverse the files and verify that they are properly composed.

5.23.1. Use the ZIP file to upload feedback in Moodle

If the ZIP created using this functionality has the file names created with certain specific structure, it can be used to upload the personalized messages as part of a Moodle assignment. The workflow data table must have two columns: one with name Identifier with values with structure Participant N where N is a unique number per row, and a column with name Full name with the learner’s full name. These columns can be obtained downloading the grading worksheet from the screen showing all the submissions in a Moodle assignment.

../../_images/downloadgradingworksheet.png

Store the CSV file obtained from this page. We are now going to merge the content of the Moodle CSV with the data already existing in the data table. In the Actions page, click in the link with name Manage table data and then in the Upload or merge option. Next, click in the CSV Upload/Merge button. Select the CSV grading sheet downloaded from Moodle.

../../_images/tutorial_moodle_merge_step1.png

Go to the next step and select only the columns Identifier, Full name and Email address. This last one we will use as the key column to merge with the existing email column. In order not to create an extra column, rename Email address to email as shown in the next figure:

../../_images/tutorial_moodle_merge_step2.png

Select email as the key for the existing table and Email address as the key column for the new table.

../../_images/tutorial_moodle_merge_step3.png

Verify that you are merging two columns and using email as the key.

../../_images/tutorial_moodle_merge_step4.png

Click finish and verify that the table in the workflow contains two additional columns: Identifier and Full name. Go to the Actions page and click in the link to generate a ZIP file for one of the personalized text actions. Select now the column Identifier as the first name prefix and the column Full name as the second column prefix. Choose additional file name suffix (or leave it empty), and click the option for the ZIP to be uploaded to Moodle.

../../_images/tutorial_action_zip.png

Once created, go to the page showing the submissions for an assignment in Moodle and choose the option to Upload multiple feedback files in a zip.

../../_images/multiplefeedbackzip.png

Upload the zip just created and each file will be placed as the feedback file for each student (independently if there is a submission or not).