English subtitles for clip: File:OpenRefine Commons - upload - indicate to create new files.webm

1
00:00:02,920 --> 00:00:06,480
In this OpenRefine project 
I am going to upload files 

2
00:00:06,480 --> 00:00:08,900
from the web, from this specific website,...

3
00:00:08,900 --> 00:00:15,800
... which has freely licensed
silhouette images of various species.

4
00:00:15,800 --> 00:00:19,560
I have prepared most of my columns 
quite well in this project.

5
00:00:19,560 --> 00:00:21,960
I have now arrived at a step where I am going 

6
00:00:21,960 --> 00:00:25,420
to tell OpenRefine that it 
has to upload new files,...

7
00:00:25,420 --> 00:00:29,800
... by actually working with my file name column. 

8
00:00:29,800 --> 00:00:34,640
So I have a column with file names, as 
I want them to be on Wikimedia Commons.

9
00:00:34,640 --> 00:00:37,160
They look a bit like this.

10
00:00:37,160 --> 00:00:40,080
And with this column, I need to tell OpenRefine 

11
00:00:40,080 --> 00:00:43,560
that it has to create, basically, 
new items on Wikimedia Commons,...

12
00:00:43,560 --> 00:00:46,760
... similar to creating new items on Wikidata.

13
00:00:46,760 --> 00:00:49,960
The first method is the more convoluted method.

14
00:00:49,960 --> 00:00:56,440
I use the menu of this column; I go to 
"Reconcile..." - "Start reconciling..."

15
00:00:56,440 --> 00:00:59,520
And, in this case, I will 
reconcile these file names 

16
00:00:59,520 --> 00:01:01,920
with Wikimedia Commons.

17
00:01:01,920 --> 00:01:04,239
Wikimedia Commons, because I am going to check 

18
00:01:04,239 --> 00:01:07,480
whether these file names already 
exist on Wikimedia Commons.

19
00:01:07,480 --> 00:01:10,320
And, of course, OpenRefine 
will discover that they do not, 

20
00:01:10,320 --> 00:01:14,120
and then I will tell 
OpenRefine to create new items.

21
00:01:14,120 --> 00:01:16,200
So I start doing this.

22
00:01:16,200 --> 00:01:21,560
I just ignore what is in the screen here;
I say "Start reconciling...".

23
00:01:21,560 --> 00:01:26,040
Reconciliation goes pretty fast.
And, as you can see, nothing is reconciled,

24
00:01:26,040 --> 00:01:26,640
and that is correct...

25
00:01:26,640 --> 00:01:30,240
... because these files do not 
exist on Wikimedia Commons yet.

26
00:01:30,240 --> 00:01:35,880
I go to the "Reconcile..." menu again,
and then I do "Actions..."

27
00:01:35,880 --> 00:01:43,520
and then I say:
"Create a new item for each cell".

28
00:01:43,520 --> 00:01:45,080
My action was successful. 

29
00:01:45,080 --> 00:01:49,400
You see that the file name column 
now has a light green line,...

30
00:01:49,400 --> 00:01:53,200
... meaning that all these items,
things in this column,

31
00:01:53,200 --> 00:01:56,080
will be new; will become new items.

32
00:01:56,080 --> 00:02:04,720
And you also see that there is
a subtle "new" indication next to each file.

33
00:02:04,720 --> 00:02:07,520
I have now gone back to the 
previous state of the project.

34
00:02:07,520 --> 00:02:10,479
File names are not reconciled 
yet with Wikimedia Commons; 

35
00:02:10,479 --> 00:02:12,880
they are not indicated yet as new.

36
00:02:12,880 --> 00:02:16,000
And there is a new, and simpler, way to indicate 

37
00:02:16,000 --> 00:02:20,800
that OpenRefine should create 
new files, or upload new files.

38
00:02:20,800 --> 00:02:23,360
I use the menu of the file name column again.

39
00:02:23,360 --> 00:02:29,760
I go to "Reconcile..." and then 
I immediately go to "Actions...". 

40
00:02:30,480 --> 00:02:34,080
Then I say: "Create a new item for each cell".

41
00:02:34,080 --> 00:02:42,520
And then I can directly select
the Wikimedia Commons reconciliation service here.

42
00:02:42,520 --> 00:02:46,960
I click "OK", and then all the 
files are immediately marked 

43
00:02:46,960 --> 00:02:49,880
as that they should become new files.

44
00:02:49,880 --> 00:02:52,320
You can only do this if you are really certain 

45
00:02:52,320 --> 00:02:55,200
that these file names are not 
present on Wikimedia Commons yet,...

46
00:02:55,200 --> 00:02:59,760
... otherwise you will not 
be able to upload your files.