English subtitles for clip: File:OpenRefine Commons - upload - prepare a project with all necessary columns.webm

1
00:00:03,720 --> 00:00:06,720
This is an OpenRefine project 
in which I have prepared 

2
00:00:06,720 --> 00:00:10,600
all the columns I need for a 
batch upload to Wikimedia Commons.

3
00:00:10,600 --> 00:00:15,400
I am going to be uploading 81 
files from this website, PhyloPic, 

4
00:00:15,400 --> 00:00:20,640
which has silhouette pictures of various 
taxa ... species around the world.

5
00:00:21,560 --> 00:00:24,360
Many of them are freely licensed .

6
00:00:24,360 --> 00:00:27,880
I have taken data from this website via the API, 

7
00:00:27,880 --> 00:00:33,880
and I have spread this out through the columns 
that are needed to do the batch upload.

8
00:00:33,880 --> 00:00:36,760
I will go through the columns.

9
00:00:36,760 --> 00:00:41,680
The first column here that you see is 
the link to the actual file itself. 

10
00:00:41,680 --> 00:00:43,880
So this is where the file lives on the website.

11
00:00:43,880 --> 00:00:47,360
You see that it is a very big 
picture; it's a vector file. 

12
00:00:47,360 --> 00:00:50,000
So this is the file we want to upload.

13
00:00:50,000 --> 00:00:54,920
There is also a link to the page 
in which the file is living, 

14
00:00:54,920 --> 00:00:58,040
and that we will use for the source of the file.

15
00:00:58,040 --> 00:01:00,531
So, you see that there are two different URLs.

16
00:01:01,120 --> 00:01:03,840
Otherwise, I also have a column with the file name...

17
00:01:03,840 --> 00:01:06,480
... that I want this file to 
have on Wikimedia Commons.

18
00:01:06,480 --> 00:01:10,760
I've made it quite descriptive, 
so it includes various things: 

19
00:01:10,760 --> 00:01:14,240
the name of the species that is 
being depicted; the website;...

20
00:01:14,240 --> 00:01:17,560
... and the creator of the illustration.

21
00:01:17,560 --> 00:01:21,000
I also already prepared a 
column with a file caption.

22
00:01:21,000 --> 00:01:25,160
I could add more columns with more 
languages - if I know more languages.

23
00:01:25,160 --> 00:01:31,400
There is also, from the API, a column with 
attribution data, which I will add in my upload.

24
00:01:31,400 --> 00:01:34,040
There's a creation date of the file.

25
00:01:34,040 --> 00:01:37,320
There's the name of the person 
who made the illustration; 

26
00:01:37,320 --> 00:01:40,800
there is also a link to this person's profile.

27
00:01:40,800 --> 00:01:43,640
So these are all the illustrations by this person;  

28
00:01:43,640 --> 00:01:49,360
which I will use for the source as well, 
or to describe the creator of the file.

29
00:01:49,360 --> 00:01:51,720
Then there is a column with a taxon name. 

30
00:01:51,720 --> 00:01:54,720
As you can see, I have not 
reconciled this with Wikidata yet.

31
00:01:54,720 --> 00:01:56,440
I will do this later.

32
00:01:56,440 --> 00:02:01,960
I have a column with the licenses of the files.
I have reconciled these already.

33
00:02:01,960 --> 00:02:05,800
And, last but not least, 
I have a column with wikitext, 

34
00:02:05,800 --> 00:02:09,400
in which I have prepared 
the same wikitext for all my files.

35
00:02:09,400 --> 00:02:12,040
As you can see, 
I am using minimal wikitext. 

36
00:02:12,040 --> 00:02:15,580
So, I am using only the simplified 
templates from Wikimedia Commons...

37
00:02:15,580 --> 00:02:21,920
... and I'm even using an experimental template
that will draw the license from structured data.

38
00:02:21,920 --> 00:02:27,800
And I included one category, which is the category 
of the resource where the images are coming from.

39
00:02:27,800 --> 00:02:31,920
If I am a good citizen, I will later on 
also add a category for the species.