pilot-db-list

Re: [pilot-db-list] Re:Test of Palm -> Mac too

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

2003-04-17 06:59: irntooth <irn...@ez...> is believed to have
typed:

> Ive tried MPC in both Mac OS 9.1 and 8.6, with similar results.=20
> When I launch the program, I get a dialog that says "No
> Preferences Set", along with an option whether or not to set a
> location of a 'backup catalog'.  I have chosen 'No', and then I
> get a 'File Browser' window, which doesn't appear to have any
> function.

The 'Backup Folder' is the HotSync backup folder (the folder where it
stores all files and applications). MPC scans this folder for databases
it knows of and list them in the browser window.

The reason why the browser window is empty is because you didn't specify
the backup folder and the default folder doesn't contain any Palm PDB
files. (I should change the code so it tries harder to find the backup
folder)

> It appears that this is a one-way translator, .pdb to
> tab-delimited text file.

Yep, it's one way only, to cite the FAQ:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Why is MPC not able to create databases?

Mainly because we don't need the ability to create databases 8-).
Another problem is that creating databases would mean that we need to
spend a lot more time on testing to make sure that everything works as
expected ... which means that we would have to charge for MPC.=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

To be honest, MPC is a one-person spare-time project done when I don't
need to do anything else (including playing with the kids, feeding the
cats, ect) ... which means that I have limited time for doing this.

I could make a version that creates databases also (for some
applications) but it would require a lot more testing (since writing
data is more complicated than reading) which in turn would mean that I
had to take time from "get money to pay the bills" projects ... which
means that we would need to charge for MPC since I can't do the other
stuff.


> A bit confusing, but functional.

Any idea how I can make it less confusing?

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

[pilot-db-list] Re:Test of Palm -> Mac too

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

>I have finally had the time to put together a beta for a Pilot-DB
>translator for MPC <http://www.mootjelitt.com/mpc.html>.=20
>
>I'm not a user of Pilot-DB myself so I'm not the best person to test
>it (this beta version have only had VERY limited testing) so I would
>be very grateful if you could test it and see what works and what
>doesn't (I'm pretty sure there are some bugs for calculated fields).
>
>You can download the program at <http://www.mootjelitt.com/MPC1.8b3.sit>

Ive tried MPC in both Mac OS 9.1 and 8.6, with similar results.  When I 
launch the program, I get a dialog that says "No Preferences Set", along 
with an option whether or not to set a location of a 'backup catalog'.  I 
have chosen 'No', and then I get a 'File Browser' window, which doesn't 
appear to have any function. I can't drag-and-drop into the window, for 
example. Using the menu commands, I then open a pilot-db .pdb file and am 
asked to specify the output file.  With the very simple database that I 
have tested, I have been able to open the subsequent file in AppleWorks 
as a spreadsheet, and it looks as though I could define database fields 
and import the data.

Drag-and-drop also works to open the .pdb file for output. 

It appears that this is a one-way translator, .pdb to tab-delimited text 
file.

A bit confusing, but functional.

 - Don

 






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

[pilot-db-list] MPC 1.8 released

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

MPC 1.8 is released <http://www.mootjelitt.com/mpc.html>.

MPC is a Mac program that can translate various Palm databases into some
some kind of data that can be used by "normal" Mac programs. Version 1.8
adds support for Pilot-DB.

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

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

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

Emmanuel Seyman wrote:

>On Tue, Apr 15, 2003 at 08:03:59PM +0200, Uwe Klo=DF wrote:
> =20
>
>[seyman@munshine seyman]$ perl test-pdb.pl
>fields:  11
>records: 13
>Number of fields: 11
>Field names: Datum,,,,,,,,,,
>
>Datum - Art
>5.7.2002---
>9.7.2002---
>20.7.2002---
>15.8.2002---
>24.8.2002---
>25.8.2002---
>13.9.2002---
>14.9.2002---
>15.9.2002---
>16.9.2002---
>25.9.2002---
>7.10.2002---
>30.10.2002---
>All tests are ok
>
>The field names output looks way off, IMHO.
>
Whoops, I tried it on Win98 with Active-Perl and got the same results.

