Sqlite can import CSVs and probably do all the manipulation and
exporting too.
See http://www.sqlite.org/
Greg
On 11-03-22 12:01 AM, Gustin Johnson wrote:
There are some c and perl libraries so you may need to roll your own.
The other option is to try and get Foxpro running under wine. I have
some friends who work at a company that still uses that format and has
a lot of in house Linux experience. I'll get back you if I find
anything else.
On Mon, Mar 21, 2011 at 11:21 PM, Shawn<sgro...@open2space.com> wrote:
So I've found all sorts of tools and tips that let me connect to a DBF file
(a table file) and convert that data to another format (csv, postgres,
mysql, etc.). That's great, that's part one of my project. But, how do I
CREATE a DBF file from Linux? Preferably from a command prompt.
The process is like this:
1. Import DBF file into a format we can work with, like say postgres.
2. Manipulate the data, add some columns, etc.
3. Dump the updated data back out to a new DBF file for processing by a
third party app.
If it helps, I'm dealing with GIS shape files and need to add some
columns/data.
I need an automated script to process hundreds of files in one goe. Some of
those files exceed the row limit of Open Office/Excel.
I've searched Google and found tons on moving the data out of DBF, but
nothing on going back into it. I'm ok even with outputting to CSV first and
then to DBF, but I'm having troubles finding that even.
Any tips? Thanks in advance.
Shawn
_______________________________________________
clug-talk mailing list
clug-talk@clug.ca
http://clug.ca/mailman/listinfo/clug-talk_clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
_______________________________________________
clug-talk mailing list
clug-talk@clug.ca
http://clug.ca/mailman/listinfo/clug-talk_clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
_______________________________________________
clug-talk mailing list
clug-talk@clug.ca
http://clug.ca/mailman/listinfo/clug-talk_clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
