PathAway: GPS Navigation on Palm

PathAway Tools

This document describes the tools available for converting to and from PathAway database format. All PathAway databases are backed up in the user's Backup folder. This folder is usually found in the C:\Palm\UserName\Backup folder. Where "UserName" is an 8 character name of the user's Palm user name, as found on the device. Note, All PathAway databases have a .pdb file extension.

The Command line converter is run from the command line prompt. It is assumed the user is knowledgable of command line commands. The Windows DLL is for developers familiar with programming Windows DLLs in C or C++.

Release Notes: (2.08)

- now strips leading and trailing blanks in data fields,
- added support for fixed field length data types. Source=FIXED, FieldLen parameter defines length of each field. CAL file required. See CAL FILE Format .
- added OZIPCX5.CAL, and OZITrack5.CAL sample converter definitions for OZIExplorer output tracks.

DB Converter - Command Line App

(note these parameters have changed from 1.0, see EleFormat field)

PathAway Database Batch Converter converts to and from PathAway Palm format.

Command Line Parameters:

PWDBConvert [ImportFileName],[ExportFileName],[CalFileName],[PalmFileType],[CSVFileType],[CSVFieldCount],[LatPos],[LongPos],[ElePos],[UTCPos],[NamePos],[IconPos],[DescPos],[EleFormat]

or if using a format definition file (CAL File) the following command line is used: See CAL FILE Format for a description

PWDBConvert [ImportFileName],[ExportFileName],[CalFileName]

[ImportFileName]: full path to import filename. Operation converts From Palm format if this is a PDB file

[PalmDBName]: full path to export File name. Operation converts To Palm format if this is a PDB file

[CalFileName]: full path to Calibration file. Must have .cal extension.

The following optional command line parameters override the entries in the .Cal file.

[PalmFileType]: File Type: "Point", "Route", or "Track". Applies to importing to PDB only

[CSVFileType]: CSV File Type: "Comma", "Garmin", "Tab". (see CSVFormatType below for further explanation)

[CSVFieldCount]: Total number of fields in CSV (Character Separated) file.

[LatPos],[LongPos],[ElePos],[UTCPos],[NamePos],[IconPos],[DescPos]: Field Position in each record of CSV file. 0 is first position

[EleFormat]: Elevation Format. "Feet" or "Metres"

The Following is an example of a set of commands to convert the samplePts.csv file into PathAway format. The PWDBConvert.exe file and the samplepts.csv and samplePts.cal file are assumed to be stored in the C:\PathAway folder:

C:\>CD \PathAway
C:\>PWDBConvert samplePts.csv

The PathAway file is called samplePts.pdb. From Windows explorer, this can be transferred to the device, by installing using the Palm Install tool.

DB Converter - DLL

The plugin DLL is a C language interface DLL. Note if a .CAL file is used, the paramters are overrides, so use the default parameters to leave them unchanged.

int PWDBImport(char *fileName, char *PalmDBName, char *CalFileName, Int16 PalmDBType, Int16 CSVFormatType, Int16 EleFormat, Int16 *CSVPosArray)

FileName: full path to import CSV filename.

PalmDBName: full path to Destination Palm File name (.PDB)

CalFileName: full path to Calibration file. Must have .cal extension. If NULL, optional parameters are used

The following optional parameters override the entries in the .Cal file.

PalmFileType: Palm Database Type: (see PalmFileType below for further explanation) , default=-1

CSVFormatType: CSV File Type: (see CSVFormatType below for further explanation), default=-1

EleFormat: Elevation Format. 0="Feet" or 1="Metres", default=-1

CSVPosArray: Field Position in each record of CSV file. 0 is first position, Pass NULL for default
[0]=LatPos, default=0
[1]=LongPos, default=1
[2]=ElePos, default=2
[3]=UTCPos, default=3
[4]=NamePos, default=4
[5]=IconPos, default=5
[6]=DescPos default=6

int PWDBExport(char *PalmDBName, char *fileName, char *CalFileName, Int16 CSVFormatType, Int16 CSVEleFormat, Int16 CSVFieldCount, Int16 *CSVPosArray)

PalmDBName: full path to source Palm File name (.PDB).

FileName: full path to destination CSV filename.

CalFileName: full path to Calibration file. Must have .cal extension. If NULL, optional parameters are used

The following optional parameters override the entries in the .Cal file.

CSVFormatType: CSV File Type: (see CSVFormatType below for further explanation)

CSVEleFormat: Elevation Format. 0="Feet" or 1="Metres", default=-1

CSVFieldCount: Total number of fields in CSV (Character Separated) file.

CSVPosArray: Field Position in each record of CSV file. 0 is first position
[0]=LatPos, default=0
[1]=LongPos, default=1
[2]=ElePos, default=2
[3]=UTCPos, default=3
[4]=NamePos, default=4
[5]=IconPos, default=5
[6]=DescPos default=6

#Defines

CSVFormatType #Defines
#define DELIMITED_COMMA 0
#define DELIMITED_TAB 1
#define GARMIN_TAB 2

CSVEleFormat #Defines
#define ELEVATION_FEET 0
#define ELEVATION_METRES 1

PalmFileType #Defines
#define PWDBTYPE_POINT 0
#define PWDBTYPE_TRACK 1
#define PWDBTYPE_ROUTE 2

CAL FILE Format

In place of command line parameters, or DLL function parameters, the configuration
of the file to import or export can be specified in a file of the same name with a .cal
extension. See samplePts.csv and samplePts.cal for an example.

Command Line Parameters:
PWDBConvert [ImportFileName],[ExportFileName],[CalFileName]

The [CalFileName] can be omitted if it is the same name as the import file name. The software will automatically look for a .cal file with the same name.

Source=[Delimited], [Comma], [Tab], [Garmin], [Fixed]
FieldCount=[# fields in CSV Record]
FieldLen=[fixed field length of each field in order. Comma delimited ie. 4,10, 20,16]
Delimited=[Delimited format character] use \ for control characters. ie. \t for tab
Latitude= [field position]
Longitude=[field position]
Elevation=[field position]
Time=[field position]
Name=[field position]
Icon=[field position] or [iconDBname:icon (can use same icon for all points)]
Desc=[field position]
LocFormat=[CompressedStr], [Degrees], [Numeric], [DegNoSpace],
PalmDBType=[Point], [Route], [Track]
DefaultIcon=1..4 or [iconDBname:icon]

LocFormat Parameters

Degrees: [NS]dd mm.##, [EW]dd mm.##, (where ## is decimal minutes), or,
[NS]dd mm ss.##, [EW]dd mm ss.##, (where ## is decimal seconds)
DegNoSpace: [NS]ddmm.ss, [EW]dddmm.ss
Numeric: d.nnnnnn, where positive values are northern and eastern hemispheres
CompressedStr: 6 character degrees latitude: ddmmss, 7 character degrees longitude:. dddmmss (Works for North-Western Hemisphere only)