Re: Populating a database

[Peter Van Biesen <peter.vanbiesen@vlafo.be>]

Hi,

I did this just last week. Netscape puts some stuff in the ldif file
that openldap can not load. You'll have to edit the ldif file manually.
I did this in emacs and it took me about ten minutes to do for our whole
netscape database ( some 500 users ).

First of all, remove all lines starting with 'aci:', these are
authorisationlines used by netscape but in openldap this is done in the
slapd.conf file.

Then, check for empty fields ( _ are spaces ! )

change "SomeField:_" to "SomeField:__", otherwise you will get a #0
error.

Remove all modifytimestamp, modifier, createtimestamp, creator ( I don't
remember the exact names, but there are 4 per record ). You could leave
them in if you login on the server with the user defined in the updatedn
parameter in the slapd.conf, but I haven't tried this myself. Safest way
is to remove them.

Then there are some objectclasses specific to netscape, you'll have to
discover these by trial and error. An attribute you can remove is
memberurl and its objectclass ( something with url also ).

If this is all done, you can just import the ldif file into the server;
it shouldn't produce a lot of errors anymore. 

Hope this helps !

Peter.

jorge@triple-e-vfx.com wrote:
> 
> Hello,
> 
> > After select the way to present and use data.
> > I am not sure than "cn=_ALL,mail=all@domain.com" is your suffix????
> > Please give your suffix, and the objectclass
> 
> My problem is that I'm trying to add the ldif file exported by netscape
> or outlook...
> 
> It has the following aspect for every person:
> 
> dn: cn=_ALL,mail=all@domain.com
> modifytimestamp: 20020319141342Z
> cn: _ALL
> mail: all@domain.com
> xmozillausehtmlmail: FALSE
> xmozillauseconferenceserver: 0
> objectclass: top
> objectclass: person
> 
> I could populate the database manually, or writing a perl script that
> parses the old ldif file. But I'm interested better in populating the
> database with this ldif file exported by netscape.
> 
> Any idea if that is possible ?
> 
> Thanks,
> 
> Jorge