<body leftmargin=0 topmargin=0 marginwidth=0 marginheight=0>
 
How to Import Source Data
from Psion Sheet Application & Psion Data File, CSV File
 
 
There are Three Ways for importing Source Data, as follows:

1. from Psion Sheet Application

2. from Psion Data File

3. from CSV File exported by the software


 
About charactors length of data


1. from Psion Sheet Application
As for importing from Sheet application, no need to care any charactors length, because the program processes automatically.
But names of variables and samples would be output 10 charactors limitted in the result text file. Because too long names would disturb eyeball of various result data in tiny resolution.

Regarding importing from Sheet, it's important to set 'number format' to General for all cells.


2. from Psion Data file
All importing charactors length are limitted to 18 charactors which is maximum length be able to calculate by EPOC R5, as text data for 64bits floating data.

All importing names of variables and samples are also limitted to 18 charactors by the software, and are output 10 charactors limitted in the result text file. Because too long names would disturb eyeball of various result data in tiny resolution.


In conclusion,
Therefore, I recommend to write numeral data under 18 charactors (except on Sheet), and to write names of variables & samples under 10 charactors, it's no problem to write names 18 charactors though.



 
1. from Psion Sheet Application

It's a very easy and efficient method.

At first, open Sheet file and select area of data which should be included names of variables and samples. All cells should be set General as their 'number format'.


Open Sheet file and entry data Please refer to about charactors length of data
Select area of data
Push "Ctrl" key and "C" key

At this condition, you may close sheet application or not. Whichever it doesn't matter.


Start up the software or bring it to foreground, and Tap "Import Sheet" of toolbar or select "Import Sheet" of menu
If correct data was selected on Sheet application, you can start to analyse. If wrong data was selected on Sheet application, error message would appear, and please check for mistakes in the figures.



 
2. from Psion Data file

This method is not so efficient though, regarding speed and flexible-handling it's a best method.
I think this method is efficient for following data:

- very large data often analysed
- data is often made additional changes
- there are some illegal or void data


At first you have to create data file.

Start up Data application and "Change labels"
Delete all default labels, and Add new labels which would not be read to the software. But please name 1st label to "sample", and 2nd label to 1st variable name, 3rd label to 2nd variable name, 4th label to 3rd variable name and so on...
At this phase, very important thing is to set all "Data type" to "Text" and to set all "charactors" to "18". Please refer to about charactors length of data
For 1st record (entry), from 2nd field variable names should be entried. For 1st field of 1st record you may input anything or void. Please refer to about charactors length of data
From 2nd record (entry), sample name and its figures of variables could be entried. Please refer to about charactors length of data
By that, data file is perfection. Please move the file to the folder for data, which default path is "c:\documents\data\PsiStats\data\". You can exchange that path by preference of menu.

Start up the software or bring it to foreground, and Tap "Import Data" of toolbar or select "Import Data" of menu. And so, a dialog box would be appeared and you can select the data file, and the software would read the data file.

Even If the software alert illegal data is included in the data file, you can ignore the sample with it, and can start to analyse.



 
3. from CSV file exported by the software

Start up the software, and Tap "Import CSV" of toolbar or select "Import CSV" of menu. And so, a dialog box would appear and a CSV file could be selected for be read.
It's easy to create the CSV file, as a data file, by a text editor. But a CSV file, which is not exported by the software, is not warranted.
Here is a sample csv file, which was exported by the software from one of sample data files.

As for exporting, start up the software and import any data file(data, csv, sheet), so the menu "Export to CSV" will be available.