Pasting in run of show items
If you already have a run sheet 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 of show 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 sheet is longer.
This is absolutely ideal for importing previous runsheets that might have been contained in a Word doc as text, or even from Excel (just copy and paste from Excel into notepad to convert to plain text).
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. Paste your run sheet 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.
What carries 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 is the parser's best guess from a time range, or the gap to the next line if that is clear, or zero.
Title is 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.
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.
