0

I'm in the process of attempting the set up of a GeoNetwork instance and have been given an xls with metadata for 1200+ maps.

Has anyone seen docs for a good workflow for batch import? Maybe xls templates which match the GeoNetwork ISO19139 templates? Or a postgres DB template I could copy them into which I could then connect to GeoNetwork?

I tried to export the GeoNetwork ISO19139 templates as xml and bring them into excel but the formatting gets lost and their not usable.

Ideas?

  • why do you need to convert the XML to Excel? You can import ISO 19139 XML records using the API (geonetwork-opensource.org/manuals/trunk/eng/users/api/…), for example POST to /geonetwork/srv/api/0.1/records (check docs at vanilla.geocat.net/geonetwork/doc/api/#/records/insertFile) – juanluisrp Jun 21 at 16:03
  • Sorry I wasn't clear, I have an excel spreadsheet with 1200+ maps records entered, with columns for title, abstract, publication date etc. I want to get these into XML so I can import them but I'm not clear on the best workflow to do this. – Edward Lewis Jun 25 at 9:28
  • 1
    Then you would need to generate XML files from that Excel document and import those new files into GN. For the transformation you could program it yourself or use some ETL tool like Talend (talend.com/products/talend-open-studio) to read the Excel, apply the transformation and maybe push the result to GeoNetwork. – juanluisrp Jun 25 at 13:48
  • @juanluisrp ok, will give that a go, thank you. – Edward Lewis Jun 27 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.