On Linux/Perl 5.8.0 it works ok!

I guess you ran it on Windows?  Or on Perl 5.6.1 ?
There seems to be a difference between perl versions.

I think I'll have to dig into this a little bit more.
I'll probably try to get some pointers in one of the perl related=20
newsgroups.

See you,
    Uwe

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

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

On Tue, Apr 15, 2003 at 08:03:59PM +0200, Uwe Kloß wrote:
> 
> As an attachment please find:
> 1. the module DB.pm and (put it in the directory Palm where PDB.pm is)
> 2. test-pdb.pl (example how to use it) and
> 3. Betriebskosten.PDB (example database needed by 2.)

[seyman@munshine seyman]$ perl test-pdb.pl
fields:  11
records: 13
Number of fields: 11
Field names: Datum,,,,,,,,,,

Datum - Art
5.7.2002---
9.7.2002---
20.7.2002---
15.8.2002---
24.8.2002---
25.8.2002---
13.9.2002---
14.9.2002---
15.9.2002---
16.9.2002---
25.9.2002---
7.10.2002---
30.10.2002---
All tests are ok

The field names output looks way off, IMHO.

> I have 2 (Pilot-Db) databases one has 58 and the other B8 (both hex) as
> AppInfo offset. They have different record numbers. So this might be due
> to something called record index. The second one is my test DB. (0xB8=184)

Looking into this, I realize that I've worked on pilot-db conversion scripts
more than I've used pilot-db itself. :-)

One thing I've noticed about the AppInfo blocks in my pdf files is that
their offset is always a multiple of 4 (and often a multiple of 8).
I'm guessing those 2 bytes are filers and that the correct thing to do is
ignore them.

Emmanuel

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

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

Emmanuel Seyman wrote:

>>Also it is not yet possible to change the AppInfo.
>>(I.e.: Defaults, Database structure, etc.)
>>    
>>
>Isn't possible to use PackAppInfoBlock() to create/modify
>an AppInfo block?
>
Yes!
As soon as I've added code who does so! ;-)
Just started hacking today.

But don't hold your breath!
I've got an appointment at the movies tonight. ;-)

>>I would like some input on other versions of Pilot-Db
>>and general comments as well ofcourse.
>>Someone like to volunteer?
>>    
>>
>Oh yes, oh yes, oh yes :-)
>
I was hoping for such an answer! ;-)

As an attachment please find:
1. the module DB.pm and (put it in the directory Palm where PDB.pm is)
2. test-pdb.pl (example how to use it) and
3. Betriebskosten.PDB (example database needed by 2.)

You also need Perl5 and the P5-Palm package.
Try the latest release 1.3.0!
I had some problems with earlier versions.

>>When writing back the data to a palm file, some of the Header
>>bytes (PDB header, not AppInfo) get zeroed out.
>>(Offsets into the file are 16-32 and 183-184)
>>    
>>
>Bytes 16-32 are the second half of the field "Name" . For a
>pilot-db file, this should contain the name of the database, the
>extra bytes being zeroed out.
>
So no need to worry! :-)
Thanks!

But if it's specified they should be zeroed, then probably pilot-db 
should do
some cleanup there also. The database I retrieved via hotsync from my Palm
contained garbage in this place.

>All the pilot-db databases I've ever handled have an AppInfo offset
>of 88 which means that the pdb header is 136 bytes long. I have no idea
>what bytes 182 and 183 contain.
>
Taking your hint on the offsets I looked at PDB.pm one more time and did a
printout of file offsets.
I have 2 (Pilot-Db) databases one has 58 and the other B8 (both hex) as
AppInfo offset. They have different record numbers. So this might be due
to something called record index. The second one is my test DB. (0xB8=184)

I think that these two bytes might be the mysterious 2 NUL bytes just 
before
the AppInfo block. The author of PDB.pm seems to have had some trouble when
expecting/reading them. He made explicitely sure that they are ignored.

