Using the import servlet: Difference between revisions

From Open-Xchange
m (added categories)
(added info about the date format)
Line 1: Line 1:
== Basics ==
There are two things to do with the import servlet:
There are two things to do with the import servlet:


Line 6: Line 7:
** Example: ''Currently, the CSV format can only be used to import contacts. You can extend it to import appointments''.
** Example: ''Currently, the CSV format can only be used to import contacts. You can extend it to import appointments''.


Importing data using existing importers is done using the API, as explained in [[HTTP API#Module_.22import.22 | HTTP API]].
== Details ==
A collection of details about the importer
=== Date formats in CSV files===
While the date formats of both iCal and vCard are pretty clear, csv can be defined freely (insert "of course" or "sadly" as you like).
Microsoft Outlook does as it likes:
* the German version uses DD.MM.YYYY
* the English version uses MM-DD-YYYY


Importing data using existing importers is done using the API, as explained in [[HTTP API#Module_.22import.22 | HTTP API]].
Our own format uses the timestamp format. Advantage: You can use hours and minutes. Disadvantage: You'll have to use negative numbers for dates before 1-1-1970.
 
Information for developers: The date format interpreters are build to be exchangeable, you can use your own format there.


== Other ==
Adding a new importer is explained in [[Building an importer]].
Adding a new importer is explained in [[Building an importer]].



Revision as of 11:34, 31 October 2007

Basics

There are two things to do with the import servlet:

  • You can use it to import data into OX: Hyperion
    • Example: Importing your Outlook data by exporting it as CSV and then importing it.
  • you can extend it to import new formats
    • Example: Currently, the CSV format can only be used to import contacts. You can extend it to import appointments.

Importing data using existing importers is done using the API, as explained in HTTP API.

Details

A collection of details about the importer

Date formats in CSV files

While the date formats of both iCal and vCard are pretty clear, csv can be defined freely (insert "of course" or "sadly" as you like).

Microsoft Outlook does as it likes:

  • the German version uses DD.MM.YYYY
  • the English version uses MM-DD-YYYY

Our own format uses the timestamp format. Advantage: You can use hours and minutes. Disadvantage: You'll have to use negative numbers for dates before 1-1-1970.

Information for developers: The date format interpreters are build to be exchangeable, you can use your own format there.

Other

Adding a new importer is explained in Building an importer.

See also: Using the export servlet.