pilot-db-list

Re: [pilot-db-list] views that show only certain record?

[Craig B. <bow...@gm...>]

On 21-Mar-05, at 1:02 PM, Jerry wrote:

> I've got a DB with entries for a number of different batteries. The 
> number entries for each battery will continue to grow over time. Can I 
> setup a view for each battery that will show only the records for one 
> battery and, if so, how? If not is there another way to do this? I 
> initially started this with a separate DB for each battery but would 
> really would rather have a single DB and just view them in groups.

-Well the simplest way is to create a filter in the drop down filter 
list at the bottom.  But if you really want it to be associated with a 
view, then here's the process.
-Create the filter in the filter list (as above).  Remember also that 
filters can use a script notation:
    Example: (gt (int %34)0).  Where %34 is a date field, and that date 
is greater than 0.  This taken from a PDA database where the date field 
was a Release date, so that unreleased PDA's could be filtered out.
-Create a global script from the options menu
     This can perform sorts and invoke a specific named filter (the one 
you created above). It would look like:
      (sort 1 1)(filt FiltName)

      Essentially-  Sort by column one, ascending (0 would be 
descending), and select the filter named "FiltName".
      Test it by selecting the Global script in the list and pressing 
the "Execute" button.
-Lastly, create a View, in the Script selector when editing the View, 
select the Global script you just made.

By choosing this view, you now not only select the fields you wish to 
display and their column widths, but you can sort and filter the 
records.
If there's anything else you can do with a "Global" script, besides 
sorting and calling filters, I don't think I've seen it mentioned here.


Anyway, I use the above extensively and it's quite useful. One example 
of it's usage is a media database where you configure it for CD's, 
DVD's, VHS, or books (all using different field types as appropriate - 
aspect ratio, sound encoding, publisher, genre, First edition, on-loan, 
status, etc) just by selecting a view.  In another database I keep 
track of target ammunition.  One View displays data from Scope sighting 
correction values, another view displays data to select the best Long 
range round to use comparing FPS, energy at impact, grouping, drop, 
etc, another View for medium range target round selection, another View 
for inventory - showing full and partial boxes - calculating total 
number of rounds - price per round of each type - and totals in number 
of rounds and dollars, etc etc.

[pilot-db-list] views that show only certain record?

[Jerry <rie...@qw...>]

I've got a DB with entries for a number of different batteries. The 
number entries for each battery will continue to grow over time. Can I 
setup a view for each battery that will show only the records for one 
battery and, if so, how? If not is there another way to do this? I 
initially started this with a separate DB for each battery but would 
really would rather have a single DB and just view them in groups.

[pilot-db-list] Sorting Times and Dates

[Michael A. L. <mic...@ma...>]

Sunday, March 13, 2005, 17:51

Dear pilot-db users,

  I made a simple DB for logging events during a day. Three columns,
  Date, Time and String, using current Date and Time as defaults.

  After a few days writing things, I inserted a few entries related to
  earlier dates and times. So I had to sort them.

  But to my sad surprise, I found that sorting by Time or Date does
  NOT sort chronologically. I just sorts them all wrong.

  (Try for yourself to understand what I mean).

  How can I have Date and Time entries be sorted correctly? And since
  Date is in one column and TIme is in another one, how can I have
  them work together when sorting? Is there a way to have Date AND
  Time in the same field?

Regards,

Michael A. Lees
mic...@ma...


-------------------
Random quote:
Hold a hard drive to your ear and listen to the C.
 - Unknown

[pilot-db-list] Some weakness in Help 1.1.3

[Francis D. <fra...@sk...>]

I've just discovered Pilot-DB.
Thanks to developpers for this big piece of software.

As a beginner, I use Help and encounter some failures...
- I downloaded V1.1.3 and 'about' function shows V1.1.2 (but dated from 14 February 2005)
- In French: Menu: Options-Afficher-i gives $$HELP_CHOOSER_DISPLAY
   The same in English is OK.
- In English: The help for Field Script shows a blank page.
  In French: OK.

Thanks for considering....
Francis

[pilot-db-list] Software Bug/Comment from PalmGear.com

[<ms...@co...>]

Below are the details of a comment/bug report submitted via our website for the product DB (Pilot-DB)


Regards,

PalmGear.com 
http://www.palmgear.com
'THE Source for your Palm Powered World!'
-----------------------------------------------------
Submitter Name: Michael Stine
Submitter Email: ms...@co...
Application: DB (Pilot-DB)
Application Location: http://www.palmgear.com/index.cfm?fuseaction=software.showsoftware&prodid=2175

