Create a CSV Configuration File

You can create a Comma Separated Values (CSV) file of the agents, dial plan, users, and routing configurations to make maintaining and updating such information easier. After you create the file, you upload it to the Oracle Enterprise Communications Broker (OECB).

In the CSV file format, each row is defined on its own line and each column is separated by a comma. When preparing the CSV file, you must specify each object and operation that you want the OECB to act on. For each object in the .csv file, the first three lines of the file format include the following information:

• object—Specify the object you want the OECB to act on. Valid values: Agents, Dial Plan, Users, and Routing.
• operation—Specify the operation to perform. Valid values: ADD, MODIFY, or DELETE. If you do not specify an operation, the system defaults to ADD-MODIFY.
• parameters—A system provided list of all of the parameters for the object. The system can perform the specified operation on any of the parameters listed.

To create a CSV file that contains system configuration, do the following:

1. Open an application that supports a CSV file.
2. In the first row, first column, enter “object:” followed by a configuration object you want to import.object:sip-interface
3. In the second row, enter the operation to perform. operation:ADD.
4. In the third row, and each in its own column, enter the parameter names of the objects to be configured. state,realm-id,descriptionstate,realm-id,description.
5. In the fourth row, and each in its own column, enter the instances (values) for the configuration objects.enabled,public,public SIP interface.
6. In subsequent rows, define additional instances (values), as needed.
7. In the next empty row, first column, enter another object if needed, related to the first object (sip-interface).object:sip-port.
8. Repeat steps 3 through 6 for this object.
9. Save the file as a .csv.
10. Upload the configuration file using the upload button from the applicable dialog. (For example, upload a .csv file of users from the User database.)

• After you create the initial CSV configuration file, you can set the OECB to automatically upload updated versions of the file. See "Automatically Upload Updated CSV Configuration Files" and "Configure Automatic CSV File Uploads."