 Hi, before we start the tutorial on the Prisma 20 Transflow Diagram app, I just want to quickly introduce myself. My name's Chris Prachard, I'm a Senior Lecturer in Paramedic Practice and Emergency Care at Nottingham Trent University and I'm also the maintainer of the Prisma 20 Flow Diagram app and I got involved with it just because I saw that there were some bugs that needed addressing and I was in a position to address them and I did and here I am now maintaining the package so I guess what I wanted to say with that is you know the evidence synthesis community is a really welcoming one and if you do see a package then you think oh you know what actually there's something that I want from that or there is a bug that needs fixing and you're in a position where you can help with that just do it submit a pull request and who knows you know it could well be that you've addressed some issues that have been outstanding for a while and so absolutely really hope you enjoy our package and hope you find this tutorial useful and yeah just remember to kind of get stuck in with the community thank you hello welcome to this tutorial on the Prisma Flow Diagram app which we hope is very useful for you in making those flow diagrams saving you fiddling around with word processes and all of that stuff so I was going to talk through the website first and the web app version and then after that go into a little bit more detail into using the template file to change specific aspects of the flow diagram and also how you can use the R package so to start with we'll talk about the website so all you need to do is visit the hosted shiny app or you can you know host it yourself from the shiny app directly from the R console it's entirely up to you how you do this but the hosted version is available and it's used by thousands of people so it's kind of stood the test of repeated access and high volume use and so the first thing you notice on the shiny app is it takes you to the main home screen so it's quite simple to get started click create flow down R of or read the instructions below for more information so we'll talk a bit about the stuff that's below and how to use the template csv file a bit later but for now it's as simple as just going into create flow diagram and you can see you've got a flow diagram and all you need to do is choose your options so do you want to include previous studies if a previous review has been done and you're including those studies in your and your review or not you know and it just changes the changes to flow diagram for you and the other thing is study searches where you've searched for studies through websites organizations citation searching etc these you will turn that on or off depending on whether you've done that and again it just makes a section of the personal diagram available or not and the other option and this is new over the last sort of year or so is the ability to report on and include individual databases and registers so all you do to turn that on is change that to included and you'll see the relevant option appears there and then it is just filling the numbers and if there is however something that you didn't do so you didn't actually search registers even if you should have done you can just delete that zero from the box and it will not show up on your flow diagram so if you've got anything that you specifically didn't want to show up you can just delete the number from the box and then it's as simple you change the number and the flow diagram changes now the other thing with the specific database results is it's again as simple you just you can see here this this text here we changed text database one to say Sinal and say we found five results from Sinal it is just as easy as as that so you've got your database name a comma the space and then number and then the semicolon separate records and you can actually put as many of these as you want in so if I were to you can see the flow diagram itself grows as you add more databases in so really this is really handy and again you can also go down to just just the one so so that's that's really useful and again just not including and it goes and included and it comes back and the and then it is just filling the numbers with the the numbers that you've got and it should automatically generate in terms of excluded reports and any box really where there's reasons it's again the reason and then a comma then the number then a semicolon and that's all you need to do that's as simple as it is and that will generate you a nice straightforward flow diagram in English for you to use in your paper which way more simple than fapping around with text boxes and stuff and you can download the image in any format you want amongst these choices we've got PDFs, PNGs, SVTs and also you can actually generate an interactive HTML file and so this is a standalone HTML file which contains all the resources bundled with it and this one is a zip file containing an HTML file and and the relevant assets now is entirely up to you which of those you choose if you if you are going to use if you are going to use one and we'll talk about the interactive HTML function a bit later but if you want to find out more about that you can read our paper the Prisma 2020 our package and shiny app for producing Prisma 2020 compliant flow diagrams with interactivity for optimized digital transparency and open synthesis and you can read that in Campbell systematic reviews the other thing is please do please remember to reference us when you when you do use our app so all you do you can see the reference comes up when you download a copy of the flow diagram so it's fine if you want to do your very straightforward flow diagrams you can also click button to reset back to the default if you've made any mistakes or don't know where to start so you've deleted a box or something but the next thing we're going to talk about is a bit more about the the template csv file because that allows for a bit more customization so we've got the template csv file here you just download it straight off the shiny app and you can see here we've actually got things that say box test box text and tool text and so these can actually be customized by by you to say previous studies so I wanted that title box to say old reviews I can save that in there choose my csv file and if you look here now you can see that I've actually changed the title of the box so if you're doing a review in a language other than English you can use that csv file to actually alter the text of the of the relevant parts of your of your reviews that's really useful with in order to generate as I said flow diagrams in languages other than English it's the same as on the web app you put your numbers in the column labeled n so that's as simple as possible and again it's comma it's the name of the database comma space and then the number with semicolon so that's all there is to filling in your own numbers there and you'll see this box labeled URL and so what that means is that when if we generate an interactive html version of the app so there's a flow chart as you saw there was that option on the on the website to download them and this is basically the URL the link to the html page that that's going to link to so that means that what you can have is a flow diagram that if we download an interactive html version actually links different bits will link to an html file called the the title that you've put in the URL box which is really handy if you wanted to if you wanted to kind of link across into more information so I'll just quickly show you an example of that so if we have a look here you can see that we've got the flow diagram here and if I click on this here you can see that that's then taken as to another page with some more information about the about the search results so you can use that really to be extremely novel in your way of reporting so you can even have links so here what we've done is in and information and use studies for database and registers have actually reported our search strategies on that page so you can you can really make that as interactive as you want in order to in order to kind of make your flow diagram a key part of your reporting particularly if you're using a sort of non-traditional format of reporting so you saw that we had a demonstration website which it could be a really accessible way of reporting your review to lay audiences whilst also making sure that you have the rigour in your reporting available for those who want it so that was just a quick overview really of the website version of the Prisma Flow Diagram app I hope you found it really helpful the next thing I was going to talk about was the R package so you can also use the Prisma Flow Diagram app in your in your R project so I'm using Visual Studio Code instead of R Studio but that's just personal preference and so it's pretty straightforward to use so basically you read in this CSV file using read.csv so make sure you're in the correct directory and then read in the CSV file so I use read.csv and that goes there and then you need to so after you've installed the package which is available from CRAN you can use the Prisma Data function to import the CSV file basically into your into your project so Prisma Data CSV so you do that and then data contains the CSV file basically formatted in such a way that the the the next function that we're going to use we'll use it so you just read in the template CSV so you can see that here and what that's going to do is actually generate the flow diagram so that's the Prisma Flow Diagram function that you can see here so again if I just go okay so you can see that there's actually quite a few options available so many of which have defaults so interactive the default is false but if you set it true or generate one of those interactive HTML files for you previous other that's those options to show previous or other versions of the study detailed database detail registers again showing the detail of those extra things so let's make detailed databases is actually going to be true now and you can customize the font size and font you can change the color of any boxes that you want as well and you can also remove the side boxes you know the these blue boxes again if you would like so that's that so if I run that see that and then if I open the if I open flow you can see that I've actually created a flow diagram and it's used the data that's on my sorry it's a bit small you can't really see it because it's open and visual studio code but it's actually used the data that we we were looking at earlier with my Prisma CSV and then the next function that you might want to to look at is the Prisma save function so pretty much that will allow you to save a flow diagram so you need to add a plot object so plot obj is actually the flow diagram that we've just created and then it defaults to saving it as an HTML file however we can call it whatever we want um so I wanted to call it um what it will do is it will pick up the extension of your file name and um smartly um select the appropriate output function uh output type um from that file name so flow dot png if I run that um you will be able to see that um takes a little while to save it um you'll be able to see that it's creating an output file it's it's actually output the name of that file um and then if I just open that you can see that I've I've created a png file um and I can do the same with a um an svg so or so again takes a little while to to save um and this is all that the website's doing behind the scenes um the shiny app is just running these these commands with with with this package um so again um we've got an svg and a pdf so let's look at the svg if I just open that we've got the svg um and pdf um I would say that your svg is probably the the best option um because it zooms in it's a vector format um much like pdf but probably more um widely supported by like web browsers and stuff um and then you can also output your interactive html and save that as well so I hope that was helpful for you all um you know as I said um it's a useful way of generating these picture flow diagrams um and uh improving the um standard of your paper very easily without having to fiddle around with Microsoft Word and uh text box positioning and stuff um hopefully you found it really easy to use and the other thing I just wanted to to show you um on the website actually um while I remember was um we've now got the ability to actually import results um put results directly into the um the website so all you do is um the columns on the csv and so the uh data column has um as you can see some specific arguments there some some titles all you do is you append those titles with the equal and the thing any numeric ones so I can't not the specific databases or specific registers where you've got to do um commas and semicodons but any any numbers you can just import directly and you can see here that websites and organizations have now been prefilled there um and um if you've used rayanne I don't know um if you have um but this was contributed uh back into our um our code base by by them um because they've implemented it um in their um in in their sort of um web app um so the online version of their web app actually has a flow diagram built in um and you can can launch our app straight from um straight from there and it will pull across your results so um again really handy um and a big thanks to them for for contributing that back to us um because it's um it's a very useful feature to enable you to integrate the app um directly into your own um your own tools so thank you very much and um I hope you enjoy the rest of the conference