CSV Import

    

Metadata for specified assets can be imported into Picturepark using the metadata import with the help of a csv file. Metadata can be created or current metadata overwritten.  A template file can be created using the report function. In addtion you have the option of creating new users in Picturepark via CSV file.

 

metadataimport_en

 

hint Tip

Metadata imports should always be tested first with a small set of test data. This ensures that the results of the import are correct and no data is lost.

 

In addition to the metadata import a category creation or assignment can also be carried out. The files must have the following structure:

 

  • Category/classes (creation)

The CSV file must include the name for each category language, as well as the descriptions for the new categories. The full path is specified by the "All" channel.  

csv-import-createcat

 

  • Assignment (of categories/classes)

The CSV file can assign assets to the category referenced in the "FullPath" using the AssetId or the OriginalFileName/ModifiedFileName for example.

csv-import-assigncat

 

  • Users

The CSV file for auser must contain the following columns. Multiple user group assignments are possible via a semi-colon as a separator.

 

  • EmailAddress
  • Password
  • FirstName
  • LastName
  • Telephone
  • Company
  • Department
  • Street
  • Country
  • Zip
  • City
  • LanguageId
  • Language4ContentId
  • CanChangeOwnProfile
  • LoginOnlyWithSecurityToken
  • ExpirationDate
  • LockDate
  • RenewalUntilDate
  • UserGroups
  • CanBeInternalContact
  • UseLdapAuthentication
  • ExcludeFromTraffic