Avaya Support Forums  

Go Back   Avaya Support Forums > IP Office Contact Center

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-11-2014, 09:34 PM
dmaravankin dmaravankin is offline
Member
.
 
Join Date: Sep 2014
Posts: 4
dmaravankin has 10 reputation points
Default Address Book

How can I upload a csv file to create a new Address book in IPOCC?
Thanks!
Reply With Quote
  #2  
Old 12-11-2014, 10:25 PM
marquardt marquardt is offline
Guru
.
 
Join Date: May 2014
Location: Stuttgart - Germany
Posts: 190
marquardt has 14 reputation pointsmarquardt has 14 reputation points
Default CSV file import for Addressbook

Note that as default the CSV file uses commas as separators.
You can change the settings of the driver. Additional information see:
http://csvjdbc.sourceforge.net/doc.html
When you access to a network drive, the service have to work with the appropriate permissions.

JDBC driver -> Specifies the JDBC driver.
The address book server installation provides a JDBC driver for the CSV (csvjdbc-1.0-18.jar). For this reason, it is sufficient to specify the driver for a JDBC import.
org.relique.jdbc.csv.CsvDriver


DB URL ->Specifies the database URL (AccountURL).
jdbc:relique:csv:<FolderPath>
<Folderpath> Folderpath without file name

Example:
jdbc:relique:csv:c:\addressbook
Example with separator semicolon
jdbc:relique:csv:c:\addressbook?separator=;


DB user->empty

DB password ->empty

DB table -> Shows the database table name.
Reply With Quote
  #3  
Old 12-18-2014, 02:35 PM
bucky101 bucky101 is offline
Brainiac
 
Join Date: Nov 2010
Posts: 70
bucky101 has 11 reputation points
Default

I am getting 'cannot load database driver! - org.relique.jdbc.csv.CsvDriver'

I take it I need to manually install the driver first?
Reply With Quote
  #4  
Old 01-14-2015, 06:45 PM
bucky101 bucky101 is offline
Brainiac
 
Join Date: Nov 2010
Posts: 70
bucky101 has 11 reputation points
Default

It worked using the Microsoft ODBC and using the csv driver
Reply With Quote
  #5  
Old 01-15-2015, 05:25 AM
marquardt marquardt is offline
Guru
.
 
Join Date: May 2014
Location: Stuttgart - Germany
Posts: 190
marquardt has 14 reputation pointsmarquardt has 14 reputation points
Default The driver is default for JDBC-Connection

The driver is a default setting for a new address book - external (JDBC)
Reply With Quote
Reply

Tags
address book, ipocc

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 04:12 PM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.