1 00:00:00,550 --> 00:00:02,800 Welcome back to this tutorial

2 00:00:02,850 --> 00:00:04,225 on using OpenRefine

3 00:00:04,225 --> 00:00:06,050 to import data into Wikidata.

4 00:00:07,700 --> 00:00:09,775 In the previous videos,

5 00:00:09,775 --> 00:00:10,988 we have matched the films

6 00:00:10,988 --> 00:00:12,525 and locations in our table

7 00:00:12,525 --> 00:00:15,375 to items.

8 00:00:13,883 --> 00:00:16,883 We now want to transform our table into statements

9 00:00:16,882 --> 00:00:19,882 and upload them to Wikidata.

10 00:00:19,988 --> 00:00:22,169 Let's first look at how this information

11 00:00:22,169 --> 00:00:24,350 is typically modelled in Wikidata.

12 00:00:24,986 --> 00:00:26,743 Pick a well-known movie

13 00:00:26,743 --> 00:00:28,500 where we expect to find this information.

14 00:00:29,114 --> 00:00:32,113 We can see that there is a "filming location" property for that.

15 00:00:33,850 --> 00:00:35,575 We review the page of the property

16 00:00:35,575 --> 00:00:37,300 and make sure it fits our needs.

17 00:00:37,695 --> 00:00:40,695 In this case it looks like a perfect fit!

18 00:00:44,867 --> 00:00:46,367 Click the Wikidata button

19 00:00:46,367 --> 00:00:47,383 in the top right corner

20 00:00:47,383 --> 00:00:50,770 and choose "Edit Wikidata schema".

21 00:00:52,010 --> 00:00:54,600 A schema is a template of Wikidata edits

22 00:00:54,600 --> 00:00:56,650 that describes how your tabular data

23 00:00:56,650 --> 00:00:59,610 will be transformed into Wikidata edits.

24 00:01:00,980 --> 00:01:03,415 It works pretty much like the Wikidata interface,

25 00:01:03,415 --> 00:01:06,000 except that you can drag and drop column names

26 00:01:05,950 --> 00:01:07,650 in place of values.

27 00:01:08,947 --> 00:01:11,947 Click "Add item".

28 00:01:12,099 --> 00:01:14,750 The items we want to modify

29 00:01:14,650 --> 00:01:15,725 are the films

30 00:01:15,725 --> 00:01:16,963 which we have reconciled

31 00:01:16,963 --> 00:01:18,200 in the "Title" column.

32 00:01:18,690 --> 00:01:21,690 So drag and drop that column to the item.

33 00:01:23,850 --> 00:01:25,450 You can see that this column

34 00:01:25,400 --> 00:01:27,625 is underlined in green:

35 00:01:27,625 --> 00:01:29,800 that is because we have reconciled it

36 00:01:29,000 --> 00:01:30,550 to Wikidata.

37 00:01:30,789 --> 00:01:33,019 You can only use reconciled columns

38 00:01:33,019 --> 00:01:35,550 in the inputs where an item is expected.

39 00:01:38,249 --> 00:01:40,249 On each of these items,

40 00:01:40,249 --> 00:01:42,250 we want to add the filming locations.

41 00:01:42,968 --> 00:01:45,009 Drag and drop the street column

42 00:01:45,009 --> 00:01:47,050 in the filming location.

43 00:01:48,559 --> 00:01:50,605 You can get a preview of the edits

44 00:01:50,605 --> 00:01:52,950 generated by the schema in the "Preview" tab.

45 00:01:54,367 --> 00:01:55,570 In the "Issues" tab,

46 00:01:55,570 --> 00:01:56,750 you get some feedback

47 00:01:56,750 --> 00:01:58,580 about the quality of your edits

48 00:01:58,580 --> 00:02:01,100 before they are made.

49 00:02:01,100 --> 00:02:02,940 OpenRefine complains about the fact

50 00:02:02,940 --> 00:02:06,099 that we haven't added any reference

51 00:02:04,200 --> 00:02:05,830 to our statements.

52 00:02:05,830 --> 00:02:08,050 So let's do that.

53 00:02:08,525 --> 00:02:10,288 I'm going to use the URL for the dataset

