Auxiliary Tool : Content Curator Tool

[chrlschwb]

Background

The Content WG is currently using l1.media app as a means of curating new videos on Joystream. A dedicated tool for the content curators would help them with their daily tasks and also make it easier for lead to generate reports.

Specifications

This tool will consist of two pages: an administrator panel for the Content WG lead, and a video verification panel for Content WG workers.

Database Structure

• There should be a database table with information of Content WG lead and workers. (member id, handle, lead/worker, email address, encrypted password)
• There should be a table with information of all channels and videos. (video id, video title, channel id, owner handle, uploaded date/time, assigned curator, NFT tag, YPP tag, entity plays, allowed, duplicate, category, comment)

Administrator panel

• Only Content WG lead can access
• Lead can assign a specific set of videos, channels or meta data to any current curator for verification using the following filters: a specific video ID, the presence of a YPP tag, a specific day, a specific channel.
• The lead can check whether a video has been verified or not
• Lead can download data in JSON or CSV format for a specified period.

Video verification panel

• Only Content WG lead/worker can access
• The curator can see a list of assigned videos, channels and metadata in a list and has the ability to view them.
• For each, the curator determines the tags: entity plays (Yes, no), allowed (Yes, No-Cruelty, No-porn, no-illegal, no-other), Duplicate (No, Yes) {only for videos and channels}, comment to the Duplicate, Date of verification (entered automatically), actual curator (entered automatically), Video category (C, B, A, without category), general comment.

[igrexac]

I believe the second and third tables can be merged. In this case, it’s easy to separate the tags “assigned curator” and “verifying curator”

For the Video verification panel, provide the ability to view videos, metadata and channels by the curator. The curator can also tag verified videos using the listed labels (tags)

[igrexac]

I believe the second and third tables can be merged. In this case, it’s easy to separate the tags “assigned curator” and “verifying curator”

For the Video verification panel, provide the ability to view videos, metadata and channels by the curator. The curator can also tag verified videos using the listed labels (tags)

Delete: Also, the administrator can upload json and csv instead of downloading them.

[ivanturlakov]

Tested on http://91.194.11.210:5000/video-list

Videos List

⚠️ Lead can assign a specific set of videos, channels or meta data to any current curator for verification using the following filters: a specific video ID, the presence of a YPP tag, a specific day, a specific channel.

• no possibility to filter videos by ID
• no possibility to filter by channel(ID or Name)
• It would be nice to add option to filter by assignee

⚠️ The lead can check whether a video has been verified or not

• can only be seen if the video on page 1
• how to check if there is no possibility to filter by ID, channel name or assignee?

✅ Lead can download data in JSON or CSV format for a specified period

Curator Panel

✅ The curator can see a list of assigned videos, channels and metadata in a list and has the ability to view them.

• Curator only sees the full list, need filters to make it easy to work with

⚠️ For each, the curator determines the tags: entity plays (Yes, no), allowed (Yes, No-Cruelty, No-porn, no-illegal, no-other), Duplicate (No, Yes) {only for videos and channels}, comment to the Duplicate, Date of verification (entered automatically), actual curator (entered automatically), Video category (C, B, A, without category), general comment.

• comment to the Duplicate - looks like missed

PS I'll have some more UI recommendations a little later