search

geosolutions-it / geobatch

Open Source GeoSpatial Processing Simplified
GNU General Public License v3.0
22 stars 19 forks source link

ds2ds action - support of other datastores #176

Open eblondel opened 11 years ago

eblondel commented 11 years ago

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

eblondel commented 11 years ago

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

eblondel commented 11 years ago

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 commented 11 years ago

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 commented 10 years ago

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 commented 10 years ago

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: https://github.com/openfigis/figis-geobatch/issues/9

Hope this clarifies

sanguinela commented 10 years ago

Thank you very much for your response.