View source for Restrictions on importing data

There are [[:Category:Import|several ways to import data into Open-Xchange]], but all are restricted by the fact that OX uses a SQL database to store data about its core elements (contacts, appointments and tasks). That means that the field size is limited.

Note: The fields have been sized generously while still having efficient row sizes for fast SQL queries. If you encounter a problem, it usually lies with generic fields like "description" or "comment", which some other programs use to store vast amounts of data (for example a VCard representation of the same contact you just imported).

If there is such a problem, one out of several possibilities might occur:
* If your database is set to automatically truncate data, the content will be cut off at that part.
* If your database is not set for automatic truncation, the JDBC driver will throw a TruncationException.
** If your OX is set to automatically truncate, it will do so, though a bit less elegant than the database (because there is less information to go with): All problematic fields will be truncated one after the other, each change triggering a new attempt to store it, until either the data fits the database or the attempts are used up.
** If your OX is not set to truncate, it will simply fail.

To determine whether data fits the database, the size of the database fields can be used. But two things should be kept in mind: Depending on the character set used, a character can take up more than one byte. The default character set used it a 3-byte UTF8 set. Chinese installations, for example, might use a set that takes up more bytes per character or not even UTF8 at all. Also, some installations have used different field sizes for reasons ranging from performance to missing updates (though updates to database tables are really rare).

Now you have been sufficiently warned: What follows is the data of a typical default installation. Yours might vary.

{{UnderConstruction}}

[[Category: OX6]]
[[Category: Import]]
[[Category: Overview]]