54 00:02:10,288 --> 00:02:12,050 with a retrieved date.

55 00:02:12,820 --> 00:02:15,540 We can also create an item for the dataset

56 00:02:15,540 --> 00:02:18,794 and use it in the reference if you prefer.

57 00:02:23,501 --> 00:02:25,701 While we are here, why not

58 00:02:25,701 --> 00:02:28,621 adding a few qualifiers to the statements...

59 00:02:28,625 --> 00:02:32,625 We have the start and end dates of the shooting

60 00:02:32,641 --> 00:02:36,641 as well as the geographical coordinates.

61 00:03:07,144 --> 00:03:09,524 It is also useful to check, if our additions

62 00:03:09,529 --> 00:03:11,779 will conflict with any existing data

63 00:03:11,779 --> 00:03:12,819 on the items.

64 00:03:13,380 --> 00:03:16,410 We fetch the existing values for the filming locations

65 00:03:35,208 --> 00:03:38,018 Once fetching has completed we use a text facet

66 00:03:38,018 --> 00:03:41,041 to inspect the sort of values they are.

67 00:03:42,057 --> 00:03:44,317 Most of these films do not have any

68 00:03:44,317 --> 00:03:45,857 filming location yet.

69 00:03:45,865 --> 00:03:47,345 and when they have one,

70 00:03:47,355 --> 00:03:50,705 it is a much less precise location.

71 00:03:50,874 --> 00:03:53,974 It should not be hard to remove the less precise location

72 00:03:53,975 --> 00:03:56,335 which are redundant with our additions

73 00:03:56,335 --> 00:03:58,844 once the dataset is uploaded.

74 00:03:58,844 --> 00:04:00,964 So, we're happy with our edits.

75 00:04:01,283 --> 00:04:03,763 Because this is a rather small dataset,

76 00:04:03,763 --> 00:04:06,021 we will upload it directly.

77 00:04:06,021 --> 00:04:07,601 For larger imports,

78 00:04:07,614 --> 00:04:08,954 complicated schemas,

79 00:04:08,965 --> 00:04:11,065 or large scale creation of new items

80 00:04:11,073 --> 00:04:13,023 it is good to request feedback

81 00:04:13,023 --> 00:04:15,113 about the import in Wikidata first.

82 00:04:15,250 --> 00:04:19,020 Click "Wikidata" – "upload edits to Wikidata"

83 00:04:19,927 --> 00:04:21,787 You will need to log in with your

84 00:04:21,796 --> 00:04:22,936 Wikidata account,

85 00:04:22,936 --> 00:04:26,166 this account will be used to make the edits.

86 00:04:26,166 --> 00:04:28,056 Add a meaningful edit summary

87 00:04:28,056 --> 00:04:29,376 to describe your edits

88 00:04:31,484 --> 00:04:34,073 This is important because it helps other editors

89 00:04:34,073 --> 00:04:35,973 understand what your edits do,

90 00:04:35,976 --> 00:04:38,376 when they look in the history of an item.

91 00:04:39,677 --> 00:04:43,977 We can now upload the dataset to Wikidata.

92 00:04:43,998 --> 00:04:46,188 You can check how the upload is going

93 00:04:46,188 --> 00:04:50,428 by looking at your own contributions.

94 00:04:53,710 --> 00:04:55,834 If you notice any issue with an edit

95 00:04:55,834 --> 00:04:58,604 you can cancel the upload in OpenRefine.

96 00:04:58,614 --> 00:05:01,154 This will stop making any further edits

97 00:05:01,159 --> 00:05:05,156 but will not remove the edits already made.

98 00:05:05,156 --> 00:05:06,616 To remove these edits

99 00:05:06,616 --> 00:05:08,276 click in the "details" link

100 00:05:08,276 --> 00:05:10,206 of any edit in the group.

101 00:05:10,214 --> 00:05:13,334 This will lead you to the edit groups tool

102 00:05:13,354 --> 00:05:17,354 where you can undo the entire edit group easily.

103 00:05:27,178 --> 00:05:29,038 This is the end of the tutorial

104 00:05:29,040 --> 00:05:33,040 I hope you enjoyed it, thanks for watching!