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

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

OK, here is the present state of affairs:

I have resolved the "can't rebuild database" problem by removing the
DBOStmp database using FileZ. 

I have resolved my problem of not being able to run jpilot-db by
reading the readme file and using a proper command line. I can open my
file with jpilot-db, see my data and edit it. I can't export anything.
Under the Export menu selection, the CSV option is greyed out and
attempting to export to XML results in an error similar to "can't open
the XML file". I don't know why it's trying to open the XML file, since
it hasn't exported it yet. After looking on sourceforge, I find that
someone else has the same problem. I also find that jpilot-db doesn't
seem to be supported anymore. the sourceforge site is certainly lacking
in activity.

I still can't run pdb2csv, due to the following error:
pdb2csv: error while loading shared libraries: libpdbtools.so: cannot
open shared object file: No such file or directory

I presume that there is something wrong with the make file.

-- darin

--- "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!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 