|
The Import command loads XML or CSV (comma-separated-value) files into the call list, contact list, or action list, depending on the option selected.
You will be prompted to specify the name and location of the file to import.
Use this command to transfer the lists from another program, or another copy of Ascendis Caller ID (XML format only).
Please note the following:
| • | When importing calls, existing calls will be ignored, not replaced. Ascendis Caller ID examines the RawNumber and CallBegan fields to determine whether a call matches. |
| • | When importing contacts, a warning will be shown if a contact already exists in the list. The imported contact will be ignored. Also, Ascendis Caller ID will try to map similar column names to the column names it uses. |
| • | When importing actions, a warning will be shown if an action already exists in the list. The imported action will be ignored. |
CSV Format
Details about the Calls CSV format can be found under Calls CSV Format.
To determine the best format for the import file, export the corresponding list from Ascendis Caller ID, and examine it. Here are some specifics:
| • | The first row must contain the names of the columns. |
| • | All subsequent rows contain data to import. |
| • | Values (or header names) containing commas must be contained within double quotes since commas are used to separate values. |
| • | Embedded double quotes must be replaced with '\"' (see contacts.csv, below, for sample). |
| • | Newlines in scripts must be replaced with '\n' (see contacts.csv, below, for sample). |
XML Format
The XML formats are intended for Ascendis Caller ID use. We recommend using CSV if you want to get data into Ascendis Caller ID from other programs. If you wish to know the details of the XML format, please export to XML and examine the file.
Sample contacts.csv:
"FirstName","LastName","DisplayName","SpeakName","Company","Address","City","County","State","PostalCode","Country","Email","Extra","Label","Custom1","Custom2","Custom3","Custom4","DisplayNumber","RawNumber","RawName","Description","FirstCalled","LastCalled","CallsReceived","CallsMade","ActionName"
"No Caller","Information","No Caller Information","No Caller Information","","","","","","","","","","","","","","","","","","","","06/28/2007 8:51:28 AM",2,0,"No Caller Information"
"Scott","Swanson","Scott Swanson","Scott Swanson","Swanson Consulting","101 Main St.","Springfield","","IL","62701","USA","scott@swansonconsulting.com","","","","","","","(217) 555-1213","2175551213","SWANSON, SCOTT","Work","06/27/2007 11:08:35 AM","06/27/2007 11:08:35 AM",0,1,"Default"
"Scott","Swanson","Scott Swanson","Scott Swanson","Swanson Consulting","101 Main St.","Springfield","","IL","62701","USA","scott@swansonconsulting.com","","","","","","","(217) 555-1214","2175551214","SWANSON, SCOTT","Home","","",0,,"Default"
Sample actions.csv:
"ActionName","ActionTypeName","SimpleScript","Script","Notes","Modified"
"Anonymous","Easy","//hangup;\n//sound \"\";\n//run \"\";\n//sendmail \"\" \"\" \"Call from {Name} at {Number}\" \"\";\nspeak \"The caller is anonymous\";\n","","",""
"Block","Easy","hangup;\n//sound \"\";\n//run \"\";\n//sendmail \"\" \"\" \"Call from {Name} at {Number}\" \"\";\n//speak \"Call from {Name}\";\n","","","09/21/2006 7:36:48 PM"
Use the Export command to export files from Ascendis Caller ID.
|
