Miscellaneous

Miscellaneous topics

This section comprises Knowledge Base topics that don't fit anywhere else.

Please browse the available sub-sections using the Knowledge Base menu at the lower left.

Translation Guide

Language Translation Guide

Omniscope is capable of supporting potentially all the languages of the world. To see the available languages, just open Omniscope and go to the Tools > Language menu. You can easily switch languages without re-installing Omniscope, although closing and restarting is strongly recommended. Note: only languages more than 90% complete for that version will be shown. To see other languages which are less than 90% complete, enable experimental features from Tools > Advanced Tools > Application-wide settings > Show experimental features.

Anyone can contribute new and improved translations. You can make minor corrections, create country-specific language variants, or add an entirely new language, using only Omniscope... and perhaps an online dictionary ;>)

We offer Translators working with beta versions of Omniscope free 3-month Professional keys, extendable by another 3 months following successful translation of the current release candidate. If you would like to participate in our Translators program, please contact us.

Translation Process

Editing translations:

Start Omniscope, and from the Tools > Language menu, choose Edit translations.
The .IOK file containing English phrases and all the existing translations will open.
Make your changes to the IOK file, being careful to follow the guidelines below.
Save the IOK file to its current location, by choosing Save (and not Save as) from the File menu.
Restart Omniscope to see your changes.

Submitting translations back to Visokio:

Start Omniscope, and from the Tools > Language menu, choose Submit edited translations.
You will be prompted with the location of the exported locally edited languages IOK file.
Send this file as an attachment in an email to us.
Please provide clear details of which columns or rows you have made changes to, and which version/build of Omniscope you are working with.

Doing further translations:

After you have submitted translations to Visokio, do not do any further translation work until you hear from us. We will incorporate your translations into an new build of Omniscope and let you know which release will include your translations.
Install the newest build of Omniscope containing your work to date.
Delete your locally edited languages .IOK file (after keeping a backup, just in case). This file can be located by starting Omniscope and choosing Submit edited translations as described above. Find the file, called "editedLanguages.iok", close Omniscope, and delete the file.
Start Omniscope again and continue as per Step 1 of "Editing translations", above.

Please respect the Languages .IOK file structure

Each record (row) is a word or phrase from that version/build of Omniscope
The Count field contains the number of locations the phrase occurs in the Visokio codebase. Zero means the phrase does not exist - this can happen occasionally when the software is changed. Do not edit this field
The Location code field contains internal references to the location in the Visokio codebase. Please quote this value when querying us. Do not edit this field
The Location keywords field gives a few keywords as to the location of the phrase. You can sort by this field to group similar phrases. Do not edit this field
The En field contains the original English version of the phrase, which is used as a unique key. Do not edit this field
Other fields with two-letter names (e.g. Es) contain a "default" translation. The field name matches exactly the appropriate 2-letter "ISO 639-1" language code. For example, the field Es contains the default translation for all Spanish countries.
Fields with "xx_YY" names (e.g. en_US) contain country-specific language translations. The "xx" part of the field name is the 2-letter language code and the "YY" part is the appropriate 2-letter "ISO 3166-1 alpha-2" country code For example, the field en_US contains the US English differences. Where the En value is correct for US English, the en_US value is left blank.

Translation Guidelines

Case A: Translating a language for the first time

You create a translation for a language used in the country of origin (the "mother country" for the language). For example, UK English, Spanish from Spain, French from France (as opposed to American English, Mexican Spanish, etc.).

You need to create 2 columns:

The name of the first column will be appropriate 2-character code for the language. So for Spanish the name of the field would be "es". This field will contain the default language translations for all local variants.
You create a second "xx_YY" column where "xx" is the same 2-character language code as above and "YY" is the 2-character country code. So for Spanish of Spain it would be "es_ES".
Edit the first column (e.g. "es"), adding translations. If you leave blank cells or cells containing "=", Omniscope/FeatureFinder will use the English text.

Note : This "es_ES" column will always be empty, because the "es" column will contain all default Spanish translations. You must create this blank "es_ES" column so it becomes available in the Omniscope/FeatureFinder Languages menu.

Case B: Adding country-specific text to already-translated "mother" language

For example, we have already translated into Spanish (Spain), and you want to translate local variations for Mexican Spanish.

In this case the default language column (named using the 2-character language code) already exists (e.g. "es" for spanish). So a single column has to be created. Following the above example, to add translations for Mexican Spanish you would create the column "es_MX" and translate just those phrases that are different in Mexico. Where the default Spanish translation is sufficient the cell can be left blank.

Case C: Corrections to existing translated text

Note:This is not possible for "en" field

Add a new field called "Amended". Locate the field for the language you are correcting (see Languages IOK file structure, above). Use the filters to search for the incorrect phrase.

Make your corrections as required. For every record you have updated, insert "Y" into the Amended field, so we can keep track of changes.

General notes and rules

If a word or sentence doesn´t need to be translated (e.g. "OK") you can leave the cell blank. You may choose to enter "=" instead to indicate that the text is definitely the same.

Note: When Omniscope looks up a translation, it first checks for a field such as "es_MX" (if you are in Spanish Mexico). If the field does not exist or contains a blank, "=" or "?", Omniscope then looks for a field such as "es" (if you are in a Spanish speaking locale). If that field does not exist or contains a blank, "=" or "?", Omniscope then uses the original English phrase.

