The JFileVw application is a Win95/WinNT standalone application which allows you to
database information that is destined for the Palm Pilot.
The JFileVw viewer works in cooperation with the JFile application on the Pilot.
If you have installed the GCM (Generic Conduit Manager) on your desktop, the JFileVw app will recognize this at startup, and display a list of your database conduits on the right hand side. You can simply select a database from this list and you will see the data displayed in a grid on the left hand side. From here you can:
JFile requires GCM25 or higher to offer hotsync services to the user. Bothway hotsync allows you to make changes to the data either on the PC or the Pilot, and the two machines with exchange data during a hotsync to make the two versions of the database the same.
If you have not installed the GCM, the JFileVw app will start up and display the database files that it finds in your Backup directory. You can simply click on them to view the data in the grid on the left hand site. From here you can:
With the nonGCM environment, data is transferred from the Pilot to the PC during a hotsync, and deposited in the Backup directory. If you make changes on the PC, you can send them back to the Pilot using the "install" feature. These changes will over-write any changes you make on the Pilot between the time you sync'd and when you "installed".
[The current PilotDesktop only sends data from the Pilot to the PC once. If a file of the same name already exists, the PilotDesktop does not over-write it. This means that the data file in the Backup directory is often "stale". You can freshen it by deleting or renaming the datafile. A future version of JBaseVw will have some feature to try and deal with this problem.]
click a database name on the right hand list
click on the "Browse" button to select a file
select File/Open Database from the menu
To make a new database
click on File/New Database from the menu (no implemented yet)
clock on File/Open from the menu, and bring in a CSV (comma separated variables) file
To save the database
click on File/Save Database from the menu
To add data to a database
select a database; click on the grid; click on Edit/InsertRow; type in the data not implemented yet
select a database; click on the grid; click on Edit/Paste to add data; if you paste at the end of the grid, you add new rows automatically
To remove data from the database
select a database; click or drag on the grid; click on Edit/Cut
To export data
select data on the grid; click on File/SaveAs and select the file type; hit OK
select only one cell on the grid;click on File/SaveAs and select the file type; hit OK
The rule here is that if only one cell is selected, the whole database is saved; if multiple cells are selected then only the selected area is saved.
To import data
select data on the grid (any number of cells) and paste
select File/Open Database from the menu and change the file type to .csv and select a file
To edit text
click on the cell, or tap the F2 key; type the new text; hit enter or tab, or click outside to confirm your changes, hit Esc to retract your changes
To add a database to the conduit list
To remove a database from the conduit list:
To install a database into the Pilot
select a database from the right hand side and click the "Install" button (code not written yet)
use the Explorer and drag the database file onto the InstApp.exe program
run the InstApp program and hit the "Browse" button and select the database file
This file type allows for the most flexibility with regard to import and export. In the Preferences dialog, you can select whether the first line of a .csv file contains the field names, or whether it contains the first line of data. Here is a typical .csv file with the first line as field names:
"Book Title",Author,Price "A Tail of Two Cities","Charles Dickens",$14.95 "Murder in the Rue Morgue","Edgar Allan Poe",$3.95 "Tinker, Tailor, Soldier, Spy","leCarree",$19.95 """Mandingo""","Kipling",$10
The rules are:
JFile does not handle carriage-returns within a piece of data; don't do it.
If you use Basic, you can just Write #1 or Input #1. If you are using Quattro, Excel or Access, just create/use .CSV files.
New is not implemented yet
Open lets you select a file of either .pdb type (JFile/Pilot binary) or .csv (see above)
Save saves the current screen data over top of the original data file. If the file was opened as .csv, it is saved as .csv. The application title bar shows the current file. A trail of backup files is created automatically.
SaveAs allows you to specify the file name for the next Save. If the file name ends in ".csv" then the data will be saved in .csv format; otherwise, it is saved in JFile binary format
Cut/Copy operate as you might expect. Cut does not collapse the rows; it simply clears them. If you have the preferences set, the clipboard also contains the field names for the "cut/copy" data.
Paste adds text to the current grid. It works right and down from the current cell. If the paste buffer is bigger than the current database, the database gets new rows added to it.
DeleteRow and InsertRow are not implemented yet
Overview should display this file
Surf to GCM should wake up your browser and go to the GCM home page.
About is not implemented
This build of JBaseVw does not allow you to edit the field names or datastructures. These must be modified on the Pilot itself. The reason is that the sync process becomes way to complex if we allow this feature.