Technology Help Website: View a Content Inventory for a Service

Anyone with permissions to view content and who has the URL can view an inventory of published content associated with each Service page on the IT site, or download a comma separated values (CSV) document that can be imported into a Google spreadsheet.

Note: Only content that is correctly associated with the Service page will be displayed in the content inventory. See Associate Pages with Categories.

In this article:

Viewing a Content Inventory for a Service

  1. Sign in to the site at it.umn.edu/saml_login.
  2. Visit the Service page you want to base the inventory on, such as Drupal Lite.
  3. Select Edit.
  4. The node URL will be displayed in the address bar of the browser, such as "https://it.umn.edu/node/61466/edit." Replace "node" with "services-technologies" and "edit" with "content-inventory," so the URL looks something like https://it.umn.edu/services-technologies/61466/content-inventory.
  5. Select Enter to reload the browser window. A table of all the content on the IT site that is associated with that service will display.

Downloading a CSV File

  1. Repeat steps 1–4 above.
  2. Add ".csv" to the URL in step 4.
    URL bar with .csv appended to the end of the URL
  3. Select Enter to reload the browser window. A CSV file titled "content-inventory.csv" should download to your computer.
    Mac Finder window in the Documents tab. A content inventory titled file is being saved as a comma-separated values format

Importing the CSV File into a Google Sheet

  1. Create or open a Google Sheet.
  2. Select Import from the File menu. An Import file modal window will appear.
    Untitled Google spreadsheet. File dropdown opened with Import selected.
  3. Select Upload.
    Import file window with options for My Drive | Shared with me | Shared drives | Recent | Upload. Upload is selected.
  4. Select the Select a file from your device button. Another modal window that lists files on your computer will display.
  5. Select the .csv file that was downloaded to your computer.
  6. Select Open. The Import file modal window will display with radio buttons already selected. The defaults should be fine if you are starting from a new sheet.
    Import file window with Import location set to "Replace spreadsheet", Separator type set to "Detect automatically", Convert text to numbers, dates, and formulas set to "Yes"
  7. Select Import data. The data will display in five columns.
    Example of a spreadsheet with list of data in the five columns titled Page, Last Changed, Content type, Resource Type, URL

Last modified

Changed

TDX ID

TDX ID
6871