pilot-db-list

[pilot-db-list] another feature request

[Bastian Brn. <bh...@gm...>]

Hi,
I have aswell tried this database software and consider it very useful.
The only thing I miss are import and export functions to and from
ASCII-based Text-Files, because as a Mac user I can't use any of the PC
converter programs.
And importing data from my desktop computer to the Pilot DB on my Visor/Palm
would be very useful as I have a lot of data...
The reverse action (Palm to Desktop Mac) would also be very useful, e.g.
when adding a lot of new data to an existing database.

Regards,
Bastian Bruninghaus 

[pilot-db-list] feature request

[Leiss, Klaus-G. 3. PPE-E. <Kla...@de...>]

Hello,
The DB palm pilot utility is great. I've been using MobileDB
to keep some databases with me. I think it is as good as
MobileDB the only MobileDB features that I miss  are

1. Clone record
   With this an user editing data on the pilot could use an
   existing similar record to generate much of the new data.

and 

2. changing records in edit mode
   Here I mean go to next or previous record


Nice to have features that even MobileDB does not have are

3. Regular expressions in find. At least it should be possible
    to anchor a search lets say with a ^ to the beginning of the
    field and a $ to the end of the field as in most UNIX programs.
    With this somebody locking for the start of all records beginning
    with s could search for ^S and would be there.

4. Boolean finds.
   record contains  a and b in one field
   record contains  a in one field and b in a second field
   record contains  a or  b 

All this features are not critical, so all what I want you to do is,
if you have a list with features that should be added to the
database put them in this list. If somebody is kind enough to
implement them I will be lucky, but if not the database is still
useable

With kind Regards

Klaus Leiss

[pilot-db-list] RE: documentation request

[Chalain Marc<mar...@vo...>]

I changed a lot of things in the UI and i can't write a stable documentation now. But i promess you a html documentation for the 0.3.2 release (i hope a beta before the end of the month and the release at september).
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

[pilot-db-list] documentation request

[Nathan H. <na...@ma...>]

The DB palm pilot utility is fantastic. I've been using MobileDB Lite
to keep a copy of Palm Bar with me. I recently installed DB and found
that it does everything I wanted. Great work, Tom! 

My only gripe is that I didn't even realise DB did MobileDB files! As
near as I could tell it isn't documented on the webpage or inside the
README included with the package. Can this be fixed?

-- 
The more I know about the WIN32 API the more I dislike it. It is complex and
for the most part poorly designed, inconsistent, and poorly documented.
                                                                - David Korn

Re: [pilot-db-list] exporting db

[Tom D. <td...@us...>]

On Thursday 14 June 2001 03:48 pm, Carson Wilcox wrote:

> I have currently three databases and they all appear
> in a single file, DBDatabases.pdb.
>
> My question is, how to I get a single database out so
> I can convert it to a csv file using pdb2csv?
>
> I'm using DB 0.3.1.

The DBDatabases.pdb file is the internal database used by the database picker 
screen to store the category and order that your databases appear in the 
picker.

Set the backup flag on the databases that you want on the desktop by opening 
them on your PDA. Go to the "Options" menu and pick "DB Preferences". Check 
the "Backup database at HotSync" flag. Press OK. Run a HotSync.

The databases will then be on your desktop system in the backup folder. The 
files will be named according to the database title.

[pilot-db-list] exporting db

[Carson W. <car...@ya...>]

I'm new to this list and appologize if this has been
asked before.

I have currently three databases and they all appear
in a single file, DBDatabases.pdb.

My question is, how to I get a single database out so
I can convert it to a csv file using pdb2csv?

I'm using DB 0.3.1.

Thanks,
Carson

__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

[pilot-db-list] exporting db

[Carson W. <car...@ya...>]

I'm new to this list and appologize if this has been
asked before.

I have currently three databases and they all appear
in a single file, DBDatabases.pdb.

