Categories CSV - Usage and Schema Description

action

Optional

Kaltura’s numeric value for the action to apply on a specific category.

CSV lines with different actions can be combined into a single CSV file. Only fields that are relevant to the CSV action will be used.

The supported action types and their numeric values are:

1=Add - to add a category

2=Update – to update an existing category

3=Delete – to delete an existing category

6=Add or Update – to add or update a category when the given categoryId or referenceId are already available in Kaltura.

1= Add

KalturaBulkUploadAction

name

Mandatory in add actions

The name of the category. When the category name includes the > character it will automatically be replaced with _ (underscore character).

Text field. Maximum length: 60 characters

relativePath

Optional

The category-tree path in which the category is located or should be created. Each category level within the path should be separated by the ‘> ‘character.  

Note: The provided path must exist prior to processing  the CSV line, or created in a higher CSV line.

Text field. Unlimited length

categoryId

Optional

The Kaltura internal and unique identifier of the category. The categoryId field is used in the CSV for identifying a category that requires updating or needs to be deleted.

In an ‘update’ or a ‘delete’ action, either the categoryId or the referenceId field must be provided for identifying the category to which the action should apply.

In ‘add’ actions the categoryId field will be ignored.

Integer 

referenceId

Optional

A possible identifier of the category based on an identifier from an external system that can relate the category to an external entity it represents or related to.

In an ‘update’ or a ‘delete’ action, either the categoryId or the referenceId field must be provided for identifying the category to which the action should apply.

In ‘add’ actions the referenceId will be populated into the new category.

Note: The uniqueness of the referenceId field is not verified nor managed in Kaltura.  It is recommended to use logic that maintains this uniqueness for being able to reference bulk actions and API calls to a specific category.

In case multiple categories with the same referenceId exist in the account, any update/delete action will be committed only to a single category.

Text field. Maximum length: 512 characters

tags

Optional

The tags to be added to the category. Multiple tags can be separated by commas, while the entire field should be wrapped with double quotation marks (e.g. “tag1, tag2). 

When the CSV is created in a simple text editor or by a script, the wrapping quotation marks should be added explicitly. When CSV is created with a spread sheet editor (e.g. Excel) this wrapping is automatically generated when saving to a CSV format with no need for manual editing.

Tag values cannot include commas.

Text field. Unlimited length

description

Optional

A description of the category and its applicative/administrative purpose.

When the CSV is created in a simple text editor or by a script – adding wrapping quotation marks is recommended for cases in which the description includes commas

Text field. Unlimited length

Custom Data

Custom data fields that are set to extend the Kaltura Category object can be populated into a category by defining the fields in the following formats:

metadata::the-schema-system-name::the-schema-field-name

With this format multiple custom data schemas and fields can be populated via the CSV.

Custom data schema and fields system names are available in the custom data setting page in the KMC.

Values of custom data fields that have multiple values should be separated with the following delimiter:   |,|

Note: When updating custom data fields to an existing category, a new metadata XML is automatically created. For preventing overriding existing values, all custom data fields that are set for the user should be provided in the CSV as part of the update action.

Entitlements settings

privacy

Optional

The numeric value of the Content Privacy option to set for the category as part of its entitlements settings.

This option is enabled only in accounts that are configured to support end-user entitlements to content and for categories that were set to have entitlement settings.

The supported action types and their numeric values are:

1= No Restriction

2 =Requires Authentication

3= Private

1 = No Restriction

KalturaPrivacyType

appearInList

Optional

The numeric value of the Category Listing option to set for the category as part of its entitlements settings.

The setting of this option is enabled only in accounts that were configured to support Content Entitlements and in categories that have entitlement settings.

The supported action types and their numeric values are:

1= No Restriction

3= Private

1 = No Restriction

KalturaAppearInListType

contributionPolicy

Optional

The numeric value of the ContributionPolicy option (who can add content to the category) to set for the category as part of its entitlements settings.

The setting of this option is enabled only in accounts that were configured to support Content Entitlements and in categories that have entitlement settings.

The supported action types and their numeric values are:

1= No Restriction

2= Private

1 = No Restriction

KalturaContributionPolicyType

inheritanceType

Optional

The numeric value of user permissions inheritance option (Inherit End-User Specific Permissions from Parent Category) to set for the category as part of its entitlements settings.

The setting of this option is enabled only in accounts that were configured to support Content Entitlements and in categories that have entitlement settings.

The supported action types and their numeric values are:

1= Yes.  inherit specific end-user permissions from  parent category

3= No.

2=No

KalturaInheritanceType

owner

Optional

The userId of the category's owner.

Text Field.

Minimum length: 3 characters Maximum length: 100 Characters

Only the following special characters are supported as part of the userId:

. _ @ -

defaultPermissionLevel

Optional

The numeric value of the default permission Level the end-users should be granted for the specific category (unless other permission level was specified explicitly via CSV or API). The supported values are:

0=Manager

1=Moderator

2=Contributor

3=Member

3=Member

KalturaCategoryUserPermissionLevel

moderation

Optional

Indicates whether content should be moderated in the application before it is added to the category.

0=moderation is not required

Boolean