GUI Preferences

The GUI Preferences tab of the User Manager page contains information related to a particular user's preferences in the 1010data web interface.

General

Favorite Folders and Tables (ids): A space-separated list of numeric table IDs that the user has flagged as favorites.
Allow 0 row tables when the macro is annotated with empty: When selected, this allows selections resulting in tables with 0 rows, if the macro contains <meta>empty<meta>.
If this is not selected (or if this is selected, but the macro does not contain the empty <meta> element), the user will receive an error saying that no rows were selected.

Location

Time Zone

The time zone that is used when showing the date and time on reports.

The options are presented as offsets to the Greenwich Mean Time.

For example, New York is in the Eastern Time Zone of the United States, and Eastern Standard Time (EST) is 5 hours behind Greenwich Mean Time. Therefore, the appropriate selection for New York would be GMT-5.

Region Format

This determines the order in which dates are presented (or downloaded as formatted values), when using the date, date4y, and datehms24 display formats as well as how numbers (i.e., integers and decimals) are displayed.


	Date	Date+Time	Integer	Decimal
USA	`MM/DD/YY`	`MM/DD/YY_HH:MM:SS`	`10,000`	`0.001`
Europe	`DD.MM.YY`	`DD.MM.YY_HH:MM:SS`	`10.000`	`0,001`
United Kingdom	`DD/MM/YY`	`DD/MM/YY_HH:MM:SS`	`10,000`	`0.001`
ANSI	`YYYY-MM-DD`	`YYYY-MM-DD HH:MM:SS`	`10,000`	`0.001`

User Interface

Return focus to browser window

When selected, the browser window regains focus after a query completes. If the browser window was behind other windows or was minimized, it becomes the active window.

By default, in certain operating systems (e.g., pre-Windows XP), whenever you get a response from the system, the browser window grabs the focus. You can disable this behavior by clearing this check box.

Enable keyboard shortcuts

When selected, keyboard shortcuts for switching tabs, editing actions, showing column information, and searching for items are enabled.

Show "Run Macro" in the "File" menu

In earlier versions of 1010data, queries could be saved as macros and run in this way. This option is provided for legacy reasons.

Display progress bar

When selected, a dialog containing a progress bar will appear while a query is processing. The progress bar shows the percentage of total operations completed within the current query.

Show advanced query error information

When selected, more detailed information related to query errors is presented.

Show column headings as

The column heading, name, or a combination of both can be displayed at the top of each column in a table.

the label: The column heading will be displayed at the top of each column (e.g., Unemployment Rate).
the name: The column name will be displayed at the top of each column (e.g., unemp_rate).
both the name and label: Both the column heading and the column name will be displayed at the top of each column.

Handling of repeated values within a column

This determines how repeated values will be displayed within a particular column in a table.