My question is, how to I get a single database out so
I can convert it to a csv file using pdb2csv?

I'm using DB 0.3.1.

Thanks,
Carson

__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

[pilot-db-list] new list for CVS log messages

[Tom D. <td...@us...>]

I just created and tested a new mailing list which will receive the log 
messages that are given to CVS when files changes. This will allow anyone to 
keep track of the development automatically. It also will allow the log 
messages to be archived by SourceForge like normal mail. The mailing list is 
not for normal discussion like this list but rather just exists so people can 
receive the automated CVS emails.

The mailing list is called:

  pil...@li...

If you would like to subscribe, please visit the following Web site for 
instructions:

  http://lists.sourceforge.net/lists/listinfo/pilot-db-commits

Normal announcements will still happen on this list. The new list is just for 
developers and other interested people to see how the DB source code changes 
near to the moment that it is changed.

Re: [pilot-db-list] problem converting from MobileDB->CSV format.

[Tom D. <td...@us...>]

On Sunday 03 June 2001 04:38 am, Mark D. Baushke wrote:

> In attempting to convert a database modified by the MobileDB v2.1
> application, I ran into a problem where I was getting the error
> message.
>
> 'test1.pdb: maximum number of fields exceeded'
>
> At the time of the error, the value of field is 20 and the value of
> getMaxNumOfFields() is 20. Making a small change (below), seems to
> have worked around the problem for me. (The odd thing with this data
> is that no record actually has more than 14 fields.) A copy of the
> test1.pdb to test this one is available via

It seems that they encoded 21 fields in the record which stores the pixel 
widhts for the column view. Run "pilot-file -v test1.pdb" using the 
pilot-file program in the pilot-link package and you will see a dump of the 
records. I'll turn the error into a warning instead and just ignore it in the 
next version.

[pilot-db-list] problem converting from MobileDB->CSV format.

[Mark D. B. <md...@em...>]

Greetings,

In attempting to convert a database modified by the MobileDB v2.1
application, I ran into a problem where I was getting the error
message.

'test1.pdb: maximum number of fields exceeded'

At the time of the error, the value of field is 20 and the value of
getMaxNumOfFields() is 20. Making a small change (below), seems to
have worked around the problem for me. (The odd thing with this data
is that no record actually has more than 14 fields.) A copy of the
test1.pdb to test this one is available via

  http://www.employees.org/~mdb/mobiledb-data/ 

as the test1.pdb (55k) file.

The next problem I have run into is with a database created directly
on the Pam using MobileDB v2.1. The pdb2csv error returned is 

'test2.pdb: data record has the wrong number of fields'

A copy of the test2.pdb to test this one is available via

  http://www.employees.org/~mdb/mobiledb-data/

as the test2.pdb (1k) file.

I am not sure of the correct fix for the test2.pdb case.

If you have any suggestions, I'd appreciate hearing about them.

	Thank you,
	-- Mark

--- palm-db-tools-0.3.2/libflatfile/MobileDB.cpp.orig	Sat Oct 14 22:45:23 2000
+++ palm-db-tools-0.3.2/libflatfile/MobileDB.cpp	Sun Jun  3 01:29:04 2001
@@ -213,7 +213,7 @@
         if (field == 0xFF) break;
 
 	// Make sure that we don't go beyond the maximum number of fields.
-	if (field >= getMaxNumOfFields())
+	if (field > getMaxNumOfFields())
 	    throw PalmLib::error("maximum number of fields exceeded");
 
 	// Expand the fields vector if this field goes beyond the end

[pilot-db-list] palm-db-tools 0.3.2

[Tom D. <td...@us...>]

Version 0.3.2 of palm-db-tools is now releases. I'll place the Windows 
version up on the site soon. The source code is there now. It is the same as 
the last beta except it is now final. :)

Visit http://palm-db-tools.sourceforge.net/ for more information including 
the download link.

-Tom

[pilot-db-list] Scroll buttons in the record edit view

[Brian F. <bri...@ei...>]

Hi,
I'd noticed that when editing records in db, pressing the hardware up and
down buttons wouldn't scroll through the fields. Here's a quick patch that
makes the buttons behave in the same way as the up and down arrows on the
screen.

Cheers,
Brian.

--- edit.c~	Thu May 31 00:19:16 2001
+++ edit.c	Thu May 31 00:16:47 2001
@@ -1127,6 +1122,18 @@
 	    return HandleCommonMenuEvent(event->data.menu.itemID);
 	}
 	break;
+
+    case keyDownEvent:
+        switch (event->data.keyDown.chr) {
+        case pageUpChr:
+            EditViewScroll(winUp);
+            break;
+
+        case pageDownChr:
+            EditViewScroll(winDown);
+            break;
+        }
+        break;

     default:
 	break;

[pilot-db-list] main record view

[Brian F. <bri...@ei...>]

Hi,

In the main record list view in db there seems to be a few pixels of slack
space underneath the columns label, and above the button bar.

Applying the patch below means you can see 10 records at a time from your
database rather than 9.

I checked the patch using a column title with descenders in it (eg
'Buffyqg') and it fit just fine.

Cheers,
Brian.

--- db.rcp~	Wed May 30 23:45:28 2001
+++ db.rcp	Wed May 30 23:56:15 2001
@@ -108,7 +108,7 @@
 BEGIN
   TITLE ""

-  GADGET ID ctlID_ListView_Grid AT (0 20 160 111) USABLE
+  GADGET ID ctlID_ListView_Grid AT (0 16 160 128) USABLE
   CHECKBOX "" ID ctlID_ListView_GridCheckbox AT (0 0 10 10) NONUSABLE

   BUTTON "Done" ctlID_ListView_DoneButton AT (1 Bottom@159 AUTO AUTO)
USABLE FRAME

Re: [pilot-db-list] transfer of maintainership

[Fab <kr...@bi...>]

> Make an account on SourceForge. Then permissions to edit the Web site and 
> also to put documentation in the shared source code repository can be enabled.
	Ok.

> [To everyone:] On a seperate matter, what should I do about palm-db-tools? It 
> is a C++ library and C++ programs. I never made a final 0.3.2 release with 
> the date/time functionality. And SourceForge turned off the ftp access, so 
> the beta is no longer accessible. Any thoughts?

	I think you could make the final release because I use the tools
with date/time since the first beta and it works great for me.

	Fab.

Re: [pilot-db-list] transfer of maintainership

[Chalain M. <mar...@vo...>]

If i have not problem with sourceforge ( i can't access to it at this moment :( ), i will update CVS tree with all my modifications this night or tomorow. I suggest to you to cross the CVS tree this week-end, not before.
thank you a lot for all your help,
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re: [pilot-db-list] transfer of maintainership

[Larry W. V. <lv...@ca...>]

Can you do a 'beta release' of the code as it is?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden <mailto:lv...@ca...> <URL: http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
-><-

Re: [pilot-db-list] transfer of maintainership

[Tom D. <td...@us...>]

On Tuesday 29 May 2001 01:42 pm, you wrote:

> > I'll be happy if some body can help me. I need help
> >to develop also to try the versions before a release,
> >to package a release (multi-language, README, documentation
> >in html), to maintaine the web site....
>
> 	Ok, I have no time to help developping, but I can
> help testing the code, for I'm actually using DB to store
> all sort of things in my palm. I may have some time to translate
> things from english to french, or produce some HTML code,
> depending of the moment. Contact me when you need.

Make an account on SourceForge. Then permissions to edit the Web site and 
also to put documentation in the shared source code repository can be enabled.

[To everyone:] On a seperate matter, what should I do about palm-db-tools? It 
is a C++ library and C++ programs. I never made a final 0.3.2 release with 
the date/time functionality. And SourceForge turned off the ftp access, so 
the beta is no longer accessible. Any thoughts?

Re: [pilot-db-list] transfer of maintainership

[Fab <kr...@bi...>]

> I'll be happy if some body can help me. I need help 
>to develop also to try the versions before a release,
>to package a release (multi-language, README, documentation
>in html), to maintaine the web site....

	Ok, I have no time to help developping, but I can
help testing the code, for I'm actually using DB to store
all sort of things in my palm. I may have some time to translate
things from english to french, or produce some HTML code,
depending of the moment. Contact me when you need.
	Fab.

Re: [pilot-db-list] transfer of maintainership

[Larry W. V. <lv...@ca...>]

Marc, have you noticed my reports of potential incompatibility between the 
utilities and the most recent version of DB?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden <mailto:lv...@ca...> <URL: http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
-><-

Re:[pilot-db-list] transfer of maintainership

[Chalain M. <mar...@vo...>]

I'm very proud to work for DB, Tom worked hard on DB and now it's usefull. I think not a lot of thing is lacking to it to do a professionnal util.
I'll be happy if some body can help me. I need help to develop also to try the versions before a release, to package a release (multi-language, README, documentation in html), to maintaine the web site....
bye,
Marc.

__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

[pilot-db-list] transfer of maintainership

[Tom D. <td...@us...>]

Due to a lack of time (and my Palm III failing and me switching to a 
Linux-based PDA), I won't be working on DB any more. Marc Chalain, whose 
email you may have seen, has shown some interest in developing DB.

Thus, I am asking if anyone else has an interest in developing DB. If so, 
please contact me. That way, if there is interest from more than one person, 
some sort of shared maintainership or other arrangement can be made.

Because the source code is on SourceForge and is stored in a CVS repository, 
shared developement is not a problem.

I will still be around and will help out a little but I cannot be the primary 
developer any more.

Re: [pilot-db-list] Build failure

[Marty B. <mar...@mj...>]

After re-R'ing TFM, I see the error of my way; I failed to install
the sdk update (sdk35update1).  DB now compiles ok.

Now I've got problems w/ pilrc to work out.  It won't compile on
my Linux box; throws a bunch of token-pasting errors from the
precompiler.  I assume this is just more fallout from Redhat-7 and
the bunged gcc it ships with because pilrc builds fine on my HP/9000
w/ gcc-2.95.2 (after removing trailing CRs from the source files).

The only RPM for pilrc I could find is version 2.5, which the DB
build doesn't like (TFM sez 2.7 is req'd).

Guess I'll have to rebuild my Palm development environment over on
the HP.

-- 
Marty Bower


On Sun, May 27, 2001 at 12:44:58PM -0400, Tom Dyas wrote:

> On Sunday 27 May 2001 12:41, Marty Bower wrote:
> 
> > I suspect that my prctools setup isn't quite right (as evidenced
> > by the sdkfind warnings on every invocation), however I am able to
> > build and run a HelloWorld.
> 
> Read the file db/docs/building.txt which is included with the source code.
> 
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> http://lists.sourceforge.net/lists/listinfo/pilot-db-list

[pilot-db-list] new features

[Chalain M. <mar...@vo...>]

In few days you will see new features in the CVS tree:
Support of plugins.
Configuration of the compilation: extract MobileDB and JFile3 support, extract Plugins support...
Plugins directory with MobileDB and JFile3 support plugin, sample plugin
Sort by tape on the header of a column of the list view.
"Duplicate Record" menu entry in the list view.

But i need you to know what i should modify or add. Example: i can extract the sort editor of Tom from the main application and build a plugin with it. Or which kind of plugin will you see for DB.

I would like develop a plugin to build a database with informations from a mySQL database server. What do you think about that??

I'm interested by all of your points of view.
Marc.
__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

Re: [pilot-db-list] Build failure

[Tom D. <td...@us...>]

On Sunday 27 May 2001 12:41, Marty Bower wrote:

