[Tagging] Download Course Tag Spreadsheet

[bradenmacdonald]

"As a power user in Studio, I wish to download a spreadsheet for the whole course, showing all the components in the course and which tags each one has"

Acceptance Criteria

1. From Studio, any user with permission to edit the course can use the new "Export Tags" menu to download a CSV that contains:
   a. Every Section/Subsection/Unit/Component of the course as its own row
   b. Every taxonomy used in the course as a column, with its Export ID as the column header.
   c. A list of what tags each item has
2. The CSV should use indentation to reflect the course outline structure (see screenshot below)

CSV Format

Name	Type	ID	Taxonomy1	Taxonomy2
Section 0: Course Introduction	Section	block-v1:...	tag1
Section 0: Course Introduction	Subsection	block-v1:...	tag3
Lesson 0.1: Course Organization	Unit	block-v1:Axim+WGU_Sample1+Test_1+type@vertical+block@51f3...	tag4,tag5,tag6
Course Introduction	Video	block-v1:Axim+WGU_Sample1+Test_1+type@wgu_image_dams+block@55c1...	tag5,tag6
Course Organization	Text	block-v1:Axim+WGU_Sample1+Test_1+type@html+block@6bad...	tag5	easy

How the above .csv would look in Excel (note the indentation):

Notes

• A follow-up task should implement this for libraries too
• We'll probably want to use the same CSV/spreadsheet format in the future for bulk editing of tags - download this spreadsheet, enter tag values into the rows/columns as needed, then upload it back into the course to have your tag changes applied. So keep that in mind.

[jmakowski1123]

This looks like it's on the right track to me!

I see this as a stepping stone to the next epic, which would be a bulk tag import. "As a course author, I want to use this excel sheet to add tags to content and import those tags in bulk via an import workflow." Out of scope for this ticket, but just want to make sure we're aligned on future steps, yes?

[bradenmacdonald]

I see this as a stepping stone to the next epic, which would be a bulk tag import.

@jmakowski1123 Yes, absolutely. I did put a note about that at the end of the description ^

[Colin-Fredericks]

Seeing tabs inside a spreadsheet cell felt weird at first, but I think it's the right way to go, especially since there's no actual bottom level to edX hierarchy. We can't just do it as a set of columns. Good call.

[bradenmacdonald]

@Colin-Fredericks Yeah, that column is not really used for anything other than helping the user understand which content items are which, so I thought we might as well make it "pretty" and "helpful". I tried a format with columns at first, but it didn't really work. And this way the format can be used identically for library exports too, which have no hierarchy.

[pomegranited]

@bradenmacdonald CC @rpenido There's already a "course blocks" API endpoint that returns all the blocks in a course, see lms.djangoapps.course_blocks.api, though note:

1. It requires a user to be passed in, because of conditional content display rules for user cohorts.
2. It doesn't sort the blocks according to the course outline, it returns them in a non-deterministic order.
   When we needed this functionality for Insights, we ended up sorting the blocks in the analytics pipeline, because it was too difficult to put it into the transformer loop used by the API. But that functionality should live in the course blocks API IMHO.

[bradenmacdonald]

@pomegranited For this we really need a Studio course outline API, not an LMS one. I think learning_sequences.api.get_course_outline comes close ("There is no user-specific data or permissions applied in this function.") but it doesn't include units and components. I am not sure what other APIs may be available.

If nothing else, we can always do it asynchronously the "slow" way by recursing the tree.

[pomegranited]

@bradenmacdonald Ahh yes, I'm sorry, I keep forgetting we have to deal with draft content for Tagging.
Sorry for the noise!

[pomegranited]

@bradenmacdonald @jmakowski1123 -- @rpenido has a good question about this requirement:

a. Every Section/Subsection/Unit/Component of the course as its own row

Should the actual top-level course block be exported too, so that we can tag courses? It's trivial to add here.