pilot-db-list

[pilot-db-list] no more ftp service on sourceforge

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

The SourceForge people have removed the anonymous ftp service from their 
offering. So it seems, I'll have to put test releases into the normal file 
release mechanism that SourceForge has. After I upload the next test release, 
I'll let you all know the new URL for it.

Re: [pilot-db-list] question about palm-db-tools

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

On Wednesday 23 May 2001 18:08, Larry W. Virden wrote:

> Is version 0.3.2beta2 of the palm-db-tools incompatible with the current
> DB?

It shouldn't be. The only thing I added was the date/time support for the 
0.3.1 release of DB.

Re: [pilot-db-list] Sorting by multiple fields

[Harald Hanche-O. <ha...@ma...>]

+ "Schweikert, Martin {POYD~Kaiseraugst}" <MAR...@Ro...>:

| I wondered if it is possible to sort a table by more than 1
| field. Using v. 0.3.1, I can't figure it out.
| 
| I dug through the mailing list and found the hint to press the "Add"
| button, but I cannot find this button.

Hit the little triangle to the left of the one sorting field.  You get
a popup with two choices:  Insert before and Insert after.

- Harald

[pilot-db-list] question about palm-db-tools

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

Is version 0.3.2beta2 of the palm-db-tools incompatible with the current
DB?

That could explain the problem I am encountering with user reports...
-- 
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.
-><-

[pilot-db-list] HELP!

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

The version of pilot-db that I've been using is dated March 24.  The
version that appears to be most recently released is from April.  The
problem report that I am getting I believe is someone using the April
version.

Is there a known incompatibility between databases able to be read by
the April released DB and the March beta version?  If so, where can I
get a version of the utilities that the April version can read?
-- 
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.
-><-

[pilot-db-list] More on DB problems

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

Note that the user reports downloading DB from the web site and
it generates the same error as the copy I distribute.  He also reports
that if he uses an older version (which, as far as I am aware, was
built using the same csv2pdb!) DB can read the data.

He is using a Visor.

I can send along a file in private email to someone interested in
investigating.
-- 
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.
-><-

[pilot-db-list] User encounters problem accessing DB files.

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

I make a zip available containing DB and a set of databases relating
to Pokemon trading cards, books, videos, episodes to tape, etc.

Today I received an email from a user using a Mac and a Visor who
reports
"the db application lists the databases but when I try to use them I get
an invalid file not a database error. I tried to load them into the palm
developer desktop application but it doesn't like the =E8 character."

Now, I'm using
$ csv2pdb -v
pdb2csv (palm-db-tools 0.3.2)

as well as db version 0.3.1.

Is there something I can do to check out this problem to see what
might be going wrong?
-- 
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.
-><-

[pilot-db-list] Sorting by multiple fields

[Schweikert, M. {POYD~Kaiseraugst} <MAR...@Ro...>]

Hi!

I wondered if it is possible to sort a table by more than 1 field. Using v. 0.3.1, I can't figure it out.

I dug through the mailing list and found the hint to press the "Add" button, but I cannot find this button.

The same posting mentions the file ftp://pilot-db.sourceforge.net/pub/pilot-db/dbtest.prc. Today, this file seems to be called dbtest-en.prc, but I cannot download it - "permission denied" if I use an FTP client; if I use a browser, there comes up a different error message, but I cannot load the file either.

Best Regards / Mit freundlichem Gruss
Martin Schweikert
-- 
F. Hoffmann-La Roche Ltd.   Division Pharmaceuticals
IT Service Unit Basel       DOCUMENTUM Services
Department POYD-D           Bldg. 223 / Room 311
Phone +41 61 688 3188       Fax +41 61 687 2770

[pilot-db-list] Configurable JFile3 and MobileDB support

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

Hi,

I thought it might be useful to be have an options not to compile in JFile3
or MobileDB support in the same way as it is done with the legacy DB
support at the moment.

Included is a patch that should do this. The extra options are #defined in
config.h.

Turning off JFile3 and MobileDB support only reduces the .prc size by about
5K, so it isn't a great saving.

Cheers,
Brian.

diff -u db-20010430/JFile3.c db-mine/JFile3.c
--- db-20010430/JFile3.c	Thu Mar  1 22:12:07 2001
+++ db-mine/JFile3.c	Wed May  2 22:30:54 2001
@@ -22,6 +22,8 @@
 #include "db.h"
 #include "enum.h"

+#ifdef CONFIG_JFILE3_SUPPORT
+
 #if defined(__GNUC__)
 #define SECT_DRV __attribute__ ((__section__("drvsect")))
 #else
@@ -964,3 +966,5 @@

     return driver;
 }
+
+#endif /* CONFIG_JFILE3_SUPPORT */
diff -u db-20010430/MobileDB.c db-mine/MobileDB.c
--- db-20010430/MobileDB.c	Thu Mar  1 22:12:07 2001
+++ db-mine/MobileDB.c	Thu May  3 00:02:41 2001
@@ -22,6 +22,8 @@
 #include "db.h"
 #include "enum.h"

+#ifdef CONFIG_MOBILEDB_SUPPORT
+
 #if defined(__GNUC__)
 #define SECT_DRV __attribute__ ((__section__("drvsect")))
 #else
@@ -1061,3 +1063,5 @@

     return driver;
 }
+
+#endif /* CONFIG_MOBILEDB_SUPPORT */
diff -u db-20010430/config.h db-mine/config.h
--- db-20010430/config.h	Mon Jun 26 07:53:36 2000
+++ db-mine/config.h	Thu May  3 00:13:05 2001
@@ -10,4 +10,12 @@
 #define CONFIG_LEGACY_SUPPORT
 /* #undef CONFIG_LEGACY_SUPPORT */

+/* Define this if you want DB to support the JFile3 file format. */
+ #define CONFIG_JFILE_SUPPORT
+/* #undef CONFIG_JFILE_SUPPORT */
+
+/* Define this if you want DB to support the MobileDB file format. */
+#define CONFIG_MOBILEDB_SUPPORT
+/* #undef CONFIG_MOBILEDB_SUPPORT */
+
 #endif
diff -u db-20010430/io.c db-mine/io.c
--- db-20010430/io.c	Thu Mar  1 22:12:07 2001
+++ db-mine/io.c	Thu May  3 00:16:36 2001
@@ -23,6 +23,14 @@
 #include "db.h"
 #include "enum.h"

+/* A little hack to make sure that the drvsect section always has some
+ * code in it, even if no data source drivers are defined in config.h
+ */
+#if defined(__GNUC__)
+static void drvsect_dummy_fn(void) __attribute__ ((__section__("drvsect")));
+static void drvsect_dummy_fn() { drvsect_dummy_fn(); }
+#endif
+
 DataSource * CurrentSource = 0;

 typedef struct
@@ -2646,16 +2654,27 @@
 GetDataSources(void)
 {
     DataSourceDriver * drivers = GetInternalDataSources();
+    #ifdef CONFIG_MOBILEDB_SUPPORT
     DataSourceDriver* driver_MobileDB = MobileDB_GetDriver();
+    #endif
+    #ifdef CONFIG_JFILE3_SUPPORT
     DataSourceDriver* driver_JFile3 = JFile3_GetDriver();
+    #endif
     DataSourceDriver* last;

     /* XXX: Make it so we can disable other data source drivers. */
     last = drivers;
     while (last->next != 0) last = last->next;
+
+    #ifdef CONFIG_MOBILEDB_SUPPORT
     last->next = driver_MobileDB;
-    driver_MobileDB->next = driver_JFile3;
-    driver_JFile3->next = 0;
+    last = last->next;
+    #endif
+    #ifdef CONFIG_JFILE3_SUPPORT
+    last->next = driver_JFile3;
+    last = last->next;
+    #endif
+    last->next = 0;

     return drivers;
 }

RE: [pilot-db-list] configurable list view

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

I agree with these comments. Makes sense.

-----Original Message-----
From: krohorl [mailto:kr...@bi...]
Sent: Wednesday, 2 May 2001 4:00
To: pil...@li...
Subject: Re: [pilot-db-list] configurable list view


> Some questions as to what you all want:
> 
> 1) Should these options be "global" in the sense they apply to all
databases 
> or "local" in the sense that each database has its own set of options?
> 2) Maybe both of the above senses so that you have global options which
can 
> be overridden on a database by database basis?

	That would be my choice.


> 3) For the "local" sense, how I should MobileDB, DB 0.2.x, and JFile 
> databases be handled which cannot store any extra information?

	Only use global customization ? Il think that would make sense.

 
> 4) Any other features that you want in the grid widget? (The "grid widget"
is 
> the code responsible for displaying the information in the list view.) 
> Different colored columns, right justified text or better yet,
configurable 
> justification for each column?

	Yes, configuration justification.
	Other ideas :
	Different fonts (for column labels and column values).
	Different colors for background of labels.
	Truncation customisation : use "..." or not.
	Padding : instead of a vertical bar beetwen columns, use an empty
sizeable area (more readable, I think).

	Fab.

