This year I was fortunate enough to attend my fifth Collaborations Workshop and it was as enjoyable and exciting as the previous four.
It was held at Stirling University. I haven't been to Stirling before, it's a really beautiful little city with the Wallace Monument keeping an eye on all the goings on.
As always, apart from listening to the inspirational keynotes, the idea of Collaborations Workshop is to provide an opportunity for delegates to discuss topics proposed by attendees. Some of the topics are then put forward as suggestions for the hack day. Topics that generate enough interest become a project, which a few people will work on for about five hours on the hack day.
During one of the discussions I mentioned my struggles with organising Carpentries workshops and the bash script that I wrote to try and automate some of the work. Another delegate, Colin Sauze, also mentioned the problems experienced with workshop attendees that misjudge the level skill required for attending the workshops. So we discussed the possibility of creating an online test that people, interested in attending a workshop, need to pass before they would be allowed to register. Putting these two ideas together sounded, to us, like a good topic to put forward for the hack day so Colin pitched it for us during one of the next sessions.
We managed to get a team of six people together (five in person and one online) and decided to use my existing bash script and MariaDB database, for creating workshop websites, as a starting point. Hollie Rowland became our project manager, Deborah Udoh and Tosan Okome worked on the online tests. Hui Ling worked on creating a csv version of my MariaDB database because Colin thought the database was to heavy duty for what we wanted. Colin worked on converting the bash script to work with the CSV file and I worked on creating a calendar invite (.ics file) that could be used to include in emails about the workshop.
We had a tremendous amount of fun and pitched our hack at the end of the day with great enthusiasm. Our collaborations workshop ended on a real high when we were announced as second prize winners of the hack day.

There was a great deal of interest in our project and I know many people have the same difficulties as me when organising workshops. So I have decided to carry on working on the project under the name we gave it on the hack day, which is CarpentriesMagic. (We'll have to ask Hollie how we came up with the name because I can't remember). I have registered an organisation on GitHub at https://github.com/CarpentriesMagic. There are three repositories at the moment. WorkshopAdmin (https://github.com/CarpentriesMagic/WorkshopAdmin) which are the bash scripts and WorkshopAdminUI (https://github.com/CarpentriesMagic/WorkshopAdminUI) which is a Java based GUI that works with a MariaDB database for adding workshops, helpers, instructors etc. The last repository is just an example of a workshop website we created with the bash script. There is also a CarpentriesMagic channel in the Carpentries' Slack workspace and a mailing list in Carpentries' TopicBox. If you are interested in using any of this or getting involved in the development, please get in contact. We would love for this project to become something that all Carpentries Workshop organisers can use.
Thanks again to the Software Sustainability Institute for organising the Collaborations Workshop and for making funds available to its fellows to attend. It is still the highlight of my year!