[pilot-db-list] Troubles with exporting data to CSV

[darin s. <dar...@ya...>]

After a year or two of using DB, I find that I need to get one of my
databases off of it and into a spreadsheet. I am running db version
1.1.0 on a Hanspring Neo. I normally use Debian linux (unstable), but I
also have a Windows XP laptop.

The first step was to copy the relevant pdb file out of my backup
directory and to a conveniant working area.

The second step was too find a way to convert this file to CSV, which I
can import into any reasonable spreadsheet. 

My first try was pdb2csv, because this is the first utility that I
found. The only version that I could locate was a windows version, so I
fired up my laptop and:
pdb2csv.exe travelog.pdb travelog.csv travellog.inf
travellog.pdb: unsupported field type

It seems that the only supported field types are strings, integers and
booleans. I use date types, so that seems like a dead end.


My second try was jpilot-db, which I think that I would prefer in the
log run. I can't run that at all:
me@wks:~/palm/pilot-db$ java -jar jpilot-db.jar

Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/commons/cli/ParseException

I presume that my classpath is wrong, but I'm not sure how to set it.


My third try was on my windows machine, where I installed db-editor.
db-editor will run, but when I try to open one of my databases, I get:

Your database could not be opened, but it is often possible to make
your database readable again. (Procedure for rebuilding db given here.)


When I try to follow the db rebuild procedure on my PDA, I get:

An error was encountered during the rebuild. No changes have been made.

I get this same error on any database I try on my PDA. I know that this
was do-able at some time in the past, because I remember tinkering with
it.

I constructed a small, demo database using db-editor and installed it
on the Neo. I can open the database and the single record is there and
it is editable. If I try to rebuild the database, I get the error
message.

So, what do I do now? How do I get data off of my Neo and into a
spreadsheet?


=====
dar...@ya...  
Database Development and Administration 

"I am always willing to run some hazard of being tedious, in order to be sure that I am perspicuous" Adam Smith


		
__________________________________ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com