Hi Sam, glad to hear that.
If possible, I would prefer to talk about adding small features to your site, that would enable continuous data flow into transformap. Are you able to add features to the transitionnetwork website yourself ?
To clarify: I would prefer to write scripts , adapters or similar to transfer data automatically so work done once can be repeated. Doing imports by hand could be nice to have some first showcases, but it creates more and more data, for which we will find time to care about.
In principle, we could grab data from your initiatives description pages (for example https://www.transitionnetwork.org/initiatives/greener-hawick-scio).
To keep data updated, we need a feed of changes.
So, if you could add a page to your website, which lists initiatives in some easy to parse data format, sorted by last change, this would be a big step forward.
An other optional step would be to publish data in a machine friendly way.
There are two roads, which can be followed:
a) publish data on a separate page: basically you would take a copy of your drupal template, which creates current initiative page, and change it to only provide data, either in json format or in some easy parsable html form. This page could be linked in the meta section of the human friendly page (which would open the data for everyone, not only transformap) or could be calculated from the main url. For example https://www.transitionnetwork.org/initiatives/greener-hawick-scio.json or https://www.transitionnetwork.org/initiatives/greener-hawick-scio/data or https://www.transitionnetwork.org/export/initiatives/greener-hawick-scio,
b) make it easier to get the data out of the current page by adding machine friendly css styles (the microformat way).