pgdbf icon indicating copy to clipboard operation
pgdbf copied to clipboard

Possibility to export to CSV?

Open maxfi opened this issue 6 years ago • 2 comments

pgdbf is so fast! I would love to use it to convert Visual FoxPro DBF files to CSV. Any ideas? Thanks in advance!

maxfi avatar Apr 06 '18 11:04 maxfi

Have you tried importing to PostgreSQL and exporting to CSV? Is that fast enough?

TravisDart avatar Jul 25 '18 22:07 TravisDart

@TravisDart I guess I instinctively ruled that out as an option due to the extra overhead. However, thinking about it more now, the extra overhead might actually be worth it for the additional benefits of exporting the data as JSON as well and the ability to query the data.

I'm thinking I might be able to create a docker image that exposes a REST API that consumes a DBF and associated files (perhaps as a tarball) as well as some options for export and returns the relevant data... Will need to brainstorm this further...

Otherwise it would be super awesome if pgdbf was able to export to CSV/JSON directly. Unfortunately I've never written any C before but I'll have a crack at it.

maxfi avatar Jul 26 '18 22:07 maxfi