Schemas

Schemas help capture information in a strictly structured way. A schema is a group of fields that can store different data (similar to a form).

Create a Schema

Each schema type has some schema-specific settings and also requires different follow-up tasks. Please check each schema type for details.

  1. Select Schemas

  2. Open correct area (e.g., Lists)

  3. Press Add

  4. Choose Create

  1. Select the Parent List to create a child schema, which will inherit all fields from its parent.

  2. Provide a name (choose plural, e.g., products)

  3. Provide an ID (choose singular, e.g., product)

  4. Save

Import a Schema

You can import schemas from another Picturepark of the same version. It is not allowed that the schema has the same ID, so You must change this.

Lists linked to other lists must all have unique ideas. Picturepark will otherwise link to an existing list.

Update a Schema

  1. Open Schemas

  2. Open Schema Type

    1. Search for Schema

    2. Click on Schema

  3. Available Settings (cogwheel icon)

  4. Update & Save

Limitation: File Types are system fields. As such, we have limited what can be changed here so that the system works as expected. You can, however, make the following changes:

  • Name

  • Sort

  • Field Settings: Include in Search, Filters, and Analyzers, e.g., make XMP core fields searchable

    • You can make the original file creation date (EXIF) searchable to create a filter for the file creation date.

    • You can make DPI searchable to add a width/height filter to the sidebar or calculate orientations (if not available for all files).

  • Display Pattern

Export a Schema

You can export schemas for use in another Picturepark of the same product version.

  1. Open the desired menu.

  2. Select your schema and then export. Click on the icon in the toolbar.

  3. By default, the export contains all schemas. De-select any referenced schemas that you would like to exclude from your export.

  4. For lists, you can choose not to Export list items. You only export the fields and settings without any items.

  5. Click on Save.

Export a Schema as JSON for updates and re-imports

Please be patient. There is no indication that your schema is exporting - you will need to wait for your computer dialog to save. The export can take more than a few minutes for complex schemas.

If you are exporting Lists and Layers that have child lists, please select any child lists or layers that you would like to exclude while exporting.

Delete a Schema

  1. Open the desired menu.

  2. Choose to delete (trash bin icon) from the context menu or the toolbar in the browser or detail view.

  3. Confirm your desire to delete. 

References (assigned items) cannot be deleted. You must clean up the references first (e.g. remove from Tagbox, remove from items) 

System Schemas

  • Picturepark has so-called System Schemas that are required for the Picturepark to function correctly. 

  • All users can view the information therein if you use them in Lists or Layers.

  • System schemas display "SYSTEM" in the UI. 

  • You cannot create a system schema, delete the schema, or delete any fields.

Examples in Lists are country, language, and region, which show the "System"-flag in the top right corner.

Manipulating System Schemas

You can change the following in a system schema:

  • Indexing (filters, search, boost factors, text fields, filter, and simple search analyzers)

  • Name and translation

  • Available for

  • Description

  • Display patterns

  • Sorting

  • You can also add layers for file types.

  • You can add a calculated value for a field; however, we don't recommend doing this.

You cannot

  • create a system schema

  • delete a system schema

  • delete fields

  • add list items

  • apply permission set to these schemas.

Schema Hierarchies (Parent and Child)

In a parent/child setup, the children get the fields from their parents and different fields. Picturepark does not display the children. If you want to see the child schemas, double-click on the parent, which you can identify by icons.  

  • You cannot remove a field that is on the parent from a child schema.

  • You can only reorder the fields that are on the child directly. You cannot reorder inherited fields. The parent fields are at the top, above the child fields.

  • You can break inheritance for tagboxes but not for other fields, so your tagbox can be required on the parent and not on the child. Other fields like a title or date field are required on parent and child.

Schema Circular References

Picturepark Press Release

Circular references, also known as cyclic dependencies, make it possible to refer from one record to another and vice-versa. 

  1. Connecting lists: Cities and Regions

    1. The city Aarau is in the Region Aargau. The capital of Aargau is Aarau. 

  2. Connecting lists: Product and Market

    1. Product A is available in markets D, A, CH. In Market CH, the best-selling product is A. 

  3. Connecting lists: Employee and Department 

    1. The employee Megan Manager works in department Marketing. The supervisor of the department Marketing is Megan Manager. 

Entity Relationship

An employee with the Department. & The Department with a Supervisor.

You have a person and department entity. The person is a member of a single department (simplified). The Department has a supervisor who is one of the Employee members. 

Blueprints for Schemas (schema.org)

A good source for schema examples is the website of schema.org, an open-source community founded and supported by Google and Microsoft that maintains and promotes schemas for structured data on the Internet, on web pages, webshops, and many more.

Examples from schema.org, which you can use as a blueprint mainly for Lists in Picturepark: 

Vision Information Transaction AG - CH-5033 Buchs - Switzerland
https://picturepark.com - support@picturepark.com
© 2022 Vision Information Transaction AG