| 1 |
joko |
1.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 |
|
|
|
| 26 |
|
|
REQUIREMENTS |
| 27 |
|
|
Win32::OLE |
| 28 |
|
|
Net::LDAP |
| 29 |
|
|
Data::Storage |
| 30 |
|
|
Data::Transfer::Sync |
| 31 |
|
|
... and all their dependencies |
| 32 |
|
|
|
| 33 |
|
|
AUTHORS / COPYRIGHT |
| 34 |
|
|
The Data::Storage module is Copyright (c) 2002 Andreas Motl. |
| 35 |
|
|
All rights reserved. |
| 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 <jan@romain-volk.com> |
| 42 |
|
|
Sebastian Utz <s.utz@tunemedia.de> |
| 43 |
|
|
|
| 44 |
|
|
SUPPORT / WARRANTY |
| 45 |
|
|
Data::Storage is free software. IT COMES WITHOUT WARRANTY OF ANY KIND. |
| 46 |
|
|
|
| 47 |
|
|
BUGS |
| 48 |
joko |
1.3 |
TODO-SHOWSTOPPER |
| 49 |
|
|
o sync items from ldap back to outlook |
| 50 |
|
|
|
| 51 |
joko |
1.1 |
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 |
joko |
1.2 |
o zugriff auf outlook (2002) ohne rückfrage gewähren? |
| 81 |
joko |
1.1 |
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 |
joko |
1.2 |
|
| 138 |
|
|
o split 'syncOutlookContacts.ini' into 'torus.ini' and 'outlook2ldap.ini' |
| 139 |
|
|
o 'syncOutlookContacts.pl' reads 'outlook2ldap.ini' and runs 'feed.pl' |
| 140 |
joko |
1.1 |
|
| 141 |
joko |
1.3 |
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 |
joko |
1.1 |
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
