pilot-db-list

[pilot-db-list] =?iso-8859-1?Q?Re:_[pilot-db-list]_Questions_about_non-working_install_for_Mac_users?=

[=?iso-8859-1?Q?<mar...@la...>]

If you did see it, there is a tool in the libpalm directory of=0D=0Athe p=
alm-db-tools source file, dump-pdb. This tool are able to=0D=0Aextract th=
e informations of the appInfo block. But i think the=0D=0Abetter is to us=
e a hex editor.=0D=0A=0D=0AHave you try to:=0D=0A * load a DB on the emul=
ator and open it.( you should be able=0D=0Ato open it).=0D=0A * load the =
same file on the Palm.( you should be not able to=0D=0Aopent it).=0D=0A *=
 delete the DB on the Mac=0D=0A * backup the DB on the Mac.=0D=0A * load =
the new file in the emulator and open it.=0D=0A=0D=0AIf you can open the =
file at the end, then the modifications do=0D=0Aduring the Hotsync, are r=
eversed during the backup, and it's=0D=0Anormal that your "Palm" file is =
identic to your "Org" file.=0D=0A=0D=0AI parsed your "Palm" File in your =
mail for informations, i=0D=0Afound some trouble can you tell me how did =
you do this file.=0D=0AThank you,=0D=0AMarc Chalain.=0D=0A=0D=0A---------=
- Debut du message initial -----------=0D=0A=0D=0ADe     : pilot-db-list-=
ad...@li...=0D=0AA      : Scott Wallace <swallace@mynah.e=
ecs.umich.edu>=0D=0ACopies : pil...@li...=0D=0ADat=
e   : Wed, 12 Mar 2003 11:10:12 +0100=0D=0AObjet  : Re: [pilot-db-list] Q=
uestions about non-working=0D=0Ainstall for Mac users=0D=0A=0D=0A2003-03-=
11 11:40: Scott Wallace <swa...@my...> is=0D=0Abelieved =
to have typed:=0D=0A=0D=0A>   This is very interesting.  Would it be poss=
ible to examine=0D=0Athe =0D=0A> AppInfo block when it is on the palm?  I=
 suppose there are=0D=0Atools to do =0D=0A> this...=0D=0A=0D=0AI don't kn=
ow. I didn't find a good one but I didn't look that=0D=0Ahard (but=0D=0AI=
 would like to have one 8-)=0D=0A=0D=0A> Well, the db3 format doesn't use=
 the standard appinfo structure.=0D=0A> According to the docs I've read, =
the appinfo block can contain=0D=0A> whatever user data one might want, b=
ut I could imagine that this=0D=0A> isn't actually the case.  =0D=0A=0D=0A=
There are several application that doesn't use the standard=0D=0Aappinfo =
so=0D=0Athe problem must be somewhere else=0D=0A=0D=0A> Have you tried cr=
eating a db on the palm, backing up to your=0D=0Amac and =0D=0A> reinstal=
ling the db?  This shouldn't work.   I could try to=0D=0Amake =0D=0A> a m=
odification to the file format to make it consistent with=0D=0Anormal =0D=
=0A> expectations about the appinfo block and we could see if=0D=0Athat r=
esolves =0D=0A> these mac problems.  =0D=0A> =0D=0A> What do you think ab=
out trying this experiment?  =0D=0A=0D=0AI tried this with the version yo=
u sent me and it doesn't work.=0D=0A=0D=0AWhat exactly happens during ins=
tallation of a database, does=0D=0Athe program=0D=0Ainteracts with the do=
wnloaded file in some way during=0D=0Adownload? (if so,=0D=0Acould there =
be some little/big endian problem) =0D=0A=0D=0ASome obeservations=0D=0A=0D=
=0AItem 1: Corruption occurs going from Mac =3D> Palm=0D=0A=0D=0AItem 2: =
Corruption doesn't occur when going Mac =3D> SD Card =3D> Palm=0D=0A=0D=0A=
Item 3: I created a database on the Palm, hotsynced, opened my=0D=0Abacku=
p=0D=0A        folder and tried to install it on my Palm but it=0D=0Afail=
ed when=0D=0A        I tried to open it.=0D=0A        =0D=0A        Then =
I tried to install it on my SD card and copy it to my=0D=0A        Palm, =
which worked! So I assume this means that going from=0D=0A        Palm to=
 Mac is OK.=0D=0A        =0D=0A        And here a few interesting things =
happens. Notation:=0D=0AOrg is=0D=0A        the file that was created on =
the Mac, Palm the one which=0D=0A        was installed on the Palm and th=
en synced back, SD the one=0D=0A        that was installed on the SD, cop=
ied to the Palm and=0D=0Asynced=0D=0A        back. The example database d=
efines two strings and has one=0D=0A        record.=0D=0A=0D=0AOrg looks =
like this=0D=0A=0D=0A       > database name: snutt=0D=0A0x0000 73 6E 75 7=
4 74 00 00 00 01 75 E4 60 00 00 00 00=0D=0A0x0010 00 00 00 00 0E 67 00 00=
 00 00 00 00 00 00 00 00=0D=0A       > flags:=0D=0A0x0020 00 08=0D=0A    =
   > version:=0D=0A0x0022 00 00=0D=0A       > time creation=0D=0A0x0024 3=
E 6F 0A 3F=0D=0A       > time modification=0D=0A0x0028 3E 6F 0A 57=0D=0A =
      > time backup=0D=0A0x002C 3E 6F 0A 57=0D=0A       > modnum ???=0D=0A=
