How to import devices using CSV file in BCM?
How to Use Device Import in BMC Client Management?

To import the CSV file with data, BCM allows only CSV comma delimited format. CSV comma delimited CSV can be created using MS Excel or Notepad++ or follow Step 1 for best compatibility.


Step 1: Copy the 'import_sample_inv.xls' file from the following location on the Master server and prepare CSV file to import.
            C:\Program Files\BMC Software\Client Management\Master\data\Vision64Database\import

• How To sheet has the list of expected values against the respective fields that can be imported in BCM along with their description.
  
  

• The data sheet has the columns that need to be updated to import the devices in BCM.

  • Create a new Excel spreadsheet file and copy the columns from Datasheet and paste them in to newly created spreadsheet. So, only have 1 sheet in the spreadsheet with the columns as headings.

Note:

• DeviceName should be the first column and it is a mandatory field for the import.

• Remove the unwanted columns as per the requirement.

• Save the file with CSV (Comma delimited *.csv) format.

Step 2: Import the CSV file into a Device Group

• Login to the BCM console and go to the Device Groups node

• Create a new device group and type the appropriate  name as per the requirements

• Right-click on the newly created device group and click 'Import Devices'

• Browse to the location of the saved CSV file. Select it and click Open.

• The source and destination columns will be mapped automatically. Click OK to proceed with Import.

• On the next screen, select 'Create not Existing Devices'. This will create new devices as per the list if it's already not in BCM.

• Click OK

• The device group will show the imported devices as soon as the import is completed.