Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page is for administrators who need to configure system-wide options for PhixFlow.
Overview
There are several ways to access system configuration:
- In the header bar, click
→Insert excerpt _administration _administration nopanel true
→Insert excerpt _system _system nopanel true Insert excerpt _system_config _system_config name admin nopanel true - (PhixFlow versions pre-11 only) Scroll to the bottom of the repository list and click
Insert excerpt _system_config _system_config name full nopanel true
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Page Contents
Table of Contents | ||
---|---|---|
|
Insert excerpt _property_tabs _property_tabs nopanel true
_property_tabs | |
_property_tabs | |
nopanel | true |
General Settings
Field | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Customer Name | This field is read-only. PhixFlow displays the customer name that was set in the PhixFlow database during system installation. | ||||||||||||||||||||||
PhixFlow Instance |
After changing this field you will need to restart the browser or reload the application (User → Reload Application) to see the new value in the banner.
| ||||||||||||||||||||||
Default Export Excel Version |
| ||||||||||||||||||||||
System Locale | Select the default locale to use for the PhixFlow system. You can set a different locale for users.
| ||||||||||||||||||||||
Default Component Palette | Select a default layout component palette. | ||||||||||||||||||||||
Default Template Package | Select a default template package. Applications created without a selected template package will use this value for the new application. | ||||||||||||||||||||||
Decimal Places |
| ||||||||||||||||||||||
Suppress Trailing Zeroes |
This setting can be over-ridden using a Number Format. | ||||||||||||||||||||||
Default Date Format | From PhixFlow version 11+, this section has moved to the
| ||||||||||||||||||||||
Default Date/Time Format | From PhixFlow version 11+, this section has moved to the
| ||||||||||||||||||||||
Allow access to data by default | Specifies the default data access permission on new tables. Possible values are:
| ||||||||||||||||||||||
Notification Timeout (s) | Specify how long, in seconds, PhixFlow should display the popup notifications before closing them automatically. | ||||||||||||||||||||||
File Download Expiry |
Specify how long files remain available in the File Download Location before they are deleted. Specify the time using one or more of:
where If you do not specify the time by d, h, m or s, PhixFlow defaults to the entered value as hours.
| ||||||||||||||||||||||
Help Url | The base URL for PhixFlow help. This is pre-set for each PhixFlow release, and should not be changed without consulting PhixFlow support. | ||||||||||||||||||||||
Online Support Url | The URL to open when the user requests online support through PhixFlow. Under normal circumstances you should not need to update this setting. If you have problem with PhixFlow help, please contact the PhixFlow support team (see the Support Home for contact details). After changing this field you will need to restart the browser or reload the application (User → Reload Application) to start using the new help location. | ||||||||||||||||||||||
System Email Address | Specify the email address from which system-generated mails will be sent, such as password reset requests. For example, create an email account for notifications@company.com and use it as the System Email Address.
| ||||||||||||||||||||||
Feedback Email Address | Specify an email address to receive any feedback emails. These are sent from the Administration → Support Menu → Email Support option. We recommend that this email address is your onsite system administration email. Issues that cannot be resolved internally should then be forwarded to support@phixflow.com. | ||||||||||||||||||||||
Error Reporting Email Address | Specify an email address to receive emails sent when a user clicks the Report button on a system error message. We recommend that this is set to an onsite system administration. Issues that cannot be resolved internally should then be forwarded to support@phixflow.com. | ||||||||||||||||||||||
Only allow users with the restricted login permission to log in | Use this option when you need maintain or upgrade PhixFlow and you need to prevent any users from logging in; see Restricting Access During System Maintenance.
Remember to untick this option when maintenance is complete. | ||||||||||||||||||||||
Only allow restricted task plan run permission users | Use this option when you need maintain or upgrade PhixFlow and you need to prevent processes from running; see Restricting Access During System Maintenance.
Scheduled task plans will not run, although the Suspended tick box will not be ticked on individual task plans.
Remember to untick this option when maintenance is complete. Note: Any scheduled task plan that attempts to run and is prevented appears in the System Console console as a warning. | ||||||||||||||||||||||
Suspend processing for non admin users | Suspend processing for all users except those in the administrators group. Non-admin users will be prevented from running analysis, task plans, table-actions and rollback. Scheduled task plans will also be suspended (but the suspended box will not be ticked on individual task plans). | ||||||||||||||||||||||
Allow access to run actions by default | If ticked, by default all users will have access to run actions (providing they have functional rights to run actions), unless this is overridden at the level of individual actions. | ||||||||||||||||||||||
Home Screen Message HTML | Enter and format a message which is displayed to users when they log in; see Configuring a Login Message. | ||||||||||||||||||||||
Banner Colour | Use the colour picker to select a colour for the menu bar at the top of the screen. |
System Directories
Use these options to configure root directories that PhixFlow needs on its server. On a Windows-hosted system, prefix directory paths with a drive letter, for example C:
Note |
---|
When you set a Restricted Directory, all other system directories, except the Database Driver File Directory, must be sub-directories of the restricted directory. |
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Plugin Location | Enter the path to a directory for any PhixFlow plugin applications. | ||||||||||
Application Location | Enter the path to a directory for the PhixFlow installation. | ||||||||||
Import File Location | Enter the path to a root directory for files to be imported into PhixFlow. This directory is used as the default location. This field can be left blank. See File Collectors for further details. | ||||||||||
Export File Location | Enter the path to a root directory for files to be exported from PhixFlow. This directory is used as the default location. This field can be left blank. See File Exporters for further details. | ||||||||||
Template Location | Enter the path to a directory for the templates that PhixFlow uses when creating Microsoft Excel file downloads. | ||||||||||
Temporary File Location | Enter the path to a directory where PhixFlow can save temporary files that it generates. | ||||||||||
Performance File Location | Deprecated. This directory is no longer used by any feature. In previous versions, this was where PhixFlow stored performance analysis files. | ||||||||||
Archive Directory | This directory is used when Archive deleted log messages to file is ticked. Enter the path to a root directory where log messages can be archived. This directory is used as the default location. This field can be left blank. | ||||||||||
Restore Directory | Enter the path to a root directory from which data can be restored. This directory is used as the default location. This field can be left blank. | ||||||||||
Restricted Directory |
Read-only. PhixFlow displays the directory path that is set in the PhixFlow database. For security reasons, we recommend that you configure a restricted directory so that Phixflow only reads data from the restricted directory.
| ||||||||||
Database Driver File Directory | Read-only. PhixFlow displays the directory path that is set in the PhixFlow database. Use this directory to store driver jar files to enable PhixFlow to communicate with different databases. To avoid your files being overwritten during Tomcat or PhixFlow upgrades, we recommend that you specify a directory outside of
See also Database Driver. If the Restricted Directory is set, this directory does not need to be within the restricted directory. | ||||||||||
File Upload Directory | Enter the path to a root directory where PhixFlow stores all loaded files, for example from file collectors, and received email messages. Loaded files and processed emails are saved in standard sub-directories as follows:
where
For each email message received, the folder has:
| ||||||||||
Download Location |
The download area is where PhixFlow saves files generated by analysis models or actions in applications. These are CSV or Excel files. Users can download the files from this area. To ensure data security, the files are encrypted and are deleted after a period of time; see File Download Expiry. |
System Tuning
Warning |
---|
This section contains options related to the PhixFlow system. Only change key options related to PhixFlow infrastructure sizes and tuning with advice from PhixFlow support. For advice about using the other system tuning options, please contact support@phixflow.com. |
Field | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Thread Pool Size | Only change this option with advice from PhixFlow support. The number of threads that can be in the pool at any time. This is an advanced option which should not be updated without advice from the PhixFlow support team. This is generally a small multiple of the number of CPU cores on your machine. | ||||||||||||||||||||||
Database Flush Size | Only change this option with advice from PhixFlow support. How frequently objects are written to disc. This sets the default Commit Size for newly created Database Exporters (Advanced section) . If no value is provided the default Commit Size is 2000. | ||||||||||||||||||||||
Result Expiry Time (sec) | Only change this option with advice from PhixFlow support. The length of time the PhixFlow front end application will wait for a result from an asynchronous query before abandoning it. | ||||||||||||||||||||||
Default Page Size | Only change this option with advice from PhixFlow support. The default number of rows to be loaded into to a grid when displayed in PhixFlow. After changing this field you will need to restart the browser or reload the application (User → Reload Application) to apply the new default page size. | ||||||||||||||||||||||
Default Buffer Size | Only change this option with advice from PhixFlow support. When reading in data from a collector, how many rows are held in memory before passing them on for processing. This means that if PhixFlow is reading in 10,000,000 records, it doesn't have to wait until all have been loaded before it begins to process them, but can begin processing after the first 2000 have been read. | ||||||||||||||||||||||
Delete Batch Size | Only change this option with advice from PhixFlow support. Defines the default number of rows to be deleted from a table in a single transaction when archiving or rolling back data. | ||||||||||||||||||||||
Write Processes Per Recordset | Only change this option with advice from PhixFlow support. Enables PhixFlow to multi-thread the process of writing table data to the database. The value of this parameter is dependent upon machine versus database performance. | ||||||||||||||||||||||
Maximum Records Per Download File | This value affects how much data a user can export to a single Excel or CSV file using the
Specify the largest number of data records that a user can downloaded to a single file. Downloads with more than this number of records will be split into multiple files which are zipped together. | ||||||||||||||||||||||
Default Download File Limit | This value affects how much total data a user can export to Excel or CSV files using the Specify the maximum number of records that a user can download. PhixFlow creates a file with this many records. Additional records will be ignored. If no value is specified, PhixFlow applies no limit to the number of records that a user can download. For table data, you can override this value using the table properties in the Download Limits section. | ||||||||||||||||||||||
Validate attribute exists at runtime | Specifies whether or not PhixFlow should check that an attribute exists when a model attempts to read the value of an attribute from a record or a record supplied by a collector.
| ||||||||||||||||||||||
Inactivity Time (sec) | The amount of time (in seconds) that must pass after a user operation before the PhixFlow client application will start any background clean-up processes. | ||||||||||||||||||||||
Maximum File Size Attachment (MB) | Outgoing emails will only attach files (zipped or unzipped) that do not exceed this size limit. An extra message will appear in the email's message subject/body indicating to the recipient that a file attachment has been removed due to this size restriction. If left blank, PhixFlow does not restrict the file size of attachments. However, the email servers will determine whether or not the message is sent/received correctly. | ||||||||||||||||||||||
Maximum Pivot Columns | The system-wide default for the maximum number of columns that can be generated by a pivot table. This applies unless a different maximum pivot columns setting is applied for an individual view. | ||||||||||||||||||||||
Maximum Exporters Errors | The maximum number of errors found before exporters will stop attempting to export records. This is useful where you process large number of records and do not want to wait until all records are processed in case of errors occurred. This value can be overridden in the properties for (database, file and HTTP) exporters. | ||||||||||||||||||||||
Log Statistics |
| ||||||||||||||||||||||
Statistics Period | The period (in seconds) over which performance statics are aggregated, over which snapshots of values are taken. | ||||||||||||||||||||||
Delete Statistics after Days |
Also see Task Plans and Processing Statistics. | ||||||||||||||||||||||
Enforce Pipe Cache Size |
| ||||||||||||||||||||||
Default Pipe Cache Size | The default cache size for a pipe, when it has not been set on the pipe. | ||||||||||||||||||||||
Maximum Pipe Cache Size | The maximum cache size that can be set on a pipe. A pipe with a cache size greater than this will cause an error during an analysis run. | ||||||||||||||||||||||
Enforce In Memory Cache Size |
| ||||||||||||||||||||||
Default In Memory Cache Size | The default cache size for an in-memory table, when it has not been set on the table. | ||||||||||||||||||||||
Maximum In Memory Cache Size | The maximum cache size that can be set on an in-memory table. A table with a cache size greater than this will cause an error during an analysis run. | ||||||||||||||||||||||
Maximum Bigstring Size |
| ||||||||||||||||||||||
Maximum Parallel File Exporters | The maximum number of non-Excel files that may be generated at the same time. This includes files generated:
Requests above this limit will be queued. This value defaults to the value of Thread Pool Size. | ||||||||||||||||||||||
Maximum Parallel Excel Exporters | The maximum number of Excel files that may be generated at the same time. This includes files generated:
| ||||||||||||||||||||||
DTO Building Thread Pool Size | Only change this option with advice from PhixFlow support. When you restart the server, PhixFlow rebuilds recently-used object caches (DTOs). Specify the number of DTOs that can be generated at the same time. This number may affect how quickly PhixFlow is able to restart. See also Advanced → Delete DTO Usage Records after Days, below. |
Advanced
Field | Description | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Default Character Set | Enter the character set PhixFlow assumes when reading from or writing to any plain text or CSV file.
| ||||||||||||||||||
Data Storage Group | Enter the data storage group to use when creating tables to store table data. This field is interpreted differently depending on the underlying database:
If no Data Storage Group is specified, the database user's default setting will be used. Ensure the database user has sufficient privileges.
| ||||||||||||||||||
Line Separator Style | Select the default line separator style that will be used by file exporters where no particular line separator has been specified. If you do not specify a default line separator here, PhixFlow will use the default of the operating system. Where a specific file exporter needs to use a different line separator, use the File Exporter → Line Separator Style property. | ||||||||||||||||||
Default Table Storage | Select the default storage type to use when creating a new table.
| ||||||||||||||||||
Database View Role | Only set this option if you have database users who want to generate reports directly from the PhixFlow database.
Select this option as part of Configuring Access to Database Views. PhixFlow creates a database role that can access views of table data. This role can only see the views, not any other PhixFlow data. | ||||||||||||||||||
Schema Version | Displays the version of the schema currently installed. (Read-only) | ||||||||||||||||||
Licence Key | The licence key for your PhixFlow Installation, provided by PhixFlow Customer Support. If PhixFlow is not configured with a valid key, analysis tasks will not run and an error message will be displayed in the log file. A licence key issued with an expiry date. If the licence has expired, an additional field will show the expiry date. After a licence has expired PhixFlow will generate warning messages in the analysis logs for 28 days beyond the expiry date. After this time analysis tasks will cease to run. | ||||||||||||||||||
Expires On | Displays the date that the current Licence Key will expire. (Read-only) | ||||||||||||||||||
Delete Log Messages after Days |
For information about the system task, see Task Plans. | ||||||||||||||||||
Archive deleted log messages to file |
| ||||||||||||||||||
Disable Scheduled Tasks | In some cases, you may want to run an instance of PhixFlow without any of the scheduled tasks automatically running.
You can also disable scheduled tasks when starting a PhixFlow instance; see Disabling Scheduled Tasks. | ||||||||||||||||||
Delete Emails after Days |
For information about the system task, see Task Plans. | ||||||||||||||||||
Delete Temp Tables after Days | Enter the number of days that temporary tables created by publishing are kept. When a System Task runs it records all temporary tables and will delete the tables after this number of days. If no value is specified, PhixFlow defaults to retaining temporary tables for 30 days. | ||||||||||||||||||
Delete Orphaned Table after Days | Enter the number of days that orphaned database tables are kept. These tables contain the data for tables that have been deleted. When a System Task runs it records all orphaned tables and will delete the tables after this number of days. If no value is specified, PhixFlow defaults to retaining orphaned tables for 30 days. | ||||||||||||||||||
Delete DTO Usage Records after Days | Only change this option with advice from PhixFlow support. The number of days that DTO usage records are kept. This is set to 7 days by default. PhixFlow monitors when objects have been used (DTO usage records). Objects used within this number of days will be re-cached automatically when the server restarts. Keeping usage records for longer periods of time will result in more objects being re-cached after a server restart. | ||||||||||||||||||
Password Policy | Select the password policy that is applies to user passwords. This policy is set in new user accounts when you create them; see Password Policy. | ||||||||||||||||||
Export Password Policy | Select the password policy that applies to security passwords on configuration export files. This policy is set in new user accounts when you create them; see Password Policy. | ||||||||||||||||||
Allow Reset Configuration | Before performing a 'Reset Configuration' the administrator must tick this check box; see Configuration Reset.
| ||||||||||||||||||
Allow Missing On Import | By default, import fails if there is a reference to an item that does not exist either in the import file or in the target system. PhixFlow reports the names of missing items or fields in the error messages from a failed import. If you want to complete the import, even with references to missing items, specify a comma-separated list of missing items or fields here. Next time you run the import, PhixFlow overrides the error messages and completes the import process. |
External Login
Anchor | ||||
---|---|---|---|---|
|
Field | Description |
---|---|
External Login Groups | Enter the names of external login groups whose members are allowed to log in into PhixFlow. Names can be separated by a semicolon but spaces around the semi-colon are considered part of the group name. For example, 'group_1;group_2' is valid, but 'group_1; group_2' is not valid. Names are case-independent. Use {instance} to include the PhixFlow instance name if required. |
External User Group Mapping Prefix | Used as the value for the {mappingValue} in the External Login Groups field. This allows different login groups to be selected on a machine basis without needing to change other configuration settings. |
External User Templates
Anchor | ||||
---|---|---|---|---|
|
This section displays a grid listing the external user templates that have been configured. The order of the templates in this grid is the order in which templates will be matched to external users; see External User Template for details.
To reorder the templates, you can:
- either double-click on a name to open its property tab, then change the Order value.
- or drag template names in the grid. PhixFlow automatically updates their Order.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Style Settings
System Formats
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Default Date Format |
| ||||||
Default Date/Time Format |
|
Form Views
Field | In View | Style is applied to ... | Description | |
---|---|---|---|---|
Grid | Default Header Icon Style | In grid views | Icons in the header row | Select the default style for layout components that appear in screens or views. PhixFlow uses the default style when the layout component does not have its own style set; see Component. |
Default Header Dropdown Pane Style | Drop-down panes | |||
Default Paging Style | The paging bar | |||
Grid Header Style | Header row | |||
Grid Header Button Style | Buttons in the header row | |||
Grid Header Dropdown Button Style | Drop-down buttons in the header row | |||
Grid Row Style | Rows | |||
Grid Alternate Row Style | Alternate rows | |||
Grid Row Hover Style | Rows on mouse-over | |||
Grid Column Style | Columns | |||
Grid Column Header Style | Column headers | |||
Row Selection Style | The currently selected row(s) | |||
View Form | Form View Header Style | In "old" forms that are based on views | Field headers | |
Form View Content Style | Field content |
Default Components
Field | Description |
---|---|
String Component | Select the default style for components that appear in dashboards or views. PhixFlow uses the default style when the component does not have its own style set; see Component. |
Bigstring Component | |
Long Component | |
Float Component | |
Decimal Component | |
True/False Component | |
Date Component | |
DateTime Component | |
Table Action Component | |
Menu Button Component | |
Form Component | |
Card Component | |
Drop Down Component | |
Dynamic Text Component |
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|