So no need to worry either! :-)
This is a happy day! :-)

See you,
    Uwe

Re: [pilot-db-list] import databases

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

In <3ED...@tw...>, g.c.tijssen_pop.hccnet.nl <g.c...@hc...> typed:
> Hello,
> So what's next....??
> I can export the Sienna database in several formats .dbf, *.csv, Microsoft 
> access format
>
> But how can I import this data into pilot-db?

You want to install the palm-db tools on your desktiop machine. They
can convert csv files to pilot-db databases. Follow the db-tools link
at <URL: http://pilot-db.sf.net/ > to get them.

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

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

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

On Tue, Apr 15, 2003 at 05:07:59PM +0200, Uwe Kloß wrote:
> 
> I'm on the way of implementing a helper class for this
> package that can be used just like the others (Memo, Address,...)
> to access the contents of Pilot-Db files.

Sounds very neat!

> Also it is not yet possible to change the AppInfo.
> (I.e.: Defaults, Database structure, etc.)

Isn't possible to use PackAppInfoBlock() to create/modify
an AppInfo block?

> I would like some input on other versions of Pilot-Db
> and general comments as well ofcourse.
> Someone like to volunteer?

Oh yes, oh yes, oh yes :-)

> When writing back the data to a palm file, some of the Header
> bytes (PDB header, not AppInfo) get zeroed out.
> (Offsets into the file are 16-32 and 183-184)

From what I've been able to deduce:

Bytes 16-32 are the second half of the field "Name" . For a
pilot-db file, this should contain the name of the database, the
extra bytes being zeroed out.

All the pilot-db databases I've ever handled have an AppInfo offset
of 88 which means that the pdb header is 136 bytes long. I have no idea
what bytes 182 and 183 contain.

Emmanuel

[pilot-db-list] Yet another perl module

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

Hi,

out there on CPAN there is the p5-Palm pakage to access
the backup database files after sync and as a add-on to
coldsync (IIRC).

I'm on the way of implementing a helper class for this
package that can be used just like the others (Memo, Address,...)
to access the contents of Pilot-Db files.

It is capable to read a database, acess and change the basic
data types, write the data back to a new file and have this
synchronized back to the palm.

Fields/types not yet supported for using or changing are:
     Link,Linked,Calculated,Note.
These are just (hopefully) copied back as they were read.

Also it is not yet possible to change the AppInfo.
(I.e.: Defaults, Database structure, etc.)

It has been tested on Pilot-Db 1.0.3 so far.

I would like some input on other versions of Pilot-Db
and general comments as well ofcourse.
Someone like to volunteer?

For those familiar with the P5-Palm package I've got a direkt question:

When writing back the data to a palm file, some of the Header
bytes (PDB header, not AppInfo) get zeroed out.
(Offsets into the file are 16-32 and 183-184)

This does not seem to prevent reading them back to the palm device.
Can anyone comment on that?

See you,
    Uwe

[pilot-db-list] import databases

[g.c.tijssen_pop.hccnet.nl <g.c...@hc...>]

Hello,

I previously used a Psion Sienna and would like to import the database 
information from this organiser to my Palm Zire.

As Palm Zire normally doesn't have a database application in which you can 
built your own database I was looking on the web and found pilot-db.

So what's next....??
I can export the Sienna database in several formats .dbf, *.csv, Microsoft 
access format

But how can I import this data into pilot-db?

Hope anyone can help....

Trudie  

[pilot-db-list] Bad records

[<DRR...@ao...>]

Every once in a while I get a bad record in one of my database file.  When 
ever I try to access that record to edit or delete it it crashes my pda.  Is 
there a solution?  Cand you copy a record from one database to another?

Thanks
David

[pilot-db-list] help

[Edwin <edw...@pd...>]

Quoting "pil...@li..."
<pil...@li...>:

> Send Pilot-db-list mailing list submissions to
> 	pil...@li...
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> or, via email, send a message with subject or body 'help' to
> 	pil...@li...
> 
> You can reach the person managing the list at
> 	pil...@li...
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pilot-db-list digest..."
> 
> 
> Today's Topics:
> 
>    1. Mac sync prob solved (Miller (Michael) Michael)
> 
> --__--__--
> 
> Message: 1
> From: "Miller (Michael) Michael" <mm...@pe...>
> To: pil...@li...
> Date: Wed, 9 Apr 2003 00:18:00 -0500
> Subject: [pilot-db-list] Mac sync prob solved
> 
> Mac sync problem solved
> 
> After the crash, I found that when I transfered the backup files to
> restore the palm, I was 
> using version 1.03 and have since downloaded version 1.04 and it now
> works when 
> transferred with OS X and Palm Desktop 4.0. I did not have to
> retransfer the dbs, but 
> was able to read the previously unreadable db files on the palm when I
> upgraded.
> 
> Thanks, great db app,
> Michael Miller
> 
> This email has been scanned for viruses by MessageLabs.
> 
> 
> 
> --__--__--
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 
> 
> End of Pilot-db-list Digest
> 



---------------------------------------------------------------------------
This e-mail has been sent via JARING webmail at http://www.jaring.my

[pilot-db-list] Re: [pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Edit_the_new_=22about_box=22_in_a_database?=

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

SW4gPEhEQzBVSyRBM0NDOTA1QzQ2QjMxODJBNTBFNDBDQTJDMzlGMTgyMUBsYXBvc3RlLm5l
dD4sIG1hcmMuY2hhbGFpbkBsYXBvc3RlLm5ldCA8bWFyYy5jaGFsYWluQGxhcG9zdGUubmV0
PiB0eXBlZDoNCj4gVGhpcyBib3ggY2FuIGJlIGVkaXRlZCBvbmx5IHdpdGggcGFsbS1kYi10
b29scyAwLjMuNS4gVGhpcw0NCj4gcmVsZWFzZSBvZiBwYWxtLWRiLXRvb2xzIGlzIG5vdCB5
ZXQgYXZhaWxsYWJsZS4gSSBtdXN0IGNsZWFuDQ0KPiB0aGUgY29kZSBhbmQgdGhlIGJ1aWxk
Lg0NCg0KSXMgdGhlIGNvZGUgY2xlYW51cCBnb2luZyB0byBiZSB0byB0aGUgZXh0ZW50IHRo
YXQgdGhleSB3aWxsIGJ1aWxkIG9uDQpVbml4IHN5c3RlbXMgYWdhaW4/IFRoYXQgcXVpdCB3
b3JraW5nIGFzIG9mIDAuMy4xIG9yIHRoZXJlYWJvdXRzLg0KDQoJPG1pa2UNCi0tIA0KTWlr
ZSBNZXllciA8bXdtQG1pcmVkLm9yZz4JCWh0dHA6Ly93d3cubWlyZWQub3JnL2NvbnN1bHRp
bmcuaHRtbA0KSW5kZXBlbmRlbnQgTmV0d29yay9Vbml4L1BlcmZvcmNlIGNvbnN1bHRhbnQs
IGVtYWlsIGZvciBtb3JlIGluZm9ybWF0aW9uLg==

[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_Edit_the_new_=22about_box=22_in_a_database?=

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

This box can be edited only with palm-db-tools 0.3.5. This=0D=0Arelease o=
f palm-db-tools is not yet availlable. I must clean=0D=0Athe code and the=
 build.=0D=0A=0D=0A---------- Debut du message initial -----------=0D=0A=0D=
=0ADe     : pil...@li...=0D=0AA      : <pilo=
t-d...@li...>=0D=0ACopies : =0D=0ADate   : Fri, 11 Apr=
 2003 18:17:38 +0200=0D=0AObjet  : [pilot-db-list] Edit the new "about bo=
x" in a database=0D=0A=0D=0AHello=0D=0A=0D=0AI have one single question.=0D=
=0A=0D=0AIs there a way to edit the new "about box" in a database=0D=0Ave=
rsion 1.0.4.=0D=0A=0D=0AMany thanks=0D=0A=0D=0APeter=0D=0A=0D=0A=0D=0A=0D=
=0A=0D=0A-------------------------------------------------------=0D=0AThi=
s SF.net email is sponsored by: Etnus, makers of TotalView,=0D=0AThe debu=
gger =0D=0Afor complex code. Debugging C/C++ programs can leave you=0D=0A=
feeling lost and =0D=0Adisoriented. TotalView can help you find your way.=
 Available=0D=0Aon major UNIX =0D=0Aand Linux platforms. Try it free. www=
.etnus.com=0D=0A_______________________________________________=0D=0APilo=
t-db-list mailing list=0D=0AP...@li...=0D=0Ahttp=
s://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0AAcc=E9d=
ez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3615 LAP=
OSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A

RE: [pilot-db-list] some ideas

[KANE P. (CA) <Pet...@er...>]

re" 2. copy-paste in note fields" - I had this problem once, but was unable=
 to repeat it.

-----Original Message-----
From: pil...@li...
[mailto:pil...@li...]On Behalf Of Fabrice
Noilhan
Sent: Saturday, 12 April 2003 2:57
To: pil...@li...
Subject: [pilot-db-list] some ideas


Hi,

Thanks for this great app!
using pilotdb (1.1b2) for a couple a months, I have some suggestions, yet=
 not
the time to start to implement them. I may have missed some obvious tricks,
so feel free to comment these ideas!

1. "set" instruction
It would be nice if one could use scripts to set fields. For instance,
I have a todo-list database. I would like to ease my work using views:
a normal view and a special "to be done today" view. With a script, I
would like to be able to set the deadline to today when I create a new
record using the "to be done today" view.

2. copy-paste in note fields
I am not able to use copy-paste in note fields. Doing this would be
quite convenient.=20

3. Title and note fields
I do not fully understand the "make first line title" checkbox. When
I check this while writing a note, it works. But the status of this
checkbox does not seem to be stored anywhere thus creating some=20
synchronisation issues.=20
So I would rather prefer to have in the note field a  first line
labelled "title" which I could fill or not.

Moreover it is difficult to know whether a note is empty or not. Wouldn't
it be possible to have something to show that?

4. link with Datebook and Todolist
I enjoy the addressbook plugin and would appreciate the above-mentioned
plugins as well!

5. Bug-report?
Using a list component, with defaults value A, B and C, I can create
numerous records and run a "report" on this field. Say 8 A, 4 B, 3 C, 0=
 Other.
I add then another possible value "D" to the list field, rebuild the=20
database. Then adding 1 "D" record and running report again.
It reports 8 A, 4 B, 3 C and 1 Other.=20
Rescanning the base does not help.

  Fabrice




This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is=
 of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
Ergon Energy Pty Ltd      ABN 66 078 875 902

Re: [pilot-db-list] some ideas

[<har...@ih...>]

Like Fabrice Noilhan and others, I am very pleased with pilotdb, and I'm grateful for this great program.

I have been using scripts quite a bit, and from my point of view, the suggestion which is the top of my wish list would 
be a set of say 10 constants stored with each database which could be entered via a dialogue invoked from the menu, 
and then used within a script as e.g %k3 or whatever. That alone would increase the versatility enormously.

If a script could also write to these constants, so much the better. 


Barry Harridge

Re: [pilot-db-list] DB Format

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

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

I got no replies, did this get lost in the ether?

/ Norman Walsh <nd...@nw...> was heard to say:
| |> A lot of developpers ask us the update of the Format.txt file
| |> which describes the format of the database of Pilot-DB.
| |> I join here the new file, that you will be able to find with
| |> the next releases.
| |> 
| |> Send us your questions or the parts to update.
|
| Ok, I'm looking at the appinfo from my test database and it looks like
| this:
|
| appinfo  :
| 00.00.00.09.00.00.00.32.73.74.72.69.6E.67.00.62
|   .  .  .  .  .  .  . 2. s. t. r. i. n. g.  . b
| 6F.6F.6C.00.69.6E.74.00.66.6C.6F.61.74.00.64.61
|  o. o. l.  . i. n. t.  . f. l. o. a. t.  . d. a
| 74.65.00.74.69.6D.65.00.6C.69.73.74.31.00.6C.69
|  t. e.  . t. i. m. e.  . l. i. s. t. 1.  . l. i
| 6E.6B.00.6C.69.6E.6B.65.64.00.00.01.00.12.00.00
|  n. k.  . l. i. n. k. e. d.  .  .  .  .  .  .  
| 00.01.00.02.00.08.00.03.00.04.00.06.00.07.00.0A
|   .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  
| 00.02.00.10.00.06.00.03.0C.00.6F.6E.65.00.74.77
|   .  .  .  .  .  .  .  .  .  . o. n. e.  . t. w
| 6F.00.33.00.00.02.00.24.00.07.4D.6F.76.69.65.73
|  o.  . 3.  .  .  .  . $.  .  . M. o. v. i. e. s
| 00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
|   . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  
| 00.00.00.00.00.00.00.00.00.00.00.03.00.41.00.04
|   .  .  .  .  .  .  .  .  .  .  .  .  . A.  .  
| 00.00.00.00.00.80.00.02.00.00
|   .  .  .  .  .  .  .  .  .  
|
| Going through the header, I find:
|
|   flags    : 0
|   numChunks: 9
|
| Ok so far.
|
|   chunk 0
|           0
|           50
|           string,bool,int,float,date,time,list1,link,linked
|
| The field names...
|
|   chunk 1
|           1
|           18
|           0,1,2,8,3,4,6,7,10
|
| The field types...
|
|   chunk 2
|           2
|           16
|           6[6], 3, 3072
|                   one,two,3
|
| The list of values for field 6...
|
|   chunk 3
|           2
|           36
|           7[7], 76694d6f, 25971
|
| Ok, chunk 3 is of type 2 and it's for field number 7 which is type 7
| (coincidentally). Type 7 is a link, so this chunk should contain:
|
|   Link Field Type:
|     UInt16 fieldNum
|     UInt32 recordID (of the ChooserDB record corresponding to the database.)
|     UInt16 filedNum (of the record to display.)
|
| But it's length is 36 which seems really odd. And the actual data in the field
|
|   00.02.00.24.00.07.4D.6F.76.69.65.73
|     .  .  . $.  .  . M. o. v. i. e. s
|   00.2E.00.00.00.00.00.00.00.00.00.00.00.00.00.00
|     . ..  .  .  .  .  .  .  .  .  .  .  .  .  .  
|
| doesn't look like it corresponds. It looks more like the name of the linked
| database is in there.

                                        Be seeing you,
                                          norm

- -- 
Norman Walsh <nd...@nw...> | Some people tell you you should not
http://nwalsh.com/            | drink claret after strawberries. They
                              | are wrong.--William Maginn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.7 <http://mailcrypt.sourceforge.net/>

iD8DBQE+mcrVOyltUcwYWjsRAiyfAJ9t8LRD7+EatV5Ln7Rt/2oT3Ze9OwCfSwo+
AcaeGFakclqGoH77QH1ZFy8=
=Q7Eg
-----END PGP SIGNATURE-----

[pilot-db-list] Test of Palm -> Mac tool

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

I have finally had the time to put together a beta for a Pilot-DB
translator for MPC <http://www.mootjelitt.com/mpc.html>.=20

I'm not a user of Pilot-DB myself so I'm not the best person to test
it (this beta version have only had VERY limited testing) so I would
be very grateful if you could test it and see what works and what
doesn't (I'm pretty sure there are some bugs for calculated fields).

You can download the program at <http://www.mootjelitt.com/MPC1.8b3.sit>


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

Re: [pilot-db-list] Missing something (again)

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

2003-04-11 15:18: Scott Wallace <swa...@my...> is
believed to have typed:

>   Perhaps you are looking at the wrong appinfo chunk?

Duh ... I better go to bed. I started to read the chunk block (I forgot
that it was there, sorry)

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

Re: [pilot-db-list] Missing something (again)

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

On Fri, 11 Apr 2003, Jan Erik Mostr=F6m wrote:

> I decided to finish my Pilot-DB =3D> Mac translator this weekend (befor=
e I
> once again get something else to do 8-) and as usual I seem to be
> missing something.
>=20
> When I look in the appinfo block to check the field types I get


	These don't look right to me.  Shouldn't you see=20
	00 00 -> String
	00 01 -> Boolean
	00 02 -> Integer=20
	etc

	as given by the DB_Create function in db3.c ?

	This also corresponds to marc's translation of the app info block=20
we examined a few weeks ago.

	Perhaps you are looking at the wrong appinfo chunk?

	-Scott

[pilot-db-list] Missing something (again)

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

I decided to finish my Pilot-DB =3D> Mac translator this weekend (before I=

once again get something else to do 8-) and as usual I seem to be
missing something.

When I look in the appinfo block to check the field types I get

0001 =3D> String
0010 =3D> Note
0000 =3D> Boolean
0005 =3D> Integer
0001 =3D> Float
0002 =3D> Date
0008 =3D> Time
0003 =3D> List

What I understand is why I see 1 both for String and Float ... I'm sure
I'm missing something but what?

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

[pilot-db-list] some ideas

[Fabrice N. <fab...@no...>]

Hi,

Thanks for this great app!
using pilotdb (1.1b2) for a couple a months, I have some suggestions, yet not
the time to start to implement them. I may have missed some obvious tricks,
so feel free to comment these ideas!

1. "set" instruction
It would be nice if one could use scripts to set fields. For instance,
I have a todo-list database. I would like to ease my work using views:
a normal view and a special "to be done today" view. With a script, I
would like to be able to set the deadline to today when I create a new
record using the "to be done today" view.

2. copy-paste in note fields
I am not able to use copy-paste in note fields. Doing this would be
quite convenient.

3. Title and note fields
I do not fully understand the "make first line title" checkbox. When
I check this while writing a note, it works. But the status of this
checkbox does not seem to be stored anywhere thus creating some 
synchronisation issues. 
So I would rather prefer to have in the note field a  first line
labelled "title" which I could fill or not.

Moreover it is difficult to know whether a note is empty or not. Wouldn't
it be possible to have something to show that?

4. link with Datebook and Todolist
I enjoy the addressbook plugin and would appreciate the above-mentioned
plugins as well!

5. Bug-report?
Using a list component, with defaults value A, B and C, I can create
numerous records and run a "report" on this field. Say 8 A, 4 B, 3 C, 0 Other.
I add then another possible value "D" to the list field, rebuild the 
database. Then adding 1 "D" record and running report again.
It reports 8 A, 4 B, 3 C and 1 Other. 
Rescanning the base does not help.

  Fabrice

[pilot-db-list] Edit the new "about box" in a database

[Peter S. <ge...@ly...>]

Hello

I have one single question.

Is there a way to edit the new "about box" in a database version 1.0.4.

Many thanks

Peter

[pilot-db-list] No hi-res fonts on Sony Clie T615C?

[Joseph M. R. Jr. <re...@mi...>]

I'm using pilot-db 1.1.0B1. The instruction say when first used it
should've asked me if I wanted to use tiny fonts (it didn't) and even
though I click hi-res in the option, the fonts are still normal size. I
use small fonts with Datebk4. Do I also need to have special fonts
installed? Thanks!

[pilot-db-list] Mac sync prob solved

[Miller (M. M. <mm...@pe...>]

Mac sync problem solved

After the crash, I found that when I transfered the backup files to restore the palm, I was 
using version 1.03 and have since downloaded version 1.04 and it now works when 
transferred with OS X and Palm Desktop 4.0. I did not have to retransfer the dbs, but 
was able to read the previously unreadable db files on the palm when I upgraded.

Thanks, great db app,
Michael Miller

This email has been scanned for viruses by MessageLabs.