File Options

From Planimate Knowledge Base
Revision as of 18:36, 17 April 2009 by Tony.Griffith (talk | contribs)
Jump to navigation Jump to search

Append to Existing File/Table

Appends data below previous entries already written to the file in a File Write. Appends data below previous entries already in the Table Targets of a File Read.

Formatted Values

Format values as defined for the attributes:

e.g.

  • label texts are included,
  • money entries are displayed as $1.00,
  • time appears as 00:05 21.00,
  • rates as /min etc. as appropriate.

Accept Incomplete Tables

(Reading Only)

If the file data is targeted at a table that has more columns that in the file, the data will still be read into the columns that are there.

The "Accept Incomplete Tables" file read option will also accept tables with less columns than the expected number of table columns.

This enables data with variable trailing columns to be read

Delete File After Read

(Reading Only)

Deletes a File after it is read into the Model.

Wait for File to exist

(Reading Only)

Suspends the running model until the file exists, and can be read.

Remove Trailing Spaces

(Reading Only)

Any text data that has training spaces will have those spaces removed before being placed into the data target.

Remove enclosing 's

(Reading Only)

Removes enclosing single quotes and strips any junk outside of single quote pairs, first character must be ' for this to activate.

The import filter treats quoted empty field the same as an unquoted empty field.

Automatically Add labels

(Reading Only)

Any labels not already in the label list that the target column or attribute is formatted to will be added automatically, without asking the user to accept them.

Read over Existing Table contents

(Reading Only)

With this option "on", Planimate® will not clear a table before reading into it.

Instead, Planimate® will attempt to read the file based on the formats of the existing cells in the table.

This is VERY useful combined with using cell specific formats in a table.

The modeller can specify what format data should be read in on a cell-by-cell basis (including different label lists).

With this option on, PL doesn't read data past the rows already present in the table.

Write Column Labels

Places attribute names beside the entries, and table titles in initial row of table.

BUG: Should provide column titles, but doesn't unless you include the Write Row Labels Options as well.


Write Row Labels

Places attribute names beside the entries, and table titles in initial row of table.

BUG: Provides column titles as well as row labels.

Delimit Using Commas

Use or assume use of Commas instead of Tabs to delimit values.

Write without delimiters

(Writing Only)

Write a file output with no delimiters between cells.

Write 4 digit years

(Writing Only)

Use 4 digit years, even if date format is just two.

Show File Browser First

Offer a File browser for the User or modeller to choose the nae of the file to be written to or read from.

Quote all Fields

(Writing Only)

Places Double Quotes around all fields in the table being written.

Dynamic Filename

Implement a placeholder for an attribute reference to be used to identify the file name under program control, rather than manually entered, or hard coded file names.

Minimise Command Window

When a command requires the creation of a Command window, the window will be launched, but will be minimised.

Remain in directory of chosen file

Causes PL to not return to the default directory when a browser is used in a change object to select a file.

This option only takes affect for PBAs (standalone EXEs) to prevent PL losing track of where the model being edited and its DBs are.


Allow Empty Cells

This option enables the column option "Dont Show Zeros" to take effect for tables written to a file. (normally all values are written out).

Write Precision as Displayed

This option causes formatted tables to be written using any column specified display rounding.

By default this is not enabled (to prevent unexpected loss of precision) but in some cases the format as displayed is desired.

Execute Commands using Shell

When this option is selected, executed commands are processed via the windows shell rather than the low level EXE loader.

This enables URLs and data files to be launched, with Windows automatically determining the application to open the data files with as happens when they are double clicked.

Dynamic Command

When this option is selected, a command line for the execute command feature is specified using a reference, like a dynamic file reference.

The default is a "0" or "1" which obviously wont achieve much.

A label reference will usually be useful.





idkbase note 10068