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
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.