In case of doubt enter just ? and we´ll explain further when you submit your changes. Don´t enter: "? I don´t understand .." as it will be taken as a translated text
When first translating into a new language the file can be ordered by "count" field (which contains the # of times a text appears in the application) and start translating those texts which higher count.
All non-alphabetic text and upper/lower case has to be preserved in the translations. e.g. "english: (Number)..." must be translated as "spanish: (Numero)..." and not "Spanish (numero)".
Some phrases contain embedded HTML tags such as "<html>" and "". You must preserve the text between the "<" and ">" characters.
Many times you will find something like "Concatenate". If the sentence is "Concatenate is used to ..." and in your language the word concatenate has to be "moved" to a different place then the surrounding "" and "" must also be moved. e.g: "Use Concatenate to ..."
The same can be applied for "some text" and other pairs of HTML tags.
Some phrases contain numbered parameters. For example, "{0} files named '{1}' were found" might appear to the user as "3 files named 'joe' were found". When translating, you can may the parameter order around to suit the language.
The can be more complex like: "File does not exist" in this case the whole will be treated like a single and whaever is between < and > is not translated.
means new line (in html) so it must be placed more or less in the same places where found in english.
Don´t translate:

Notes on English terminology

"Data source". The data source is where the original data was imported from, such as a database or an Excel file. The "refresh from source" option retrieves and updates data from the original file or database.
'Slide' means a PowerPoint slide. A 'slider' is one of the formats for Side Bar filter devices. Slider has nothing to do with a PowerPoint slide.

Knowledge Base Top

XML Schema

Visokio XML Schema

Visokio applications read and write XML files, according to the Visokio XML schema, an extremely simple XML schema for structured data somewhat analogous to the widely-used .CSV delimited text data file format.

Note: Not all .XML data source files have a tabular layout defined. To import directly into Omniscope, both the file schema AND the layout must be transformed to a tabular Visokio XML representation. Omniscope always exports .XML data files in a tabular layout.

Visokio Namespace

Full namespace:

http://www.visokio.com/xmldata

This namespace identifies the Visokio XML data format, used for importing flat-file data. If you need to create a structured flat-file data for feeding into Visokio applications, create a .XML file adhering to this schema and open as a file.

Important: please ensure that the XML document has the correct namespace defined on the <data> element. See the example, below.

You can use XSL translations inside our applications to convert existing XML data into this schema. You will need to produce the XSL yourself. In the File > Open File File Import Wizard, tick Customise data import in the dialog as shown here

Example XML Files

Attached are some sample files illustrating the Visokio schema in use

If viewing in a browser such as Firefox, be sure to view the page source.

KnowledgeBase Top

Flash Skins

Modifying Flash Skins/Components

Skins are a way of changing the look and feel of the Flash .SWF files produced by DataPlayer. Using skins, all of the elements within the DataPlayer .SWF file can be changed to fit a corporate look and feel, adapt to touch/kiosk screens of various sizes, etc. By selecting different skins, it is possible to change colours and most other aspects of the elements within any DataPlayer.

A catalogue of DataPlayer Flash skins and components is being developed. Knowledgeable developers may wish to create their own. If you are interested in creating new skins and components for DataPlayers, please contact us.

Requirements for creating new skins

Knowledge of Adobe/Macromedia Flash
Adobe/Macromedia Flash (version 6 or better .SWF files)
Omniscope DataPlayer or Enterprise Edition
DataPlayer Skin Template (download)

Visokio Flash Skin Template File

The Omniscope DataPlayer Flash Skin Template file is a .FLA file that is opened using the Adobe/Macromedia Flash application. The stage is blank as this file is just a store of components that is used by the DataPlayer View .SWF creation part of the application. In order to see these components, open up the Library by going to the Window menu and choosing Library. Alternatively, use the keyboard shortcut Ctrl-L.

In the Library are a number of folders named after different parts of the application. In each folder are all the elements required to alter the look and feel of the DataPlayers produced by Visokio applications.

Descriptions of the elements required to make each of the components can be found on the links below:

Component- Barometer

Elements

Element Name	Required	Can resize vertically	Can resize horizontally
BAROMETER_INNER	yes	no	yes
BAROMETER_INNER_L	yes	no	no
BAROMETER_INNER_R	yes	no	no
BAROMETER_L	yes	no	no
BAROMETER_R	yes	no	no
BAROMETER_TRACK	yes	no	yes

Color replacements

Name: Barometer
Color: 0xFF9900

(back to top)

Component-Buttons

Fetch Buttons

Elements

Element Name	Required	Can resize vertically	Can resize horizontally
FETCH_DISABLED	yes	no	no
FETCH_ENABLED	yes	no	no

Color replacements

none

----------------------------------------------------------------------------------

Reset Buttons

Elements

Element Name	Required	Can resize vertically	Can resize horizontally
BUTTON_RESET_DISABLED	yes	no	no
BUTTON_RESET_ENABLED	yes	no	no

Color replacements

none

(back to top)

Component-Details

Elements

Outer Frame

Element Name	Required	Can resize vertically	Can resize horizontally
DOD_OUTER_BL	yes	no	no
DOD_OUTER_BM	yes	no	yes
DOD_OUTER_BR	yes	no	no
DOD_OUTER_FILL	yes	yes	yes
DOD_OUTER_ML	yes	yes	no
DOD_OUTER_MR	yes	yes	no
DOD_OUTER_TL	yes	no	no
DOD_OUTER_TM	yes	no	yes
DOD_OUTER_TR	yes	no	no

Inner Frame

Element Name	Required	Can resize vertically	Can resize horizontally
DOD_INNER_BL	yes	no	no
DOD_INNER_BM	yes	no	yes
DOD_INNER_BR	yes	no	no
DOD_INNER_FILL	yes	yes	yes
DOD_INNER_ML	yes	yes	no
DOD_INNER_MR	yes	yes	no
DOD_INNER_TL	yes	no	no
DOD_INNER_TM	yes	no	yes
DOD_INNER_TR	yes	no	no

Buttons

Element Name	Required	Can resize vertically	Can resize horizontally
DOD_BUTTON_CLOSE	yes	no	no
DOD_BUTTON_NEXT	yes	no	no
DOD_BUTTON_PREV	yes	no	no

Color replacements

Color name	Color
Frame background	0x000000
Frame foreground	0xFFFFFF

(back to top)

Component-Frame

Elements

Outer Frame

Element Name	Required	Can resize vertically	Can resize horizontally
FRAME_OUTER_BL	yes	no	no
FRAME_OUTER_BM	yes	no	yes
FRAME_OUTER_BR	yes	no	no
FRAME_OUTER_FILL	yes	yes	yes
FRAME_OUTER_ML	yes	yes	no
FRAME_OUTER_MR	yes	yes	no
FRAME_OUTER_TL	yes	no	no
FRAME_OUTER_TM	yes	no	yes
FRAME_OUTER_TR	yes	no	no

Inner Frame

Element Name	Required	Can resize vertically	Can resize horizontally
FRAME_INNER_BL	yes	no	no
FRAME_INNER_BM	yes	no	yes
FRAME_INNER_BR	yes	no	no
FRAME_INNER_FILL	yes	yes	yes
FRAME_INNER_ML	yes	yes	no
FRAME_INNER_MR	yes	yes	no
FRAME_INNER_TL	yes	no	no
FRAME_INNER_TM	yes	no	yes
FRAME_INNER_TR	yes	no	no

Component-Query Devices

Query Device Frame

Outer Frame

Element Name	Required	Can resize vertically	Can resize horizontally
QD_OUTER_BL	yes	no	no
QD_OUTER_BM	yes	no	yes
QD_OUTER_BR	yes	no	no
QD_OUTER_FILL	yes	yes	yes
QD_OUTER_ML	yes	yes	no
QD_OUTER_MR	yes	yes	no
QD_OUTER_TL	yes	no	no
QD_OUTER_TM	yes	no	yes
QD_OUTER_TR	yes	no	no

Inner Frame

Checkboxes

Element Name	Required	Can resize vertically	Can resize horizontally
QD_CHECKBOX_OFF	yes	no	no
QD_CHECKBOX_ON	yes	no	no

Feature checkbox

Element Name	Required	Can resize vertically	Can resize horizontally
QD_FEATURE_OFF	yes	no	no
QD_FEATURE_ON	yes	no	no

(back to top)

Slider

(back to top)

Spacer

(back to top)

Knowledge Base Top

Functions Guide

Visokio Functions and Formulae

This section expands on the information contained in our applications regarding functions used in formula fields to calculate values based on values in other columns. Most of the functions/syntax are the same as those used in spreadsheets like Excel, but there are also powerful Visokio-specific functions that perform operations on entire data sets, both aggregated and disaggregated.

Function	Usage	Description
ABS	ABS(number)	Returns the absolute value of a number, a number without its sign.
ACOS	ACOS(number)	Returns the arccosine of a number, in radians in the range 0 to Pi. The arccosine is the angle whose cosine is Number.
ACOSH	ACOSH(number)	Returns the inverse hyberbolic cosine of a number.
ASIN	ASIN(number)	Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2.
ASINH	ASINH(number)	Returns the inverse hyperbolic sine of a number.
ATAN	ATAN(number)	Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2.
ATANH	ATANH(number)	Returns the inverse hyperbolic tangent of a number
AVG	AVG(number1, number2, ...)	Returns the average (arithmetic mean) of its arguments.
COMBIN	COMBIN(number, number_chosen)	Returns the number of combinations for a given number of items.
CONVERT_OSGB_TO_LAT	CONVERT_OSGB_TO_LAT(osgbX, osgbY)	Converts coordinates from British National Grid (OSGB 36) to the latitude value in WGS 84 (GPS lat/lon)
CONVERT_OSGB_TO_LON	CONVERT_OSGB_TO_LON(osgbX, osgbY)	Converts coordinates from British National Grid (OSGB 36) to the longitude value in WGS 84 (GPS lat/lon)
COS	COS(number)	Returns the cosine of an angle.
COSH	COSH(number)	Returns the hyperbolic cosine of a number.
E	E	Euler's number, e, also called the base of natural logarithms.
EXP	EXP(number)	Returns e raised to the power of a given number.
FACT	FACT(number)	Returns the factorial of a number, equal to 123...Number.
INTCEIL	INTCEIL(number)	Rounds a number up to the nearest integer.
INTFLOOR	INTFLOOR(number)	Rounds a number down to the nearest integer.
INTROUND	INTROUND(number)	Rounds a number to the nearest integer.
LG	LG(number)	Returns the base-2 logarithm of a number.
LN	LN(number)	Returns the natural logarithm of a number.
LOG10	LOG10(number)	Returns the base-10 logarithm of a number.
LOG	LOG(number, base)	Returns the logarithm of a number to the base you specify.
MOD	MOD(number, divisor)	Returns the remainder after a number is divided by a divisor.
PI	PI	Returns the value of Pi, 3.141592653589793, accurate to over 15 digits.
POWER	POWER(number, power)	Returns the result of a number raised to a power.
RAND	RAND() or RAND(seed)	Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The result changes on every recalculation, unless a seed value (any number) is specified, in which case the number generated is always the same for a given seed.
SIGN	SIGN(number)	Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
SIN	SIN(number)	Returns the sine of an angle.
SINH	SINH(number)	Returns the hyperbolic sine of a number.
SQRT	SQRT(number)	Returns the square root of a number.
SUM	SUM(number1,number2,...)	Adds a list of arguments (e.g. field values)
TAN	TAN(number)	Returns the tangent of an angle.
TANH	TANH(number)	Returns the hyperbolic tangent of a number.
AND	AND(logical1, logical2, ...)	Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
OR	OR(logical1, logical2, ...)	Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
CURRENTROW	CURRENTROW()	Evaluates to the row number of the record being evaluated. Numbering starts at 1.
RECORDCOUNT	RECORDCOUNT()	Evaluates to the number of records (rows) in the data.
CHOOSE	CHOOSE(index_num, value1, value2, ...)	Chooses a value from a list of values, based on an index number (beginning at 1).
DATEDIFF	DATEDIFF(date1, date2, unit)	Establishes the difference between two dates, as a decimal number of a specified unit (optional, default: "days").If date2 is before date1, the result will be negative. E.g. the decimal number of weeks between two dates. Units should be specified as: "years", "months","weeks", "days", "hours", "minutes", "seconds", "milliseconds"
DATETOTEXT	DATETOTEXT(date_value, custom_format)	Converts a Date into text, optionally using a custom date format.
DATEVALUE	DATEVALUE(text)	Converts a text string that represents a date to a date.
EXEC	EXEC(command)	Executes an operating system command, resulting in a text value containing the command's output
IF	IF(logical_test, value_if_true, value_if_false)	Checks whether a condition is met, and returns one value if TRUE,and another value if FALSE
LEFT	LEFT(text, num_chars)	Returns the specified number of characters from the start of a text string
RIGHT	RIGHT(text, num_chars)	Returns the specified number of characters from the end of a text string
LEN	LEN(text)	Returns the number of characters in a text string.
LOOKUPCSVCELL	LOOKUPCSVCELL(csv_data,row,column, has_headers,locale)	Parses and reads CSV data, which may or may not contain a header row. Returns the cell specified (NB. row/column numbers start at zero). This will not perform well for large numbers of calculations or large CSV data. The fifth arguement is optional and you can use it to override the default locale. For an example if the default is italian and you are loading a CSV file with english decimals, add "en"
MID	MID(text, start_num, um_chars)	Returns the specified number of characters from the middle of a text string, given a starting position and length
NOT	NOT(logical)	Changes FALSE to TRUE, or TRUE to FALSE.
NOW	NOW	Returns the current date/time
NUM_OF_TOKENS	NUM_OF_TOKENS(text, token_separator)	Returns the number of tokens (split by a single character such as a comma) in a text value
NUMVALUE	NUMVALUE(text)	Converts a text string that represents a number to a number.
RANK	RANK(value, fieldName, ascending, includeNulls)	Returns the rank of a value within the field specified (use a double-quoted field name). This is the value position within the ordered field values. If ascending is not specified, or false, the rank is against a descending order (higher values give higher rank). If the value is NULL, or not present in the list, NULL is returned, unless includeNulls is specified as true, in which case empty cells in the list will be considered.
READRES	READRES(file_path_or_url)	Reads the text contents from a file or URL.
REPLACE	REPLACE(old_text, start_num, num_chars, new_text)	Replaces part of a text string with a different text string.
REPT	REPT(text, number_times)	Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
SEARCH	SEARCH(find_text, within_text, start_num)	Returns the number of the character at which a specific character or text string is first found, reading from left to right (not case-sensitive).
SEARCHREGEX	SEARCHREGEX(reg_expr, within_text, start_num)	Returns the number of the character at which a regular expression is first found, reading from left to right (not case-sensitive).
TRIM	TRIM(text)	Removes all spaces from a text string except for single spaces between words
PROPER	PROPER(text)	LOWER LOWER(text) Converts all letters in a text string to lowercase.
TEXT_LINE_COUNT	TEXT_LINE_COUNT(text)	Returns the number of lines (split by line-break) in a text value
TEXTTODATE	TEXTTODATE(text_value, custom_format, lenient)	Converts a Date into text, optionally using a custom date format (e.g. "dd/MM/yyyy HH:mm:ss", defaults to the current regional format), optionally specifying whether parsing is lenient (true/false, default true).
TEXTVALUE	TEXTVALUE(text, pattern)	Converts any value into the text equivalent, optionally using a pattern string. The pattern string refers to the format you want your end results to be in. Click here for information on date and time formats. For numbers please click here.
VALUE	VALUE(text)	Converts a text string that represents a number to a number, or date text into a date, where possible, otherwise resulting in a text value.

Knowledge Base Top

Visokio Functions

Visokio DATASET Functions

This section documents the Visokio-specific DATASET functions currently available in Visokio applications:

DATASET_EMPTYCOUNT
DATASET_EMPTYCOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_NONEMPTYCOUNT
DATASET_NONEMPTYCOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of non-empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_UNIQUECOUNT
DATASET_UNIQUECOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of unique non-empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MEAN
DATASET_MEAN(field_name, category_field, category_field_value)
Calculates the statistical function [Mean (average) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MEDIAN
DATASET_MEDIAN(field_name, category_field, category_field_value)
Calculates the statistical function [Median (middle) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MIN
DATASET_MIN(field_name, category_field, category_field_value)
Calculates the statistical function [Minimum value (lowest or first)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MAX
DATASET_MAX(field_name, category_field, category_field_value)
Calculates the statistical function [Maximum value (highest or last)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_RANGE
DATASET_RANGE(field_name, category_field, category_field_value)
Calculates the statistical function [Range of values (maximum minus minimum)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_SUM
DATASET_SUM(field_name, category_field, category_field_value)
Calculates the statistical function [Sum (total) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_STDDEV
DATASET_STDDEV(field_name, category_field, category_field_value)
Calculates the statistical function [Standard deviation of values from the mean] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

----------------------------------

We have also added DATASET_SUM2, DATASET_SUM3, DATASET_SUM4 and DATASET_SUM5, so (unrelated to aggregation in the table), for each record, you can now calculate the sum (or mean, etc.) of a field for all records in the same group of records specified by up to 5 field intersections.

So, as per DATASET_SUM (or DATASET_MEAN, etc), where you could find the SUM (or MEAN, etc) of a field for all records with the same [Month] value, now you can find the SUM (or MEAN, etc) for all records with the same [Month][Client] values using DATASET_SUM2, or with the same [Month][Client][Currency Pair] values using DATASET_SUM3.

Knowledge Base Top

Useful Formulae

Below are some examples of formulae/useful syntax useful for defining commonly-used calculated Formula fields:

Note: You can type function names or pick from the list; text strings in quotes should be entered literally; field names in [ ] should be input using the [Insert field ] tool in the Add/Edit Formula wizard.

1. 'Bucketing' values:

To create a new column where values in a source column are categorised according to user-defined upper and lower limits:

=IF([SourceColumn]<50 "0-50",IF[SourceColumn]<500,"50-500",">500"))

In this example, values in [SourceColumn] are evaluated and placed in 'bucket' categories 0-50, 50-500, or >500

2. Fiscal year 'bucketing':

Dates of payments and other events sometimes need to be categorised by fiscal rather than calendar year. One way to do this is to use the following formula, which can be extended to any number of years:

=IF([Date]=null,null,IF(DATEDIFF(DATEVALUE("1 Oct 2001"),[Date],"day")<366,"FY2002",IF(DATEDIFF(DATEVALUE("1 Oct 2002"),[Date],"day")<366,"FY2003","Out of range")))

In this example, the company's fiscal year runs from October, and the formula column Fiscal Year will be populated with null, FY2002, FY2003, or "out of range" depending on the value in the [Date] field.

3. Converting/Parsing dates:

Date fields can be translated into various components by specifying a custom output date format as the second argument in the DATETOTEXT function. For example:

=DATETOTEXT([DateField],"w") ...this formula evaluates [DateField] and returns the corresponding week number.

=DATETOTEXT([DateField],"EEEE") ...this formula evaluates [DateField] and returns the corresponding day of the week

4. Flagging extreme values:

Using a Variable to define the threshold, you can flag Values which are outside a user-selectable upper-lower tolerance range:

=IF(OR([Value]<(-1*{Threshold variable}),[Value]>{Threshold variable}),"Flagged","Not Flagged")

Before writing the formula, you must define the Threshold Variable, its min, max and default values

5. Value counts:

Counting the number of times a particular value appears in a column:

=DATASET_NONEMPTYCOUNT("Column Name","Column Name", [Insert field-Column Name])

The first free text input "Column Name" specifies the column, the second the non-empty and the last is an [Insert Field] of the field 'Column Name' to pick up the values. This admittedly obscure syntax will return for each row the total number of times the value in the row appears in that same column in the entire data set.

Back to Functions Guide

KnowledgeBase Top

Proposed New Functions

Almost any generalised formula that takes one or more columns of like-typed data as inputs can be expressed as an Omniscope function and added to Omniscope.

Below are some new functions which have already been proposed...

1. Working Days between Dates -function calculates days between given dates excluding list of holidays and weekends.

2. Capture Text Match(es) -when an external list of terms/text items is submitted for matching to an internal target text column, the function records the term or terms (tokenized) from the input list that were matched within the text of the target column. (submitted by Amr Hassan- Segmetrix)

-----------------------------------

To propose a new function, or refine an existing or proposed function, please contact us

KnowledgeBase Top

3rd Party Licenses

Omniscope includes a number of 3rd-party components, typically called "libraries", embedded within the installer which are used to create the seamless Omniscope experience. These packages are included in full accordance with their redistribution license terms, which often includes supplying a copy of the license text (provided below), and are summarised here.

JDOM	Home page:	http://www.jdom.org/
	Summary:	Java library for xml reading/writing
	File(s):	Binary class files embedded in obfuscated form within Main.jar for reduced size
	Version:	1.0b8
	License:	Apache-style "with the acknowledgment clause removed". More info. View full license.
JAF	Home page:	http://java.sun.com/javase/technologies/desktop/javabeans/jaf/downloads/
	Summary:	JavaBeans Activation Framework
	File(s):	activation.jar activation.jar_LICENSE.txt
	Version:	1.1.1
	License:	Proprietary, from Sun - view full license (also bundled with app)
JACOB	Home page:	http://danadler.com/jacob/
	Summary:	Java-COM bridge
	File(s):	jacob.dll jacob_license.txt jacob.jar
	Version:	1.7
	License:	Proprietary - view full license (also bundled with app) Note: bundled version has minor changes to permit integration by Visokio
Transform SWF	Home page:	http://www.flagstonesoftware.com/transform/
	Summary:	SWF file manipulation
	File(s):	transform.jar flagstone_license.txt
	Version:	2.0.3
	License:	BSD - view full license (also bundled with app) Note: bundled version includes minor bugfixes by Visokio
JavaMail	Home page:	http://java.sun.com/products/javamail/downloads/
	Summary:	Emailing capabilities
	File(s):	mail.jar mail.jar_LICENSE.txt
	Version:	1.4.1
	License:	Proprietary, from Sun - view full license (also bundled with app)
JDIC	Home page:	https://jdic.dev.java.net/
	Summary:	Java Desktop Integration Components
	File(s):	jdic.jar jdic_stub.jar jdic.dll jdic_license.txt IeEmbed.exe MozEmbed.exe
	Version:	20061102
	License:	LGPL 2.1, from Sun - view full license (also bundled with app)
Java Service Wrapper	Home page:	http://wrapper.tanukisoftware.org/
	Summary:	Windows NT Service wrapper for Java
	File(s):	wrapper.dll wrapper.jar wrapper-license.txt wrapper.exe
	Version:	3.2.3
	License:	Proprietary - view full license (also bundled with app)
POI	Home page:	http://poi.apache.org/
	Summary:	Java API to access MS format files
	File(s):	poi-3.0.1.jar poi-3.0.1.jar_LICENSE.txt
	Version:	3.0.1
	License:	Apache 2.0 - view full license (also bundled with app)
Silk	Home page:	http://www.famfamfam.com/lab/icons/silk/
	Summary:	Silk icon set 1.3
	File(s):	silk_attribution.txt Various images embedded within JAR files
	Version:	1.3
	License:	Creative Commons Attribution 2.5 - view attribution (also bundled with app)
Java	Home page:	http://java.sun.com/javase/downloads/
	Summary:	Private Java VM
	File(s):	Entire "pvm6u4" folder
	Version:	6u4
	License:	Proprietary, from Sun - view full license Also includes other 3rd party software - view all licenses. Note: bundled version has optional redistributables removed in accordance with Sun's redistribution terms

JDOM license text

/*-- 

 $Id: LICENSE.txt,v 1.8 2002/01/19 10:15:17 jhunter Exp $

 Copyright (C) 2000-2002 Brett McLaughlin & Jason Hunter.
 All rights reserved.
 
 Redistribution and use in source and binary forms, with or without
 modification, are permitted provided that the following conditions
 are met:
 
 1. Redistributions of source code must retain the above copyright
    notice, this list of conditions, and the following disclaimer.
 
 2. Redistributions in binary form must reproduce the above copyright
    notice, this list of conditions, and the disclaimer that follows 
    these conditions in the documentation and/or other materials 
    provided with the distribution.

 3. The name "JDOM" must not be used to endorse or promote products
    derived from this software without prior written permission.  For
    written permission, please contact license@jdom.org.
 
 4. Products derived from this software may not be called "JDOM", nor
    may "JDOM" appear in their name, without prior written permission
    from the JDOM Project Management (pm@jdom.org).
 
 In addition, we request (but do not require) that you include in the 
 end-user documentation provided with the redistribution and/or in the 
 software itself an acknowledgement equivalent to the following:
     "This product includes software developed by the
      JDOM Project (http://www.jdom.org/)."
 Alternatively, the acknowledgment may be graphical using the logos 
 available at http://www.jdom.org/images/logos.

 THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
 WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 DISCLAIMED.  IN NO EVENT SHALL THE JDOM AUTHORS OR THE PROJECT
 CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
 USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
 OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
 OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 SUCH DAMAGE.

 This software consists of voluntary contributions made by many 
 individuals on behalf of the JDOM Project and was originally 
 created by Brett McLaughlin <brett@jdom.org> and 
 Jason Hunter <jhunter@jdom.org>.  For more information on the 
 JDOM Project, please see <http://www.jdom.org/>.
 
 */

JAF license text

A. Sun Microsystems, Inc. ("Sun") ENTITLEMENT for SOFTWARE

Licensee/Company: Entity receiving Software.

Effective Date: Date of delivery of the Software to You.

Software: JavaBeans Activation Framework 1.1.1.

License Term:  Perpetual (subject to termination under the SLA).

Licensed Unit: Software Copy.

Licensed unit Count: Unlimited.

Permitted Uses:

1. You may reproduce and use the Software for Individual, Commercial,
or Research and Instructional Use for the purposes of designing,
developing, testing, and running Your applets and
application("Programs").

2. Subject to the terms and conditions of this Agreement and
restrictions and exceptions set forth in the Software's documentation,
You may reproduce and distribute portions of Software identified as a
redistributable in the documentation ("Redistributable"), provided
that:

(a) you distribute Redistributable complete and unmodified and only
bundled as part of Your Programs,

(b) your Programs add significant and primary functionality to the
Redistributable,

(c) you distribute Redistributable for the sole purpose of running your
Programs,

(d) you do not distribute additional software intended to replace any
component(s) of the Redistributable,

(e) you do not remove or alter any proprietary legends or notices
contained in or on the Redistributable.

(f) you only distribute the Redistributable subject to a license
agreement that protects Sun's interests consistent with the terms
contained in this Agreement, and

(g) you agree to defend and indemnify Sun and its licensors from and
against any damages, costs, liabilities, settlement amounts and/or
expenses  (including attorneys' fees) incurred in connection with any
claim, lawsuit or action by any third party that arises or results from
the use or distribution of any and all Programs and/or
Redistributable.

3. Java Technology Restrictions.  You may not create, modify, or change
the behavior of, or authorize your licensees to create, modify, or
change the behavior of, classes, interfaces, or subpackages that are in
any way identified as "java", "javax", "sun" or similar convention as
specified by Sun in any naming convention designation.

B. Sun Microsystems, Inc. ("Sun")
SOFTWARE LICENSE AGREEMENT

READ THE TERMS OF THIS AGREEMENT ("AGREEMENT") CAREFULLY BEFORE OPENING
SOFTWARE MEDIA PACKAGE. BY OPENING SOFTWARE MEDIA PACKAGE, YOU AGREE TO
THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCESSING SOFTWARE
ELECTRONICALLY, INDICATE YOUR ACCEPTANCE OF THESE TERMS BY SELECTING
THE "ACCEPT" BUTTON AT THE END OF THIS AGREEMENT. IF YOU DO NOT AGREE
TO ALL OF THE TERMS, PROMPTLY RETURN THE UNUSED SOFTWARE TO YOUR PLACE
OF PURCHASE FOR A REFUND OR, IF SOFTWARE IS ACCESSED ELECTRONICALLY,
SELECT THE "DECLINE" (OR "EXIT") BUTTON AT THE END OF THIS AGREEMENT.
IF YOU HAVE SEPARATELY AGREED TO LICENSE TERMS ("MASTER TERMS") FOR
YOUR LICENSE TO THIS SOFTWARE, THEN SECTIONS 1-5 OF THIS AGREEMENT
("SUPPLEMENTAL LICENSE TERMS") SHALL SUPPLEMENT AND SUPERSEDE THE
MASTER TERMS IN RELATION TO THIS SOFTWARE.

1.      Definitions.

(a)     "Entitlement" means the collective set of applicable documents
authorized by Sun evidencing your obligation to pay associated fees (if
any) for the license, associated Services, and the authorized scope of
use of Software under this Agreement.

(b)     "Licensed Unit" means the unit of measure by which your use of
Software and/or Service is licensed, as described in your Entitlement.

(c)     "Permitted Use" means the licensed Software use(s) authorized
in this Agreement as specified in your Entitlement. The Permitted Use
for any bundled Sun software not specified in your Entitlement will be
evaluation use as provided in Section 3.

(d)     "Service" means the service(s) that Sun or its delegate will
provide, if any, as selected in your Entitlement and as further
described in the applicable service listings at
www.sun.com/service/servicelist.

(e)     "Software" means the Sun software described in your
Entitlement. Also, certain software may be included for evaluation use
under Section 3.

(f)     "You" and "Your" means the individual or legal entity specified
in the Entitlement, or for evaluation purposes, the entity performing
the evaluation.

2.      License Grant and Entitlement.

Subject to the terms of your Entitlement, Sun grants you a
nonexclusive, nontransferable limited license to use Software for its
Permitted Use for the license term. Your Entitlement will specify (a)
Software licensed, (b) the Permitted Use, (c) the license term, and (d)
the Licensed Units.

Additionally, if your Entitlement includes Services, then it will also
specify the (e) Service and (f) service term.

If your rights to Software or Services are limited in duration and the
date such rights begin is other than the purchase date, your
Entitlement will provide that beginning date(s).

The Entitlement may be delivered to you in various ways depending on
the manner in which you obtain Software and Services, for example, the
Entitlement may be provided in your receipt, invoice or your contract
with Sun or authorized Sun reseller. It may also be in electronic
format if you download Software.

3.      Permitted Use.

As selected in your Entitlement, one or more of the following Permitted
Uses will apply to your use of Software. Unless you have an Entitlement
that expressly permits it, you may not use Software for any of the
other Permitted Uses. If you don't have an Entitlement, or if your
Entitlement doesn't cover additional software delivered to you, then
such software is for your Evaluation Use.

(a) Evaluation Use. You may evaluate Software internally for a period
of 90 days from your first use.

(b) Research and Instructional Use. You may use Software internally to
design, develop and test, and also to provide instruction on such
uses.

(c) Individual Use. You may use Software internally for personal,
individual use.

(d) Commercial Use. You may use Software internally for your own
commercial purposes.

(e) Service Provider Use. You may make Software functionality
accessible (but not by providing Software itself or through outsourcing
services) to your end users in an extranet deployment, but not to your
affiliated companies or to government agencies.

4.      Licensed Units.

Your Permitted Use is limited to the number of Licensed Units stated in
your Entitlement. If you require additional Licensed Units, you will
need additional Entitlement(s).

5.  Restrictions.

(a) The copies of Software provided to you under this Agreement are
licensed, not sold, to you by Sun. Sun reserves all rights not
expressly granted. (b) You may make a single archival copy of Software,
but otherwise may not copy, modify, or distribute Software. However if
the Sun documentation accompanying Software lists specific portions of
Software, such as header files, class libraries, reference source code,
and/or redistributable files, that may be handled differently, you may
do so only as provided in the Sun documentation. (c) You may not rent,
lease, lend or encumber Software. (d) Unless enforcement is prohibited
by applicable law, you may not decompile, or reverse engineer
Software.  (e) The terms and conditions of this Agreement will apply to
any Software updates, provided to you at Sun's discretion, that replace
and/or supplement the original Software, unless such update contains a
separate license. (f) You may not publish or provide the results of any
benchmark or comparison tests run on Software to any third party
without the prior written consent of Sun. (g) Software is confidential
and copyrighted. (h) Unless otherwise specified, if Software is
delivered with embedded or bundled software that enables functionality
of Software, you may not use such software on a stand-alone basis or
use any portion of such software to interoperate with any program(s)
other than Software.  (i) Software may contain programs that perform
automated collection of system data and/or automated software updating
services. System data collected through such programs may be used by
Sun, its subcontractors, and its service delivery partners for the
purpose of providing you with remote system services and/or improving
Sun's software and systems. (j) Software is not designed, licensed or
intended for use in the design, construction, operation or maintenance
of any nuclear facility and Sun and its licensors disclaim any express
or implied warranty of fitness for such uses. (k) No right, title or
interest in or to any trademark, service mark, logo or trade name of
Sun or its licensors is granted under this Agreement.

6.  Term and Termination. 

The license and service term are set forth in your Entitlement(s). Your
rights under this Agreement will terminate immediately without notice
from Sun if you materially breach it or take any action in derogation
of Sun's and/or its licensors' rights to Software. Sun may terminate
this Agreement should any Software become, or in Sun's reasonable
opinion likely to become, the subject of a claim of intellectual
property infringement or trade secret misappropriation. Upon
termination, you will cease use of, and destroy, Software and confirm
compliance in writing to Sun. Sections 1, 5, 6, 7, and 9-15 will
survive termination of the Agreement.

7.      Java Compatibility and Open Source.

Software may contain Java technology. You may not create additional
classes to, or modifications of, the Java technology, except under
compatibility requirements available under a separate agreement
available at www.java.net.

Sun supports and benefits from the global community of open source
developers, and thanks the community for its important contributions
and open standards-based technology, which Sun has adopted into many of
its products.

Please note that portions of Software may be provided with notices and
open source licenses from such communities and third parties that
govern the use of those portions, and any licenses granted hereunder do
not alter any rights and obligations you may have under such open
source licenses, however, the disclaimer of warranty and limitation of
liability provisions in this Agreement will apply to all Software in
this distribution.

8.      Limited Warranty.

Sun warrants to you that for a period of 90 days from the date of
purchase, as evidenced by a copy of the receipt, the media on which
Software is furnished (if any) will be free of defects in materials and
workmanship under normal use. Except for the foregoing, Software is
provided "AS IS". Your exclusive remedy and Sun's entire liability
under this limited warranty will be at Sun's option to replace Software
media or refund the fee paid for Software. Some states do not allow
limitations on certain implied warranties, so the above may not apply
to you. This limited warranty gives you specific legal rights. You may
have others, which vary from state to state.

9.      Disclaimer of Warranty.

UNLESS SPECIFIED IN THIS AGREEMENT, ALL EXPRESS OR IMPLIED CONDITIONS,
REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT
ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT THESE DISCLAIMERS ARE HELD TO
BE LEGALLY INVALID.

10.     Limitation of Liability.

TO THE EXTENT NOT PROHIBITED BY LAW, IN NO EVENT WILL SUN OR ITS
LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR
SPECIAL, INDIRECT, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
HOWEVER CAUSED REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF OR
RELATED TO THE USE OF OR INABILITY TO USE SOFTWARE, EVEN IF SUN HAS
BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. In no event will Sun's
liability to you, whether in contract, tort (including negligence), or
otherwise, exceed the amount paid by you for Software under this
Agreement. The foregoing limitations will apply even if the above
stated warranty fails of its essential purpose. Some states do not
allow the exclusion of incidental or consequential damages, so some of
the terms above may not be applicable to you.

11.     Export Regulations.

All Software, documents, technical data, and any other materials
delivered under this Agreement are subject to U.S. export control laws
and may be subject to export or import regulations in other countries.
You agree to comply strictly with these laws and regulations and
acknowledge that you have the responsibility to obtain any licenses to
export, re-export, or import as may be required after delivery to you.

12.     U.S. Government Restricted Rights.

If Software is being acquired by or on behalf of the U.S. Government or
by a U.S. Government prime contractor or subcontractor (at any tier),
then the Government's rights in Software and accompanying documentation
will be only as set forth in this Agreement; this is in accordance with
48 CFR 227.7201 through 227.7202-4 (for Department of Defense (DOD)
acquisitions) and with 48 CFR 2.101 and 12.212 (for non-DOD
acquisitions).

13.     Governing Law.

Any action related to this Agreement will be governed by California law
and controlling U.S. federal law. No choice of law rules of any
jurisdiction will apply.

14.     Severability.

If any provision of this Agreement is held to be unenforceable, this
Agreement will remain in effect with the provision omitted, unless
omission would frustrate the intent of the parties, in which case this
Agreement will immediately terminate.

15.     Integration.

This Agreement, including any terms contained in your Entitlement, is
the entire agreement between you and Sun relating to its subject
matter. It supersedes all prior or contemporaneous oral or written
communications, proposals, representations and warranties and prevails
over any conflicting or additional terms of any quote, order,
acknowledgment, or other communication between the parties relating to
its subject matter during the term of this Agreement. No modification
of this Agreement will be binding, unless in writing and signed by an
authorized representative of each party.

Please contact Sun Microsystems, Inc. 4150 Network Circle, Santa Clara,
California 95054 if you have questions.

JACOB license text

JACOB (jacob.jar and jacob.dll) is distributed under the following license.
For further information and source code, please visit http://danadler.com/jacob/

/*
 * Copyright (c) 1999-2001 Dan Adler, 315 E72 St. NY, NY, 10021, USA.
 * mailto:danadler@rcn.com. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in 
 *    the documentation and/or other materials provided with the
 *    distribution.
 * 3. Redistributions in any form must be accompanied by information on
 *    how to obtain complete source code for the JACOB software.
 *
 * Redistribution of the JACOB software is not permitted as part of any
 * commercial product that is targeted primarily at Java developers.
 * Such products include, but are not limited to: Java virtual machines,
 * integrated development environments, code libraries, and application
 * server products. Licensing terms for such distribution may be
 * obtained from the copyright holder.
 *
 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED 
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED.  IN NO EVENT SHALL THE COPYRIGHT HOLDER BE LIABLE
 * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
 * OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
 * OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; 
 * OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
 * USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 * SUCH DAMAGE.
 */

Transform SWF license text

 /*
 * All the files in this library are covered under the terms of the Berkeley
 * Software Distribution (BSD) License:
 *
 * Copyright (c) 2001-2004 Flagstone Software Ltd. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, 
 * are permitted provided that the following conditions are met:
 *
 *  * Redistributions of source code must retain the above copyright notice, this
 *    list of conditions and the following disclaimer.
 *  * Redistributions in binary form must reproduce the above copyright notice, 
 *    this list of conditions and the following disclaimer in the documentation 
 *    and/or other materials provided with the distribution.
 *  * Neither the name of Flagstone Software Ltd. nor the names of its contributors 
 *    may be used to endorse or promote products derived from this software 
 *    without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND 
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. 
 * IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 
 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF 
 * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE 
 * OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED 
 * OF THE POSSIBILITY OF SUCH DAMAGE.
 */

JavaMail license text

Sun Microsystems, Inc. ("Sun") ENTITLEMENT for SOFTWARE

Licensee/Company: Entity receiving Software.

Effective Date: Date of delivery of the Software to You.

Software: JavaMail 1.4.1.

License Term:  Perpetual (subject to termination under the SLA).

Licensed Unit: Software Copy.

Licensed unit Count: Unlimited.

Permitted Uses:

1. You may reproduce and use the Software for Individual, Commercial,
or Research and Instructional Use for the purposes of designing,
developing, testing, and running Your applets and
application("Programs").

2. Subject to the terms and conditions of this Agreement and
restrictions and exceptions set forth in the Software's documentation,
You may reproduce and distribute portions of Software identified as a
redistributable in the documentation ("Redistributable"), provided
that:

(a) you distribute Redistributable complete and unmodified and only
bundled as part of Your Programs,

(b) your Programs add significant and primary functionality to the
Redistributable,

(c) you distribute Redistributable for the sole purpose of running your
Programs,

(d) you do not distribute additional software intended to replace any
component(s) of the Redistributable,

(e) you do not remove or alter any proprietary legends or notices
contained in or on the Redistributable.

(f) you only distribute the Redistributable subject to a license
agreement that protects Sun's interests consistent with the terms
contained in this Agreement, and

(g) you agree to defend and indemnify Sun and its licensors from and
against any damages, costs, liabilities, settlement amounts and/or
expenses  (including attorneys' fees) incurred in connection with any
claim, lawsuit or action by any third party that arises or results from
the use or distribution of any and all Programs and/or
Redistributable.

3. Java Technology Restrictions.  You may not create, modify, or change
the behavior of, or authorize your licensees to create, modify, or
change the behavior of, classes, interfaces, or subpackages that are in
any way identified as "java", "javax", "sun" or similar convention as
specified by Sun in any naming convention designation.

B. Sun Microsystems, Inc. ("Sun")
SOFTWARE LICENSE AGREEMENT

READ THE TERMS OF THIS AGREEMENT ("AGREEMENT") CAREFULLY BEFORE OPENING
SOFTWARE MEDIA PACKAGE. BY OPENING SOFTWARE MEDIA PACKAGE, YOU AGREE TO
THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCESSING SOFTWARE
ELECTRONICALLY, INDICATE YOUR ACCEPTANCE OF THESE TERMS BY SELECTING
THE "ACCEPT" BUTTON AT THE END OF THIS AGREEMENT. IF YOU DO NOT AGREE
TO ALL OF THE TERMS, PROMPTLY RETURN THE UNUSED SOFTWARE TO YOUR PLACE
OF PURCHASE FOR A REFUND OR, IF SOFTWARE IS ACCESSED ELECTRONICALLY,
SELECT THE "DECLINE" (OR "EXIT") BUTTON AT THE END OF THIS AGREEMENT.
IF YOU HAVE SEPARATELY AGREED TO LICENSE TERMS ("MASTER TERMS") FOR
YOUR LICENSE TO THIS SOFTWARE, THEN SECTIONS 1-5 OF THIS AGREEMENT
("SUPPLEMENTAL LICENSE TERMS") SHALL SUPPLEMENT AND SUPERSEDE THE
MASTER TERMS IN RELATION TO THIS SOFTWARE.

1.      Definitions.

(a)     "Entitlement" means the collective set of applicable documents
authorized by Sun evidencing your obligation to pay associated fees (if
any) for the license, associated Services, and the authorized scope of
use of Software under this Agreement.

(b)     "Licensed Unit" means the unit of measure by which your use of
Software and/or Service is licensed, as described in your Entitlement.

(c)     "Permitted Use" means the licensed Software use(s) authorized
in this Agreement as specified in your Entitlement. The Permitted Use
for any bundled Sun software not specified in your Entitlement will be
evaluation use as provided in Section 3.

(d)     "Service" means the service(s) that Sun or its delegate will
provide, if any, as selected in your Entitlement and as further
described in the applicable service listings at
www.sun.com/service/servicelist.

(e)     "Software" means the Sun software described in your
Entitlement. Also, certain software may be included for evaluation use
under Section 3.


(f)     "You" and "Your" means the individual or legal entity specified
in the Entitlement, or for evaluation purposes, the entity performing
the evaluation.

2.      License Grant and Entitlement.

Subject to the terms of your Entitlement, Sun grants you a
nonexclusive, nontransferable limited license to use Software for its
Permitted Use for the license term. Your Entitlement will specify (a)
Software licensed, (b) the Permitted Use, (c) the license term, and (d)
the Licensed Units.

Additionally, if your Entitlement includes Services, then it will also
specify the (e) Service and (f) service term.

If your rights to Software or Services are limited in duration and the
date such rights begin is other than the purchase date, your
Entitlement will provide that beginning date(s).

The Entitlement may be delivered to you in various ways depending on
the manner in which you obtain Software and Services, for example, the
Entitlement may be provided in your receipt, invoice or your contract
with Sun or authorized Sun reseller. It may also be in electronic
format if you download Software.

3.      Permitted Use.

As selected in your Entitlement, one or more of the following Permitted
Uses will apply to your use of Software. Unless you have an Entitlement
that expressly permits it, you may not use Software for any of the
other Permitted Uses. If you don't have an Entitlement, or if your
Entitlement doesn't cover additional software delivered to you, then
such software is for your Evaluation Use.

(a) Evaluation Use. You may evaluate Software internally for a period
of 90 days from your first use.

(b) Research and Instructional Use. You may use Software internally to
design, develop and test, and also to provide instruction on such
uses.

(c) Individual Use. You may use Software internally for personal,
individual use.

(d) Commercial Use. You may use Software internally for your own
commercial purposes.

(e) Service Provider Use. You may make Software functionality
accessible (but not by providing Software itself or through outsourcing
services) to your end users in an extranet deployment, but not to your
affiliated companies or to government agencies.

4.      Licensed Units.

Your Permitted Use is limited to the number of Licensed Units stated in
your Entitlement. If you require additional Licensed Units, you will
need additional Entitlement(s).

5.  Restrictions.

(a) The copies of Software provided to you under this Agreement are
licensed, not sold, to you by Sun. Sun reserves all rights not
expressly granted. (b) You may make a single archival copy of Software,
but otherwise may not copy, modify, or distribute Software. However if
the Sun documentation accompanying Software lists specific portions of
Software, such as header files, class libraries, reference source code,
and/or redistributable files, that may be handled differently, you may
do so only as provided in the Sun documentation. (c) You may not rent,
lease, lend or encumber Software. (d) Unless enforcement is prohibited
by applicable law, you may not decompile, or reverse engineer Software.
(e) The terms and conditions of this Agreement will apply to any
Software updates, provided to you at Sun's discretion, that replace
and/or supplement the original Software, unless such update contains a
separate license. (f) You may not publish or provide the results of any
benchmark or comparison tests run on Software to any third party
without the prior written consent of Sun. (g) Software is confidential
and copyrighted. (h) Unless otherwise specified, if Software is
delivered with embedded or bundled software that enables functionality
of Software, you may not use such software on a stand-alone basis or
use any portion of such software to interoperate with any program(s)
other than Software. (i) Software may contain programs that perform
automated collection of system data and/or automated software updating
services. System data collected through such programs may be used by
Sun, its subcontractors, and its service delivery partners for the
purpose of providing you with remote system services and/or improving
Sun's software and systems. (j) Software is not designed, licensed or
intended for use in the design, construction, operation or maintenance
of any nuclear facility and Sun and its licensors disclaim any express
or implied warranty of fitness for such uses. (k) No right, title or
interest in or to any trademark, service mark, logo or trade name of
Sun or its licensors is granted under this Agreement.

6.      Term and Termination.

The license and service term are set forth in your Entitlement(s). Your
rights under this Agreement will terminate immediately without notice
from Sun if you materially breach it or take any action in derogation
of Sun's and/or its licensors' rights to Software. Sun may terminate
this Agreement should any Software become, or in Sun's reasonable
opinion likely to become, the subject of a claim of intellectual
property infringement or trade secret misappropriation. Upon
termination, you will cease use of, and destroy, Software and confirm
compliance in writing to Sun. Sections 1, 5, 6, 7, and 9-15 will
survive termination of the Agreement.

7.      Java Compatibility and Open Source.

Software may contain Java technology. You may not create additional
classes to, or modifications of, the Java technology, except under
compatibility requirements available under a separate agreement
available at www.java.net.

Sun supports and benefits from the global community of open source
developers, and thanks the community for its important contributions
and open standards-based technology, which Sun has adopted into many of
its products.

Please note that portions of Software may be provided with notices and
open source licenses from such communities and third parties that
govern the use of those portions, and any licenses granted hereunder do
not alter any rights and obligations you may have under such open
source licenses, however, the disclaimer of warranty and limitation of
liability provisions in this Agreement will apply to all Software in
this distribution.

8.      Limited Warranty.

Sun warrants to you that for a period of 90 days from the date of
purchase, as evidenced by a copy of the receipt, the media on which
Software is furnished (if any) will be free of defects in materials and
workmanship under normal use. Except for the foregoing, Software is
provided "AS IS". Your exclusive remedy and Sun's entire liability
under this limited warranty will be at Sun's option to replace Software
media or refund the fee paid for Software. Some states do not allow
limitations on certain implied warranties, so the above may not apply
to you. This limited warranty gives you specific legal rights. You may
have others, which vary from state to state.

9.      Disclaimer of Warranty.

UNLESS SPECIFIED IN THIS AGREEMENT, ALL EXPRESS OR IMPLIED CONDITIONS,
REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT
ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT THESE DISCLAIMERS ARE HELD TO
BE LEGALLY INVALID.

10.     Limitation of Liability.

TO THE EXTENT NOT PROHIBITED BY LAW, IN NO EVENT WILL SUN OR ITS
LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR
SPECIAL, INDIRECT, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
HOWEVER CAUSED REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF OR
RELATED TO THE USE OF OR INABILITY TO USE SOFTWARE, EVEN IF SUN HAS
BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. In no event will Sun's
liability to you, whether in contract, tort (including negligence), or
otherwise, exceed the amount paid by you for Software under this
Agreement. The foregoing limitations will apply even if the above
stated warranty fails of its essential purpose. Some states do not
allow the exclusion of incidental or consequential damages, so some of
the terms above may not be applicable to you.

11.     Export Regulations.

All Software, documents, technical data, and any other materials
delivered under this Agreement are subject to U.S. export control laws
and may be subject to export or import regulations in other countries.
You agree to comply strictly with these laws and regulations and
acknowledge that you have the responsibility to obtain any licenses to
export, re-export, or import as may be required after delivery to you.

12.     U.S. Government Restricted Rights.

If Software is being acquired by or on behalf of the U.S. Government or
by a U.S. Government prime contractor or subcontractor (at any tier),
then the Government's rights in Software and accompanying documentation
will be only as set forth in this Agreement; this is in accordance with
48 CFR 227.7201 through 227.7202-4 (for Department of Defense (DOD)
acquisitions) and with 48 CFR 2.101 and 12.212 (for non-DOD
acquisitions).

13.     Governing Law.

Any action related to this Agreement will be governed by California law
and controlling U.S. federal law. No choice of law rules of any
jurisdiction will apply.

14.     Severability.

If any provision of this Agreement is held to be unenforceable, this
Agreement will remain in effect with the provision omitted, unless
omission would frustrate the intent of the parties, in which case this
Agreement will immediately terminate.

15.     Integration.

This Agreement, including any terms contained in your Entitlement, is
the entire agreement between you and Sun relating to its subject
matter. It supersedes all prior or contemporaneous oral or written
communications, proposals, representations and warranties and prevails
over any conflicting or additional terms of any quote, order,
acknowledgment, or other communication between the parties relating to
its subject matter during the term of this Agreement. No modification
of this Agreement will be binding, unless in writing and signed by an
authorized representative of each party.

Please contact Sun Microsystems, Inc. 4150 Network Circle, Santa Clara,
California 95054 if you have questions.

JDIC license text

Copyright (c) 2004 Sun Microsystems, Inc., 4150 Network Circle, Santa
Clara, California 95054, U.S.A. All rights reserved.  Use is subject
to license terms below.  Sun, Sun Microsystems and the Sun logo are
trademarks or registered trademarks of Sun Microsystems, Inc. in the
U.S. and other countries.
 
Notice: This product is covered by U.S. export control laws and may be
subject to the export or import laws in other countries. These laws may
restrict the fields of use for this software and may require you to
secure government authorization.
 
            GNU LESSER GENERAL PUBLIC LICENSE
               Version 2.1, February 1999

 Copyright (C) 1991, 1999 Free Software Foundation, Inc.
     59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 Everyone is permitted to copy and distribute verbatim copies
 of this license document, but changing it is not allowed.

[This is the first released version of the Lesser GPL.  It also counts
 as the successor of the GNU Library Public License, version 2, hence
 the version number 2.1.]

                Preamble

  The licenses for most software are designed to take away your
freedom to share and change it.  By contrast, the GNU General Public
Licenses are intended to guarantee your freedom to share and change
free software--to make sure the software is free for all its users.

  This license, the Lesser General Public License, applies to some
specially designated software packages--typically libraries--of the
Free Software Foundation and other authors who decide to use it.  You
can use it too, but we suggest you first think carefully about whether
this license or the ordinary General Public License is the better
strategy to use in any particular case, based on the explanations below.

  When we speak of free software, we are referring to freedom of use,
not price.  Our General Public Licenses are designed to make sure that
you have the freedom to distribute copies of free software (and charge
for this service if you wish); that you receive source code or can get
it if you want it; that you can change the software and use pieces of
it in new free programs; and that you are informed that you can do
these things.

  To protect your rights, we need to make restrictions that forbid
distributors to deny you these rights or to ask you to surrender these
rights.  These restrictions translate to certain responsibilities for
you if you distribute copies of the library or if you modify it.

  For example, if you distribute copies of the library, whether gratis
or for a fee, you must give the recipients all the rights that we gave
you.  You must make sure that they, too, receive or can get the source
code.  If you link other code with the library, you must provide
complete object files to the recipients, so that they can relink them
with the library after making changes to the library and recompiling
it.  And you must show them these terms so they know their rights.

  We protect your rights with a two-step method: (1) we copyright the
library, and (2) we offer you this license, which gives you legal
permission to copy, distribute and/or modify the library.

  To protect each distributor, we want to make it very clear that
there is no warranty for the free library.  Also, if the library is
modified by someone else and passed on, the recipients should know
that what they have is not the original version, so that the original
author's reputation will not be affected by problems that might be
introduced by others.

  Finally, software patents pose a constant threat to the existence of
any free program.  We wish to make sure that a company cannot
effectively restrict the users of a free program by obtaining a
restrictive license from a patent holder.  Therefore, we insist that
any patent license obtained for a version of the library must be
consistent with the full freedom of use specified in this license.

  Most GNU software, including some libraries, is covered by the
ordinary GNU General Public License.  This license, the GNU Lesser
General Public License, applies to certain designated libraries, and
is quite different from the ordinary General Public License.  We use
this license for certain libraries in order to permit linking those
libraries into non-free programs.

  When a program is linked with a library, whether statically or using
a shared library, the combination of the two is legally speaking a
combined work, a derivative of the original library.  The ordinary
General Public License therefore permits such linking only if the
entire combination fits its criteria of freedom.  The Lesser General
Public License permits more lax criteria for linking other code with
the library.

  We call this license the "Lesser" General Public License because it
does Less to protect the user's freedom than the ordinary General
Public License.  It also provides other free software developers Less
of an advantage over competing non-free programs.  These disadvantages
are the reason we use the ordinary General Public License for many
libraries.  However, the Lesser license provides advantages in certain
special circumstances.

  For example, on rare occasions, there may be a special need to
encourage the widest possible use of a certain library, so that it becomes
a de-facto standard.  To achieve this, non-free programs must be
allowed to use the library.  A more frequent case is that a free
library does the same job as widely used non-free libraries.  In this
case, there is little to gain by limiting the free library to free
software only, so we use the Lesser General Public License.

  In other cases, permission to use a particular library in non-free
programs enables a greater number of people to use a large body of
free software.  For example, permission to use the GNU C Library in
non-free programs enables many more people to use the whole GNU
operating system, as well as its variant, the GNU/Linux operating
system.

  Although the Lesser General Public License is Less protective of the
users' freedom, it does ensure that the user of a program that is
linked with the Library has the freedom and the wherewithal to run
that program using a modified version of the Library.

  The precise terms and conditions for copying, distribution and
modification follow.  Pay close attention to the difference between a
"work based on the library" and a "work that uses the library".  The
former contains code derived from the library, whereas the latter must
be combined with the library in order to run.

          GNU LESSER GENERAL PUBLIC LICENSE
   TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION

  0. This License Agreement applies to any software library or other
program which contains a notice placed by the copyright holder or
other authorized party saying it may be distributed under the terms of
this Lesser General Public License (also called "this License").
Each licensee is addressed as "you".

  A "library" means a collection of software functions and/or data
prepared so as to be conveniently linked with application programs
(which use some of those functions and data) to form executables.

  The "Library", below, refers to any such software library or work
which has been distributed under these terms.  A "work based on the
Library" means either the Library or any derivative work under
copyright law: that is to say, a work containing the Library or a
portion of it, either verbatim or with modifications and/or translated
straightforwardly into another language.  (Hereinafter, translation is
included without limitation in the term "modification".)

  "Source code" for a work means the preferred form of the work for
making modifications to it.  For a library, complete source code means
all the source code for all modules it contains, plus any associated
interface definition files, plus the scripts used to control compilation
and installation of the library.

  Activities other than copying, distribution and modification are not
covered by this License; they are outside its scope.  The act of
running a program using the Library is not restricted, and output from
such a program is covered only if its contents constitute a work based
on the Library (independent of the use of the Library in a tool for
writing it).  Whether that is true depends on what the Library does
and what the program that uses the Library does.

  1. You may copy and distribute verbatim copies of the Library's
complete source code as you receive it, in any medium, provided that
you conspicuously and appropriately publish on each copy an
appropriate copyright notice and disclaimer of warranty; keep intact
all the notices that refer to this License and to the absence of any
warranty; and distribute a copy of this License along with the
Library.

  You may charge a fee for the physical act of transferring a copy,
and you may at your option offer warranty protection in exchange for a
fee.

  2. You may modify your copy or copies of the Library or any portion
of it, thus forming a work based on the Library, and copy and
distribute such modifications or work under the terms of Section 1
above, provided that you also meet all of these conditions:

    a) The modified work must itself be a software library.

    b) You must cause the files modified to carry prominent notices
    stating that you changed the files and the date of any change.

    c) You must cause the whole of the work to be licensed at no
    charge to all third parties under the terms of this License.

    d) If a facility in the modified Library refers to a function or a
    table of data to be supplied by an application program that uses
    the facility, other than as an argument passed when the facility
    is invoked, then you must make a good faith effort to ensure that,
    in the event an application does not supply such function or
    table, the facility still operates, and performs whatever part of
    its purpose remains meaningful.

    (For example, a function in a library to compute square roots has
    a purpose that is entirely well-defined independent of the
    application.  Therefore, Subsection 2d requires that any
    application-supplied function or table used by this function must
    be optional: if the application does not supply it, the square
    root function must still compute square roots.)

These requirements apply to the modified work as a whole.  If
identifiable sections of that work are not derived from the Library,
and can be reasonably considered independent and separate works in
themselves, then this License, and its terms, do not apply to those
sections when you distribute them as separate works.  But when you
distribute the same sections as part of a whole which is a work based
on the Library, the distribution of the whole must be on the terms of
this License, whose permissions for other licensees extend to the
entire whole, and thus to each and every part regardless of who wrote
it.

Thus, it is not the intent of this section to claim rights or contest
your rights to work written entirely by you; rather, the intent is to
exercise the right to control the distribution of derivative or
collective works based on the Library.

In addition, mere aggregation of another work not based on the Library
with the Library (or with a work based on the Library) on a volume of
a storage or distribution medium does not bring the other work under
the scope of this License.

  3. You may opt to apply the terms of the ordinary GNU General Public
License instead of this License to a given copy of the Library.  To do
this, you must alter all the notices that refer to this License, so
that they refer to the ordinary GNU General Public License, version 2,
instead of to this License.  (If a newer version than version 2 of the
ordinary GNU General Public License has appeared, then you can specify
that version instead if you wish.)  Do not make any other change in
these notices.

  Once this change is made in a given copy, it is irreversible for
that copy, so the ordinary GNU General Public License applies to all
subsequent copies and derivative works made from that copy.

  This option is useful when you wish to copy part of the code of
the Library into a program that is not a library.

  4. You may copy and distribute the Library (or a portion or
derivative of it, under Section 2) in object code or executable form
under the terms of Sections 1 and 2 above provided that you accompany
it with the complete corresponding machine-readable source code, which
must be distributed under the terms of Sections 1 and 2 above on a
medium customarily used for software interchange.

  If distribution of object code is made by offering access to copy
from a designated place, then offering equivalent access to copy the
source code from the same place satisfies the requirement to
distribute the source code, even though third parties are not
compelled to copy the source along with the object code.

  5. A program that contains no derivative of any portion of the
Library, but is designed to work with the Library by being compiled or
linked with it, is called a "work that uses the Library".  Such a
work, in isolation, is not a derivative work of the Library, and
therefore falls outside the scope of this License.

  However, linking a "work that uses the Library" with the Library
creates an executable that is a derivative of the Library (because it
contains portions of the Library), rather than a "work that uses the
library".  The executable is therefore covered by this License.
Section 6 states terms for distribution of such executables.

  When a "work that uses the Library" uses material from a header file
that is part of the Library, the object code for the work may be a
derivative work of the Library even though the source code is not.
Whether this is true is especially significant if the work can be
linked without the Library, or if the work is itself a library.  The
threshold for this to be true is not precisely defined by law.

  If such an object file uses only numerical parameters, data
structure layouts and accessors, and small macros and small inline
functions (ten lines or less in length), then the use of the object
file is unrestricted, regardless of whether it is legally a derivative
work.  (Executables containing this object code plus portions of the
Library will still fall under Section 6.)

  Otherwise, if the work is a derivative of the Library, you may
distribute the object code for the work under the terms of Section 6.
Any executables containing that work also fall under Section 6,
whether or not they are linked directly with the Library itself.

  6. As an exception to the Sections above, you may also combine or
link a "work that uses the Library" with the Library to produce a
work containing portions of the Library, and distribute that work
under terms of your choice, provided that the terms permit
modification of the work for the customer's own use and reverse
engineering for debugging such modifications.

  You must give prominent notice with each copy of the work that the
Library is used in it and that the Library and its use are covered by
this License.  You must supply a copy of this License.  If the work
during execution displays copyright notices, you must include the
copyright notice for the Library among them, as well as a reference
directing the user to the copy of this License.  Also, you must do one
of these things:

    a) Accompany the work with the complete corresponding
    machine-readable source code for the Library including whatever
    changes were used in the work (which must be distributed under
    Sections 1 and 2 above); and, if the work is an executable linked
    with the Library, with the complete machine-readable "work that
    uses the Library", as object code and/or source code, so that the
    user can modify the Library and then relink to produce a modified
    executable containing the modified Library.  (It is understood
    that the user who changes the contents of definitions files in the
    Library will not necessarily be able to recompile the application
    to use the modified definitions.)

    b) Use a suitable shared library mechanism for linking with the
    Library.  A suitable mechanism is one that (1) uses at run time a
    copy of the library already present on the user's computer system,
    rather than copying library functions into the executable, and (2)
    will operate properly with a modified version of the library, if
    the user installs one, as long as the modified version is
    interface-compatible with the version that the work was made with.

    c) Accompany the work with a written offer, valid for at
    least three years, to give the same user the materials
    specified in Subsection 6a, above, for a charge no more
    than the cost of performing this distribution.

    d) If distribution of the work is made by offering access to copy
    from a designated place, offer equivalent access to copy the above
    specified materials from the same place.

    e) Verify that the user has already received a copy of these
    materials or that you have already sent this user a copy.

  For an executable, the required form of the "work that uses the
