Bulk edit file format

Company administrators can create multiple users at one time by providing a CSV file containing the information for those users.

User Fields

The following table contains all available user fields along with their descriptions, valid values, and sample inputs.

For more detailed information about each of these fields, see:
Field Name Description Type Sample Input
uid User ID text mycomp_jsmith
first First name text John
last Last name text Smith
mi Middle initial text R
email Email address text jsmith@mycomp.com
emaillist Email list text johnsmith@gmail.com
company Company name text My Company
phone Phone number text 123-456-7890
street Street address text 10 Main Street
city City text New York
state State text NY
country Country text USA
zip Zip code text 10101
profess Profession text Analyst
dormantmin Idle time (minutes) integer 60
inactive Deactivate Valid values are:
  • 0
  • 1
0
expiredate User expiration date integer (YYYYMMDD) 20201231
pwdate Password set date integer (YYYYMMDD) 20010101
pwdatecycle Password expiration cycle integer 45
version Version text prod-9.53
ip Restricted IPs text 127.0.0.1
timeout Client time-out period (seconds) integer 600
maxdown Maximum download (cells) integer 100000
maxrows Maximum download (rows) integer 100000
totdisk Total disk space (GB) integer 5000000
timezone Time zone (GMT offset) integer -5
region_fmt Region format text US
favorites Favorite folders and tables (IDs) space-separated list of integers 174638 374757
err_stack_info Show advanced query error information Valid values are:
  • 0
  • 1
0
focus Focus browser on query completion Valid values are:
  • 0
  • 1
1
shortcut Enable keyboard shortcuts Valid values are:
  • 0
  • 1
1
allow_empty_tables Allow 0 row tables when macro is annotated with empty Valid values are:
  • 0
  • 1
1
grid_labels Grid labels Valid values are:
  • name
  • label
  • both
both
showids Show table IDs instead of paths in Macro Language code Valid values are:
  • 0
  • 1
0
ditto Handling of repeated values within column Valid values are:
  • value
  • mark
  • markfx
  • blank
  • blankfx
blank
sortcols Column order in selections Valid values are:
  • 0
  • 1
  • 2
0
combo Use combo boxes Valid values are:
  • 0
  • 1
0
inf2na Reduce the number of 0i’s Valid values are:
  • 0
  • 1
0
excel_dl Excel downloads Valid values are:
  • new
  • old
old
down_eor End-of-record delimiter in downloads Valid values are:
  • lf
  • crlf
crlf
down_last Include a record delimiter at end of file downloads Valid values are:
  • 0
  • 1
1
tab_condense Do step-wise aggregation Valid values are:
  • 0
  • 1
1
s_res_n Number of summarizations for quick summary integer 20
maxrows_blk Tabulation block size integer 2
t_breaks_n Number of grouping columns for tabulation integer 6
t_res_n Number of summarizations for tabulation integer 20
x_rbreaks_n Number of row dimensions for cross tabulation integer 10
x_cbreaks_n Number of column dimensions for cross tabulation integer 10
l_cols_n Number of columns for links integer 20
syntax_h Enable syntax highlighting in Edit Actions (XML) dialog Valid values are:
  • 0
  • 1
1
oe_wrap Wrap text on Edit Actions (XML) dialog Valid values are:
  • 0
  • 1
1
progressbar Show the progress bar Valid values are:
  • 0
  • 1
1
auto_hint Enable autocomplete in Edit Actions (XML) dialog Valid values are:
  • 0
  • 1
1
nestmacro Number of spaces to indent nested elements in Macro Language code integer 3
splitattr Show each attribute on a separate line in Macro Language code Valid values are:
  • 0
  • 1
0
splitexpr Show each ANDed expression on a separate line in Macro Language code Valid values are:
  • 0
  • 1
0
autocomment Autocomment Macro Language code Valid values are:
  • base
  • link
  • base link
link

Example

The following is an excerpt from a sample CSV file:

uid,first,last,email,dormantmin,expiredate,progressbar
mycomp_jsmith,John,Smith,jsmith@mycomp.com,60,20201231,0
mycomp_manderson,Maggy,Anderson,manderson@mycomp.com,60,,0