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

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

My other problem, namely not being able to rebuild databases on my
palm, seems to be due to the existence of the DBOStmp database. 

Is there any neat trick to deleting this database, or do I have to use
a utility like FileZ, after copying FileZ to my PDA?

--- "marc.chalain" <mar...@la...> wrote:

> The current PDBTools (0.3.6)  must be build on Linux box.
> There  is no trouble to do it, you just need the linux
> development tools (gcc binutils g++) and to run "./configure;
> make; make install"
> 
> This version supports all field type for the DB3 format (the
> default format of Pilot-DB) except for the calculated field
> type which are partialy supported (and this explains why the
> version number begins by 0)
> 
> On Windows if you installed the last installation file of
> pilot-db, you can choice to install the last PDBTools.
> 
> Salut,
> Marc Chalain.
> 
> > 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
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from
> real users.
> > Discover which products truly live up to the hype. Start
> reading now.
> > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > Pilot-db-list mailing list
> > Pil...@li...
> > https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> > 
> 
> Accédez au courrier électronique de La Poste : www.laposte.net ; 
> 3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn)
> 
> 
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

=====
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 