claws_abook_from_odoo.sql

SELECT xmlroot (
  xmlelement(
    name "address-book",
    xmlattributes ('ODOO addresses' as name),
    xmlagg(person)),
  version '1.0',
  standalone YES)
FROM (
SELECT xmlelement(
   name person,
   xmlattributes(id as uid, name as "nick-name", name as cn),
   xmlelement(
      name "address-list",
      xmlelement(
        name "address",
        xmlattributes(id||'-1' as uid, email as email))
   )) as person
FROM res_partner
WHERE email IS NOT NULL AND
      is_company = False AND
      active = True ) as people