The system settings are where global operations parameters are set. These settings have effect for the entire installation for both Dynamic AI Server and Dynamic AI Enterprise.
The system settings are accessed from the administration menu under General / System. They consist of 3 options called System, System parameters and Import/Export.
System opens a tabbed interface for maintaining various system options. They are grouped in general settings, security related settings, alias handling settings and a tab called setup with language options and system information.
System Parameters is a mirror of some of the known settings in the general, security and alias tabs, and also a place where miscellaneous other settings (experimental, extensions and non standard) are maintained.
Import/Export provides functionality to move report definitions and other Dynamic AI objects between installations.
The General tab has the following settings:
Setting |
Description |
Report Documentation: Color saved version: |
Sets a HTML color code for indicating the saved version in the report documentation |
Report Documentation: Color current version: |
Sets a HTML color code for indicating the current version in the report documentation |
Maximum allowed columns in Ad-hoc design: |
Optionally limits number of displayed columns for ad-hoc changes |
Maximum Grouped columns in Ad-hoc design: |
Optionally limits number of grouped columns for ad-hoc changes |
Default location for posting DEBUG information if nothing specified "http://www.dynamicai.com/geterr.asp" is being used: |
Specifies target URL for error reporting – requires “Allow post debug information” to be on |
SMTPServer - if not specified "localhost)" is being used: |
Specifies SMTP server for outgoing mail – requires “Allow E-mail from Dynamic AI server” |
Outfolder for server-side export files (e.g.: C:\DYNAMIC\OUT\): |
Specifies folder on servers hard drive for dropping export files. |
Maximum number of records shown on 1 report/list page (default): |
Sets the default for maximum records on a list |
Maximum size of Log Content Field (Bytes): |
In order to control the size of log entries, the maximum length of log entries can be set. |
Default page when no Start-page has been specified on user (e.g.: http://www.dynamicai.com): |
- |
Disable Author, ID and connection Title on mouse-over in menu |
- |
Disable all Title information in menu |
- |
Disable Bytes/Process Time information on mouse-over on Reports |
- |
Cancel Bundle Roles Auto create logic |
- |
Show COBOL export and format options in Design |
- |
Ownership required to change FILTERS in Ad-hoc design |
- |
Forced Sub-sharing in Ad-hoc design |
- |
Report Documentation: Disable user account information |
Toggle show/hide of user data |
Allow show debug information |
- |
Allow post debug information |
- |
Agent runs JobQueue |
- |
Allow E-mail from Dynamic AI server |
- |
Allow scheduled task by Agent |
- |
Disable Logging |
The log is a powerful and centralized control mechanism to control overview and investigate Dynamic AI activity. Logging can be disabled if it is deemed unnecessary. Disabling the log can gain a slight performance increase. |
Log also SQL Statements |
Additional to logging user activity the log can be set to capture (default turned on) all SQL statements executed by Dynamic AI against background databases. Using this log information detailed information of which information was accessed or manipulated by individual users can be trapped. |
PDF Web grabber installed |
Sets whether ActivePDF Webgrabber is installed and enables PDF output – see Server Side PDF Output |
The Security tab has the following settings:
Setting |
Description |
Password minimum length |
- |
Password minimum char digits |
- |
Password minimum numeric digits |
- |
Password duration in no. days |
- |
Maximum failed login attempts before closing account |
Accounts are locked and must be unlocked by someone with User Administration permissions |
Import server-certificate from file (e.g.: C:\DYNAMIC\cert.txt) |
Certificate for enabling external trust integration |
Read from Organization field on certificate and verify to user-account |
|
OR read from field on certificate and verify to user-account |
|
Force SSL on |
Only accept HTTPS connections |
Check user password history (history of 5) |
- |
Allow "Run As" from profile for users having User-adm rights |
- |
Use Roles security |
- |
The Alias tab has the following settings for each of the 10 possible aliases:
Setting |
Description |
Required |
- |
Bundle Prefix |
- |
Bundle Connection |
- |
Bundle Table |
- |
Bundle Value Col |
Column holding Values |
Bundle IN Value Col Name |
In Value |
Bundle IN Value Col Type |
Data type for the IN value |
The Setup tab lets you pick the languages you want to use and to reset your activation data.
You can reset the activation from system/setup. You need to reset your activation if you receive a new license code (when upgrading to more concurrent users or from Dynamic AI Server to Dynamic AI Enterprise)
The system parameters let administrators maintain additional parameters.
This option lists currently configured scheduled report deliveries. It allows administrators to modify or delete schedule items.
Schedule parameters are in an internal format and should not be changed unless specific instructions have been given by your vendor. Instead, each user can administer own schedules on their user profile.
The Import/export interface allows administrators to move a subset of the defined objects to another installation or to send them to their vendor for troubleshooting.
Running Import/Export
Users that have the “Import/Export” right assigned to their account can access the Import/Export main screen from System settings.
Exporting
To export definitions, click the Export link.
If needed, apply filters on connection, user group, sub share or report groups and press Export.
Exportable objects matching the filters are shown:
· Connection objects
· Dynamic View objects
· Dynamic Dictionary objects
· Relation objects
· Report objects
Use the checkboxes to select each element to be exported.
You need to include depending objects as well.
Pressing the “Discover dependencies” button, will attempt to locate other objects that the current selection depends on. The same screen will be shown again, with discovered dependencies appearing in blue text.
You may now select those objects as well, and press “Discover dependencies” again. Repeat until no more dependencies are discovered. Then press “Next…”
After pressing “Next…” up to 4 files are generated in the root Dynamic AI folder (typically c:\program files\dynamic ai server\):
DNMCExpR.DIM |
Includes right headers (reports and connections) |
DNMCExpL.DIM |
Includes relation information |
DNMCExpC.DIM |
Includes detail information about selected reports |
DNMCExpD.DIM |
Includes dictionary information |
Screen indicating successful export.
You might want to print the screen for later reference. The original Internal ID’s could be useful for troubleshooting.
If you chose not to export dictionary or relation information, the respective files were not created.
Importing
To import definitions, take the generated *.DIM files to the receiving Dynamic AI Server and place them in the root Dynamic AI folder (typically c:\program files\dynamic ai server\)
Verify that all users are logged out of the system.
Select the “Import” link from the main page of the Import/Export function.
The Import function reads the *.DIM files and displays information about items found:
Before pressing the Continue button, review that the displayed information is correct.
Note that the
“Rights
found” number includes connection definitions, Dynamic View definitions and
reports
“Report elements found” number is probably quite large. All fields, extra captions, picture element etc counts toward this total, so a large number is most likely ok.
Also review the import options:
Check this box to change owner, users and designer rights on each object into the XXXXXX group.
(This allows you to let a user group different
from the specified take ownership of imported items. Note that this applies to
everything imported.)
Check this box to allow overwriting of existing Dictionary information.
(If both source and destination servers have
dictionary information from the same Connection/table set, the dictionary
information cannot be merged together. In this case dictionary information from
the source is ignored, unless you set this option that allows destination
dictionary information to be replaced.)
Delete import files after import
(Import files are removed after import)
Prefix
report group names with: ZZZ
(This option renames the report groups
for easier identification after import.)
Verify that you have a current backup of the repository on the destination Dynamic AI server, then press continue to start the actual import
Depending on the number of elements to import, the import process will take from a few seconds to several minutes.
After a successful import, a confirmation is displayed.
The import definition files (*.DIM) can now be removed.
After import, server settings are automatically reloaded.
Connection parameters may have changed.
For file based data sources, you may have to verify their locations.
For server based data sources, you may have to verify server location information (server names, IP addresses).
If you move connection objects between servers that use different license codes, you will need to update the connection password since it is encrypted using parts of the license code as key.
Orphan Users
If imported reports were assigned to users or groups that do not exist in the destination repository and the change owner information option was not used, you will have to manually create the users and groups to be able to access the reports.
Refer to the source Dynamic AI server for user and group names.
Forgotten elements
If the exported elements did not include all referencing reports or other element, it is probably easiest to restore the backup of the destination repository and redo the export.
Styles not matching
Style information is not exported; however, each report references styles by internal ID. In some cases the imported reports uses styles that match existing styles in the destination. Please review that the correct styles are used and select the correct style where appropriate. Remember that each report may reference 3 styles (form style, list style and chart style). A style that does not exist on the destination server must be created before the imported reports can work.