The Calls list can be exported to CSV files.  The file will look something like this:

Sample version 2 calls.csv:

"CallBegan","CallEnded","CallDuration","DisplayName","DisplayNumber","FirstName","LastName","SpeakName","RawName","RawNumber","Description","Company","Address","City","County","State","PostalCode","Country","Email","Priority","Rings","New","Notes","DeviceName","DisplayLine","ServerName","IncomingCall","AddressID","RingType","ActionName"

"06/28/2007 2:14:52 PM","06/28/2007 2:22:43 PM","00:07:51","Shannon Dwyer","(419) 555-0911","Shannon","Dwyer","Shannon Dwyer","PCS Phone    OH","4195550911","Mobile","","","","","","","","",,2,"True","","Whozz Calling?","Home","DELL","True",1,"","Default"

"06/28/2007 10:48:03 AM","06/28/2007 10:55:04 AM","00:07:01","Victoria Baenor","(801) 555-0872","Victoria","Baenor","Victoria Baenor","COLONIAL MORTGA","8015550872","Work","Colonial Mortgage","25 S. Fifth\nSuite 220","Midland","","UT","84128","USA","vbaenor@colonialmortgage.com",,3,"True","","Whozz Calling?","Business","DELL","True",2,"","Default"

CSV Files exported from Ascendis Caller ID can also be imported into Ascendis Caller ID, but this is not the preferred method for transferring data between machines running Ascendis Caller ID.  In fact, if calls are exported as CSV and then imported, some information will be lost.  See Importing and Exporting for help choosing the best format for the task at hand.

Ascendis Caller ID can read Calls CSV files created in Ascendis Caller ID version 1.  These look something like this:

Sample version 1 calls.csv:

"TimeStamp","Line","RawName","RawNumber","Rings","New"

"11/8/2003 11:40:35 AM","0","MOSS,CARRIE-ANNE","6045551010",2,"True"

"11/8/2003 9:11:20 AM","0","Blocked","Blocked",2,"True"

"11/8/2003 8:43:14 AM","0","APPLIED,BIOMATH","5165554046",4,"False"

"11/5/2003 8:05:57 PM","0","MINNESOTA","6515551065",2,"False"

"11/4/2003 6:28:39 PM","0","APPLIED,BIOMATH","5165554351",4,"False"

"11/4/2003 11:26:19 AM","0","CHRISTY,JIM","5615557353",4,"False"

"11/3/2003 12:52:47 PM","0","Out of Area","Out of Area",2,"False"

"11/3/2003 12:04:27 AM","0","HAMILTON,LINDA","4105557248",2,"False"

"11/1/2003 11:47:33 AM","0","HANSON,ERIC","2485552562",2,"False"

"11/1/2003 11:32:22 AM","0","APPLIED,BIOMATH","5165554046",2,"False"

"11/1/2003 10:34:03 AM","0","MICHIGAN","8105559918",2,"False"

"11/1/2003 10:01:16 AM","0","ROOT,WILLIAM","5165557248",2,"False"

Ascendis Caller ID can also read CSV files created by other programs, or by hand.  The supported field names are:

CallBegan

CallEnded

DisplayName

DisplayNumber

FirstName

LastName

SpeakName

RawName

RawNumber

Description

Address

City

County

State

PostalCode

Country

Rings

New

Notes

DeviceName

DisplayLine

ServerName

IncomingCall

AddressID

RingType

Notes

When importing CSV call files created by Ascendis Caller ID, some fields will be ignored after a warning to this effect.  In general the ignored fields are redundant or are stored elsewhere (such as the Contact list) and were included in the export only for convenience when using other programs. CallDuration is one of those fields.  Internally, CallDuration is computed as the difference between the CallEnded and CallBegan fields.

To import calls from a source other than Ascendis Caller ID that exports a CallDuration column, you will need to convert the data to use a CallEnded field instead.  As an example, assume you have a source of call data from another program named MyCallData that exports to CSV, but contains a CallDuration column instead of a CallEnded column:

We recommend using the same computer or at least the same date & time formats on the computers used for creating the CSV file, running Excel (or another spreadsheet program), and importing using Ascendis Caller ID.  If different date & time formats are used, additional conversion steps may be necessary.

In Excel, you may need to change the date & time format for the CallBegan and CallEnded columns to include the seconds to avoid Excel dropping them from the exported CSV file.