Category:	Applications:Database
Description:	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 features good import/export of industry-standard database and delimited text files. Specification : Full Relational capabilities including table lookups, one-to-many parent-child subtables; up to 10 nested levels. Opening and editing of all tables created with OPL\\\'s standard database functions. Auto-recognition of field names (can be overridden with user-defined aliases). Search functions: Basic Text or SQL Option to use a successful SQL query as a genuine filter. Save SQL queries so that they can be selected from a picklist. AutoSQL filters - create filtered views on-the-fly to match current criteria with a single shift-F Multiple Indexes. 5 toolbar buttons (increasing to 7 when using sub-tables) on all machines including Revo. Buttons are dynamic (ie. they can respond to a pen held down instead of just standard pen down / pen up events). Up to 255 fields per table. Create tables containing all 17 EPOC DBMS field types. Browse standard EPOC Data files (and \\\'Save As\\\' them to OPL database/PsiDat format) User-upgradeable system of field modifiers for defining special field properties, input/output effects, and flags. Editing of 13 Field Types * PsiDat CSV files can be easily reimported into the EPOC Data application (including memo fields). dBase III and dBase IV files (DBF) imports/export include memo (DBT) files and codepage conversion. Intelligent importing (ie. Text & CSV files are scanned and interpreted so that field types and names are automatically assigned) Comprehensive control of HTML exports in tabular and single record modes. Various XML export options See Example Unedited PsiDat XML Export Page Calculated Fields User-defined opening banner for individual databases with automatic opening of correct table and index. Extensive Help File Create example OPL code for creating/opening/reading/writing tables with and without DATA.OPX (if you\\\'re an OPL programmer developing a standalone application, PsiDat can do much of the coding for you so that you can copy-paste the required source code into the program editor) Tabular Printing - up to 8 rows per record, gridlines, summary results. Summary Fields - COUNT, SUM, MINIMUM, MAXIMUM, AVERAGE Report Design (unlimited number of different reports can be saved for each table) Quick Print for any table without having to define a report (including LongText8 Memos and MBM graphics embedded in long binary fields) Restructuring of Database tables User-defined colours and background tiles Export field, record, or multiple records to clipboard with user-control of delimiters. Support for latitude/longitude information directly from an NMEA-compatible GPS (or indirectly through RealMaps if installed) On-the-fly additions to lookups and helps Storage & Launching of embedded files Built-in EPOC picture viewer. Built-in Sound Player Autowidth multi-column List View and Split List View User-defined menus and custom OPL routines. Simple password protection to prevent casual users altering the structure of PsiDat databases International support. Italian, German, French, Dutch, and Spanish resource files now included
Author:	Kevin Millican
Homepage:	http://www.millican.info
SIBO:	No
EPOC:	Yes
Type:	Freeware
Updates:	Version v1.25 at 15:09:27 on 3rd August 2003 Version v1.24 at 20:16:51 on 31st May 2003 Version v1.23 at 23:01:38 on 27th May 2003 Version v1.21 at 01:53:58 on 17th November 2002 Version v1.21 beta 4 at 13:34:46 on 7th November 2002 Version v1.20 at 18:44:14 on 3rd July 2002 Version v1.19 at 00:08:04 on 20th April 2002 Version v1.18 at 01:14:02 on 1st March 2002 Version v1.17 at 19:22:25 on 23rd December 2001 Version v1.16 at 00:59:08 on 18th November 2001 Version v1.15 at 22:54:37 on 14th October 2001 Version v1.14 at 23:26:07 on 17th June 2001 Version v1.13 at 21:44:11 on 20th May 2001 Version v1.12 at 21:48:59 on 20th April 2001 Version v1.11 at 23:39:53 on 5th April 2001 Version v1.10 at 01:02:38 on 1st March 2001 Version v1.08 at 01:41:00 on 28th January 2001 Version v1.07 at 00:06:29 on 2nd December 2000 Version v1.06 at 22:45:52 on 7th November 2000 Version v1.05 at 01:02:13 on 5th November 2000 Version v1.03 at 00:46:36 on 28th October 2000 Version v1.00 at 23:33:16 on 23rd October 2000 Version 0.91 beta at 20:39:46 on 13th July 2000 Version 0.90 beta at 18:12:42 on 5th July 2000 Version 0.88 beta at 22:39:22 on 22nd June 2000 Version 0.86 beta at 01:43:25 on 18th June 2000 Version 0.8 alpha at 00:36:48 on 10th June 2000 Version 0.7alpha at 23:52:07 on 7th June 2000 Version Initial Notification at 09:30:40 on 1st June 2000
Hits:	16979 views, 6479 hits.
Rating:	7.95 (912 ratings)   [ rate this software ]
Tips:	There are currently 4 tips for this application.   [ view tips ]   [ submit a tip ]