Library" must include any data and utility programs needed for
reproducing the executable from it.  However, as a special exception,
the materials to be distributed need not include anything that is
normally distributed (in either source or binary form) with the major
components (compiler, kernel, and so on) of the operating system on
which the executable runs, unless that component itself accompanies
the executable.

  It may happen that this requirement contradicts the license
restrictions of other proprietary libraries that do not normally
accompany the operating system.  Such a contradiction means you cannot
use both them and the Library together in an executable that you
distribute.

  7. You may place library facilities that are a work based on the
Library side-by-side in a single library together with other library
facilities not covered by this License, and distribute such a combined
library, provided that the separate distribution of the work based on
the Library and of the other library facilities is otherwise
permitted, and provided that you do these two things:

    a) Accompany the combined library with a copy of the same work
    based on the Library, uncombined with any other library
    facilities.  This must be distributed under the terms of the
    Sections above.

    b) Give prominent notice with the combined library of the fact
    that part of it is a work based on the Library, and explaining
    where to find the accompanying uncombined form of the same work.

  8. You may not copy, modify, sublicense, link with, or distribute
the Library except as expressly provided under this License.  Any
attempt otherwise to copy, modify, sublicense, link with, or
distribute the Library is void, and will automatically terminate your
rights under this License.  However, parties who have received copies,
or rights, from you under this License will not have their licenses
terminated so long as such parties remain in full compliance.

  9. You are not required to accept this License, since you have not
