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
      • Special Bins
      • Limitations
      • Compatibility
        • macOS Permissions
        • Windows Antivirus
      • Change Log
      • Uninstall
    • Quiver
    • 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
      • Videos
      • Compatibility
      • Change log
      • Uninstall
    • Grave Robber
      • What is it for?
      • How it works
      • Main Panel
      • Settings
      • Excalibur shortcut
      • 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
      • What is it for?
      • How it works
      • Excalibur shortcut
      • Compatibility
      • Change Log
      • Uninstall
    • Cauldron
      • What is it for?
      • How it works
      • Compatibility
      • Change Log
      • Uninstall
    • Arrow
      • What is it for?
      • How it works
      • Image transparency
      • Compatibility
        • macOS Permissions
        • Windows Antivirus
      • Change log
      • Uninstall
    • Compass
      • How it works
      • Wildcard names
      • Disable Compass
      • Compatibility
      • Change log
      • Uninstall
    • Portal
      • What is it for?
      • How it works
      • Settings
      • Compatibility
      • Change log
      • Uninstall
    • The Game
      • Settings
      • Customize sounds
      • Change log
      • Uninstall
    • Spell Book
      • What is it for?
      • How it works
      • Uninstall
  • SUPPORT TOOLS
    • Merlin
    • Undead
  • 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 7 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
    ])
}