search

ckan / ideas

[DEPRECATED] Use the main CKAN repo Discussions instead:
https://github.com/ckan/ckan/discussions
40 stars 2 forks source link

App to add a GDocs Spreadsheet to CKAN instance like datahub.io in one click #3

Open rufuspollock opened 11 years ago

Aaron-M commented 10 years ago

Just fyi, we (Landcare Research in NZ) are investigating linking the DataUp excel addin* which allows you to record metadata for your dataset. Out of the box DataUp deposits to a US repository (DataONE), but we are looking at getting it to send data into our installation of CKAN.

*http://dataup.cdlib.org/dataup_features.html (note the DataUp developers have decided to focus on the webapp, but I see more value in the excel addin)

rossjones commented 10 years ago

+50 on excel import. +30 on GDocs ;)

rufuspollock commented 10 years ago

@Aaron-M huge +1 here - do you have a link to any example excel plugin code?

Aaron-M commented 10 years ago

@rgrp The original developers code is on this bitbucket site https://bitbucket.org/dataup/main/downloads (documentation and install of compiled addin) https://bitbucket.org/dataup/main/src (code of both webapp and addin)

They originally produced 2 versions, the Addin which users interact with inside excel (can be used offline for most of the functionality) and a webapp which you uploaded your spreadsheet to the website, it checked, any problems you fix and re-upload, finally enter some stuff/finalise QA and then post to a repository (all online). Personally I felt the webapp was the clunky poor cousin to the addin, however the developers have for what ever reason shelved the addin and progressed the webapp to DataUp version 2.

Internally we have picked up the original addin code and begun changing it to our needs:

The programmers here have done a lot of the first two points, and I think begun investigating linking to CKAN but early days on that (haven't had an update from them for a while and they pretty stretched on various projects). I'll bring them into the loop on this discussion - I'm sure they would be happy to share code of where they have got to and engage with you guys if you wanted to help us progress it and release (a generic version) to the CKAN community.

Aaron-M commented 9 years ago

Just a quick update, we have got the excel addin posting data to our test CKAN repository. It still needs work to fine tune it, but the first hurdle has been overcome, and not proved too difficult. Adding some smarts and fine tuning may be trickier, as well have to consider (know/confirm) things like the users authorisation - what (existing) organisations they have rights to upload datasets too vs simply depositing to a holding tank from where a person reassigns to an organisation...

Aaron-M commented 9 years ago

Update - We have made substantial improvements to the original excel addin v1 release the original developers made, and all going to schedule I should have a 'final' version by the end of Feb. Our improvements tie in with #106 and has been done with #6 in mind (aligning metadata with the DataCite requirements for DOIs).

Note: the original developers of DataUp have ceased work on it (both the excel addin which they dropped some time ago, and the web version). They are happy for us (Landcare NZ) to take over/continue development on the excel addin.