Credits Editor for DVD Profiler

What's This?

An Excel workbook template for editing cast and crew credits with maximum flexibility. See screen shot.

Features

• Maximum comfort and flexibility while editing data due to reliance on the well-known and intuitive Office user interface.
• Uses Outline to structure credits with dividers.
• Uses AutoFilter to quickly find certain credit entries (e.g. those with a birth year).
• Supports multiple cast and crew sheets for managing credits from multiple profiles.
• Full data validation. Minor problems, such as truncations and inexact Unicode conversions, can be highlighted.

Requirements

• DVD Profiler 3.5 or newer (Invelos).
• Microsoft Excel 2000, Excel 2002/3, Excel 2007 or newer.
• Microsoft Windows 2000, Windows XP, or Windows Vista.

Terms of Use

This software is Copyright (c) 2007-2008 Matthias Wolf, Germany AKA goodguy. All rights reserved.

Permission is hereby granted, free of charge, to use and redistribute this software in unmodified form, for non-commercial purposes, and provided that any use or redistribution retains or reproduces, in the documentation and/or other materials, the copyright notice above, this permission and the following disclaimer.

DISCLAIMER This software is provided "as is", without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and noninfringement. In no event shall the author be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the software or the use or other dealings in the software.

Feedback

If you have questions, comments, or suggestions, you can send a PM to goodguy on the Invelos forums. Alternatively, you can reply to this Invelos forum thread.

Make a Donation

Credits Editor may be used free of charge, but if you wish to express your appreciation for the time and resources I have spent on developing this software, you are welcome to make a donation by using one of the following PayPal links:

Install Steps

1. Download CreditsEditor.zip (89KB) and unpack it into a dedicated folder.
2. Create a shortcut to the unpacked CreditsEditor.xlt on your Start Menu.

Commands

• Copy
  Copies the content of the current cast or sheet to the clipboard after fully validating all data.
  To paste these data into DVD Profiler, open the Edit Profile window, right-click on the current cast or crew list, then select Paste All Cast/Crew.
• Paste
  Pastes the content of the clipboard into the current cast or crew sheet. If the sheet already contains data, the new content will be appended. This allows you to quickly merge credits from multiple (child) profiles.
  To copy credits from DVD Profiler to the clipboard, open the Edit Profile window, right-click on the current cast or crew list, then select Copy All Cast/Crew.
• Clear
  Deletes all data on the current cast or crew sheet.
• More
  Displays a popup menu with the following commands.
  • AutoFit Columns
    Adjusts the width of all columns to fit their content. This happens automatically when you paste new data into the sheet, but you may have to re-apply the command after manually entering data.
  • Outline by Dividers
    Toggles the Excel Outline to group credits by dividers.
  • AutoFilter
    Toggles the Excel Autofilter.
  • Role First (Cast only)
    Toggles the position of the Role column. Alternatively, you can change the order of all columns by manually dragging them around.
  • Show Credit Type (Crew only)
    Shows or hides the Credit Type column, which contains the "super" type of a crew credit (e.g. Writing). This column is hidden by default, and its content is only used to restrict the choices of the CreditSubtype column. Exception: Since the CreditSubtype "Custom" can belong to any CreditType, you have to explicitly pick a CreditType.
  • New Sheet
    Creates a new, empty sheet of the same type (cast or crew) as the current one.

Data Columns

• Div - Divider
  To create a divider, you enter it in this column and leave all other columns empty. The maximum length for a divider is 40 characters.
• FirstName, MiddleName, LastName
  Enter the name parts into the appropriate columns. At least a first name is required. The maximum length for each name part is 25 characters.
• BY - Birth Year
  Optional.
• CreditedAs
  Optional. The maximum length is 40 characters.
• Role (Cast only)
  Optional. The maximum length is 40 characters.
• U - Uncredited, V - Voice (Cast only)
  Instead of checkboxes, any text in these columns will mark the credit entry as Uncredited and/or Voice. The default text used is "u" and "v".
• CreditType (Crew only)
  This is the "super" type of a crew credit (e.g. Writing). It can be picked from a drop down list. The column is hidden by default, and its content is only used to restrict the choices of the CreditSubtype column. Exception: If you want to use a CustomRole without a predefined CreditSubtype, but with a predefined CreditType, you have to explicitly pick the CreditType. Otherwise, the CreditType will be "Other".
• CreditSubtype (Crew only)
  This is the real crew role (e.g. Screenwriter). It can be picked from a drop down list. Leave empty for an entirely custom role that should not match any of the predefined ones.
• CustomRole (Crew only)
  This is an optional custom crew role.

Version History

• v1.0.4: Support for DVD Profiler 3.5 added.
• v1.0.3: First public release.