Portal provides a beta version of import CSV data, this is implemented as an asynchronous process available when enabled as early adopter as an option in portal.

The process will offer two possibilities, first one synchronous, where a first feedback of data quality will be provided in the UI, this process will still manage the import asynchronously (taking potentially few minutes until data is loaded) and the file size to load is very limited.
A second option is to load it asynchronously, in that case the file will not be examined and will be sent automatically to be processed in the backend.

System will detect and validate the entities to be loaded based on the list of fields present in the CSV.
Whenever the selection fields for any type of entity are present in the file, the system will asses if any changes would happen in the existing data for the entity with the columns available, and if there are, records would be updated or created accordingly

Entities

User

username,active,password,email,name,language,role
user1,true,Password1!,test@email.com,User Name,en-US,BATTERY
user2,true,Password1!,test2@email.com,User Name 2,en-US,ADMIN|BATTERY

Selection

  • username

Available

  • Password
    • Mandatory to create users

    • Requires to be 8 characters long, with at least one upper case, one lower case and a special character

  • email

  • name

  • active

    • true/false (defaults to true if not present)

  • role

    • Provided as a pipe delimited list of possible roles

      • ADMIN

      • GROUP_CREATOR

      • CONTENT_CREATOR

      • BATTERY

      • OFFLINE_UPLOADER

      • ONLINE_UPLOADER

      • DASHBOARD_VIEWER

  • features

  • language

    • From list of available locales

      • en-US

  • hierarchyId

    • Hierarchy used in the system to categorise users

  • organizationId

    • Organization unit inside the hierarchy where the user belongs

Group

groupName,groupDescription
Group A,Group A description
Group B,Group B description

Selection

groupName

Available

  • groupDescription
  • active

    • true/false (defaults to true if not present)

  • hierarchyId

    • Hierarchy used in the system to categorise users

  • organizationId

    • Organization unit inside the hierarchy where the user belongs

User In Group

groupName,username,groupRole
Group A,user1,TEST_TAKER
Group A,user2,GRADER
Group B,user2,TEST_TAKER

Selection

  • groupName
  • username

Available

  • groupRole
    • Provided one of available roles

      • GROUP_MANAGER

      • TEST_TAKER

      • GRADER

  • hierarchyId

    • Hierarchy used in the system to categorise users

  • organizationId

    • Organization unit inside the hierarchy where the user belongs

Session

sessionName,deliveryId,groupName,startDate,endDate,timezone,testRunnerSecurityPlugins,readAloud,testRunnerSessionPlugins,testRunnerAccessibilityPlugins,reportSettings
Session 1,cfdd25d3bc6a,Group A,2023-01-01T12:00:00Z,2023-12-31T12:00:00Z,Europe/Warsaw,content-based,"print","contrast,contrastToolOptions,customPointer,customPointerOptions,font,fontToolOptions,zoom","studentReport"
Session 3,cfdd25d3bc6a,Group B,2023-01-01T12:00:00Z,2023-12-31T12:00:00Z,Europe/Warsaw,"requireFullscreen,preventRightClickAndKeyboardShortcuts,preventScreenshot",content-based,"print","contrast,contrastToolOptions,customPointer,customPointerOptions,font,fontToolOptions,zoom","studentReport"

Selection

  • sessionName
  • groupName

  • deliveryId / batteryName / batteryId

Available

  • startDate
    • 2023-12-01T11:00:00.000Z

  • endDate

    • 2023-12-01T11:00:00.000Z

  • submissionDate

    • 2023-12-01T11:00:00.000Z

  • timezone

    • From list of available timezones (default from the tenant configuration or UTC)

      • Europe/Berlin

  • active

    • true/false (defaults to true if not present)

  • testRunnerSessionPlugins

    • Provided as a comma-delimited list of possible settings

      • print (by default it is enabled, so provide that option to disable it )

  • testRunnerSecurityPlugins

    • Provided as a comma-delimited list of possible settings

      • requireFullscreen

      • preventRightClickAndKeyboardShortcuts

      • pauseTestWhenExistFullScreen

      • preventScreenshot

      • requireAuthorizationToStart

  • testRunnerReviewSettings

    • Provided as a comma-delimited list of possible settings

      • enabled

      • showCorrect

      • showScore

  • testRunnerAccessibilityPlugins

    • Provided as a comma-delimited list of possible settings (equivalent to check checkbox in UI)

      • contrast

      • contrastToolOptions

      • customPointer

      • customPointerOptions

      • font

      • fontToolOptions

      • zoom

  • readAloud

    • Possible values should be only one in list: content-based, always-enabled, always-disabled,

  • reportSettings

    • Provided as a comma-delimited list of possible settings

      • studentReport

Battery

Selection

  • batteryName

Available

  • batteryDescription
  • batteryDeliveriesId

    • Provided as a pipe delimited list of possible deliveries

      • Delivery1|Delivery2

  • batteryDeliveriesPassword

    • Provided as a pipe delimited list of passwords for each delivery from batteryDeliveriesId

      • Password1|password2

  • batteryDeliveriesOrder

    • Provided as a pipe delimited list of orders for each delivery from batteryDeliveriesId

      • 1|2