| 1 |
NAME |
| 2 |
Torus |
| 3 |
|
| 4 |
DESCRIPTION |
| 5 |
Torus is a module to ease migration from Outlook. |
| 6 |
|
| 7 |
Torus uses CPAN's Win32::OLE to access Microsoft's MAPI locally and |
| 8 |
CPAN's Net::LDAP to connect to a remote OpenLDAP-server (slapd). |
| 9 |
|
| 10 |
Access to these storage-implementations is wrapped via Data::Storage. |
| 11 |
Core functionality of Torus is currently provided from Data::Transfer::Sync. |
| 12 |
|
| 13 |
We are starting with Contacts/Adresses, will go along with Messages, |
| 14 |
Calendar-Items and Journaling-Features. |
| 15 |
The "rest" should be able to be modeled and implemented on top of this. |
| 16 |
|
| 17 |
This is more a reference implementation than anything actually useful. ;-) |
| 18 |
You'll also like to take a look at: |
| 19 |
- Kroupware Project: http://kroupware.kde.org |
| 20 |
- Outlook Connector Project: http://otlkcon.sourceforge.net |
| 21 |
- bynari InsightConnector: http://bynari.net/index.php?id=7 |
| 22 |
|
| 23 |
NEWS |
| 24 |
2003-01-18 - initial check-in |
| 25 |
REQUIREMENTS |
| 26 |
Win32::OLE |
| 27 |
Net::LDAP |
| 28 |
Data::Storage |
| 29 |
Data::Transfer::Sync |
| 30 |
... and all their dependencies |
| 31 |
|
| 32 |
AUTHORS / COPYRIGHT |
| 33 |
The Torus module is Copyright (c) 2002-2004 Andreas Motl. |
| 34 |
All rights reserved. |
| 35 |
Mail to <andreas.motl (at) ilo.de> for improvements and suggestions. |
| 36 |
|
| 37 |
You may distribute it under the terms of either the GNU General Public |
| 38 |
License or the Artistic License, as specified in the Perl README file. |
| 39 |
|
| 40 |
CONTRIBUTORS |
| 41 |
Jan Hoffmann <janosch (at) netfrag.org> |
| 42 |
Sebastian Utz <su (at) rotamente.com> |
| 43 |
|
| 44 |
SUPPORT / WARRANTY |
| 45 |
The Torus module is free software. IT COMES WITHOUT WARRANTY OF ANY KIND. |
| 46 |
|
| 47 |
BUGS |
| 48 |
TODO-SHOWSTOPPER |
| 49 |
o sync items from ldap back to outlook |
| 50 |
|
| 51 |
TODO |
| 52 |
- outlook2ldap - essential modules: |
| 53 |
- Net::LDAP |
| 54 |
- Convert::ASN1 / BER1 |
| 55 |
- Unicode::String |
| 56 |
- MIME::Base64 |
| 57 |
o use setup.pm with autoinstall, use ExtUtils::MakeMaker and/or h2xs |
| 58 |
o enhance mapping through expressions |
| 59 |
o provide multiple use of same fields |
| 60 |
o provide mechanism to concatenate fields |
| 61 |
--> see etc/_future! |
| 62 |
o make integrated setup |
| 63 |
o provide gui(s) |
| 64 |
o development (create mappings and stuff (testing, ...)) |
| 65 |
o productive use (control sync-processing at a central console) |
| 66 |
o little hotsync-button (iconbar bottom-right) which provides some actions and some configuration-settings (put ACLs on these settings?) |
| 67 |
o move libs/Torus to nfo-modules, exclude various metadata needed to actually sync with ldap and mappings (csv-files) |
| 68 |
o provide example to sync with mysql/Tangram/mbox/... |
| 69 |
o integrate genSchema.pl |
| 70 |
o regeln: |
| 71 |
o 3.spalte in outlook_ole_fields.csv: für "genSchema.pl" |
| 72 |
o wenn 2.spalte und/oder 3. leer, dann wird kein mapping gemacht (genSchema sowieso nicht) |
| 73 |
--> see etc/_future! |
| 74 |
o daten "rückwärts" übertragen! |
| 75 |
o mapping aufbohren (csv -> xml) - integrate "schema"-property _per-field_!!! |
| 76 |
o have the engine use this |
| 77 |
o maybe provide cross-checks |
| 78 |
--> see etc/_future! |
| 79 |
o transfer statistics |
| 80 |
o zugriff auf outlook (2002) ohne rückfrage gewähren? |
| 81 |
o v.a. wichtig, wenn integrierter zugriff (z.b. durch outlook-plugin) stattfindet |
| 82 |
+ verwenden _aller_ attribute, die mit einem address-eintrag assoziiert sein können? |
| 83 |
+ mileage (reisekilometer) kommt! |
| 84 |
+ bis dato unbekannte mapi-felder sollten nun auch verwendet werden können |
| 85 |
o declare folder-mapping inside xml-file |
| 86 |
o check-before-delete doesn't seem to work (again!) |
| 87 |
o make basedn configurable |
| 88 |
o introduce host-to-basedn-mapping |
| 89 |
o provide additional fallback basedn |
| 90 |
o maybe additional permissions for folder-autocreation |
| 91 |
o rework regexes in Torus::Driver::ldap |
| 92 |
o spaces in ou's? |
| 93 |
o utf8-encoding for dn's in ou's |
| 94 |
o also in other property-names (besides the attributes)?! |
| 95 |
o ä, ö, ü |
| 96 |
o Insight: |
| 97 |
o cclient.dll |
| 98 |
o InsightConnector.dll |
| 99 |
o folder-mapping |
| 100 |
o leerzeichen (non-word-chars) do not work inside foldernames |
| 101 |
o regex fails: |
| 102 |
o introduce some "highlevel-splitting" of ldap-addresses |
| 103 |
o fix problems occoured 2003-01-06/07 @barschwaechter: rules, access to mapi, etc. (see email) |
| 104 |
o do a _true_ sync! (no delete/add) |
| 105 |
o handle folder-mapping/-creation completely _before_ continuing with single entries |
| 106 |
o create non-existant and stuff.... |
| 107 |
o timestamp log-entries |
| 108 |
o add fieldname-context to ldap_errors.log |
| 109 |
o regeln für cn/dn - build |
| 110 |
o wenn "sn" gesetzt, dann nimm "sn" als "cn" |
| 111 |
o wenn "givenname" gesetzt, dann füge zu "cn" hinzu (bisheriger "build"-Vorgang) |
| 112 |
o wenn "sn" leer, dann nimm stattdessen "FileAs" als "cn" und ab [Debug Level=1]info |
| 113 |
o wenn "FileAs" leer, dann nimm stattdessen "FirstName" und ab [Debug Level=1]info |
| 114 |
o wenn "FirstName" leer, dann nimm stattdessen "CompanyName" und ab [Debug Level=1]info |
| 115 |
else ab [Debug Level=1] Warn: |
| 116 |
"Couldn't build DN/CN cause neighter SN/FileAs/FirstName/CompanyName does exist." (Should not happen). |
| 117 |
o collision checks!!! |
| 118 |
o convert date-fields |
| 119 |
o detect must-not-have characters in dn: |
| 120 |
+ replace "+" through "&" |
| 121 |
o replace "," through "" [Kill] |
| 122 |
o replace "ô" through "" [to UTF8] |
| 123 |
o enhance mechanisms to talk to OLE: |
| 124 |
o use "->EnumAllObjects" |
| 125 |
o use "->FreeUnusedLibraries" |
| 126 |
o use "->LastError" |
| 127 |
o encode "dn" with utf8 |
| 128 |
o "member" is empty!!! |
| 129 |
o free resources while processing |
| 130 |
o Outlook (OLE) |
| 131 |
o Perl (Variables, Objects) |
| 132 |
o LDAP-Server (Handle) |
| 133 |
|
| 134 |
o for Horde: |
| 135 |
o helper: some kinda "genSchema.pl" |
| 136 |
o app: LDAP-Browser |
| 137 |
|
| 138 |
o split 'syncOutlookContacts.ini' into 'torus.ini' and 'outlook2ldap.ini' |
| 139 |
o 'syncOutlookContacts.pl' reads 'outlook2ldap.ini' and runs 'feed.pl' |
| 140 |
|
| 141 |
o check howto handle outlook-profile logon |
| 142 |
o mode to transfer all items in bunch |
| 143 |
o use a news- (nntp) server to (maybe) mimic journalling-functionality |
| 144 |
|
| 145 |
IDEAS |
| 146 |
o acl based permissions (use Data::ACL?) |
| 147 |
o combine Torus::Xyz with Device::Xyz somehow? |
| 148 |
o assure published stuff contains no client-specific informations (HMI, ...) |
| 149 |
o CPAN's AppConfig is still needed for now (could this be changed? e.g. using App::Config?) |
| 150 |
o if not, just include it below "libs" or install "nmake" (through integrated setup) before configuring CPAN |
| 151 |
(if you already have, do "perl -MCPAN -eshell" and "o conf init" to redo configuration) |
| 152 |
o rework folder-mapping to use xml |
| 153 |
o rework field-mapping to use xml (Data::Transfer::Sync!) |
| 154 |
o rework declaration of while-transfer-rules and after-transfer-patches to xml |
| 155 |
o example of a "while-transfer-rule" |
| 156 |
o build "dn" from "cn/sn" |
| 157 |
o must have "sn" |
| 158 |
o if no "sn" given, just use "Vorname" |
| 159 |
o don't allow some special characters inside "dn": '+' seems to get translated to '&' at somewhere in code |
| 160 |
o example of a "after-transfer-patch-rule" |
| 161 |
o copy contents of field "x" to field "y" to nivelate(?) access from ldap-query-engines we don't have access to! (the source!) |
| 162 |
(e.g. query-/search-engines in commercial products like "MS Outlook 2000|2002|Express", |
| 163 |
which also don't have _any_ mechanism to parametrize them) |
| 164 |
o write papers about networking (computers _and_ small/embedded/electronic devices (atmel, c-control)) |
| 165 |
o janosch: how to control arbitrary devices via personal computers _and_ standalone circuits in parallel! |
| 166 |
(using Device::SerialPort and Conrad C-Control together) |
| 167 |
o implement infrastructure(s) |
| 168 |
o actually handle folders (check, autocreation) completely _before_ starting to sync/process items/entries! |
| 169 |
o provide easy-to-access shell-interface to LDAP (e.g. via Xyz::Xyz or (maybe later) "oedit.pl") |
| 170 |
o this removes the need for the currently used Java-based Ldap-Client (which will stay more comfortable - of course) |
| 171 |
o navigate via "cd" through containers, show items/entries via (e.g.) "dump"(?) and stuff... |
| 172 |
... the interactive feeling/behaviour is similar to navigating in a filesystem via a commandline-interface (CLI) |
| 173 |
o sum up "must-have" features of known synchronization-tools for (e.g.) ... |
| 174 |
o use news (the nntp-protocol) for journalling-functionality |
| 175 |
o have mapping stored inside ldap as well |
| 176 |
|
Parent Directory
| 
Revision Log
