A custom asset/sponsor scheduler.

Version 1.0.0

• Copy the Creative field into the Asset description field.

• Use the Advertiser as the campaign and client.

• Open the last used file folder if the current input file field is blank.

• Save the schedule items in batches instead a single large transaction.

Version 0.1.2

• An initial test version

• Reads an Excel file to get sponsor schedules to apply to a Tick-It instance.

• Creates an asset placeholder for scheduling if the asset cannot be found.

Working Assumptions

1. Each day starts at 5:00 am and runs to 5:00 am the next day

2. If no Start and End Time is given then assume 5:00 am to 5:00 am the next day

   1. Example for an End Date of 2023-10-01 the actual end is 2023-10-02 5:00

      1. The last possible asset scheduled time would be 2023-10-02 4:59

3. Use the House# (example: AB15117) to identify the asset to be scheduled.

4. If no Rotate value is provided then the sponsor is scheduled once per hour at the given offset (example 5:08) of each day.

5. If the given End Time is at or before 5:00 it is assumed to be the next day. (example Start: 19:00 with End: 5:00)

6. If the asset doesn’t yet exist in the Tick-it database, then create a placeholder asset and schedule it assuming a user will assign the required template and campaign information in Flow.

7. Requires the following columns in the given order:

   1. Feature

   2. Advertiser

   3. House #

   4. Zone #

   5. Start Time (HH:mm)

   6. End Time (HH:mm)

   7. Rotate

   8. Start Day

   9. End Day

   10. (another column)

   11. Offset