Page Comparison

This page details the functionality of using a CSV file to manage collection. This is a common functionality that has to be enabled for any collection category. It is part of generalized collection editor.

...

1. Option to select a Folders CSV from user’s system (of user’s system)

2. There is a link to sample file: “Sample CSV”

3. User selects folders file, user clicks “Upload”. System provides a message “Validating file”“Upload is in progress” (note: this is a synchronous process)

4. The system should first validate file. Following are the validations:

   1. All the columns are present: All columns as in the template should be present

   2. All the mandatory columns have values filled in: “Level 1 Folder” is mandatory. If any Level columns are filled in, all the previous level columns are mandatory.

   3. There are no duplicate folders: The sequence of all level folder names should be unique. For example,

      1. Following are duplicate rows:

         1. Row 1 - Level 1: Chapter 1, Level 2: Explanation Content, Level 3: Explanation Videos

         2. Row 2 - Level 1: Chapter 1, Level 2: Explanation Content, Level 3: Explanation Videos

      2. Following are NOT duplicate rows:

         1. Row 1 - Level 1: Chapter 1, Level 2: Explanation Content, Level 3: Explanation Videos

         2. Row 2 - Level 1: Chapter 2, Level 2: Explanation Content, Level 3: Explanation Videos

5. In case there are errors in the file validation, display relevant error message on the Upload dialog: “The file has following errors. Please check and upload again”

   1. Some columns are not available:
      “Following columns are not found in the file: <list the missing column names>”

   2. Some mandatory columns have values missing:
      “Following rows have missing values: <list the row numbers (starting from 1) with missing values>“

   3. Some duplicate rows found:
      ”Following rows are duplicate: <list the row numbers (starting from 1) that are duplicate>“

   In case file doesn’t have any validation errors, the dialog shows “Upload is in progress” (note: this is a synchronous process)

6. Once the upload is complete, the dialog closes and updated folder hierarchy is shown in the collection editor.

7. In case there is an error in upload process, show an error “Upload failed. Please retry and if you continue to face the error, please contact support”.

Download hierarchy csv

There is an option to download the folders of a collection as a csv (“Download folders as CSV”). This option is present as part of the collection editor. This option is to download the folders a CSV so that use user can update the attributes or link assets to the folders through this CSV, instead of using the editor UI.

Here is the template of the Folders CSV that will be downloaded.

The set of attribute columns in the folders csv are configurable for each primary category.

Update folder metadata and linked assets through a csv

...

1. Option to select a Folders CSV from user’s system (of user’s system)

2. There is a message stating “This should be the same file that you have downloaded using “Download folders as CSV” option”

3. User selects folders CSV file, user clicks “Update”. System provides a message “Validating file”“Update is in progress” (note: this is a synchronous process)

4. The system should first validate file. Following are the validations:

   1. All the columns are present: All columns as in the template should be present

   2. All the mandatory columns have values filled in. Following columns are mandatory:

      1. Collection Name, Folder IdentifiedIdentifier

      2. “Level 1 Folder” is mandatory. If any Level columns are filled in, all the previous level columns are mandatory.

      3. Folder Identifiers column should be unique

   3. In case there are errors in the file validation, display relevant error message on the Upload dialog: “The file has following errors. Please check and upload again”

   4. Some columns are not available:
      “Following columns are not found in the file: <list the missing column names>”

   5. Some mandatory columns have values missing:
      “Following rows have missing values: <list the row numbers (starting from 1) with missing values>“

   6. Some rows have duplicate folder identifiers:
      ”Following rows have duplicate folder identifiers: <list the row numbers (starting from 1) that have duplicate folder identifiers>“

5. In case file doesn’t have any validation errors, the dialog shows “Update is in progress” (note: this is a synchronous process)

6. Once the update is complete,

   1. If the update is successful without errors, show status as “Update Successful” in the update dialog.

   2. In case there are errors in processing any of the rows, show the list of errors in the update dialog. Following are the possible errors that can happen at each row:

      1. Folder Identifier is incorrect - Message “Folder identifier is incorrect”

      2. Mapped topics are not found in the framework topics list - Message “Mapped topics are not found in the Topics master list”

      3. Keywords have a blank value (there are two commas without any keyword in between) - Message “Error in parsing keywords. Please ensure the keywords are separated by commas and there are no empty keywords.”

      4. QR Code is not generated for the collection - Message “QR Code is incorrect. Please ensure this QR code is generated for this collection.”

      5. Linked Content do_id is incorrect - Message “Incorrect content id”

      6. Any other error - Message “System “Update error. Please retry and if you continue to face the error, please report”contact support”.

   3. The errors list should be shown as follows:

      1. <<Row id (starting from 1)>>: <<Error Message>>

7. User has option to close the dialog

...