You can import appointments, tasks, and contact data created in other applications into the groupware.
The following data is supported:
iCal
vCard
CSV
iCal data allows the standardized exchange of calendar data like appointments and tasks. The typical name extension of an iCal file is .ics.
vCard data allows the standardized exchange of contact data in the form of an electronic business card. The typical name extension of a vCard file is .vcf.
CSV data allows the exchange of text data in the form of a table. You can import contact data from a CSV file. The typical name extension is .csv.
A description of all iCal objects can be found in the document RFC2445.
The following table shows which iCal objects are imported in the groupware and which are not. The information in the columns "Appointments" and "Tasks" have the following meaning:
"X" means the object is imported. The object value is set in RFC2445.
A number like "255" means the object is imported. The number indicates the maximum number of characters.
The entry "unlimited" means the object is imported. There is no limit for the maximum number of characters.
The entry "-" means the object is not imported.
Category | iCal object | Appointments | Tasks |
---|---|---|---|
Calendar Properties | CALSCALE | - | - |
METHOD | - | - | |
PRODID | X | X | |
VERSION | X | X | |
Calendar Components | VALARM | X | X |
VEVENT | X | X | |
VFREEBUSY | - | - | |
VJOURNAL | - | - | |
VTIMEZONE | X | X | |
VTODO | X | X | |
Component Properties | ATTACH | - | - |
ATTENDEE | X | X | |
CATEGORIES | X | X | |
CLASS | X | X | |
COMMENT | - | - | |
COMPLETED | - | X | |
CONTACT | - | - | |
CREATED | X | X | |
DESCRIPTION | Unlimited | Unlimited | |
DTEND | X | X | |
DTSTAMP | X | X | |
DTSTART | X | X | |
DUE | X | X | |
DURATION | X | X | |
EXDATE | X | - | |
EXRULE | - | - | |
FREEBUSY | - | - | |
GEO | - | - | |
LAST-MODIFIED | - | - | |
LOCATION | 255 | - | |
ORGANIZER | - | - | |
PERCENT-COMPLETE | - | X | |
PRIORITY | - | X | |
RDATE | - | - | |
RECURRENCE-ID | - | - | |
RELATED-TO | - | - | |
REPEAT | - | - | |
REQUEST-STATUS | - | - | |
RESOURCES | X | - | |
RRULE | X | X | |
SEQUENCE | - | - | |
STATUS | - | X | |
SUMMARY | 255 | 255 | |
TRANSP | - | X | |
TRIGGER | X | X | |
TZID | X | X | |
TZNAME | X | X | |
TZOFFSETFROM | X | X | |
TZOFFSETTO | X | X | |
TZURL | X | X | |
UID | X | X | |
URL | - | - | |
Property Parameters | CUTYPE | X | X |
DELEGATED-FROM | - | - | |
DELEGATED-TO | - | - | |
DIR | - | - | |
ENCODING | X | X | |
FMTTYPE | - | - | |
FBTYPE | - | - | |
LANGUAGE | - | - | |
MEMBER | - | - | |
PARTSTAT | - | - | |
RANGE | - | - | |
RELATED | - | - | |
RELTYPE | - | - | |
ROLE | - | - | |
RSVP | - | - | |
SENT-BY | - | - | |
TZID | X | X | |
VALUE | X | X |
The groupware supports appointments in the form "The last Sunday of a month".
The groupware does not support appointments with days counted from the end of the month ("The second last Sunday of a month", for example). If an appointments includes such information the appointment is not imported.
The groupware does not support alarm repetition. Example: "Remind me four times". If an appointment contains such information the information is ignored.
Note: Make sure the file that is to be imported contains correct iCal data.
Note: You can not import iCal data that you exported from within the groupware under your username.
How to import appointments or tasks in the iCal format:Click the icon in the title bar .
Click on
below in the folder tree. The available options for the import are displayed in the overview window.Select the
file type. Specify the data to be imported:If you want to import appointments select
in the drop-down field.If you want to import tasks select
in the drop-down field.Click on
. Select the target folder for the import.Click on
. Select the file to be imported. Close the file selection dialog window.In order to complete the data import click on the panel entry
.Result: The appointments or tasks are imported into the target folder.
Tip: You can also import appointments or tasks by right-clicking on a calendar or task folder and selecting from the submenu.
Note: Make sure the file that is to be imported contains correct vCard data.
Note: For each contact only one private address and one business address will be imported. If the imported vCard file contains additional private and business addresses, those addresses are being ignored when importing.
How to import contacts in the vCard format:Click the icon in the title bar .
Click on
below the entry in the folder tree. The settings available for the import are displayed in the overview window.Select the file type
.Click on
. Select the target folder for the import.Click on
. Select the file to be imported. Close the file selection dialog window.In order to complete the data import click on the panel entry
.Result: The contacts are imported into the target folder.
Tip: You can also import contacts by right-clicking on a contact folder and selecting from the submenu.
The following CSV files are supported:
Standard CSV files with comma separated values
CSV files from Microsoft Outlook
A standard CSV file contains contacts in the form of a table. The table has the following structure:
The first row contains the headers i.e., the names of the data fields.
Each of the following rows contains the data fields for a contact in the individual columns.
The data fields are comma separated.
The end of the line is indicated by a line wrap.
A CSV file can, for example, be created with spread sheet software or a text editor. When doing so you have to consider the following details.
If there are umlauts in the data fields of the CSV file, they have to be utf-8 encoded.
The first row of the CSV file has to contain at least one of the column titles mentioned below.
The column titles are case sensitive.
The columns can be in any order. The imported data will be assigned to the data fields in the Groupware.
The data fields are separated with commas.
If there are invalid formats in a data field the respective contact will be skipped. The data fields have to have the following format:
All E-Mail fields have to contain the "@" character.
The file can have an empty data field.
If a data field exceeds the number of maximum allowed characters, all characters that exceed the maximum allowed number are removed. The table below shows the maximum allowed number of characters for each data field.
The first row of the CSV file has to contain one or more of the following column headers:
Display name | Sur name | Given name | Middle name |
Suffix | Title | Street home | Postal code home |
City home | State home | Country home | Martial status |
Number of children | Profession | Nickname | Spouse name |
Note | Company | Department | Position |
Room number | Street business | Postal code business | City business |
State business | Country business | Number of employee | Sales volume |
Tax id | Commercial register | Branches | Manager's name |
Assistant's name | Street other | Postal code other | City other |
State other | Country other | Telephone assistant | Telephone business 1 |
Telephone business 2 | FAX business | Telephone car | Telephone company |
Telephone home 1 | Telephone home 2 | FAX home | Cellular telephone 1 |
Cellular telephone 2 | Telephone other | FAX other | Telephone pager |
Telephone telex | Telephone TTY/TDD | Instantmessenger 1 | Instantmessenger 2 |
Telephone IP | Email 1 | Email 2 | Email 3 |
URL | Categories | Dynamic Field 1 | Dynamic Field 2 |
Dynamic Field 3 | Dynamic Field 4 | Dynamic Field 5 | Dynamic Field 6 |
Dynamic Field 7 | Dynamic Field 8 | Dynamic Field 9 | Dynamic Field 10 |
Dynamic Field 11 | Dynamic Field 12 | Dynamic Field 13 | Dynamic Field 14 |
Dynamic Field 15 | Dynamic Field 16 | Dynamic Field 17 | Dynamic Field 18 |
Dynamic Field 19 | Dynamic Field 20 | private | Birthday |
Anniversary |
During the import the data fields of the CSV file will be assigned to certain data fields in the Groupware. The following table shows the contact fields in the Groupware and the fields they are assigned to. The table also shows the maximum number of characters allowed for the data field.
Data fields in the contact dialog window | CSV data field | ||
---|---|---|---|
Tab | Data field | Max. chars | |
General | Title | 64 | Title |
First name | 128 | Given name | |
Middle name | 128 | Middle name | |
Last name | 128 | Sur name | |
Suffix | 64 | Suffix | |
Display name | 64 | Display name | |
Company | 512 | Company | |
Street | 256 | Street business | |
ZIP | 64 | Postal code business | |
City | 128 | City business | |
Country | 64 | Country business | |
State | 64 | State business | |
Department | 128 | Department | |
Position | 128 | Position | |
Room number | 64 | Room number | |
Employee ID | 64 | Number of employee | |
Phone | 64 | Telephone business 1 | |
Phone (2) | 128 | Telephone business 2 | |
Fax | 64 | FAX business | |
Phone (company) | 64 | Telephone company | |
Mobile | 64 | Cellular telephone 1 | |
Phone (Assistant) | 64 | Assistant's phone | |
URL | 128 | URL | |
256 | Email 1 | ||
IM | 64 | Instantmessenger 1 | |
Tags | 1024 | Categories | |
Type | private | ||
Private | Profession | 64 | Profession |
Date of birth | Birthday | ||
Street | 256 | Street home | |
ZIP | 64 | Postal code home | |
City | 64 | City home | |
State | 64 | State home | |
Country | 64 | Country home | |
Nickname | 64 | Nickname | |
Phone | 64 | Telephone home 1 | |
Phone 2 | 64 | Telephone home 2 | |
Fax | 64 | FAX home | |
Mobile | 64 | Cellular telephone 2 | |
IP-phone | 64 | Telephone IP | |
256 | Email 2 | ||
Marital status | 64 | Martial status | |
Anniversary | Anniversary | ||
IM (private) | 64 | Instantmessenger 2 | |
Pager | 64 | Telephone pager | |
Comments | 5680 | Note | |
Additional | Street (other) | 256 | Street other |
ZIP (other) | 64 | Postal code other | |
City (other) | 64 | City other | |
State (other) | 64 | State other | |
Country (other) | 64 | Country other | |
Phone (other) | 64 | Telephone other | |
Fax (other) | 64 | FAX other | |
E-Mail (other) | 256 | Email 3 | |
Phone (car) | 64 | Telephone car | |
TTY/TDD | 64 | Telephone TTY/TDD | |
Sales Volume | 64 | Sales volume | |
TAX ID | 128 | Tax id | |
Commercial Register | 64 | Commercial register | |
Branches | 64 | Branches | |
Manager | 64 | Manager's name | |
Assistant | 64 | Assistant's name | |
Telex | 64 | Telephone telex | |
Spouse's name | 64 | Spouse name | |
Children | 64 | Number of children | |
Optional 1 .. 20 | 64 | Dynamic Field 1 .. 20 |
Select the menu item
.In the dialog window Import/Export Wizard choose the entry
. Click on .Choose the entry
. Click .Select the contact folder to be exported. Click
.Set the name and location for the output file. Click
.To complete the export process click on
. Note: Leave the check box activated. Do not click on . Leave the default assignment unchanged.Result: The new CSV file contains all data fields for the exported contacts.
The following data fields are imported in the Groupware:
Anniversary | Assistant's Name | Assistant's Phone |
Birthday | Business City | Business Country |
Business Fax | Business Phone | Business Phone 2 |
Business Postal Code | Business State | Business Street |
Car Phone | Categories | Children |
Company | Company Main Phone | Department |
E-mail 2 Address | E-mail 3 Address | E-mail Address |
First Name | Home City | Home Country |
Home Fax | Home Phone | Home Phone 2 |
Home Postal Code | Home State | Home Street |
Last Name | Manager's Name | Middle Name |
Mobile Phone | Notes | Organizational ID Number |
Other City | Other Country | Other Fax |
Other Phone | Other Postal Code | Other State |
Other Street | Pager | Profession |
Sensitivity | Spouse | Suffix |
Telex | Title | TTY/TDD Phone |
Web Page |
When importing, the data fields of the MS Outlook CSV file will be assigned to certain data fields in the Groupware. The following table shows the assignment by listing the data fields that are displayed when editing a contact in the Groupware. The table also shows the maximum number of characters for each data field.
Data fields in the Contacts dialog window | MS Outlook CSV data field | ||
---|---|---|---|
Tab | Data field | Max. chars. | |
General | Title | 64 | Title |
First name | 128 | First name | |
Middle name | 128 | Middle name | |
Last name | 128 | Last name | |
Suffix | 64 | Suffix | |
Company | 512 | Company | |
Street | 256 | Business Street | |
ZIP | 64 | Business Postal Code | |
City | 128 | Business City | |
Country | 64 | Business Country | |
State | 64 | Business State | |
Department | 128 | Department | |
Phone | 64 | Business Phone | |
Phone (2) | 128 | Business Phone 2 | |
Fax | 64 | Business Fax | |
Phone (company) | 64 | Company Main Phone | |
Mobile | 64 | Mobile Phone | |
Phone (assistant) | 64 | Assistant's phone | |
URL | 128 | Web Page | |
256 | E-mail Address | ||
Tags | 1024 | Categories | |
Type | Sensitivity | ||
Private | Profession | 64 | Profession |
Date of birth | Birthday | ||
Street | 256 | Home Street | |
ZIP | 64 | Home Postal Code | |
City | 64 | Home City | |
State | 64 | Home State | |
Country | 64 | Home Country | |
Phone | 64 | Home Phone | |
Phone (2 | 64 | Home Phone 2 | |
Fax | 64 | Home Fax | |
256 | E-mail 2 Address | ||
Anniversary | Anniversary | ||
Pager | 64 | Pager | |
Comment | 5680 | Notes | |
Additional | Street (other) | 256 | Other Street |
ZIP (other) | 64 | Other Postal Code | |
City (other) | 64 | Other City | |
State (other) | 64 | Other State | |
Country (other) | 64 | Other Country | |
Phone (other) | 64 | Other Phone | |
Fax (other) | 64 | Other Fax | |
E-Mail (other) | 64 | E-mail 3 Address | |
Phone (car) | 64 | Car Phone | |
TTY/TDD | 64 | TTY/TDD Phone | |
Commercial Register | 64 | Organizational ID Number | |
Manager | 64 | Manager's Name | |
Assistant | 64 | Assistant's Name | |
Telex | 64 | Telex | |
Spouse's name | 64 | Spouse | |
Children | 64 | Children |
Warning: If the data field for an import file exceeds the maximum number of allowed characters or contains invalid data the respective contact will be skipped during the import.
Note: Make sure to use valid import files. Please find some hints on valid import files in 8.3.4.1: What is the structure of a standard CSV file? and 8.3.4.3: How to create an MS Outlook CSV file?. .
Note: When importing an already existing contact, the contact's data is overwritten with the data from the imported file.
To import contacts from a default CSV file or an MS Outlook file proceed as follows:Click the in the title bar .
Click on
below in the folder tree. The import settings are displayed in the overview window.Select
as file type.Select the CSV file format:
If the file contains data in the default CSV format select
.If the file contains data in the MS Outlook CSV format, select
.Click on
. Select the folder for the import.Click on
. Select the file to be imported. Close the file selection dialog.To execute the data import click on the panel entry
.Result: The contacts are imported into the target folder.
Tip: You can also import contacts by right-clicking on a contact folder and selecting from the submenu.