0x0030 00 00 00 04=0D=0A       > appInfo block offset: 0x00000058=0D=0A0x=
0034 00 00 00 58=0D=0A       > sortInfo block offset: 0x00000000=0D=0A0x0=
038 00 00 00 00=0D=0A       > type: DB00=0D=0A0x003C 44 42 30 30=0D=0A   =
    > creator: DBOS=0D=0A0x0040 44 42 4F 53=0D=0A       > unique ID=0D=0A=
0x0044 00 00 00 00=0D=0A       > next record ID=0D=0A0x0048 00 00 00 00=0D=
=0A       > number of records: 1=0D=0A0x004C 00 01 00 00=0D=0A       > re=
cord 1 entry: offset 0x0080, =0D=0A0x0050 00 80 40 00 20 01 00 00=0D=0A  =
     > AppInfo block: =0D=0A0x0058 00 00 00 02 00 00 00 0A=0D=0A0x0060 48=
 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00=0D=0A0x0070 00 00 00 41 00 =
04 00 00 00 00 00 80 00 02 00 00=0D=0A       >> Number of Chunk: 2=0D=0A =
 > 0x0058 00 00 00 02=0D=0A       >> Chunk 1 type: 0 =3D> field name=0D=0A=
  > 0x005C 00 00=0D=0A       >> Chunk 1 size: 10=0D=0A  > 0x005E 00 0A=0D=
=0A       >> Chunk 1: 2 strings: =0D=0A  > 0x0060 48 65 6A 00 48 65 6C 6C=
 6F 00=0D=0A       >> Chunk 2 type: 1 =3D> field type=0D=0A  > 0x006A 00 =
01=0D=0A       >> Chunk 2 size: 4=0D=0A  > 0x006C 00 04=0D=0A       >> Ch=
unk 2: 00 00 =3D> string, 00 00 =3D> string=0D=0A  > 0x006E 00 00 00 00=0D=
=0A       >> Chunk 3 type: 41 =3D> listview=0D=0A  > 0x0072 00 41=0D=0A  =
     >> Chunk 3 size: 4   (CORRUPTION the minimum is 4 + 32)=0D=0A  > 0x0=
074 00 04=0D=0A       >> Chunk 3:=0D=0A  > 0x0076 00 00 00 00=0D=0A      =
 >> Chunk 4 type: 80 =3D> find options=0D=0A  > 0x007A 00 80=0D=0A       =
>> Chunk 4 size: 2=0D=0A  > 0x007C 00 02=0D=0A       >> Chunk 4:=0D=0A  >=
 0x007E 00 00=0D=0A       > record 1=0D=0A0x0080 00 04 00 08 45 74 74 00 =
54 72 65 00 =0D=0A       >> offset of the field 1=0D=0A  > 0x0080 00 04=0D=
=0A       >> offset of the field 2=0D=0A  > 0x0082 00 08=0D=0A       >> f=
ield 1: "Ett"=0D=0A  > 0x0084 45 74 74 00=0D=0A       >> field 1: "Tre"=0D=
=0A  > 0x0088 54 72 65 00 =0D=0A=0D=0APalm like this=0D=0A0x0000 73 6E 75=
 74 74 00 00 00 01 75 E4 60 00 00 00 00=0D=0A0x0010 00 00 00 00 0E 67 00 =
00 00 00 00 00 00 00 00 00=0D=0A0x0020 00 08 00 00 3E 6F 0A 3F 3E 6F 0A 5=
7 3E 6F 0A 57=0D=0A0x0030 00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30=
=0D=0A0x0040 44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00=0D=0A0x0050 =
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A=0D=0A0x0060 48 65 6A 00 4=
8 65 6C 6C 6F 00 00 01 00 04 00 00=0D=0A0x0070 00 00 00 41 00 04 00 00 00=
 00 00 80 00 02 00 00=0D=0A0x0080 00 04 00 08 45 74 74 00 54 72 65 00 =0D=
=0A=0D=0AAnd SD like this=0D=0A0x0000 73 6E 75 74 74 00 00 00 01 82 2B E0=
 63 6E 74 6C=0D=0A0x0010 00 00 00 04 00 00 00 00 40 C7 8B 0D D8 E8 64 02=0D=
=0A0x0020 00 08 00 00 C2 49 59 BF 3E 6F 0C 92 3E 6F 0C 92=0D=0A0x0030 00 =
00 00 04 00 00 00 58 00 00 00 00 44 42 30 30=0D=0A0x0040 44 42 4F 53 00 0=
0 00 00 00 00 00 00 00 01 00 00=0D=0A0x0050 00 80 40 00 20 01 00 00 00 00=
 00 02 00 00 00 0A=0D=0A0x0060 48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 =