Software Bug/Comment:
Hey Friend,  I hope there is a way you can correct the language problem of the program.  I have attemted to download it 3 times in the past week now and for some reason it is not in english.  Let me know when you correct it as I am eager to have this database program on my Palm Pilot.  Thanks for your work on this.
Mike

[pilot-db-list] Re: Pilot-Db and desktop (Robert Thompson)

[Michael A. L. <mic...@ma...>]

Tuesday, March 1, 2005, 16:13

Regarding your message dated 01/03/05 01:15,
subject "Pilot-Db and desktop (Robert Thompson)",

pdlrlsn>> ...  However,  it does not appear on the Palm Desktop (which
pdlrlsn>> has  icons  for  the  address  book,  etc.), so that I can't
pdlrlsn>> create  a data base and then hot sync it to the PDA. How can
pdlrlsn>> I get it into the Palm Desktop?

You can't get it on the Palm Desktop, but can use another software to
create/edit your databases on the PC.

I   use   and   recommend   DB-Editor,   for   Windows,   freeware  at
www.jakewalk.de. Easy to use. Just download, install and run.

If you create a Database on DB-Editor, you can have it sent to the
Palm's Install program, and it will be installed on the Palm on the
next Hotsync.

If  you edit or create a database on the Palm, then when you perform a
Hotsync,  make  sure  that  the  System  option  is  set  to  Handheld
Overwrites Desktop (this will backup your files on the Palm to the PC,
including you Pilot DB files). Then you can open and edit the
databases on DB-Editor.

Regards,

Michael A. Lees
mic...@ma...

-------------------
Random quote:
Quick to judge, quick to anger,
slow to understand,
ignorance and prejudice and fear
walk hand in hand.
-Neil Peart


---8<---Your original message starts here (or part of it)--------

pdlrlsn> On my Palm Zire 21 PDA I have the Pilot-DB
pdlrlsn> installed.  However, it does not appear on the Palm Desktop
pdlrlsn> (which has icons for the address book, etc.), so that I can't
pdlrlsn> create a data base and then hot sync it to the PDA.  How can
pdlrlsn> I get it into the Palm Desktop?  Any help you can provide in
pdlrlsn> directing me to some source of instructions for doing this
pdlrlsn> would be much appreciated.  I should add that I am not a PC
pdlrlsn> whiz, so the simpler the better!

pdlrlsn> Robert Thompson

---8<------------Your original message ends here-----------------

[pilot-db-list] Lecture base Pilot-DB

[PECHENOT <pat...@cl...>]

Bonjour,
Existe-t'il un exemple de code =E0 int=E9grer dans une aplli Palm pour=20
ouvrir une base Pilot-DB et lire ses records ?
Merci !

[pilot-db-list] Pilot-Db and desktop

[Robert T. <rvt...@ea...>]

On my Palm Zire 21 PDA I have the Pilot-DB installed.  However, it does not appear on the Palm Desktop (which has icons for the address book, etc.), so that I can't create a data base and then hot sync it to the PDA.  How can I get it into the Palm Desktop?  Any help you can provide in directing me to some source of instructions for doing this would be much appreciated.  I should add that I am not a PC whiz, so the simpler the better!

Robert Thompson


rvt...@ea...
Youth would be an ideal state if it came later in life. -- Herbert Henry Asquith

RE: [pilot-db-list] Software Bug/Comment from PalmGear.com

[marc\.chalain <mar...@la...>]

OK It's a mistake from me. I updated the palmgear site.
Sorry.
=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net =
; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)=0A=
=0A

RE: [pilot-db-list] Software Bug/Comment from PalmGear.com

[Michael R. <ma...@ex...>]

The English version is available to download from http://pilot-db.sourceforge.net/







Michael Reich

ma...@ex...



 --- On Mon 02/21,  < ms...@co... > wrote:

From:  [mailto: ms...@co...]

To: pil...@li...

Date: Mon, 21 Feb 2005 14:59:52 -0800 (PST)

Subject: [pilot-db-list] Software Bug/Comment from PalmGear.com



Below are the details of a comment/bug report submitted via our website for the product DB (Pilot-DB)<br><br><br>Regards,<br><br>PalmGear.com <br>http://www.palmgear.com<br>'THE Source for your Palm Powered World!'<br>-----------------------------------------------------<br>Submitter Name: Michael Stine<br>Submitter Email: ms...@co...<br>Application: DB (Pilot-DB)<br>Application Location: http://www.palmgear.com/index.cfm?fuseaction=software.showsoftware&prodid=2175<br><br>Software Bug/Comment:<br>The database was not english version.  How do I get the english version?<br><br><br><br><br>-------------------------------------------------------<br>SF email is sponsored by - The IT Product Guide<br>Read honest & candid reviews on hundreds of IT Products from real users.<br>Discover which products truly live up to the hype. Start reading now.<br>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click<br>_______________________________________________<br>Pilot-db-list mailing list<br>Pil...@li...<br>https://lists.sourceforge.net/lists/listinfo/pilot-db-list<br>

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

