manipulate data from ldap

[samuel desseaux]

Hi,

It's the first time i work with data from ldap. I know some methods in
python  but not in perl.

The case:

I've exported my datas from ldap in an xml format and it gives this (it's
an extract).

<PERSONS>
   <PERSON>
      <CN>Joseph Stephanie</CN>
      <CIVILITE>Mme</CIVILITE>
      <OU>employee</OU>
      <LOGIN>josephs</LOGIN>
      <ACHMAIL>stephanie.jos...@ecp.fr</ACHMAIL>
      <UID>2009josephs</UID>
      <LEC_NUM>20018</LEC_NUM>
      <ECP_BADGE>P5704</ECP_BADGE>
      <DATEFIN>2100-01-01</DATEFIN>
      <CAT>CAT2</CAT>
      <ECP_CHAMBRE></ECP_CHAMBRE>
      <LEC_CATEG_PORTAIL>ABO<PERSON>
      <CN>Joseph Stephanie</CN>
      <CIVILITE>Mme</CIVILITE>
      <OU>employee</OU>
      <LOGIN>josephs</LOGIN>
      <ACHMAIL>stephanie.jos...@ecp.fr</ACHMAIL>
      <UID>2009josephs</UID>
      <LEC_NUM>20018</LEC_NUM>
      <ECP_BADGE>P5704</ECP_BADGE>
      <DATEFIN>2100-01-01</DATEFIN>
      <CAT>CAT2</CAT>
      <ECP_CHAMBRE></ECP_CHAMBRE>
      <LEC_CATEG_PORTAIL>ABOP</LEC_CATEG_PORTAIL>
      <LEC_AUTORISE>1</LEC_AUTORISE>
   </PERSON>P</LEC_CATEG_PORTAIL>
      <LEC_AUTORISE>1</LEC_AUTORISE>
   </PERSON>
   <PERSON>
      <CN>Pierron Lucienne</CN>
      <CIVILITE>Mlle</CIVILITE>
      <OU>employee</OU>
      <LOGIN>pierronl</LOGIN>
      <ACHMAIL>lucienne.pier...@ecp.fr</ACHMAIL>
      <UID>2009pierronl</UID>
      <LEC_NUM>20019</LEC_NUM>
      <ECP_BADGE>P5738</ECP_BADGE>
      <DATEFIN>2100-01-01</DATEFIN>
      <CAT>CAT2</CAT>
      <ECP_CHAMBRE>Olivier S309</ECP_CHAMBRE>
      <LEC_CATEG_PORTAIL>ABOP</LEC_CATEG_PORTAIL>
      <LEC_AUTORISE>1</LEC_AUTORISE>
   </PERSON>
   <PERSON>
      <CN>Dumur Didier</CN>
      <CIVILITE>M.</CIVILITE>
      <OU>employee</OU>
      <LOGIN>dumurd</LOGIN>
      <ACHMAIL>didier.du...@ecp.fr</ACHMAIL>
      <UID>2009dumurd</UID>
      <LEC_NUM>20020</LEC_NUM>
      <ECP_BADGE>P5749</ECP_BADGE>
      <DATEFIN>2013-02-01</DATEFIN>
      <CAT>CAT2</CAT>
      <ECP_CHAMBRE></ECP_CHAMBRE>
      <LEC_CATEG_PORTAIL>ABOP</LEC_CATEG_PORTAIL>
      <LEC_AUTORISE>1</LEC_AUTORISE>
   </PERSON>



I would like change the structure and the name of the balises

Here is my new structure and comments

<PERSON>
      <CN>Joseph Stephanie</CN>   ----> is it possible to break this balise
in
<surname>Joseph</surname>
<firstname>Stephanie</firstname>


      <CIVILITE>Mme</CIVILITE>   --->to drop
      <OU>employee</OU>  ----> become <categorycode>employee</categorycode>
      <LOGIN>josephs</LOGIN> --->become <login>xxxx</login>
      <ACHMAIL>stephanie.jos...@ecp.fr</ACHMAIL>  -->become <email>
x...@ecp.fr</email>
      <UID>2009josephs</UID>  -->become <userid>2009josephs</userid>
      <LEC_NUM>20018</LEC_NUM>  -->become <cardnumber>xxxx</cardnumber>

the following balises can be dropped
      <ECP_BADGE>P5704</ECP_BADGE>
      <DATEFIN>2100-01-01</DATEFIN>
      <CAT>CAT2</CAT>
      <ECP_CHAMBRE></ECP_CHAMBRE>
      <LEC_CATEG_PORTAIL>ABOP</LEC_CATEG_PORTAIL>
      <LEC_AUTORISE>1</LEC_AUTORISE>
   </PERSON>


Many thanks.

Samuel