00 00=0D=0A0x0070 00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00=0D=0A0x=
0080 00 04 00 08 45 74 74 00 54 72 65 00 =0D=0A=0D=0A=0D=0A        Note t=
hat the Org and Palm files looks exactly the=0D=0Asame, while=0D=0A      =
  the one who got installed on the SD card is different (the=0D=0A       =
 name is changed after the 0 but that shouldn't=0D=0Amatter). All=0D=0A  =
      three dates fields are changed but the rest is the same.=0D=0A     =
   =0D=0A        But in this case it's only thing that has changed, nothi=
ng=0D=0A        extra is inserted there but it still refuses to do=0D=0Aa=
nything.=0D=0A=0D=0AThis would suggest that if the only thing that matter=
s is how=0D=0Athe file=0D=0Alooks like, then one problem seems to be rela=
ted to either the=0D=0Adates or=0D=0Athe name of the file. But this doesn=
't explain the extra info=0D=0Ain the=0D=0Aappinfo block described below.=
=0D=0A=0D=0ADoes Pilot-DB check the creation date against the other two i=
n=0D=0Asome way?=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A        =0D=0A=0D=
=0AHere is a description I sent to another list=0D=0A=0D=0A> I compared t=
he faulty database in my backup folder with the=0D=0A> orginal I tried to=
 install and from what I can understand the=0D=0A> appinfo block seem to =
have become corrupted (note I'm looking at=0D=0A> this file on my Mac so =
the database have travelled Mac =3D>=0D=0APalm =3D>=0D=0A> Mac, the one w=
ho travelled Mac =3D> SD Card =3D> Palm =3D> Mac doesn't=0D=0A> have this=
 problem).=0D=0A> =0D=0A> There seems be an extra chunk of information (I=
 think 15F bytes)=0D=0A> at the end of the AppInfo block of the munged fi=
le.=0D=0A=0D=0ADo you get any ideas??=0D=0A=0D=0A                jem=0D=0A=
-- =0D=0AJan Erik Mostr=F6m   je...@mo...    www.mostrom.pp.se=0D=0A=
=0D=0A=0D=0A-------------------------------------------------------=0D=0A=
This SF.net email is sponsored by:Crypto Challenge is now open! =0D=0AGet=
 cracking and register here for some mind boggling fun and =0D=0Athe chan=
ce of winning an Apple iPod:=0D=0Ahttp://ads.sourceforge.net/cgi-bin/redi=
rect.pl?thaw0031en=0D=0A_______________________________________________=0D=
=0APilot-db-list mailing list=0D=0AP...@li...=0D=
=0Ahttps://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0A=
Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3=
615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

Re: [pilot-db-list] pdb2sql

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

On Sat, Mar 15, 2003 at 05:46:55PM +0800, Elijah wrote:
>
> I hope it can export from mysql to pdb ...

This is planned but I first want to fix any bugs that are
in the current script (now you know why it's version 0.9.0).
Then I make a sql2pdb script and start work on the data types
that aren't documented.

> On Wed, 2003-03-12 at 16:30, mar...@la... wrote:
> > Great,
> > I always hope to see a tool like that.
> > Thank you.

Je t'en prie. :-)

Emmanuel

Re: [pilot-db-list] Questions about non-working install for Mac users

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

2003-03-11 11:40: Scott Wallace <swa...@my...> is
believed to have typed:

>   This is very interesting.  Would it be possible to examine the=20
> AppInfo block when it is on the palm?  I suppose there are tools to do=20
> this...

I don't know. I didn't find a good one but I didn't look that hard (but
I would like to have one 8-)

> Well, the db3 format doesn't use the standard appinfo structure.
> According to the docs I've read, the appinfo block can contain
> whatever user data one might want, but I could imagine that this
> isn't actually the case. =20

There are several application that doesn't use the standard appinfo so
the problem must be somewhere else

> Have you tried creating a db on the palm, backing up to your mac and=20
> reinstalling the db?  This shouldn't work.   I could try to make=20
> a modification to the file format to make it consistent with normal=20
> expectations about the appinfo block and we could see if that resolves=20
> these mac problems. =20
>=20
> What do you think about trying this experiment? =20

I tried this with the version you sent me and it doesn't work.

What exactly happens during installation of a database, does the program
interacts with the downloaded file in some way during download? (if so,
could there be some little/big endian problem)=20

Some obeservations

Item 1: Corruption occurs going from Mac =3D> Palm

Item 2: Corruption doesn't occur when going Mac =3D> SD Card =3D> Palm

Item 3: I created a database on the Palm, hotsynced, opened my backup
        folder and tried to install it on my Palm but it failed when
        I tried to open it.
       =20
        Then I tried to install it on my SD card and copy it to my
        Palm, which worked! So I assume this means that going from
        Palm to Mac is OK.
       =20
        And here a few interesting things happens. Notation: Org is
        the file that was created on the Mac, Palm the one which
        was installed on the Palm and then synced back, SD the one
        that was installed on the SD, copied to the Palm and synced
        back. The example database defines two strings and has one
        record.

Org looks like this

73 6E 75 74 74 00 00 00 01 75 E4 60 00 00 00 00
00 00 00 00 0E 67 00 00 00 00 00 00 00 00 00 00
00 08 00 00 3E 6F 0A 3F 3E 6F 0A 57 3E 6F 0A 57
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20

Palm like this
73 6E 75 74 74 00 00 00 01 75 E4 60 00 00 00 00
00 00 00 00 0E 67 00 00 00 00 00 00 00 00 00 00
00 08 00 00 3E 6F 0A 3F 3E 6F 0A 57 3E 6F 0A 57
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20

And SD like this
73 6E 75 74 74 00 00 00 01 82 2B E0 63 6E 74 6C
00 00 00 04 00 00 00 00 40 C7 8B 0D D8 E8 64 02
00 08 00 00 C2 49 59 BF 3E 6F 0C 92 3E 6F 0C 92
00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30
44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00
00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A
48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00
00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00
00 04 00 08 45 74 74 00 54 72 65 00=20


        Note that the Org and Palm files looks exactly the same, while
        the one who got installed on the SD card is different (the
        name is changed after the 0 but that shouldn't matter). All
        three dates fields are changed but the rest is the same.
       =20
        But in this case it's only thing that has changed, nothing
        extra is inserted there but it still refuses to do anything.

This would suggest that if the only thing that matters is how the file
looks like, then one problem seems to be related to either the dates or
the name of the file. But this doesn't explain the extra info in the
appinfo block described below.

Does Pilot-DB check the creation date against the other two in some way?






       =20

Here is a description I sent to another list

> I compared the faulty database in my backup folder with the
> orginal I tried to install and from what I can understand the
> appinfo block seem to have become corrupted (note I'm looking at
> this file on my Mac so the database have travelled Mac =3D> Palm =3D>
> Mac, the one who travelled Mac =3D> SD Card =3D> Palm =3D> Mac doesn't
> have this problem).
>=20
> There seems be an extra chunk of information (I think 15F bytes)
> at the end of the AppInfo block of the munged file.

Do you get any ideas??

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

Re: [pilot-db-list] Re:[pilot-db-list] pdb2sql

[Elijah <des...@so...>]

Cool Just what I needed ^-^ Thanks 
Learning mysql will now be in my todo list ;)
I hope it can export from mysql to pdb ... 

On Wed, 2003-03-12 at 16:30, mar...@la... wrote:
> Great,
> I always hope to see a tool like that.
> Thank you.
> 
> ---------- Debut du message initial -----------
> 
> De     : pil...@li...
> A      : pil...@so...
> Copies : 
> Date   : Tue, 11 Mar 2003 19:09:43 +0100
> Objet  : [pilot-db-list] pdb2sql
> 
> 
> Using the documentation on the web site, I've hacked together
> a perl script that takes a pilot-db database and spits out
> the corresponding sql dump, which you can then use to
> recreate your database in MySQL or Postgresql (or anything,
> really). It's handled the little I have to throw at it
> and I would really appreciate if somebody could test this
> and report any errors.
> 
> <URL:http://www.acticiel.com/~seyman/pilot-db/>
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open! 
> Get cracking and register here for some mind boggling fun and 
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> 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)"
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open! 
> Get cracking and register here for some mind boggling fun and 
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
-- 
Elijah <des...@so...>

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_pdb2sql?=

