Skip to main content

Upload Devices and/or Data

What

Mass import devices/data from a CSV

The upload option (0qO882VCL2PBvIto-embedded-image-ubdt7qxx.png) allows en masse import of devices and/or field data, and allows you to specify additional import actions.

When/Why

You would use this option any time you need to create a lot of placeholders at once or if you need to update data fields for a large number of devices.  For instance, if my asset management system had given me data in a csv linking device serial number to a physical asset tag number, then I might use this tool to upload that asset tag information into FileWave.

How

    From the View - Devices  Press the upload icon (

    d9pvZUjb004YXmja-embedded-image-cnqiixdq.png

    )

      This takes you to the Import File tool Select your txt/csv file and move to Map Fields In Map Fields, match the fields you want to import to FileWave fields In Actions, define other options

      Import File tool

      This window will allow us to import a large amount of data from a CSV source.

      We'll use this method whenever we have a large number of new device placeholders to enter or whenever we want to update fields for existing devices. 

        For instance, we may have a spreadsheet from a hardware vendor sharing details of 100 new laptops we'll be receiving next week which includes Mac Addresses and Asset Tag information.  With placeholders imported for these new devices, we could image them immediately out of the box. Alternatively, we may already have the devices enrolled in FileWave, but perhaps our property management folks have given us a spreadsheet that has serial numbers and associated physical asset tag information.  We could use this tool to import that asset tag information into FileWave for quick reference.

        How

        To import a file, we will:

          Create a CSV/TXT with a header row, followed by a row for each device 
          "Serial Number","OS Type","Device Name",comment,location,asset_tag
C02WP0hgHTDF,macOS,"HR-John-MBP","John's laptop","north site","123456"
ABC456123DEF,iOS,"ThatsABeautClark ","no comment","Normal, IL","651241"
215487958754,Windows,"PR-Sal-1258","that other device","south site","654321"

          The data can be in pretty much any order, but it must include at minimum a device name, and an OS Type.

            Browse for the file with the Browse Button (Z4bjEkBnOiEWDMjZ-embedded-image-rpwuunlf.png) Preview your upload and continue to the Map Fields 

            Map Fields

            Connect CSV columns with FileWave inventory fields

            Here is where you match up the columns heading with existing FileWave Inventory Fields.

            How

            From the Actions Tab

              From the dropdown Pick the appropriate FileWave inventory that matches your column head Continue onto the Actions tab next

              Back to top