[pilot-db-list] Software Bug/Comment from PalmGear.com

[<ms...@co...>]

Below are the details of a comment/bug report submitted via our website for the product DB (Pilot-DB)


Regards,

PalmGear.com 
http://www.palmgear.com
'THE Source for your Palm Powered World!'
-----------------------------------------------------
Submitter Name: Michael Stine
Submitter Email: ms...@co...
Application: DB (Pilot-DB)
Application Location: http://www.palmgear.com/index.cfm?fuseaction=software.showsoftware&prodid=2175

Software Bug/Comment:
The database was not english version.  How do I get the english version?

[pilot-db-list] proper way to test boolean fields in scripts

[Jurrie L. <jur...@ya...>]

So, what's "the right way" to test boolean fields in
scripts?

I find that if I only need to filter on a boolean
field that "(seq %5 1)" works just fine. However, this
does not work if I add additional conditions.

Then there's the "(!(! %5))" notation that seems to
work some of the time.

And lastly there's "(test %5 (other stuff) 0)"

scripts.txt does not show an operator to test if a
boolean is set (oposite of "!").  The document
indicates that booleans can be treated as integers,
yet
"(eq 1 %5)" doesn't appear to work.

Am I missing something?

thanks,

jurrie


		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com 
 

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

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

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 

Re:[pilot-db-list] sort form bug

[Michael R. <ma...@ex...>]

Thanks for the 1.1.3 update, Marc.  The sorting crash is fixed!





Michael Reich

ma...@ex...



 --- On Sun 01/02, marc.chalain < mar...@la... > wrote:

From: marc.chalain [mailto: mar...@la...]

To: ma...@ex...

     Cc: pil...@li...

Date: Sun,  2 Jan 2005 10:10:58 +0100

Subject: Re:[pilot-db-list] sort form bug



Yes i found the bug in the sort form that crash the<br>application. I already correct it, i will release a new<br>version (1.1.3) soon, but i need to do some others thing, before.

I think that you will have Pilot-DB 1.1.3 the next month.

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

Re: [pilot-db-list] Software Bug/Comment from PalmGear.com

[<di...@ta...>]

On Sat, Feb 12, 2005 at 07:15:18AM -0800, mpa...@ea... wrote:
> Below are the details of a comment/bug report submitted via our website for the product DB (Pilot-DB)
> 
> 
> Regards,
> 
> PalmGear.com 
> http://www.palmgear.com
> 'THE Source for your Palm Powered World!'
> -----------------------------------------------------
> Submitter Name: Matt Parker
> Submitter Email: mpa...@ea...
> Application: DB (Pilot-DB)
> Application Location: http://www.palmgear.com/index.cfm?fuseaction=software.showsoftware&prodid=2175
> 
> Software Bug/Comment:
> Hi! I love your Pilot-DB program! I just have one question, though: is it possible to sort one column and then do a subsorting on a second column? That is, can I sort the first column (say, alphabetically) and then have the database retain the first column's sorting while I sort a second column , say, numerically? Thanks!

I do not have a pilot nor an emulator installed currently, so I can't
test.
You can try using scripts. Read the file docs/scripts.txt for info.
Basically you write a script like
(sort 1 1 3 1)
I do not recall if you can run it manually from the menu, but you can
make a view run it, and so create a view which calls it and choose that
view for sorting.
-- 
Didi

Re: [pilot-db-list] Multiple Sort and Hi-Res-Display

[<di...@ta...>]

On Thu, Feb 17, 2005 at 07:18:36PM +0100, Maik St?hrenberg wrote:
> Hello,
> 
> I found Pilot-DB for Palm a very useful tool (by now I've used the 
> commercial SmartList To Go), but there are some limitations and I'd like to 
> ask you if there is anything I can do.
> 
> Sorting: Is there a possibility for multiple sorting? I use Pilot-DB for my 
> music database (originally an MS Access -- sorry for that). I can sort the 
> records by the interpret or by the title of the album or by the year of the 
> release. But the best thing would be to sort it by the interpret and 
> afterwards by the release (or alphabetically). I've read the manual but 
> there is nothing said about it.

I do not have a pilot nor an emulator installed currently, so I can't
test.
You can try using scripts. Read the file docs/scripts.txt for info.
Basically you write a script like
(sort 1 1 3 1)
I do not recall if you can run it manually from the menu, but you can
make a view run it, and so create a view which calls it and choose that
view for sorting.

