main | about us | download | faq | readings | blogs | support | tutorial | *

Help Contents

Introduction

Managing Problems

Data Entry

Reading the Matrix

Reading the Status Line

Making New Problems

Entering Marks

Managing Rows

Sizing The Matrix

Printing Problems

Computations

Partition

Tearing

Show Impacted Rows

Show Notified Rows

Show Bands of Parallel Items

PSM Properties

Importing/Exporting PSM Data

Exporting to MS Project

Keyboard Shortcuts

Support

 

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:

DataMenu.gif (10856 bytes)

File formats supported by PSM 32 for both exporting and importing

File Extension Notes
DSS 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).
CSV This is a primitive matrix format. The format is a header of column headings followed by rows in:
"Row Name",,,,,,,,,,,,,,
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 are:

  • 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.

MDB 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.