[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-pim
Subject:    Re: [Kde-pim] XML format for kabc
From:       thefrog <thefrog () rlac ! de>
Date:       2002-05-22 5:54:08
[Download RAW message or body]

Am Tuesday 21 May 2002 13:25 schrieb Mike Pilone:
> On Tuesday 21 May 2002 06:46 am, Tobias Koenig wrote:
> > > Binary, LDAP or SQL may be a better solution.
> >
> > Did somebody already implement one of the above backends?
>
> There is a very simple implementation of a SQL backend, but nothing much.
> Look at the 'Resource' classes in libkabc. LDAP is constantly requested if
> your looking for something to start with.

I started to have look on a sql implementation soon. But it's growing slowly.
I discussed it a little bit with cornelius. The thing is we need some kind of
mapping between the kabc fields and database fields to make it flexible.

I attached my actual 'state of thinkin'. It's incomplete, I know.

I don't nothing about ldap.

rainald


["generic.xml" (text/xml)]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE kabcsqldata >
<KabcSqlData
	Type="1"
	Host="localhost"
	Port="5432"
	Database="kabcdata"
	User=""
	Password=""
>
 <KabcSqlDataField Name="Uid" Table="addressee" Mapping="uid" />
 <KabcSqlDataField Name="Name" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="FormattedName" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="FamilyName" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="GivenName" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="AdditionalName" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Prefix" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="HonoricSuffix" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="NickName" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Birthday" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Mailer" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Timezone" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="GeographicPosition" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Title" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Role" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Organisation" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="Note" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="ProductId" Table="addressee" Mapping="name" />
 <KabcSqlDataField Name="RevisionDate" Table="addressee" Mapping="name" />

 <KabcSqlDataField Name="Uid" Table="contact" Mapping="name" />
 <KabcSqlDataField Name="Url" Table="contact" Mapping="name" />
 <KabcSqlDataField Name="Email" Table="contact" Mapping="name" />
 <KabcSqlDataField Name="PhoneNumber" Table="contact" Mapping="name" />

 <KabcSqlDataField Name="" Table="addresse" Mapping="name" />
 <KabcSqlDataField Name="" Table="addresse" Mapping="name" />
 <KabcSqlDataField Name="" Table="addresse" Mapping="name" />
 <KabcSqlDataField Name="" Table="addresse" Mapping="name" />
 <KabcSqlDataField Name="" Table="addresse" Mapping="name" />

 <KabcSqlDataField Name="Category" Table="category" Mapping="name" />

 <KabcSqlDataField Name="Field1" Table="custom" Mapping="name" />
</KabcSqlData>

_______________________________________________
kde-pim mailing list
kde-pim@mail.kde.org
http://mail.kde.org/mailman/listinfo/kde-pim
kde-pim home page at http://pim.kde.org/

[prev in list] [next in list] [prev in thread] [next in thread]