Kendraio Adapter PPL - Bulk Upload Workflow

[BBGuy]

Relates to Adapter

Kendraio Adapter PPL #7

Description

This issue is for the development of a Bulk Upload workflow for the Kendraio Adapter.

Related Documents

Varies versions of the script on Google Drive

Workflow State

• The workflow is working and has been used to successfully load recordings onto PPL
• UI and UX improvements can be made including validation and page layouts.

Todo

• Field names to match CSV heading names
• All fields are in and in the correct order
• Add "default": "", to all elements so they auto-submit all data
• Handling of ISO lists country
• Handle all field types in the correct format for the CSV export
• Les strict required field list
• Use new serialize and file output blocks instead of CSV export block.
• Use new file input and parse data blocks instead of CSV import block.
• Look at page layout
• Use RegEx referenced patterns for ISRC (from builder: adapter -> Bloomen -> soundRecording -)
• Handling of ISO lists language
• Use reg ex for better validation - for a later date
• Rightsholder section to be conditional on “I Own The Rights to This Recording” field = “Y”
• Conditional validation for rightsholders section. All fields for each of the blocks.

Latest script

{"title":"PPL Export Example","blocks":[{"type":"file-input","label":"Import","accept":["csv"]},{"type":"parse-data","csvOptions":{"header":true,"skipEmptyLines":true,"dynamicTyping":false,"transform":false},"xmlOptions":{}},{"type":"debug"},{"type":"mapping","mapping":"data[0]"},{"type":"form","hasSubmit":false,"jsonSchema":{"title":"PPL recording","description":"Register a recording with PPL.","type":"object","required":["ISRC","Band / Artist Name","Recording Title"],"properties":{"ISRC":{"type":"string","title":"ISRC","minLength":12,"maxLength":12,"default":""},"Band / Artist Name":{"type":"string","default":"","title":"Band/Artist name"},"Recording Title":{"type":"string","default":"","title":"Recording Title"},"Version Type":{"type":"string","title":"Version Type","default":"","enum":["Album","Alternative","Demo","Edit","Instrumental","Karaoke","Live","Remix","Session","Single","None"]},"Is Remastered":{"type":"string","title":"Remastered","description":"This recording is remastered","default":"","enum":["Y","N"]},"Genre":{"type":"string","title":"Genre","default":"","enum":["Adult contemporary","Alternative Rock","Bhangra","Blues","Chamber music","Children's music","Christian","Classical","Country","Dance","Easy listening","Erotic","Folk","Gospel","Hip Hop","Jazz","Latin","Middle of the road","Musical (theatre)","New Age","Opera","Operetta","Other","Pop","Rap","Reggae","Religious","Rhythm and Blues","Rock","Rock and Roll","Show","Soul","Sound effects","Spoken word","Unclassified","World music"]},"Content Type":{"type":"string","default":"","title":"Content Type","enum":["Audio","video"]},"(P)Date (YYYY)":{"type":"integer","title":"(P)Date ","default":"","description":"This is usually the year in which copies were first issued to the public. If this took place more than 50 years after the recording was made, or if you are unsure, please contact us to clarify.","minLength":4,"maxLength":4},"(P)Name":{"type":"string","default":"","title":"(P)Name ","description":"The name of the original copyright owner of the sound recording as of the (P)Date."},"Primary Country of Recording":{"type":"string","default":"","title":"Primary Country of Recording"},"Country of Commissioning":{"type":"string","default":"","title":"Country of Commissioning"},"Alternative Title":{"type":"string","default":"","title":"Alternative Title"},"Duration (mm:ss)":{"title":"Duration MM:SS","default":"","type":"string","minimum":3,"maximum":6},"Explicit":{"type":"string","title":"Contains Explicit Lyrics","default":"","description":"This is an indicator that the recording contains explicit lyrical content.","enum":["Y","N"]},"Recording Date (DD/MM/YYYY)":{"title":"Recording Date","default":"","type":"string"},"Language":{"type":"string","title":"Language","default":"","enum":["English","Arabic","Bengali","..needs finishing.."]},"Country of First Publication":{"type":"string","title":"Country of First Publication","default":""},"Recording Venue":{"type":"string","default":"","title":"Recording Venue "},"Local Recording ID":{"type":"string","title":"Local Recording ID","default":"","description":"Local Recording ID"},"This Recording Uses a Sample":{"type":"string","title":"This Recording Uses a Sample","default":"","description":"This recording contains a Sample","enum":["Y","N"]},"This Recording Is a Medley":{"type":"string","title":"This Recording Is a Medley","default":"","description":"The recording is a Medley of more than one individual musical or lyrical works","enum":["Y","N"]},"My Line-up Default":{"type":"string","default":"","title":"Publisher Name"},"Number of Featured Performers":{"title":"Number of Featured Performers","description":"The number of unique Contracted and Other Featured performers who have contributed to the recording. Please refer to the PPL Repertoire Style Guide for further information.","default":"","type":"integer","minimum":0,"maximum":100},"Number of Non-Featured Performers":{"title":"Number of Non Featured Performers","description":"The number of unique Non-Featured performers who have contributed to the recording. Please refer to the PPL Repertoire Style Guide for further information.","type":"integer","default":"","minimum":0,"maximum":100},"I Own The Rights to This Recording":{"type":"string","title":"I Own The Rights to This Recording","default":"","enum":["Y","N"]},"Rightsholder ID 1":{"title":"Rightsholder ID 1","default":"","type":"integer"},"Rights Ownership Type 1":{"type":"string","default":"","title":"Rights Ownership Type 1","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 1":{"type":"string","default":"","title":"Rights Country Default 1"},"Rights Begin Date 1":{"type":"string","default":"","format":"date","title":"Rights Begin Date 1 (DD/MM/YYYY)"},"Rights End Date 1":{"type":"string","default":"","format":"date","title":"Rights End Date 1 (DD/MM/YYYY)"},"Rights % 1":{"title":"Rights % 1","type":"integer","default":"","minimum":0,"maximum":100},"Rightsholder ID 2":{"title":"Rightsholder ID 2","default":"","type":"integer"},"Rights Ownership Type 2":{"type":"string","default":"","title":"Rights Ownership Type 2","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 2":{"type":"string","default":"","title":"Rights Country Default 2"},"Rights Begin Date 2":{"type":"string","default":"","format":"date","title":"Rights Begin Date 2 (DD/MM/YYYY)"},"Rights End Date 2":{"type":"string","default":"","format":"date","title":"Rights End Date 2 (DD/MM/YYYY)"},"Rights % 2":{"title":"Rights % 2","default":"","type":"integer","minimum":0,"maximum":100},"Rightsholder ID 3":{"title":"Rightsholder ID 3","default":"","type":"integer"},"Rights Ownership Type 3":{"type":"string","title":"Rights Ownership Type 3","default":"","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 3":{"type":"string","default":"","title":"Rights Country Default 3"},"Rights Begin Date 3":{"type":"string","format":"date","default":"","title":"Rights Begin Date 3 (DD/MM/YYYY)"},"Rights End Date 3":{"type":"string","format":"date","default":"","title":"Rights End Date 3 (DD/MM/YYYY)"},"Rights % 3":{"title":"Rights % 3","type":"integer","minimum":0,"default":"","maximum":100},"Rightsholder ID 4":{"title":"Rightsholder ID 4","default":"","type":"integer"},"Rights Ownership Type 4":{"type":"string","default":"","title":"Rights Ownership Type 4","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 4":{"type":"string","default":"","title":"Rights Country Default 4"},"Rights Begin Date 4":{"type":"string","default":"","format":"date","title":"Rights Begin Date 4 (DD/MM/YYYY)"},"Rights End Date 4":{"type":"string","default":"","format":"date","title":"Rights End Date 4 (DD/MM/YYYY)"},"Rights % 4":{"title":"Rights % 4","default":"","type":"integer","minimum":0,"maximum":100},"Rightsholder ID 5":{"title":"Rightsholder ID 5","default":"","type":"integer"},"Rights Ownership Type 5":{"type":"string","title":"Rights Ownership Type 5","default":"","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 5":{"type":"string","default":"","title":"Rights Country Default 5"},"Rights Begin Date 5":{"type":"string","format":"date","default":"","title":"Rights Begin Date 5 (DD/MM/YYYY)"},"Rights End Date 5":{"type":"string","format":"date","default":"","title":"Rights End Date 5 (DD/MM/YYYY)"},"Rights % 5":{"title":"Rights % 5","type":"integer","default":"","minimum":0,"maximum":100},"Rightsholder ID 6":{"title":"Rightsholder ID 6","default":"","type":"integer"},"Rights Ownership Type 6":{"type":"string","default":"","title":"Rights Ownership Type 6","enum":["Exclusive Licensee","Original Copyright Owner","Successor In Title "]},"Rights Country Default 6":{"type":"string","default":"","title":"Rights Country Default 6"},"Rights Begin Date 6":{"type":"string","format":"date","default":"","title":"Rights Begin Date 6 (DD/MM/YYYY)"},"Rights End Date 6":{"type":"string","format":"date","default":"","title":"Rights End Date 6 (DD/MM/YYYY)"},"Rights % 6":{"title":"Rights % 6","type":"integer","minimum":0,"default":"","maximum":100}}},"uiSchema":{"Primary Country of Recording":{"ui:widget":"k-select","ui:labelProp":"name","ui:valueProp":"alpha2Code","ui:isMultiSelect":false,"ui:ref":"testCountries","ui:refType":"http"},"Country of Commissioning":{"ui:widget":"k-select","ui:labelProp":"name","ui:valueProp":"alpha2Code","ui:isMultiSelect":false,"ui:ref":"testCountries","ui:refType":"http"},"Country of First Publication":{"ui:widget":"k-select","ui:labelProp":"name","ui:valueProp":"alpha2Code","ui:isMultiSelect":false,"ui:ref":"testCountries","ui:refType":"http"}}},{"type":"debug"},{"type":"mapping","mapping":"[data]"},{"type":"debug"},{"type":"serialize","hasFormatSelection":false,"formats":["csv"],"csvOptions":{"header":true,"skipEmptyLines":true},"xmlOptions":{}},{"type":"file-export","label":"Export","fileName":"ppl_recording"}],"id":false}

[dahacouk]

@BBGuy I think we should use checkboxes for todo lists. Can you investigate and, if you agree, amend the first post above?

• Tick it if you wan' it!