I feel like maybe the only way to do this is manually but I thought I'd ask here.
I work with a lot of schedules in media production and 100% percent of these come as PDF's in a similar format.
| Episode # | SC Due | NC Due | Locked | Final |
|---|---|---|---|---|
| 101 | 9/21 | 9/28 | 10/3 | 10/10 |
| 102 | 9/23 | 9/30 | 10/6 | 10/12 |
So forth and so on.
I can extract the info that I need from the PDF pretty easily by hand, but I can't figure out how to automate the import into a calendar. I just keep finding myself reformatting everything by hand and at that point. I might as well import the calendar by hand.
What should I be looking for to help.
Ideally, I'd have an event for each entry.
101 SC - 9/21 - ALL DAY
102 SC - 9/23 - ALL DAY
101 NC - 9/28 - ALL DAY
102 NC - 9/30 - ALL DAY
101 LOCKED - 10/3 - ALL DAY
102 LOCKED - 10/6 - ALL DAY
101 FINAL - 10/10 - ALL DAY
101 FINAL - 10/12 - ALL DAY
So forth and so on.
Thanks. Cheers.