signed it.  However, nothing else grants you permission to modify or
distribute the Library or its derivative works.  These actions are
prohibited by law if you do not accept this License.  Therefore, by
modifying or distributing the Library (or any work based on the
Library), you indicate your acceptance of this License to do so, and
all its terms and conditions for copying, distributing or modifying
the Library or works based on it.

  10. Each time you redistribute the Library (or any work based on the
Library), the recipient automatically receives a license from the
original licensor to copy, distribute, link with or modify the Library
subject to these terms and conditions.  You may not impose any further
restrictions on the recipients' exercise of the rights granted herein.
You are not responsible for enforcing compliance by third parties with
this License.

  11. If, as a consequence of a court judgment or allegation of patent
infringement or for any other reason (not limited to patent issues),
conditions are imposed on you (whether by court order, agreement or
otherwise) that contradict the conditions of this License, they do not
excuse you from the conditions of this License.  If you cannot
distribute so as to satisfy simultaneously your obligations under this
License and any other pertinent obligations, then as a consequence you
may not distribute the Library at all.  For example, if a patent
license would not permit royalty-free redistribution of the Library by
all those who receive copies directly or indirectly through you, then
the only way you could satisfy both it and this License would be to
refrain entirely from distribution of the Library.

If any portion of this section is held invalid or unenforceable under any
particular circumstance, the balance of the section is intended to apply,
and the section as a whole is intended to apply in other circumstances.

