pilot-db-list

[pilot-db-list] pilot-db 1.1 and ifo files

[Daniel L. <spr...@PA...>]

All:

Is there any documentation online about how to pre-program a global 
script (and attach it to a view) via the .ifo file mechanism?

Also, the Front page of this project claims that version 1.1 is 
available, but all I can see on the download page is 1.1 beta2 from 
January 2003.  Should I be looking somewhere else for the 1.1 stable 
release, or is that not out yet?

Thanks,
Dan
-- 
Daniel Lyddy
California CCIT
2105 Bancroft Way, Third Floor
University of California
Berkeley, CA 94720-3830

tel: +1 (510) 642-5667
fax: +1 (510) 642-0910
email: spr...@pa...
url: http://highwaylab.berkeley.edu/~sprocket

Shannon's Law: All learning derives from surprises.
Shannon's Corollary: How much you learn depends on how much of a 
surprise it is.

Re: [pilot-db-list] problems while trying to compile pilot-db-tools

[Mike M. <mw...@mi...>]

In <134...@ww...>, kli...@gm... typed:
> Hi,
> 
> I got problems while trying to compile pilot-db-tools
> 
> - used system, software: -
>  Linux 2.4.20 
>  gcc-3.2.3 based
>  glibc-2.3.2.
>  XFree 4.30 (hardware dri/drm enabled and working)
>  KDE 3.1.1a with IceWM 2.7

The pilot-db-tools build for Unix systems has been broken for a
while. Try going backwards through the distributions until you get one
that builds. That's what I wound up doing.

> After this I have no more ideas anymore. Please help me, since I need
> this tools to recover some data after a crash.

You might also try <URL: http://jpilot-db.sf.net/ >. It includes
export and import tools for pilot-db. There are other tools available
as well, depending on which way you're trying to go.

	<mike
-- 
Mike Meyer <mw...@mi...>		http://www.mired.org/consulting.html
Independent Network/Unix/Perforce consultant, email for more information.

[pilot-db-list] problems while trying to compile pilot-db-tools

[<kli...@gm...>]

Hi,

I got problems while trying to compile pilot-db-tools

- used system, software: -
 Linux 2.4.20 
 gcc-3.2.3 based
 glibc-2.3.2.
 XFree 4.30 (hardware dri/drm enabled and working)
 KDE 3.1.1a with IceWM 2.7
  
- used system, hardware: -
 ATI Radeon 7500 AGP made by Sapphire
 Athlon XP 2400+
 EPoX 8K5A3+
 256 MB DDR RAM

What I got with pilot-db-tools 0.3.4 is:

I copnfigured with:
./configure --prefix=/usr --enable-shared --disable-static
which runs without any problems, warnings or errors.
After 'make' I got:
[palm-db-tools/] :make
make  all-recursive
make[1]: Entering directory `/tmp/palm-db-tools-0_3_4/palm-db-tools'
Making all in libsupport
make[2]: Entering directory
`/tmp/palm-db-tools-0_3_4/palm-db-tools/libsupport'
/bin/sh ../libtool --mode=compile g++ -DHAVE_CONFIG_H -I. -I. -I.. -I..   
-ansi -pedantic -O3 -march=athlon-xp -mcpu=athlon-xp -mfpmath=sse -Wall
-Werror -c clp.cpp
g++ -DHAVE_CONFIG_H -I. -I. -I.. -I.. -ansi -pedantic -O3 -march=athlon-xp
-mcpu=athlon-xp -mfpmath=sse -Wall -Werror -Wp,-MD,.deps/clp.pp -c clp.cpp 
-fPIC -DPIC -o clp.o
In file included from clp.cpp:1:
clp.h:21: looser throw specifier for `virtual 
   CLP::option_error::~option_error()'
clp.h:16:   overriding `virtual CLP::parse_error::~parse_error() throw ()'
clp.h:21: looser throw specifier for `virtual 
   CLP::option_error::~option_error()'
clp.h:16:   overriding `virtual CLP::parse_error::~parse_error() throw ()'
clp.h:21: looser throw specifier for `virtual 
   CLP::option_error::~option_error()'
clp.h:16:   overriding `virtual CLP::parse_error::~parse_error() throw ()'
make[2]: *** [clp.lo] Error 1
make[2]: Leaving directory
`/tmp/palm-db-tools-0_3_4/palm-db-tools/libsupport'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/palm-db-tools-0_3_4/palm-db-tools'
make: *** [all-recursive-am] Error 2

---

Trying to configure (after making ./configure executable...)
palm-db-tools-0.3.5 with the same options I alway get:


: bad interpreter: No such file or directory


first line of configure is 

      #! /bin/sh

ls -l /bin/sh gives me:
lrwxrwxrwx    1 root     root            4 Apr 19 09:44 /bin/sh -> bash

A 'bash ./configure' gives me:

[palm-db-tools/] :bash ./configure
: command not found: 
'/configure: line 14: syntax error near unexpected token `in
'/configure: line 14: `  case X$UNAME in

