Then she would select the one that she needs, from the Nepali Central Bank and select the last row, the column that contains the number, and click the “insert” button. She would go to Insert > Open Data… there a window appears with a search box, she writes “Nepal inflation”, this would trigger a search of all datasets those that match. The accountant is using a spreadshet application to (for example) evaluate investments in different countries, and she needs to know the inflation rates for each country. Now I will have to confirm if there’s an actual use case for that. So I’m confirming my impression that there’s no easy way to consume open data from inside spreasheet apps, which seems like a gap the process. If you know about any, please let me know. So, tu summarize: I think consuming data and browsing data catalogs from inside spreadsheet applications could be a great way to improve data usability, but I can’t find any solution that currently works. But it had so many javascript errors that I was not able to use it with the CKAN-based argentinian data portal (About LibreOffice, they also claim to have support for something called WebQuery, but I can’t follow this wiki’s instruction in my LibreOffice 5 installation, maybe it’s changed. I tested in Excel 2003 and it seemed to have a feature where you would use an embedded browser to find tables in HTML and import them to the workbook. I don’t have access to the Excel version that has OData support. I searched this forum for mentions of OData but there’s none, so I’m guessing there’s something wrong with it, isn’t there? There’s even a CKAN extension for it: This CKAN extension provides a basic OData endpoint - CKAN ExtensionsĪnd there’s a recent fork that improves it. It seems like the OData protocol is a standard set of APIs so that any app can consume data from any portal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |