Talk:Global Open Initiative/UG Digital Collection Wikidata Batch Upload Documentation/Open Refine

@Masssly: I have converted Book Chapters and Reviews_submissions into an excel sheet and shared with all team members working on this and this is the Wiki page we will be using. We @Kinvidia, Mwintirew, Sunkanmi12, Shahadusadik, Afroprogrammer, Terese Baidoo, Nana yaa series, Warmglow, Jemima2019, and Dhee jah: (the GOI team) will be on standby for further instructions. Celestinesucess (talk) 10:58, 2 November 2020 (UTC)

Okay, great. We already did a few of the items to show what they'll look like when we were requesting for P8602. The next steps would be to

• Determined if these items already exist which I doubt except for these three. But feel free to go ahead and further check for the titles in case they do exist but just haven't been connected with P8602.
• If an item doesn't exist then create them on Wikidata. Let's ensure that we include a unique keyword the Edit summary of this project, so we can easily pull up all the items if we need to check for errors. Here is the documentation for the Quickstatements commands in case you need it.
• Perform a running Listeria query (you could start with this step), so we can have an overview of the items and all of their statements including their descriptions and labels. That way we know where we are and what statements are missing.

Feel free to ping me on the Wikis if something is unclear, so I could take a look. -—M@sssly^✉ 16:03, 8 November 2020 (UTC)

Listeria Lists

@Masssly: I am trying to create the Wikidata query which will be used as the listeria query but the subject and author statements are creating duplicate entries. I am not sure how to fix this, can you help please? Celestinesucess (talk) 00:10, 11 November 2020 (UTC)

​Apologies for responding late. I think it's because there are multiple subject matters and authors for each. We'd have to figure out a way to efficiently group and separate them with a comma (GROUP_CONCAT(DISTINCT ?mainsubject; separator = ", "), but you could easily ask here and save us the time. BTW, does ListeriaBot update pages here on Meta? If not, then you might want to move this conversation to a Wikipedia or Wikidata page. —M@sssly^✉ 15:31, 20 November 2020 (UTC)