After makeing ./autogen.sh executable I executed that and got:
[palm-db-tools/] :./autogen.sh 
: bad interpreter: No such file or directory

Executing ./autogen.sh with

bash ./autogen.sh

gives me
[palm-db-tools/] :bash ./autogen.sh 
: command not found3: 
: command not found6: 
: command not found8: 
: command not found10: 
: command not found12: echo
**Error**: You must have `autoconf' installed to compile.
Download the appropriate package for your distribution,
or get the source tarball at ftp://ftp.gnu.org/pub/gnu/
: command not found17: }
: command not found18: 
/configure.in: No such file or directory
: command not found21: echo
**Error**: You must have `libtool' installed to compile.
Get ftp://ftp.gnu.org/pub/gnu/libtool-1.2d.tar.gz
(or a newer version if it is available)
: command not found26: }
: command not found27: }
: command not found28: 
: command not found39: 
: command not found50: 
: command not found52: echo
**Error**: You must have `automake' installed to compile.
Get ftp://ftp.gnu.org/pub/gnu/automake-1.3.tar.gz
(or a newer version if it is available)
: command not found58: }
: command not found59: 
: command not found60: 
: command not found63: echo
**Error**: Missing `aclocal'.  The version of `automake'
installed doesn't appear recent enough.
Get ftp://ftp.gnu.org/pub/gnu/automake-1.3.tar.gz
(or a newer version if it is available)
: command not found69: }
: command not found70: 
'/autogen.sh: line 82: syntax error near unexpected token `in
'/autogen.sh: line 82: `case $CC in


After this I have no more ideas anymore. Please help me, since I need
this tools to recover some data after a crash.

Kind regards,
Meino Cramer (mccramer@s.netic.de)

now i'm curious (Re: [pilot-db-list] calculations with linked fields as arguments?)

[julio s. <jm...@ma...>]

Hi!
Scott Wallace wrote:

>	(+ (int %1) 5)
>  
>
yep! it works, thanks.

>	the problem is that linked fields are viewed as strings, not their 
>original data type, so you need to somehow convert them back to their 
>original type.  I'd like to fix this problem at its root, but it would 
>require a new database format, and it would be pretty hard to make it 
>robust.
>
Now I' m curious.  Your explanation and solution seems good to me. I 
only desire to solve all software problems with that kind of rational 
and no adhoc solution! So - are there a real *problem*?
Sure, user have some work to do (writing 5 more characters :-) but now I 
believe that a good glance on doc files (blushing) would be enough. BTW 
-  I hope that such elucidation is already on docs because I believe 
that my attempt with linked fields is trivial... and lots of users 
appreciate documentation-for-dumbs (blushing again)
Thanks again,
Julio

Re: [pilot-db-list] calculations with linked fields as arguments?

[Scott W. <swa...@my...>]

On Fri, 25 Apr 2003, julio sameiro wrote:

> Hi!
> 
> in a dbase, db2, like this:
> 
> field0: link to a key on db1
> field1: linked (it shows the result of a calculated field on db1)
> field2: (+ %1 5) <-- when i try something like this an error msg occurs 
> - "bad argument for +"



	Yes, in general, this won't work.  If the linked field is an 
integer, then you might be able to do something like:

	(+ (int %1) 5)

	the problem is that linked fields are viewed as strings, not their 
original data type, so you need to somehow convert them back to their 
original type.  I'd like to fix this problem at its root, but it would 
require a new database format, and it would be pretty hard to make it 
robust.

	-Scott

[pilot-db-list] calculations with linked fields as arguments?

[julio s. <jm...@ma...>]

Hi!

in a dbase, db2, like this:

field0: link to a key on db1
field1: linked (it shows the result of a calculated field on db1)
field2: (+ %1 5) <-- when i try something like this an error msg occurs 
- "bad argument for +"

So: are there any way to make calculations with linked fields as arguments?
something like (/ (+ %LinkedField1 %LinkedField2) 2)?

thanks a lot,

Julio

[pilot-db-list] scripts with linked fields

[Julio S. <jul...@ma...>]

Hi!

in a dbase, db2, like this:

field0: link to a key on db1
field1: linked (it shows the result of a calculated field on db1)
field2: (+ %1 5) <-- when i try something like this an error msg occurs 
- "bad argument for +"

So: are there any way to make calculations with linked fields as arguments?
something like (/ (+ %LinkedField1 %LinkedField2) 2)?

thanks a lot,

Julio

[pilot-db-list] Re: *** QUESTION *** (fwd)

[<Hei...@t-...>]

Hello,=20

how can I delete a database from Pilot-DB v. 1.0.3 ???=20

Thank you for your answer !!!=20

Bye Heike Haag

[pilot-db-list] conversion of PDB files to CSV

[Gulla, B. A <bre...@ed...>]

I have downlaoded the db-tools and am trying to convert a PDB file to CSV.
I keep getting and error saying that there is a currupt record in the db.  I
have changed the data in the db to just ascii and then to just integer.  No
matter what I change my data to I still receive the same error.  Does anyone
have any suggestions?

Thanks,

Brent 

Re: [pilot-db-list] 2 questions

[Mike M. <mw...@mi...>]

In <200...@ac...>, Emmanuel Seyman <se...@ac...> typed:
> Mike Meyer has a python script that synchs Pilot-DB bases to Postgresql
> (which can easily be adapted to other DBs).

That includes a dbfile module that exposes pilot-db files as Python
objects. I've created a dbfile viewer based on the same module, but
haven't had time to work on it.

	<mike
-- 
Mike Meyer <mw...@mi...>		http://www.mired.org/consulting.html
Independent Network/Unix/Perforce consultant, email for more information.

Re: [pilot-db-list] 2 questions

[G S O. <gs...@em...>]

On Tue, 22 Apr 2003 08:04:09 -0600
"Trever M. Shick" <ts...@se...> wrote:

> There's a whole Java library that lets you manipulate Pilot-DBs, and a
> GUI.
> 
> http://jpilot-db.sourceforge.net
> 

Could pilot-db data be accessed in waba (e.g. http://www.superwaba.com)
using these libraries?

Re: [pilot-db-list] 2 questions

[G S O. <gs...@em...>]

On Tue, 22 Apr 2003 10:44:56 +0200
Emmanuel Seyman <se...@ac...> wrote:

> On Sat, Apr 19, 2003 at 01:15:16PM +0100, GSO wrote:
.....
> > 2) What language would you recommend to develop with Pilot-DB
> > (interface libs etc)
.....
> 
> Anybody else?

In terms of palm based development,

Pocket Toolbox: A PocketC Palm native library
http://www.geocities.com/retro_01775/PToolboxLib.htm
Includes a Pilot-DB database interface (not sure if the source is open
or not).

Would it take much work to create a palm library that could be called from onboardc quartus forth etc (probably the tidiest solution)?

GSO

Re: [pilot-db-list] 2 questions

[Trever M. S. <ts...@se...>]

There's a whole Java library that lets you manipulate Pilot-DBs, and a GUI.

http://jpilot-db.sourceforge.net

if you need help using the libraries, don't hesitate to ask.




----- Original Message -----
From: "Emmanuel Seyman" <se...@ac...>
To: <pil...@li...>
Sent: Tuesday, April 22, 2003 2:44 AM
Subject: Re: [pilot-db-list] 2 questions


> On Sat, Apr 19, 2003 at 01:15:16PM +0100, GSO wrote:
> >
> > 1) Is there anyway to merge two databases?
>
> I'ld export both bases to csv files and merge those, then create a new
> Pilot-DB file from that.
>
> > 2) What language would you recommend to develop with Pilot-DB (interface
libs etc)
>
> The pdb2csv and csv2pdb scripts are on the Pilot-DB website.
> Uwe Kloss has made an add-on to the Perl p5-Palm module which is coming
> along very nicely.
> Mike Meyer has a python script that synchs Pilot-DB bases to Postgresql
> (which can easily be adapted to other DBs).
> I've got a script that converts bases to sql format.
> DB-Editor is a Windows app that lets you edit Pilot-DB databases.
>
> Anybody else?
>
> Emmanuel
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>

Re: [pilot-db-list] Yet another perl module

[<Uwe...@t-...>]

Emmanuel Seyman wrote:

>Just one minor nitpick:
>
>You don't need to put the DB.pm file in the same directory as the p5-Palm files
>but in a $inc/Palm directory (where $inc is any entry in @INC). If you're not
>root on the machine you're using, you can simply put it in ./Palm and run your
>script.
>
Good point!
I'll update the docs.
Thanks!

As I'm on that subject (docs).

To the developers (Mark,Scott,...):
In the "format.txt" file it says, "char*" where strings are part of the 
fields.
In fact this is "char[ ] (NUL-terminated)".

My first attempt to coding decoding (before using a hex editor) was to 
really
expect some kind of pointer there.

After wondering what a pointer might be in a file and using a hex editor
it soon became clear that "char *" is most probably the structure in memory.

See you,
    Uwe

[pilot-db-list] MPC 1.8.2

[Jan E. <li...@mo...>]

A new version of MPC has been released
<http://www.mootjelitt.com/mpc.html>. It fixes two bugs that would crash
MPC when trying to translate an empty database or Pilot-DB databses that
were set up in a certain way.

                        jem
--=20
Jan Erik Mostr=F6m   je...@mo...    www.mostrom.pp.se

[pilot-db-list] Search form for pilot-db

[Hans Z. <hz...@gm...>]

Hi,

as a pilot-db newbie I love pilot-db's open sourced approach
doing databases on the Palm platform. Currently I'm using pilot-db on a daily
basis (price database, about 700 articles). What pilot-db is IMHO missing
is to search using a form entry. This form would be identical to that
which you use when you input new data sets.

The current search is ok for simple searches. But if you want to do more
complex sequential searches you often get screwed by chosing the wrong
search fields if you are in a hurry.

In addition that new search form might present two check boxes at the
right side of each line to switch on 'whole word' (w)
and 'case sensitive search' (c).

Enjoy!
--Hans

-- 
Blind support for Linux           - http://www.leb.net/blinux/

Re: [pilot-db-list] 2 questions

[Emmanuel S. <se...@ac...>]

On Sat, Apr 19, 2003 at 01:15:16PM +0100, GSO wrote:
> 
> 1) Is there anyway to merge two databases?

I'ld export both bases to csv files and merge those, then create a new
Pilot-DB file from that.

> 2) What language would you recommend to develop with Pilot-DB (interface libs etc)

The pdb2csv and csv2pdb scripts are on the Pilot-DB website.
Uwe Kloss has made an add-on to the Perl p5-Palm module which is coming
along very nicely.
Mike Meyer has a python script that synchs Pilot-DB bases to Postgresql
(which can easily be adapted to other DBs).
I've got a script that converts bases to sql format.
DB-Editor is a Windows app that lets you edit Pilot-DB databases.

Anybody else?

Emmanuel

Re: [pilot-db-list] Yet another perl module

[<Uwe...@t-...>]

Hi there,

after some more cleanup there's a new version of the Pilot-DB add-on to 
the P5-Palm package.
You can download it from:
    http://home.t-online.de/home/Uwe.Kloss/DB.pm

Available from the same place is a PerlTk database viewer.
    http://home.t-online.de/home/Uwe.Kloss/PilotDBViewer.pl

Any reports on bugs (or no bugs ;-) are welcome.
Especially for other versions of Perl and Pilot-DB.
It is tested on Perl 5.8.0, P5-Palm 1.3.0 and with Pilot-DB 1.0.3.

As the add-on as well as the viewer are file oriented, support for
field types that access multiple databases is limited/not implemented.

Nevertheless if you don't mess around with the contents of those
fields and just write them back to a file this schould work.

Please consider both als alpha quality code and work in progress.
Don't forget to make backup copies of your precious data before
overwriting them.

See you,
    Uwe

RE: [pilot-db-list] Error when attempting to open a DB

[hermann g. <hgr...@gm...>]

hi rick ;-)

this is the wrong list to ask that question, the maintainer of DB Editor ist
Raphael Fetzer (http://www.jakewalk.de) the maintainers of this list do
nothing about DB Editor.

i never had problems when opening a database, tell the circumstances more
exactly ...

so long, ciao hermann

> -----Original Message-----
> From: pil...@li...
> [mailto:pil...@li...]On Behalf Of Rick
> Ankrum
> Sent: Sunday, April 20, 2003 5:10 AM
> To: pil...@li...
> Subject: [pilot-db-list] Error when attempting to open a DB
>
>
> With both the 0.31 and 0.40 DBEditor program I get an error
> message when I
> try to open the DB on my desktop. Any ideas?
>
> <o><><><><><><><><><><><o><><><><><><><o><><><><><><><><><><><><><o>
> http://www.texbiker.net -- Texas Bicycling Information Central.
> <o><><><><><><><><><><><o><><><><><><><o><><><><><><><><><><><><><o>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>

[pilot-db-list] Error when attempting to open a DB

[Rick A. <tex...@te...>]

With both the 0.31 and 0.40 DBEditor program I get an error message when I 
try to open the DB on my desktop. Any ideas?

<o><><><><><><><><><><><o><><><><><><><o><><><><><><><><><><><><><o>
http://www.texbiker.net -- Texas Bicycling Information Central.
<o><><><><><><><><><><><o><><><><><><><o><><><><><><><><><><><><><o> 

[pilot-db-list] 2 questions

[GSO <gs...@ya...>]

A few quick questiosn if I may

1) Is there anyway to merge two databases?

2) What language would you recommend to develop with pilot-db (interface libs etc)

Thx

GSO

Re: [pilot-db-list] utilizing views

[Scott W. <swa...@my...>]

> I'm brand new to pilot-db, having just downloaded db-1_0_4.zip.
> I used the MobileDB plug-in and imported a database.  It works
> great.
> 
> I'm confused, though, about creating and changing "views".  It
> looks like the documentation that came with the .prc is out of
> sync and the UI is not intuitive to me on this point.  Chapter 6,
> "Utilizing Views", tells me I should be able to create a new
> view with the View Manager.  When I'm in what I assume is the 
> default view of my db, I tap "All Fields" in the upper right.
> I tap "Edit List Views..." and I get a form titled "DB:List Views"
> that looks like the scrren shot it "Accessing the View Manager",
> except there's no "new" button, just "edit" and "done".  What am
> I missing?

	DB's plugins allow you to access many kinds of databases, such as 
those in the MobleDB format.  The manual refers to DB's native format 
(DB3), and it's important to note that not all formats support all 
features.

	I think that in particular, MobileDB doesn't support multiple 
views.  If you want to use multiple features, you will need to convert the 
database to the native (DB3) format.  You can do this in the 'chooser' 
screen using the 'duplicate database' menu option.  Make sure that the new 
database is created in the DB3 format, then  you should be all set.  