[=?iso-8859-1?Q?<mar...@la...>]

Great,=0D=0AI always hope to see a tool like that.=0D=0AThank you.=0D=0A=0D=
=0A---------- Debut du message initial -----------=0D=0A=0D=0ADe     : pi=
lot...@li...=0D=0AA      : pilot-db-list@sourc=
eforge.net=0D=0ACopies : =0D=0ADate   : Tue, 11 Mar 2003 19:09:43 +0100=0D=
=0AObjet  : [pilot-db-list] pdb2sql=0D=0A=0D=0A=0D=0AUsing the documentat=
ion on the web site, I've hacked together=0D=0Aa perl script that takes a=
 pilot-db database and spits out=0D=0Athe corresponding sql dump, which y=
ou can then use to=0D=0Arecreate your database in MySQL or Postgresql (or=
 anything,=0D=0Areally). It's handled the little I have to throw at it=0D=
=0Aand I would really appreciate if somebody could test this=0D=0Aand rep=
ort any errors.=0D=0A=0D=0A<URL:http://www.acticiel.com/~seyman/pilot-db/=
>=0D=0A=0D=0A=0D=0A=0D=0A------------------------------------------------=
-------=0D=0AThis SF.net email is sponsored by:Crypto Challenge is now op=
en! =0D=0AGet cracking and register here for some mind boggling fun and =0D=
=0Athe chance of winning an Apple iPod:=0D=0Ahttp://ads.sourceforge.net/c=
gi-bin/redirect.pl?thaw0031en=0D=0A______________________________________=
_________=0D=0APilot-db-list mailing list=0D=0AP...@li...urce=
forge.net=0D=0Ahttps://lists.sourceforge.net/lists/listinfo/pilot-db-list=
=0D=0A=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : www.lapost=
e.net ; =0A3615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80=
/mn)"=0A=0A

[pilot-db-list] Re: Questions about non-working install for Mac users

[Patrick C. <pa...@oc...>]

On Tuesday, March 11, 2003, at 12:03 PM, jem wrote:
> So I would like to collect some more information before trying Palm
> Support again, and I would like to ask:
>
> +   What versions of the HotSync stuff are you using?
HotSync Manager 3.0.0, Conduit Manager 3.0.0, Palm Desktop 4.0

> +   Does it always fail?
Always.

> +   Is there some Mac user who can install DBs?
>
> +   Does it happen for some other application also, or is it only
>     for Pilot-DBs (it has never happend for any other application
>     for me)?
Just the databases.  No problems with apps.

> Does Pilot-DB do something special with the AppInfo block that could
> possible cause this problem?

Specs:
	Max OS X 10.2.4, 667 PB G4
	Silver Visor Edge

[pilot-db-list] pdb2sql

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

Using the documentation on the web site, I've hacked together
a perl script that takes a pilot-db database and spits out
the corresponding sql dump, which you can then use to
recreate your database in MySQL or Postgresql (or anything,
really). It's handled the little I have to throw at it
and I would really appreciate if somebody could test this
and report any errors.

<URL:http://www.acticiel.com/~seyman/pilot-db/>

Re: [pilot-db-list] Questions about non-working install for Mac users

