Importing and Exporting
Data from PSM 32.
PSM provides importing and exporting from many file formats to allow PSM to communicate
with many different software programs such as Excel or Project.
The following diagram shows the Data Menu:
File formats supported by PSM 32 for both exporting and importing
||DSS was the original text file format. This format does not
support row or mark notes. This option exists for users of our earlier software programs.
It is a handy way of e-mailing problems to users that do not support MIME mail
extensions (text only).
||This is a primitive matrix format. The format is a header of
column headings followed by rows in:
format. Where each comma represents either a space or a value from 0 to 9. The mark values
may be quoted or unquoted.
Common problems people have with importing CSV files into PSM
- Uneven number of columns in each text row (e.g. missing or additional commas)
- Missing header rows
- Unquoted row labels
- Illegal row label punctuation characters
- Values other then 0-9 in the cells
A good way to get a feel for the required format is to export a problem an look at it
in notepad or another text editor.
||This allows problems to be stored into the PSM MDB format or
imported from another MDB file. This is the preferred way of sending problems back and
forth to unconnected users as it preserves all of the problems attributes.
File formats supported by PSM to import data only
Import CSV List
This imports only row names, creating a new problem.