Show Import allows an organization to import a large list of events, movies, or shows from an Excel spreadsheet. This is especially useful to Film Festivals or Organizations that have many events or shows that need to be added to the system quickly.
You are now able to import shows at the top level in Agile. This allows organizations with multiple venues to build show (film) meta-data only once and use it for all venues and blue sales folders.
Pro Tip: Avoid major headaches by saving a copy of your Import Results File to your computer. This file will contain exact Event IDs that will be generated for your shows. If you ever notice an issue with your events, you can mass-update them by following the import process and loading your Results spreadsheet instead of your original import file.
1. Log into the Web Portal.
2. From the menu on the left side of the screen, click Events and then select Import.
3. Select the Shows tab.
4. On the right side of the screen, click the Download Example File button.
5. Rename and save the spreadsheet. Then, enter your Show information. Below are descriptions of each column on the spreadsheet. Some of the columns are required, others are optional.
A. Internal Name – This is the name of the show/film that will appear in the Agile Sales application. This is a required field.
B. External Name – This is the name of the show/film that will appear online. This should be the proper title of the film or event. This is required.
C. Original Name – If the show/film has a foreign title, this is where you will list the original title in its native language. This is optional.
D. Duration – This is how long you want the film to be available for Streaming online in minutes. This is required.
E. Event Type – These are the different types of events you have in Agile, but for virtual shows it will typically be "Streaming." This is required.
F. Color – This will allow you to assign a color that will appear on the grid view online (Documentary films are all Red, Shorts Programs are Blue, etc.). This is optional.
G. Description – This is where you will put a full-length synopsis of the film. This is optional but highly recommended for the import.
H. Short Description – This is a short synopsis of the film. This is optional but highly recommended for the import.
I. Short Descriptive 1 – This gives you an additional space to show the film's type, rating, and run time. This is optional.
J. Short Descriptive 2 – This lets you list additional information relevant to the show. This is optional.
K. Web Availability – This is an area to add additional information that you would want the customer to know when your inventory for that event/movie has reached zero, such as a "Sold Out" message. This is optional.
L. Show Info – This can be used to add additional information about the show (Sponsored by XYZ Company, etc.) This is optional.
M. Extra HTML – This can add additional information for this event and can have custom scripting and other HTML Text. This is optional.
N. Confirmation – This can add specific confirmation text for this event. This is optional.
O. Ticket Verbiage 1 – This can place specific information that will appear on the ticket when printed. This would not be used for Streaming Events.
P. Ticket Verbiage 2 – This can place specific information that will appear on the ticket when printed. This would not be used for Streaming Events.
Q. Ticket Verbiage 3 – This can place specific information that will appear on the ticket when printed. This would not be used for Streaming Events.
R. Ticket Verbiage 4 – This can place specific information that will appear on the ticket when printed. This would not be used for Streaming Events.
S. Ticket Verbiage 5 – This can place specific information that will appear on the ticket when printed. This would not be used for Streaming Events.
T. Project Code – If you have specific codes associated with the film, place it here. This is optional.
U. Distributor – You can place the Distributor’s name for this film. This is optional. Generally used by Art House or 1st Run Cinemas.
V. Distributor Reporting – Set to TRUE to automatically report revenue for this Show to comScore Swift and to Nightly Flash.
W. External Event ID – The External Event ID self populates once you have imported the sheet. Leave this column blank. 50 Character Limit.
X. Image - Your show/film images can be imported at the same time that you import the spreadsheet. Make sure that your images are all the same size and have been named for ease of association. If you have multiple images for the film, the first image listed in the cell will be the main image for the film page and will also create the thumbnail. For multiple images, make sure to separate the image names with a comma. Also, if you choose to specify a folder name in the Subdirectory box (see Step 8) you must specify this folder name in the image cell, e.g. "Folder Name\Image Name.jpg".
**NOTE: We recommend that all of your images are sized to 560 pixels wide x 315 pixels high at 72 dpi.
Y. Thumbnail Image - You may leave the Thumbnail Column blank. When you import your spreadsheet, Agile will automatically create a thumbnail image using the 1st image from Image column.
Z. Ticket Image - This would not be used for Streaming Events and isn't required.
AA. Extra Image/Media – This is where you will put the link for your trailers via YouTube or Vimeo link.
***If you need help understanding any of the values between these stars CLICK HERE for an explanation on how to Set Up Virtual Events***
AB. Stream Type - This is where you define what Streaming service you will be using. The options are AgileLINK, AgileLINKVoucher, CineSend, CineSendVoucher, Brightcove, ExternalURL, EmbedURL, PurchaseURL, Vimeo, VimeoLive, VimeoShowcase, ZoomMeeting.
AC. Stream Asset ID - If you already have a MeetingID or Asset ID for your meeting/video, you can put that here.
AD. Stream Viewing Window - This defines how the stream is accessed by the customer. The options are EndDate, FirstWatch, OpenToAll, OpenToMembers, PurchaseDate, StateDate.
AE. Stream Hours - You can define a customer length of time the customer has access to the stream here. If left blank or at 0 it will default to 50 hours
AF. Stream Site URL - Only used for specific Stream Types (ExternalURL, EmbedURL, and PurchaseURL), otherwise leave blank. This field is optional.
AG. Stream Geo Blocking - This allows you to set individual-show Geo Blocking. The values are Same State, Same Country, and US & Canada. You may also put a number into this field and that number will be assessed as the amount of miles in a Zip Radius. If you leave this field blank it will be assessed as whatever default value is for your Organization (Geo Blocking is disabled by default. If you wish to have this changed, please talk to your Agile Representative).
AH. Stream Purchase Prompt - This field allows you to specify the "Buy" button text.
AI. Stream View Prompt - This field allows you to specify the "Click To Stream" button text.
**************************************************************************************************
**Note: Columns AJ – AZ are called Custom Properties. These custom fields are designated by each film festival or organization to allow them to enter additional information about the film (i.e. Cast and Crew Information, Run Time, Country of Origin, etc.). Even though these fields are created by the organization, if you do not add information into these cells, the information will not populate online. For more information on how to create Custom Properties, click here.
When your spreadsheet is complete, you are ready to import your shows into Agile.
6. Once you have entered all of the show metadata, go back to the import page in Web Portal.
7. First, you will begin uploading the images that go with the shows you are trying to import. Click the Images tab at the top of the import page.
8. Next, select the Create a New Image Folder (i.e. 2019 Images) or select an Existing Image Folder from the drop-down. Click the Select Images button and choose the images from your computer that you wish to upload.
9. If your images have been uploaded successfully, you will see Success in green next to the images.
10. Once the images have been added to the library, you will need to go back to the Shows tab of the Import page.
11. Select the folder where you want to import your shows.
12. Click the Load Excel File button and select your completed spreadsheet.
13. Your shows will appear. If there are errors in the spreadsheet, the system will notify you to let you know what column or cell needs to be fixed. To fix an issue, double-click the cell and edit it.
14. After you have reviewed your loaded excel file, click Upload to import your shows.
15. Click Yes to confirm your import. You will be notified when the import is complete.
16. On the import window, you will notice that the successfully imported shows have turned green.
17. You are also able to download a Save Results File if needed.
Comments