CSV support? about ogr2ogr HOT 11 CLOSED

CSV is supported through OGR_VRT, do you have a sample code snippet on how you are using this in code?

from ogr2ogr.

Yes, my code looks like this:

let ogr = await ogr2ogr(path)
	.format('PostgreSQL')
	.destination(databaseHost)
	.options(['-nlt', 'PROMOTE_TO_MULTI', '-nln', 'schema.tableName, '-a_srs', 'EPSG:4326', '-oo', 'X_POSSIBLE_NAMES="' + long + '"', '-oo', 'Y_POSSIBLE_NAMES="' + lat + '"', '-overwrite',]).promise();

where path is the path to the CSV file and databaseHost is my database credentials

from ogr2ogr.

specifying a destination can sometimes cause issues but, out of curiosity, does this work:

let ogr = await ogr2ogr(fs.createReadStream(path), 'csv')
	.format('PostgreSQL')
	.destination(databaseHost)
	.options(['-nlt', 'PROMOTE_TO_MULTI', '-nln', 'schema.tableName, '-a_srs', 'EPSG:4326', '-oo', 'X_POSSIBLE_NAMES="' + long + '"', '-oo', 'Y_POSSIBLE_NAMES="' + lat + '"', '-overwrite',]).promise();

from ogr2ogr.

Hmmm still didn't work for me.. I still get the same error about the drivers

from ogr2ogr.

So @wavded I tried a different file and it seems like the module is successful but it didn't send over the data correctly to my destination... When I look at the table in my postgres, it's empty. Is there something wrong with csv and the destination?

from ogr2ogr.

Gosh, I don't have a great way to test this as I don't have a Postgres environment readily available. Usually I try to mimic the command using the ogr2ogr command line tool itself to see. I don't see anything API wise that is amiss with what you've shared.

from ogr2ogr.

It seems to run the ogr2ogr command successfully but it isn’t writing the data in the csv correctly..

from ogr2ogr.

The name of the table in my postgres is correct, but when I try to view all the data for that table, all I see is a ogc_fid column with nothing in it

from ogr2ogr.

I also noticed that the same file writes to my postgres locally but when I try to do it on my lambda function, it doesn't work properly. The data isn't in the table

from ogr2ogr.

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

from ogr2ogr.

This issue was closed because it has been stalled for 5 days with no activity.

from ogr2ogr.