Templates for sign in sheet

[jharej]

Hi,

we work mostly on national big projects about involving ICT to schools. Within this project, we also develop courses for teachers. Our financier demands that we provide sign-in-sheets for each workshop that we organize. Sign-in-sheets must follow the design that financier has done. We use mod_booking for all our workshops, MOOCs ... Currently we must export users from booking and copy-paste them in word template provided from our financier. So it is essential for us to upgrade booking module to provide/support the option to use templates for sign-in-sheets.

Can you provide a solution for this issue?

bye, Janko

[gemguardian]

Hi Janko,

In the Bookingmodule there is a sign-in-sheet option. You can Add a logo to the sign-in-sheet. Select the column information you need (like name etc). And can add up to 3 columns with headings you need yourself.

Sofar I had no issues creating a design that matched the request of the party needed. Have you check these options?

Gemma

[jharej]

Hi, yes I know these options, but unfortunately, they are not enough. In the attachment, you can see our current sign-in-sheet that we must use. In the {...} I wrote down where I expect some data from booking. Janko sign-in-sheet-translated.pdf

[dasistwas]

Hi, thank you for the translated document. As far as I see, there have to be following modifications to the sign in sheet:

• Add a custom header with auto-filled data and custom data (first table in the document).
• Participants and educators list are already there
• Add a custom footer

So maybe adding a possibility to fill out a form, that is displayed as the first table would be a way to go. Another idea would be to use a reporting tool like configurable reports: https://moodle.org/plugins/block_configurable_reports in order to create custom reports.

Also there would be a possibility to use a combination of Generico filter with the database activity or Datalynx activity. (These plugins allow combining custom data with report data in one form).

Kind regards, David

[gemguardian]

As addition too David.

I took a look at your PDF file. And I think you can pull this off with all the bookings administration settings their are by "abusing" some of the settings.

As David mentioned custom header and footers can be created. If you make them as a PNG file that you upload a the sign-in-sheet options at the bookingsadministration ór at the site administrator > plugin settings.

Some fields in the first table already excists, or ccan be renamed through language files. to add extra fields to it, go to the siteadministration > plugin settings and created custom fields to add to the booking options. You can mark them as needed on the sign-in-sheet, and you can there for choice at the bookingsoption to fill them with data or not.

For the participants and educators list, this is added in the latest version of the bookingsmodule on moodle.org. You can decided to turn the REC. number column on, and First / last name + institution are fields that can be added to the sign-in-sheet on bookingsadministration level (you can even decided which order is being used - on first name or last name).

The column SIGN exsist in the sign-in-sheet, and you could choice to rename it through the language file. Material (sign) does not excist as a field, but can be created as an extra column at the Siteadministration > plugin settings ór you decided to rename an excisting column in the language settings.

Gemma

[jharej]

Our aim is to use the booking module for everything. We have to many users and educators to support different modules. I would like to stress out, that we have to use exactly that template as is. Our financier is our ministry for education that also sponsors the development of this module through different projects. Each project has its own template. We would like to have a solution that nontechnical staff would be able to use. So we would like to have a possibility to print out a sign-in-sheet where a nontechnical person can set the position of different elements: graphics, text and booking data.

Janko

[dasistwas]

Dear Janko,

OK, in order to develop the best solution for this usecase, I would be happy if you could provide further details, how these templates are going to be used:

1) Will this be used on one Moodle site or on multiple sites? 2) Will the template change and if yes, which frequency? What does change? 3) Is there a special template for each booking option, for each booking instance or each Moodle site? Or is there a single template for all the booking instances on all Moodle sites? 4) What role do the people have on the Moodle platform who create the document? 5) How many different people are going to fill out the document generated from the template?

