Load devices

When you launch Gopher for Chrome in a blank Google Sheet, you will see the Load managed devices from... sidebar tab, which allows you to import managed devices to the Devices tab via one of three sources:

  1. Admin console
  2. CSV file (located under the Push Updates to Google tab)
  3. List of Asset IDs or Serial Number (via Copy+Paste --OR-- USB Scanner)

Loading devices from the Admin panel

Loading from the Admin console offers very basic queries based on Org Unit Path and Enrollment Dateor device status. Once a device import has been run, a Devices Spreadsheet tab will fill with all available data on all devices that match your query. More advanced filters now become possible via the native Sheets filter functionality by choosing the filter functionality. You can toggle filters on and off using the funnel icon in the Sheets toolbar.  

  1. From the sidebar, select query parameters using the Where and And drop-downs.
  2. Click Load to Sheet.

Best practices:

  • Once your import is complete, click More Filters to learn about using the power of Google Sheets filters to drill down on and make updates to subsets of devices.
  • Whoa! Too many columns to take in? ClickScreen_Shot_2019-04-26_at_2.23.09_PM.png (hamburger icon) in the sidebar to quickly hide columns you don’t need.
Screen_Shot_2019-04-26_at_2.20.29_PM.png

 

Importing devices from a CSV file

Importing devices from a CSV file is ideal for working with exports from a 3rd party asset management system. A valid CSV file for import must contain device Serial Number and may additionally contain Annotated User, Annotated Asset ID, Annotated Location, and Notes data. The column headers in the CSV file must match those shown here in bold. Importing from a CSV file is a multi-step process, in which you will be prompted to preview your import before performing an update.

Once the devices in your CSV file have been successfully looked up on the domain, you can review and modify their settings before updating them.

  1. From the sidebar, click Push Updates to Google.
  2. Click Update from CSV. The stepper appears to walk you through the update.
CSV.png


List of asset IDs or serial number (via copy+paste --OR-- USB scanner)

Importing devices from your clipboard, or a USB barcode scanner can be a very efficient way of performing bulk updates, deprovision, or enable/disable operations on a set of devices whose Asset IDs or SNs live in a document or Sheet, or for physically co-located devices, such as a group of machines in a single laptop cart, or as devices are enrolled during unboxing.

You can use this feature to import and make updates to one or more devices by Serial Number or by asset ID.

  1. From the sidebar, click Import from Google.
  2. In the Load managed devices from… field, select List of IDs.
  3. Place your cursor in the text area and scan a barcode with either device serial number or asset ID, followed by a newline or Enter.
    Note: Most scanners ship with a set of configuration barcodes that can be used to make them auto-insert newlines after each scan.
  4. Once the devices have been imported to the Devices tab, perform your updates in the Sheet.
  5. Click the Update button or use the Disable/re-enable device or Deprovision features.