 Hello everyone. Nice to meet you. My name is Sandra Fukunye and I am a long-term Wikimedian and I currently work with OpenRefine. I will give you a tutorial of Wikimedia Commons uploading with OpenRefine. Here's a few slides. In this session we will actually start with a recorded demonstration. I am doing that because I am a little bit hesitant to do a live demo. You always know that these things tend to go wrong sometimes. So there's a pre-recorded demonstration, but I am around and the demo will be shorter than the session. So whenever you have questions while you see me do things, please ask your questions. I would say either in the chat, but it would even be better if you ask the questions in the sessions either bad. We have an either bad for the session and you can place your questions there. Then in that case, if you do that, I can see your questions certainly. And after the demo, we will answer those. Maybe some of your questions will already been answered while I was giving the demo, but the ones that remain I will be available to answer them. Let me start by giving a very brief introduction for those who don't know OpenRefine yet. OpenRefine is software, free open source software that is used actually quite widely. It is quite popular software used for data wrangling, for working with large data sets, data operations, modifying data, and preparing to upload data to other databases. People sometimes jokingly call it spreadsheets or Excel on steroids. It basically is a little bit like Excel in the sense that you see in the screenshot here, you see the data in a grid view. So you see it a little bit like a spreadsheet and you can do all sorts of operations with it, but it's way more powerful than Excel. It runs as a desktop application. So it's software that you download to your computer and then you run locally. It is a little bit funny though because it will not run as a native application, but it will open a tab in your web browser and you will work with OpenRefine in your web browser. You will see me do that pretty soon. So I already said OpenRefine is quite widely used. It is widely used not just by Wikimediants. It has been used by Wikimediants for a while, but it's software that has been around for more than 10 years now and it is used in the cultural sector by museums, cultural institutions, libraries, a lot by libraries actually. They are our main user group, but also data scientists, journalists who work with lots of data by activists around the world. Our interface is also international. We have translations of our interface in languages like French, but also Japanese, Indonesian languages, etc. So since several years you can use OpenRefine for batch editing Wikidata. So you can use it to do data imports and do Wikidata. And in the last year we have also worked on a project to extend OpenRefine with functionalities for Wikimedia Commons. And that is what I'm going to show you in this session with a focus on uploading new files to Wikimedia Commons. And that is brand new. Just to reinforce that OpenRefine is actually indeed a widely used software. This is something I really like. This is a t-shirt that an OpenRefine fan has made and the t-shirt says OpenRefine is magic. I recommend actually Wikimediants who are interested in working with cultural institutions to learn to work with OpenRefine because it is software that is really popular in the cultural sector. So it will help you with your work in general. But so going back to Wikimedia Commons support, we have been working on Wikimedia Commons support for a year now. And at this point in time you can already do batch editing existing files of Wikimedia Commons with OpenRefine and file uploads, which I'm going to demo now. The focus is structured data though. So you can do Wikitext editing with OpenRefine, but we really, really emphasize using structured data. It is a tool that is focused on structured data. So it has been used for Wikidata and now we also use it for structured data on Wikimedia Commons. In terms of difficulty of how to learn to use the tool, it is actually we see it as the replacement for the Glambiki tool set. The Glambiki tool set was an advanced tool that was easy to use by or not easy to use, but was really powerful for cultural institutions who would do exports from their database and then import files into Wikimedia Commons. We see OpenRefine as a replacement for that, but it's way easier to use than the Glambiki tool set. I would say in terms of difficulty it is somewhere maybe in the middle between Patipan and the Glambiki tool set. And unlike Patipan, OpenRefine, as I said, supports structured data. So that is a big advantage. You can add structured data from the start and it is a tool that cultural institutions already use. So your partners might already be familiar with it and it will help you in your partnerships. By the way, we are doing this project thanks to a grant from the Wikimedia Foundation for which I thank them. The project runs until the end of October 2022. So after this session, the demo that you are getting now is not the final software. We will still add some user-friendly features and actually I got a good news that after October, we will also have a budget, not so much for new development, but for bug fixes. We will be able to do that and we will also have a budget for training in the Wikimedia movement. So this session is definitely not the only one that you will see, but I will look into various ways of helping Wikimedians use OpenRefine better. If this session is, by the way, going too fast for you, which I totally get, there is already some documentation on Wikimedia Commons about batch editing and batch uploading. So we have an info page on Wikimedia Commons which you can consult and that one, we already have 12,000 uploads which is great. There you find a link to how you can add structured data with OpenRefine and there is also a Google document with instructions on how to upload files with the current features. This is not the final documentation because we will still improve our features and I will put, of course, final documentation on Wiki and in places where the Wikimedia community can use them better and not the Google doc. So demo time, I will actually start demonstrating how very quickly how you do batch uploading to Wikimedia Commons with OpenRefine. In the course of this session, I can absolutely not show all the features. We have too little time for that. I think to learn to use OpenRefine well, I would say take an hour or two. Then you can learn the features of the software itself and you can also learn to do the Wikimedia things with it. In this session, I will really focus on uploading new files so I will actually not go too much in depth into all the very powerful things in general that OpenRefine can do. But as I said, later in the year, we will start on training and that is also something I really want to cover, learning to use OpenRefine in general. By the way, on the internet, there are many, many tutorials that are actually quite great for that too. So it is not the first time that people are learning to use OpenRefine. But yes, for this demonstration, I am going to show you how to upload a set of files. I have chosen a very small set of files on my computer right here. Like most Wikimedians in the world, I go around, I see the world and I take pictures. And then I have many, many pictures on my computer that I have taken myself of interesting things in the world and I have not uploaded them to comments yet. And I thought, Sandra, for the demo at Wikimedia, let's fix some pictures you took in 2020. So I have around nine pictures of a really big structure around my hometown Rotterdam. This is the Rosenberg Windwall. And I also have some pictures of a public artwork in Belgium. This artwork is called, I wrote it down, it's French, well, it has a French name, Le Val souffle ou vu, from the artist called Daniel Buren that is on the Belgian coast. And I will show you how I would go about uploading these files. So first, of course, I have these files on my computer and I am going to get their file paths, their local file paths. This is something that we hope to improve with a feature. So that you don't have to do this step anymore. But basically, I'm now going to get a list of file paths. I'm doing that on my Mac here. I'm going to copy the file paths here. And I am going to open refining my browser. Now I have started open refining my computer and open refining is open here. And I now have on my clipboard, on my computer clipboard, the list of file names. And as you can see here, this is the start screen of open refine. And you can start using open refine with many different starting points, like a file on your computer, but also a web address, something like an API of a cultural institution. Cultural institutions will be super happy with that. That they can just feed you a link from their API in here and then open refine will load the data. You can also do an external database. I've never done that in my life, but it's possible. You can do Google data sheets or Google spreadsheets. We also are building an extension to start from Wikimedia Commons categories to edit these files. I have not edited that extension for this demo. But in this case, I have file paths on my clipboards, and I will paste those here. So what you see here is just a link of paths of where I have, I think around 15, 16 images that I just showed you. And this looks good to me. I'm just going to start a project with that. So what you see here is a preview screen. And I am going to tweak some things that now it interprets that I actually have a column name with users and then my user name and desktop. That's not what we want. So let me see. Yeah, this is what I want. I just want one column with my file paths. Just a side note, it is totally fine to start in this way with just file names from your computer. But you can also start with a full spreadsheet or a full database that maybe you have file paths somewhere. And you already have the data about these files somewhere on your computer or somewhere in a data set that is also good. I will actually add them as I go. But this is one way to do it. But you can also have more data to start with. All of that is, by the way, explained also in this Google Doc. So I'm going to start just here with file paths. I forgot to say I am now uploading files from local files on my computer here. But you can also upload from URL. So if you have a cultural institution that has, you know, you are partnering with a cultural institution that has files on the internet, that has files on the web of their collections, then you can actually also use these links to upload directly from that. So you don't have to download them to your computer. I'm now going to give this project name. It's a little bit like creating a file. I'm going to say demo wiki mania 2022. And I'm just going to give it some tags. When you work with Operyfine all the time, you will have a lot of projects going on in your Operyfine software. And you can use tags to make them discoverable. Demo, why not uploads, comments. There we go. I will create the projects and it loads. And here we are. All right. So we have this list of files on my computer here. It actually says that we have 16 rows, but we only see 10 Operyfine has a way to limit the view of the data that you have. That is also a thing that is featured to also preserve memory or to be more careful with the memory of your computer. If you are using really big datasets, you can have views of fewer data, like 50 rows at a time. I will now switch to 25 rows. And I have a column of files here. Now, of course, I want to have some extra information about these files. So in the next steps, and I'm going to skip through that in the recording a little bit, I will actually use Operyfine to add some extra columns with information about all these files. I want to have columns a little bit if you're familiar with Pettypan. This is very similar. You want to have columns with all the data that you want to upload to Wikimedia Commons. So you want things like maybe a short description. You want to have information about the creator, the license, the date when the file was created, etc. I will now go ahead and do that. All right. I have proceeded with adding some data about my files here in my Operyfine project. I have created a column with the file names as I want them to appear on Wikimedia Commons. And for people not super familiar with Wikimedia Commons, these need to be unique. So you will see that I have created unique file names for every file. My original files had very nondescriptive names like Image8025, and I improved that. So I have created a bit of a description inside the file name that's best practice. I have added short descriptions, captions, which will be added as file captions in structured data in English and in my native language Dutch. I have also added a column of the things that are depicted in the file because I want to add that as structured data. And I added the date when the files were created all in 2020. And I have also created a column with WikiText. So Operyfine, as I said, focuses on structured data, adding structured data to files on Commons also when uploading. But files also need to have WikiText. And for that purpose, when you do an upload, it's good to have a column of WikiText. You can also add the WikiText in another place. I'm going to show that later. But if you have diverse WikiText across different files, which I do in this case, you see here one file that shows the windwall and another file that shows the artwork in Belgium. You see that their WikiText is slightly different. So I have a column with that as well. You may notice for the Wikimedia Commons geeks that this WikiText is super simple. And I will talk about that later. Basically, because we are adding structured data, we can keep the WikiText simple because it will be autofilled by the template on Wikimedia Commons. So it will automatically show the structured data, which is awesome. Cool. Let me make my screen a little bit smaller again. Now, next steps that I need to do is actually, before I can start uploading these files, is I have to make Operyfine aware that it should work with Wikimedia Commons and that it should be editing Wikimedia Commons and that it should be adding files there and that it should add these things, which are not just text strings. I want to help Operyfine discover these as Wikidata items. So there is a Wikidata item for the Rosenberg windwall, this really big windwall in concrete near Rotterdam. And there's also a Wikidata item for that artwork, basically this one. I opened it in my image browser. So I want to make sure that Operyfine knows about the Wikidata items for these. So I will do a few steps for that. And the first thing I'm going to do is I am actually going to tell Operyfine, hey, Operyfine, you are now going to edit Wikimedia Commons. Operyfine is able to edit Wikidata, Wikimedia Commons and Wikibases. So anyone who manages a Wikibase can also edit their Wikibase and you basically have to tell Operyfine, okay, now in this case you're not editing Wikidata but another website. And for that you do and all of that is also explained in the Google document again. You select under the Wikidata extension menu here in Operyfine you say, I am going to select the Wikibase instance that I want to work against. And I already have Wikimedia Commons here, I will remove it. So in this menu here you see a link that says discover Wikibase instances. If you click that link it will open a new tab in your browser and then you will go to a GitHub repository that has various what we call Wikibase manifests. These are various settings files for different type for different Wikibases. There is of course Wikidata itself which you will actually not have to enter into Wikidata because it is there by default and there is also the Rhizome one, Rhizome has a Wikibase that's a cultural institution in New York but there's also one for Wikimedia Commons. I'm going to click that one and then you see some code here which is basically the settings file that Operyfine needs to know how Wikimedia Commons works. I can either copy that code and paste it or I can go to the raw and then a raw version of this code and then click the URL of that and I can add that URL in here or I can paste the JSON that I just saw. I think the URL is slightly better because then if this JSON ever changes in the GitHub repository then yeah this URL will help to keep it up to date at Wikibase. Now I have added to Wikimedia Commons and I am going to select it just to make sure that it's blue and now Operyfine is aware that it has to work with Wikimedia Commons and not with Wikibase. Now there's one intuitive not very intuitive thing that you need to do and this is a feature that we want to add we want to improve this we have ideas to improve this. You basically have to tell Operyfine that it needs to create new items, needs to upload new files for this column. I am going now to do some things. I'm going to say reconcile, start reconciling and I am going to reconcile this column against Wikimedia Commons. Basically what I am doing here is I am going, reconciliation is actually looking up a list of values in your dataset and looking it up against another database that can be Wikidata, Wikimedia Commons and in this case I'm looking up the file names on Wikimedia Commons but they don't exist yet and that's totally fine. So my reconciliation is running and that will take a few seconds. The reconciliation is done and if these files would actually have existed already on Wikimedia Commons the links would have been blue. I would have had blue links here, hyperlinks and I would have had a little pop-up showing me oh this is this file, this is this file and I could click it and go to the file on Commons but obviously I am creating new files here. So I am actually now going to tell OpenRefine again here under the reconciliation menu, create a new item for each cell and basically that will tell OpenRefine that it will have to upload new files for me. You see now that each little cell in the data grid has a new label, this one, a little create out label and the column also has this bright green underlined line bright green line and that means that OpenRefine now knows oh I am working with Wikimedia Commons and I'm going to create new files for you. Another thing I want to do is I will actually, I would like to look up the Wikidata items for these two things, the Rosenberg wind well and the artwork by Danielle Buren and for that I am going to do exactly the same thing, I am going to reconcile but against Wikidata. So I say I will do that a little bit slower here under each column in OpenRefine you have a menu with all the powerful things you can do with that column, the menu is for most columns the same, you have reconcile at the bottom which means look up in another database, start reconciling and then by default you will already have the Wikidata one in here and when you add it to Wikimedia Commons just now what I showed you you will also have Wikimedia Commons here. I am selecting Wikidata and then yeah why not installation artwork, it will look up what I have in this column superficially and it will kind of try to guess what kind of type it is, what kind of instance of it is and in this case I have two artworks, public artworks so this is probably quite good installation artwork, sometimes when you have a column with really mixed things you can just say reconcile against no particular type which I'm doing here but I'm super happy with the installation artwork and I am going to say start reconciling that will also take a few seconds to do when you have really big data sets this takes a while so whenever you want to do this and you have a lot of data taken to account that you need time because this algorithm needs time to look up things on Wikidata. Now we see that it has found this work, the work by Daniel Buren in Newport but it has not yet found Rosenberg Windwall I will just search on Wikidata because it's probably not described as installation artwork and now I have matched this as well so my two values here have been matched I am super happy so you see that the links are blue I can actually click on those links and it has linked those cells Opryfin has linked those cells to the Wikidata item and it is a really small picture here well it's a white picture it's a little bit like a panorama but I want to upload my own photos as well because I created nice photos cool so basically my data set is now ready for preparing it for upload you see that some data is missing of course I need to add information about who created these files I am the photographer there is not information yet about the license well there is some here in the Wikitext but I also want to add it as structured data because it's the same for all the files I will do that at the later step and that later step is called schema building so the next step is you are going to go to the next tab here in Opryfin you have the tab of your rows that you're looking at and then you can go to the tab schema and basically here is where you construct the like I would say the template in which your edit will happen the structured data edit will happen I will start by clicking you can also access this by the menu here so that's exactly the same you go to edit Wikibay schema and you go there as well you say add media and then I get some empty information that I can fill with the data that I have here and I am going to do some stuff and maybe speed up the recording a little bit first thing you need to do is actually tell it oh you need to work with my file names here so um these are the files that I want to create new this is the column in which I recall south just now as I showed you so this is the column that Opryfin knows it needs to create on Wikimedia Commons so I am going to drag that one it is underlined in green here as the main thing that needs to be edited and then I Opryfin is asking me for the file path well I have that here so I can drag that column here so it will take actually the values of what we have in the data set here and it will input it there in my schema and then the file name that I want to give it I have the wiki text and then I can also add file captions I want to add the caption in English and that's this one I want to add a caption in Dutch in my native language that is this one and then I can also add some structured data statements and there's some statements I'm going to add is what it depicts the pics and then it depicts the artwork that I just reconciled so it depicts this thing you see that it also has the screen line below it that is shows that it has been reconciled against the database in this case against wiki data and I am going to add some more information like when the file was created file and some more stuff like who created its uploader etc all right I am ready adding some basic statements and of course this looks extremely abstract and I actually want to preview what that will look like when I upload this file to wiki media comments it doesn't look fully like wiki media comments of course but it is a little bit of a preview what each file what kind of data it will have so if you click here in the preview tab you move from the schema tab to the preview tab then you can actually see each individual item or the first the first ones of the set that you have here and you see actually the specific data that it will add so you see that it adds depict statement source of file copyright license copyright status etc we also have an issue step in this case it only tells me oh Sandra watch out you will upload new files well that's exactly what I want of course I need to be careful doing that but if there would be things wrong here like for instance I could have made a mistake in formatting the dates etc I would also get notifications here about that so I think my preview looks rather good and I am ready to actually do my uploads to wiki media comments to do that I can go to the extension menu again here extension the wiki data extension and I select the menu item upload edits to wiki base and then I only need to look in I can I should actually double check here that I am indeed working with wiki media comments so we get a little local here and it also says wiki media comments if I would still have wiki data as the wiki that it would which are wiki data or it can show wiki base but in this case I've added wiki media comments and I am going to enter my credentials here doing that now and I am looking in and then I create an edit summary so this is the edit summary that every file will get so we can make wiki media comments so I'm just gonna say public art work photo draft in 2020 and I am going to say upload edits and then it will do the upload for me the upload is running and so the upload is done I am going to go to my contributions on wiki media comments I actually had to do a bit of I forgot to add a statement so I did an additional statement afterwards I am just going to show you two things and here's where I uploaded the files and you see that with the edit summary of the file you see one link that says details if you click on that link you will go to a tool called edit groups and that is a tool also created by Pintosh our opera refines lead developer which allows you to undo batches so if I have made mistakes in this batch in this set of files then I can undo this I have to say I am not sure if it will be possible to also undo uploads entire uploads because I'm not sure that wiki media comments allows that to any user but if I have for instance added additional circuit data statements to these files and I made the mistake I already did that I make mistakes all the time I am a very confused person then I can just undo an entire group and that's also reassuring if you make mistakes you can actually undo them edit groups also access for wiki data so people working with wiki data doing batch uploads there may be familiar with it already I'm just going to click on one file here and open it in a new tab to inspect my uploads and I actually want to double check if it went well because it's an animated give I created an animation for this artwork so as you can see it shows the file captions that I added to the file and although I used very minimal wiki text you do see that it has that it is loading so it is like basically this wiki text let me show you a bit bigger I updated it a little bit to also improve my name it is this wiki text super simple and it generates this because the wiki text template is actually is actually lua driven and it loads data from wiki data and wiki media comments so it shows information about the sculpture and about me as a photographer so if we look at the structure data tab you see that all the structure data that I included here in operefi in the schema has also yeah this is an additional edit that I did afterwards that it shows that the structure data I added in the schema is also added to wiki media comments and that's by the way I forgot to say one thing um and this is an important thing it is mentioned actually quite clearly um in this document here uploading files to wiki media comments is only possible with operefi 3.7 or newer so for operefi our current version if you go to operefi's website operefi.org then you will see if you click the download button that our official version at this moment is 3.6.0 but we always are working on new code so if you want to download uh if you want to do an upload to wiki media comments you actually have to use 3.7 and you can find it on github it is also included as a link in this document um under download instructions oh it no longer exists let me see download and install operefi and then we go to operefi's github repository and you have a header that is called snapshot releases that's basically the latest code of yesterday that was built automatically and you can download that for your own platform with those users I would encourage you to download the one with embedded java runtime environment we just noticed that that tends to work better um that's it sorry for forgetting to say this it's important uh use 3.7 for this and I welcome questions hi everyone if all is well you should be hearing me live now uh I hope that goes well I am now juggling with two computers so please bear with me I am trying to juggle this um I see that people have asked a lot of questions in the etherpads and I am super happy that I did this pre-recording because I could simultaneously let the recording run and already ask questions so that is a really efficient use of time I hope my answers in the etherpads have been okay and usable for people I would say um I can actually see the chat and I see the etherpad in front of me so if people have more questions I will answer those still and I can answer these live now um um do we have any questions that people want me to answer live I can also repeat some of the major questions that happened in the etherpads while I don't see any other questions popping up because they the answer will actually be nice for the recording one main question that people had was this over refined support all formats I assume that's all the formats that you can do on Wikimedia Commons the answer is yes um with a little hesitation we hope um we tried over refined that with uploading with many many different formats already I uploaded videos I uploaded animated gifs someone did pdfs um that all went well however we are still noticing some trouble but for instance big defiles and I hear that these are also in general for any upload to on Wikimedia Commons quite uh thickly so um we are still looking into that but in theory um we are indeed uh aiming to support all the formats that Wikimedia Commons also supports um I think that's important for the recording uh because I did not mention that in in the video um I see that there is a question are you still looking out for beta testers yes um I notice I cannot discover all the mistakes that the software currently has I cannot discover all the flaws so um actually um the google doc that I shared you can use that to on your own do your first uploads and if you encounter any issues either report them on github if you feel okay doing that it's really github will not bite we are super happy if people support issues on github or just get in touch with me and um I will then help you one on one and also report issues uh we already have some people doing that but more is better because you know more I will see more things and also have more ideas for features that we need so yes please please test um if you have materials to work with I will be grateful um it's as you as you see at the current state is still a little bit experimental we will add some features that they will make it a little bit more user friendly but um yes that should be uh yeah very nice that people do beta testing um let me see we um there was one thing I also did not mention in the video but it's I think also really good for the recording um people are asking maybe some people have trouble installing open we find normally if you have a normal computer and you use a browser on that computer you should be able to install it but sometimes at work people have firewalls or there are connectivity issues or something like that so we do have cases where people cannot really run open we find very well because they are in a work environment where they cannot install any software we also have open we find in the cloud for wiki medians and that is on pause and I put that in the etherpad as well maybe it is already getting hidden hidden among all the nodes so I will also put that link in the chat here um pause is basically and I have to use the right keyword keyboard I'm sorry um it's basically a cloud's place where you can run all sorts of scripts but we also have open we find running there I do have to say it is not managed by us open we find itself it's run by the very enthusiastic volunteers that do the pause installation and um we have been uh having a little bit of difficulty installing the last version of open we find so 3.6 is not there yet and that's a bit of a hassle so um please bear with us if that one is a little bit unstable we're doing our best we're doing this also mostly with yeah little budgets and many of us as volunteers so we do our best to support you there let me see if there are more questions either in the chat that have popped up new or that I can answer here um I see a question offline data verification can that be done I'm not sure if I understand that question I'm very sorry I that doesn't really uh give me uh I I actually don't know what you mean I feel a bit blonde now um but uh if you have a bit more explanation about what that is or a link then I will still try to answer that question because I am intrigued actually um let me see I will scroll down and see that there are other questions I got a suggestion for to look at photomechanic I am curious what the tool is because I am not very familiar with that um the general question yeah so indeed the pause that we just talked about that still runs an older version I am sorry for that um so when will 3.7 be released we are working really hard to have that released by the end of our funded wiki media project which is the end of October 2022 my colleagues are working like beasts to get that done um is it possible to use open refine for batch editing of wiki data records yes and that has been the case for quite a few years already so any the current version of open refine you can use it to edit wiki data that is actually where it all started uh wiki data editing has been the first uh wiki media implementation of open refine and um now we are adding the commons one but the wiki data one is really the old one that many people already do and it's really well tested I can try to find the link to our info page on wiki data but if you google wiki data tools open refine you will find the info page about that um I have a batch of tiff files I want to upload what do you recommend can I just give it a try or should I convert them I would just give it a try we would be if if you're okay with being a little bit of a test um how do you say that uh a guinea pig a tester uh we would actually really appreciate if people want to try the tiff files I don't have tiff files lying around randomly so if you have them please try um and let us know how it goes maybe it goes well um so um another question and that's a great one all the questions are great you're great um can open refine get some meta data from the image or other files like the active meta data um yes well no at this moment not um we have been thinking about that since the start that that would be really really handy to have um but it would require us to code something very specific of you know exit retrieval inside open refine it's absolutely not impossible but we cannot do it in the current grants we are already you know working super super hard the end to finish the basic features we want to have and exit is a wish that we know is there and we cannot support it yet maybe if we get another follow up grant we hope that that could be something we can do I did include in the google document though with the instructions for wiki day for wiki media comments batch uploading the one that I talked about a few times in the recording I have included a small um like note with instructions on how to use an external exit um script which is really easy to use that you you give your files to that script and your files will then have a spreadsheet with all the exit and that you can feed them to open refine I've done that a few times and that works really like a charm basically what we would ideally like to do at some point is have the same mechanic inside open refine of course you just give open refine files and then it will read the exit that you are interested in so we know that the need is there it's just yeah uh that's for a next iteration um can um oh and thank you for making notes of my answer that's awesome is there any chance of the getting David Ewing to create some new tutorials he has a fantastic voice I have never heard his voice so I that would be great I don't know I'm actually I've been working for open refine for a year now and I have never been in touch with him so I don't know the guy I just know that he created the tool at some point but I will keep that suggestion in mind because who knows you know it would be nice um yeah if you have other suggestions for people with good voices who should do tutorials then keep us posted um let's see uh do we have other questions or are we done with questions I'm also looking at the chat um ah what were the solutions for batch uploading before open refine um there were and are still a lot of solutions um many people use bots if you can if you are a programmer you will be inclined to write a bot for you know your your batch uploads that's what we're all you know the batch upload started and then other tools came around a tool called Patty Pan um which has been uh broken for for a while in the past year but it's back up Patty Pan is still um is has been repaired so you can use it again but it does not do structure data and I expect that Patty Pan will also not support structure data in the future uh structure data is a quite complicated thing to add and I can imagine that people will I would really like to see that people move towards open refine um so I really hope that people are open to start using open refine um there are there are quite a lot of other batch uploading tools if you google Wikimedia Commons batch uploading you will find a few instruction pages that lists various tools that are popular for that um another one that has been quite popular but that one is also sunset it it does not work at all anymore is the glam wiki tool set that was a really really powerful one where you could input xml files where control institutions could do you know really complicated things with their databases and pushing their databases to commons but that one is gone um and there are other tools still around um but in my biased opinion open refine is a really good addition to that because it that's so much flexibility um it is very possible that you use by wikibots yes because that's the bot framework that a lot of bots programmers are uh yeah using to write bots so if you do some scripting then that is your place to go and I see that alex has also linked some uh uh yeah information about other tools vquinnia uploader is indeed I think still used um I don't use it myself that's uh I know about the tool I see here that the counter has done I'm not sure if that's really hard cut or if I am now not hearable anymore by anyone um but I think we are a bit at time for this session um so I will check out the tutorial by David I am very curious to hear his voice I really hope this was informative for people um and as I said in my recording before um I will be back we will be back with more tutorials and training and I really hope many of you show up there and we can start a small community of open refine users uh for wikibit comments thank you yeah in my case the screen says zero type remaining but I can apparently just keep going on um yeah