Address Book

[dmaravankin]

How can I upload a csv file to create a new Address book in IPOCC?
Thanks!

[marquardt]

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.

[bucky101]

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

I take it I need to manually install the driver first?

[bucky101]

It worked using the Microsoft ODBC and using the csv driver

[marquardt]

The driver is default for JDBC-Connection

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