Uploading a CSV File Using Inventory Preload

Jamf Pro Documentation 11.16.0
Solution
Application
Content Type
Technical Documentation
Utilities & Services
version
11.16.0
ft:locale
en-US
vrm_version
11.16.0
Requirements

To upload a CSV file, you need:

  • A Jamf Pro user account with all privileges for Inventory Preload Records

  • A Jamf Pro user account with Create and Update privileges for Users

For more information, see Jamf Pro User Accounts and Groups.

  1. In Jamf Pro, click Settings in the sidebar.
  2. In the Global section, click Inventory preload .
  3. To download a CSV file template and prepare the data, click Template .
  4. If your browser prompts you to allow downloads, click Allow.
  5. Prepare the downloaded CSV file using an editor of your choice.
    Important:

    If you edit the CSV file using Microsoft Excel on Windows, you must save the file using the file type, "CSV UTF-8 (Comma delimited)(*.csv)". If you saved the CSV file as an XLSX file, you can convert the file to "CSV UTF-8 (Comma delimited)(*.csv)" by saving the file as a different file type. However, data may be lost depending on how the data was formatted.

  6. After you have prepared your CSV file, click File Upload in Jamf Pro.
  7. Drag or browse for your CSV file in the Upload Resource File dialog.

    The CSV file will be validated in the dialog before the data is uploaded.

    1. If the file is valid, a confirmation message is displayed.
    2. If the file is invalid, a list of issues is displayed. Correct the issues, click Close, and then try uploading the file again.
  8. Click Upload to upload the data.
    Important:

    New data will overwrite existing data for CSV rows that have matching Serial Numbers.