CSV files for Server Hardware fails to upload with vRealize Business for Cloud

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:
vRealize Business will reject the .csv file when you attempt to upload it. This is for quick entry of server costing into vRealize Business.

Environment

VMware vRealize Business for Cloud Advanced 7.x

Cause

vRealize Business for Cloud does need the file in a specific format. If there is any white space, or commas, in the CSV the upload will fail.

Resolution

The correct header for the CSV file is as follows:

serverModelName,manufacturer,numCpus,cpuType,cpuGhz,memGb,numberOfServers,dateOfPurchase,pricePerServer,batchType,dataCenterName
 

dataCenterName is optional. If there is a comma in any field, for example: "Server Manufacturer, Model1", the field in the CSV should be as follows:

"ServerManufacturer,Model1"

Any white space inbetween fields, or between words themselves, will cause the CSV to fail importing into vRealize Business.