userfileExecute (Command)

Prev Next

The userfileExecute command performs user import file–related administrative operations. User import files are comma-separated text file (.csv) that are used to import user accounts in bulk to the database.

  Table: userfileExecute commands
CommandDescription
USERFILECMD_IMPORT_FILE

Processes user import data previously uploaded from a user import file (see  USERFILECMD_IMPORT_FILE).

The user import file must be uploaded first using one of the supported upload commands:

  • userfileuploaddime
  • userfileuploadmime
  • userfileuploadmtom
USERFILECMD_QUERY_STATUSReturns the status of a server task that has been previously started via the USERFILECMD_IMPORT_FILE operation(see  USERFILECMD_QUERY_STATUS).
USERFILECMD_STOP_IMPORTStops a server task that has been previously started via the USERFILECMD_IMPORT_FILE operation (see  USERFILECMD_STOP_IMPORT).

The following field attributes are available for the operations of this command:

  Table: userfileExecute field attributes
Attribute nameData typeDescription
USERFILEFLD_ASSIGN_DPBoolean

Determines whether to assign authenticators after a user account has been created.

Default value: false

USERFILEFLD_CACHE_IDString

The unique identifier of the uploaded user import file generated by the respective upload operations.

Up to 255 characters.

USERFILEFLD_CREATE_NEW_ACCOUNTBoolean

Determines whether to create new user accounts when they are imported.

Default value: true

USERFILEFLD_ENABLE_NEW_ACCOUNTBoolean

Determines whether to enable new user accounts when they are created.

Default value: true

USERFILEFLD_ERROR_LISTattributesErrors returned
USERFILEFLD_GRACE_PERIOD_DAYSInteger

The grace period in days for the user accounts created from the user import file.

Default value: 7

USERFILEFLD_NOTIFYString

The notification delivery method to notify the user on completion of the task. The required contact information must be defined in the respective user account.

  • Email
  • SMS
USERFILEFLD_RETURN_ERRORBoolean

Indicates whether to return errors or not.

Default value: false

USERFILEFLD_SCHEDULE_DATEString

The scheduled date if scheduled with USERFILEFLD_SCHEDULED.

Format: DD/MM/YYYY

Example: 20/07/2013

USERFILEFLD_SCHEDULE_TIMEString

The scheduled time of the day to execute the task if scheduled with USERFILEFLD_SCHEDULED.

Format: hh:mm

Use 24-hour time. For example: 21:00

USERFILEFLD_SCHEDULEDBoolean

Determines whether the respective task is scheduled.

Default value: false

USERFILEFLD_SHOW_ASSIGN_DPBooleanShow assign authenticator options after the file has been uploaded. Used by Web Administration Service.
USERFILEFLD_SHOW_PASSWORD_OPTIONBoolean

Used by Web Administration Service.

USERFILEFLD_TASK_DESCRIPTIONString 
USERFILEFLD_UPDATE_ACCOUNTBoolean

Determines whether existing user account should be updated with the import data.

Default value: false

USERFILEFLD_UPDATE_STATIC_PASSWORDBoolean

Determines whether to update the static password if the user account already exists.

Default value: false

USERFILEFLD_USER_FILE_NAMEString

The name of the uploaded user file.

Up to 255 characters.

USERFILEFLD_USERS_FAILEDIntegerThe total number of user import failures.
USERFILEFLD_USERS_IMPORTEDIntegerThe total number of user already imported.
USERFILEFLD_USERS_READIntegerThe total number of users already read and processed.
USERFILEFLD_USERS_TOTALIntegerThe total numbers of users found in the user import file.

USERFILECMD_IMPORT_FILE

Processes user import data previously uploaded from a user import file referred by the USERFILEFLD_CACHE_ID attribute.

The following attributes can be specified in the attributeSet input parameter of this command:

  Table: USERFILECMD_IMPORT_FILE (Supported input attributes)
Attribute nameOptionality
USERFILEFLD_ASSIGN_DPOptional
USERFILEFLD_CACHE_IDMandatory
USERFILEFLD_CREATE_NEW_ACCOUNTOptional
USERFILEFLD_ENABLE_NEW_ACCOUNTOptional
USERFILEFLD_GRACE_PERIOD_DAYSOptional
USERFILEFLD_NOTIFYOptional
USERFILEFLD_SCHEDULEOptional
USERFILEFLD_SCHEDULE_DATEOptional
USERFILEFLD_SCHEDULE_TIMEOptional
USERFILEFLD_UPDATE_ACCOUNTOptional
USERFILEFLD_UPDATE_STATIC_PASSWORDOptional

This command returns no result attributes.

USERFILECMD_QUERY_STATUS

Returns the status of a server task that has been previously started via the USERFILECMD_IMPORT_FILE operation.

The following attributes can be specified in the attributeSet input parameter of this command:

  Table: USERFILECMD_QUERY_STATUS (Supported input attributes)
Attribute nameOptionality
USERFILEFLD_CACHE_IDMandatory
USERFILEFLD_RETURN_ERROROptional

The following attributes will be specified in the results output parameter of this command:

  Table: USERFILECMD_QUERY_STATUS (Supported output attributes)
Attribute nameReturned?
USERFILEFLD_USERS_FAILEDAlways
USERFILEFLD_USERS_IMPORTEDAlways
USERFILEFLD_USERS_READAlways

USERFILECMD_STOP_IMPORT

Stops a server task that has been previously started via the USERFILECMD_IMPORT_FILE operation

Only the USERFILEFLD_CACHE_ID attribute can be specified in the attributeSet input parameter of this command.

This command returns no result attributes.