[Norman W. <nd...@nw...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

/ Jan Erik Mostr=81=F6m <li...@mo...> was heard to say:
| Does Pilot-DB do something special with the AppInfo block that could
| possible cause this problem?

I have no reason to believe that this is related, but in case it is...

My own investigation of syncing with pilot-db revealed that the
conduit has to get the appinfo block first in order to know how to
decode the records. It turns out that PilotManager, the system I was
working with, doesn't actually provide the appinfo block until after
it's processed the records, so some reworking was needed.

                                        Be seeing you,
                                          norm

- --=20
Norman Walsh <nd...@nw...> | Men are more like the times they live
http://nwalsh.com/            | in than they are like their
                              | fathers.--Ali Ibn-abi-talib
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+bhY9OyltUcwYWjsRAql4AJ9mW914I0jER/XngZYwZ86r07l0OQCgnnPQ
MdusRBUNRftIuLjbFJE7jN0=3D
=3D99YJ
-----END PGP SIGNATURE-----

Re: [pilot-db-list] Questions about non-working install for Mac users

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

On Tue, 11 Mar 2003, Jan Erik Mostr=F6m wrote:

> I haven't had the time to work on my Pilot-DB translator for a week or
> so, but I've been trying to get some more information about why it's no=
t
> possible to install Pilot-DB databases.
>=20
> So far I can only confirm that:
>=20
> +   The AppInfo block in the DB doesn't have to be large
>=20
> +   There seems to be some extra information added to the AppInfo
>     block somewhere during the installation.


	This is very interesting.  Would it be possible to examine the=20
AppInfo block when it is on the palm?  I suppose there are tools to do=20
this...

	=09
> +   Does it happen for some other application also, or is it only
>     for Pilot-DBs (it has never happend for any other application
>     for me)?
>=20
> Does Pilot-DB do something special with the AppInfo block that could
> possible cause this problem?
>=20

Well, the db3 format doesn't use the standard appinfo structure. Accordin=
g=20
to the docs I've read, the appinfo block can contain whatever user data=20
one might want, but I could imagine that this isn't actually the case. =20

Have you tried creating a db on the palm, backing up to your mac and=20
reinstalling the db?  This shouldn't work.   I could try to make=20
a modification to the file format to make it consistent with normal=20
expectations about the appinfo block and we could see if that resolves=20
these mac problems. =20

What do you think about trying this experiment? =20

	-Scott

[pilot-db-list] Questions about non-working install for Mac users

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

I haven't had the time to work on my Pilot-DB translator for a week or
so, but I've been trying to get some more information about why it's not
possible to install Pilot-DB databases.

So far I can only confirm that:

+   Installing DBs on the Palm doesn't work

+   Installing DBs on a SD card and then move it to the Palm works

+   The AppInfo block in the DB doesn't have to be large

+   There seems to be some extra information added to the AppInfo
    block somewhere during the installation.

+   The only advise I got from Palm support was "re-install"

So I would like to collect some more information before trying Palm
Support again, and I would like to ask:

+   What versions of the HotSync stuff are you using?

+   Does it always fail?

+   Is there some Mac user who can install DBs?

+   Does it happen for some other application also, or is it only
    for Pilot-DBs (it has never happend for any other application
    for me)?

Does Pilot-DB do something special with the AppInfo block that could
possible cause this problem?

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

Re: [pilot-db-list] Calculated Fields

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

I can't comment on your first problem because it seems that it might have 
to do with the conversion from csv to pdb format, and I'm not too familiar 
with db-tools.  As for your problem with 'gcd', are you sure that your 
palm's clock is set correctly? I debug regularly with the Vx, and I have 
not seen any strange behavior with gcd.  Perhaps it would help if you sent 
me the script.  

	As for doing calculating differences between dates, you can use 
the 'dur' operation to cast an integer as a duration.  So if %1 and %2 are 
dates (dur (- (int %1) (int %2))) will give the difference between these 
dates in days, hours and minutes.  However, getting the difference in 
days, months, years is not possible, but it is a good idea.


	-Scott

> 2. The 'gcd' function returns the value of today's date with the year as
> '1999'.
>  
> While transferring the data the '.ifo' file contains the following
> command -
>  
> format date %d/%m/%Y
>  
> What's wrong??
>  
> Further, is there any simple way of doing date calculations viz.
> difference between two dates in years, months and days etc.
>  
> Kapoor
> dh...@si...
>  
> 

-- 

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Understanding_the_db_format?=

[=?iso-8859-1?Q?<mar...@la...>]

I will try to do something asap.=0D=0A=0D=0AGreat job on DocBook!!!=0D=0A=
=0D=0A---------- Debut du message initial -----------=0D=0A=0D=0ADe     :=
 pil...@li...=0D=0AA      : pilot-db-list@li=
sts.sourceforge.net=0D=0ACopies : =0D=0ADate   : Tue, 04 Mar 2003 07:14:5=
5 -0500=0D=0AObjet  : [pilot-db-list] Understanding the db format=0D=0A=0D=
=0A-----BEGIN PGP SIGNED MESSAGE-----=0D=0AHash: SHA1=0D=0A=0D=0AHi,=0D=0A=
=0D=0AI'm working on a PilotManager[1] conduit for pilot-db. There=0D=0As=
eem to=0D=0Abe a few fields in the appinfo block that aren't documented i=
n the=0D=0Amost recent db_docs.html. I wonder if someone could fill in=0D=
=0Athe blanks=0D=0Afor me.=0D=0A=0D=0AThere seems to be a chunk type 2 in=
 the appinfo block. It=0D=0Aappears to have=0D=0Athree UInt16 values foll=
owed by more stuff. The "more stuff"=0D=0Ais sometimes=0D=0Aa list of nul=
l-terminated strings that are the values for list=0D=0Afields.=0D=0A=0D=0A=
chunk 2=0D=0A        2=0D=0A        16=0D=0A        6, 3, 3072=0D=0A     =
           one,two,3=0D=0A=0D=0ABut if the list is a "link" it's clearly =
something else:=0D=0A=0D=0Achunk 3=0D=0A        2=0D=0A        36=0D=0A  =
      7, 19823, 30313=0D=0A                es,.,,,,,,,,,,,,,,,,,,,,,,,,,=0D=
=0A=0D=0ASimilarly, there seems to be a field type "6" in records. It=0D=0A=
appears to be=0D=0Aa single UInt8. My guess is that it's the ordinal valu=
e of the=0D=0Alist value=0D=0Aselected from the ... corresponding? ... ch=
unk 2 block from=0D=0Athe header.=0D=0A=0D=0AI'll probably have more ques=
tions when I try syncing some of=0D=0Athe other new=0D=0Afield types (lik=
e script and linked).=0D=0A=0D=0A                                        =
Be seeing you,=0D=0A                                          norm=0D=0A=0D=
=0A[1] http://www.moshpit.org/pilotmgr/=0D=0A- -- =0D=0ANorman Walsh <ndw=
@nwalsh.com> | An ill-humoured man is a=0D=0Aprisoner at=0D=0Ahttp://nwal=
sh.com/            | the mercy of an enemy from=0D=0Awhom he can=0D=0A   =
                           | never escape.--Sa'di=0D=0A-----BEGIN PGP SIG=
NATURE-----=0D=0AVersion: GnuPG v1.0.6 (GNU/Linux)=0D=0AComment: Processe=
d by Mailcrypt 3.5.7=0D=0A<http://mailcrypt.sourceforge.net/>=0D=0A=0D=0A=
iD8DBQE+ZJi/OyltUcwYWjsRAhXHAJoD9MzfZClf+g8BuLnbdMjap0ZCmgCcCVZ7=0D=0AHok=
CIiUzNKhQT5s06bhQP08=3D=0D=0A=3D/fi2=0D=0A-----END PGP SIGNATURE-----=0D=0A=
=0D=0A=0D=0A-------------------------------------------------------=0D=0A=
This SF.net email is sponsored by: Etnus, makers of TotalView,=0D=0AThe d=
ebugger =0D=0Afor complex code. Debugging C/C++ programs can leave you=0D=
=0Afeeling lost and =0D=0Adisoriented. TotalView can help you find your w=
ay. Available=0D=0Aon major UNIX =0D=0Aand Linux platforms. Try it free. =
www.etnus.com=0D=0A_______________________________________________=0D=0AP=
ilot-db-list mailing list=0D=0AP...@li...=0D=0Ah=
ttps://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0AAcc=E9=
dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LA=
POSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

[pilot-db-list] Understanding the db format

[Norman W. <nd...@nw...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I'm working on a PilotManager[1] conduit for pilot-db. There seem to
be a few fields in the appinfo block that aren't documented in the
most recent db_docs.html. I wonder if someone could fill in the blanks
for me.

There seems to be a chunk type 2 in the appinfo block. It appears to have
three UInt16 values followed by more stuff. The "more stuff" is sometimes
a list of null-terminated strings that are the values for list fields.

chunk 2
        2
        16
        6, 3, 3072
                one,two,3

But if the list is a "link" it's clearly something else:

chunk 3
        2
        36
        7, 19823, 30313
                es,.,,,,,,,,,,,,,,,,,,,,,,,,,

Similarly, there seems to be a field type "6" in records. It appears to be
a single UInt8. My guess is that it's the ordinal value of the list value
selected from the ... corresponding? ... chunk 2 block from the header.

I'll probably have more questions when I try syncing some of the other new
field types (like script and linked).

                                        Be seeing you,
                                          norm

[1] http://www.moshpit.org/pilotmgr/
- -- 
Norman Walsh <nd...@nw...> | An ill-humoured man is a prisoner at
http://nwalsh.com/            | the mercy of an enemy from whom he can
                              | never escape.--Sa'di
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+ZJi/OyltUcwYWjsRAhXHAJoD9MzfZClf+g8BuLnbdMjap0ZCmgCcCVZ7
HokCIiUzNKhQT5s06bhQP08=
=/fi2
-----END PGP SIGNATURE-----

[pilot-db-list] Re: Macintosh Sync for pilot-db databases

[irntooth <irn...@ez...>]

I am running Palm Desktop for Mac 2.6.3 on Mac OS 9.1, and I see this 
problem, too.  When I was running pilot-db with a Handspring Visor with 
Memplug CF, I copied the db databases to the CF card with a card adapter 
on my Powerbook.  Now, I am using a Palm m130 with a MMC expansion card.  
The trick with this configuration is to hotsync the db databases to the 
card, rather than to the Palm device (Choose 'Change Destination' from 
the 'Install Handheld Files' panel).  Pilot-db with the VFS plugin 
recognizes the databases on the card, and there is _no_ error when 
opening them.  I can hotsync the same databases to the Palm, and get the 
'Could not open database' error...

Hope this helps at least a few of the Mac users.

>All databases available from the PilotDB sourceforge website are 
>affected by this Mac OS X Palm Desktop bug.  I've tried every single 
>one and they ALL give me that "Could not open database" error.  I have 
>not run into any applications though that have this "not working" issue.


 -- -- -- -- -- -- --
     Don V. Zahniser
  irn...@ez...

[pilot-db-list] DB errors

[<mon...@ju...>]

I am using a Palm "Zire" (2M OS 4.1)

When DB 1.2b2 is installed, the program stabilitytest1.2 (attached)
passes all the tests, but fails and causes a soft reset on exit.  I have
tried various configurations, and I believe that I have isolate the
problem to when DB is installed.  I was prompted to try stabilitytest1.2
because I was experiencing apparently random soft resets.

Does this situation match any known bug in DB?

Frank

[pilot-db-list] Bug report

[Craig B. <sys...@ca...>]

DB-Bugs 1.1B2 on a Handera 330 with the smallest of the 8 fonts selected
in global prefs.

-Editing Database design or View causes global pref font setting to be
ignored (reverts to larger font) when returning to records

-When in a filtered record set, editing a record, the filter selection is
lost when returning to the record list.  Filter should remain in place
until "no filter" is selected.

-Very often when editing a View to add recently added fields (to the
bottom of the view), not all fields in the view are shown, nor is the
scroll down control shown on screen.  One has to add a field arbitrarily
among the displayed fields to enable the scroll down control to see the
rest of the fields in the view and edit them, or add additional ones near
the bottom.

-Having fields with the field type "float" seems to cause long delays to
screen refresh when scrolling laterally across those fields.

-Even though there appears to be plenty of room in the column header to
tap for popping up the sort or Report Plugin options when the column
width is set to 10 or 15, one can't seem to.  With a column with of 19,
you can tap the header for sort selection, but only on the first few
pixels of width in the header field, rather than the full field width.

-VFS Plug-in bugs?  I have yet to spend more definitive bug tracking on
this yet but a least two instances of issues seem to pop up.
1.  Some of my databases give an unsupported field type error on
calculated fields if the file is VFS media based instead of RAM based.
2.  With Filtering:  Works fine when RAM based.  When VFS Media based
(the same file) If I choose a Filter from the list the following events
occur:
- Debug popup: "Set Filter to none" [hit OK]
- Debug popup: "-OK" [hit OK]
- Debug popup: "Filtering" [hit OK]
- Debug popup: "-ok" [hit OK]
- Debug popup: "Filtering" [hit OK]

...and so on.  A loop.  When your stylus hand gets tired, and you hit the
application silk button to exit, the PDA takes over and hits the OK's for
you seemingly, and you watch the popups alternating before you at high
speed for about 20 seconds before it quits (the time may be related to
the number of records in the database?)

-Feature Request: Could float fields in the record edit view abide by the
decimal preference as it does in the record list view?

[pilot-db-list] Re: Pilot-db-list digest, Vol 1 #612 - 4 msgs

[Patrick C. <pa...@oc...>]

All databases available from the PilotDB sourceforge website are 
affected by this Mac OS X Palm Desktop bug.  I've tried every single 
one and they ALL give me that "Could not open database" error.  I have 
not run into any applications though that have this "not working" issue.

Patrick
Mac OS X

On Sunday, March 2, 2003, at 12:05 PM, 
pil...@li... wrote:
>> 2003-03-01 15:34: Scott Wallace <swa...@my...> is
>> believed to have typed:
>>
>>>     Hm, well, I don't have a mac, so I'm not positive.  But a
>>>     number of users with macs (os x and os 9.whatever) and palm
>>>     desktop 4.0 have said they had trouble installing pilot
>>>     databases from the web.
>>
>> You don't remember if there was some example of a PDB that didn't 
>> work?
>> Just so I can make it happen on my machine.
>
> No, I don't ;)  However, there have been comments that some of the
> databases on the web sight don't work (but there are a fair number of
> these...)
>
> Perhaps another mac user can send you a database they had trouble
> with....(assuming they read this message...)

Re: [pilot-db-list] Mac Pilot DB Trouble

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

> 2003-03-01 15:34: Scott Wallace <swa...@my...> is
> believed to have typed:
> 
> >     Hm, well, I don't have a mac, so I'm not positive.  But a
> >     number of users with macs (os x and os 9.whatever) and palm
> >     desktop 4.0 have said they had trouble installing pilot
> >     databases from the web.
> 
> You don't remember if there was some example of a PDB that didn't work?
> Just so I can make it happen on my machine.

No, I don't ;)  However, there have been comments that some of the 
databases on the web sight don't work (but there are a fair number of 
these...)


	Perhaps another mac user can send you a database they had trouble 
with....(assuming they read this message...)


	-Scott

Re: [pilot-db-list] Pilot-DB calculated fields

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

2003-03-01 15:34: Scott Wallace <swa...@my...> is
believed to have typed:

>     Hm, well, I don't have a mac, so I'm not positive.  But a
>     number of users with macs (os x and os 9.whatever) and palm
>     desktop 4.0 have said they had trouble installing pilot
>     databases from the web.

You don't remember if there was some example of a PDB that didn't work?
Just so I can make it happen on my machine.
=20
>     pilotdb not being able to open a particular database)   But if
>     you're using the mac os 4.0 desktop and not having this
>     trouble, then I my initial guess must be wrong.

It's probably correct, and the reason why I haven't seen it is that I've
been using the "wrong" applications 8-)

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

Re: [pilot-db-list] Pilot-DB calculated fields

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

2003-03-01 15:34: Scott Wallace <swa...@my...> is
believed to have typed:

> ago, I found an article on the web saying that the mac palm
> desktop only transmitted part of a database's AppInfo Block,
> basically it was limited to a fairly small size, like 512 bytes or
> something.  Since DB stores a bunch of stuff in the appinfo block
> (the db schema, all calculated field scripts, views, etc) it
> seemed like this was likely the culprit for mac os people that had
> trouble installing databases they d/l from the web, or that they
> had backed up on a previous hotsync.  (the trouble manifests as=20

I might have been lucky (I don't normally use Pilot-DB, just installed
it a few days ago and started to look at the database format yesterday)
but I think that I have another applications that have fairly large
appinfo blocks. I'll have to look into this.

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

Re: [pilot-db-list] Pilot-DB calculated fields

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

On Sat, 1 Mar 2003, Jan Erik Mostr=F6m wrote:

> 2003-03-01 13:38: Scott Wallace <swa...@my...> is
> believed to have typed:
>=20
> >     Great! I took a quick look at your website and noticed that
> >     this is built for Mac OS X.  I should tell you that there is a
> >     problem with the Mac version of Palm Desktop that prevents it
> >     from transferring pilotdb databases to the palm correctly.  I
> >     don't know if you've tried to get pilot-link
> >     (http://www.pilot-link.org) to work on OS X, but it is one way
> >     to get /complete/ databases to the palm.  If you do have it
> >     working (and have found a place to download binaries), you
> >     could send the url to the newgroup?  A number of people have
> >     run into this problem, but there is no easy way to change the
> >     db format to deal with this bug in the mac palm desktop.
>=20
> How does this bug manifest itself? I haven't had any problems at all
> with this since I switched to OS X (about a year ago now).


	Hm, well, I don't have a mac, so I'm not positive.  But a number=20
of users with macs (os x and os 9.whatever) and palm desktop 4.0 have sai=
d=20
they had trouble installing pilot databases from the web.  A year or two=20
ago, I found an article on the web saying that the mac palm desktop only=20
transmitted part of a database's AppInfo Block, basically it was limited=20
to a fairly small size, like 512 bytes or something.  Since DB stores a=20
bunch of stuff in the appinfo block (the db schema, all calculated field=20
scripts, views, etc) it seemed like this was likely the culprit for mac o=
s=20
people that had trouble installing databases they d/l from the web, or=20
that they had backed up on a previous hotsync.  (the trouble manifests as=
=20
pilotdb not being able to open a particular database)   But if you're=20
using the mac os 4.0 desktop and not having this trouble, then I my=20
initial guess must be wrong.

	-Scott

Re: [pilot-db-list] Pilot-DB calculated fields

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

2003-03-01 13:38: Scott Wallace <swa...@my...> is
believed to have typed:

>     Great! I took a quick look at your website and noticed that
>     this is built for Mac OS X.  I should tell you that there is a
>     problem with the Mac version of Palm Desktop that prevents it
>     from transferring pilotdb databases to the palm correctly.  I
>     don't know if you've tried to get pilot-link
>     (http://www.pilot-link.org) to work on OS X, but it is one way
>     to get /complete/ databases to the palm.  If you do have it
>     working (and have found a place to download binaries), you
>     could send the url to the newgroup?  A number of people have
>     run into this problem, but there is no easy way to change the
>     db format to deal with this bug in the mac palm desktop.

How does this bug manifest itself? I haven't had any problems at all
with this since I switched to OS X (about a year ago now).


>     No.  Calculations for scripts that make within record field
>     references are done after each edit.  Calculations for scripts
>     that make inter-record field references are done only when
>     requested by the user (via explicit recalcuation, or via
>     global preferences setting).  The calculated value is then
>     stored inside the record so it can be fetched quickly.

Ahh, I thought it would do something like that. Thanks.

> field enumeration in datasource.h and what is actually stored in
> the file. So, I guess you will need to take a look at that code.

Aha, thanks. I'll take a look.

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

Re: [pilot-db-list] Pilot-DB calculated fields

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

> Hi
> 
> I've just started to add PilotDB databases as a supported format to my
> program MPC <http://www.mootjelitt.com/mpc.html>. I've been looking
> through the documentation and most of it seems like should cause no
> problem. 


	Great! I took a quick look at your website and noticed that this 
is built for Mac OS X.  I should tell you that there is a problem with the 
Mac version of Palm Desktop that prevents it from transferring pilotdb 
databases to the palm correctly.  I don't know if you've tried to get 
pilot-link (http://www.pilot-link.org) to work on OS X, but it is one way 
to get /complete/ databases to the palm.  If you do have it working (and 
have found a place to download binaries), you could send the url to the 
newgroup?  A number of people have run into this problem, but there is no 
easy way to change the db format to deal with this bug in the mac palm 
desktop.


> 
> What I'm wondering about is the calculated field type, am I current when
> I say that the value is calulated each time the record is viewed? (it's
> not really clear to me if it does this or not)
> 
	
	No.  Calculations for scripts that make within record field 
references are done after each edit.  Calculations for scripts that make 
inter-record field references are done only when requested by the user 
(via explicit recalcuation, or via global preferences setting).  The 
calculated value is then stored inside the record so it can be fetched 
quickly.

> A second question is the field types, the number I get in my test
> database isn't the same as in the documentation or the datasource.h
> file.

	I belive there is a tranlation from the field ids in datasource.h 
to those used in db3.c (the actual file encoder)  datasource.h is sort of 
the 'generic' interface, db3, on the otherhand  is the current file format 
used by pilotdb, since its possible that db3 only supports a subset of the 
field types in datasource.h, there is a translation between the 
field enumeration in datasource.h and what is actually stored in the file.  
So, I guess you will need to take a look at that code.

	Hope this helps,

	Scott

[pilot-db-list] Pilot-DB calculated fields

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

Hi

I've just started to add PilotDB databases as a supported format to my
program MPC <http://www.mootjelitt.com/mpc.html>. I've been looking
through the documentation and most of it seems like should cause no
problem.=20

What I'm wondering about is the calculated field type, am I current when
I say that the value is calulated each time the record is viewed? (it's
not really clear to me if it does this or not)

A second question is the field types, the number I get in my test
database isn't the same as in the documentation or the datasource.h
file.

I'm pretty sure that I'm missing something so I would be grateful if
someone could point me to the=20
--=20
Jan Erik Mostr=F6m   je...@mo...    www.mostrom.pp.se

Re: [pilot-db-list] Re: Databases won't open

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

> I have the same problem, using a visor neo (running
> PalmOS 3.5.2H3.0) and syncing with a Mac (OS 9.2)
> running the latest Palm Desktop for Mac/Handsprings.
> I can ONLY open MobileDB databases with PilotDB +
> plugins. The normal Pilot-db files (DBOS?) I've
> downloaded won't open at all.


Yes, this makes sense.  MobileDB gets around this Mac PalmDesktop error by 
storing the appinfo in a fake database record.  We can't do this easily in 
DB because category information (which is how Mobile DB hides these fake 
records) is used for other purposes.

	-Scott