Import a running order
Turn a photo of the timetable, an Excel or CSV file, pasted rows or a Google Sheets link into running orders. Setclock creates the days and stages it names, and you check every row before anything changes.
Before you start
- The show is created with its dates, so a photo or sheet that says "Day 2" or "Saturday" lands on the right day. See Create a show.
- Every imported set counts toward your plan's sets. Changeovers don't.
Open the show's Lineup and press Import. On a show with no stages yet, press Import a running order. The Import lineup dialog offers Photo and Spreadsheet.
From a photo
Press Upload or take photos and pick up to 10 photos: timetables, flyers or set sheets, one per day is fine. Each must be under 15 MB.
Wait while Setclock reads them. Each stage it finds is listed with its rows.
Check the day. Photos are matched by the printed date, weekday, Day 2 or the day's name, and a missing day is added with the right date. If a photo doesn't say, pick one from Which day is this? Choose one.
Check the stage name and where it goes under Import into: an existing stage of the same name, or New stage. Press the bin to skip a stage.
Correct any start time, artist or minutes in the rows. Times without AM or PM are highlighted so you can check them.
If a stage already has a running order, choose Replace (it says how many running orders) or Add after what's there.
Press Import. When it replaces running orders, press again to confirm.
From a spreadsheet
Choose Spreadsheet, then paste rows copied from Excel, Google Sheets or Numbers, press Open an Excel or CSV file, or paste a Google Sheets link and press Get. A workbook with several tabs lets you pick the tab.
Check the column matches above the first rows: Artist, Start, End, Length, Set type, Set or changeover, Stage, Day or Don't import. Columns can be in any order. Untick The first row is column headings if the data starts on row 1.
A sheet with Stage and Day columns imports the whole show: keep Every day and stage, match each Day value to a show day, or choose Only the stage that's open. Otherwise pick the Rows for stage and Rows for day.
Leave Add changeovers in the gaps on to fill gaps of up to 3 hours between sets. A sheet with its own changeover rows keeps them.
Press Import, Add after what's there or Replace (press twice). For a whole show, press Import with the number of running orders, twice.
No sheet yet? Under Start from a template, download Excel or CSV, or open Google Sheets (make a copy). Keep the headings in row 1.
What the import does for you
- Converts 9:30 PM, 10pm, noon and midnight to 24-hour and lists every change it made.
- Reads lengths as minutes (60, 90m) or hours and minutes (1:30, 1h30), or works them out from start and end, past midnight too.
- Puts each stage in time order, even when the source lists the headliner first, and says Put in time order when it did.
- Offers Set doors to the first set's time when sets start before doors, or Keep the doors you have.
- Turns on Auto-start for imported items, so the night runs on its own once the first set starts.
- Leaves out doors and curfew rows, and lists rows it couldn't read.
It says "Photos must be under 15 MB; up to 10 at a time."
Some photos were too big or there were more than 10. Take a smaller photo or a screenshot, and import in batches.
It says "no running order found" or "could not read that photo"
The photo is blurred, cropped or too small to read. Retake it straight on, or copy the rows into a spreadsheet.
It says "Couldn't read that file. Save it as .xlsx or CSV, or paste the rows instead."
Open the file in Excel or Numbers and save it as .xlsx or CSV, or copy the rows and paste them.
It says "Set limit reached"
The import would go over your plan's sets across all shows. Take some rows out, replace a running order instead of adding to it, or ask for more sets. See Plans and limits.