> I suspect that my prctools setup isn't quite right (as evidenced
> by the sdkfind warnings on every invocation), however I am able to
> build and run a HelloWorld.

Read the file db/docs/building.txt which is included with the source code.

[pilot-db-list] Build failure

[Marty B. <mar...@mj...>]

I can't seem to build db-0.3.1 on my Linux box (complete listing
attached):

m68k-palmos-gcc -g -o db db-sections.ld db-sections.o main.o list.o chooser.o design.o io.o util.o listprop.o prefs.o
find.o linkaware.o grid.o edit.o sort.o names.o MobileDB.o JFile3.o -lPalmOSGlue
sdkfind: warning: /usr/local/palmdev/sdk does not exist
/usr/local/m68k-palmos/lib/gcrt0.o(.text+0x50):crt0.c: relocation truncated to fit: DISP16 __do_bhook
/usr/local/m68k-palmos/lib/gcrt0.o(.text+0x5a):crt0.c: relocation truncated to fit: DISP16 __do_ctors
/usr/local/m68k-palmos/lib/gcrt0.o(.text+0x60):crt0.c: relocation truncated to fit: DISP16 _GdbStartDebug
/usr/local/m68k-palmos/lib/gcrt0.o(.text+0x78):crt0.c: relocation truncated to fit: DISP16 __do_dtors
/usr/local/m68k-palmos/lib/gcrt0.o(.text+0x82):crt0.c: relocation truncated to fit: DISP16 __do_ehook
db-sections.o(.text+0x2):db-sections.s: relocation truncated to fit: DISP16 _GccLoadCodeAndRelocateData
/usr/local/m68k-palmos/lib/libcrt.a(hooks.o)(.text+0x16):hooks.c: relocation truncated to fit: DISP16 start
/usr/local/m68k-palmos/lib/libcrt.a(hooks.o)(.text+0x64):hooks.c: relocation truncated to fit: DISP16 start
/usr/local/m68k-palmos/lib/libcrt.a(hooks.o)(.text+0xa6):hooks.c: relocation truncated to fit: DISP16 start
/usr/local/m68k-palmos/lib/libcrt.a(hooks.o)(.text+0xe0):hooks.c: relocation truncated to fit: DISP16 start
/usr/local/m68k-palmos/lib/libcrt.a(gdbstub.o)(.text+0x3c):gdbstub.c: relocation truncated to fit: DISP16 start
/usr/local/m68k-palmos/lib/libcrt.a(multi_dreloc.o)(.text+0xe):dreloc.c: relocation truncated to fit: DISP16 start
collect2: ld returned 1 exit status

I suspect that my prctools setup isn't quite right (as evidenced
by the sdkfind warnings on every invocation), however I am able to
build and run a HelloWorld.

Here's the gcc that I'm using:

marty@linux:db-0.3.1$ m68k-palmos-gcc -v
sdkfind: warning: /usr/local/palmdev/sdk does not exist
 [/usr/local/m68k-palmos/real-bin/gcc] m68k-palmos-gcc -v -isystem /usr/local/palmdev/include -isystem /usr/local/palmdev/include/Core -isystem /usr/local/palmdev/include/Core/Hardware -isystem /usr/local/palmdev/include/Core/System -isystem /usr/local/palmdev/include/Core/System/Unix -isystem /usr/local/palmdev/include/Core/UI -isystem /usr/local/palmdev/include/Dynamic -isystem /usr/local/palmdev/include/Libraries -isystem /usr/local/palmdev/include/Libraries/INet -isystem /usr/local/palmdev/include/Libraries/PalmOSGlue -L/usr/local/palmdev/lib/m68k-palmos-coff
Reading specs from /usr/local/lib/gcc-lib/m68k-palmos/2.95.3-kgpd/specs
gcc version 2.95.3-kgpd 20010315 (release)

Please point me in the right direction if this is a FAQ.

Thanks.

-- 
Marty Bower