Import and Export as .XLS

In addition to saving your project to Dropbox, you can also export a project to your Dropbox account in the popular .xls format used by Excel, Numbers and other spreadsheet programs.

Once you export a project, you can then enter details and notes or insert additional scenes in a spreadsheet program on your computer, before sending it back to Dropbox and reimporting it into ShotList.


To import or export, select a project, then tap the Dropbox logo to the left of the bottom menu bar.

To create a template to work from, we suggest you should create a new project and export it. You can copy and paste additional rows freely to create scenes, and the same with day markers, but do not add or delete columns, as it is quite important to stick to a structure that ShotList can read.

We suggest that you make a few simple edits and reimport your project, to test the workflow, before making a lot of complex edits.

Images

You can import additional images into the project by placing the files in the project Dropbox folder as .pngs and then entering their name into the spreadsheet in the “Pic” column (including the .png extension)

To keep the memory footprint low and allow easier backup and sharing of projects, it is important to use screen resolution or lower (say 640 x 480, 1024 x 768, or 2048 x 1536) for these files. They are never shown within ShotList at greater than screen resolution anyway.

Characters

You can select whether to handle castlists as a string of names or numbers when exporting the file, using a switch on the ShotList page of the Settings app.

The heading (“CastNumbers” or “CastNames”) for this column in the file determines how it is interpreted on import.

When entering a castlist for a scene as a series of numbers, place a comma and a space between each one, e.g. “1, 2, 4, 6”

When entering a castlist for a scene as a series of names, place a comma and space between each one. e.g. “Heisenberg, Jesse, Skylar”

ShotList maintains an extra list at the bottom of the spreadsheet to map  characters consistently to cast numbers. You will need a column containing the cast numbers, starting from 1, next to a column with the character names. It is important that this data section ends with the “EndOfCastList“ marker.

Dates

Dates are entered in the Date column of a day strip as a simple string using a day number, a three-letter month and a full year. e.g. “21 Aug 2011” (or possibly Aug 21 2013, depending how your device is configured.)

The date field is left blank for individual scenes.

On To Printing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: