Thread: [pilot-db-list] DataBase Delete

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I am new to Pilot-DB. 
Can you delete a database?

Praise the Lord,
Les Neely     <((((<
www.theneelys.info

How can I convert the .PDB database to an Access database. I tried the
instructions that came with the tools to convert it to an Excel
spreadsheet but all I get is garbage.
I am trying to do this on Win2K not 98.

Bill Farr
bi...@fa...

There are no tools to convert a PDB to Access. You can either convert 
manualy your PDB to a CSV file and import it in any office suite, or you 
can use the macro to import to Excel.
We can provide some support if you tell us a little bit more. Actually 
the db-tools do not support completely all the field types.

Thomas

Bill Farr wrote:
> How can I convert the .PDB database to an Access database. I tried the
> instructions that came with the tools to convert it to an Excel
> spreadsheet but all I get is garbage.
> I am trying to do this on Win2K not 98.
> 
> Bill Farr
> bi...@fa...
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

Creating a CSV would be fine. I see that the pdbtools don't support all
the field types. Date & Note are two that I am using that it looks like
I have to use string. I may be able to find a way around that when I
import it.
The metafile I created looks like:

title "contact list"
field "Date" string
field "Association" string
field "Contactperson" string
field "OffMgr" string
field "Recept" string

The Date is a date formatted field on my Palm. The database was created
with DBv. 1.0.2 & I have just upgraded to 1.0.3 a few days ago with no
problems.
When I run "pdb2csv contact.pdb contact.txt contactmeta.txt" it returns
"contact.pdb: record is corrupt" & no file is created.

Any more help would be appreciated

Bill

-----Original Message-----
From: Thomas Rohmer [mailto:tr...@fr...] 
Sent: Tuesday, November 12, 2002 1:28 AM
To: Bill Farr
Cc: pil...@li...
Subject: Re: [pilot-db-list] DataBase Delete

There are no tools to convert a PDB to Access. You can either convert 
manualy your PDB to a CSV file and import it in any office suite, or you

can use the macro to import to Excel.
We can provide some support if you tell us a little bit more. Actually 
the db-tools do not support completely all the field types.

Thomas

Bill Farr wrote:
> How can I convert the .PDB database to an Access database. I tried the

> instructions that came with the tools to convert it to an Excel 
> spreadsheet but all I get is garbage. I am trying to do this on Win2K 
> not 98.
> 
> Bill Farr
> bi...@fa...
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf 
> _______________________________________________
> Pilot-db-list mailing list Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
> 

Date and Note fields should work fine.
The metafile you describe is useless: when using pdb2csv, the metafile 
parameter is only used for format settings, like date format (DD/MM/YYYY 
or MM/DD/YYYY...) and the separator to use in the CSV file. Field names 
and types are ignored as pdb2csv extracts such information from the PDB 
itself.
Something may fix your "record is corrupt" problem: you can try to 
rebuild the database from the option menu.
If your note fields contains carriage return, you may have to use the 
extended CSV mode.

here is a sample metafile to use with pdb2csv:

extended on
separator ;
format time "%H:%M"
format date "%d/%m/%Y"

Thomas

Bill Farr wrote:
Creating a CSV would be fine. I see that the pdbtools don't support all
the field types. Date & Note are two that I am using that it looks like
I have to use string. I may be able to find a way around that when I
import it.
The metafile I created looks like:

title "contact list"
field "Date" string
field "Association" string
field "Contactperson" string
field "OffMgr" string
field "Recept" string

The Date is a date formatted field on my Palm. The database was created
with DBv. 1.0.2 & I have just upgraded to 1.0.3 a few days ago with no
problems.
When I run "pdb2csv contact.pdb contact.txt contactmeta.txt" it returns
"contact.pdb: record is corrupt" & no file is created.

Any more help would be appreciated

Bill

-----Original Message-----
From: Thomas Rohmer [mailto:tr...@fr...] Sent: Tuesday, November 12, 
2002 1:28 AM
To: Bill Farr
Cc: pil...@li...
Subject: Re: [pilot-db-list] DataBase Delete

There are no tools to convert a PDB to Access. You can either convert 
manualy your PDB to a CSV file and import it in any office suite, or you

can use the macro to import to Excel.
We can provide some support if you tell us a little bit more. Actually 
the db-tools do not support completely all the field types.

Thomas

Bill Farr wrote:

How can I convert the .PDB database to an Access database. I tried the

instructions that came with the tools to convert it to an Excel 
spreadsheet but all I get is garbage. I am trying to do this on Win2K 
not 98.

Bill Farr
bi...@fa...

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf _______________________________________________
Pilot-db-list mailing list Pil...@li...
https://lists.sourceforge.net/lists/listinfo/pilot-db-list

-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing your 
web site with SSL, click here to get a FREE TRIAL of a Thawte Server 
Certificate: http://www.gothawte.com/rd522.html
_______________________________________________
Pilot-db-list mailing list
Pil...@li...
https://lists.sourceforge.net/lists/listinfo/pilot-db-list

Les Neely wrote:
 > I am new to Pilot-DB.
 > Can you delete a database?
 >

This question has been already asked just 5 days ago:

 > I looked through the instruction manual and the menus and
 > cannot figure out how to delete a database once it is created.

Before to open the database, in the screen a front of the
database name, ou have an icon. Tape on it, and select delete.