Managing Courses' Meta Data using Excel file-5 - How to update multiple products with a big Excel file

Video Transcription

Video Summary

In the video, the presenter demonstrates how to import an Excel file to update or append metadata. They upload a larger Excel file with almost 80 rows and show that column B is used as a pivot. They open the metadata for a specific entry, "Behavioral Health in Diabetes Care," to show that it already has data. They explain that they will replace the existing data in the system with the data from the Excel file. The presenter then goes through the steps to import the file, selecting the replace option. They mention that some product metadata will not be imported due to non-existent product codes. After importing, they refresh the page to show that the data now matches the Excel file. They conclude by stating that the Excel file allows for efficient uploading and management of metadata. No credits are mentioned.

Meta Tag

Creation Year 2023

Keywords

import Excel file

update metadata

append metadata

pivot column

replace existing data

KGConcept: Excel File (8)

KGConcept: Course Metadata (10)

KGConcept: Import Action (9)

KGConcept: Append Mode (8)

KGConcept: Replace Action (8)

KGConcept: Pivot Field (9)

KGConcept: Column (9)

KGConcept: Import Validation Message (8)

KGConcept: Product Code (6)

KGConcept: Refresh (7)

KGConcept: Imported Metadata (9)