Knights of the Editing Table
Knights of the Editing Table
  • Manuscript
  • Extensions
    • Excalibur
      • What is it for?
      • How it works
      • Search Bar
        • Windows
      • Settings
        • Commands
        • General
      • List of Commands
        • Timecode
        • Clip
        • Sequence
        • Selection
        • Project
        • Export
        • Video/Audio Effects
        • Video/Audio Presets
        • Video/Audio Transitions
        • Preferences
        • Special
      • User Commands
        • Keyboard Shortcut
        • Wait
        • Wildcards
        • Extensions
      • Special Bins
      • Limitations
      • Compatibility
        • macOS Permissions
        • Windows Antivirus
      • Change Log
      • Uninstall
    • Quiver
      • Main panel
      • Settings
      • Start Marker
      • Bin item
      • Sequence item (group of clips)
      • Projects library
      • Spell Book shortcuts
      • Excalibur user command
      • Videos
      • Change log
      • Uninstall
    • Watchtower
      • What is it for?
      • How it works
      • Main Panel
      • Watch-folders manager
        • Image sequence detection
        • Supported camera folders
      • Settings
        • Regex folder name filter
      • Pro Tips
      • Spell Book shortcuts
      • Compatibility
      • Videos
      • Change log
      • Uninstall
    • Grave Robber
      • What is it for?
      • How it works
      • Main Panel
      • Settings
      • Spell Book shortcuts
      • Excalibur user command
      • Compatibility
        • Windows Antivirus
      • Change Log
      • Uninstall
    • Chronicler
      • What is it for?
      • How it works
      • Main Panel
      • Settings
        • General
        • Export
      • Compatibility
        • Windows Antivirus
      • Change Log
      • Uninstall
    • Anchor
      • Main panel
      • Spell Book shortcuts
      • Excalibur user command
      • Compatibility
      • Change Log
      • Uninstall
    • Cauldron
      • What is it for?
      • How it works
      • Compatibility
      • Change Log
      • Uninstall
    • Arrow
      • Main panel
      • Settings
      • Image transparency
      • Spell Book shortcuts
      • Excalibur user command
      • Compatibility
      • Change log
      • Uninstall
    • Compass
      • How it works
      • Wildcard names
      • Disable Compass
      • Compatibility
      • Change log
      • Uninstall
    • Portal
      • What is it for?
      • How it works
      • Settings
      • Spell Book shortcuts
      • Compatibility
      • Change log
      • Uninstall
    • The Game
      • Settings
      • Customize sounds
      • Change log
      • Uninstall
    • Spell Book
      • What is it for?
      • How it works
      • Main window
      • Control Surfaces
      • Supported apps
      • Uninstall
    • Spell Book [Excalibur version]
      • What is it for?
      • How it works
      • Uninstall
  • SUPPORT TOOLS
    • Merlin
      • Supported extensions
      • Uninstall
    • Undead
      • Supported extensions
      • Uninstall
  • Website
    • Free
      • Convert .kys file
    • License Management
  • Support
Powered by GitBook
On this page
  • User ID
  • CSV Location
  • Webhook
  • JSON structure:
  • Google Sheet script example
  1. Extensions
  2. Chronicler
  3. Settings

Export

Last updated 8 months ago

User ID

Set user ID which will be linked to Chronicler data genarated on a computer. It is useful if you collect data from multiple machines and you want to distinguish between them.

CSV Location

CSV file will be automatically created in predefined location.

Webhook

Add url to post data to. All data is live and is posted as you work.

JSON structure:

Key
Description

user_id

User ID, can be defined in Settings -> Export tab

app_id

Application ID

unix_start

Start time in UNIX

unix_end

End time in UNIX

date

Date in "YYYY-MM-DD" format

start

Start time in "HH:MM:SS" format

end

End time in "HH:MM:SS" format

folder

Folder name in Chronicler panel

production

Production name (only for Premiere Pro)

project

Project name

project_item

Project item name

project_item_type

Project item type: projectpanel, document, multicam, sequence

duration

Duration in "HH:MM:SS" format

duration_hours

Duration in hours

rate

Rate set in Chronicler panel

sum

Sum = duration_hours * rate

project_id

Project ID (could be project path or different ID)

untitled_id

Project ID before it was saved to disk

Google Sheet script example

function doPost(e) {
  const sheetName = "Sheet Name";
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  const data = JSON.parse(e.postData?.contents);
  sheet.appendRow([
    data.user_id,
    data.app_id,
    data.unix_start,
    data.unix_end,
    data.date,
    data.start,
    data.end,
    data.folder,
    data.production,
    data.project,
    data.project_item,
    data.project_item_type,
    data.duration,
    data.duration_hours,
    data.rate,
    data.sum,
    data.project_id,
    data.untitled_id
    ])
}