Preparing the part numbers file

The part numbers file can be used to increase the accuracy of bundling assistant by narrowing the number of possible products to which a discovered component can be assigned. You can download the file from Passport Advantage® or create it manually.

About this task

If you added custom part numbers to the software catalog, make sure that they are included in the part numbers file. Otherwise, the custom part numbers are not matched against the uploaded part numbers and are not used during bundling assistance.
Restriction: BigFix Inventory supports only CR LF and LF end of line characters. While editing the part number file do not use CR end of line characters specific for Mac systems.
Downloading the file with part numbers from Passport Advantage®

Procedure

  1. Download the part numbers file from Passport Advantage.
    1. Log in to Passport Advantage®.
    2. From the menu on the top, select Reporting > Order history.
    3. If applicable, select the relevant site or sites.
    4. In the Type of order section, select All.
    5. Specify the Sales order date and Sort by. Then, click Submit detail report. Your report is ready.
    6. To save the file, click Download report and then select Comma delimited. Ensure that the file is in the CSV or ZIP format.
      Important: If you are not able to download part numbers, you might not have the required permissions on Passport Advantage.
  2. If you do not have custom part numbers, create a CSV file that contains a single column without a header. This file can only contain Passport Advantage part numbers, not your custom part numbers. List each part number in a new line. Do not use quotation marks (" ") to define part numbers.
    Example:
    D07UMLL
D08UMLL
D09UMLL
  3. If you have custom part numbers that are not available on Passport Advantage, add them to the downloaded file. Ensure that the edited file meets the following requirements:
    1. The file contains two mandatory columns: Part number and Order type. Only the rows that contain the Licenses element in the Order type column are imported. The list of part numbers can include Passport Advantage® part numbers, as well as your custom part numbers. You can add any other columns to the file, however, these columns are ignored during upload. Use a comma as a field separator and quotation marks (" ") as a text delimiter.
    2. Part numbers that should be imported to BigFix Inventory must have the value "Licenses" in the Order type column. Rows with other values are skipped.
    Example
    "Part number", "Order type"
"D07UMLL", "Licenses"
"D08UMLL", "Licenses"
"Custom part number", "Licenses"

What to do next

After you prepare the file, upload the part numbers.