ds2ds action - support of other datastores

[eblondel]

It would be good if other datastores, e.g. jdbc-oracle, could be added by default to the build of gb-action-ds2ds.

[eblondel]

The support of Oracle NG datastore in ds2dsAction has been added with f885acb

[eblondel]

Would it be possible to add support for CSV or EXCEL datastore to the ds2ds module? I'm currently working on an action that extends DsBaseAction and should have a CSV,or possibly XLS, as event input file.

It seems gt-csv is supported by GeoTools 8-SNAPSHOT, but not gt-excel.

[eblondel]

I had a look, it seems gt-excel is not yet available in the geotools build. gt-csv is, but actually is not very mature, and apparently more dedicated to ContentDataStore tutorial. I'll probably use directly this module directly in our project, and forget it for now for ds2ds.

[sanguinela]

sorry eblondel, I know task is closed. I've read this your conversation but I not understood if csv import is supported or isn't supported? I would import a csv to db postgres by geobatch-ds2sd. It is an actions permitted?

[eblondel]

AFAIK, it is not supported by geobatch DS2DS, Geosolutions might update on this. The gt-csv is very basic and if i remember, it's only tailored to geometry Point data collection (x/y), not to other kind of geometry types, and does not manage geometryless inputs (e.g. statistical table).

For these reasons, i didn't investigate how to enrich DS2DS with CSV inputs, and used custom solution for our projects needs as indicated here: openfigis/figis-geobatch#9

Hope this clarifies

[sanguinela]

Thank you very much for your response.