iService Calendar

The iService Calendar highlights all events, activities, training, announcements, launches, deadlines and other important occasions pertaining to HR, Finance, Departmental Security and IM/IT. Submitted calendar items must be available to all employees and not a specific audience.

Content Approver

Content Approver

Submission of New Items to the Calendar

New calendar items must be submitted by an iService Content Approver. Content Approvers must submit new calendar items online by completing the electronic "Add a Calendar Item" form or by e-mailing the Content Design Team at: esdc.nc.iservice.design-conception.iservice.cn.edsc@servicecanada.gc.ca with the following information:

Requestor's Name:
(required)
Email:
(required)
Date/Period of the calendar item:
(required)
Title of the calendar item in English:
(required)
Title of the calendar item in French:
(required)
Link to HTML page in English:
(if available)
Link to HTML page in French:
(if available)
Service (HR, Finance, Security, IM/IT):
Discipline in English:
Discipline in French:
Type of calendar item:
Other instructions:

New calendar items are added and updated weekly.

Content Publisher

Content publisher

This work instruction is for publishing data to the iService Calendar.

The data is kept in an Excel spreadsheet in the iService SharePoint.

 Watch the video: iService Calendar Work instruction Tutorial (available to iService team members)

  1. Make a working of the Excel spreadsheet (XLXS, 276 KB).
  2. In the data tab, sort all the information by date from oldest to newest.
  3. All of the information in the tabs EN-Cal, FR-Cal, EN-table & FR-table are taken from the data tab dynamically.
  4. Look for cell entries that have #REF! in them. This will indicate an error that is usually caused by a row in the data tab being deleted. Select the row and delete it.
  5. Ensure there are enough rows in each of the tabs for all the items in the data tab. Select the entire last row. Grab the square box from the bottom left of the first cell and drag it down until you reach the number of rows needed. For example: If the data tab has 306 rows the other tabs need 306 rows. This action will copy all the html code and the formulas that are needed for extracting information from the data tab.
    decorative

 

English Calendar

  1. copy the contents of the tab "EN-Cal" starting at the row with actual calendar information (row 2). Do not copy the titles row.
  2. Paste the contents into Notepad++
  3. Delete all the spaces. for example the space between the quote and /eng: href="    /eng/ with a search and replace.
  4. Delete all the http://iservice.prv leaving the URL to start at the root. For example: /eng/...
  5. Delete all the time entries that are caused by empty "to date" items. Search for &#160;to&#160;<time datetime="1900-01-00">January 0, 1900</time> and replace with nothing.
  6. Copy the entire contents into https://jsfiddle.net to tidy the code. Use the HTML window and use the "tidy" link in the top right of that window.
  7. Replace the entire calendar list between <ul id="EN-Cal"> and </ul> with the new list.

French Calendar

  1. Copy the contents of the tab "FR-Cal" starting at the row with actual calendar information (row 2). Do not copy the titles row.
  2. Paste the contents into Notepad++
  3. Delete all the spaces. for example the space between the quote and /fra: href="    /fra/ with a search and replace.
  4. Delete all the http://iservice.prv leaving the URL to start at the root. For example: /fra/...
  5. Delete all the time entries that are caused by empty "to date" items. Search for &#160;au&#160;<time datetime="1900-01-00">0 janvier, 1900</time> and replace with nothing.
  6. Copy the entire contents into https://jsfiddle.net to tidy the code. Use the HTML window and use the "tidy" link in the top right of that window.

  7. Replace the entire calendar list between <ul id="FR-Cal"> and </ul> with the new list.

     Pro Tip! Search for "<table" to quickly find the end of the list.

Upcoming Events table

This instruction applies for both languages.

  1. Copy the contents of the tab "EN-table" (FR-table) starting at current date or the next newest date. do not copy the titles row.
  2. Paste the contents into Notepad++
  3. Delete all the spaces. for example: href="   /eng/ with a search and replace.
  4. Delete all the http://iservice.prv leaving the URL to start at the root. For example: /eng/... (/fra/...)
  5. Remove the <a href="#calendar"> links leaving just the text. Use this regular expression: find what: <a href=\"#calendar\">(.*?)</a> Replace with: $1
  6. Copy the entire contents into https://jsfiddle.net to tidy the code. Use the HTML window and use the "tidy" link in the top right of that window.
  7. Replace the entire contents of the table between <tbody> and </tbody> with the new information.
  8. Publish the page.