Home
Personal Info and Holiday Snaps How to contact Kevin Millican KM-Zone: Kevin Millican's Forum Professional Applications : Database / Information Management Systems Programming Articles Pocket Computer & PDA Links Software for Psion Series 5 / 5mx / Revo(+) / Series 7 / netBook / Osaris / Geofox / Ericsson MC218 and other ER3-ER5 devices PDA Articles General Computing Links Psion Series 3a/c/mx Software PC Articles Christian Links PC Software Technical Articles Metallurgy & Welding Links Software for Other Platforms & Web Development Miscellaneous Articles General Links Main Menu

PsiDat for EPOC (v1.25 release 3)

A Powerful Freeware Relational Database Management System for EPOC...

PsiDat - Split view on Series 5 sized screen


Download PsiDat for EPOC (~0.3MB)

Download PsiDat for WINS Emulator (~0.3MB)

Colour Backgrounds / Mono Backgrounds

Example Databases & Templates


More Information including 'Welding' example Database
Revo Screen Shots
Operating Manual and Tutorial for v1.10

(24 Pages as a zipped fully-illustrated MS Word 95 Document)
Or as an Adobe Acrobat file (thanks to David Rossall) :-
psidat-manual.pdf

(warning : this document is getting rather out-of-date so some limitations mentioned no longer apply. However, it's still a useful guide so I've left it available for now until I get round to updating it) 


"The freeware PsiDat... is just about the ultimate database tool for Psion palmtops - it can open, import and export virtually everything, but you definitely have to know what you're doing. Thankfully, there's some truly excellent help text and documentation provided, plus a number of examples...."
(Palmtop User magazine issue 2)


Aim :

To create a database application for the Psion Series 5/5mx, Revo, Series 7/Netbook, NetPad, Osaris, & Geofox that will allow browsing and editing of all OPL DBMS data files, create EPOC databases with and without indexes, and feature good import/export of industry-standard database and delimited text files.

Specification :

Field Type

Calculations

User Extensions

Notes

Bit

Yes

Logical: True/False, Yes/No, or Male/Female

0 or 1

Signed Byte

Yes


-128 to 127

Unsigned Byte

Yes


0 to 255

Integer (OPL %)

Yes

Stopwatch

-32768 to +32767

Unsigned Integer

Yes

Stopwatch

0 to 65535

Long Integer (OPL &)

Yes

Stopwatch

-2147483648 to +2147483647

Unsigned Long Integer

Yes

Stopwatch

0 to 4294967296

Single Float

Yes

Stopwatch

(Range uncertain but larger than Long Integers)

Double Float (OPL Real)

Yes

Stopwatch, Lat/Long, DateTime Display

2.2250738585072015E-308 to 1.7976931348623157E+308
Lat/Long option allows coordinates to be entered in DMS as well as displayed. Realtime coordinates can be read directly from an NMEA-compatible GPS (or indirectly via RealMaps if installed)

Date/Time

Operand

Created, Modified

Can be displayed as a DateTime, Date, or Time.

Text (OPL $)

Yes

Table Helps/Lookups, Filename

'Lookups' must match a value in the lookup table whereas 'Helps' may be used to select a value which can be edited if desired. New values entered in 'Helps' can optionally be added to the helps available. Various field modifiers can be used to alter the exact behaviour.

LongText8 (Memo)

No



LongBinary (File Objects)

No

Rich Text file (defaulting to Word or Jotter)

Can be used for EPOC pictures and other documents. Most files that can be opened by tapping them in the system screen can be launched.

File Type

Import

Export

OPL Database

Native

Native

EPOC Data

Browse and 'Save As'

No (*)

dBASE III/III+

Yes

Yes

dBASE IV

Yes

Yes

CSV Files

Yes

Yes

Delimited Text Files

Yes

Yes

HTML

No

Yes

XML

No

Yes

Idealist Natural

No

Yes

Lotus Notes Structured Text

No

Yes

TreePad (via application file)

Yes

Yes

Others

via OPL code

via OPL code

Cost :


Other Tools :

WebCol - Tool for picking colours - netBook / netPad / WINS (3KB)

(This is included in the PsiDat.ZIP and PsiDat-WINS.ZIP archives but can be downloaded separately)



Forum :
You can share tips ideas, and ask for advice on anything to do with PsiDat on the
PsiDat Discussion Board (New Location)


Betas :If beta test versions of the next release are available, then you can download them here :-
PsiDatBeta (EPOC) | PsiDat Beta (WINS Emulator)


If you think PsiDat is useful then you can vote for it on Epoczone below (10=Highest Rating, 1=Lowest Rating) but if you don't then I'd prefer you to just send me an email saying how you think it can be improved.


<< Back


Saturday, 17 July 2004