_______________________________________________
Pilot-db-list mailing list
Pil...@li...
http://lists.sourceforge.net/lists/listinfo/pilot-db-list



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] configurable list view

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

> Some questions as to what you all want:
> 
> 1) Should these options be "global" in the sense they apply to all databases 
> or "local" in the sense that each database has its own set of options?
> 2) Maybe both of the above senses so that you have global options which can 
> be overridden on a database by database basis?

	That would be my choice.


> 3) For the "local" sense, how I should MobileDB, DB 0.2.x, and JFile 
> databases be handled which cannot store any extra information?

	Only use global customization ? Il think that would make sense.

 
> 4) Any other features that you want in the grid widget? (The "grid widget" is 
> the code responsible for displaying the information in the list view.) 
> Different colored columns, right justified text or better yet, configurable 
> justification for each column?

	Yes, configuration justification.
	Other ideas :
	Different fonts (for column labels and column values).
	Different colors for background of labels.
	Truncation customisation : use "..." or not.
	Padding : instead of a vertical bar beetwen columns, use an empty
sizeable area (more readable, I think).

	Fab.

[pilot-db-list] configurable list view

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

I am currently working on adding better color support in DB. (Not that 
everything would be in color but just to do selections correctly and so on.) 
I ported the grid widget used in the list view so it does things in color.

The grid widget is configurable but not all this configuration has been 
exposed to the user. Now that I have a color version of the grid widget which 
still operates on older systems, I'd like to expose some of the 
configurability.

The test release currently up lets you hide the header row and also add a 
seperator line between the header and data area. Some more options that I can 
add with relative ease since the grid already supports them:

- vertical column sepeators
- change colors of any grid piece including normal row, highlighted row, and 
selected row (by tap)

Some questions as to what you all want:

1) Should these options be "global" in the sense they apply to all databases 
or "local" in the sense that each database has its own set of options?

2) Maybe both of the above senses so that you have global options which can 
be overridden on a database by database basis?

3) For the "local" sense, how I should MobileDB, DB 0.2.x, and JFile 
databases be handled which cannot store any extra information?

4) Any other features that you want in the grid widget? (The "grid widget" is 
the code responsible for displaying the information in the list view.) 
Different colored columns, right justified text or better yet, configurable 
justification for each column?

5) Other suggestions on this topic are welcome.

-Tom Dyas

[pilot-db-list] Re: bug in DB??

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

[ reply directed to list so others can benefit from answer ]

On Monday 09 April 2001 12:21, you wrote:

> I just installed DB 3.1 and may have run across a bug.  The bug may
> be in the db tools (cvs2pdb).  Here is what happened.
>
> I created a database for a bus schedule.  The info file is
>
> title "96 Inbound, Daily"
> field "Medford Square" string 100
> field "Powder House" string 100
> field "Harvard Square" string 100
>
> [ data file edited out ]
>
> I ran csv2pdb with no problems after building it on my RH 6.2 box.
> The resulting pdb file was usable on my pilot (III running OS 3.5)
> after a hotsync using jpilot.  I then edited the database format and
> changed string to time for the Medford Square field.  This caused all
> Medford Square entries to have the same time (bug?).  Then I changed
> the field back to string, and the entire database seemed to have lost
> its records (bug?).  I then re-installed the database...

The limitation is in the code in DB which rebuilds the database when field 
types change. I was lazy and didn't write the code to parse a string and 
convert it to a time. I could probably adapt the code from the palm-db-tools 
but I don't know when it would get done.

Re: [pilot-db-list] non-palm editing of databases

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

On Thursday 05 April 2001 11:51, Jay Sekora wrote:

> I'm actually working on a Tcl/Tk GUI for pilot-db databases.  It's
> in the very very early stages at this point, and not trivial to set up
> because it depends on my jstools (soon to be renamed aqtools) suite,
> but when I get a bit further with it I'll post it here.  What I have
> so far is the ability to parse an existing pilot-db .info file, read
> a .csv file into a Tcl list based on the fields in the .info file, and
> append records to that list using a dialogue box with appropriate
> widgets (e.g. a checkbutton for Boolean fields).

If you want to use my C++ code directly to read/write the PDB files, look at 
generating Tcl bindings using the swig program at http://www.swig.org/

Re: [pilot-db-list] non-palm editing of databases

[Jay S. <js...@aq...>]

I'm actually working on a Tcl/Tk GUI for pilot-db databases.  It's 
in the very very early stages at this point, and not trivial to set up 
because it depends on my jstools (soon to be renamed aqtools) suite, 
but when I get a bit further with it I'll post it here.  What I have 
so far is the ability to parse an existing pilot-db .info file, read
a .csv file into a Tcl list based on the fields in the .info file, and 
append records to that list using a dialogue box with appropriate 
widgets (e.g. a checkbutton for Boolean fields).

