Hi Shawn, It's been alot of years since I worked with DBFs (Clipper mostly). If you get stuck I can probably find/re-write/adapt code for this purpose. My memory says the only awkward part were "Memo" fields the others were straight forward fixed length fields.
DBFs were defined in the days before things like constraints and referential integrity so a much simpler problem. Do you need to create indexes on the new files, or do you just need the files themselves? Cheers, J.J. On Mon, 2011-03-21 at 23:21 -0600, Shawn 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