the value: If a particular cell has the same value as the cell in the row above it, the same value will be displayed in that cell. This is the default setting.
a ditto mark (all columns): If a particular cell has the same value as the cell in the row above it, a ditto mark (") will be displayed in that cell.
a ditto mark (fixed columns only): Within a fixed column, if a particular cell has the same value as the cell in the row above it, a ditto mark (") will be displayed in that cell. Otherwise, if it is not a fixed column, the same value will be displayed.
a blank (all columns): If a particular cell has the same value as the cell in the row above it, the cell will appear blank.
a blank (fixed columns only): Within a fixed column, if a particular cell has the same value as the cell in the row above it, the cell will appear blank. Otherwise, if it is not a fixed column, the same value will be displayed.

In selection boxes, show columns in

This determines how column headings will appear within the drop-down lists in row selection dialogs.

the order that they appear in the table: Column headings will appear within the drop-down lists in the same order that they appear in the table.
alphabetical order: Column headings will appear in the drop-down lists in alphabetical order and will include column names for any linked tables.
alphabetical order but with columns from linked tables last: Column headings will appear in the drop-down lists in alphabetical order; however, column headings for any linked tables will appear separately (in alphabetical order) at the bottom of the list.

Use combo boxes instead of select boxes

When selected, combo boxes will be used instead of select boxes for the drop-down lists in all dialogs.

Number of decimal places

Specifies the number of decimal places to display for numbers in the 1010data grid.

Number of Summarizations for Quick Summary

The number of summarizations available The default is 10.

Number of Grouping Columns for Tabulation

The number of grouping columns available for a tabulation. The default is 3.

Number of Summarizations for Tabulation

The number of summarizations available in a tabulation. The default is 10.

Number of Row Dimensions for Cross Tabulation

The number of rows of results available in cross tabulation. The default is 3.

Number of Column Dimensions for Cross Tabulation

The number of columns of results available in a cross tabulation. The default is 3.

Number of Columns for Links

The number of available columns to match when linking tables or worksheets using the link dialogs. The default is 3.

Default folder path to save a quick query or new table

The path to the folder where quick queries and new tables are saved by default. If no path is specified, the user's My Data folder is the default location.

Macro Language

Enable syntax highlighting

When selected, Macro Language elements, attributes, and values are color coded within the Macro Language Workshop.

Wrap text on Edit Actions page

When selected, text that is too long to fit on one line in Macro Language Workshop is wrapped to the next line.

Note: This option is only available when Enable syntax highlighting is selected.

Automatically indent on Edit Actions page

When selected, the line following an opening tag for a particular Macro Language element is indented by the number of spaces specified by Indent spaces for nested elements.

If this option is not selected, the line following the opening <tabu> tag is not indented.

Enable autocomplete

When selected, a drop-down menu of context-related options is presented as you type in Macro Language element names, attributes, and values for certain attributes (such as functions) in Macro Language Workshop.

For instance, if you type < in Macro Language Workshop, a list of context-dependent element names will be presented.

If you type fun=" when you are specifying a tabulation column (<tcol>) element, a list of summarization functions will appear in the drop-down list.

Note: This option is only available when Enable syntax highlighting is selected.

Indent spaces for nested elements

The number of spaces to indent nested Macro Language elements. The default is 2.

Put each attribute on a separate line

When selected, each attribute for a particular Macro Language element will appear on its own line.

The default is for all attributes to appear on the same line.

Break up long selection and value expressions

When selected, this breaks up lengthy value expressions in <sel> statements over multiple lines, with each selection criterion on a separate line, prefaced by an &.

In a <link>, show the linked table ID instead of its name

Select whether a table ID or a table name (path) will be displayed as the value of the table2 attribute for a <link> element in the Macro Language.

name: In Macro Language Workshop, the value of the table2 attribute for a <link> element is displayed as the table's name.
ID: In Macro Language Workshop, the value of the table2 attribute for a <link> element is displayed as the table's ID.

Automatically add comments for the following

When selected, a <note> element containing a comment is automatically added for the table that the macro is being applied to and the table that is being linked to.

Downloads

Excel Downloads

Choose whether tables downloaded in Excel format should be decorated with colorful borders, fills, and fonts (and include tabulation totals), or if they should appear as plain data.

Decorated with totals: Tables will be decorated with colorful borders, fills, and fonts. Also, totals will appear at the top of tabulation columns.
Plain: Tables will not be decorated with any special formatting, and totals will not appear at the top of tabulation columns.

End-of-record delimiter

Select whether a line feed, or carriage return and line feed, are used to signify the end of a record.

LF: A line feed will be used as the end-of-record delimiter.
CRLF: A carriage return and line feed will be used as the end-of-record delimiter.

Include an end-of-record delimiter after the last record

Select whether an end-of-record delimiter should be included after the last record.

Advanced

Display NA for error or "infinity" values

Some computations (e.g., dividing by zero) can result in errors or "infinity" values (0I, -0I, 0i, or -0i). Selecting this option can help reduce or eliminate this behavior.

Specifically:

Division by zero (X/0) returns 0i or -0i if the numerator is not zero.
Checking this box causes N/A to be returned instead of 0i and -0i.
Exponentiation (X^Y) can generate error messages if X is negative.
Checking this box mostly eliminates such messages and causes N/A to be returned in the event of an error.
The range functions (range1, range1f, etc.) return 0I, -0I, 0i, or -0i for column values that lie outside the specified ranges.
Checking this box causes N/A to be returned instead.

Do step-wise aggregation

Select this option to help alleviate virtual memory problems when working with large tables. Using this feature saves memory but is slower.

Blocking Level

Select lower numbers to help alleviate virtual memory problems when doing row selections and tabulations on large tables. Lower numbers save memory but may cause queries to run slower.