Another thought is, that the government could get the data in an automated way: You could connect a client (client as client-server model: https://en.wikipedia.org/wiki/Client%E2%80%93server_model#Client_and_server_role) to the Moodle instances and configure exactly which data can be retrieved by the government agency. So there would not be the need for complicated document exchange.

Kind regards, David

[jharej]

hi,

1. we plan to use it on several sites
2. the template will change - typicaly once per project/institution - around every 2 years; changes include new logos, position of elements, paper orientation, first table contents, column names
3. in our case we have one to two templates per course, where we have several booking instances;
4. course teachers
5. very different number - in the curent project we will execute workshops, where we have around 40 educators - they are responsible also for printing and filling the sign-in-sheets

We have a very clear strategy when supporting the development of this plugin: to have a set of plugins in moodle to support the organization of events of any type.

bye Janko

V pet., 13. sep. 2019 15:46 je oseba David Bogner notifications@github.com napisala:

Dear Janko,

OK, in order to develop the best solution for this usecase, I would be happy if you could provide further details, how these templates are going to be used:

1. Will this be used on one Moodle site or on multiple sites?
2. Will the template change and if yes, which frequency? What does change?
3. Is there a special template for each booking option, for each booking instance or each Moodle site? Or is there a single template for all the booking instances on all Moodle sites?
4. What role do the people have on the Moodle platform who create the document?
5. How many different people are going to fill out the document generated from the template?

Another thought is, that the government could get the data in an automated way: You could connect a client (client as client-server model: https://en.wikipedia.org/wiki/Client%E2%80%93server_model#Client_and_server_role) to the Moodle instances and configure exactly which data can be retrieved by the government agency. So there would not be the need for complicated document exchange.

Kind regards, David

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dasistwas/moodle-mod_booking/issues/138?email_source=notifications&email_token=ACTXPCHTB2WUTRLR2EBGVNDQJOKSBA5CNFSM4IVQV3A2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6VCB2I#issuecomment-531243241, or mute the thread https://github.com/notifications/unsubscribe-auth/ACTXPCFDY5FVIPNVIXC43UDQJOKSBANCNFSM4IVQV3AQ .

[dasistwas]

I would then recommend to make adaptations to the existing possibility to download the sign-in sheet. I think the fpdf framework would allow to make these adaptations. As long as templates do not get more complex, adding server requirements like headless libreoffice is more an overkill and prevents universal usage of the booking module.

[jharej]

Hi, I think your solution does not enable a regular user to make a template. We want to offer this solution also to our faculties. And so Word template is the only way. Users usually do have MS or LibreOffice installed, so there is no need for pdf. You need LibreOffice only if you want a conversion to pdf. Most Moodle installations at our country have it (Libreoffice) as they need it to support pdf annotations in assignments.

We need to move fast as we need the code to be in production by the end of the month. So I contacted @atlet and ask him to do the coding. I hope you can cooperate with him in order to get the coding done and merged at the end.

[dasistwas]

Hi, the solution Moodle uses for dealing with word/libreoffice documents is unoconv, which converts documents to pdf in order to be then edited as pdf. The solution proposed by @atlet is different. I do not think I can integrate stuff, that requires additional server software to be installed. Maybe providing a sub-plugin would be better in that case. Kind regards, David

[atlet]

My suggested solution don't use any additional software on server. You don't need to install OpenOffice. but if you like to convert to PDF you need unoconv on server - as I understand is required by Moodle.

This are requirements for OpenTBS library:

I'll integrate as sub-plugin.

[gemguardian]

@atlet

Jus to make sure that this development is not only looking at the requirement of "uniconv" for PDF converting.

Moodle doesn't state that Uniconv is required for converting documents to PDF. Moodle admins can also decided to use (by example) Google Document converter through the OATH2 options.

Moodle does require for annotation PDF documents that Ghostscript is installed on the sever.

[dasistwas]

Hi, OK if it does not depend on unoconv, and use of it is optional it can be used, respecting following guidelines: https://docs.moodle.org/dev/Third_Party_Libraries https://docs.moodle.org/dev/Plugin_files#thirdpartylibs.xml

Kind regards, David

[atlet]

Ok @dasistwas, I'll check and implement it without sub-plugin.

[atlet]

In attached zip you will find 2 examples. One is with all options and second is report you requested.

Open booking instance and in menu you will find new option "Manage custom report templates". Upload both templates and then edit booking instance. In section "Custom report templates" you select, which template wil populate with data, when you click on button "Print report" in booking option.

Examples.zip

[dasistwas]

Just had a quick look: Why do we need phpmailer? It is already part of Moodle...

[atlet]

I just followed documentation of Moodle, how to include a new library to module. This library has examples directory, which include phpmailer. I will remove example directory.

[atlet]

@gemguardian I created conversion to PDF as you suggested.

[jharej]

I suggest that you close this issue. I've tested the newest version of the plugin and I can just say great work guys.

Thanks and bye