[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
RonnieV added a comment. It seems the first batch is imported, but not the rest of 'monumenten.xls'. Not sure about the status of other files. The script for making pages on the Dutch Wikipedia on the information in 'Kopie van Erfgoed van Strijd Bevrijding Verzet.xls' was kind of working at the end of WTS2018. Migth have another look at it, so we can make it work before WTS2019 and have all these articles made. TASK DETAIL https://phabricator.wikimedia.org/T207839 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Pintoch, RonnieV Cc: Ecritures, Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, darthmon_wmde, Yupik, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, _jensen, rosalieper, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Ecritures added a comment. Is this task resolved? @Pintoch @SIryn @RonnieV ? Or should it still be on the workboard for WTS2019 in November? TASK DETAIL https://phabricator.wikimedia.org/T207839 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Pintoch, Ecritures Cc: Ecritures, Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, darthmon_wmde, Yupik, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, _jensen, rosalieper, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
SIryn added a comment. In T207839#4701516, @RonnieV wrote: Good to see that you found a solution for the strange addition which changes integers to floats. New imports will be fine, so it's just a one time clean-up for 100 records. Manual handling is a quick solution, writing a script might be nicer and help in other cases Would writing a script be the way to go since the problem is not existing in the future? If it is to much work for just 100 uploads, I did be happy to adjust them manually.TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, SIrynCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
SIryn added a comment. In T207839#4701366, @RonnieV wrote: The spreadsheet which Slryn made available has also a description of each monument. If this information is available under the right license, we could use this spreadsheet to create pages for monuments and use the infobox and these descriptions to start with articles on a reasonable level. Some script to use a csv to create these pages and fill them was already made yesterday. I'll upload it to github. I'll get on making this happen. My collegeau told me that they are actually freely licensed, but we do not have the written statement to back it up. It would be great if we could use the descriptions to make articles. I'll let you know how it works out.TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, SIrynCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Pintoch added a comment.
Just to let you know that the problem with the ".0" will be solved in the next version of OpenRefine.
In the meantime, you can solve the issue by transforming your column with the following _expression_: value.toString().replace(".0",""). Hope it helps!TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: PintochCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment.
Added another batch{F26968548}TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. I figured there might already be a script available. Basically there are a lot of items that have no known suggestion. These could be automatically set to 'new item' (Note: this isn't foolproof. For example the Anne Frank house doesn't get a suggestion, if you try to add it as a monument, but of course it's already in Wikidata under a different, and probably more suitable label). A lot of other items do get suggestions for possible Wikidata matches. Since we already did a check in advance these are usually wrong. The monuments we're working with all have an unique identifier, so it might be possible to exclude these false suggestions, but I'm not sure how to go about it.TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
RonnieV added a comment. Good to see that you found a solution for the strange addition which changes integers to floats. New imports will be fine, so it's just a one time clean-up for 100 records. Manual handling is a quick solution, writing a script might be nicer and help in other casesTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, RonnieVCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. Er is nog een issue: OpenRefine heeft de identifier als integer gelezen en er een ,0 aan toegevoegd. Ik heb geprobeerd dit te corrigeren door de kolom op tekst te zetten. Nu is de identifier echter gedoubleerd. Weet iemand hoe dit opgelost kan worden? Zie bijlage https://www.wikidata.org/wiki/Q57907750 F26946020: image.pngTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. We were planning to upload the whole list in one go, but it required to much manual checking. I ended up adding a first batch of 100 items (see attachment). F26943519: monumenten.xlsxTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
RonnieV added a comment. The spreadsheet which Slryn made available has also a description of each monument. If this information is available under the right license, we could use this spreadsheet to create pages for monuments and use the infobox and these descriptions to start with articles on a reasonable level.TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, RonnieVCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
RonnieV added a comment. If we get so much detailed information into Wikidata, we should try to use a Wikidata-driven template to show this information on Wikipedia. Will we use a special template for this, or update the template [https://nl.wikipedia.org/wiki/Sjabloon:Infobox_beeld]? Not all monuments are sculptures. Should we make a subtask or a separate task for this?TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, RonnieVCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Multichill added a comment. https://github.com/multichill/toollabs/blob/master/bot/wikidata/oorlogsmonumenten_import.py code I used for tsv generation and importTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, MultichillCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Jane023 added a comment. The 6 test items uploaded well but these were the first 6 ids (1,2,3,4,5,6) and after upload these were added in decimal format with ".0" after the number. Open refine is great when it works as expected... Meanwhile multichill has also added some images to existing items. Listeria list is here for now, a war memorial WikiProject should probably be made to park this stuff more permanently https://www.wikidata.org/wiki/User:Jane023/oorlogsmonumentenTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, Jane023Cc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. F26887561: oorlogsmonumentenWikipedia.xlsx Latest version of fileTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Jane023, Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Multichill added a comment. Scraped the Dutch Wikipedia. TSV @ https://tools.wmflabs.org/multichill/queries/nlwp/oorlogsmonumenten.tsvTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, MultichillCc: Multichill, Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Jane023, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. Hi Pintoch, A demo would be great. It's just me (Fricke), so far, but I'm expecting three team mates. We will also have to convert some GPS coordinates in bulk. Do you have a tip what tool/site we could use for this?TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Arybolab, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Jane023, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Pintoch added a comment. Awesome! \o/ Actually OpenRefine could potentially help you already at that stage to do the matching - let me know if you want a quick demo :)TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: PintochCc: Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Jane023, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. We made an export of all Dutch war memorials in Wikidata and compared them with our list (Monumenten - Gelderland). 37 memorials already have a page.TASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Jane023, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T207839: Batch add WO II war memorials to Wikidata
Footech added a comment. We are willing to help out with this. Is anyone working on this yet? Fricke en LoisTASK DETAILhttps://phabricator.wikimedia.org/T207839EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Pintoch, FootechCc: Footech, Elvalente, Pintoch, RonnieV, SIryn, Vemonet, A_ka_es, Teffubud, S9a8m, Dja, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, DDJJ, Harmonia_Amanda, Spinster, Jane023, Wikidata-bugs, aude, Mbch331, valhallasw___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