> 
> There's one feature that I see in my demo version of MobileDB that
> I like.  It's that when I scroll horizontally, the leftmost column
> is not replaced.  In other words, only columns 2 through n are
> scrolled, and in a circular fashion.  That allows the user to 
> keep the "name" of each record in view as the fields are scrolled.
> Is there a way to set up views in pilot-db to do that?
> 


	DB doesn't do this right now.  Although a number of people have 
suggested it, so perhaps it will be added in the future.

	hope this helps,

	-Scott

[pilot-db-list] utilizing views

[Stuart B. <stu...@va...>]

I'm brand new to pilot-db, having just downloaded db-1_0_4.zip.
I used the MobileDB plug-in and imported a database.  It works
great.

I'm confused, though, about creating and changing "views".  It
looks like the documentation that came with the .prc is out of
sync and the UI is not intuitive to me on this point.  Chapter 6,
"Utilizing Views", tells me I should be able to create a new
view with the View Manager.  When I'm in what I assume is the 
default view of my db, I tap "All Fields" in the upper right.
I tap "Edit List Views..." and I get a form titled "DB:List Views"
that looks like the scrren shot it "Accessing the View Manager",
except there's no "new" button, just "edit" and "done".  What am
I missing?

There's one feature that I see in my demo version of MobileDB that
I like.  It's that when I scroll horizontally, the leftmost column
is not replaced.  In other words, only columns 2 through n are
scrolled, and in a circular fashion.  That allows the user to 
keep the "name" of each record in view as the fields are scrolled.
Is there a way to set up views in pilot-db to do that?

I took a look for these issues in the archive before this posting.
I apologize if I'm going over old ground.

Thanks.

	Stuart Blood

Re: [pilot-db-list] Yet Another Calculated Field

[Scott W. <swa...@my...>]

On Thu, 17 Apr 2003, mowestusa wrote:

> Hello,
> I love Pilot-DB, and I would love the answer to this
> question because it would give me the chance to make
> new databases that would be really cool.
> 
> I want to know how to use a script to keep a running
> total going in the calculated field.
> Example:
> Field0  Date  (A date field)
> Field1  Type  (A list field)
> Field2  Description (A string field)
> Field3  Cost  (A floating point field)
> Field4  Total  (A calculated field that keeps a
> running total (or if possible a running total by
> type?))
> 

	off the top of my head how about:

(sort 0 1)(+ %3 (ffr 4 -1 0.0))

	sort by date, then keep a running total of cost


	or: 

(sort 1 1 0 1)(+ (? (seq (ffr 1 -1 'n/a') %1) (ffr 4 -1 0.0) 0.0) %3)

	sort by type then date, keep running totals per type. That is,
check to see if the previous record is the same type as the current record
(? (seq ffr 1 -1 'n/a') %1).  If so, add its running total (ffr 4 -1 0.0)
with the current cost (%3).  Otherwise add the default value (0.0) to the
current cost (%3)
	

If you want to do both of these, then you'll probably want to use the same 
sort order for the scripts, (i.e. sort 1 1 0 1) or define two views with 
appropriate sortings for the calculated field you display.  Otherwise, 
one running total might look a bit odd.


	hope this helps

		-Scott
	 

[pilot-db-list] Yet Another Calculated Field

[mowestusa <mow...@ya...>]

Hello,
I love Pilot-DB, and I would love the answer to this
question because it would give me the chance to make
new databases that would be really cool.

I want to know how to use a script to keep a running
total going in the calculated field.
Example:
Field0  Date  (A date field)
Field1  Type  (A list field)
Field2  Description (A string field)
Field3  Cost  (A floating point field)
Field4  Total  (A calculated field that keeps a
running total (or if possible a running total by
type?))

I know that you need to use sort( ) and ffr.  But the
manual left me with unanswered questions.  I guess I
didn't understand the examples.  If someone wouldn't
mind explaining this to me I would appreciate it.

mowestusa

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com