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

Материал из SmartPlayer
← Предыдущая правка
Обновление для соответствия новой версии исходной страницы.
Нет описания правки
 
Строка 1: Строка 1:
<languages/>
<languages/>
<div class="mw-translate-fuzzy">
== '''Situation Description''' ==
== '''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.
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''' ==
== '''Action Algorithm''' ==
The first step for the user is to log in to the SmartPlayer personal account.<br>
The first step for the user is to log into their SmartPlayer account.<br>
Next, the user needs to navigate to the "Schedule" section.
Next, the user needs to navigate to the "Schedule" section.
[[File:Раздел_расписание.png|thumb|center| Example of "Schedule" section in personal account|800px]]
[[File:Раздел_расписание.png|thumb|center| Example of the "Schedule" section in the personal account|800px]]
Then the user should select a new device and apply a broadcast.
After that, the user must select a new device and apply the broadcast.
[[File:Выбранное_устройство.png|thumb|center| Example of device selection|800px]]
[[File:Выбранное_устройство.png|thumb|center| Example of selecting a device|800px]]
[[File:Выбор_трансляции.png|thumb|center| Example of broadcast selection|800px]]
[[File:Выбор_трансляции.png|thumb|center| Example of selecting a broadcast|800px]]
During this process, a right-side toolbar will appear where the user needs to click "Show Schedule".
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 "Show Schedule" button in toolbar|800px]]
[[File:Показать_расписание.png|thumb|center| Example of the "Show Schedule" button in the toolbar|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".
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 date selection in calendar and schedule addition icon|800px]]
[[File:Добавить_расписание трансляции.png|thumb|center| Example of selecting a date in the calendar and the icon for adding a schedule|800px]]
The system will automatically open a new window where the user must configure schedule parameters.
The system will automatically open a new window where the user must configure the schedule parameters.
[[File:Параметры_расписания.png|thumb|center| Example of schedule parameters|800px]]
[[File:Параметры_расписания.png|thumb|center| Example of schedule parameters|800px]]
After these steps, click "Select from file" to upload an ".xlsx" file with information.
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 "Select from file" setting|800px]]
[[File:Выбрать_из_файла.png|thumb|center| Example of the "Select from file" option|800px]]
After uploading, click "Details" in the top right corner.
Once the file is uploaded, the user should click the "More" button in the upper right corner.
[[File:Кнопка_подробнее.png|thumb|center| Example of "Details" button|800px]]
[[File:Кнопка_подробнее.png|thumb|center| Example of the "More" button|800px]]
This provides access to the ".xlsx" file's item list, showing which devices fall into available categories:
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." 
* Selected
[[File:Добавленные_значения.png|thumb|center| Example of the "Selected" and "Not Selected" lists from the ".xlsx" file|800px]]
* Not selected
{{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}} 
[[File:Добавленные_значения.png|thumb|center| Example of "Selected" and "Not selected" lists in ".xlsx" file|800px]]
== '''Video Tutorial''' ==
{{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}}
[https://vk.com/video-227547238_456239054 Uploading Information from an ".XLSX" File as a List]
== '''File Example''' ==
== '''Additional Information''' ==
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].
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.
The file contains two key parameters:
[[File:Обсуждение_загрузки_информации.png|thumb|center| Example of the "Discussions" tab on the wiki page |800px]]
# Key field - must contain "digitalSignage"
Additional information can also be found on the page [[Как взаимодействовать пользователю с разделом "Обсуждения"]]
# Device names - must match naming conventions in SmartPlayer personal account
</div>
[[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