search

tomayac / wikipedia-tools-for-google-spreadsheets

Wikipedia Tools for Google Spreadsheets — Install:
https://gsuite.google.com/marketplace/app/wikipedia_and_wikidata_tools/595109124715?pann=cwsdp&hl=en
Apache License 2.0
141 stars 32 forks source link

Error: Function not rcognised #38

Closed Llywelyn2000 closed 4 years ago

Llywelyn2000 commented 4 years ago

The tool worked perfectly until around 17.00 yesterday, and has been down since.

tomayac commented 4 years ago

Most probably you have exceeded your daily quota for URL Fetch calls that the plugin uses internally to communicate with the Wikipedia and Wikidata APIs. You can see the quota here: https://developers.google.com/apps-script/guides/services/quotas#current_quotas.

Llywelyn2000 commented 4 years ago

Thnaks! Might be for me, but not for two other users who hadn't used it yesterday. They get the same message.

tomayac commented 4 years ago

Can you try the solutions from this answer: https://stackoverflow.com/questions/32077904/custom-function-not-recognized. The Google Sheets backend occasionally gets stuck :-(

Llywelyn2000 commented 4 years ago

No. Tried 4 diff browsers. Do they work for you? Try =WIKIDATAQID(CONCAT("en:",B2)) in B1; enter 'London' or 'Madrid' in B2. Should return the Qcode (Qid).

tomayac commented 4 years ago

It worked. One tip is to open the documentation, this helps "kick" the loading of the add-on. See the screenshot below for how to do this:

Screen Shot 2020-04-08 at 09 29 48
Llywelyn2000 commented 4 years ago

It worked! Reminds me of starting our old Morris Oxford by hand, back in the early 70s! But it worked! Thanks for your time and patience!

tomayac commented 4 years ago

Happy it worked. I also looked up Morris Oxford and was not disappointed. What a diamond!