christianroy
commented
1 week ago Autre hypothèse: utiliser l'option Partager/Publier sur le web de Google Sheets, en ne partageant que l'onglet pertient.
Le résultat serait sous cette forme: https://docs.google.com/spreadsheets/d/e/2PACX-1vSqUTZJhwOkggd-d9FOy7bar74jDyOZveGvOieCh0mWBm4Bc08SE5alcMW5kFZ2en5SaDnzv0WeaZBA/pubhtml?gid=2032887030&single=true
Est-ce que Nebula saurait importer à partir d'une telle page?
Context
In parallel to the development of Culture Creates's MVP, CAPACOA commission A10s to develop another spreadsheet-based tool to convert an in-house spreadsheet into structured data:
Issue
This MVP transforms tabular data into JSON-LD that is fully compliant with the Artsdata model. However, there is no means yet to upload this data to Artsdata.
Solution 1.A - Use the same upload method as with the smart chip MVP
We could easily insert a first tab with the same column headings as the smart chip MVP and then code formulas to automatically populate the first tab with data from other tabs. However, that would be extremely confusing for the user: the first tab they would see in the sheet would be a tab with locked cells that they would not be able to edit. Bad user experience = no adoption.
Solution 1.B - Same as above, but hide the first tab
We tried hiding the first tab and then dereferencing the Google Sheet. Finding: Nebula does "see" a hidden first tab when we dereference the Google Sheet. This is currently not a good solution (unless we find a way for Nebula to see a hidden tab).
Solution B - Ask the user to embed the JSON-LD on their web pages and then crawl the site
While this is technically feasible, it involves too many steps for the user and it would even generate an immediate result: they would have to notify Culture Creates via email and then someone would send a bot several weeks later. Too big an effort + delayed reward = unlikely to yield adoption.
Solution C - Implement the new "publish to Artsdata" feature into the A10s spreadsheet
The next work order for the smart chip project involves developing a "publish to Artsdata" feature.
@saumier: Could expand the scope of this project to implement this new feature into the A10s spreadsheet as well?
If so, could we use the feature to publish the current JSON-LD data or would we need to create a new tab with data laid out in tabular format?
Would the user need to "publish to Artsdata" while in the actual tab or could they trigger the publication from any tab?