isogeo-export-xl 1.3.2

Toolbelt to export metadata from the Isogeo REST API into Microsoft Excel workbooks (.xlsx).

Isogeo - XLSX Exporter

Python package to export Isogeo metadata into Excel workshbook using the Python SDK and Openpyxl.

Usage in a nutshell

1. Install:

   pip install isogeo-export-xl
   

2. Authenticate

   # import
   from isogeo_pysdk import Isogeo
   # API client
   isogeo = Isogeo(
       auth_mode="group",
       client_id=ISOGEO_API_GROUP_CLIENT_ID,
       client_secret=ISOGEO_API_GROUP_CLIENT_SECRET,
       auto_refresh_url="{}/oauth/token".format(ISOGEO_ID_URL),
       platform=ISOGEO_PLATFORM,
   )
   
   # getting a token
   isogeo.connect()
   

3. Make a search:

   search = isogeo.search(include="all",)
   # close session
   isogeo.close()
   

4. Export:

   # import
   from isogeotoxlsx import Isogeo2xlsx
   # instanciate the final workbook
   out_workbook = Isogeo2xlsx(
       lang=isogeo.lang,
       url_base_edit=isogeo.app_url,
       url_base_view=isogeo.oc_url
   )
   # add needed worksheets
   out_workbook.set_worksheets(auto=search.tags.keys())
   
   # parse search results
   for md in map(Metadata.clean_attributes, search.results):
       out_workbook.store_metadatas(md)
   
   # save file
   out_workbook.save("./isogeo_export_to_xlsx.xlsx")