Bulk provisioning Webex Calling elements using CSV

Webex Calling is capable of exporting and importing provision-able elements to the cloud by leveraged Comma Separated Value (CSV) files. A Webex Calling user can import a file that contains field values and specify whether the associated elements should be created, updated, or deleted based on the values entered in the file.

The conventions for uploading CSV files are as follows:

• A CSV file consists of a series of lines that correspond to each individual record in the database. There is a comma (,) between fields within each line of the file. For example, if a field has a value of “Smith, Barney, and Weston,” then that field will be encoded as “Smith/, Barney/, and Weston/,” for example, and if it has a value of “Smith, Barney, and Weston,” then you need to use a backslash (/) to escape commas within fields.

• There are a number of columns in a CSV file, so the first row is a header row which contains the field names for all of the subsequent data rows in the CSV file. Based on the order of the fields and the number of fields, it can be used as a starting point. There will be an error that will appear if there is more than one field in a row.

• Blank fields (those not included in the form) will be ignored by the system.

• You can remove a setting by entering REMOVE in the column next to the setting you wish to remove.

• The mandatory fields must be filled in with each record if the field is mandatory. A record that is not included in this list will be considered as erroneous if it is not included.

• An identity field (also known as an identification field) is a field that is designated as an identity (ID) field. It is impossible to modify identity fields and they stay that way for the life of the record in question. There is a high probability that the record will be flagged for error if you attempt to change an identity field, as the system would not be able to identify the record with an incorrect ID field when you attempt to change the identity field.

• Unicode characters are supported in CSV files.

• The import of CSV files is limited to numbers that are E.164 compliant.

  When a CSV file is opened in a spreadsheet editor such as Excel, the + sign is removed from the cells. The best way to update your CSV file is to use a text editor. Please note that in a spreadsheet editor, when you choose the cell format to text, the + sign is removed from all cells. If this happens, please be sure to add back the + sign.