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.

Note: Many of these settings can also be changed using the Set Preferences dialog in the 1010data user interface. See Preferences for more information.

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.
Enable the User Manager in the Admin App
When enabled, users that are not administrators will see the User Manager tab from the Account Administration page. The information for that user will be pre-populated on the User Manager page. The User Manager tab replaces the User Info and Change Password tabs.
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.
Note: In this example the State column is fixed, but Unemployment Rate is not.
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.
Note: In this example the State column is fixed, but Unemployment Rate is not.
In selection boxes, show columns in
This determines how column headings will appear within the drop-down lists in row selection dialogs (e.g., Select Rows, Find Row).
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 in the Quick Summary dialog. The default is 10.
Number of Grouping Columns for Tabulation
The number of grouping columns available in the Tabulation dialog. The default is 3.
Number of Summarizations for Tabulation
The number of summarizations available in the Tabulation dialog. The default is 10.
Number of Row Dimensions for Cross Tabulation
The number of rows of results available in the Cross Tabulation dialog. The default is 3.
Number of Column Dimensions for Cross Tabulation
The number of columns of results available in the Cross Tabulation dialog. 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 (e.g., Link in Another Table, Link in Another Worksheet, Link and Select Rows). 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 Edit Actions (XML) dialog.

Wrap text on Edit Actions page
When selected, text that is too long to fit on one line in the Edit Actions (XML) dialog is wrapped to the next line.

In the following example, the <note> element on line 2 wraps to the next line.

If this option was not selected, the <note> element would appear only on one line (and a horizontal scroll bar would appear at the bottom of the Edit Actions (XML) dialog).

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.

For instance, the following screen shot shows the automatic indention of the line following the opening <tabu> tag:

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 the Edit Actions (XML) dialog.

For instance, if you type < in the Edit Actions (XML) dialog, 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.

In the following example, the <tcol> elements nested within the <tabu> element are indented two spaces.

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 the Edit Actions (XML) dialog, the value of the table2 attribute for a <link> element is displayed as the table's name.

ID
In the Edit Actions (XML) dialog, 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.
In the following example:
  • The <note> on line 1 contains the comment that was automatically added about the table the macro was applied to (training.retail.item).
  • The <note> on line 2 contains the comment that was automatically added about the table that was linked to (training.retail.prod) in the <link> statement on line 3.

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.
Enable Query Scheduler
When enabled, the Query Scheduler tab shows up in the Account Administration toolbar. The Query Scheduler allows you to run scheduled reports.

Certain other settings are needed for users to be able to run scheduled reports (e.g., API access, FTP folder setup), so before turning this on, a company administrator should email support@1010data.com and request access for the target user.

See Query Scheduler for more information.

Note: This setting is available to all company administrators.
Enable Powerloader UQ via Advanced upload button
When enabled, the Advanced button will be displayed when the user clicks the Upload icon in the Folders and Tables toolbar. The Advanced button provides access to the Advanced Upload feature.

The Advanced Upload feature provides many options for fine-grained control over the data you are uploading. In addition, the Advanced Upload feature is recommended when uploading a file in the user interface that is larger than 20 MB in size.

Note: This setting is available to all company administrators.