Cheers,

-j.

-- 
Jay Sekora             http://www.aq.org/~js/            js...@aq...

`A language that doesn't have everything is actually easier to program
in than some that do.' - Dennis M. Ritchie

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

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

Re: looking for a DB repository

I have my DB databases of Pokémon information up on PalmGear and Memoware.
However, I don't recall seeing any native DB databases on either site.
-- 
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] non-palm editing of databases

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

Re: non-palm interfaces to DB

I've been ruminating on the creation of just such a thing.

Tom of course has a set of command line tools for converting csv + files
to DB binary format and back.

My thought was to take Tcl/Tk plus TkTable (a GUI extension providing a
spreadsheet like interface) and to wrap around Tom's commands so that
one could load the data into a spreadsheet (with perhaps a second window
displaying the out of band information like column names, types, etc.).
The tool would allow one to manipulate the data, then to generate a 
DB database from it.

Unfortunately, my time has been so limited that I've been unable to date
to begin the effort of writing the app.
-- 
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] pilot-db databases

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

On Wednesday 04 April 2001 15:58, Patrick K Notz wrote:

> Does anyone know of a repository of "general interest" databases
> for pilot-db?  I've looked at TUCOWS and at Palm's software connection
> at palmgear.com but haven't found any.
>
> [list of examples edited out]
>
> If not, what would be the best way to start one?  A source forge
> project?  A new section at palmgear.com?  A contrib/ section for
> pilot-db?

The Web site is begging for people to put stuff on it. It cries out, "Tom! 
You have no time for me due to that train ride each day into NYC. Anyone with 
a SourceForge account who is added to the pilot-db project by you can update 
my pages. Code me!"

A contrib section of databases sounds cool.

-Tom Dyas

Re: [pilot-db-list] non-palm editing of databases

[Hal D. <hal...@ac...>]

>>>>> On Wed, 4 Apr 2001, "Patrick" == Patrick K Notz wrote:

  Patrick> Are there any non-palm interfaces for pilot-db
  Patrick> databases available?

I'm guessing that you aren't aware of db-tools.  Convert the pdb 
files to/from csv.  palm-db-tools.sourceforge.net


--Hal

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

[Hal D. <hal...@ac...>]

>>>>> On Wed, 4 Apr 2001, "Patrick" == Patrick K Notz wrote:

  Patrick> There are many such databases available for other palm
  Patrick> database programs.

And, since db can read several other formats, a lot of them are 
usable for us db users.


--Hal

[pilot-db-list] non-palm editing of databases

[Patrick K N. <no...@pu...>]

Hi,

Are there any non-palm interfaces for pilot-db databases available?
I'm thinking of Linux or Windows or Mac (ugh) front ends.

Thanks - pat

[pilot-db-list] pilot-db databases

[Patrick K N. <no...@pu...>]

Hi,

Does anyone know of a repository of "general interest" databases
for pilot-db?  I've looked at TUCOWS and at Palm's software connection
at palmgear.com but haven't found any.

There are many such databases available for other palm database
programs.  A few examples include 

o Phone/Web information for airlines, hotels and car rental agencies
o NPR radio stations
o Chemistry data
o Airport codes
o Area codes
o senator/congress person info
etc.

If not, what would be the best way to start one?  A source forge
project?  A new section at palmgear.com?  A contrib/ section for
pilot-db? 

Thanks, pat

Re: [pilot-db-list] Pilot-DB utility note

[<lv...@ca...>]

I believe so - I was in the process of converting some ifo files and
had mistyped the name of one of them.  

-- 
-- 
"See, he's not just anyone ... he's my son."  Mark Schultz
<URL: 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] Pilot-DB utility note

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

On Saturday 31 March 2001 06:14, Larry W. Virden wrote:

> In csv2pdb 0.3.2 beta (and perhaps the other palm-db-tools) when an
> error occurs, there doesn't seem to be a space or other seperator between
> the utility name and the error msg, making it more difficult to read than
> necessary.

Was the specific error message for "file not found"? (I looked and at least 
in that spot, I missed putting in a colon in the output statement.)

[pilot-db-list] Pilot-DB utility note

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

In csv2pdb 0.3.2 beta (and perhaps the other palm-db-tools) when an
error occurs, there doesn't seem to be a space or other seperator between
the utility name and the error msg, making it more difficult to read than
necessary.
-- 
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.
-><-