Загрузка информации из XLSX списком/en: различия между версиями

Материал из SmartPlayer
← Предыдущая правка
Новая страница: «== '''Situation Description''' == As the SmartPlayer platform evolves, the development team continues to add new features. Now, when setting up a schedule, users have the ability to add information about objects from an ".xlsx" file as a list. == '''Action Algorithm''' == The first step for the user is to log into their SmartPlayer account.<br> Next, the user needs to navigate to the "Schedule" section. File:Раздел_расписание.png|...»
Нет описания правки
 
(не показана 1 промежуточная версия 1 участника)
Строка 1: Строка 1:
== '''Situation Description''' ==
<languages/>
As the SmartPlayer platform evolves, the development team continues to add new features. Now, when setting up a schedule, users have the ability to add information about objects from an ".xlsx" file as a list.
== '''Situation Description''' ==
== '''Action Algorithm''' ==
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.
The first step for the user is to log into their SmartPlayer account.<br>
== '''Action Algorithm''' ==
Next, the user needs to navigate to the "Schedule" section.
The first step for the user is to log in to the SmartPlayer personal account.<br>
[[File:Раздел_расписание.png|thumb|center| Example of the "Schedule" section in the personal account|800px]]
Next, the user needs to navigate to the "Schedule" section.
After that, the user must select a new device and apply the broadcast.
[[File:Раздел_расписание.png|thumb|center| Example of "Schedule" section in personal account|800px]]
[[File:Выбранное_устройство.png|thumb|center| Example of selecting a device|800px]]
Then the user should select a new device and apply a broadcast.
[[File:Выбор_трансляции.png|thumb|center| Example of selecting a broadcast|800px]]
[[File:Выбранное_устройство.png|thumb|center| Example of device selection|800px]]
During the process, a toolbar will appear on the right, where the user needs to click the "Show Schedule" button.
[[File:Выбор_трансляции.png|thumb|center| Example of broadcast selection|800px]]
[[File:Показать_расписание.png|thumb|center| Example of the "Show Schedule" button in the toolbar|800px]]
During this process, a right-side toolbar will appear where the user needs to click "Show Schedule".
A new page with a calendar will open on the screen. The user needs to select a date from which the schedule countdown will start and click the "+" icon on the right toolbar, labeled "Add Schedule." 
[[File:Показать_расписание.png|thumb|center| Example of "Show Schedule" button in toolbar|800px]]
[[File:Добавить_расписание трансляции.png|thumb|center| Example of selecting a date in the calendar and the icon for adding a schedule|800px]]
A new calendar page will open. Select the start date for the schedule and click the "+" icon in the right toolbar labeled "Add Schedule".
The system will automatically open a new window where the user must configure the schedule parameters.
[[File:Добавить_расписание трансляции.png|thumb|center| Example of date selection in calendar and schedule addition icon|800px]]
[[File:Параметры_расписания.png|thumb|center| Example of schedule parameters|800px]]
The system will automatically open a new window where the user must configure schedule parameters.
After completing the previous steps, the user needs to click on the "Select from file" option. This allows them to upload an ".xlsx" file containing the necessary information.
[[File:Параметры_расписания.png|thumb|center| Example of schedule parameters|800px]]
[[File:Выбрать_из_файла.png|thumb|center| Example of the "Select from file" option|800px]]
After these steps, click "Select from file" to upload an ".xlsx" file with information.
Once the file is uploaded, the user should click the "More" button in the upper right corner.
[[File:Выбрать_из_файла.png|thumb|center| Example of "Select from file" setting|800px]]
[[File:Кнопка_подробнее.png|thumb|center| Example of the "More" button|800px]]
After uploading, click "Details" in the top right corner.
This grants access to the list of positions from the ".xlsx" file, allowing the user to review which devices are listed under "Selected" and which remain in "Not Selected." 
[[File:Кнопка_подробнее.png|thumb|center| Example of "Details" button|800px]]
[[File:Добавленные_значения.png|thumb|center| Example of the "Selected" and "Not Selected" lists from the ".xlsx" file|800px]]
This provides access to the ".xlsx" file's item list, showing which devices fall into available categories:
{{Note|Transferring devices from the "Not Selected" list to the "Selected" list is automatic. This transfer is based on a data comparison with the server. Since the uploaded list is also stored on the server, the system can compare the data and select the appropriate devices.|warn}} 
* Selected
== '''Video Tutorial''' ==
* Not selected
[https://vk.com/video-227547238_456239054 Uploading Information from an ".XLSX" File as a List]
[[File:Добавленные_значения.png|thumb|center| Example of "Selected" and "Not selected" lists in ".xlsx" file|800px]]
== '''Additional Information''' ==
{{Note|Device transfer from "Not selected" to "Selected" happens automatically via server data comparison. The uploaded list exists on the server enabling this matching process.|warn}}
If this article does not help you utilize the feature properly or if you still have questions after reading it, you can ask them in the "Discussions" section at the top of the page.
== '''File Example''' ==
[[File:Обсуждение_загрузки_информации.png|thumb|center| Example of the "Discussions" tab on the wiki page |800px]]
Users can download and review a properly formatted sample file here: [https://docs.google.com/spreadsheets/d/1fm-lCWFOI11dW-607i7etYAWGlbTS4ig/edit?usp=drive_link&ouid=112553925670345352283&rtpof=true&sd=true link].
Additional information can also be found on the page [[Как взаимодействовать пользователю с разделом "Обсуждения"]]
The file contains two key parameters:
# Key field - must contain "digitalSignage"
# Device names - must match naming conventions in SmartPlayer personal account
[[File:Основные_поля.png|thumb|center| Example of required fields|800px]]
{{Note|Users must manually configure their files following this example.|warn}}
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
[[File:Устрйоства.png|thumb|center| Example of "Devices" section in personal account|800px]]
Select the folder with target devices
[[File:Выбранная_группа_устройств.png|thumb|center| Example of selected device folder|800px]]
After checkbox selection, find "Export Devices" in the right toolbar
[[File:Выгрузить_устройство.png|thumb|center| Example of "Export Devices" button|800px]]
Download and reconfigure the file following the sample format
[[File:Устройства из лк.png|thumb|center| Example of exported device file|800px]]
== '''Video Tutorial''' ==
[https://vk.com/video-227547238_456239054 Bulk upload from ".XLSX" files]
== '''Additional Information''' ==
For unresolved issues, please use the "Discussions" section at the page top.
[[File:Обсуждение_загрузки_информации.png|thumb|center| Example of "Discussions" tab on wiki-page|800px]]
More details at [[Как взаимодействовать пользователю с разделом "Обсуждения"]]

Текущая версия от 12:16, 13 мая 2025

Другие языки:

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 Как взаимодействовать пользователю с разделом "Обсуждения"

Источник — https://wiki.smartplayer.org/index.php?title=Загрузка_информации_из_XLSX_списком/en&oldid=16501