Loading Information from XLSX as a List

Situation Description

While developing the SmartPlayer platform, the development team continues to add new features. Now when configuring schedules, users can add object information from ".xlsx" files in bulk.

Action Algorithm

The first step for the user is to log in to the SmartPlayer personal account.
Next, the user needs to navigate to the "Schedule" section.

Example of "Schedule" section in personal account

Then the user should select a new device and apply a broadcast.

Example of device selection

Example of broadcast selection

During this process, a right-side toolbar will appear where the user needs to click "Show Schedule".

Example of "Show Schedule" button in toolbar

A new calendar page will open. Select the start date for the schedule and click the "+" icon in the right toolbar labeled "Add Schedule".

Example of date selection in calendar and schedule addition icon

The system will automatically open a new window where the user must configure schedule parameters.

Example of schedule parameters

After these steps, click "Select from file" to upload an ".xlsx" file with information.

Example of "Select from file" setting

After uploading, click "Details" in the top right corner.

Example of "Details" button

This provides access to the ".xlsx" file's item list, showing which devices fall into available categories:

• Selected
• Not selected

Example of "Selected" and "Not selected" lists in ".xlsx" file

Device transfer from "Not selected" to "Selected" happens automatically via server data comparison. The uploaded list exists on the server enabling this matching process.

File Example

Users can download and review a properly formatted sample file here: link. The file contains two key parameters:

1. Key field - must contain "digitalSignage"
2. Device names - must match naming conventions in SmartPlayer personal account

Example of required fields

Users must manually configure their files following this example.

The sample file helps users create proper server-compatible files. Correctly prepared files are automatically detected by the client's server, which categorizes each ".xlsx" entry as selected/not selected.

Alternative Upload Method

For convenient ".xlsx" file configuration, users can: Navigate to the "Devices" section

Example of "Devices" section in personal account

Select the folder with target devices

Example of selected device folder

After checkbox selection, find "Export Devices" in the right toolbar

Example of "Export Devices" button

Download and reconfigure the file following the sample format

Example of exported device file

Video Tutorial

Bulk upload from ".XLSX" files

Additional Information

For unresolved issues, please use the "Discussions" section at the page top.

Example of "Discussions" tab on wiki-page

More details at Как взаимодействовать пользователю с разделом "Обсуждения"