It is not the purpose of this section to induce you to infringe any
patents or other property right claims or to contest validity of any
such claims; this section has the sole purpose of protecting the
integrity of the free software distribution system which is
implemented by public license practices.  Many people have made
generous contributions to the wide range of software distributed
through that system in reliance on consistent application of that
system; it is up to the author/donor to decide if he or she is willing
to distribute software through any other system and a licensee cannot
impose that choice.

This section is intended to make thoroughly clear what is believed to
be a consequence of the rest of this License.

  12. If the distribution and/or use of the Library is restricted in
certain countries either by patents or by copyrighted interfaces, the
original copyright holder who places the Library under this License may add
an explicit geographical distribution limitation excluding those countries,
so that distribution is permitted only in or among countries not thus
excluded.  In such case, this License incorporates the limitation as if
written in the body of this License.

  13. The Free Software Foundation may publish revised and/or new
versions of the Lesser General Public License from time to time.
Such new versions will be similar in spirit to the present version,
but may differ in detail to address new problems or concerns.

Each version is given a distinguishing version number.  If the Library
specifies a version number of this License which applies to it and
"any later version", you have the option of following the terms and
conditions either of that version or of any later version published by
the Free Software Foundation.  If the Library does not specify a
license version number, you may choose any version ever published by
the Free Software Foundation.

  14. If you wish to incorporate parts of the Library into other free
