[Wikidata-bugs] [Maniphest] [Closed] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac closed this task as "Resolved".Tomayac claimed this task.Tomayac added a comment. @Spinster I'm closing this task :-)TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. To reflect the changes, I have renamed the add-on to "Wikipedia and Wikidata Tools for Google Spreadsheets" :-)TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. Alright, this is now fully working. You can as of now say… WIKIDATAFACTS("Q42", "all", "P106") …to get all of Douglas Adams' occupations (i.e., P106). If you replace "all" with "first", you will just get the first occupation. If you want several properties, pass them as an array like… WIKIDATAFACTS("Q42", "all", {"P31"; "P106"})TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. I am now actively working on this and have just updated the GitHub issue accordingly: https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/12#issuecomment-257088707.TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. Thanks for the realworld example (I have created a copy https://docs.google.com/spreadsheets/d/1pSXDJ0h_SxkupmvIVUruUrCpmlcHJp0hXK3oqIl17Sw/edit?usp=sharing that I could edit). So, there is a solution for your column D (=QUERY(WIKIDATALABEL(B2, "en"), "SELECT Col2")) and with a couple of hops for your other columns, but I can see how this can be tedious. I have created https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/10 and will work on this in the near to mid future :-)TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. @Spinster I think this is possible by working with native functions, check this example.TASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T146140: wishlisted: Wikidata Tools for Google Spreadsheets add-on
Tomayac added a comment. Hi @Spinster, I believe what you envision is already possible with the latest version of the add-on. Please see the WIKIDATA* functions, namely WIKIDATAQID, WIKIDATAFACTS, WIKIDATALABELS in the documentation. Cheers, TomTASK DETAILhttps://phabricator.wikimedia.org/T146140EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: TomayacCc: Spinster, Tomayac, Aklapper, dachary, D3r1ck01, Izno, Wikidata-bugs, aude, Ricordisamoa, Sjoerddebruin, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T123511: [Task] adapt primary sources tool to text/icon changes
Tomayac added a comment. Perfect, thanks for the Pull Request. Merging now! Could any of the admins deploy <https://github.com/google/primarysources/tree/master/frontend#deployment-on-wikidata> the gadget? TASK DETAIL https://phabricator.wikimedia.org/T123511 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: inyono, Tomayac Cc: Tomayac, inyono, StudiesWorld, Sjoerddebruin, Tpt, adrianheine, thiemowmde, Aklapper, Tobi_WMDE_SW, Ricordisamoa, Jonas, Lydia_Pintscher, gerritbot, Bene, D3r1ck01, Izno, Wikidata-bugs, aude, TheDJ, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Changed Subscribers] T99243: make it possible to order statements in an item
Tomayac added a subscriber: Tomayac. TASK DETAIL https://phabricator.wikimedia.org/T99243 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Tomayac Cc: Tomayac, Liuxinyu970226, matej_suchanek, Mbch331, JeroenDeDauw, Ricordisamoa, daniel, thiemowmde, Bene, Aklapper, Lydia_Pintscher, Wikidata-bugs, aude, Malyacko, P.Copp ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T95289: Deploy Google's primary sources tool to beta and test.wikidata
Tomayac added a comment. I fixed this with commit https://github.com/google/primarysources/commit/cc2da3c08b7663a24343d7dd94b34410e7d84d68, the user script should be testable now on test.wikidata.org and beta. TASK DETAIL https://phabricator.wikimedia.org/T95289 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: JanZerebecki, Tomayac Cc: JanZerebecki, Tomayac, Denny, Lydia_Pintscher, Tobi_WMDE_SW, Aklapper, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Changed Subscribers] T95290: Browsertests for Google's primary source tool
Tomayac added a subscriber: Tomayac. TASK DETAIL https://phabricator.wikimedia.org/T95290 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Tomayac Cc: Tomayac, Denny, Aklapper, Tobi_WMDE_SW, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Changed Subscribers] T95289: Deploy Google's primary sources tool to beta and test.wikidata
Tomayac added a subscriber: Tomayac. TASK DETAIL https://phabricator.wikimedia.org/T95289 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Tomayac Cc: Tomayac, Denny, Lydia_Pintscher, Tobi_WMDE_SW, Aklapper, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs