Pasting in a run of show
If you already have a run of show in a Word document, an email, a spreadsheet, or anywhere else as plain text, you can import it into 1pm by pasting it in. This is the fastest way to get an existing run sheet into a new event.
You can paste up to 200 lines at a time. The cap is per import, not per event, so you can paste multiple times if your run of show is longer.
How it works
Open the event in the planner. Above the timeline on the right side you will see a Paste in button. Click it.
A modal opens with a large text box that fills the window height, so a long run of show is easy to scroll and scan. Paste your run of show into the box.
1pm reads one activity per line. The format on each line is the time first, then the title.
Examples that work:
9am Setup
9:30am Sound check
10:00 Doors open
10:30 - 11:15 Welcome remarks
You can mix formats in the same paste. The parser handles 12-hour times (9am, 9:30pm) and 24-hour times (09:00, 21:30). A time range like 10:30 - 11:15 is parsed as start 10:30 with a 45-minute duration.
Preview
Click Preview to see what 1pm understood from your text. The parser shows every line with the start time, the duration (editable inline), and the title it pulled out. Rows it could not parse are marked as skipped, with a short warning explaining why.
If a row's duration is wrong, click into the duration cell and type the correct number of minutes before confirming.
Two buttons let you change your mind:
Edit. Takes you back to the text box with your original paste preserved so you can fix the source and re-preview.
Cancel. Closes the modal without adding anything.
If you are happy with the preview, click the Add button at the bottom to import the items. The modal closes and the new items appear in your timeline.
Reformatting titles as you import
Pasted-in titles often arrive in whatever case the source used, ALL CAPS from a supplier's spreadsheet, or a jumble of styles from an email. On the preview screen there is a Format toggle that tidies every title in one go, so you do not have to retype them:
- Off. Leave titles exactly as pasted. This is the default.
- Title Case. Capitalises The First Letter Of Each Word.
- Sentence case. Capitalises only the first letter of each title.
- UPPERCASE. Sets every title in capitals, handy if your printed run sheet or crew view reads better shouting.
Pick an option and the preview updates live, so you can see the result before you commit. The choice is applied once, when you click Add, to the titles being imported; it does not touch items already on the timeline, and you can still edit any individual title inline afterwards.
What carries through and what does not
Paste import covers the basics: start time, duration, and title. Other fields are set to defaults:
- Date. Defaults to the event date. If the event spans multiple days, you can edit each row's date inline after import.
- Duration. The parser's best guess from a time range, or the gap to the next line if that is clear, or zero.
- Title. The part of the line after the time.
Details, Where (location), Responsible crew, and Private are not imported. Add or edit them per item after the import is complete.
Common gotchas
- Each line must start with a time. A line that starts with a title gets skipped.
- Use one activity per line. If two activities sit on the same line, the second one is lost.
- If the source has bullets or numbering at the start of the line (1., -, *), strip them first. Lines that do not start with a time are skipped.
- Smart quotes and other unusual characters generally come through fine, but if a row is skipped unexpectedly, copying the line into a plain text editor and pasting it back into 1pm usually fixes it.
- Pasting straight out of Gmail sometimes drags along invisible zero-width characters around separator lines. 1pm strips these on the way in, so a paste from an email thread no longer leaves you with blank junk rows to clean up.
Limits
200 rows per import. If your source has more than 200 rows, the parser truncates and tells you. Paste the remainder as a second import.
500 timeline items per event. The import adds to whatever is already on the timeline. The 500-item cap applies to the total.