programs whose distribution conditions are incompatible with these,
write to the author to ask for permission.  For software which is
copyrighted by the Free Software Foundation, write to the Free
Software Foundation; we sometimes make exceptions for this.  Our
decision will be guided by the two goals of preserving the free status
of all derivatives of our free software and of promoting the sharing
and reuse of software generally.

                NO WARRANTY

  15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO
WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW.
EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR
OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY
KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE.  THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE
LIBRARY IS WITH YOU.  SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME
THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.

  16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN
WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY
AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU
FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR
CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE
LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING
RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A
FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF
SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH
DAMAGES.

             END OF TERMS AND CONDITIONS

           How to Apply These Terms to Your New Libraries

  If you develop a new library, and you want it to be of the greatest
possible use to the public, we recommend making it free software that
everyone can redistribute and change.  You can do so by permitting
redistribution under these terms (or, alternatively, under the terms of the
ordinary General Public License).

  To apply these terms, attach the following notices to the library.  It is
safest to attach them to the start of each source file to most effectively
convey the exclusion of warranty; and each file should have at least the
"copyright" line and a pointer to where the full notice is found.

    <one line to give the library's name and a brief idea of what it does.>
    Copyright (C) <year>  <name of author>

    This library is free software; you can redistribute it and/or
    modify it under the terms of the GNU Lesser General Public
    License as published by the Free Software Foundation; either
    version 2.1 of the License, or (at your option) any later version.

    This library is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
    Lesser General Public License for more details.

    You should have received a copy of the GNU Lesser General Public
    License along with this library; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307  USA

Also add information on how to contact you by electronic and paper mail.

You should also get your employer (if you work as a programmer) or your
school, if any, to sign a "copyright disclaimer" for the library, if
necessary.  Here is a sample; alter the names:

  Yoyodyne, Inc., hereby disclaims all copyright interest in the
  library `Frob' (a library for tweaking knobs) written by James Random Hacker.

  <signature of Ty Coon>, 1 April 1990
  Ty Coon, President of Vice

Java Service Wrapper license txt

Copyright (c) 1999, 2006 Tanuki Software, Inc.

Permission is hereby granted, free of charge, to any person
obtaining a copy of the Java Service Wrapper and associated
documentation files (the "Software"), to deal in the Software
without  restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sub-license,
and/or sell copies of the Software, and to permit persons to
whom the Software is furnished to do so, subject to the
following conditions:

The above copyright notice and this permission notice shall be
included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, 
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES 
OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND 
NON-INFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT 
HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, 
WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
OTHER DEALINGS IN THE SOFTWARE.


Portions of the Software have been derived from source code
developed by Silver Egg Technology under the following license:

BEGIN Silver Egg Techology License -----------------------------------
    
    Copyright (c) 2001 Silver Egg Technology
    
    Permission is hereby granted, free of charge, to any person
    obtaining a copy of this software and associated documentation
    files (the "Software"), to deal in the Software without 
    restriction, including without limitation the rights to use, 
    copy, modify, merge, publish, distribute, sub-license, and/or 
    sell copies of the Software, and to permit persons to whom the
    Software is furnished to do so, subject to the following 
    conditions:
    
    The above copyright notice and this permission notice shall be
    included in all copies or substantial portions of the Software.
    
    THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, 
    EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES 
    OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND 
    NON-INFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT 
    HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, 
    WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
    FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
    OTHER DEALINGS IN THE SOFTWARE.
    
END Silver Egg Techology License -------------------------------------

POI license text

                                 Apache License
                           Version 2.0, January 2004
                        http://www.apache.org/licenses/

   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION

   1. Definitions.

      "License" shall mean the terms and conditions for use, reproduction,
      and distribution as defined by Sections 1 through 9 of this document.

      "Licensor" shall mean the copyright owner or entity authorized by
      the copyright owner that is granting the License.

      "Legal Entity" shall mean the union of the acting entity and all
      other entities that control, are controlled by, or are under common
      control with that entity. For the purposes of this definition,
      "control" means (i) the power, direct or indirect, to cause the
      direction or management of such entity, whether by contract or
      otherwise, or (ii) ownership of fifty percent (50%) or more of the
      outstanding shares, or (iii) beneficial ownership of such entity.

      "You" (or "Your") shall mean an individual or Legal Entity
      exercising permissions granted by this License.

      "Source" form shall mean the preferred form for making modifications,
      including but not limited to software source code, documentation
      source, and configuration files.

      "Object" form shall mean any form resulting from mechanical
      transformation or translation of a Source form, including but
      not limited to compiled object code, generated documentation,

Miscellaneous

Miscellaneous topics

Translation Guide

Language Translation Guide

Translation Process

Editing translations:

Submitting translations back to Visokio:

Doing further translations:

Please respect the Languages .IOK file structure

Translation Guidelines

Case A: Translating a language for the first time

Case B: Adding country-specific text to already-translated "mother" language

Case C: Corrections to existing translated text

General notes and rules

Notes on English terminology

XML Schema

Visokio XML Schema

Visokio Namespace

Example XML Files

Flash Skins

Modifying Flash Skins/Components

Requirements for creating new skins

Visokio Flash Skin Template File

Component- Barometer

Elements

Color replacements

Component-Buttons

Fetch Buttons

Elements

Color replacements

Reset Buttons

Elements

Color replacements

Component-Details

Elements

Outer Frame

Inner Frame

Buttons

Component-Frame

Elements

Outer Frame

Inner Frame

Component-Query Devices

Query Device Frame

Outer Frame

Inner FrameCheckboxes

Feature checkbox

Slider

Spacer

Functions Guide

Visokio Functions and Formulae

Contents:

Function

Usage

Description

Visokio Functions

Visokio DATASET Functions

Useful Formulae

Useful Formulae

1. 'Bucketing' values:

2. Fiscal year 'bucketing':

3. Converting/Parsing dates:

4. Flagging extreme values:

5. Value counts:

Proposed New Functions

Proposed New Functions

3rd Party Licenses

3rd Party Licenses

Inner Frame

Checkboxes