<< Click to Display Table of Contents >> ImportCustomFields |
Imports custom field values for computers from a CSV file. The CSV must contain a column that identifies each computer and one or more columns for the custom field values to import.
NOTE: This command requires a PDQ Inventory Enterprise license. Custom fields must already exist before importing. Use CreateCustomField to create them first.
PDQInventory ImportCustomFields <filename> [-AllowOverwrite] [-ComputerColumn <header>] [-CustomFields <mappings>] [-NoHeader] [-Preview] [-WhatIf]
Parameter |
Required |
Description |
|---|---|---|
<filename> |
Yes |
Path to the CSV file to import. |
-AllowOverwrite |
No |
Overwrites existing custom field values. Without this flag, existing values are preserved. |
-ComputerColumn <header> |
No |
The CSV column header that contains computer names. Required when the CSV has multiple columns and PDQ Inventory cannot auto-detect which column holds computer names. |
-CustomFields <mappings> |
No |
A comma-delimited list of CSV Header=Custom Field mappings. Used when CSV column names do not match custom field names exactly. For headerless CSVs, use column numbers: 2=Department,3=Location. |
-NoHeader |
No |
Indicates the CSV file has no header row. Columns are referenced by number when using -CustomFields. |
-Preview |
No |
Shows which computers in the CSV were not found in PDQ Inventory and lists any column parsing errors, without saving any data. |
-WhatIf |
No |
Equivalent to -Preview. Shows unmatched computers and column parsing errors without saving any data. |
Preview an import to check for unmatched computers:
PDQInventory ImportCustomFields C:\data\departments.csv -Preview
Import using a specific computer column header and overwrite existing values:
PDQInventory ImportCustomFields C:\data\departments.csv -ComputerColumn "PC Name" -AllowOverwrite
Import with explicit column-to-field mappings:
PDQInventory ImportCustomFields C:\data\data.csv -ComputerColumn "Computer" -CustomFields "Dept=Department,Loc=Location"
© 2026 PDQ.com Corporation. All rights reserved.
PDQ.com is a trademark of PDQ.com Corporation. All other product and company names are the property of their respective owners.
Help Version: 20.0.22.0