Show Import allows an organization to import a large list of events, movies or shows from an excel spread sheet. This is especially useful to Film Festivals or Organizations that have many events or shows that need to be added to the system quickly.
1. Log in to Administration in Agile.
2. Open the Corporate Organization . Then open the current screening folder for that season's festival.
3. Once in the sales folder, select Show.
4. In the Show area at the top of your screen, right click and select Import.
5. On the Import page select Import Example. This will open an Import Spread Sheet.
6. Rename and save the spread sheet. Enter your Show information in the spread sheet. Below are descriptions of each column on the spread sheet. Some of the columns are required while 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 on the web. 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 the run time of the film in minutes. This is required.
E. Event Type - These are the different type of events (i.e. Feature, Opening Night Film, Short, Shorts Program, etc.). This is required.
F. Color – This will allow you to assign a color that will appear on the grid view online (i.e. Documentary films are all Red, while 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 for the import, but we highly recommend adding the information in the spread sheet and import all at once.
H. Short Description - This is a short synopsis of the film. This is optional, but we highly recommend adding this information in the spread sheet to import. (Image 6)
I. Short Descriptive 1 - Gives you an additional space to show the film type, the rating and the run time. This is optional.
J. Short Descriptive 2 – Can have additional information listed here (i.e. Doors Open at 6PM, etc.) 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 (i.e. Rush Line Only, Sold Out, etc.). This is optional
L. Show Info – This can be used to add additional information about the show (i.e. Sponsored by XYZ Company, etc.) This is optional
M. Extra HTML – Can add additional information for this event and can have customer scripting and other HTML Text. This is optional
N. Confirmation – Can add specific confirmation text for this event. This is optional.
O. Ticket Verbiage 1 – Can place specific information that will appear on the ticket when printed. This is optional as most ticket formats now pull information from different elements in the database.
P. Ticket Verbiage 2 – Can place specific information that will appear on the ticket when printed. This is optional as most ticket formats now pull information from different elements in the database.
Q. Ticket Verbiage 3 – Can place specific information that will appear on the ticket when printed. This is optional as most ticket formats now pull information from different elements in the database.
R. Ticket Verbiage 4 – Can place specific information that will appear on the ticket when printed. This is optional as most ticket formats now pull information from different elements in the database.
S. Ticket Verbiage 5 – Can place specific information that will appear on the ticket when printed. This is optional as most ticket formats now pull information from different elements in the database.
T. Project Code – If you have specific codes associated with the film, you can place it here. Not required.
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. Rentrak – If you report to Rentrak, place “True” in the field. If you do not, then place “False” in these fields. Generally used by Art House or 1st Run Cinemas. This switch allows user to pull Gross Revenue to send Rentrak report.
W. External Event ID – External Event ID self populates once you have imported the sheet. Leave this column blank.
X. Image - You show/film images can be imported at the same time as you import the spread sheet. Make sure that all of 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 using the main image. For multiple images, make sure to separate the image names with a comma.
**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 spread sheet, Agile will automatically create a thumb nail image using the 1st image from Image column.
Z. Ticket Image - This can be used on your print at home tickets if you need to have a sponsor logo on certain film’s tickets. Not required.
AA. Extra Image/Media – This is where you will put the link for your trailers via You Tube or Vimeo link.
**Note: Columns AB – AT 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 spread sheet is complete, you are ready to import your shows into Agile.
7. Repeat Steps 2 - 4 to get to the Import screen in your sales folder. Click on Upload Images first to import your images folder.
**Note: Make sure that all of your images are the same size and that the names of the images are listed the same way on the spread sheet.
8. Select the image folder from your desk top.
9. When the image's appear, in the text field at the top of the screen, name the folder for the image library (i.e. 2014 Feature Images) then click on Upload button at the bottom of the screen.
10. Once the images have been uploaded into the Image Library you will be taken back to the Import screen. Click on the Import button to select the import spread sheet.
11. Select your Import Spread Sheet from your computer
12. Once all of the shows from your spread sheet appear in the screen, Click Apply. If there are errors in the spread sheet, the system will notify you to let you know what column or cell needs to be fixed
Adding Showing Dates and Times to a screening using Templates.
13. Now you are ready to associate the showing dates and times with the show.
14.In the Show area, select the film that you need to add venue, dates and times to.
15. Right click on the Showing area and then select New. (Image 17)
16. In the Showing: Properties screen, you will see the name of the Show , the Template/Venue list. Choose you the correct Template/Venue from the drop down.
17. Choose the Start Date and Time of the showing.
18.If this show is a Recurring Showing, check mark the days that this Showing and Template will be used for future dates. Make sure to select the Through date for the final day this Template and Time will be recur.
19. If you are ready to place this on sale right away, check the Set On Sale box. If you need to set a specific On Sale Date and time, see How to Place a Show On Sale.
20. Click Add to add your showing(s). Click Close once complete.