I have no idea about your other problem, at least currently.
-- 
Didi

[pilot-db-list] 1.1.3

[<bow...@gm...>]

I noticed that 1.1.3 also seems to have broken DPad navigation an the ability to scroll left and right in the record list view via the Dpad on a Tungsten.

Plus it seems to ignore my previous color scheme.

Reverting to 1.1.2 reverts all of the above back to normal.

More changes than just the sorting or did I miss something.

Re: [pilot-db-list] Software Bug/Comment from PalmGear.com

[Craig B. <bow...@gm...>]

The .exe's are no fun for direct Tungsten C or Mac downloads either.

On 18-Feb-05, at 3:39 PM, dw...@co... wrote:

> Below are the details of a comment/bug report submitted via our  
> website for the product DB (Pilot-DB)
>
>
> Regards,
>
> PalmGear.com
> http://www.palmgear.com
> 'THE Source for your Palm Powered World!'
> -----------------------------------------------------
> Submitter Name: Dale Lehmann
> Submitter Email: dw...@co...
> Application: DB (Pilot-DB)
> Application Location:  
> http://www.palmgear.com/index.cfm? 
> fuseaction=software.showsoftware&prodid=2175
>
> Software Bug/Comment:
> I downloaded the ZIP file after noticing your 14 February update, and  
> I found that I had the French installer (pilotdb1.1.3fr.exe).  I had  
> to go out to SourceForge to get the English installer.  Could you fix  
> this?

[pilot-db-list] Software Bug/Comment from PalmGear.com

[<dw...@co...>]

Below are the details of a comment/bug report submitted via our website for the product DB (Pilot-DB)


Regards,

PalmGear.com 
http://www.palmgear.com
'THE Source for your Palm Powered World!'
-----------------------------------------------------
Submitter Name: Dale Lehmann
Submitter Email: dw...@co...
Application: DB (Pilot-DB)
Application Location: http://www.palmgear.com/index.cfm?fuseaction=software.showsoftware&prodid=2175

Software Bug/Comment:
I downloaded the ZIP file after noticing your 14 February update, and I found that I had the French installer (pilotdb1.1.3fr.exe).  I had to go out to SourceForge to get the English installer.  Could you fix this?

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

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

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 

[pilot-db-list] Multiple Sort and Hi-Res-Display

[Maik <Mai...@ge...>]

Hello,

I found Pilot-DB for Palm a very useful tool (by now I've used the 
commercial SmartList To Go), but there are some limitations and I'd like to 
ask you if there is anything I can do.

Sorting: Is there a possibility for multiple sorting? I use Pilot-DB for my 
music database (originally an MS Access -- sorry for that). I can sort the 
records by the interpret or by the title of the album or by the year of the 
release. But the best thing would be to sort it by the interpret and 
afterwards by the release (or alphabetically). I've read the manual but 
there is nothing said about it.

Display: Using Pilot-DB on a Tungsten T3 with its 320*320 (320*480) 
resolution, it's a pity that there are only four font sizes -- with the 
smallest displaying 16 records in line.

Just a minor glitch: the German overlay still displays the version number 
1.1.2 (but the correct date Feb 14, 2005) in the about dialog.

But to be honest: I really appreciate your program: the commercial 
SmartList To Go doesn't even support more than 10.000 records in a view -- 
Pilot-DB has no problem displaying nearly 11.000 records and is very quick 
and responsive indeed.

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

[marc\.chalain <mar...@la...>]

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?
> 
> 
> =3D=3D=3D=3D=3D
> 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=3D6595&alloc_id=3D14396&op=3Dclick
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.laposte.ne=
t ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)=
=0A=0A

[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 

[pilot-db-list] sort bug

[Seth R. <ra...@ma...>]

Hello All,

Great piece of software!!

I would like to know what the status of the sort bug is.  Are there any work
arounds or patches?  Also, what is the status of cast to float for scripts?

If neither of these things are yet done, I would be happy to help get them into
the source, if someone could help orient me a little bit.

Thank you!

-Seth

[pilot-db-list] Reinstall after hard reset?

[Cuyler G. <ori...@ya...>]

My Palm T/e  locked up and I was forced to do a hard reset. All my databases were secure in the backup folder. TheColWidths.ini  file was initiated on the next sync.

But not all the database file settings were included in the ColWidths.ini file.  Nor my categories.

Are there other files that may contain additional column width settings and another file for my database categories?

I can rebuild of course, but would be nice to have the previous since I've already done the 'leg work' once.

Thanks !

		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'