Improve columns management in Excel

Isogeo - XLSX Exporter

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

Usage in a nutshell

Install:
```
pip install isogeo-export-xl
```

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()

Make a search:

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

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")

	# add modification date (not datetime) for later stats, only if different from the creation date
	if md._modified != md._created:
	self.stats.li_dates_md_modified.append(
	utils.hlpr_datetimes(md._modified).date()
	)

isogeo / export-xlsx-py Goto Github PK

export-xlsx-py's Introduction

Isogeo - XLSX Exporter

Usage in a nutshell

export-xlsx-py's People

Contributors

Watchers

export-xlsx-py's Issues

Constat

Diagnostic

Idée

Besoins

Solution

Difficultés

Métadonnées à récupérer

Reproduire

Constat

Recommend Projects

Recommend Topics

Recommend Org