openerp-expert-framework team mailing list archive

["Olivier Dony \(OpenERP\)" <odo@xxxxxxxxxxx>]

You have been requested to review the proposed merge of lp:~openerp-dev/openobject-server/trunk-newimport-phase2-xmo into lp:openobject-server.

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-server/trunk-newimport-phase2-xmo/+merge/126658

Import backend rewrite

* new core function BaseImport.load, splits the CSV-ish input (list of lists), converts into records and saves that to the db (via ir.model.data._update)
  - Can return a multitude of warnings and errors
  - Richer returned messages
  - Should be transaction-clean (via savepoints)
* Extracted field validators and converters into a separate model for overriding and warnings
* Tests copied from import_data and altered to match new return, behavioral fixes

-- 
https://code.launchpad.net/~openerp-dev/openobject-server/trunk-newimport-phase2-xmo/+merge/126658
Your team OpenERP Framework Experts is requested to review the proposed merge of lp:~openerp-dev/openobject-server/trunk-newimport-phase2-xmo into lp:openobject-server.

=== modified file '.bzrignore'
--- .bzrignore	2012-03-19 10:33:17 +0000
+++ .bzrignore	2012-10-08 13:46:29 +0000
@@ -15,4 +15,5 @@
 build/
 include/
 lib/
-share/
\ No newline at end of file
+share/
+doc/_build/*

=== modified file 'doc/api/user_img_specs.rst'
--- doc/api/user_img_specs.rst	2012-05-18 14:36:25 +0000
+++ doc/api/user_img_specs.rst	2012-10-08 13:46:29 +0000
@@ -3,9 +3,24 @@
 
 .. versionadded:: 7.0
 
-This revision adds an avatar for users. This replaces the use of gravatar to emulate avatars, used in views like the tasks kanban view. Two fields have been added to the res.users model:
- - avatar_big, a binary field holding the image. It is base-64 encoded, and PIL-supported. Images stored are resized to 540x450 px, to limitate the binary field size.
- - avatar, a function binary field holding an automatically resized version of the avatar_big field. It is also base-64 encoded, and PIL-supported. Dimensions of the resized avatar are 180x150. This field is used as an inteface to get and set the user avatar.
-When changing the avatar through the avatar function field, the new image is automatically resized to 540x450, and stored in the avatar_big field. This triggers the function field, that will compute a 180x150 resized version of the image.
-
-An avatar field has been added to the users form view, as well as in Preferences. When creating a new user, a default avatar is chosen among 6 possible default images.
+This revision adds an avatar for users. This replaces the use of
+gravatar to emulate avatars, used in views like the tasks kanban
+view. Two fields have been added to the res.users model:
+
+* ``avatar_big``, a binary field holding the image. It is base-64
+  encoded, and PIL-supported. Images stored are resized to 540x450 px,
+  to limitate the binary field size.
+
+* ``avatar``, a function binary field holding an automatically resized
+  version of the avatar_big field. It is also base-64 encoded, and
+  PIL-supported. Dimensions of the resized avatar are 180x150. This
+  field is used as an inteface to get and set the user avatar.
+
+When changing the avatar through the avatar function field, the new
+image is automatically resized to 540x450, and stored in the
+avatar_big field. This triggers the function field, that will compute
+a 180x150 resized version of the image.
+
+An avatar field has been added to the users form view, as well as in
+Preferences. When creating a new user, a default avatar is chosen
+among 6 possible default images.

=== modified file 'doc/conf.py'
--- doc/conf.py	2012-03-05 16:45:52 +0000
+++ doc/conf.py	2012-10-08 13:46:29 +0000
@@ -19,6 +19,7 @@
 #sys.path.insert(0, os.path.abspath('.'))
 sys.path.append(os.path.abspath('_themes'))
 sys.path.append(os.path.abspath('..'))
+sys.path.append(os.path.abspath('../openerp'))
 
 # -- General configuration -----------------------------------------------------
 
@@ -50,9 +51,9 @@
 # built documents.
 #
 # The short X.Y version.
-version = '6.1'
+version = '7.0'
 # The full version, including alpha/beta/rc tags.
-release = '6.1'
+release = '7.0b'
 
 # The language for content autogenerated by Sphinx. Refer to documentation
 # for a list of supported languages.

=== added file 'doc/import.rst'
--- doc/import.rst	1970-01-01 00:00:00 +0000
+++ doc/import.rst	2012-10-08 13:46:29 +0000
@@ -0,0 +1,231 @@
+.. _bulk-import:
+
+Bulk Import
+===========
+
+OpenERP has included a bulk import facility for CSV-ish files for a
+long time. With 7.0, both the interface and internal implementation
+have been redone, resulting in
+:meth:`~openerp.osv.orm.BaseModel.load`.
+
+.. note::
+
+    the previous bulk-loading method,
+    :meth:`~openerp.osv.orm.BaseModel.import_data`, remains for
+    backwards compatibility but was re-implemented on top of
+    :meth:`~openerp.osv.orm.BaseModel.load`, while its interface is
+    unchanged its precise behavior has likely been altered for some
+    cases (it shouldn't throw exceptions anymore in many cases where
+    it previously did)
+
+This document attempts to explain the behavior and limitations of
+:meth:`~openerp.osv.orm.BaseModel.load`.
+
+Data
+====
+
+The input ``data`` is a regular row-major matrix of strings (in Python
+datatype terms, a ``list`` of rows, each row being a ``list`` of
+``str``, all rows must be of equal length). Each row must be the same
+length as the ``fields`` list preceding it in the argslist.
+
+Each field of ``fields`` maps to a (potentially relational and nested)
+field of the model under import, and the corresponding column of the
+``data`` matrix provides a value for the field for each record.
+
+Generally speaking each row of the input yields a record of output,
+and each cell of a row yields a value for the corresponding field of
+the row's record. There is currently one exception for this rule:
+
+One to Many fields
+------------------
+
+Because O2M fields contain multiple records "embedded" in the main
+one, and these sub-records are fully dependent on the main record (are
+no other references to the sub-records in the system), they have to be
+spliced into the matrix somehow. This is done by adding lines composed
+*only* of o2m record fields below the main record:
+
+.. literalinclude:: o2m.txt
+
+the sections in double-lines represent the span of two o2m
+fields. During parsing, they are extracted into their own ``data``
+matrix for the o2m field they correspond to.
+
+Import process
+==============
+
+Here are the phases of import. Note that the concept of "phases" is
+fuzzy as it's currently more of a pipeline, each record moves through
+the entire pipeline before the next one is processed.
+
+Extraction
+----------
+
+The first phase of the import is the extraction of the current row
+(and potentially a section of rows following it if it has One to Many
+fields) into a record dictionary. The keys are the ``fields``
+originally passed to :meth:`~openerp.osv.orm.BaseModel.load`, and the
+values are either the string value at the corresponding cell (for
+non-relational fields) or a list of sub-records (for all relational
+fields).
+
+This phase also generates the ``rows`` indexes for any
+:ref:`import-message` produced thereafter.
+
+Conversion
+----------
+
+This second phase takes the record dicts, extracts the :ref:`dbid` and
+:ref:`xid` if present and attempts to convert each field to a type
+matching what OpenERP expects to write. Empty fields (empty strings)
+are replaced with the ``False`` value, and non-empty fields are
+converted through
+:class:`~openerp.addons.base.ir.ir_fields.ir_fields_converter`:
+
+Char, text and binary fields
+++++++++++++++++++++++++++++
+
+Are returned as-is, without any alteration.
+
+Boolean fields
+++++++++++++++
+
+The string value is compared (in a case-insensitive manner) to ``0``,
+``false`` and ``no`` as well of any translation thereof loaded in the
+database. If the value matches one of these, the field is set to
+``False``.
+
+Otherwise the field is compared to ``1``, ``true`` and ``yes`` (and
+any translation of these in the database). The field is always set to
+``True``, but if the value does not match one of these a warning will
+also be output.
+
+Integers and float fields
++++++++++++++++++++++++++
+
+The field is parsed with Python's built-in conversion routines
+(``int`` and ``float`` respectively), if the conversion fails an error
+is generated.
+
+Selection fields
+++++++++++++++++
+
+The field is compared to 1. the values of the selection (first part of
+each selection tuple) and 2. all translations of the selection label
+found in the database.
+
+If one of these is matched, the corresponding value is set on the
+field.
+
+Otherwise an error is generated.
+
+The same process applies to both list-type and function-type selection
+fields.
+
+Many to One field
++++++++++++++++++
+
+If the specified field is the relational field itself (``m2o``), the
+value is used in a ``name_search``. The first record returned by
+``name_search`` is used as the field's value.
+
+If ``name_search`` finds no value, an error is generated. If
+``name_search`` finds multiple value, a warning is generated to warn
+the user of ``name_search`` collisions.
+
+If the specified field is a :ref:`xid` (``m2o/id``), the
+corresponding record it looked up in the database and used as the
+field's value. If no record is found matching the provided external
+ID, an error is generated.
+
+If the specified field is a :ref:`dbid` (``m2o/.id``), the process is
+the same as for external ids (on database identifiers instead of
+external ones).
+
+Many to Many field
+++++++++++++++++++
+
+The field's value is interpreted as a comma-separated list of names,
+external ids or database ids. For each one, the process previously
+used for the many to one field is applied.
+
+One to Many field
++++++++++++++++++
+
+For each o2m record extracted, if the record has a ``name``,
+:ref:`xid` or :ref:`dbid` the :ref:`dbid` is looked up and checked
+through the same process as for m2o fields.
+
+If a :ref:`dbid` was found, a LINK_TO command is emmitted, followed by
+an UPDATE with the non-db values for the relational field.
+
+Otherwise a CREATE command is emmitted.
+
+Create/Write
+------------
+
+If the conversion was successful, the converted record is then saved
+to the database via ``(ir.model.data)._update``.
+
+Error handling
+--------------
+
+The import process will only catch 2 types of exceptions to convert
+them to error messages: ``ValueError`` during the conversion process,
+and sub-exceptions of ``psycopg2.Error`` during the create/write
+process.
+
+The import process uses savepoint to:
+
+* protect the overall transaction from the failure of each ``_update``
+  call, if an ``_update`` call fails the savepoint is rolled back and
+  the import process keeps going in order to obtain as many error
+  messages as possible during each run.
+
+* protect the import as a whole, a savepoint is created before
+  starting and if any error is generated that savepoint is rolled
+  back. The rest of the transaction (anything not within the import
+  process) will be left untouched.
+
+.. _import-message:
+.. _import-messages:
+
+Messages
+========
+
+A message is a dictionary with 5 mandatory keys and one optional key:
+
+``type``
+    the type of message, either ``warning`` or ``error``. Any
+    ``error`` message indicates the import failed and was rolled back.
+
+``message``
+    the message's actual text, which should be translated and can be
+    shown to the user directly
+
+``rows``
+    a dict with 2 keys ``from`` and ``to``, indicates the range of
+    rows in ``data`` which generated the message
+
+``record``
+    a single integer, for warnings the index of the record which
+    generated the message (can be obtained from a non-false ``ids``
+    result)
+
+``field``
+    the name of the (logical) OpenERP field for which the error or
+    warning was generated
+
+``moreinfo`` (optional)
+    A string, a list or a dict, leading to more information about the
+    warning.
+
+    * If ``moreinfo`` is a string, it is a supplementary warnings
+      message which should be hidden by default
+    * If ``moreinfo`` is a list, it provides a number of possible or
+      alternative values for the string
+    * If ``moreinfo`` is a dict, it is an OpenERP action descriptor
+      which can be executed to get more information about the issues
+      with the field. If present, the ``help`` key serves as a label
+      for the action (e.g. the text of the link).

=== modified file 'doc/index.rst.inc'
--- doc/index.rst.inc	2012-05-18 14:36:25 +0000
+++ doc/index.rst.inc	2012-10-08 13:46:29 +0000
@@ -5,6 +5,7 @@
 .. toctree::
    :maxdepth: 1
 
+   import
    test-framework
 
 Changed in 7.0

=== added file 'doc/o2m.txt'
--- doc/o2m.txt	1970-01-01 00:00:00 +0000
+++ doc/o2m.txt	2012-10-08 13:46:29 +0000
@@ -0,0 +1,13 @@
++-------+-------+===========+===========+-------+-------+
+|value01|value02‖o2m/value01|o2m/value02‖value03|value04|
++-------+-------+-----------+-----------+-------+-------+
+|       |       ‖o2m/value11|o2m/value12‖       |       |
++-------+-------+-----------+-----------+-------+-------+
+|       |       ‖o2m/value21|o2m/value22‖       |       |
++-------+-------+===========+===========+-------+-------+
+|value11|value12‖o2m/value01|o2m/value02‖value13|value14|
++-------+-------+-----------+-----------+-------+-------+
+|       |       ‖o2m/value11|o2m/value12‖       |       |
++-------+-------+===========+===========+-------+-------+
+|value21|value22|           |           |value23|value24|
++-------+-------+-----------+-----------+-------+-------+

=== modified file 'openerp/addons/base/ir/__init__.py'
--- openerp/addons/base/ir/__init__.py	2012-10-03 14:20:06 +0000
+++ openerp/addons/base/ir/__init__.py	2012-10-08 13:46:29 +0000
@@ -40,6 +40,7 @@
 import ir_config_parameter
 import osv_memory_autovacuum
 import ir_mail_server
+import ir_fields
 
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 

=== modified file 'openerp/addons/base/ir/ir.xml'
--- openerp/addons/base/ir/ir.xml	2012-10-03 16:18:07 +0000
+++ openerp/addons/base/ir/ir.xml	2012-10-08 13:46:29 +0000
@@ -1019,6 +1019,7 @@
                 <tree string="External Identifiers">
                     <field name="complete_name"/>
                     <field name="display_name"/>
+                    <field name="res_id"/>
                     <field name="model" groups="base.group_no_one"/>
                 </tree>
             </field>

=== modified file 'openerp/addons/base/ir/ir_actions.py'
--- openerp/addons/base/ir/ir_actions.py	2012-10-01 14:49:41 +0000
+++ openerp/addons/base/ir/ir_actions.py	2012-10-08 13:46:29 +0000
@@ -19,14 +19,11 @@
 #
 ##############################################################################
 
-import ast
-import copy
 import logging
 import os
 import re
 import time
 import tools
-from xml import dom
 
 import netsvc
 from osv import fields,osv
@@ -47,6 +44,9 @@
         'name': fields.char('Name', size=64, required=True),
         'type': fields.char('Action Type', required=True, size=32,readonly=True),
         'usage': fields.char('Action Usage', size=32),
+        'help': fields.text('Action description',
+            help='Optional help text for the users with a description of the target view, such as its usage and purpose.',
+            translate=True),
     }
     _defaults = {
         'usage': lambda *a: False,
@@ -107,6 +107,7 @@
                         r['report_xsl'] and opj('addons',r['report_xsl']))
 
     _name = 'ir.actions.report.xml'
+    _inherit = 'ir.actions.actions'
     _table = 'ir_act_report_xml'
     _sequence = 'ir_actions_id_seq'
     _order = 'name'
@@ -155,6 +156,7 @@
 class act_window(osv.osv):
     _name = 'ir.actions.act_window'
     _table = 'ir_act_window'
+    _inherit = 'ir.actions.actions'
     _sequence = 'ir_actions_id_seq'
     _order = 'name'
 
@@ -245,9 +247,6 @@
         'filter': fields.boolean('Filter'),
         'auto_search':fields.boolean('Auto Search'),
         'search_view' : fields.function(_search_view, type='text', string='Search View'),
-        'help': fields.text('Action description',
-            help='Optional help text for the users with a description of the target view, such as its usage and purpose.',
-            translate=True),
         'multi': fields.boolean('Action on Multiple Doc.', help="If set to true, the action will not be displayed on the right toolbar of a form view"),
     }
 
@@ -331,6 +330,7 @@
 class act_url(osv.osv):
     _name = 'ir.actions.act_url'
     _table = 'ir_act_url'
+    _inherit = 'ir.actions.actions'
     _sequence = 'ir_actions_id_seq'
     _order = 'name'
     _columns = {
@@ -432,6 +432,7 @@
 
     _name = 'ir.actions.server'
     _table = 'ir_act_server'
+    _inherit = 'ir.actions.actions'
     _sequence = 'ir_actions_id_seq'
     _order = 'sequence,name'
     _columns = {

=== added file 'openerp/addons/base/ir/ir_fields.py'
--- openerp/addons/base/ir/ir_fields.py	1970-01-01 00:00:00 +0000
+++ openerp/addons/base/ir/ir_fields.py	2012-10-08 13:46:29 +0000
@@ -0,0 +1,335 @@
+# -*- coding: utf-8 -*-
+import functools
+import operator
+import itertools
+import psycopg2
+import time
+from openerp.osv import orm, fields
+from openerp.tools.translate import _
+from openerp.tools.misc import DEFAULT_SERVER_DATE_FORMAT,\
+                               DEFAULT_SERVER_DATETIME_FORMAT
+
+REFERENCING_FIELDS = set([None, 'id', '.id'])
+def only_ref_fields(record):
+    return dict((k, v) for k, v in record.iteritems()
+                if k in REFERENCING_FIELDS)
+def exclude_ref_fields(record):
+    return dict((k, v) for k, v in record.iteritems()
+                if k not in REFERENCING_FIELDS)
+
+CREATE = lambda values: (0, False, values)
+UPDATE = lambda id, values: (1, id, values)
+DELETE = lambda id: (2, id, False)
+FORGET = lambda id: (3, id, False)
+LINK_TO = lambda id: (4, id, False)
+DELETE_ALL = lambda: (5, False, False)
+REPLACE_WITH = lambda ids: (6, False, ids)
+
+class ConversionNotFound(ValueError): pass
+
+class ir_fields_converter(orm.Model):
+    _name = 'ir.fields.converter'
+
+    def to_field(self, cr, uid, model, column, fromtype=str, context=None):
+        """ Fetches a converter for the provided column object, from the
+        specified type.
+
+        A converter is simply a callable taking a value of type ``fromtype``
+        (or a composite of ``fromtype``, e.g. list or dict) and returning a
+        value acceptable for a write() on the column ``column``.
+
+        By default, tries to get a method on itself with a name matching the
+        pattern ``_$fromtype_to_$column._type`` and returns it.
+
+        Converter callables can either return a value and a list of warnings
+        to their caller or raise ``ValueError``, which will be interpreted as a
+        validation & conversion failure.
+
+        ValueError can have either one or two parameters. The first parameter
+        is mandatory, **must** be a unicode string and will be used as the
+        user-visible message for the error (it should be translatable and
+        translated). It can contain a ``field`` named format placeholder so the
+        caller can inject the field's translated, user-facing name (@string).
+
+        The second parameter is optional and, if provided, must be a mapping.
+        This mapping will be merged into the error dictionary returned to the
+        client.
+
+        If a converter can perform its function but has to make assumptions
+        about the data, it can send a warning to the user through adding an
+        instance of :class:`~openerp.osv.orm.ImportWarning` to the second value
+        it returns. The handling of a warning at the upper levels is the same
+        as ``ValueError`` above.
+
+        :param column: column object to generate a value for
+        :type column: :class:`fields._column`
+        :param type fromtype: type to convert to something fitting for ``column``
+        :param context: openerp request context
+        :return: a function (fromtype -> column.write_type), if a converter is found
+        :rtype: Callable | None
+        """
+        # FIXME: return None
+        converter = getattr(
+            self, '_%s_to_%s' % (fromtype.__name__, column._type), None)
+        if not converter: return None
+
+        return functools.partial(
+            converter, cr, uid, model, column, context=context)
+
+    def _str_to_boolean(self, cr, uid, model, column, value, context=None):
+        # all translatables used for booleans
+        true, yes, false, no = _(u"true"), _(u"yes"), _(u"false"), _(u"no")
+        # potentially broken casefolding? What about locales?
+        trues = set(word.lower() for word in itertools.chain(
+            [u'1', u"true", u"yes"], # don't use potentially translated values
+            self._get_translations(cr, uid, ['code'], u"true", context=context),
+            self._get_translations(cr, uid, ['code'], u"yes", context=context),
+        ))
+        if value.lower() in trues: return True, []
+
+        # potentially broken casefolding? What about locales?
+        falses = set(word.lower() for word in itertools.chain(
+            [u'', u"0", u"false", u"no"],
+            self._get_translations(cr, uid, ['code'], u"false", context=context),
+            self._get_translations(cr, uid, ['code'], u"no", context=context),
+        ))
+        if value.lower() in falses: return False, []
+
+        return True, [orm.ImportWarning(
+            _(u"Unknown value '%s' for boolean field '%%(field)s', assuming '%s'")
+                % (value, yes), {
+                'moreinfo': _(u"Use '1' for yes and '0' for no")
+            })]
+
+    def _str_to_integer(self, cr, uid, model, column, value, context=None):
+        try:
+            return int(value), []
+        except ValueError:
+            raise ValueError(
+                _(u"'%s' does not seem to be an integer for field '%%(field)s'")
+                % value)
+
+    def _str_to_float(self, cr, uid, model, column, value, context=None):
+        try:
+            return float(value), []
+        except ValueError:
+            raise ValueError(
+                _(u"'%s' does not seem to be a number for field '%%(field)s'")
+                % value)
+
+    def _str_id(self, cr, uid, model, column, value, context=None):
+        return value, []
+    _str_to_char = _str_to_text = _str_to_binary = _str_id
+
+    def _str_to_date(self, cr, uid, model, column, value, context=None):
+        try:
+            time.strptime(value, DEFAULT_SERVER_DATE_FORMAT)
+            return value, []
+        except ValueError:
+            raise ValueError(
+                _(u"'%s' does not seem to be a valid date for field '%%(field)s'") % value, {
+                    'moreinfo': _(u"Use the format '%s'") % u"2012-12-31"
+                })
+
+    def _str_to_datetime(self, cr, uid, model, column, value, context=None):
+        try:
+            time.strptime(value, DEFAULT_SERVER_DATETIME_FORMAT)
+            return value, []
+        except ValueError:
+            raise ValueError(
+                _(u"'%s' does not seem to be a valid datetime for field '%%(field)s'") % value, {
+                    'moreinfo': _(u"Use the format '%s'") % u"2012-12-31 23:59:59"
+                })
+
+    def _get_translations(self, cr, uid, types, src, context):
+        types = tuple(types)
+        # Cache translations so they don't have to be reloaded from scratch on
+        # every row of the file
+        tnx_cache = cr.cache.setdefault(self._name, {})
+        if tnx_cache.setdefault(types, {}) and src in tnx_cache[types]:
+            return tnx_cache[types][src]
+
+        Translations = self.pool['ir.translation']
+        tnx_ids = Translations.search(
+            cr, uid, [('type', 'in', types), ('src', '=', src)], context=context)
+        tnx = Translations.read(cr, uid, tnx_ids, ['value'], context=context)
+        result = tnx_cache[types][src] = map(operator.itemgetter('value'), tnx)
+        return result
+
+    def _str_to_selection(self, cr, uid, model, column, value, context=None):
+
+        selection = column.selection
+        if not isinstance(selection, (tuple, list)):
+            # FIXME: Don't pass context to avoid translations?
+            #        Or just copy context & remove lang?
+            selection = selection(model, cr, uid)
+        for item, label in selection:
+            labels = self._get_translations(
+                cr, uid, ('selection', 'model', 'code'), label, context=context)
+            labels.append(label)
+            if value == unicode(item) or value in labels:
+                return item, []
+        raise ValueError(
+            _(u"Value '%s' not found in selection field '%%(field)s'") % (
+                value), {
+                'moreinfo': [label or unicode(item) for item, label in selection
+                             if label or item]
+            })
+
+
+    def db_id_for(self, cr, uid, model, column, subfield, value, context=None):
+        """ Finds a database id for the reference ``value`` in the referencing
+        subfield ``subfield`` of the provided column of the provided model.
+
+        :param model: model to which the column belongs
+        :param column: relational column for which references are provided
+        :param subfield: a relational subfield allowing building of refs to
+                         existing records: ``None`` for a name_get/name_search,
+                         ``id`` for an external id and ``.id`` for a database
+                         id
+        :param value: value of the reference to match to an actual record
+        :param context: OpenERP request context
+        :return: a pair of the matched database identifier (if any), the
+                 translated user-readable name for the field and the list of
+                 warnings
+        :rtype: (ID|None, unicode, list)
+        """
+        if context is None: context = {}
+        id = None
+        warnings = []
+        action = {'type': 'ir.actions.act_window', 'target': 'new',
+                  'view_mode': 'tree,form', 'view_type': 'form',
+                  'views': [(False, 'tree'), (False, 'form')],
+                  'help': _(u"See all possible values")}
+        if subfield is None:
+            action['res_model'] = column._obj
+        elif subfield in ('id', '.id'):
+            action['res_model'] = 'ir.model.data'
+            action['domain'] = [('model', '=', column._obj)]
+
+        RelatedModel = self.pool[column._obj]
+        if subfield == '.id':
+            field_type = _(u"database id")
+            try: tentative_id = int(value)
+            except ValueError: tentative_id = value
+            try:
+                if RelatedModel.search(cr, uid, [('id', '=', tentative_id)],
+                                       context=context):
+                    id = tentative_id
+            except psycopg2.DataError:
+                # type error
+                raise ValueError(
+                    _(u"Invalid database id '%s' for the field '%%(field)s'") % value,
+                    {'moreinfo': action})
+        elif subfield == 'id':
+            field_type = _(u"external id")
+            if '.' in value:
+                module, xid = value.split('.', 1)
+            else:
+                module, xid = context.get('_import_current_module', ''), value
+            ModelData = self.pool['ir.model.data']
+            try:
+                _model, id = ModelData.get_object_reference(
+                    cr, uid, module, xid)
+            except ValueError: pass # leave id is None
+        elif subfield is None:
+            field_type = _(u"name")
+            ids = RelatedModel.name_search(
+                cr, uid, name=value, operator='=', context=context)
+            if ids:
+                if len(ids) > 1:
+                    warnings.append(orm.ImportWarning(
+                        _(u"Found multiple matches for field '%%(field)s' (%d matches)")
+                        % (len(ids))))
+                id, _name = ids[0]
+        else:
+            raise Exception(_(u"Unknown sub-field '%s'") % subfield)
+
+        if id is None:
+            raise ValueError(
+                _(u"No matching record found for %(field_type)s '%(value)s' in field '%%(field)s'")
+                % {'field_type': field_type, 'value': value},
+                {'moreinfo': action})
+        return id, field_type, warnings
+
+    def _referencing_subfield(self, record):
+        """ Checks the record for the subfields allowing referencing (an
+        existing record in an other table), errors out if it finds potential
+        conflicts (multiple referencing subfields) or non-referencing subfields
+        returns the name of the correct subfield.
+
+        :param record:
+        :return: the record subfield to use for referencing and a list of warnings
+        :rtype: str, list
+        """
+        # Can import by name_get, external id or database id
+        fieldset = set(record.iterkeys())
+        if fieldset - REFERENCING_FIELDS:
+            raise ValueError(
+                _(u"Can not create Many-To-One records indirectly, import the field separately"))
+        if len(fieldset) > 1:
+            raise ValueError(
+                _(u"Ambiguous specification for field '%(field)s', only provide one of name, external id or database id"))
+
+        # only one field left possible, unpack
+        [subfield] = fieldset
+        return subfield, []
+
+    def _str_to_many2one(self, cr, uid, model, column, values, context=None):
+        # Should only be one record, unpack
+        [record] = values
+
+        subfield, w1 = self._referencing_subfield(record)
+
+        reference = record[subfield]
+        id, subfield_type, w2 = self.db_id_for(
+            cr, uid, model, column, subfield, reference, context=context)
+        return id, w1 + w2
+
+    def _str_to_many2many(self, cr, uid, model, column, value, context=None):
+        [record] = value
+
+        subfield, warnings = self._referencing_subfield(record)
+
+        ids = []
+        for reference in record[subfield].split(','):
+            id, subfield_type, ws = self.db_id_for(
+                cr, uid, model, column, subfield, reference, context=context)
+            ids.append(id)
+            warnings.extend(ws)
+        return REPLACE_WITH(ids), warnings
+
+    def _str_to_one2many(self, cr, uid, model, column, records, context=None):
+        commands = []
+        warnings = []
+
+        if len(records) == 1 and exclude_ref_fields(records[0]) == {}:
+            # only one row with only ref field, field=ref1,ref2,ref3 as in
+            # m2o/m2m
+            record = records[0]
+            subfield, ws = self._referencing_subfield(record)
+            warnings.extend(ws)
+            # transform [{subfield:ref1,ref2,ref3}] into
+            # [{subfield:ref1},{subfield:ref2},{subfield:ref3}]
+            records = ({subfield:item} for item in record[subfield].split(','))
+
+        for record in records:
+            id = None
+            refs = only_ref_fields(record)
+            # there are ref fields in the record
+            if refs:
+                subfield, w1 = self._referencing_subfield(refs)
+                warnings.extend(w1)
+                reference = record[subfield]
+                id, subfield_type, w2 = self.db_id_for(
+                    cr, uid, model, column, subfield, reference, context=context)
+                warnings.extend(w2)
+
+            writable = exclude_ref_fields(record)
+            if id:
+                commands.append(LINK_TO(id))
+                commands.append(UPDATE(id, writable))
+            else:
+                commands.append(CREATE(writable))
+
+        return commands, warnings

=== modified file 'openerp/osv/expression.py'
--- openerp/osv/expression.py	2012-08-02 15:25:53 +0000
+++ openerp/osv/expression.py	2012-10-08 13:46:29 +0000
@@ -22,102 +22,114 @@
 
 """ Domain expression processing
 
-The main duty of this module is to compile a domain expression into a SQL
-query. A lot of things should be documented here, but as a first step in the
-right direction, some tests in test_osv_expression.yml might give you some
-additional information.
+The main duty of this module is to compile a domain expression into a
+SQL query. A lot of things should be documented here, but as a first
+step in the right direction, some tests in test_osv_expression.yml
+might give you some additional information.
 
-For legacy reasons, a domain uses an inconsistent two-levels abstract syntax
-(domains are regular Python data structures). At the first level, a domain
-is an expression made of terms (sometimes called leaves) and (domain) operators
-used in prefix notation. The available operators at this level are '!', '&',
-and '|'. '!' is a unary 'not', '&' is a binary 'and', and '|' is a binary 'or'.
-For instance, here is a possible domain. (<term> stands for an arbitrary term,
-more on this later.)
+For legacy reasons, a domain uses an inconsistent two-levels abstract
+syntax (domains are regular Python data structures). At the first
+level, a domain is an expression made of terms (sometimes called
+leaves) and (domain) operators used in prefix notation. The available
+operators at this level are '!', '&', and '|'. '!' is a unary 'not',
+'&' is a binary 'and', and '|' is a binary 'or'.  For instance, here
+is a possible domain. (<term> stands for an arbitrary term, more on
+this later.)::
 
     ['&', '!', <term1>, '|', <term2>, <term3>]
 
-It is equivalent to this pseudo code using infix notation:
+It is equivalent to this pseudo code using infix notation::
 
     (not <term1>) and (<term2> or <term3>)
 
-The second level of syntax deals with the term representation. A term is
-a triple of the form (left, operator, right). That is, a term uses an infix
-notation, and the available operators, and possible left and right operands
-differ with those of the previous level. Here is a possible term:
+The second level of syntax deals with the term representation. A term
+is a triple of the form (left, operator, right). That is, a term uses
+an infix notation, and the available operators, and possible left and
+right operands differ with those of the previous level. Here is a
+possible term::
 
     ('company_id.name', '=', 'OpenERP')
 
-The left and right operand don't have the same possible values. The left
-operand is field name (related to the model for which the domain applies).
-Actually, the field name can use the dot-notation to traverse relationships.
-The right operand is a Python value whose type should match the used operator
-and field type. In the above example, a string is used because the name field
-of a company has type string, and because we use the '=' operator. When
-appropriate, a 'in' operator can be used, and thus the right operand should be
-a list.
-
-Note: the non-uniform syntax could have been more uniform, but this would hide
-an important limitation of the domain syntax. Say that the term representation
-was ['=', 'company_id.name', 'OpenERP']. Used in a complete domain, this would
-look like:
-
-  ['!', ['=', 'company_id.name', 'OpenERP']]
-
-and you would be tempted to believe something like this would be possible:
-
-  ['!', ['=', 'company_id.name', ['&', ..., ...]]]
-
-That is, a domain could be a valid operand. But this is not the case. A domain
-is really limited to a two-level nature, and can not take a recursive form: a
-domain is not a valid second-level operand.
+The left and right operand don't have the same possible values. The
+left operand is field name (related to the model for which the domain
+applies).  Actually, the field name can use the dot-notation to
+traverse relationships.  The right operand is a Python value whose
+type should match the used operator and field type. In the above
+example, a string is used because the name field of a company has type
+string, and because we use the '=' operator. When appropriate, a 'in'
+operator can be used, and thus the right operand should be a list.
+
+Note: the non-uniform syntax could have been more uniform, but this
+would hide an important limitation of the domain syntax. Say that the
+term representation was ['=', 'company_id.name', 'OpenERP']. Used in a
+complete domain, this would look like::
+
+    ['!', ['=', 'company_id.name', 'OpenERP']]
+
+and you would be tempted to believe something like this would be
+possible::
+
+    ['!', ['=', 'company_id.name', ['&', ..., ...]]]
+
+That is, a domain could be a valid operand. But this is not the
+case. A domain is really limited to a two-level nature, and can not
+take a recursive form: a domain is not a valid second-level operand.
 
 Unaccent - Accent-insensitive search
 
-OpenERP will use the SQL function 'unaccent' when available for the 'ilike' and
-'not ilike' operators, and enabled in the configuration.
-Normally the 'unaccent' function is obtained from the PostgreSQL 'unaccent'
-contrib module[0].
-
-
-..todo: The following explanation should be moved in some external installation
-        guide
-
-The steps to install the module might differ on specific PostgreSQL versions.
-We give here some instruction for PostgreSQL 9.x on a Ubuntu system.
-
-Ubuntu doesn't come yet with PostgreSQL 9.x, so an alternative package source
-is used. We use Martin Pitt's PPA available at ppa:pitti/postgresql[1]. See
-[2] for instructions. Basically:
+OpenERP will use the SQL function 'unaccent' when available for the
+'ilike' and 'not ilike' operators, and enabled in the configuration.
+Normally the 'unaccent' function is obtained from `the PostgreSQL
+'unaccent' contrib module
+<http://developer.postgresql.org/pgdocs/postgres/unaccent.html>`_.
+
+.. todo: The following explanation should be moved in some external
+         installation guide
+
+The steps to install the module might differ on specific PostgreSQL
+versions.  We give here some instruction for PostgreSQL 9.x on a
+Ubuntu system.
+
+Ubuntu doesn't come yet with PostgreSQL 9.x, so an alternative package
+source is used. We use Martin Pitt's PPA available at
+`ppa:pitti/postgresql
+<https://launchpad.net/~pitti/+archive/postgresql>`_.
+
+.. code-block:: sh
 
     > sudo add-apt-repository ppa:pitti/postgresql
     > sudo apt-get update
 
-Once the package list is up-to-date, you have to install PostgreSQL 9.0 and
-its contrib modules.
+Once the package list is up-to-date, you have to install PostgreSQL
+9.0 and its contrib modules.
+
+.. code-block:: sh
 
     > sudo apt-get install postgresql-9.0 postgresql-contrib-9.0
 
 When you want to enable unaccent on some database:
 
+.. code-block:: sh
+
     > psql9 <database> -f /usr/share/postgresql/9.0/contrib/unaccent.sql
 
-Here 'psql9' is an alias for the newly installed PostgreSQL 9.0 tool, together
-with the correct port if necessary (for instance if PostgreSQL 8.4 is running
-on 5432). (Other aliases can be used for createdb and dropdb.)
+Here :program:`psql9` is an alias for the newly installed PostgreSQL
+9.0 tool, together with the correct port if necessary (for instance if
+PostgreSQL 8.4 is running on 5432). (Other aliases can be used for
+createdb and dropdb.)
+
+.. code-block:: sh
 
     > alias psql9='/usr/lib/postgresql/9.0/bin/psql -p 5433'
 
 You can check unaccent is working:
 
+.. code-block:: sh
+
     > psql9 <database> -c"select unaccent('hélène')"
 
 Finally, to instruct OpenERP to really use the unaccent function, you have to
-start the server specifying the --unaccent flag.
-
-[0] http://developer.postgresql.org/pgdocs/postgres/unaccent.html
-[1] https://launchpad.net/~pitti/+archive/postgresql
-[2] https://launchpad.net/+help/soyuz/ppa-sources-list.html
+start the server specifying the ``--unaccent`` flag.
 
 """
 
@@ -232,7 +244,7 @@
     """ Test whether an object is a valid domain term.
 
     :param internal: allow or not the 'inselect' internal operator in the term.
-    This normally should be always left to False.
+                     This normally should be always left to False.
     """
     INTERNAL_OPS = TERM_OPERATORS + ('inselect',)
     return (isinstance(element, tuple) or isinstance(element, list)) \

=== modified file 'openerp/osv/fields.py'
--- openerp/osv/fields.py	2012-09-26 13:09:42 +0000
+++ openerp/osv/fields.py	2012-10-08 13:46:29 +0000
@@ -1580,19 +1580,32 @@
 
 
 class column_info(object):
-    """Struct containing details about an osv column, either one local to
-       its model, or one inherited via _inherits.
-
-       :attr name: name of the column
-       :attr column: column instance, subclass of osv.fields._column
-       :attr parent_model: if the column is inherited, name of the model
-                           that contains it, None for local columns.
-       :attr parent_column: the name of the column containing the m2o
-                            relationship to the parent model that contains
-                            this column, None for local columns.
-       :attr original_parent: if the column is inherited, name of the original
-                            parent model that contains it i.e in case of multilevel
-                            inheritence, None for local columns.
+    """ Struct containing details about an osv column, either one local to
+        its model, or one inherited via _inherits.
+
+        .. attribute:: name
+
+            name of the column
+
+        .. attribute:: column
+
+            column instance, subclass of :class:`_column`
+
+        .. attribute:: parent_model
+
+            if the column is inherited, name of the model that contains it,
+            ``None`` for local columns.
+
+        .. attribute:: parent_column
+
+            the name of the column containing the m2o relationship to the
+            parent model that contains this column, ``None`` for local columns.
+
+        .. attribute:: original_parent
+
+            if the column is inherited, name of the original parent model that
+            contains it i.e in case of multilevel inheritance, ``None`` for
+            local columns.
     """
     def __init__(self, name, column, parent_model=None, parent_column=None, original_parent=None):
         self.name = name
@@ -1601,5 +1614,10 @@
         self.parent_column = parent_column
         self.original_parent = original_parent
 
+    def __str__(self):
+        return '%s(%s, %s, %s, %s, %s)' % (
+            self.__name__, self.name, self.column,
+            self.parent_model, self.parent_column, self.original_parent)
+
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 

=== modified file 'openerp/osv/orm.py'
--- openerp/osv/orm.py	2012-10-01 15:37:53 +0000
+++ openerp/osv/orm.py	2012-10-08 13:46:29 +0000
@@ -42,6 +42,7 @@
 """
 
 import calendar
+import collections
 import copy
 import datetime
 import itertools
@@ -53,18 +54,21 @@
 import time
 import traceback
 import types
+
+import psycopg2
 from lxml import etree
+import warnings
 
 import fields
 import openerp
 import openerp.netsvc as netsvc
 import openerp.tools as tools
 from openerp.tools.config import config
+from openerp.tools.misc import CountingStream
 from openerp.tools.safe_eval import safe_eval as eval
 from openerp.tools.translate import _
 from openerp import SUPERUSER_ID
 from query import Query
-from openerp import SUPERUSER_ID
 
 _logger = logging.getLogger(__name__)
 _schema = logging.getLogger(__name__ + '.schema')
@@ -1217,7 +1221,11 @@
         return {'datas': datas}
 
     def import_data(self, cr, uid, fields, datas, mode='init', current_module='', noupdate=False, context=None, filename=None):
-        """Import given data in given module
+        """
+        .. deprecated:: 7.0
+            Use :meth:`~load` instead
+
+        Import given data in given module
 
         This method is used when importing data via client menu.
 
@@ -1245,7 +1253,7 @@
         * The last item is currently unused, with no specific semantics
 
         :param fields: list of fields to import
-        :param data: data to import
+        :param datas: data to import
         :param mode: 'init' or 'update' for record creation
         :param current_module: module name
         :param noupdate: flag for record creation
@@ -1253,194 +1261,264 @@
         :returns: 4-tuple in the form (return_code, errored_resource, error_message, unused)
         :rtype: (int, dict or 0, str or 0, str or 0)
         """
-        if not context:
-            context = {}
+        context = dict(context) if context is not None else {}
+        context['_import_current_module'] = current_module
+
         fields = map(fix_import_export_id_paths, fields)
         ir_model_data_obj = self.pool.get('ir.model.data')
 
-        # mode: id (XML id) or .id (database id) or False for name_get
-        def _get_id(model_name, id, current_module=False, mode='id'):
-            if mode=='.id':
-                id = int(id)
-                obj_model = self.pool.get(model_name)
-                ids = obj_model.search(cr, uid, [('id', '=', int(id))])
-                if not len(ids):
-                    raise Exception(_("Database ID doesn't exist: %s : %s") %(model_name, id))
-            elif mode=='id':
-                if '.' in id:
-                    module, xml_id = id.rsplit('.', 1)
-                else:
-                    module, xml_id = current_module, id
-                record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
-                ir_model_data = ir_model_data_obj.read(cr, uid, [record_id], ['res_id'])
-                if not ir_model_data:
-                    raise ValueError('No references to %s.%s' % (module, xml_id))
-                id = ir_model_data[0]['res_id']
-            else:
-                obj_model = self.pool.get(model_name)
-                ids = obj_model.name_search(cr, uid, id, operator='=', context=context)
-                if not ids:
-                    raise ValueError('No record found for %s' % (id,))
-                id = ids[0][0]
-            return id
-
-        # IN:
-        #   datas: a list of records, each record is defined by a list of values
-        #   prefix: a list of prefix fields ['line_ids']
-        #   position: the line to process, skip is False if it's the first line of the current record
-        # OUT:
-        #   (res, position, warning, res_id) with
-        #     res: the record for the next line to process (including it's one2many)
-        #     position: the new position for the next line
-        #     res_id: the ID of the record if it's a modification
-        def process_liness(self, datas, prefix, current_module, model_name, fields_def, position=0, skip=0):
-            line = datas[position]
-            row = {}
-            warning = []
-            data_res_id = False
-            xml_id = False
-            nbrmax = position+1
-
-            done = {}
-            for i, field in enumerate(fields):
-                res = False
-                if i >= len(line):
-                    raise Exception(_('Please check that all your lines have %d columns.'
-                        'Stopped around line %d having %d columns.') % \
-                            (len(fields), position+2, len(line)))
-                if not line[i]:
-                    continue
-
-                if field[:len(prefix)] != prefix:
-                    if line[i] and skip:
-                        return False
-                    continue
-                field_name = field[len(prefix)]
-
-                #set the mode for m2o, o2m, m2m : xml_id/id/name
-                if len(field) == len(prefix)+1:
-                    mode = False
-                else:
-                    mode = field[len(prefix)+1]
-
-                # TODO: improve this by using csv.csv_reader
-                def many_ids(line, relation, current_module, mode):
-                    res = []
-                    for db_id in line.split(config.get('csv_internal_sep')):
-                        res.append(_get_id(relation, db_id, current_module, mode))
-                    return [(6,0,res)]
-
-                # ID of the record using a XML ID
-                if field_name == 'id':
-                    try:
-                        data_res_id = _get_id(model_name, line[i], current_module)
-                    except ValueError:
-                        pass
-                    xml_id = line[i]
-                    continue
-
-                # ID of the record using a database ID
-                elif field_name == '.id':
-                    data_res_id = _get_id(model_name, line[i], current_module, '.id')
-                    continue
-
-                field_type = fields_def[field_name]['type']
-                # recursive call for getting children and returning [(0,0,{})] or [(1,ID,{})]
-                if field_type == 'one2many':
-                    if field_name in done:
-                        continue
-                    done[field_name] = True
-                    relation = fields_def[field_name]['relation']
-                    relation_obj = self.pool.get(relation)
-                    newfd = relation_obj.fields_get( cr, uid, context=context )
-                    pos = position
-
-                    res = []
-
-                    first = 0
-                    while pos < len(datas):
-                        res2 = process_liness(self, datas, prefix + [field_name], current_module, relation_obj._name, newfd, pos, first)
-                        if not res2:
-                            break
-                        (newrow, pos, w2, data_res_id2, xml_id2) = res2
-                        nbrmax = max(nbrmax, pos)
-                        warning += w2
-                        first += 1
-
-                        if (not newrow) or not reduce(lambda x, y: x or y, newrow.values(), 0):
-                            break
-
-                        res.append( (data_res_id2 and 1 or 0, data_res_id2 or 0, newrow) )
-
-                elif field_type == 'many2one':
-                    relation = fields_def[field_name]['relation']
-                    res = _get_id(relation, line[i], current_module, mode)
-
-                elif field_type == 'many2many':
-                    relation = fields_def[field_name]['relation']
-                    res = many_ids(line[i], relation, current_module, mode)
-
-                elif field_type == 'integer':
-                    res = line[i] and int(line[i]) or 0
-                elif field_type == 'boolean':
-                    res = line[i].lower() not in ('0', 'false', 'off')
-                elif field_type == 'float':
-                    res = line[i] and float(line[i]) or 0.0
-                elif field_type == 'selection':
-                    for key, val in fields_def[field_name]['selection']:
-                        if tools.ustr(line[i]) in [tools.ustr(key), tools.ustr(val)]:
-                            res = key
-                            break
-                    if line[i] and not res:
-                        _logger.warning(
-                            _("key '%s' not found in selection field '%s'"),
-                            tools.ustr(line[i]), tools.ustr(field_name))
-                        warning.append(_("Key/value '%s' not found in selection field '%s'") % (
-                            tools.ustr(line[i]), tools.ustr(field_name)))
-
-                else:
-                    res = line[i]
-
-                row[field_name] = res or False
-
-            return row, nbrmax, warning, data_res_id, xml_id
-
-        fields_def = self.fields_get(cr, uid, context=context)
-
-        position = 0
+        def log(m):
+            if m['type'] == 'error':
+                raise Exception(m['message'])
+
         if config.get('import_partial') and filename:
             with open(config.get('import_partial'), 'rb') as partial_import_file:
                 data = pickle.load(partial_import_file)
                 position = data.get(filename, 0)
 
-        while position<len(datas):
-            (res, position, warning, res_id, xml_id) = \
-                    process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
-            if len(warning):
-                cr.rollback()
-                return -1, res, 'Line ' + str(position) +' : ' + '!\n'.join(warning), ''
-
-            try:
+        position = 0
+        try:
+            for res_id, xml_id, res, info in self._convert_records(cr, uid,
+                            self._extract_records(cr, uid, fields, datas,
+                                                  context=context, log=log),
+                            context=context, log=log):
                 ir_model_data_obj._update(cr, uid, self._name,
                      current_module, res, mode=mode, xml_id=xml_id,
                      noupdate=noupdate, res_id=res_id, context=context)
-            except Exception, e:
-                return -1, res, 'Line ' + str(position) + ' : ' + tools.ustr(e), ''
-
-            if config.get('import_partial') and filename and (not (position%100)):
-                with open(config.get('import_partial'), 'rb') as partial_import:
-                    data = pickle.load(partial_import)
-                data[filename] = position
-                with open(config.get('import_partial'), 'wb') as partial_import:
-                    pickle.dump(data, partial_import)
-                if context.get('defer_parent_store_computation'):
-                    self._parent_store_compute(cr)
-                cr.commit()
+                position = info.get('rows', {}).get('to', 0) + 1
+                if config.get('import_partial') and filename and (not (position%100)):
+                    with open(config.get('import_partial'), 'rb') as partial_import:
+                        data = pickle.load(partial_import)
+                    data[filename] = position
+                    with open(config.get('import_partial'), 'wb') as partial_import:
+                        pickle.dump(data, partial_import)
+                    if context.get('defer_parent_store_computation'):
+                        self._parent_store_compute(cr)
+                    cr.commit()
+        except Exception, e:
+            cr.rollback()
+            return -1, {}, 'Line %d : %s' % (position + 1, tools.ustr(e)), ''
 
         if context.get('defer_parent_store_computation'):
             self._parent_store_compute(cr)
         return position, 0, 0, 0
 
+    def load(self, cr, uid, fields, data, context=None):
+        """
+        Attempts to load the data matrix, and returns a list of ids (or
+        ``False`` if there was an error and no id could be generated) and a
+        list of messages.
+
+        The ids are those of the records created and saved (in database), in
+        the same order they were extracted from the file. They can be passed
+        directly to :meth:`~read`
+
+        :param fields: list of fields to import, at the same index as the corresponding data
+        :type fields: list(str)
+        :param data: row-major matrix of data to import
+        :type data: list(list(str))
+        :param dict context:
+        :returns: {ids: list(int)|False, messages: [Message]}
+        """
+        cr.execute('SAVEPOINT model_load')
+        messages = []
+
+        fields = map(fix_import_export_id_paths, fields)
+        ModelData = self.pool['ir.model.data']
+        fg = self.fields_get(cr, uid, context=context)
+
+        mode = 'init'
+        current_module = ''
+        noupdate = False
+
+        ids = []
+        for id, xid, record, info in self._convert_records(cr, uid,
+                self._extract_records(cr, uid, fields, data,
+                                      context=context, log=messages.append),
+                context=context, log=messages.append):
+            try:
+                cr.execute('SAVEPOINT model_load_save')
+            except psycopg2.InternalError, e:
+                # broken transaction, exit and hope the source error was
+                # already logged
+                if not any(message['type'] == 'error' for message in messages):
+                    messages.append(dict(info, type='error',message=
+                        u"Unknown database error: '%s'" % e))
+                break
+            try:
+                ids.append(ModelData._update(cr, uid, self._name,
+                     current_module, record, mode=mode, xml_id=xid,
+                     noupdate=noupdate, res_id=id, context=context))
+                cr.execute('RELEASE SAVEPOINT model_load_save')
+            except psycopg2.Warning, e:
+                cr.execute('ROLLBACK TO SAVEPOINT model_load_save')
+                messages.append(dict(info, type='warning', message=str(e)))
+            except psycopg2.Error, e:
+                # Failed to write, log to messages, rollback savepoint (to
+                # avoid broken transaction) and keep going
+                cr.execute('ROLLBACK TO SAVEPOINT model_load_save')
+                messages.append(dict(
+                    info, type='error',
+                    **PGERROR_TO_OE[e.pgcode](self, fg, info, e)))
+        if any(message['type'] == 'error' for message in messages):
+            cr.execute('ROLLBACK TO SAVEPOINT model_load')
+            ids = False
+        return {'ids': ids, 'messages': messages}
+    def _extract_records(self, cr, uid, fields_, data,
+                         context=None, log=lambda a: None):
+        """ Generates record dicts from the data sequence.
+
+        The result is a generator of dicts mapping field names to raw
+        (unconverted, unvalidated) values.
+
+        For relational fields, if sub-fields were provided the value will be
+        a list of sub-records
+
+        The following sub-fields may be set on the record (by key):
+        * None is the name_get for the record (to use with name_create/name_search)
+        * "id" is the External ID for the record
+        * ".id" is the Database ID for the record
+        """
+        columns = dict((k, v.column) for k, v in self._all_columns.iteritems())
+        # Fake columns to avoid special cases in extractor
+        columns[None] = fields.char('rec_name')
+        columns['id'] = fields.char('External ID')
+        columns['.id'] = fields.integer('Database ID')
+
+        # m2o fields can't be on multiple lines so exclude them from the
+        # is_relational field rows filter, but special-case it later on to
+        # be handled with relational fields (as it can have subfields)
+        is_relational = lambda field: columns[field]._type in ('one2many', 'many2many', 'many2one')
+        get_o2m_values = itemgetter_tuple(
+            [index for index, field in enumerate(fields_)
+                  if columns[field[0]]._type == 'one2many'])
+        get_nono2m_values = itemgetter_tuple(
+            [index for index, field in enumerate(fields_)
+                  if columns[field[0]]._type != 'one2many'])
+        # Checks if the provided row has any non-empty non-relational field
+        def only_o2m_values(row, f=get_nono2m_values, g=get_o2m_values):
+            return any(g(row)) and not any(f(row))
+
+        index = 0
+        while True:
+            if index >= len(data): return
+
+            row = data[index]
+            # copy non-relational fields to record dict
+            record = dict((field[0], value)
+                for field, value in itertools.izip(fields_, row)
+                if not is_relational(field[0]))
+
+            # Get all following rows which have relational values attached to
+            # the current record (no non-relational values)
+            record_span = itertools.takewhile(
+                only_o2m_values, itertools.islice(data, index + 1, None))
+            # stitch record row back on for relational fields
+            record_span = list(itertools.chain([row], record_span))
+            for relfield in set(
+                    field[0] for field in fields_
+                             if is_relational(field[0])):
+                column = columns[relfield]
+                # FIXME: how to not use _obj without relying on fields_get?
+                Model = self.pool[column._obj]
+
+                # get only cells for this sub-field, should be strictly
+                # non-empty, field path [None] is for name_get column
+                indices, subfields = zip(*((index, field[1:] or [None])
+                                           for index, field in enumerate(fields_)
+                                           if field[0] == relfield))
+
+                # return all rows which have at least one value for the
+                # subfields of relfield
+                relfield_data = filter(any, map(itemgetter_tuple(indices), record_span))
+                record[relfield] = [subrecord
+                    for subrecord, _subinfo in Model._extract_records(
+                        cr, uid, subfields, relfield_data,
+                        context=context, log=log)]
+
+            yield record, {'rows': {
+                'from': index,
+                'to': index + len(record_span) - 1
+            }}
+            index += len(record_span)
+    def _convert_records(self, cr, uid, records,
+                         context=None, log=lambda a: None):
+        """ Converts records from the source iterable (recursive dicts of
+        strings) into forms which can be written to the database (via
+        self.create or (ir.model.data)._update)
+
+        :returns: a list of triplets of (id, xid, record)
+        :rtype: list((int|None, str|None, dict))
+        """
+        if context is None: context = {}
+        Converter = self.pool['ir.fields.converter']
+        columns = dict((k, v.column) for k, v in self._all_columns.iteritems())
+        Translation = self.pool['ir.translation']
+        field_names = dict(
+            (f, (Translation._get_source(cr, uid, self._name + ',' + f, 'field',
+                                         context.get('lang'))
+                 or column.string or f))
+            for f, column in columns.iteritems())
+        converters = dict(
+            (k, Converter.to_field(cr, uid, self, column, context=context))
+            for k, column in columns.iteritems())
+
+        def _log(base, field, exception):
+            type = 'warning' if isinstance(exception, Warning) else 'error'
+            record = dict(base, field=field, type=type,
+                          message=unicode(exception.args[0]) % base)
+            if len(exception.args) > 1 and exception.args[1]:
+                record.update(exception.args[1])
+            log(record)
+
+        stream = CountingStream(records)
+        for record, extras in stream:
+            dbid = False
+            xid = False
+            converted = {}
+            # name_get/name_create
+            if None in record: pass
+            # xid
+            if 'id' in record:
+                xid = record['id']
+            # dbid
+            if '.id' in record:
+                try:
+                    dbid = int(record['.id'])
+                except ValueError:
+                    # in case of overridden id column
+                    dbid = record['.id']
+                if not self.search(cr, uid, [('id', '=', dbid)], context=context):
+                    log(dict(extras,
+                        type='error',
+                        record=stream.index,
+                        field='.id',
+                        message=_(u"Unknown database identifier '%s'") % dbid))
+                    dbid = False
+
+            for field, strvalue in record.iteritems():
+                if field in (None, 'id', '.id'): continue
+                if not strvalue:
+                    continue
+
+                # In warnings and error messages, use translated string as
+                # field name
+                message_base = dict(
+                    extras, record=stream.index, field=field_names[field])
+                try:
+                    converted[field], ws = converters[field](strvalue)
+
+                    for w in ws:
+                        if isinstance(w, basestring):
+                            # wrap warning string in an ImportWarning for
+                            # uniform handling
+                            w = ImportWarning(w)
+                        _log(message_base, field, w)
+                except ValueError, e:
+                    _log(message_base, field, e)
+
+            yield dbid, xid, converted, dict(extras, record=stream.index)
+
     def get_invalid_fields(self, cr, uid):
         return list(self._invalids)
 
@@ -4976,7 +5054,7 @@
     def is_transient(self):
         """ Return whether the model is transient.
 
-        See TransientModel.
+        See :class:`TransientModel`.
 
         """
         return self._transient
@@ -5118,5 +5196,39 @@
     _auto = False # don't create any database backend for AbstractModels
     _register = False # not visible in ORM registry, meant to be python-inherited only
 
-
+def itemgetter_tuple(items):
+    """ Fixes itemgetter inconsistency (useful in some cases) of not returning
+    a tuple if len(items) == 1: always returns an n-tuple where n = len(items)
+    """
+    if len(items) == 0:
+        return lambda a: ()
+    if len(items) == 1:
+        return lambda gettable: (gettable[items[0]],)
+    return operator.itemgetter(*items)
+class ImportWarning(Warning):
+    """ Used to send warnings upwards the stack during the import process
+    """
+    pass
+
+
+def convert_pgerror_23502(model, fields, info, e):
+    m = re.match(r'^null value in column "(?P<field>\w+)" violates '
+                 r'not-null constraint\n',
+                 str(e))
+    if not m or m.group('field') not in fields:
+        return {'message': unicode(e)}
+    field = fields[m.group('field')]
+    return {
+        'message': _(u"Missing required value for the field '%(field)s'") % {
+            'field': field['string']
+        },
+        'field': m.group('field'),
+    }
+
+PGERROR_TO_OE = collections.defaultdict(
+    # shape of mapped converters
+    lambda: (lambda model, fvg, info, pgerror: {'message': unicode(pgerror)}), {
+    # not_null_violation
+    '23502': convert_pgerror_23502,
+})
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== modified file 'openerp/osv/query.py'
--- openerp/osv/query.py	2011-06-23 09:03:57 +0000
+++ openerp/osv/query.py	2012-10-08 13:46:29 +0000
@@ -73,15 +73,15 @@
         :param connection: a tuple ``(lhs, table, lhs_col, col)``.
                            The join corresponds to the SQL equivalent of::
 
-                                ``(lhs.lhs_col = table.col)``
+                               (lhs.lhs_col = table.col)
 
         :param outer: True if a LEFT OUTER JOIN should be used, if possible
                       (no promotion to OUTER JOIN is supported in case the JOIN
-                       was already present in the query, as for the moment
-                       implicit INNER JOINs are only connected from NON-NULL
-                       columns so it would not be correct (e.g. for
-                       ``_inherits`` or when a domain criterion explicitly
-                       adds filtering)
+                      was already present in the query, as for the moment
+                      implicit INNER JOINs are only connected from NON-NULL
+                      columns so it would not be correct (e.g. for
+                      ``_inherits`` or when a domain criterion explicitly
+                      adds filtering)
         """
         (lhs, table, lhs_col, col) = connection
         lhs = _quote(lhs)
@@ -120,4 +120,4 @@
     def __str__(self):
         return '<osv.Query: "SELECT ... FROM %s WHERE %s" with params: %r>' % self.get_sql()
 
-# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== modified file 'openerp/sql_db.py'
--- openerp/sql_db.py	2012-02-06 20:31:51 +0000
+++ openerp/sql_db.py	2012-10-08 13:46:29 +0000
@@ -138,6 +138,16 @@
         sure you use psycopg2 v2.4.2 or newer if you use PostgreSQL 9.1 and
         the performance hit is a concern for you.
 
+        .. attribute:: cache
+
+            Cache dictionary with a "request" (-ish) lifecycle, only lives as
+            long as the cursor itself does and proactively cleared when the
+            cursor is closed.
+
+            This cache should *only* be used to store repeatable reads as it
+            ignores rollbacks and savepoints, it should not be used to store
+            *any* data which may be modified during the life of the cursor.
+
     """
     IN_MAX = 1000 # decent limit on size of IN queries - guideline = Oracle limit
 
@@ -182,6 +192,8 @@
 
         self._default_log_exceptions = True
 
+        self.cache = {}
+
     def __del__(self):
         if not self.__closed and not self._cnx.closed:
             # Oops. 'self' has not been closed explicitly.
@@ -279,6 +291,8 @@
         if not self._obj:
             return
 
+        del self.cache
+
         if self.sql_log:
             self.__closer = frame_codeinfo(currentframe(),3)
         self.print_log()

=== modified file 'openerp/tests/addons/test_impex/models.py'
--- openerp/tests/addons/test_impex/models.py	2012-08-07 14:37:44 +0000
+++ openerp/tests/addons/test_impex/models.py	2012-10-08 13:46:29 +0000
@@ -17,11 +17,12 @@
     ('float', fields.float()),
     ('decimal', fields.float(digits=(16, 3))),
     ('string.bounded', fields.char('unknown', size=16)),
+    ('string.required', fields.char('unknown', size=None, required=True)),
     ('string', fields.char('unknown', size=None)),
     ('date', fields.date()),
     ('datetime', fields.datetime()),
     ('text', fields.text()),
-    ('selection', fields.selection([(1, "Foo"), (2, "Bar"), (3, "Qux")])),
+    ('selection', fields.selection([(1, "Foo"), (2, "Bar"), (3, "Qux"), (4, '')])),
     ('selection.function', fields.selection(selection_fn)),
     # just relate to an integer
     ('many2one', fields.many2one('export.integer')),
@@ -67,6 +68,12 @@
     def name_get(self, cr, uid, ids, context=None):
         return [(record.id, "%s:%s" % (self._name, record.value))
             for record in self.browse(cr, uid, ids, context=context)]
+    def name_search(self, cr, user, name='', args=None, operator='ilike', context=None, limit=100):
+        return (self.name_get(cr, user,
+                self.search(cr, user, [['value', operator, int(name.split(':')[1])]])
+                , context=context)
+            if isinstance(name, basestring) and name.split(':')[0] == self._name
+            else [])
 
 class One2ManyMultiple(orm.Model):
     _name = 'export.one2many.multiple'
@@ -116,3 +123,13 @@
                     , context=context)
                 if isinstance(name, basestring) and name.split(':')[0] == self._name
                 else [])
+
+class SelectionWithDefault(orm.Model):
+    _name = 'export.selection.withdefault'
+
+    _columns = {
+        'value': fields.selection([(1, "Foo"), (2, "Bar")], required=True),
+    }
+    _defaults = {
+        'value': 2,
+    }

=== modified file 'openerp/tests/addons/test_impex/tests/__init__.py'
--- openerp/tests/addons/test_impex/tests/__init__.py	2012-08-07 14:37:44 +0000
+++ openerp/tests/addons/test_impex/tests/__init__.py	2012-10-08 13:46:29 +0000
@@ -1,6 +1,6 @@
 # -*- coding: utf-8 -*-
 
-from . import test_export, test_import
+from . import test_export, test_import, test_load
 
 fast_suite = [
 ]
@@ -8,6 +8,7 @@
 checks = [
     test_export,
     test_import,
+    test_load,
 ]
 
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'openerp/tests/addons/test_impex/tests/contacts_big.json'
--- openerp/tests/addons/test_impex/tests/contacts_big.json	1970-01-01 00:00:00 +0000
+++ openerp/tests/addons/test_impex/tests/contacts_big.json	2012-10-08 13:46:29 +0000
@@ -0,0 +1,1 @@
+[["Zahm", "", "agathe.zahm@xxxxxxxxxxxxxxxx", ""], ["RIVES", "04.91.39.59.25", "catherine.rives@xxxxxxxxxxxxxxxxxx", ""], ["OLIVERES", "04 91 39 59 00", "christian.oliveres@xxxxxxxxxxxxxxxxxx", ""], ["ROMAN", "04 91 39 59 24", "christian.roman@xxxxxxxxxxxxxxxxxx", ""], ["CATAIX", "01 58 50 86 37", "helene.cataix@xxxxxxxxxxxxxxxxxx", ""], ["COULHON", "04 91 39 59 34", "Isabelle.coulhon@xxxxxxxxxxxxxxxxxx", ""], ["TERRASSE", "04 91 35 59 56", "jacques.terrasse@xxxxxxxxxxxxxxxxxx", ""], ["GUERIN", "04 91 39 59 01", "jean-paul.guerin@xxxxxxxxxxxxxxxxxx", ""], ["SAINT-OLIVE", "01 58 50 71 80", "marc.saintolive@xxxxxxxxxxxxxxxxxx", ""], ["MEYNARD", "04 91 39 59 53", "marie-therese.meynard@xxxxxxxxxxxxxxxxxx", ""], ["DUGRAVOT", "04 91 39 59 21", "michel.dugravot@xxxxxxxxxxxxxxxxxx", ""], ["BENSOUSSAN", "04 92 17 64 43", "claude.bensoussan@xxxxxxxxxxxxxxx", ""], ["RONAL", "04 96 17 06 31", "frederic.ronal@xxxxxxxxxxxxxxx", ""], ["MILLET", "04 92 17 64 41", "genevieve.millet@xxxxxxxxxxxxxxx", ""], ["PERRIN", "04 42 52 78 09", "armand.perrin@xxxxxxxxxxxxxxxxxxx", ""], ["POUZET", "04 42 52 77 07", "cap.marc.pouzet@xxxxxxxxxx", ""], ["BARNETCHE", "04 91 33 95 06", "jeanpierre.barnetche@xxxxxxxxxxxxxxxxxxx", ""], ["BOURDILLON", "04 91 33 95 08", "thierry.bourdillon@xxxxxxxxxxxxxxxxxxx", ""], ["LAPORTE", "08 11 01 07 60", "pierre.laporte@xxxxxxxxx", ""], ["SCHWARTZ", "04 94 84 47 00", "yves.schwartz@xxxxxxxxx", ""], ["DELAYE", "04 94 01 74 40", "bernard.delaye@xxxxxxxxx", ""], ["BELLIER", "", "claude.bellier@xxxxxx", ""], ["LECENES", "04 96 11 44 23", "michele.lecenes@xxxxxx", ""], ["BABIC", "04 42 07 25 02", "babicyv@xxxxxxxxxxxxxxxxxxx", ""], ["DONAHUE", "04 91 32 16 53", "charlotte.donahue@xxxxxxxx", ""], ["CARDUNER", "04 91 32 16 50", "herve.carduner@xxxxxxxxxxxxxxxxx", ""], ["VANDAELE", "04.42.94.02.33", "stephane.vandaele@xxxxxxxxxxxxx", ""], ["LEFEVRE", "", "christophe.lefevre@xxxxxxxxxxxxx", ""], ["VILLIER", "(04) 42 34 43 05", "patrice.villier@xxxxxxxxxxxx", ""], ["DELIEUVIN", "", "jean-marcel.delieuvin@xxxxxxxx", ""], ["MOLENAT", "04 42 85 79 12", "marc.molenat@xxxxxxxxxxxxxx", ""], ["LESBROS", "04 95 09 41 75", "patrick.lesbros@xxxxxx", ""], ["TORRION", "(04) 91 29 70 01", "philippe.torrion@xxxxxx", ""], ["BLANC-PATIN", "04 91 23 98 20", "christine.blanc.patin@xxxxxxxxx", ""], ["CORNAIRE", "04 91 23 98 22", "frederic.cornaire@xxxxxxxxx", ""], ["PROST", "04 91 23 98 79", "geraldine.prost@xxxxxxxxx", ""], ["MAGNAN", "04 91 23 98 10", "jerome.magnan@xxxxxxxxx", ""], ["FARAILL", "04 97 12 80 12", "jeanluc.faraill@xxxxxxxxxxxxxxxxx", ""], ["OLIVA", "04 91 28 33 09", "serge.oliva@xxxxxxxxxxxxxxx", ""], ["VENDEMBILQUE", "04 42 02 98 60", "audrey.vendembilque@xxxxxxxxxxx", ""], ["DAUBENFELDT", "04 42 02 98 60", "frederic.daubenfeldt@xxxxxxxxxxx", ""], ["STASIA", "04 42 02 98 60", "jacques.stasia@xxxxxxxxxxx", ""], ["TORDO", "04 93 22 22 04", "c-tordo@xxxxxx", ""], ["GRANIANI", "", "caroline.clares@xxxxxxx", ""], ["BERAUD", "04 91 61 58 00", "gilbert.beraud@xxxxxxx", ""], ["BAKONYI", "", "Jean-Christophe.Bakonyi@xxxxxxxxxx", ""], ["DEROLLEPOT", "04 92 17 58 23", "thierry.derollepot@xxxxxxxxxx", ""], ["GUIGON", "04 91 23 56 24", "muriel.guigon@xxxxxxxxxx", ""], ["HELY", "04 92 17 58 24", "cyril.hely@xxxxxxxxxx", ""], ["BRUGIERE", "04 90 14 93 94", "chantal.brugiere@xxxxxx", ""], ["COULOMBON", "04 91 13 33 73", "eric.coulombon@xxxxxx", ""], ["FEUTRY", "04 91 13 55 01", "dominique.feutry@xxxxxx", ""], ["LAILHACAR", "04 91 13 34 69", "didier.lailhacar@xxxxxx", ""], ["PAPAZIAN", "04 91 13 32 22", "francis.papazian@xxxxxx", ""], ["SKEIF", "04 91 13 34 24", "alexandra.skeif@xxxxxx", ""], ["LAMAURY", "", "pascal.lamaury@xxxxxxxxxxxxxxxxxx", ""], ["REBIFFE", "01 41 24 59 12", "eric.rebiffe@xxxxxxxxxxxxxxxxxx", ""], ["SAVINEL", "04 91 11 10 05", "philippe.savinel@xxxxxxxxx", ""], ["AUDIER", "04 91 57 67 69", "jean-louis.audier@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["COSTE", "04 96 20 83 16", "celine.coste@xxxxxxxxxxxxxxxxxxxxxxxx", ""], ["TROUSSIER", "04 94 92 60 96", "eric.troussier@xxxxxxxxxx", ""], ["VIGNES", "04 91 34 82 20", "conseilp@xxxxxxxxxx", ""], ["BALLESTER", "04 67 15 80 42", "sylvain.ballester@xxxxxxxxxxxxxxx", ""], ["VOLLE", "04 67 15 80 42", "frederic.volle@xxxxxxxxxxxxxxx", ""], ["BENEGLIA", "04 94 91 99 94", "var@xxxxxxxxxxxxxxxxx", ""], ["BOYER", "", "bgvar@xxxxxxx", ""], ["TORRE", "04 94 91 99 94", "bgvar83@xxxxxxx", ""], ["FIORI", "04 91 85 59 61", "cfiori@xxxxxxxxxxxxxx", ""], ["KRAMEL", "04 91 85 59 61", "akramel@xxxxxxxxxxxxxx", ""], ["CAMPELLO", "04 89 60 30 55", "o.campello@xxxxxxxxxxxxxxxxxxxx", ""], ["PERROT", "04 72 00 11 41", "bp@xxxxxxxxxxxxxxxx", ""], ["BICAS", "04 91 17 68 20", "jean-bernard.bicas@xxxxxxx", ""], ["MAZOYER", "", "eric@xxxxxxxxx", ""], ["WIJERS", "04 93 00 60 77", "bella.wijers@xxxxxxxxxx", ""], ["PIQUAND", "04 66 88 08 80", "l.piquand@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["NYSSEN", "04 90 49 86 91", "f.nyssen@xxxxxxxxxxxx", ""], ["WATTEL", "04 91 62 55 19", "fr.wattel@xxxxxxxxxx", ""], ["DAIKHI", "", "hinda.daikhi@xxxxxxxx", ""], ["OLIVE", "04 91 59 82 80", "folive-adije@xxxxxxxxxx", ""], ["THERON", "06 08 56 80 78", "frederic.theron@xxxxxxxxxxx", ""], ["MILLOUR", "", "dominiquemillour@xxxxxxxxx", ""], ["CAPRISTO", "04 90 44 85 85", "nicolas.capristo@xxxxxxxxxxxxxxxxxxxxxx", ""], ["DEFOUR", "04 90 44 77 40", "bruno.defour@xxxxxxxxxxxxxxxxxxxxxx", ""], ["CLAIR", "", "claude.clair@xxxxxxxxx", ""], ["KLEIN", "04 94 10 73 11", "monburo@xxxxxxxxxx", ""], ["EMPRIN", "", "cemprin@xxxxxxxxxxxxxxxxxx", ""], ["FAYOLLE", "04 90 82 94 32", "philippefayolle@xxxxxxxxx", ""], ["HANRAS", "", "contact@xxxxxxxxxxxxxxxxxxxxx", ""], ["MONTRE", "04 93 80 87 96", "bmontre@xxxxxxxxxx", ""], ["GRANGIER", "04 92 36 62 40", "s.isoard.mairiedigne@xxxxxxx", ""], ["ISNARD", "04 42 98 00 25", "aude.isnard@xxxxxxxxxx", ""], ["LESAY", "04 42 98 00 25", "eric.lesay@xxxxxxxxxx", ""], ["MORIN", "", "omorin@xxxxxxxxxx", ""], ["GUIVARC'H", "", "yvesguivarch@xxxxxxxxxxxxxx", ""], ["HIRZMANN", "04 97 23 08 37", "claus.hirzmann@xxxxxxxxxxx", ""], ["BOUTIN", "04 95 08 00 40", "amd-routage@xxxxxxxxxx", ""], ["LE GALLES", "", "xlegalles@xxxxxxxxxx", ""], ["DERBES", "06 17 55 03 56", "ercadres.06331@xxxxxxx", ""], ["POTIE", "", "normandie-eure@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["CARVIN", "", "denis.carvin@xxxxxxxxxx", ""], ["LANCA", "04 91 39 33 91", "contact@xxxxxxxxxxxxxxxxxx", ""], ["DOUIX", "04 94 32 02 91", "afdouix@xxxxxxx", ""], ["MARON", "", "aptinitiative@xxxxxxxxxxxxxx", ""], ["TESTA", "04 42 82 16 95", "a.testa@xxxxxxxxxxxxxxxxxxxx", ""], ["AUGER", "0442 53 81 50", "contact@xxxxxxxxxx", ""], ["PEYRE", "04 90 14 98 99", "lpeyre@xxxxxxxxxxxx", ""], ["SITRI", "04 96 20 84 84", "david.sitri@xxxxxxxxxxxxxx", ""], ["BLANCHOT-COURTOIS", "", "vbc@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["BLANDEL", "04 93 00 07 87", "ablandel@xxxxxxxxxxxxxxxxx", ""], ["MOREAU", "04 97 21 41 26", "bruno.moreau@xxxxxx", ""], ["MONCOUDIOL", "04 94 24 25 36", "olivier.moncoudiol@xxxxxxxxxxxxxx", ""], ["FONTAINE", "04 42 24 40 26", "pf.asso.entreprises@xxxxxxxxxx", ""], ["PAPADOPOULOS", "", "robert.papadopoulos@xxxxxxxxxx", ""], ["VANDENBROUCK", "04 91 02 83 03", "arnavant@xxxxxxxxxx", ""], ["CHAMP", "04 94 22 61 40", "secretairedirtechnologies@xxxxxxxxxxxx", ""], ["AKNIN", "04 95 06 99 99", "raknin@xxxxxxxx", ""], ["DELMAS", "04 94 91 02 02", "e.delmas@xxxxxxxxxxxxxxxxx", ""], ["ABRIAL", "04 42 47 11 11", "cabrial@xxxxxxxxx", ""], ["LOMBARDO", "04 91 56 03 03", "laurent.lombardo@xxxxxxxxxxxx", ""], ["CASTAING", "04 91 50 79 41", "adn@xxxxxxxxxxxxxxxxxxxx", ""], ["BEURNIER", "04 91 11 19 19", "jdbeurnier@xxxxxxxxxxxxxxxxx", ""], ["GRANERAU", "04 91 01 25 23", "agence.granerau@xxxxxx", ""], ["LAFAYSSE", "04 91 10 79 70", "jacques.lafaysse@xxxxxxxxxxx", ""], ["VANNER", "04 92 12 45 60", "jjvanner@xxxxxxxxxxxxxxx", ""], ["LANDES", "", "rh.landes@xxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["LAUDET", "04 42 08 86 19", "matthieu_laudet@xxxxxxxxxxxxxxx", ""], ["MOURALIS", "04 90 27 27 89", "fmouralis@xxxxxxxxxxxxxxx", ""], ["ODDO", "04 90 13 53 55", "jjoddo@xxxxxxxxxxxxxxx", ""], ["PATILLON", "04 91 86 40 10", "marseille.foch@xxxxxxxxxxxxxxx", ""], ["BERGER", "04 93 13 54 11", "patrick.berger@xxxxxxxxxxxxxxxx", ""], ["BRUNET", "04 91 04 10 40", "lionel.brunet@xxxxxxxxxxxxxxxx", ""], ["JUBIN", "04 91 04 10 92", "jean-pierre.jubin@xxxxxxxxxxxxxxxx", ""], ["BERINO", "04 91 53 28 98", "pberino@xxxxxxxxxxxxxxxx", ""], ["DE BOISSEZON", "04 91 04 83 06", "ldeboissezon@xxxxxxxxxxxxxxxx", ""], ["DELHOMME", "04 91 04 83 16", "pdelhomme@xxxxxxxxxxxxxxxx", ""], ["FORCANS", "04 91 04 81 33", "cforcans@xxxxxxxxxxxxxxxx", ""], ["LAMANT", "04 91 04 81 79", "jeannelamant@xxxxxxxxxxxxxxxx", ""], ["VALLAT", "04 91 04 81 88", "avallat@xxxxxxxxxxxxxxxx", ""], ["MARTINEZ", "04 93 21 56 74", "gilles.martinez@xxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["CASCONE", "04 91 17 66 57", "sauveur.cascone@xxxxxxx", ""], ["CASSADO", "04 91 17 66 78", "cyril.cassado@xxxxxxx", ""], ["COMBA", "", "jean-pierre.comba@xxxxxxxx", ""], ["DUFOUR", "820337432", "sylvain.dufour@xxxxxxx", ""], ["GASSEND", "04 91 17 69 16", "philippe.gassend@xxxxxxx", ""], ["HABIB", "04 96 11 07 74", "lucie.habib@xxxxxxx", ""], ["MICHALEC", "04 96 11 07 98", "ISABELLE.MICHALEC@xxxxxxx", ""], ["MIQUELIS", "04 32 74 30 80", "jean-pierre.miquelis@xxxxxxx", ""], ["ROUQUEROL", "04 96 11 21 41", "jean-marc.rouquerol@xxxxxxx", ""], ["DENIS", "04 90 78 25 65", "jardiflora@xxxxxxxxx", ""], ["Bardon", "04 94 45 10 24", "BARDON3@xxxxxxxxxx", ""], ["MEIFFREN", "04 91 23 26 40", "meiffrenp@xxxxxxxxxxxxxxxxx", ""], ["PETRETTO", "04 94 21 31 43", "gerardpetretto@xxxxxxx", ""], ["MARENESI", "04 91 03 67 14", "nmareneri@xxxxxxxxxxxxx", ""], ["ROUX", "04 93 86 56 32", "bdf.roux@xxxxxxxxxx", ""], ["AMAND", "04 96 11 53 84", "didier.amand@xxxxxxxxxxxxxx", ""], ["CASTERAS", "04 91 23 23 65", "isabelle.casteras@xxxxxxxxxxxxxx", ""], ["MORAND", "04 91 16 93 02", "didier.morand@xxxxxxxxxxxxxx", ""], ["PIMENTA DE MIRANDA", "04 94 24 63 05", "manuel.pimenta@xxxxxxxxxxxxxx", ""], ["BONNANS", "04 91 28 36 00", "e.bonnans@xxxxxxxxxx", ""], ["BEN NACEUR", "04 90 14 69 99", "activconseil@xxxxxxxxxx", ""], ["BONNET", "04 91 90 88 66", "contact@xxxxxxxxxxxxxxxxx", ""], ["MEISSEL", "04 91 91 92 69", "contact@xxxxxxxxxxxxxxxxx", ""], ["INGRAVIDI", "01 55 35 77 18", "gilles.ingravidi@xxxxxxxxxxxxxx", ""], ["MEUNIER", "04 91 55 03 41", "emmanuelle.meunier@xxxxxxxxxxxxxx", ""], ["LATIL", "04 91 94 30 45", "michel.latil@xxxxxxxxxx", ""], ["THERON", "04 91 57 70 49", "theron@xxxxxxxxxxx", ""], ["EYSSAUTIER", "04 91 55 57 62", "cabinet@xxxxxxxxxxxxxx", ""], ["CURNIER", "04 95 10 40 00", "richard.curnier@xxxxxxxxxxxxxxxxxx", ""], ["LACHAMP", "04 92 29 34 03", "dominique.lachamp@xxxxxxxxxxxxxxxxxx", ""], ["IMBERT", "", "c.imbert@xxxxxxxxxxxxxxx", ""], ["ABGRALL", "04 42 25 70 26", "nicolas.abgrall@xxxxxxxxxxxxxx", ""], ["GIANNOTTA", "04 93 00 43 80", "giannotta@xxxxxxxx", ""], ["FERROTIN", "", "cbepcs@xxxxxxxxxx", ""], ["KEHAYAN", "04 91 25 71 70", "fk@xxxxxx", ""], ["VANDAMME", "04 42 63 04 04", "cce13@xxxxxxxxxx", ""], ["FRIEDMANN", "04 95 06 11 44", "muriel@xxxxxxx", ""], ["ALLEMAND", "04 90 14 87 89", "callemand@xxxxxxxxxxxxxxxxxxxxxx", ""], ["BELLEVILLE", "04 90 14 87 79", "xbelleville@xxxxxxxxxxxxxxxxxxxxxx", ""], ["CHASTEL", "04 90 14 87 20", "bchastel@xxxxxxxxxxxxxxx", ""], ["FRACHI", "", "mfrachi@xxxxxxxxxxxxxxxxxxxxxx", ""], ["MANENT", "04 92 30 80 85", "p.manent@xxxxxxxxxxxx", ""], ["RICHAUD", "04 92 30 80 80", "a.richaud@xxxxxxxxxxxx", ""], ["BENOIT-FIEVET", "04 90 99 08 08", "cbenoit-fievet@xxxxxxxxxxxx", ""], ["RAVALDEL", "", "mravaldel@xxxxxxxxxxxx", ""], ["SERRANO", "04 90 99 08 08", "lserrano@xxxxxxxxxxxx", ""], ["DALMAS", "04 94 22 80 05", "michel.dalmas@xxxxxxxxxx", ""], ["DANTZER", "04 94 22 80 09", "sylvie.dantzer@xxxxxxxxxx", ""], ["PASSAQUET", "04 94 22 89 04", "catherine.passaquet@xxxxxxxxxx", ""], ["SALLERIN", "04 94 22 80 28", "michelle.sallerin@xxxxxxxxxx", ""], ["AMER", "04 91 13 86 81", "kamel.amer@xxxxxxxxx", ""], ["ARAUJO", "04 88 10 44 11", "franck.araujo@xxxxxxxxx", ""], ["BALIVET", "", "marie-helene.balivet@xxxxxxxxx", ""], ["BETBEDE", "04 91 39 33 33", "jacques.betbede@xxxxxxxxx", ""], ["BOURDILLON", "04 91 10 01 01", "chantal.bourdillon@xxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["BRAZEILLES", "04 91 13 85 08", "philippe.brazeilles@xxxxxxxxx", ""], ["CARENZO", "04 91 39 33 64", "laurent.carenzo@xxxxxxxxx", ""], ["FUSELLA", "04 91 39 33 39", "caroline.fusella@xxxxxxxxx", ""], ["GARBIES", "04 91 13 85 71", "stephane.garbies@xxxxxxxxx", ""], ["GHAZAROSSIAN", "04 91 13 86 82", "fanny.ghazarossian@xxxxxxxxx", ""], ["MICHEL", "04 42 24 15 09", "patrick.michel@xxxxxxxx", ""], ["PICATTO", "04 88 10 44 07", "gilles.picatto@xxxxxxxxx", ""], ["PUSSACQ", "04 91 13 85 65", "gerald.pussacq@xxxxxxxxx", ""], ["ROLLAND", "04 91 13 86 83", "corinne.rolland@xxxxxxxxx", ""], ["SOILIHI", "", "zile.soilihi@xxxxxxxxx", ""], ["SOUCHON", "04 91 39 33 07", "francoise.souchon@xxxxxxxxx", ""], ["WENDLING", "04 91 39 33 10", "eric.wendling@xxxxxxxxx", ""], ["AGOSTINI", "04 93 13 74 30", "jean-francois.agostini@xxxxxxxxxxxxxxxx", ""], ["BOURGAREL", "04 93 13 74 53", "cecile.bourgarel@xxxxxxxxxxxxxxxx", ""], ["CHEREAU", "04 93 95 32 75", "philippe.chereau@xxxxxxxxxxxxxxxx", ""], ["NEFFATI", "04 93 13 75 11", "ferjani.neffati@xxxxxxxxxxxxxxxx", ""], ["BEBEAR", "01 58 50 71 82", "isabelle.bebear@xxxxxxxxxxxxxxxxx", ""], ["FONTENEAU", "", "fonteneau@xxxxxxxxxxxxxxxxx", ""], ["LACOMBE", "", "lacombe@xxxxxxxxxxxxxxxxx", ""], ["RIBARD", "04 88 19 75 15", "ribard@xxxxxxxxxxxxxxxxx", ""], ["TERRIERE", "04 42 97 18 18", "terriere@xxxxxxxxxxxxxxxxx", ""], ["RIONDET", "04 91 39 34 72", "yves.riondet@xxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["VIAL-BROCCO", "04 91 90 70 32", "fvialbrocco@xxxxxxxxx", ""], ["CARGIL", "04 42 32 05 27", "e.robineau@xxxxxxxx", ""], ["SCOLA", "04 92 75 39 52", "drscola@xxxxxxxxx", ""], ["BOYER", "04 42 12 63 95", "roland.boyer@xxxxxxxxxx", ""], ["FERRARY", "04 93 95 45 10", "michel.ferrary@xxxxxxxx", ""], ["BOEHM", "04 91 21 57 01", "cfai-corot.boehm@xxxxxxxxxx", ""], ["VAMBERSKY", "04 91 21 57 27", "christian.vambersky@xxxxxxxxxxxxx", ""], ["BUR", "", "christine.bur@xxxxxxxxxx", ""], ["ROUARD", "04 98 08 08 01", "jacques.rouard@xxxxxxxxxxxxxxxxxxxxx", ""], ["ROELANDTS", "04 42 92 24 24", "f.roelandts@xxxxxxxxxx", ""], ["POTTIER", "04 94 11 08 09", "paulandre.pottier.ciel@xxxxxxx", ""], ["SERRE", "04 91 39 58 90", "dany.serre@xxxxxxxxxxx", ""], ["VERON", "04 91 14 45 45", "c.veron@xxxxxxxxxxx", ""], ["DEBRABANT", "03 20 99 47 35", "cdebrabant@xxxxxxxxxxxxxx", ""], ["BONNARDEL", "04 42 39 38 77", "sbonnardel@xxxxxxx", ""], ["NARBONNE", "04 94 75 23 80", "f.narbonne@xxxxxxxxxx", ""], ["TREMOUILLE", "04 91 33 19 46", "scvpmarseille@xxxxxxx", ""], ["BONADA", "04 94 19 54 57", "devis@xxxxxxxxxxxxxxxxxxx", ""], ["FOUACHE", "04 91 11 37 00", "pascal.fouache@xxxxxxxxxxxxx", ""], ["MATTEI", "04 91 11 88 29", "catherine.mattei@xxxxxxx", ""], ["DELCOURT", "04 93 94 62 70", "ydelcourt@xxxxxxxxxxxxxxxx", ""], ["ALLEMAND", "04 91 99 00 50", "christian_allemand@xxxxxxxxxx", ""], ["MARTIN", "04 91 99 00 50", "corinne_martin@xxxxxxxxxx", ""], ["SAPIN", "04 91 91 46 00", "benoit.sapin@xxxxxxxxxx", ""], ["MAILLOT", "04 98 10 72 31", "hubert.maillot@xxxxxxxxxxxx", ""], ["MENAGER", "04 98 10 72 30", "stephanie.menager@xxxxxxxxxxxx", ""], ["DESALBRES", "04 89 87 70 92", "m.desalbres@xxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["FAUDOT", "04 42 91 60 82", "jcfaudot@xxxxxxxxxxxxxxxxx", ""], ["BATAILLE", "04 95 09 50 12", "maurice.bataille@xxxxxxxxxxxxxxxxxxxxx", ""], ["BIZAILLON", "04 91 16 04 30", "crcc@xxxxxxxxxxxx", ""], ["PRICCO", "04 97 18 67 54", "ppricco@xxxxxxx", ""], ["MAZZOCUT", "04 90 16 14 67", "sebastien.mazzocut@xxxxxxx", ""], ["BENOLIEL", "04 91 21 22 52", "patrick.benoliel@xxxxxxx", ""], ["BRIOLA", "04 91 21 26 57", "florence.briola@xxxxxxx", ""], ["GUARDIOLA", "04 91 21 23 28", "nathalie.guardiola@xxxxxxx", ""], ["MARON", "", "fabienne.maron@xxxxxxx", ""], ["POQUET", "04 91 21 22 59", "marc.poquet@xxxxxxx", ""], ["CHAYLA", "04 94 93 64 13", "vchayla@xxxxxxx", ""], ["NIZZOLI", "", "rnizzoli@xxxxxxx", ""], ["TISSOT", "04 94 14 46 67", "etissot@xxxxxxx", ""], ["VITEL", "04 94 18 60 05", "philippe.vitel@xxxxxxxxxx", ""], ["AUBERT", "04 42 90 00 97", "s83@xxxxxxx", ""], ["DOLORIAN", "04 91 16 04 20", "oecpacac@xxxxxxxxxxxxxxx", ""], ["EYSSAUTIER", "04 91 16 04 20", "oecpacac@xxxxxxxxxxxxxxx", ""], ["ALCARAZ", "", "malcaraz@xxxxxxxxxxxxx", ""], ["DELEUIL", "04 91 57 58 98", "fdeleuil@xxxxxxxxxxxxx", ""], ["GUERMEUR", "04 91 57 53 94", "fguermeur@xxxxxxxxxxxxx", ""], ["LE MASNE", "04 91 57 50 57", "llemasne@xxxxxxxxxxxxx", ""], ["PAULET", "04 91 57 53 79", "apaulet@xxxxxxxxxxxxx", ""], ["TREGAN", "", "mtregan@xxxxxxxxxxxxx", ""], ["MELLITI", "04 91 50 45 08", "abdallahmelliti@xxxxxxxx", ""], ["DEMENOIS", "04 91 57 71 00", "demenois@xxxxxxxxx", ""], ["BRENET", "04 96 11 05 05", "carolebrenet@xxxxxxxxxxxxxxxxxxxx", ""], ["MAURIES TCHOUKAVOFF", "04 91 99 01 51", "imauries@xxxxxxxxxxxxxxxxxx", ""], ["RIZZO", "04 91 99 01 55", "srizzo@xxxxxxxxxxxxxxxxxx", ""], ["TSAKYRELLIS", "04 91 99 04 56", "atsakyrellis@xxxxxxxxxxxxxxxxxx", ""], ["BERGASSE", "04 42 96 00 74", "hbergasse@xxxxxxxxxx", ""], ["MATHIEU", "04 42 96 00 74", "cra.aix-marseille@xxxxxxxxxxxx", ""], ["THENIERE", "", "cra.arles@xxxxxxxxxxxx", ""], ["TOMEI", "04 42 21 26 04", "jmtomei@xxxxxxxx", ""], ["VAULPRE", "", "cra.arles@xxxxxxxxxxxx", ""], ["PECHOU", "01 40 26 71 65", "jean.pechou@xxxxxxxxxxxx", ""], ["REGUIS", "", "nicolas.reguis@xxxxxxxxxx", ""], ["NGUYEN", "04 91 37 99 18", "Frederic.nguyen@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["CHAZAUX", "04 90 23 67 67", "marc.chazaux@xxxxxxxxxxxx", ""], ["GUIRAUDIE", "04 91 14 30 81", "particia.guiraudie@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["BUIGUEZ", "04 91 14 30 81", "critt@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["FAURE", "04 91 14 30 81", "critt@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["GUERRERA", "04 91 14 30 81", "critt@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["MATAL", "04 42 56 72 30", "pierre.matal@xxxxxxxxx", ""], ["AMADEO", "04 98 01 25 25", "mamadeo@xxxxxxxxxxx", ""], ["SCIANDRA", "04 98 16 31 63", "d.sciandra@xxxxxxxxxx", ""], ["CADOT", "04 91 80 63 44", "mcadot@xxxxxxxxxxxxxxxxxxx", ""], ["GIACOMI", "04 91 80 63 63", "lgiacomi@xxxxxxxxxxxxxxxxxxx", ""], ["GUEYDAN", "04 91 80 63 53", "pgueydan@xxxxxxxxxxxxxxxxxxx", ""], ["MANDIER", "04 94 95 50 55", "p.mandier@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["LATIL D'ALBERTAS", "04 91 14 56 73", "olatil@xxxxxxxxxxxxxxxxxxx", ""], ["BENICHOU", "04 42 02 55 50", "pbenichou@xxxxxxxxxxxxxx", ""], ["MARCHAND", "04 94 09 75 24", "chantal-m.marchand@xxxxxxxxxxxxxxxxxxxx", ""], ["JAUBERT", "04 42 24 40 01", "b.jaubert@xxxxxxxxxxxxxxxxxxx", ""], ["MARCORELLES", "04 91 10 31 08", "jpmarcorelles@xxxxxxxxx", ""], ["BUNAN", "04 94 98 58 98", "laurent@xxxxxxxxx", ""], ["MONFREDO", "04 32 75 08 45", "andremonfredo@xxxxxxxxxxx", ""], ["FOURNIER-BERAUD", "04 91 83 63 66", "fabienne.fournier-beraud@xxxxxxxxxxxxxxxxx", ""], ["PIC", "04.93.72.70.24", "pierre.pic@xxxxxxxxxxxxxxxxx", ""], ["ARABEYRE", "04 91 15 13 44", "marion.arabeyre@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["DUCREUX", "04 91 15 13 49", "daniele.ducreux@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["VILLANUEVA", "04 91 72 31 37", "dvrpcom@xxxxxxx", ""], ["KERBRAT", "04 90 51 36 90", "sec-dir@xxxxxxxxxx", ""], ["BIDEAU", "", "delphine.bideau@xxxxxxxxxxxxx", ""], ["BERTHET", "", "fabienne.berthet@xxxxxxxxxxxxx", ""], ["SCHMITT", "04 90 85 61 41", "egee.vaucluse@xxxxxxxxxxxxxx", ""], ["BONNEFOY", "04 90 34 35 10", "bonnefoyecv@xxxxxxx", ""], ["THOMAS", "04 42 51 34 22", "michel.thomas@xxxxxxxxxx", ""], ["CARMONA", "04 42 93 81 81", "jean-claude.carmona@xxxxxxxxxxxx", ""], ["Nom", "T\u00e9l\u00e9phone", "E-mail", ""], ["ROYER", "491142562", "royer@xxxxxxxxxxxxxx", ""], ["TEYSSIER", "04 90 34 95 75", "jct@xxxxxxxxxxxxxxxxxxxx", ""], ["LEBRET", "+41 21 693 7054", "herve.lebret@xxxxxxx", ""], ["AMAR", "", "epoque1@xxxxxxxx", ""], ["CARABALO", "", "carablo@xxxxxxxx", ""], ["ROCHEGUDE", "04 91 59 85 70", "rochegude@xxxxxxxx", ""], ["MARCQ", "04 91 28 38 00", "marcq.philippe@xxxxxxxxxxxxxxxxx", ""], ["DE PERETTI", "04 96 15 13 40", "ideperetti@xxxxxxxxxxxxxxx", ""], ["INFANTE", "04 94 12 52 42", "d.infante@xxxxxxxxxxxxxxx", ""], ["ROYERE", "04 91 13 74 62", "emilie.royere@xxxxxxxxxxxxxxxxxxx", ""], ["ANIFRANI", "", "jean-charles.anifrani@xxxxxxxxxxxxxx", ""], ["BELTRAN", "04 91 80 60 34", "patrick.beltran@xxxxxxxxxxxxxxxxxxxxx", ""], ["CHIANALINO", "04 78 63 64 42", "patrick.chianalino@xxxxxxxxxxxxxxxxxxxxx", ""], ["BLANC", "04 91 82 73 17", "katia.blanc@xxxxxxxxxxxxxxxxxxxxx", ""], ["LEONARDI", "04 91 82 78 00", "jean-paul.leonardi@xxxxxxxxxxxxxxxxxxxxx", ""], ["MOUYSSET", "04 91 82 79 92", "christophe.mouysset@xxxxxxxxxxxxxxxxxxxxxx", ""], ["PARANQUE", "04 91 82 78 73", "bernard.paranque@xxxxxxxxxxxxxxxxxxxxx", ""], ["TAPIA MOORE", "04 91 82 79 71", "ernesto.tapia-moore@xxxxxxxxxxxxxxxxxxxxx", ""], ["VINCENT", "04 91 82 78 05", "pascal.vincent@xxxxxxxxxxxxxxxxxxxxx", ""], ["JALINOT", "04 91 14 45 53 / 02", "francois.jalinot@xxxxxxxxxxxxxxxxxxx", ""], ["BLANC", "04 91 56 72 72", "flo.blanc@xxxxxxx", ""], ["LOPEZ", "04 94 66 62 60", "eureva@xxxxxxxxxx", ""], ["MARROT", "", "o.marrot@xxxxxxxxxx", ""], ["PARE", "", "jl.pare@xxxxxxxxxx", ""], ["LIOLIOS", "04 91 39 97 00", "pliolios@xxxxxxx", ""], ["CISNEROS", "04 96 13 96 13", "gilbert.cisneros@xxxxxxxxxxxxx", ""], ["CAMMARATA", "04 91 13 96 29", "rosalie.cammarata@xxxxxxxxxx", ""], ["LANGEVIN", "04 91 13 96 26", "philippe.langevin@xxxxxxxxxx", ""], ["CAMPO", "04 94 94 55 35", "rcampo@xxxxxxxxxxxxxxxxxx", ""], ["PALACIO", "04 91 90 91 66", "palaciofbfpaca@xxxxxxxxx", ""], ["SARKISSIAN", "04 91 90 91 66", "comitebanquespaca@xxxxxxxxxx", ""], ["CHEMIN", "04 91 54 79 00", "chr-13@xxxxxxxxxx", ""], ["LEMOINE", "04 91 57 71 36", "lemoine@xxxxxxxxxxxxxxxxxxxx", ""], ["BEGOU", "04 78 72 13 77", "agnes.begou@xxxxxxxxxx", ""], ["MIRANDE", "04 42 52 77 38", "annemarie.mirande@xxxxxxxxxxxxxxxxxxx", ""], ["DE POMPIGNAN", "04 91 06 17 90", "gdepompignan@xxxxxxxxxxxx", ""], ["MAGNAN", "04 91 06 17 90", "cmagnan@xxxxxxxxxxxx", ""], ["ROSIER", "04 91 33 04 44", "rosier@xxxxxxxxxx", ""], ["PRUVOT", "04 94 22 21 21", "pruvot@xxxxxxxxxxxxxxx", ""], ["COPPIN CANGE", "04 90 13 69 00", "isabelle.coppin-cange@xxxxxxxx", ""], ["BEHAR", "04 91 16 04 57", "alexandra.behar@xxxxxxxx", ""], ["BOURGUEIL", "04 91 90 75 66", "guillaume@xxxxxxxxxxxxxxxxx", ""], ["PINCE", "04 93 62 03 03", "v.pince@xxxxxxxxxxxxxxxxxxxxx", ""], ["PANSU", "", "denis.pansu@xxxxxxxx", ""], ["FABRE", "04 42 10 52 67", "fonderies-du-midi@xxxxxxxxxx", ""], ["SAVORNIN", "04 42 11 16 64", "villenouvelleinitiatives@xxxxxxxxxx", ""], ["SEGUIN", "04 42 24 57 57", "commercial@xxxxxxxxxx", ""], ["THERY", "04 42 22 60 05", "denis.thery@xxxxxxxxxxxxxxxxxx", ""], ["BONNARDEL", "01 58 50 15 03", "frederic.bonnardel@xxxxxxxxxxxx", ""], ["CHILLIET", "01 58 50 19 04", "alain..chilliet@xxxxxxxxxxxx", ""], ["CHEVALIER", "04 93 00 65 07", "anne.chevalier@xxxxxxxxxxx", ""], ["GAUTIER", "04 90 240 270", "jacques.gautier@xxxxxxxxxxxxxxxxxxx", ""], ["SENECA", "04 42 36 50 26", "info.GEMVENTURES@xxxxxxxxxxx", ""], ["VERCAEMST", "03 20 67 59 66", "overcaemst@xxxxxxxxxxxx", ""], ["CASPERS", "04 42 60 05 82", "elvira.caspers@xxxxxxxxx", ""], ["FLEURY", "04 42 20 27 76", "guy.fleury@xxxxxxxxxx", ""], ["IPPOLITO", "04 42 62 85 34", "marie-helene.ippolito@xxxxxxxxxxxxxxxxxxxxx", ""], ["KRIMPZER", "04 94 94 21 67", "contact@xxxxxxxxxxxxxx", ""], ["GORSE", "04 42 27 05 02", "jm.gorse@xxxxxxxxx", ""], ["KHAIR", "04 90 14 91 91", "rachid.khair@xxxxxxxxxx", ""], ["PINETTI", "04 90 86 49 66", "marc.pinetti@xxxxxxxxxxxxx", ""], ["BOYER", "", "florent.boyer@xxxxxxxxxxxxxx", ""], ["LESCAUDRON", "", "lescaudron.pierre@xxxxxxxxxxxxxxx", ""], ["MALEK", "", "anissa.malek@xxxxxxxxxxxxxx", ""], ["OUSSMOU", "", "oussmou@xxxxxxxxxxxxxxx", ""], ["NADAL", "01 53 42 61 61", "jnadal@xxxxxxxxxxxxxxx", ""], ["DANEL", "04 90 14 25 00", "christian.danel@xxxxxxxxxxxxxx", ""], ["PEYREAUD", "04 92 42 34 00", "contact@xxxxxxxxx", ""], ["SCHIAVI", "04 42 16 54 14", "dschiavi@xxxxxxxxxxxxxxx", ""], ["MONNIER", "04 98 10 66 66", "monnier.pierre@xxxxxxxxx", ""], ["GROSSMANN", "04 91 57 60 60", "alain.grossmann@xxxxxxxxxxxxxxxxxx", ""], ["ANSINELLI", "04 42 43 17 03", "ansinelli.gmif@xxxxxxxxx", ""], ["TURGIS", "", "xavier.turgis@xxxxxxx", ""], ["SAUT", "(04) 90 91 60 10", "psaut@xxxxxxxxxxx", ""], ["BAUSSAN", "04 92 72 51 51", "hpi@xxxxxxxxx", ""], ["GRAZIANI", "04 92 72 51 51", "hpi@xxxxxxxxx", ""], ["LOJOU", "04 91 35 87 56", "hlojou@xxxxxxxxxx", ""], ["BIGAY", "", "jean-francois.bigay@xxxxxxxxxxxxx", ""], ["SENENTE", "", "davidsenente@xxxxxxxxxxxxxx", ""], ["CAILLAT", "04 42 24 58 24", "r.caillat@xxxxxxxxx", ""], ["DINSDALE", "04 94 08 78 78", "hobie.cat@xxxxxxxxxx", ""], ["COUTURIER", "04 93 14 80 01", "resort@xxxxxxxxxx", ""], ["CLARET", "04 93 19 54 00", "claude.claret@xxxxxxxxxxxxxxx", ""], ["MAURIN", "04 96 17 22 08", "h1148-sb@xxxxxxxxx", ""], ["CLAMON", "01 58 13 11 56", "thierry.clamon@xxxxxxx", ""], ["CARRIER", "04 96 11 71 31", "jean-christian.carrier@xxxxxxx", ""], ["MARTIN", "04 91 30 78 96", "eric.martin@xxxxxxx", ""], ["MARTIN", "04 91 30 78 31", "frederic.m.martin@xxxxxxx", ""], ["SACHOT", "04 91 30 78 55", "pierre.marie.sachot@xxxxxxx", ""], ["HEMAR", "04 90 71 85 85", "ehemar@xxxxxxxxxxxxxxxx", ""], ["MARZIANI", "04 93 20 10 21", "alda@xxxxxxxxxxxxx", ""], ["MONCE", "04 88 67 25 25", "contact@xxxxxxxxxxxxx", ""], ["GEMIGNANI", "", "agemignani@xxxxxxx", ""], ["DUBRANA", "", "philippe.dubrana@xxxxxxxxxxxxx", ""], ["JULIENNE", "04 92 18 62 87", "s.julienne@xxxxxxxx", ""], ["MORGAVI", "", "paul.morgavi@xxxxxxxxxx", ""], ["RODRIGUEZ", "04 42 98 04 75", "michel.rodriguez@xxxxxxxxxxxxxx", ""], ["CIAVATTA", "04 91 15 73 40", "bruno@xxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["MOLLET", "04 92 72 00 44", "mollet.imprimerie@xxxxxxxxxx", ""], ["ALESSIO", "04 95 04 67 32", "catherine.alessio@xxxxxxxxxxxxxx", ""], ["BELHADJI", "", "maria.belhadji@xxxxxxxxxxxxxx", ""], ["BROCART", "04 95 04 67 37", "jpierre.brocart@xxxxxxxxxxxxxx", ""], ["DINKEL", "", "morgan.dinkel@xxxxxxxxxxxxxx", ""], ["SOULIERS", "", "celine.souliers@xxxxxxxxxxxxxx", ""], ["BOIS", "", "bois@xxxxxxx", ""], ["COILLARD", "", "jc.coillard@xxxxxxxxxxxxxxxxxxxxxx", ""], ["DEFOUS", "", "m.defous@xxxxxxxxxxxxxxxxxxxxxx", ""], ["FOURNERIE", "04 91 10 01 45", "cda3.impulse@xxxxxxx", ""], ["ROSSI", "", "f.rossi@xxxxxxxxxxxxxxxxxxxxxx", ""], ["SCHERER", "", "m.scherer@xxxxxxxxxxxxxxxxxxxxxx", ""], ["LABAT", "04 89 73 02 45", "labat@xxxxxxxxxxx", ""], ["MONTEIL", "04 97 15 53 71", "monteil@xxxxxxxxxxx", ""], ["CERCELET", "04 91 72 04 00", "jacques.cercelet@xxxxxxxxxxx", ""], ["BLONDEL", "04 92 22 33 00", "igbe05@xxxxxxxxxx", ""], ["FABRE", "", "julien@xxxxxxxxxxxxxx", ""], ["BOISSEL", "04 30 30 30 30", "stephane.boissel@xxxxxxxxxxxxxxxx", ""], ["DARTIGUES", "04 90 09 55 00", "c.dartigues@xxxxxxxxxxxxxx", ""], ["MABILAT", "04 94 45 28 14", "jp.mabilat@xxxxxxxxxxxxxx", ""], ["MARTIN-CHAVE", "", "ymc@xxxxxxxxxxxxxxxxxxxxx", ""], ["GIRARD", "", "philippe.girard87@xxxxxxxxxxxx", ""], ["GIRAUDON", "", "Gerard.Giraudon@xxxxxxxxxxxxxxx", ""], ["DE TONNAC", "04 42 39 33 07", "rdetonnac@xxxxxxxxxxxx", ""], ["MONTANIER", "04 94 32 69 03", "jc.montanier@xxxxxxxxxx", ""], ["SAMAN", "04 91 39 34 05", "claudette.visa@xxxxxxxxx", ""], ["PLOUCHART", "04 78 02 29 93", "georgia.plouchart@xxxxxx", ""], ["BELLIEUD-VIGOUROUX", "04 91 14 92 14", "m.bellieud-vigouroux@xxxxxxxxxxxxxxxx", ""], ["CLOE", "04 91 90 88 11", "c.cloe@xxxxxxxxxxxxxxxx", ""], ["TALALKHOKH", "04 93 31 62 50", "intercompta@xxxxxxxxxx", ""], ["BONNET", "04 91 90 88 66", "couveuse-interface@xxxxxxxxx", ""], ["BOURGAREL", "04 91 78 77 85", "jp@xxxxxxxxxxxx", ""], ["CHABRIERES", "04 91 78 77 85", "jp@xxxxxxxxxxxx", ""], ["PUYCOUYOUL", "04 91 78 77 85", "jp@xxxxxxxxxxxx", ""], ["ASKMO", "", "stina.askmo@xxxxxxxxxxxx", ""], ["MINAULT", "", "sm@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["DAGAULT", "04 96 11 18 11", "sebastien.dagault@xxxxxxxxxx", ""], ["FONTAINE", "04 96 11 67 68", "laurence.fontaine@xxxxxxxxxx", ""], ["MELI", "04 94 10 24 90", "iProcess@xxxxxxxxxxx", ""], ["BARTHELEMY", "04 42 59 90 00", "s.barthellemy@xxxxxxxxxxxxx", ""], ["DAMORA", "", "m.damora@xxxxxxxxxxxxx", ""], ["DUCLOS", "04 42 59 90 00", "v.duclos@xxxxxxxxxxxxx", ""], ["HALLE", "04 42 59 90 00", "jm.halle@xxxxxxxxxxxxx", ""], ["MARGAILLAN", "04 42 59 90 00", "d.margaillan@xxxxxxxxxxxxx", ""], ["SANDERIAN", "04 42 59 90 00", "a.sanderian@xxxxxxxxxxxxx", ""], ["SIVELLE", "04 42 59 90 00", "c.sivelle@xxxxxxxxxxxxx", ""], ["DELLERY", "04 94 20 78 00", "bernard.dellery@xxxxxxx", ""], ["DUFOUR", "04 96 12 50 00", "jefco@xxxxxxxxxx", ""], ["MELO", "04 92 91 98 31", "aurelie.melo@xxxxxxxxxxxxxxxxxxxx", ""], ["CALZARONI", "04 93 12 22 60", "jpcalzaroni@xxxxxx", ""], ["LE GOFF", "04.89.73.02.42", "edouard.legoff@xxxxxxxxxx", ""], ["PETIT", "", "r.petit@xxxxxxxx", ""], ["LEFFLOT", "04 96 20 53 60", "jllefflot@xxxxxxx", ""], ["QUAGLIA", "04 96 20 53 20", "jquaglia@xxxxxxx", ""], ["TRIPONEL", "", "ptriponel@xxxxxxx", ""], ["PALMARO", "04 94 59 57 17", "jpalmaro@xxxxxxxxxx", ""], ["BETTINGER", "04 91 29 81 71", "philippe.bettinger@xxxxxxxxxxxxxxxxxx", ""], ["LECOUR", "", "michel.lecour@xxxxxxxxxxxxxxxxxx", ""], ["FERRIOL", "09 91 58 52 17", "david@xxxxxxxxxxxxxxx", ""], ["AZAM", "04 42 24 34 35", "Christophe AZAM", ""], ["LEFORT", "04 96 20 10 07", "didier.lefort@xxxxxxxxxxxxxx", ""], ["DEWAVRIN", "04 91 16 00 85", "e.dewavrin@xxxxxxxxxxxxxxxxxxxxx", ""], ["PILLET", "04 91 84 49 05", "dpillet@xxxxxxxxxxxxxxxxxxxx", ""], ["TUR", "08 73 65 53 10", "gtur@xxxxxxxxxx", ""], ["PEUPORTIER", "01 49 11 43 11", "herve.peuportier@xxxxxxxxxxx", ""], ["BRECHET", "", "armeliere@xxxxxxxxxx", ""], ["DUBE", "(450) 978 5951", "robert.dube@xxxxxxxxxxxxxxxxxxx", ""], ["BIGAY", "04 88 66 51 00", "bbigay@xxxxxx", ""], ["LIEVRE", "", "slievre@xxxxxx", ""], ["CLOAREC", "04 93 71 06 37", "g.cloarec@xxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["LASCOLS", "04 94 21 90 34", "h.lascols@xxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["CHUVER", "04 91 46 70 00", "lepoissonquimarche@xxxxxxxxxx", ""], ["GIUDICE", "", "lesjardinsdelestaque@xxxxxxx", ""], ["MORIOU", "01 53 24 40 81", "corine.moriou@xxxxxxxxxxxxxxxxxxxx", ""], ["ALEXIS", "", "christinealexis@xxxxxxxxxx", ""], ["HUBINET", "04 91 49 14 00", "j.hubinet@xxxxxxxxxxxxxxxxx", ""], ["BOUDIN", "04 90 49 19 19", "accueil@xxxxxxxxxxxxxxxx", ""], ["DELRIEUX", "04 42 84 38 48", "les-paluds-aubagne@xxxxxxxxxx", ""], ["GAILLARD", "04 91 71 40 48", "patrice.gaillard@xxxxxxxxxxxx", ""], ["LE GO", "04 42 24 00 10", "elego@xxxxxx", ""], ["BARLA", "04 90 42 76 58", "jchbarla@xxxxxxxxxx", ""], ["COTTE", "04 91 23 67 00", "cotteer@xxxxxx", ""], ["CREPY-BANFIN", "", "crepybje@xxxxxx", ""], ["MANGIONE", "", "mangioje@xxxxxx", ""], ["RIVET-JOLIN", "", "rivet-jolinc@xxxxxxxxxxxxxxxxxxxxxx", ""], ["BURGAUD", "04 95 06 11 50", "sburgaud@xxxxxxxxxx", ""], ["COSTES", "04 91 16 62 82", "ccostes@xxxxxxxxxxxxxxxxxxx", ""], ["BLANC", "04 93 29 08 98", "jpblanc@xxxxxxxxxxx", ""], ["BOURDILLON", "04 91 34 89 12", "coroi@xxxxxxx", ""], ["CARANTA", "04 94 12 44 00", "info@xxxxxxxxxxxxxxxxxx", ""], ["MARIANI", "", "j.m.mariani@xxxxxxxxxx", ""], ["BUGNAZET", "04 95 04 95 22", "n.bugnazet@xxxxxxxxxxxxxxxxxxx", ""], ["OLIVIER", "04 91 11 88 05", "l.olivier@xxxxxxxxxxxxxxxxxxx", ""], ["REY", "04 91 11 88 02", "c.rey@xxxxxxxxxxxxxxxxxxx", ""], ["DE CIBON", "04 91 13 77 42", "hugues.de-cibon@xxxxxxxxxxxxxxxxxxxxx", ""], ["THIERRY", "04.95.09.50.51", "eric.thierry@xxxxxxxxxxxxxxxxxxxxx", ""], ["OLMETA", "", "marvin.eurl@xxxxxxxxxx", ""], ["DAURELLE", "04 91 46 73 05", "bdaurelle@xxxxxxxxxxxxxxxxxxxx", ""], ["CHEVALLIER", "04 91 00 96 27", "benedicte.chevallier@xxxxxxxxxxxxxxx", ""], ["CANALLAS", "04 98 00 90 31", "mcanallas@xxxxxxxxxx", ""], ["GILLET", "01 56 03 34 00", "jcgillet@xxxxxxxxxxxxxxxxxxx", ""], ["BOUVENE", "", "gbouvene@xxxxxxxxx", ""], ["MASSOL", "04 93 98 27 64", "jose.massol@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["PESQUET BAILLON DHUMEZ", "04 93 98 27 64", "cpbd@xxxxxxxxx", ""], ["CHEHANNE", "", "chehanne@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["DALBY", "", "dalby@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["LORENZI", "(0)4 91 14 05 60", "lorenzi@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["PEREZ", "04 91 14 05 60", "perez@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["UHLMANN", "04 91 14 05 69", "uhlmann@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["ZIEGER", "04 92 94 59 92", "zieger@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["MIRAS (de)", "", "aidm@xxxxxxxxxxxxxxx", ""], ["GOUDAL", "04 97 06 03 03", "cgoudal@xxxxxxxxxxxxxx", ""], ["TCHERKEZIAN", "04 96 15 11 11", "tcherkezian@xxxxxxxxxxxx", ""], ["BASSO", "", "nbasso@xxxxxxxxxxx", ""], ["ROHMER", "", "fx.rohmer@xxxxxx", ""], ["ROUABAH", "", "contact@xxxxxxxxxxxx", ""], ["LIRZIN", "04 91 83 63 69", "franck.lirzin@xxxxxxxxxxxxxxxxx", ""], ["GOMEZ", "04 91 83 63 75", "sophie.gomez@xxxxxxxxxxxxxxxxx", ""], ["MICHEL", "04 91 83 63 70", "pierre.michel@xxxxxxxxxxxxxxxxx", ""], ["RUSSO", "04 91 17 93 06", "jean-jacques.russo@xxxxxxxxxxxxxxxxxxxxxx", ""], ["DE FORESTA", "04 96 17 07 40", "bruno.de-foresta@xxxxxxxxxxxxx", ""], ["COLON", "04 91 91 87 66", "fcolon@xxxxxxxxxx", ""], ["BINET", "04 94 88 19 54", "negexim@xxxxxxxxxx", ""], ["COLLIGNON", "04 91 46 84 60", "p.collignon@xxxxxxxxxxxxxxxxxx", ""], ["REBOURCET", "04 91 37 79 26", "grebourcet@xxxxxxxxxx", ""], ["BERNARD", "04 89 98 16 42", "gillesolivier.bernard@xxxxxxxxxxxxx", ""], ["BOUSCATEL", "04 89 98 16 57", "paul.bouscatel@xxxxxxxxxxxxxxxxx", ""], ["BOUSCATEL", "04 89 98 16 57", "paul.bouscatel@xxxxxxxxxxxxxxxxx", ""], ["BOUSCATEL", "04 89 98 16 57", "paul.bouscatel@xxxxxxxxxxxxxxxxx", ""], ["MERCIER", "04 89 98 16 43", "sophie.mercier@xxxxxxxxxxxxxxxxx", ""], ["VAN DER HASSELT", "04 89 98 16 10", "yves.vanderhasselt@xxxxxxxxxxxxx", ""], ["VIDAL", "04 89 98 23 44", "mariechristine.vidal@xxxxxxxxxxxxxxxxx", ""], ["NAVAS", "04 93 18 26 95", "chnavas@xxxxxxxxxxxx", ""], ["LEFEBVRE", "03 28 76 56 00", "jmlefebvre@xxxxxxxxx", ""], ["JAMEN", "04 91 10 79 76", "karine.jamen@xxxxxxxxxxx", ""], ["COUTANT", "04 96 20 34 00", "jf.coutant@xxxxxxxxxxxxxxxxxxxxx", ""], ["DUFOIX", "04 91 76 91 50", "dufoix.cedric@xxxxxxxx", ""], ["MARLIER", "04 92 12 04 80", "jean-pierre.marlier@xxxxxxxxxxx", ""], ["LAFON", "04 91 23 87 09", "glafon@xxxxxxx", ""], ["MARTIN-LAVAL", "04 91 95 60 84", "yml@xxxxxxxxxx", ""], ["GAY", "", "optimumental@xxxxxxxx", ""], ["LONDEIX", "08 10 83 06 06", "laurent.londeix@xxxxxxxxxxxxxxxxxx", ""], ["VINZANT", "04 94 06 59 48", "alain.vinzant@xxxxxxxxxx", ""], ["MAUREL", "04 91 15 31 13", "ordreavocats.marseille@xxxxxxxxxx", ""], ["ATANIAN", "04 91 17 44 25", "marc.atanian@xxxxxxx", ""], ["BROSSE", "04 91 17 84 25", "jb.brosse@xxxxxxx", ""], ["COGNET", "04 92 29 42 83", "jerome.cognet@xxxxxxx", ""], ["COLSON", "04 91 17 44 04", "celine.colson@xxxxxxx", ""], ["DURR", "04 91 17 44 31", "jf.durr@xxxxxxx", ""], ["FOURNIER", "04 91 17 44 35", "aline.fournier@xxxxxxx", ""], ["GARCIA", "04 92 29 42 88", "delphine.garcia@xxxxxxx", ""], ["GARCIA", "04 92 29 42 88", "delphine.garcia@xxxxxxx", ""], ["GATE", "04 91 17 84 26", "christophe.gate@xxxxxxx", ""], ["GRAS", "04 92 29 42 82", "yves.gras@xxxxxxx", ""], ["GUEUZIEC", "04 91 17 44 19", "francoise.gueuziec@xxxxxxx", ""], ["HOK", "04 91 17 84 27", "bunheng.hok@xxxxxxx", ""], ["JOUBERT", "04 91 17 44 00", "pierre.joubert@xxxxxxx", ""], ["LAI", "04 91 17 84 31", "claude.lai@xxxxxxx", ""], ["MAUPETIT", "04 91 17 44 28", "benedicte.maupetit@xxxxxxx", ""], ["MOSCHETTI", "04 91 17 44 27", "anne.moschetti@xxxxxxx", ""], ["RIVOIRE-SOUILMI", "04 92 29 42 81", "emilie.rivoiresouilmi@xxxxxxx", ""], ["ROBERT-CHARRERAU", "04 91 17 44 15", "sebastien.robertcharrerau@xxxxxxx", ""], ["SABATIER", "04 91 17 84 23", "nicolas.sabatier@xxxxxxx", ""], ["SIBUT", "04 91 17 84 47", "marina.sibut@xxxxxxx", ""], ["SUQUET", "04 91 17 44 21", "jm.suquet@xxxxxxx", ""], ["TRINGALI", "04 91 17 44 10", "michel.tringali@xxxxxxx", ""], ["TROGLIA", "04 92 29 42 85", "nadege.troglia@xxxxxxx", ""], ["TROGLIA", "", "nadege.troglia@xxxxxxx", ""], ["VEDRINE", "04 91 17 44 01", "veronique.vedrine@xxxxxxx", ""], ["VINCENT", "04 92 29 42 84", "olivier.vincent@xxxxxxx", ""], ["VITI", "04 91 17 44 16", "rolland.viti@xxxxxxx", ""], ["MIOQUE", "04 42 56 53 13", "pmioque@xxxxxxxxxxxx", ""], ["HUGUES", "08 73 67 28 28", "redaction@xxxxxxxxxxxxxxx", ""], ["CARDOSO", "04 94 19 84 14", "emiliecardoso@xxxxxxxxxxxxxxxxx", ""], ["BLANC", "04 42 98 12 50", "peloux@xxxxxxxxxxxxxxxxxxx", ""], ["PERSONNIC", "04 42 61 29 20", "o.personnic@xxxxxxxxxxxxxx", ""], ["CARDINEAU", "04 90 16 54 02", "com@xxxxxxxx", ""], ["GARCIA", "04 90 16 54 05", "redac@xxxxxxxx", ""], ["PEYTAVIN", "04 94 14 1 260", "c.peytavin@xxxxxxxxxxxxxxxxxxxxx", ""], ["RIALLANT", "", "driallant@xxxxxxxxxxxxx", ""], ["VETU", "03 28 52 06 86", "laurent.vetu@xxxxxxxxxxx", ""], ["BARUSSEAU", "04 96 11 64 80", "jcbarusseau@xxxxxxxxxxxxxxxxxx", ""], ["GRAND", "04 96 11 64 80", "ngrand@xxxxxxxxxxxxxxxxxx", ""], ["BIZET", "04 97 05 22 00", "cbizet@xxxxxxxxxxxxxxxxxxxx", ""], ["RIOS", "04.97.01.12.75", "richard.rios@xxxxxxxxxxxxxxxxxxxx", ""], ["AVELLAN", "04 94 03 89 73", "avellan@xxxxxxxxxxxxxxx", ""], ["BARAONA", "04 93 03 89 03", "baraona@xxxxxxxxxxxxxxx", ""], ["BOISSON", "04 42 85 60 60", "jean-francois.boisson@xxxxxxxxxxxxxxx", ""], ["LONGERE", "04 42 85 77 70", "jean-yves.longere@xxxxxxxxxxxxxxx", ""], ["SAUGIER", "04.91.15.60.35", "jacques.saugier@xxxxxxxxxxxxxxxxx", ""], ["ANDRIEU", "04 91 99 30 64", "marie.andrieu@xxxxxxxxxx", ""], ["ROMEO", "04 91 99 30 38", "marie-antoinette.romeo@xxxxxxxxxx", ""], ["FENECH", "", "contact@xxxxxxxxxxxxxxxxxx", ""], ["MELIN", "04 91 39 33 61", "valerie.melin@xxxxxxxxxxxxxxxxxxxxxxxx", ""], ["PRIEUR", "04 91 04 03 86", "d.prieur@xxxxxxxxxxxxx", ""], ["ALBANESE", "04 88 66 90 90", "jp.albanese@xxxxxxxxxxxxx", ""], ["ROGAR", "04 42 02 02 41", "olivier.rogar@xxxxxxxxxxx", ""], ["DUFOUR-LORIOLLE", "04 42 27 28 20", "sdufourloriolle@xxxxxxx", ""], ["SANTAMARINA", "", "brigitte.santamarina@xxxxxxx", ""], ["PAGET", "04 91 17 63 63", "a.paget@xxxxxxxxxxxx", ""], ["GASTOU", "04 91 57 70 17", "gastou@xxxxxxxxxxxx", ""], ["ROCCA SERRA", "04 90 84 05 91", "proget.roccaserra@xxxxxxxxxx", ""], ["LEGROS", "04 94 08 12 03", "progetech@xxxxxxxxxx", ""], ["MAILLE", "04 66 70 64 67", "emaille@xxxxxxxxxx", ""], ["FRENEAUX", "", "freneaux@xxxxxxxxxx", ""], ["FLORISOONE", "04 91 11 88 97", "c.florisoone@xxxxxxxxxxxxxxxxxx", ""], ["LIOTTA", "04 91 11 88 97", "d.liotta@xxxxxxxxxxxxx", ""], ["MOUILLET", "04 91 11 88 97", "olivier@xxxxxxxxxxx", ""], ["SCHLEICH", "04 91 11 88 97", "aschleich@xxxxxxxxxxxxx", ""], ["SIRI", "04 91 11 88 97", "patrick-siri@xxxxxxxxx", ""], ["FABRE", "04 42 53 20 35", "chfabre.pea@xxxxxxxxxx", ""], ["DISTINGUIN", "", "p.distinguin@xxxxxxxxxxxxxxxxxxxxx", ""], ["FACKELDEY", "", "e.fackeldey@xxxxxxxxxxxxxxxxxxxxx", ""], ["FAVERJON", "04 96 11 60 00", "y.faverjon@xxxxxxxxxxxxxxxxxxxxx", ""], ["NGUYEN", "", "d.nguyen@xxxxxxxxxxxxxxxxxxxxx", ""], ["SEMERDJIAN", "04 96 11 60 17", "e.semerdjian@xxxxxxxxxxxxxxxxxxxxx", ""], ["SERRE", "04 96 11 60 01", "c.serre@xxxxxxxxxxxxxxxxxxxxx", ""], ["SIERRA", "04 96 11 60 07", "m.sierra@xxxxxxxxxxxxxxxxxxxxx", ""], ["WNUCK", "04 96 11 60 15", "f.wnuck@xxxxxxxxxxxxxxxxxxxxx", ""], ["BESSON-DAMEGON", "04 88 66 90 00", "eric.besson-damegon@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["BIZAILLON", "", "contact@xxxxxxxxxx", ""], ["CERRATO", "04 88 66 90 95", "christine.cerrato@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["DEBAILLE", "04 91 57 71 85", "debaille@xxxxxxxxx", ""], ["FONSEQUE-NATHAN", "04 42 24 11 57", "dominique.fonseque@xxxxxxxxxx", ""], ["REISCH", "04 90 78 70 74", "mreisch@xxxxxxxxxxxxx", ""], ["POUZET", "", "cap.marc.pouzet@xxxxxxxxxx", ""], ["GIRAUD", "04 72 80 00 35", "ogiraud@xxxxxxxxxxxxxxxxxxxx", ""], ["RICO", "04 42 41 36 14", "herve.rico@xxxxxxxxxxxxxxxxx", ""], ["LEDERLIN", "04 42 24 44 61", "dlederlin@xxxxxxxxxxx", ""], ["CLEMENT", "04 76 44 52 69", "n.clement@xxxxxxxxxx", ""], ["HENIN", "", "hening@xxxxxxxxx", ""], ["CLAVAUD", "05 55 35 01 68", "nicolerene@xxxxxxxxxx", ""], ["RICHARD", "04 77 49 32 70", "jr@xxxxxxxxxxxxxxxxxxxxxx", ""], ["STAUDRE", "", "jacky@xxxxxxxxxxx", ""], ["LABRUNYE", "02 35 60 99 80", "francis.labrunye@xxxxxxxxxxxxxxxx", ""], ["DE BLIGNIERES", "01 56 69 43 52", "gonzague.deblignieres@xxxxxxxxxx", ""], ["BATAILLE", "03 44 40 77 60", "jerome.bataille@xxxxxxxxxxxxxxxxxxxxxx", ""], ["GAUTIER", "05 45 61 13 18", "gautierjpaul@xxxxxxxxxxxxxxxxxxxxx", ""], ["BROCHIER", "", "jbrochier@xxxxxxxxxx", ""], ["PALMYRE", "04 79 68 34 35", "contact@xxxxxxxxxxxxxx", ""], ["BETREMIEUX", "02 32 84 58 51", "pierre@xxxxxxxx", ""], ["CHRISTOPH", "01 64 89 30 00", "jph.cristoph@xxxxxxxxxx", ""], ["SAGE", "05 63 33 92 02", "editions@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["COUSTILLAC", "", "acarassou@xxxxxxxxxxxxx", ""], ["JAAFOURA", "73 463287/73 463207", "lotfi.jaafoura@xxxxxxxxxx", ""], ["SEKMA", "22138838", "mehdi@xxxxxxxxxx", ""], ["AMIOT", "02 54 90 30 30", "marienoelle.amiot@xxxxxxxxxxx", ""], ["DOIZON", "02 51 66 30 65", "doizon.raymond@xxxxxxxxxxxxxxx", ""], ["SIROT", "04 42 84 35 36", "mireille.serot@xxxxxxxxxxx", ""], ["ABBAD ANDALOUSSI", "00 212 022 26 93 18", "m.abbad@xxxxxxxxx", ""], ["BENSALEH CHAQROUN", "00 212 22 33 47 47", "sidiali@xxxxxxxxx", ""], ["CHEIKH LAHLOU", "00 212 22 30 51 16", "cooper@xxxxxxxxxxxxxxx", ""], ["EL KETTANI", "00 212 22 20 15 75", "kettani@xxxxxxxxx", ""], ["SMAD", "00 212 22 20 76 82", "smad_h@xxxxxxxxx", ""], ["GIOCANTI", "09 50 40 04 92", "xgiocanti@xxxxxxxxx", ""], ["CASQUERO", "", "isabelle_casquero@xxxxxxxxxxx", ""], ["CAILLIBOTTE", "04 90 67 14 73", "j.caillibotte@xxxxxxxxxxxxxxxxxxx", ""], ["GOLDZAHL", "04 91 77 03 25", "contact@xxxxxxxxx", ""], ["JAMET", "04 78 71 71 91", "nadine.jamet@xxxxxxxxxxxxxxxx", ""], ["BOUREE", "02 32 27 70 00", "bouree.d@xxxxxxxxxxxxxxxxxxx", ""], ["DE HAUT DE SIGY", "04 95 09 10 10", "bdehaut@xxxxxxx", ""], ["BEKKENS", "03 28 04 52 20", "cbekkens@xxxxxxxxxx", ""], ["ALBERTINI", "04 94 08 09 49", "aegcom@xxxxxxxxxx", ""], ["GARCIA", "04 90 49 40 02", "jmgarcia@xxxxxxxxxxxxxxxxx", ""], ["NAINOB", "04 90 49 40 00", "tfnainob@xxxxxxxxxxxxx", ""], ["SALASCA", "04 90 49 40 00", "jean-luc.salasca@xxxxxxxxx", ""], ["DEPORT", "04 42 74 42 74", "alain.deport@xxxxxxxxx", ""], ["SIFFREIN-BLANC", "04 96 20 63 00", "willy@xxxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["LA PIANA", "04 42 18 06 08", "s.lapiana@xxxxxxxxxxxxx", ""], ["CAZALOT", "04 96 10 04 30", "b.cazalot@xxxxxxxxxxx", ""], ["FEUTRY", "", "dominique.feutry@xxxxxx", ""], ["GUILAS", "04 91 13 34 20", "florence.guilas@xxxxxx", ""], ["SALASCA", "04 91 14 25 40", "jean-luc.salasca@xxxxxxxxx", ""], ["LIOTARD", "04 90 49 25 04", "jean-marc.liotard@xxxxxxxxxxx", ""], ["POURCELOT", "04 90 49 25 04", "sofipaca@xxxxxxxxxx", ""], ["SAINT-MICHEL", "04 90 49 25 04", "sofipaca@xxxxxxxxxx", ""], ["COURET", "04 42 99 04 04", "christian.couret@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["GARCIA", "04 90 49 40 05", "jmgarcia@xxxxxxxxxxxxxxxxx", ""], ["NAINOB", "04 90 49 40 00", "tfnainob@xxxxxxxxxxxxxxxxx", ""], ["VAYSSET", "04 42 53 82 84", "eric.vaysset@xxxxxxxxxxxx", ""], ["PROD'HOMME", "", "infos@xxxxxxxxxxx", ""], ["ARFEUILLERE", "", "darfeuillere@xxxxxxxxxx", ""], ["CAMPION", "04 42 68 88 00", "philippe.campion@xxxxxx", ""], ["GRALL", "04 42 63 13 46", "jygrall@xxxxxxxxxx", ""], ["PELLENC", "04 90 36 20 04", "spellenc@xxxxxxxxxxxxx", ""], ["DANTHEZ", "04 96 11 65 66", "p.danthez@xxxxxxxx", ""], ["GELIN", "04 96 11 65 62", "gelin@xxxxxxxxxxxx", ""], ["LEFRANC", "01 96 11 65 62", "lefranc@xxxxxxxxxxxx", ""], ["PIANETTI", "04 90 09 57 52", "david.sli@xxxxxxxxxx", ""], ["HATEMIAN", "04 91 54 82 52", "bhatemian@xxxxxxxxxxxxx", ""], ["GAULT", "04 67 15 66 09", "i.gault@xxxxxxx", ""], ["TADDEI", "04 90 14 20 00", "d.s.e@xxxxxxxxxx", ""], ["WEBER", "04 42 97 11 11", "jlw@xxxxxxxxxxxxxxxx", ""], ["DARY", "04 92 17 51 64", "cdary@xxxxxxxxxxxxxxxx", ""], ["PIN-MONSAIGEON", "04 92 17 51 86", "spin@xxxxxxxxxxxxxxxx", ""], ["PIN-MONSAINGEON", "04 92 17 51 86", "spin@xxxxxxxxxxxxxxxx", ""], ["BRAUN", "", "patricia.braun@xxxxxxxxxxxxxxxxxxxx", ""], ["FIASTRE", "04 91 22 28 52", "fiastre@xxxxxxxxxx", ""], ["TESTA", "04 42 82 20 40", "groupetesta@xxxxxxxxxxxxxxx", ""], ["DOMALLAIN", "04 91 68 02 96", "tommasi@xxxxxxxxxx", ""], ["LORENZI", "04 94 10 72 57", "alorenzi@xxxxxxxxxxxxxxxxxxxxx", ""], ["CARCAUD-MACAIRE", "01 47 44 53 50", "francois.carcaud-macaire@xxxxxxxxx", ""], ["VALERIO", "01 47 44 28 83", "fabrice.valerio@xxxxxxxxx", ""], ["RIPOCHE", "04 42 78 53 00", "jacques.ripoche@xxxxxxxxx", ""], ["HUSSON", "04 94 93 70 88", "shusson@xxxxxxxxx", ""], ["REBHUN", "04 94 93 68 23", "mrebhun@xxxxxxxxx", ""], ["VIDEAU", "04 94 93 83 59", "javideau@xxxxxxxxx", ""], ["BLOTTIERE", "", "blottiere@xxxxxx", ""], ["FAURE LAMBERT", "04 94 03 89 20", "faurelambert@xxxxxx", ""], ["FEKRANE", "", "fekrane@xxxxxx", ""], ["HAUWEL", "04 94 03 89 69", "hauwel@xxxxxx", ""], ["BERTAUDON", "04 91 13 66 24", "yves.bertaudon@xxxxxxxxxxxxxxxxxxx", ""], ["CARLES", "04 96 12 07 40", "transaff@xxxxxxx", ""], ["CZIMER", "08 25 07 36 36", "laurent.czimer@xxxxxxxxxxxxxxxxxxxx", ""], ["MORAES", "04 90 66 94 00", "hmoraes@xxxxxxxxx", ""], ["DE MAISSIN", "04 91 76 78 02", "bdemaissin@xxxxxxxxxxxxxxxxxxxx", ""], ["GUEZ", "04 91 14 31 35", "jetsud@xxxxxxxxxxxxxxxxxx", ""], ["LEYTES", "04 96 17 25 52", "virginie.leytes@xxxxxxxxxxxx", ""], ["TOUITOU", "04 96 17 25 82", "frederique.touitou@xxxxxxxxxxxx", ""], ["BORNAREL", "04 91 80 91 48", "bornarel@xxxxxxxxxxxxxxx", ""], ["ROLLANDIN", "04 91 80 91 48", "pierre.rollandin@xxxxxxxxxxxxxxx", ""], ["PASQUIER", "04 91 99 49 90", "mhpasquier@xxxxxxxxxxx", ""], ["NAHOUM", "", "up84@xxxxxxxxxx", ""], ["BALAZUC", "04 94 09 78 71", "t.balazuc@xxxxxxx", ""], ["BRUNIER", "", "n.brunier@xxxxxxx", ""], ["COINTE", "04 94 09 78 78", "l.cointe@xxxxxxx", ""], ["FRANCESCHINI", "04 94 09 78 75", "f.franceschini@xxxxxxx", ""], ["FLESIA", "04 91 10 65 53", "eflesia@xxxxxxxxxxxxxx", ""], ["GASTE", "04 94 14 28 02", "gaste@xxxxxxxxxxx", ""], ["CALACIURA", "04 92 27 27 60", "i.calaciura@xxxxxxxxx", ""], ["GAILLARD", "04 91 57 70 39", "gaillard@xxxxxxxxx", ""], ["GUEYDON", "04 91 57 71 79", "gueydon@xxxxxxxxxx", ""], ["RIGAUD", "04 91 57 71 53", "rigaud-lasperches@xxxxxxxxx", ""], ["VOUILLEMIN", "04 42 18 43 99", "urei.paca@xxxxxxx", ""], ["ARNAUD", "04 91 83 79 55", "daniel.arnaud@xxxxxxxxx", ""], ["ISIDORE", "04 94 41 86 65", "marc.isidore@xxxxxxxxx", ""], ["ARNAUD-ROUECHE", "04 91 00 96 01", "jlebrun@xxxxxxxxxxxxxxxxxx", ""], ["BAUMLEN", "04 91 81 62 43", "baumlen@xxxxxxxxxxxxxxxxx", ""], ["BREST", "04 91 00 96 11", "brest@xxxxxxxxxxxxxxxxx", ""], ["LEANDRI", "", "franleandri@xxxxxxxxx", ""], ["MAGNAN", "04 91 00 96 26", "ccm@xxxxxxxxxxxxxxxxx", ""], ["MARSAUDON", "04 91 00 96 40", "marsaudon@xxxxxxxxxxxxxxxxxx", ""], ["VAQUETTE", "08 79 22 09 91", "jcv@xxxxxxxxxxxxxxxxxxxxxx", ""], ["GABENESCH", "", "a.gabenesch@xxxxxxxx", ""], ["HOUEIX", "", "m.houeix@xxxxxxxx", ""], ["ISSALIS", "04 94 93 31 81", "issalis@xxxxxxxxxxxx", ""], ["DEL NEGRO", "04 90 16 45 60", "e.delnegro@xxxxxxxxxxx", ""], ["AMIRAULT", "04 92 07 55 55", "isabelle.amirault@xxxxxxxxxxxxx", ""], ["CHESNET", "04 91 72 90 00", "jchesnet@xxxxxxxxxxxxxxxxxxx", ""], ["MICHEL", "04 91 72 90 23", "smichel@xxxxxxxxxxxxxxxxxxx", ""], ["SALIGNON", "04 94 81 25 15", "salignon@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["BERTELLI", "04 91 29 41 68", "Elisabeth.BERTELLI@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["PAGLIA", "04 91 29 41 80", "bruno.paglia@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["ROY", "", "cprien.roy@xxxxxxxxxxxxxxxxxxxxxxx", ""], ["ARLIN", "04 95 06 97 00", "info@xxxxxxxxx", ""], ["TOMASZEK", "09 60 46 23 09", "jean-pierre.tomaszek@xxxxxxxxxx", ""], ["DESCHAMPS", "04 13 94 04 12", "s.deschamps@xxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["PONTIER", "04 91 39 33 94", "vpontier@xxxxxxxxxxxxxxxxxx", ""], ["BENAICHE", "", "abenaich@xxxxxxxx", ""], ["BERTUCCI", "04 90 78 80 40", "abertucci@xxxxxxxxxxxxxxxxxxxx", ""], ["BOURGEAISEAU", "", "vhalluin@xxxxxxxxxxxxx", ""], ["CHAPERON", "", "jean_luc.chaperon@xxxxxxxxxx", ""], ["CHAUCHE", "", "philippe.chauche@xxxxxxxxxxxxxxx", ""], ["COURRIEU", "04 91 90 92 93", "sophie.courrieu@xxxxxxxxx", ""], ["CROZEL", "04 91 84 47 38", "jlcrozel@xxxxxxxxxxxxxxxxxxxx", ""], ["DEBACKER", "04 90 80 70 43", "ndebacker@xxxxxxxxxxxxxxxxxxxx", ""], ["DELEPINE", "04 92 96 11 45", "bruno.delepine@xxxxxxxxxxx", ""], ["DUTOYA", "", "marie-pascale.dutoya@xxxxxxxxxxxxxxxx", ""], ["FINE", "", "Noelle.FINE@xxxxxxxxxx", ""], ["GAILLARD", "", "laurent.gaillard@xxxxxxxxxxxxxx", ""], ["GROS", "04 92 29 76 90", "patrick.gros@xxxxxxx", ""], ["GSCHWIND", "04 93 70 05 91", "m.gschwind@xxxxxxxx", ""], ["ISSARD", "", "issardfr@xxxxxxxxx", ""], ["LASCOLS", "04 94 21 90 34", "h.lascols@xxxxxxxxxxxxxxxxxxxxxxxxxxx", ""], ["LE BAIL", "", "m.lebail@xxxxxxxxxxx", ""], ["MAGAT", "04 92 17 38 17", "catherine.magat@xxxxxxxxxxxxxxxxxxx", ""], ["MANENT", "04 91 13 32 51", "jh.manent@xxxxxx", ""], ["MAUNIER", "04 83 28 80 50", "m.maunier@xxxxxxxxxxxxxxxxx", ""], ["MAZIANI", "04 93 20 10 21", "alda@xxxxxxxxxxxxx", ""], ["MENUEY", "04 91 79 21 78", "virginie@xxxxxxxxxxxxxxxxx", ""], ["MEYRIGNAC", "", "c.meyrignac@xxxxxxxxxxxx", ""], ["Michel", "", "michel@xxxxxxxxxxxxxxxxx", ""], ["MOTTE", "00377 93 25 74 37", "monaco-principaute@xxxxxx", ""], ["NICOLET", "04 90 13 68 40", "vnicolet@xxxxxxxxxxxxx", ""], ["RODRIGUEZ", "", "arodriguez@xxxxxxxxxxxxxxxxxx", ""], ["DELUCA", "04 91 13 41 56", "j.deluca@xxxxxxxxxxxx", ""], ["CHOUX", "04 91 13 41 50", "l.choux@xxxxxxxxxxxx", ""], ["DELUCA", "04 91 13 41 79", "t.deluca@xxxxxxxxxxxx", ""], ["LECOMPTE", "", "message@xxxxxxxxxxxxxxxxx", ""], ["GACHON", "", "bertrand.gachon@xxxxxxxx", ""], ["CORDOLIANI", "", "martine.cordoliani@xxxxxxxxxxxxx", ""], ["Domec", "", "mathilde.domec@xxxxxxxxxx", ""], ["Rouan", "04 91 91 29 59", "centresocial@xxxxxxxxxxxxxxxxxx", ""], ["Marini", "04 91 85 63 18", "charlotte.marini@xxxxxxxxxx", ""], ["Driget", "04 91 74 2012", "delphine.driget@xxxxxxxxxx", ""], ["Jubert", "04 91 35 72 80", "sylvie.jubert@xxxxxxxxxx", ""], ["Clermont", "04 91 50 83 88", "afev.marseille@xxxxxxxxx", ""], ["Castel", "04 91 18 70 90", "aec.escourtines@xxxxxxx", ""], ["Flambeau", "04 91 62 28 09", "labelledemai1@xxxxxxx", ""], ["Touchot", "04 91 13 71 87", "contact@xxxxxxxxxxxxx", ""], ["Flores", "04 91 62 82 40", "odile.flore@xxxxxxxxxx", ""], ["Caruette", "04 91 01 56 20", "mpt.corderie@xxxxxxxxxxxx", ""], ["Dogliani", "04 96 12 20 20", "mpt.tivoli@xxxxxxxxxxxx", ""], ["Miguel", "04 91 62 55 05", "belledemai@xxxxxxxxxxxxxxxxxxx", ""], ["Amette", "", "laurence.amette@xxxxxxxxxxxxxxx", ""], ["Blin", "", "jerome.blin@xxxxxxxxxxxx", ""], ["DE CROZET", "", "decrozet@xxxxxxxxx", ""], ["LEBEL", "", "frede.lebel@xxxxxxxxx", ""], ["Garay", "", "bgaray@xxxxxxxxxxxxxxxxx", ""], ["BARBACCIA", "", "abarbaccia@xxxxxxxxxxx", ""], ["PATEBEX", "", "madeleine.patebex@xxxxxxxxxxxxxxxx", ""], ["MOURET", "", "citymagazine@xxxxxxxxxx", ""], ["BALLAND", "", "cballand@xxxxxxxxxxxxx", ""], ["SERFATY", "", "lserfaty@xxxxxxxxxxxxx", ""], ["BOURGET", "", "bourgetph@xxxxxxxx", ""], ["SZEREMETA", "", "szeremeta@xxxxxxxxxxxxx", ""], ["MAGNIN", "", "magnin@xxxxxxxxxxxxx", ""], ["ROUSSAT", "", "isabelle.roussat@xxxxxxxxxxxxxxxxx", ""], ["LANGUMIER", "", "lettre.aventure@xxxxxxxxx", ""], ["REVOL", "", "crevol@xxxxxxxxxxxxxxxxx", ""], ["REVOL", "", "crevol@xxxxxxxxxxxxxxxxx", ""], ["EYMERY", "", "celine@xxxxxxxxxxx", ""], ["EYMERY", "", "celine@xxxxxxxxxxx", ""], ["GEOFFROY", "", "pgeoffroy@xxxxxx", ""], ["Chaix", "", "chaix@xxxxxxxxx", ""], ["Laugier", "", "", ""], ["Malonda", "", "silviamalonda@xxxxxx", ""], ["Girard", "", "laetitia-girard@xxxxxxxxx", ""], ["Mourgues", "", "cmourgues@xxxxxxx", ""], ["Chabot", "", "", ""], ["BELHADJ", "", "belbaya@xxxxxxxxxx", ""], ["Noname", "", "", ""], ["Liget", "", "stephane-liget@xxxxxxxxx", ""], ["Lari", "", "c_lari@xxxxxxxxxxx", ""], ["Guinet", "", "alain_guinet@xxxxxxxx", ""], ["Robin", "", "robincoullet@xxxxxxx", ""], ["Tamisier", "", "christian.tamisier@xxxxxxxxxx", ""], ["Delarue", "", "contact@xxxxxxxxxxxxxxxx", ""], ["Didon", "", "", ""], ["KALAYDJIAN", "", "talinekalaydjian@xxxxxxxxxxx", ""], ["Largois", "", "philippelargois@xxxxxxxx", ""], ["Lalet", "", "lisalalet@xxxxxxxxx", ""], ["Monti", "", "liliane.monti@xxxxxxx", ""], ["Aubert", "", "aubert_perrine@xxxxxxxx", ""], ["Granaux", "", "agranaux@xxxxxxxxx", ""], ["Didon", "", "olivier.didon@xxxxxxx", ""], ["Volpi", "", "j.p13@xxxxxxx", ""], ["Faneau", "", "mathieu.faneau@xxxxxxxxxxx", ""], ["Moure", "", "", ""], ["Bothwell", "", "katywatson2011@xxxxxxxxx", ""], ["Lehmann", "", "drplehmann@xxxxxxxxx", ""], ["Basch", "", "pierre.basch@xxxxxxxxxxxx", ""], ["Saunier", "", "danaesb@xxxxxxxxxx", ""], ["Breton", "", "zenplongeemarseille@xxxxxxxxx", ""], ["Pierre", "", "phil.pperso@xxxxxxxxx", ""], ["Pierre", "", "comptaedjo@xxxxxxxx", ""], ["Forman", "", "a.forman@xxxxxxx", ""], ["Wilson", "", "juliet.nick@xxxxxxxxxxxxxx", ""], ["Dallet", "", "franck.glardon@xxxxxxxxxxxx", ""], ["Giraud", "", "cam2malta@xxxxxxxxxxx", ""], ["Annabelle", "", "annabelle.arnaud@xxxxxxxxxxx", ""], ["Torrice", "", "virginietorrice@xxxxxxxxx", ""], ["Rolland", "", "justine34-22@xxxxxxxxxx", ""], ["Fushino", "", "fuschy@xxxxxxx", ""], ["Cenu", "", "stephane.chenu1@xxxxxxxxxxx", ""], ["Yvinec", "", "yoann_yvinec@xxxxxxxxxx", ""], ["Legier", "", "ludovic.legier@xxxxxxxxx", ""], ["Dupont", "", "alice@xxxxxxxxxxxxxxx", ""], ["Boronat", "", "variantapaca@xxxxxxx", ""], ["Lavanant", "", "", ""], ["Francois", "", "aureliefrancois13@xxxxxxxxx", ""], ["Colson", "", "colson-thomas@xxxxxxxxx", ""], ["Church", "", "church_k@xxxxxxxxxxx", ""], ["Ennen", "", "a.ennen@xxxxxx", ""], ["Housiaux", "", "housiaux_sophie@xxxxxxxxxxx", ""], ["Minetti", "", "minetti.caroline@xxxxxxxxx", ""], ["Rolland", "", "anne.laurent13@xxxxxxxxxx", ""], ["Keusters", "", "olivia@xxxxxxxxxxxx", ""], ["Legier", "", "ludovic.legier@xxxxxxxxx", ""], ["Debiais", "", "julien_debiais3@xxxxxxxxxx", ""], ["Dallet", "", "franck.dallet@xxxxxxxxx", ""], ["Lavigne", "", "philou@xxxxxxxxxxxxxx", ""], ["Brozo", "", "sbrozo@xxxxxxxxxxx", ""], ["Conand", "", "delphine.conand@xxxxxxxxxxx", ""], ["Tissot", "", "peace_and_peace20@xxxxxxxxxx", ""], ["Roman", "", "danyetcendrine@xxxxxxxxx", ""], ["Delory", "", "celinegamelin@xxxxxxxxxx", ""], ["Chambon", "", "", ""], ["Duquesne", "", "jujuduquesne@xxxxxxxxx", ""], ["Mao", "", "anthony.mao@xxxxxxxxxxx", ""], ["Galinier", "", "sabine.galinier-warrain@xxxxxxxxxx", ""], ["Cozette", "", "n.cozette@xxxxxxxx", ""], ["Abderam", "", "abderam.ach@xxxxxxxxx", ""], ["Despr\u00e9aux", "", "antipode.com@xxxxxxxxxx", ""], ["Walker", "", "", ""], ["Schuler", "", "dodieschuler@xxxxxxxxxx", ""], ["Tellois", "", "tellois@xxxxxxx", ""], ["Prevost", "", "pelotho@xxxxxxx", ""], ["Granger", "", "robin.granger@xxxxxxxxxx", ""], ["Cambour", "", "marieange.cambour@xxxxxx", ""], ["Baujard", "", "clm_baujard@xxxxxxxx", ""], ["Olejarz", "", "anouk_olejarz@xxxxxxxx", ""], ["Damis", "", "damishelene@xxxxxxxx", ""], ["Scheer", "", "j.scheer@xxxxxxxx", ""], ["Cohen", "", "mikacohen@xxxxxxxx", ""], ["Remond", "", "remond_o@xxxxxxxx", ""], ["DIETSCHY", "", "conceptdiet@xxxxxxxxxx", ""], ["Sampol", "", "sampol.jerome@xxxxxxxxxx", ""], ["Combe", "", "lionel.combe@xxxxxxxxxx", ""], ["Lehner", "", "christophe.lehner@xxxxxxxxx", ""], ["Balbous", "", "kerinfo@xxxxxxxxxxx", ""], ["Girola", "", "delphgir@xxxxxxxxx", ""], ["Sauvegrain", "", "stephaniesauvegrain@xxxxxxxxxxx", ""], ["Daniel", "", "w-daniel@xxxxxxx", ""], ["Ambler", "", "liz.ambler@xxxxxxxxxxxxxxxx", ""], ["Le Flem", "", "", ""], ["LILTI", "", "simon_lilti@xxxxxxxxxxx", ""], ["Dewavrin", "", "c.dewavrin@xxxxxxxxxxxxxxxxxx", ""], ["Leveque", "", "juju.lvq@xxxxxxxxx", ""], ["Alonso", "671675134", "valerie.alonso@xxxxxxxxxxxxxxx", ""], ["Jan", "", "mylilie56@xxxxxxxxxx", ""], ["Joly", "", "kichrisjoly@xxxxxxxxx", ""], ["Marganne", "", "martine.marganne@xxxxxxxxxxx", ""], ["Rousset-rouvi\u00e8re", "", "roussetrouviere.jb@xxxxxxx", ""], ["Belin", "685443885", "patricia.belin@xxxxxxxxx", ""], ["Clavel", "476786068", "laudel38@xxxxxxx", ""], ["Svetchine", "638299987", "annesophie.svetchine@xxxxxxxxxx", ""], ["Le-hingrat", "646752132", "yos.onel@xxxxxxxx", ""], ["delmas", "565695311", "delmas.anne-marie@xxxxxxxxxx", ""], ["Henry", "678229870", "alexandra.henry@xxxxxxx", ""], ["Mme blasquez", "442901422", "benedicte.triboulloy@xxxxxxxxxxxxxx", ""], ["Brodin", "243003873", "jlbrod@xxxxxxx", ""], ["Detee", "450032005", "Claude.Detee@xxxxxxxxxx", ""], ["Veys", "619194983", "raphaelveys@xxxxxxxxxxx", ""], ["Sirven", "", "", ""], ["Margueron", "41799558014", "sophiemargueron@xxxxxxxxxxx", ""], ["Duval", "677876710", "delphine.duval.delort@xxxxxxxxx", ""], ["R\u00e9possi", "04.42.65.65.57", "info.jeunes.fuveau@xxxxxxxxxx", ""], ["Beitz", "206-225-7477", "laurie.beitz@xxxxxxxxxxx", ""], ["Dupouy", "", "r.dupouy@xxxxxxxxx", ""], ["Lebrun", "04-42-65-65-60", "glebrun@xxxxxxxxxxxxxxxxx", ""], ["Juin", "689159216", "celinejuin@xxxxxxxxx", ""], ["Motte", "663572998", "teddymotte@xxxxxxxxx", ""], ["Schlier", "670001407", "i.schlier@xxxxxxxxxxxxxxxxxxx", ""], ["Lorin", "492320975", "lorin.ml@xxxxxxxxxx", ""], ["Fouzai", "661836445", "fouzai@xxxxxxxxx", ""], ["Luyza", "", "luyza1@xxxxxxxxx", ""], ["Akinian", "664413175", "akiniananagallis@xxxxxxxxxxx", ""], ["Martinez", "648691593", "elodie762@xxxxxxxx", ""], ["Passi", "0631383394/0478072727", "jl.passi@xxxxxxxxxxx", ""], ["Murno", "", "h_murno@xxxxxxxxx", ""], ["Baudon", "625485550", "baudon@xxxxxxxxxxxxxxxxx", ""], ["Marzan", "", "", ""], ["Jardat", "660353675", "delphinesouthon@xxxxxxxxx", ""], ["Chollet", "", "nicolas.chollet@xxxxxxxxx", ""], ["Avon", "610253617", "brunoavon@xxxxxxx", ""], ["Villis smith", "610054816", "michellevillis@xxxxxxxxxxx", ""], ["Karila", "646793017", "patricia.louis719@xxxxxxxxx", ""], ["Masselot", "640069208", "gilmasselot@xxxxxxxxx", ""], ["viallard", "686776628", "aurelievd@xxxxxxxxxx", ""], ["Martin", "", "", ""], ["Mary", "0491227869/0680042740", "mary.michel@xxxxxxxxx", ""], ["Pouchoulin", "610698742", "mylilie56@xxxxxxxxxx", ""], ["Jovanovic", "686345154", "", ""]]
\ No newline at end of file

=== modified file 'openerp/tests/addons/test_impex/tests/test_import.py'
--- openerp/tests/addons/test_impex/tests/test_import.py	2012-09-12 04:35:51 +0000
+++ openerp/tests/addons/test_impex/tests/test_import.py	2012-10-08 13:46:29 +0000
@@ -80,9 +80,9 @@
     model_name = 'export.integer'
 
     def test_create_with_id(self):
-        self.assertRaises(
-            Exception, # dammit
-            self.import_, ['.id', 'value'], [['42', '36']])
+        self.assertEqual(
+            self.import_(['.id', 'value'], [['42', '36']]),
+            error(1, u"Unknown database identifier '42'"))
     def test_create_with_xid(self):
         self.assertEqual(
             self.import_(['id', 'value'], [['somexmlid', '42']]),
@@ -136,27 +136,25 @@
         self.assertEqual(
             self.import_(['value'], [
                 [u'0'],
-                [u'off'],
+                [u'no'],
                 [u'false'],
                 [u'FALSE'],
-                [u'OFF'],
                 [u''],
             ]),
-            ok(6))
+            ok(5))
         self.assertEqual([
                 False,
                 False,
                 False,
                 False,
                 False,
-                False,
             ],
             values(self.read()))
 
     def test_trues(self):
         self.assertEqual(
             self.import_(['value'], [
-                ['no'],
+                ['off'],
                 ['None'],
                 ['nil'],
                 ['()'],
@@ -164,10 +162,11 @@
                 ['#f'],
                 # Problem: OpenOffice (and probably excel) output localized booleans
                 ['VRAI'],
+                [u'OFF'],
             ]),
-            ok(7))
+            ok(8))
         self.assertEqual(
-            [True] * 7,
+            [True] * 8,
             values(self.read()))
 
 class test_integer_field(ImporterCase):
@@ -226,21 +225,20 @@
     def test_out_of_range(self):
         self.assertEqual(
             self.import_(['value'], [[str(2**31)]]),
-            error(1, "integer out of range\n", value=2**31))
+            error(1, "integer out of range\n"))
         # auto-rollbacks if error is in process_liness, but not during
         # ir.model.data write. Can differentiate because former ends lines
         # error lines with "!"
         self.cr.rollback()
         self.assertEqual(
             self.import_(['value'], [[str(-2**32)]]),
-            error(1, "integer out of range\n", value=-2**32))
+            error(1, "integer out of range\n"))
 
 
     def test_nonsense(self):
-        # FIXME: shit error reporting, exceptions half the time, messages the other half
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value'], [['zorglub']])
+        self.assertEqual(
+            self.import_(['value'], [['zorglub']]),
+            error(1, u"'zorglub' does not seem to be an integer for field 'unknown'"))
 
 class test_float_field(ImporterCase):
     model_name = 'export.float'
@@ -298,9 +296,9 @@
         ], values(self.read()))
 
     def test_nonsense(self):
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value'], [['foobar']])
+        self.assertEqual(
+            self.import_(['value'], [['foobar']]),
+            error(1, u"'foobar' does not seem to be a number for field 'unknown'"))
 
 class test_string_field(ImporterCase):
     model_name = 'export.string.bounded'
@@ -405,8 +403,6 @@
                 'value': value
             })
 
-        # FIXME: can't import an exported selection field label if lang != en_US
-        # (see test_export.test_selection.test_localized_export)
         self.assertEqual(
             self.import_(['value'], [
                 ['toto'],
@@ -417,27 +413,23 @@
         self.assertEqual([3, 1, 2], values(self.read()))
         self.assertEqual(
             self.import_(['value'], [['Foo']], context={'lang': 'fr_FR'}),
-            error(1, "Key/value 'Foo' not found in selection field 'value'",
-                  value=False))
+            ok(1))
 
     def test_invalid(self):
         self.assertEqual(
             self.import_(['value'], [['Baz']]),
-            error(1, "Key/value 'Baz' not found in selection field 'value'",
-                  # what the fuck?
-                  value=False))
+            error(1, u"Value 'Baz' not found in selection field 'unknown'"))
         self.cr.rollback()
         self.assertEqual(
             self.import_(['value'], [[42]]),
-            error(1, "Key/value '42' not found in selection field 'value'",
-                  value=False))
+            error(1, u"Value '42' not found in selection field 'unknown'"))
 
 class test_selection_function(ImporterCase):
     model_name = 'export.selection.function'
     translations_fr = [
         ("Corge", "toto"),
         ("Grault", "titi"),
-        ("Whee", "tete"),
+        ("Wheee", "tete"),
         ("Moog", "tutu"),
     ]
 
@@ -482,8 +474,7 @@
                 ['toto'],
                 ['tete'],
             ], context={'lang': 'fr_FR'}),
-            error(1, "Key/value 'toto' not found in selection field 'value'",
-                  value=False))
+            ok(2))
         self.assertEqual(
             self.import_(['value'], [['Wheee']], context={'lang': 'fr_FR'}),
             ok(1))
@@ -555,7 +546,6 @@
         self.assertEqual(
             self.import_(['value'], [[name2]]),
             ok(1))
-        # FIXME: is it really normal import does not care for name_search collisions?
         self.assertEqual([
             (integer_id1, name1)
         ], values(self.read()))
@@ -569,35 +559,35 @@
         integer_id2 = self.registry('export.integer').create(
             self.cr, openerp.SUPERUSER_ID, {'value': 36})
 
-        self.assertRaises(
-            ValueError, # Because name_search all the things. Fallback schmallback
-            self.import_, ['value'], [
+        self.assertEqual(
+            self.import_(['value'], [
                 # import by id, without specifying it
                 [integer_id1],
                 [integer_id2],
                 [integer_id1],
-            ])
+            ]),
+            error(1, u"No matching record found for name '%s' in field 'unknown'" % integer_id1))
 
     def test_sub_field(self):
         """ Does not implicitly create the record, does not warn that you can't
         import m2o subfields (at all)...
         """
-        self.assertRaises(
-            ValueError, # No record found for 42, name_searches the bloody thing
-            self.import_, ['value/value'], [['42']])
+        self.assertEqual(
+            self.import_(['value/value'], [['42']]),
+            error(1, u"Can not create Many-To-One records indirectly, import the field separately"))
 
     def test_fail_noids(self):
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value'], [['nameisnoexist:3']])
-        self.cr.rollback()
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value/id'], [['noxidhere']]),
-        self.cr.rollback()
-        self.assertRaises(
-            Exception, # FIXME: Why can't you be a ValueError like everybody else?
-            self.import_, ['value/.id'], [[66]])
+        self.assertEqual(
+            self.import_(['value'], [['nameisnoexist:3']]),
+            error(1, u"No matching record found for name 'nameisnoexist:3' in field 'unknown'"))
+        self.cr.rollback()
+        self.assertEqual(
+            self.import_(['value/id'], [['noxidhere']]),
+            error(1, u"No matching record found for external id 'noxidhere' in field 'unknown'"))
+        self.cr.rollback()
+        self.assertEqual(
+            self.import_(['value/.id'], [[66]]),
+            error(1, u"No matching record found for database id '66' in field 'unknown'"))
 
 class test_m2m(ImporterCase):
     model_name = 'export.many2many'
@@ -635,12 +625,9 @@
         self.assertEqual(values(b[2].value), [3, 44, 84])
 
     def test_noids(self):
-        try:
-            self.import_(['value/.id'], [['42']])
-            self.fail("Should have raised an exception")
-        except Exception, e:
-            self.assertIs(type(e), Exception,
-                          "test should be fixed on exception subclass")
+        self.assertEqual(
+            self.import_(['value/.id'], [['42']]),
+            error(1, u"No matching record found for database id '42' in field 'unknown'"))
 
     def test_xids(self):
         M2O_o = self.registry('export.many2many.other')
@@ -662,9 +649,9 @@
         self.assertEqual(values(b[0].value), [3, 44])
         self.assertEqual(values(b[2].value), [44, 84])
     def test_noxids(self):
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value/id'], [['noxidforthat']])
+        self.assertEqual(
+            self.import_(['value/id'], [['noxidforthat']]),
+            error(1, u"No matching record found for external id 'noxidforthat' in field 'unknown'"))
 
     def test_names(self):
         M2O_o = self.registry('export.many2many.other')
@@ -689,9 +676,9 @@
         self.assertEqual(values(b[2].value), [3, 9])
 
     def test_nonames(self):
-        self.assertRaises(
-            ValueError,
-            self.import_, ['value'], [['wherethem2mhavenonames']])
+        self.assertEqual(
+            self.import_(['value'], [['wherethem2mhavenonames']]),
+            error(1, u"No matching record found for name 'wherethem2mhavenonames' in field 'unknown'"))
 
     def test_import_to_existing(self):
         M2O_o = self.registry('export.many2many.other')
@@ -717,13 +704,13 @@
     model_name = 'export.one2many'
 
     def test_name_get(self):
-        # FIXME: bloody hell why can't this just name_create the record?
-        self.assertRaises(
-            IndexError,
-            self.import_,
-            ['const', 'value'],
-            [['5', u'Java is a DSL for taking large XML files'
-                   u' and converting them to stack traces']])
+        s = u'Java is a DSL for taking large XML files and converting them to' \
+            u' stack traces'
+        self.assertEqual(
+            self.import_(
+                ['const', 'value'],
+                [['5', s]]),
+            error(1, u"No matching record found for name '%s' in field 'unknown'" % s))
 
     def test_single(self):
         self.assertEqual(
@@ -813,14 +800,11 @@
             ]),
             ok(2))
 
-        # No record values alongside id => o2m resolution skipped altogether,
-        # creates 2 records => remove/don't import columns sideshow columns,
-        # get completely different semantics
-        b, b1 = self.browse()
+        [b] = self.browse()
         self.assertEqual(b.const, 42)
-        self.assertEqual(values(b.value), [])
-        self.assertEqual(b1.const, 4)
-        self.assertEqual(values(b1.value), [])
+        # automatically forces link between core record and o2ms
+        self.assertEqual(values(b.value), [109, 262])
+        self.assertEqual(values(b.value, field='parent_id'), [b, b])
 
     def test_link_2(self):
         O2M_c = self.registry('export.one2many.child')
@@ -838,21 +822,10 @@
             ]),
             ok(2))
 
-        (b,) = self.browse()
-        # if an id (db or xid) is provided, expectations that objects are
-        # *already* linked and emits UPDATE (1, id, {}).
-        # Noid => CREATE (0, ?, {})
-        # TODO: xid ignored aside from getting corresponding db id?
+        [b] = self.browse()
         self.assertEqual(b.const, 42)
-        self.assertEqual(values(b.value), [])
-
-        # FIXME: updates somebody else's records?
-        self.assertEqual(
-            O2M_c.read(self.cr, openerp.SUPERUSER_ID, id1),
-            {'id': id1, 'str': 'Bf', 'value': 1, 'parent_id': False})
-        self.assertEqual(
-            O2M_c.read(self.cr, openerp.SUPERUSER_ID, id2),
-            {'id': id2, 'str': 'Me', 'value': 2, 'parent_id': False})
+        self.assertEqual(values(b.value), [1, 2])
+        self.assertEqual(values(b.value, field='parent_id'), [b, b])
 
 class test_o2m_multiple(ImporterCase):
     model_name = 'export.one2many.multiple'
@@ -866,16 +839,10 @@
                 ['', '14', ''],
             ]),
             ok(4))
-        # Oh yeah, that's the stuff
-        (b, b1, b2) = self.browse()
-        self.assertEqual(values(b.child1), [11])
-        self.assertEqual(values(b.child2), [21])
-
-        self.assertEqual(values(b1.child1), [12])
-        self.assertEqual(values(b1.child2), [22])
-
-        self.assertEqual(values(b2.child1), [13, 14])
-        self.assertEqual(values(b2.child2), [23])
+
+        [b] = self.browse()
+        self.assertEqual(values(b.child1), [11, 12, 13, 14])
+        self.assertEqual(values(b.child2), [21, 22, 23])
 
     def test_multi(self):
         self.assertEqual(
@@ -888,11 +855,10 @@
                 ['', '', '23'],
             ]),
             ok(6))
-        # What the actual fuck?
-        (b, b1) = self.browse()
+
+        [b] = self.browse()
         self.assertEqual(values(b.child1), [11, 12, 13, 14])
-        self.assertEqual(values(b.child2), [21])
-        self.assertEqual(values(b1.child2), [22, 23])
+        self.assertEqual(values(b.child2), [21, 22, 23])
 
     def test_multi_fullsplit(self):
         self.assertEqual(
@@ -906,12 +872,11 @@
                 ['', '', '23'],
             ]),
             ok(7))
-        # oh wow
-        (b, b1) = self.browse()
+
+        [b] = self.browse()
         self.assertEqual(b.const, 5)
         self.assertEqual(values(b.child1), [11, 12, 13, 14])
-        self.assertEqual(b1.const, 36)
-        self.assertEqual(values(b1.child2), [21, 22, 23])
+        self.assertEqual(values(b.child2), [21, 22, 23])
 
 # function, related, reference: written to db as-is...
 # => function uses @type for value coercion/conversion

=== added file 'openerp/tests/addons/test_impex/tests/test_load.py'
--- openerp/tests/addons/test_impex/tests/test_load.py	1970-01-01 00:00:00 +0000
+++ openerp/tests/addons/test_impex/tests/test_load.py	2012-10-08 13:46:29 +0000
@@ -0,0 +1,1043 @@
+# -*- coding: utf-8 -*-
+import json
+import pkgutil
+
+import openerp.modules.registry
+import openerp
+
+from openerp.tests import common
+from openerp.tools.misc import mute_logger
+
+def message(msg, type='error', from_=0, to_=0, record=0, field='value', **kwargs):
+    return dict(kwargs,
+                type=type, rows={'from': from_, 'to': to_}, record=record,
+                field=field, message=msg)
+def moreaction(**kwargs):
+    return dict(kwargs,
+        type='ir.actions.act_window',
+        target='new',
+        view_mode='tree,form',
+        view_type='form',
+        views=[(False, 'tree'), (False, 'form')],
+        help=u"See all possible values")
+
+def values(seq, field='value'):
+    return [item[field] for item in seq]
+
+class ImporterCase(common.TransactionCase):
+    model_name = False
+
+    def __init__(self, *args, **kwargs):
+        super(ImporterCase, self).__init__(*args, **kwargs)
+        self.model = None
+
+    def setUp(self):
+        super(ImporterCase, self).setUp()
+        self.model = self.registry(self.model_name)
+        self.registry('ir.model.data').clear_caches()
+
+    def import_(self, fields, rows, context=None):
+        return self.model.load(
+            self.cr, openerp.SUPERUSER_ID, fields, rows, context=context)
+    def read(self, fields=('value',), domain=(), context=None):
+        return self.model.read(
+            self.cr, openerp.SUPERUSER_ID,
+            self.model.search(self.cr, openerp.SUPERUSER_ID, domain, context=context),
+            fields=fields, context=context)
+    def browse(self, domain=(), context=None):
+        return self.model.browse(
+            self.cr, openerp.SUPERUSER_ID,
+            self.model.search(self.cr, openerp.SUPERUSER_ID, domain, context=context),
+            context=context)
+
+    def xid(self, record):
+        ModelData = self.registry('ir.model.data')
+
+        ids = ModelData.search(
+            self.cr, openerp.SUPERUSER_ID,
+            [('model', '=', record._table_name), ('res_id', '=', record.id)])
+        if ids:
+            d = ModelData.read(
+                self.cr, openerp.SUPERUSER_ID, ids, ['name', 'module'])[0]
+            if d['module']:
+                return '%s.%s' % (d['module'], d['name'])
+            return d['name']
+
+        name = dict(record.name_get())[record.id]
+        # fix dotted name_get results, otherwise xid lookups blow up
+        name = name.replace('.', '-')
+        ModelData.create(self.cr, openerp.SUPERUSER_ID, {
+            'name': name,
+            'model': record._table_name,
+            'res_id': record.id,
+            'module': '__test__'
+        })
+        return '__test__.' + name
+
+    def add_translations(self, name, type, code, *tnx):
+        Lang = self.registry('res.lang')
+        if not Lang.search(self.cr, openerp.SUPERUSER_ID, [('code', '=', code)]):
+            Lang.create(self.cr, openerp.SUPERUSER_ID, {
+                'name': code,
+                'code': code,
+                'translatable': True,
+                'date_format': '%d.%m.%Y',
+                'decimal_point': ',',
+            })
+        Translations = self.registry('ir.translation')
+        for source, value in tnx:
+            Translations.create(self.cr, openerp.SUPERUSER_ID, {
+                'name': name,
+                'lang': code,
+                'type': type,
+                'src': source,
+                'value': value,
+                'state': 'translated',
+            })
+
+class test_ids_stuff(ImporterCase):
+    model_name = 'export.integer'
+
+    def test_create_with_id(self):
+        result = self.import_(['.id', 'value'], [['42', '36']])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [{
+            'type': 'error',
+            'rows': {'from': 0, 'to': 0},
+            'record': 0,
+            'field': '.id',
+            'message': u"Unknown database identifier '42'",
+        }])
+    def test_create_with_xid(self):
+        result = self.import_(['id', 'value'], [['somexmlid', '42']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual(
+            'somexmlid',
+            self.xid(self.browse()[0]))
+
+    def test_update_with_id(self):
+        id = self.model.create(self.cr, openerp.SUPERUSER_ID, {'value': 36})
+        self.assertEqual(
+            36,
+            self.model.browse(self.cr, openerp.SUPERUSER_ID, id).value)
+
+        result = self.import_(['.id', 'value'], [[str(id), '42']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual(
+            [42], # updated value to imported
+            values(self.read()))
+
+    def test_update_with_xid(self):
+        self.import_(['id', 'value'], [['somexmlid', '36']])
+        self.assertEqual([36], values(self.read()))
+
+        self.import_(['id', 'value'], [['somexmlid', '1234567']])
+        self.assertEqual([1234567], values(self.read()))
+
+class test_boolean_field(ImporterCase):
+    model_name = 'export.boolean'
+
+    def test_empty(self):
+        self.assertEqual(
+            self.import_(['value'], []),
+            {'ids': [], 'messages': []})
+
+    def test_exported(self):
+        result = self.import_(['value'], [['False'], ['True'], ])
+        self.assertEqual(len(result['ids']), 2)
+        self.assertFalse(result['messages'])
+        records = self.read()
+        self.assertEqual([
+            False,
+            True,
+        ], values(records))
+
+    def test_falses(self):
+        for lang, source, value in [('fr_FR', 'no', u'non'),
+                                    ('de_DE', 'no', u'nein'),
+                                    ('ru_RU', 'no', u'нет'),
+                                    ('nl_BE', 'false', u'vals'),
+                                    ('lt_LT', 'false', u'klaidingas')]:
+            self.add_translations('test_import.py', 'code', lang, (source, value))
+        falses = [[u'0'], [u'no'], [u'false'], [u'FALSE'], [u''],
+                  [u'non'], # no, fr
+                  [u'nein'], # no, de
+                  [u'нет'], # no, ru
+                  [u'vals'], # false, nl
+                  [u'klaidingas'], # false, lt,
+        ]
+
+        result = self.import_(['value'], falses)
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), len(falses))
+        self.assertEqual([False] * len(falses), values(self.read()))
+
+    def test_trues(self):
+        trues = [['None'], ['nil'], ['()'], ['f'], ['#f'],
+                  # Problem: OpenOffice (and probably excel) output localized booleans
+                  ['VRAI'], ['ok'], ['true'], ['yes'], ['1'], ]
+        result = self.import_(['value'], trues)
+        self.assertEqual(len(result['ids']), 10)
+        self.assertEqual(result['messages'], [
+            message(u"Unknown value '%s' for boolean field 'unknown', assuming 'yes'" % v[0],
+                    moreinfo=u"Use '1' for yes and '0' for no",
+                    type='warning', from_=i, to_=i, record=i)
+            for i, v in enumerate(trues)
+            if v[0] not in ('true', 'yes', '1')
+        ])
+        self.assertEqual(
+            [True] * 10,
+            values(self.read()))
+
+class test_integer_field(ImporterCase):
+    model_name = 'export.integer'
+
+    def test_none(self):
+        self.assertEqual(
+            self.import_(['value'], []),
+            {'ids': [], 'messages': []})
+
+    def test_empty(self):
+        result = self.import_(['value'], [['']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual(
+            [False],
+            values(self.read()))
+
+    def test_zero(self):
+        result = self.import_(['value'], [['0']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+
+        result = self.import_(['value'], [['-0']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+
+        self.assertEqual([False, False], values(self.read()))
+
+    def test_positives(self):
+        result = self.import_(['value'], [
+            ['1'],
+            ['42'],
+            [str(2**31-1)],
+            ['12345678']
+        ])
+        self.assertEqual(len(result['ids']), 4)
+        self.assertFalse(result['messages'])
+
+        self.assertEqual([
+            1, 42, 2**31-1, 12345678
+        ], values(self.read()))
+
+    def test_negatives(self):
+        result = self.import_(['value'], [
+            ['-1'],
+            ['-42'],
+            [str(-(2**31 - 1))],
+            [str(-(2**31))],
+            ['-12345678']
+        ])
+        self.assertEqual(len(result['ids']), 5)
+        self.assertFalse(result['messages'])
+        self.assertEqual([
+            -1, -42, -(2**31 - 1), -(2**31), -12345678
+        ], values(self.read()))
+
+    @mute_logger('openerp.sql_db')
+    def test_out_of_range(self):
+        result = self.import_(['value'], [[str(2**31)]])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [{
+            'type': 'error',
+            'rows': {'from': 0, 'to': 0},
+            'record': 0,
+            'message': "integer out of range\n"
+        }])
+
+        result = self.import_(['value'], [[str(-2**32)]])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [{
+            'type': 'error',
+            'rows': {'from': 0, 'to': 0},
+            'record': 0,
+            'message': "integer out of range\n"
+        }])
+
+    def test_nonsense(self):
+        result = self.import_(['value'], [['zorglub']])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [{
+            'type': 'error',
+            'rows': {'from': 0, 'to': 0},
+            'record': 0,
+            'field': 'value',
+            'message': u"'zorglub' does not seem to be an integer for field 'unknown'",
+        }])
+
+class test_float_field(ImporterCase):
+    model_name = 'export.float'
+    def test_none(self):
+        self.assertEqual(
+            self.import_(['value'], []),
+            {'ids': [], 'messages': []})
+
+    def test_empty(self):
+        result = self.import_(['value'], [['']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual(
+            [False],
+            values(self.read()))
+
+    def test_zero(self):
+        result = self.import_(['value'], [['0']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+
+        result = self.import_(['value'], [['-0']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+
+        self.assertEqual([False, False], values(self.read()))
+
+    def test_positives(self):
+        result = self.import_(['value'], [
+            ['1'],
+            ['42'],
+            [str(2**31-1)],
+            ['12345678'],
+            [str(2**33)],
+            ['0.000001'],
+        ])
+        self.assertEqual(len(result['ids']), 6)
+        self.assertFalse(result['messages'])
+
+        self.assertEqual([
+            1, 42, 2**31-1, 12345678, 2.0**33, .000001
+        ], values(self.read()))
+
+    def test_negatives(self):
+        result = self.import_(['value'], [
+            ['-1'],
+            ['-42'],
+            [str(-2**31 + 1)],
+            [str(-2**31)],
+            ['-12345678'],
+            [str(-2**33)],
+            ['-0.000001'],
+        ])
+        self.assertEqual(len(result['ids']), 7)
+        self.assertFalse(result['messages'])
+        self.assertEqual([
+            -1, -42, -(2**31 - 1), -(2**31), -12345678, -2.0**33, -.000001
+        ], values(self.read()))
+
+    def test_nonsense(self):
+        result = self.import_(['value'], [['foobar']])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [
+            message(u"'foobar' does not seem to be a number for field 'unknown'")])
+
+class test_string_field(ImporterCase):
+    model_name = 'export.string.bounded'
+
+    def test_empty(self):
+        result = self.import_(['value'], [['']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual([False], values(self.read()))
+
+    def test_imported(self):
+        result = self.import_(['value'], [
+            [u'foobar'],
+            [u'foobarbaz'],
+            [u'Með suð í eyrum við spilum endalaust'],
+            [u"People 'get' types. They use them all the time. Telling "
+             u"someone he can't pound a nail with a banana doesn't much "
+             u"surprise him."]
+        ])
+        self.assertEqual(len(result['ids']), 4)
+        self.assertFalse(result['messages'])
+        self.assertEqual([
+            u"foobar",
+            u"foobarbaz",
+            u"Með suð í eyrum ",
+            u"People 'get' typ",
+        ], values(self.read()))
+
+class test_unbound_string_field(ImporterCase):
+    model_name = 'export.string'
+
+    def test_imported(self):
+        result = self.import_(['value'], [
+            [u'í dag viðrar vel til loftárása'],
+            # ackbar.jpg
+            [u"If they ask you about fun, you tell them – fun is a filthy"
+             u" parasite"]
+        ])
+        self.assertEqual(len(result['ids']), 2)
+        self.assertFalse(result['messages'])
+        self.assertEqual([
+            u"í dag viðrar vel til loftárása",
+            u"If they ask you about fun, you tell them – fun is a filthy parasite"
+        ], values(self.read()))
+
+class test_required_string_field(ImporterCase):
+    model_name = 'export.string.required'
+
+    @mute_logger('openerp.sql_db')
+    def test_empty(self):
+        result = self.import_(['value'], [[]])
+        self.assertEqual(result['messages'], [message(
+            u"Missing required value for the field 'unknown'")])
+        self.assertIs(result['ids'], False)
+
+    @mute_logger('openerp.sql_db')
+    def test_not_provided(self):
+        result = self.import_(['const'], [['12']])
+        self.assertEqual(result['messages'], [message(
+            u"Missing required value for the field 'unknown'")])
+        self.assertIs(result['ids'], False)
+
+class test_text(ImporterCase):
+    model_name = 'export.text'
+
+    def test_empty(self):
+        result = self.import_(['value'], [['']])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual([False], values(self.read()))
+
+    def test_imported(self):
+        s = (u"Breiðskífa er notað um útgefna hljómplötu sem inniheldur "
+             u"stúdíóupptökur frá einum flytjanda. Breiðskífur eru oftast "
+             u"milli 25-80 mínútur og er lengd þeirra oft miðuð við 33⅓ "
+             u"snúninga 12 tommu vínylplötur (sem geta verið allt að 30 mín "
+             u"hvor hlið).\n\nBreiðskífur eru stundum tvöfaldar og eru þær þá"
+             u" gefnar út á tveimur geisladiskum eða tveimur vínylplötum.")
+        result = self.import_(['value'], [[s]])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+        self.assertEqual([s], values(self.read()))
+
+class test_selection(ImporterCase):
+    model_name = 'export.selection'
+    translations_fr = [
+        ("Foo", "tete"),
+        ("Bar", "titi"),
+        ("Qux", "toto"),
+    ]
+
+    def test_imported(self):
+        result = self.import_(['value'], [
+            ['Qux'],
+            ['Bar'],
+            ['Foo'],
+            ['2'],
+        ])
+        self.assertEqual(len(result['ids']), 4)
+        self.assertFalse(result['messages'])
+        self.assertEqual([3, 2, 1, 2], values(self.read()))
+
+    def test_imported_translated(self):
+        self.add_translations(
+            'export.selection,value', 'selection', 'fr_FR', *self.translations_fr)
+
+        result = self.import_(['value'], [
+            ['toto'],
+            ['tete'],
+            ['titi'],
+        ], context={'lang': 'fr_FR'})
+        self.assertEqual(len(result['ids']), 3)
+        self.assertFalse(result['messages'])
+
+        self.assertEqual([3, 1, 2], values(self.read()))
+
+        result = self.import_(['value'], [['Foo']], context={'lang': 'fr_FR'})
+        self.assertEqual(len(result['ids']), 1)
+        self.assertFalse(result['messages'])
+
+    def test_invalid(self):
+        result = self.import_(['value'], [['Baz']])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [message(
+            u"Value 'Baz' not found in selection field 'unknown'",
+            moreinfo="Foo Bar Qux 4".split())])
+
+        result = self.import_(['value'], [[42]])
+        self.assertIs(result['ids'], False)
+        self.assertEqual(result['messages'], [message(
+            u"Value '42' not found in selection field 'unknown'",
+            moreinfo="Foo Bar Qux 4".split())])
+
+class test_selection_with_default(ImporterCase):
+    model_name = 'export.selection.withdefault'
+
+    def test_skip_empty(self):
+        """ Empty cells should be entirely skipped so that default values can
+        be inserted by the ORM
+        """
+        result = self.import_(['value'], [['']])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        self.assertEqual(
+            values(self.read()),
+            [2])
+
+class test_selection_function(ImporterCase):
+    model_name = 'export.selection.function'
+    translations_fr = [
+        ("Corge", "toto"),
+        ("Grault", "titi"),
+        ("Wheee", "tete"),
+        ("Moog", "tutu"),
+    ]
+
+    def test_imported(self):
+        """ import uses fields_get, so translates import label (may or may not
+        be good news) *and* serializes the selection function to reverse it:
+        import does not actually know that the selection field uses a function
+        """
+        # NOTE: conflict between a value and a label => pick first
+        result = self.import_(['value'], [
+            ['3'],
+            ["Grault"],
+        ])
+        self.assertEqual(len(result['ids']), 2)
+        self.assertFalse(result['messages'])
+        self.assertEqual(
+            ['3', '1'],
+            values(self.read()))
+
+    def test_translated(self):
+        """ Expects output of selection function returns translated labels
+        """
+        self.add_translations(
+            'export.selection,value', 'selection', 'fr_FR', *self.translations_fr)
+
+        result = self.import_(['value'], [
+            ['titi'],
+            ['tete'],
+        ], context={'lang': 'fr_FR'})
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 2)
+        self.assertEqual(values(self.read()), ['1', '2'])
+
+        result = self.import_(['value'], [['Wheee']], context={'lang': 'fr_FR'})
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+class test_m2o(ImporterCase):
+    model_name = 'export.many2one'
+
+    def test_by_name(self):
+        # create integer objects
+        integer_id1 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        integer_id2 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 36})
+        # get its name
+        name1 = dict(self.registry('export.integer').name_get(
+            self.cr, openerp.SUPERUSER_ID,[integer_id1]))[integer_id1]
+        name2 = dict(self.registry('export.integer').name_get(
+            self.cr, openerp.SUPERUSER_ID,[integer_id2]))[integer_id2]
+
+        result = self.import_(['value'], [
+            # import by name_get
+            [name1],
+            [name1],
+            [name2],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 3)
+        # correct ids assigned to corresponding records
+        self.assertEqual([
+            (integer_id1, name1),
+            (integer_id1, name1),
+            (integer_id2, name2),],
+            values(self.read()))
+
+    def test_by_xid(self):
+        ExportInteger = self.registry('export.integer')
+        integer_id = ExportInteger.create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        xid = self.xid(ExportInteger.browse(
+            self.cr, openerp.SUPERUSER_ID, [integer_id])[0])
+
+        result = self.import_(['value/id'], [[xid]])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+        b = self.browse()
+        self.assertEqual(42, b[0].value.value)
+
+    def test_by_id(self):
+        integer_id = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        result = self.import_(['value/.id'], [[integer_id]])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+        b = self.browse()
+        self.assertEqual(42, b[0].value.value)
+
+    def test_by_names(self):
+        integer_id1 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        integer_id2 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        name1 = dict(self.registry('export.integer').name_get(
+            self.cr, openerp.SUPERUSER_ID,[integer_id1]))[integer_id1]
+        name2 = dict(self.registry('export.integer').name_get(
+            self.cr, openerp.SUPERUSER_ID,[integer_id2]))[integer_id2]
+        # names should be the same
+        self.assertEqual(name1, name2)
+
+        result = self.import_(['value'], [[name2]])
+        self.assertEqual(
+            result['messages'],
+            [message(u"Found multiple matches for field 'unknown' (2 matches)",
+                     type='warning')])
+        self.assertEqual(len(result['ids']), 1)
+        self.assertEqual([
+            (integer_id1, name1)
+        ], values(self.read()))
+
+    def test_fail_by_implicit_id(self):
+        """ Can't implicitly import records by id
+        """
+        # create integer objects
+        integer_id1 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 42})
+        integer_id2 = self.registry('export.integer').create(
+            self.cr, openerp.SUPERUSER_ID, {'value': 36})
+
+        # Because name_search all the things. Fallback schmallback
+        result = self.import_(['value'], [
+                # import by id, without specifying it
+                [integer_id1],
+                [integer_id2],
+                [integer_id1],
+        ])
+        self.assertEqual(result['messages'], [
+            message(u"No matching record found for name '%s' in field 'unknown'" % id,
+                    from_=index, to_=index, record=index,
+                    moreinfo=moreaction(res_model='export.integer'))
+            for index, id in enumerate([integer_id1, integer_id2, integer_id1])])
+        self.assertIs(result['ids'], False)
+
+    @mute_logger('openerp.sql_db')
+    def test_fail_id_mistype(self):
+        result = self.import_(['value/.id'], [["foo"]])
+
+        self.assertEqual(result['messages'], [
+            message(u"Invalid database id 'foo' for the field 'unknown'",
+                    moreinfo=moreaction(res_model='ir.model.data',
+                                        domain=[('model','=','export.integer')]))
+        ])
+        self.assertIs(result['ids'], False)
+
+    def test_sub_field(self):
+        """ Does not implicitly create the record, does not warn that you can't
+        import m2o subfields (at all)...
+        """
+        result = self.import_(['value/value'], [['42']])
+        self.assertEqual(result['messages'], [
+            message(u"Can not create Many-To-One records indirectly, import "
+                    u"the field separately")])
+        self.assertIs(result['ids'], False)
+
+    def test_fail_noids(self):
+        result = self.import_(['value'], [['nameisnoexist:3']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for name 'nameisnoexist:3' "
+            u"in field 'unknown'", moreinfo=moreaction(
+                res_model='export.integer'))])
+        self.assertIs(result['ids'], False)
+
+        result = self.import_(['value/id'], [['noxidhere']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for external id 'noxidhere' "
+            u"in field 'unknown'", moreinfo=moreaction(
+                res_model='ir.model.data', domain=[('model','=','export.integer')]))])
+        self.assertIs(result['ids'], False)
+
+        result = self.import_(['value/.id'], [['66']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for database id '66' "
+            u"in field 'unknown'", moreinfo=moreaction(
+                res_model='ir.model.data', domain=[('model','=','export.integer')]))])
+        self.assertIs(result['ids'], False)
+
+    def test_fail_multiple(self):
+        result = self.import_(
+            ['value', 'value/id'],
+            [['somename', 'somexid']])
+        self.assertEqual(result['messages'], [message(
+            u"Ambiguous specification for field 'unknown', only provide one of "
+            u"name, external id or database id")])
+        self.assertIs(result['ids'], False)
+
+class test_m2m(ImporterCase):
+    model_name = 'export.many2many'
+
+    # apparently, one and only thing which works is a
+    # csv_internal_sep-separated list of ids, xids, or names (depending if
+    # m2m/.id, m2m/id or m2m[/anythingelse]
+    def test_ids(self):
+        id1 = self.registry('export.many2many.other').create(
+                self.cr, openerp.SUPERUSER_ID, {'value': 3, 'str': 'record0'})
+        id2 = self.registry('export.many2many.other').create(
+                self.cr, openerp.SUPERUSER_ID, {'value': 44, 'str': 'record1'})
+        id3 = self.registry('export.many2many.other').create(
+                self.cr, openerp.SUPERUSER_ID, {'value': 84, 'str': 'record2'})
+        id4 = self.registry('export.many2many.other').create(
+                self.cr, openerp.SUPERUSER_ID, {'value': 9, 'str': 'record3'})
+        id5 = self.registry('export.many2many.other').create(
+                self.cr, openerp.SUPERUSER_ID, {'value': 99, 'str': 'record4'})
+
+        result = self.import_(['value/.id'], [
+            ['%d,%d' % (id1, id2)],
+            ['%d,%d,%d' % (id1, id3, id4)],
+            ['%d,%d,%d' % (id1, id2, id3)],
+            ['%d' % id5]
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 4)
+
+        ids = lambda records: [record.id for record in records]
+
+        b = self.browse()
+        self.assertEqual(ids(b[0].value), [id1, id2])
+        self.assertEqual(values(b[0].value), [3, 44])
+
+        self.assertEqual(ids(b[2].value), [id1, id2, id3])
+        self.assertEqual(values(b[2].value), [3, 44, 84])
+
+    def test_noids(self):
+        result = self.import_(['value/.id'], [['42']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for database id '42' in field "
+            u"'unknown'", moreinfo=moreaction(
+                res_model='ir.model.data', domain=[('model','=','export.many2many.other')]))])
+        self.assertIs(result['ids'], False)
+
+    def test_xids(self):
+        M2O_o = self.registry('export.many2many.other')
+        id1 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 3, 'str': 'record0'})
+        id2 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 44, 'str': 'record1'})
+        id3 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 84, 'str': 'record2'})
+        id4 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 9, 'str': 'record3'})
+        records = M2O_o.browse(self.cr, openerp.SUPERUSER_ID, [id1, id2, id3, id4])
+
+        result = self.import_(['value/id'], [
+            ['%s,%s' % (self.xid(records[0]), self.xid(records[1]))],
+            ['%s' % self.xid(records[3])],
+            ['%s,%s' % (self.xid(records[2]), self.xid(records[1]))],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 3)
+
+        b = self.browse()
+        self.assertEqual(values(b[0].value), [3, 44])
+        self.assertEqual(values(b[2].value), [44, 84])
+    def test_noxids(self):
+        result = self.import_(['value/id'], [['noxidforthat']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for external id 'noxidforthat' in field"
+            u" 'unknown'", moreinfo=moreaction(
+                res_model='ir.model.data', domain=[('model','=','export.many2many.other')]))])
+        self.assertIs(result['ids'], False)
+
+    def test_names(self):
+        M2O_o = self.registry('export.many2many.other')
+        id1 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 3, 'str': 'record0'})
+        id2 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 44, 'str': 'record1'})
+        id3 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 84, 'str': 'record2'})
+        id4 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 9, 'str': 'record3'})
+        records = M2O_o.browse(self.cr, openerp.SUPERUSER_ID, [id1, id2, id3, id4])
+
+        name = lambda record: dict(record.name_get())[record.id]
+
+        result = self.import_(['value'], [
+            ['%s,%s' % (name(records[1]), name(records[2]))],
+            ['%s,%s,%s' % (name(records[0]), name(records[1]), name(records[2]))],
+            ['%s,%s' % (name(records[0]), name(records[3]))],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 3)
+
+        b = self.browse()
+        self.assertEqual(values(b[1].value), [3, 44, 84])
+        self.assertEqual(values(b[2].value), [3, 9])
+
+    def test_nonames(self):
+        result = self.import_(['value'], [['wherethem2mhavenonames']])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for name 'wherethem2mhavenonames' in "
+            u"field 'unknown'", moreinfo=moreaction(
+                res_model='export.many2many.other'))])
+        self.assertIs(result['ids'], False)
+
+    def test_import_to_existing(self):
+        M2O_o = self.registry('export.many2many.other')
+        id1 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 3, 'str': 'record0'})
+        id2 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 44, 'str': 'record1'})
+        id3 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 84, 'str': 'record2'})
+        id4 = M2O_o.create(self.cr, openerp.SUPERUSER_ID, {'value': 9, 'str': 'record3'})
+
+        xid = 'myxid'
+        result = self.import_(['id', 'value/.id'], [[xid, '%d,%d' % (id1, id2)]])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+        result = self.import_(['id', 'value/.id'], [[xid, '%d,%d' % (id3, id4)]])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        b = self.browse()
+        self.assertEqual(len(b), 1)
+        # TODO: replacement of existing m2m values is correct?
+        self.assertEqual(values(b[0].value), [84, 9])
+
+class test_o2m(ImporterCase):
+    model_name = 'export.one2many'
+
+    def test_name_get(self):
+        s = u'Java is a DSL for taking large XML files and converting them ' \
+            u'to stack traces'
+        result = self.import_(
+            ['const', 'value'],
+            [['5', s]])
+        self.assertEqual(result['messages'], [message(
+            u"No matching record found for name '%s' in field 'unknown'" % s,
+            moreinfo=moreaction(res_model='export.one2many.child'))])
+        self.assertIs(result['ids'], False)
+
+    def test_single(self):
+        result = self.import_(['const', 'value/value'], [
+            ['5', '63']
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        (b,) = self.browse()
+        self.assertEqual(b.const, 5)
+        self.assertEqual(values(b.value), [63])
+
+    def test_multicore(self):
+        result = self.import_(['const', 'value/value'], [
+            ['5', '63'],
+            ['6', '64'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 2)
+
+        b1, b2 = self.browse()
+        self.assertEqual(b1.const, 5)
+        self.assertEqual(values(b1.value), [63])
+        self.assertEqual(b2.const, 6)
+        self.assertEqual(values(b2.value), [64])
+
+    def test_multisub(self):
+        result = self.import_(['const', 'value/value'], [
+            ['5', '63'],
+            ['', '64'],
+            ['', '65'],
+            ['', '66'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        (b,) = self.browse()
+        self.assertEqual(values(b.value), [63, 64, 65, 66])
+
+    def test_multi_subfields(self):
+        result = self.import_(['value/str', 'const', 'value/value'], [
+            ['this', '5', '63'],
+            ['is', '', '64'],
+            ['the', '', '65'],
+            ['rhythm', '', '66'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        (b,) = self.browse()
+        self.assertEqual(values(b.value), [63, 64, 65, 66])
+        self.assertEqual(
+            values(b.value, 'str'),
+            'this is the rhythm'.split())
+
+    def test_link_inline(self):
+        """ m2m-style specification for o2ms
+        """
+        id1 = self.registry('export.one2many.child').create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Bf', 'value': 109
+        })
+        id2 = self.registry('export.one2many.child').create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Me', 'value': 262
+        })
+
+        result = self.import_(['const', 'value/.id'], [
+            ['42', '%d,%d' % (id1, id2)]
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(b.const, 42)
+        # automatically forces link between core record and o2ms
+        self.assertEqual(values(b.value), [109, 262])
+        self.assertEqual(values(b.value, field='parent_id'), [b, b])
+
+    def test_link(self):
+        """ O2M relating to an existing record (update) force a LINK_TO as well
+        """
+        O2M = self.registry('export.one2many.child')
+        id1 = O2M.create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Bf', 'value': 109
+        })
+        id2 = O2M.create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Me', 'value': 262
+        })
+
+        result = self.import_(['const', 'value/.id'], [
+            ['42', str(id1)],
+            ['', str(id2)],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(b.const, 42)
+        # automatically forces link between core record and o2ms
+        self.assertEqual(values(b.value), [109, 262])
+        self.assertEqual(values(b.value, field='parent_id'), [b, b])
+
+    def test_link_2(self):
+        O2M_c = self.registry('export.one2many.child')
+        id1 = O2M_c.create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Bf', 'value': 109
+        })
+        id2 = O2M_c.create(self.cr, openerp.SUPERUSER_ID, {
+            'str': 'Me', 'value': 262
+        })
+
+        result = self.import_(['const', 'value/.id', 'value/value'], [
+            ['42', str(id1), '1'],
+            ['', str(id2), '2'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(b.const, 42)
+        self.assertEqual(values(b.value), [1, 2])
+        self.assertEqual(values(b.value, field='parent_id'), [b, b])
+
+class test_o2m_multiple(ImporterCase):
+    model_name = 'export.one2many.multiple'
+
+    def test_multi_mixed(self):
+        result = self.import_(['const', 'child1/value', 'child2/value'], [
+            ['5', '11', '21'],
+            ['', '12', '22'],
+            ['', '13', '23'],
+            ['', '14', ''],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(values(b.child1), [11, 12, 13, 14])
+        self.assertEqual(values(b.child2), [21, 22, 23])
+
+    def test_multi(self):
+        result = self.import_(['const', 'child1/value', 'child2/value'], [
+            ['5', '11', '21'],
+            ['', '12', ''],
+            ['', '13', ''],
+            ['', '14', ''],
+            ['', '', '22'],
+            ['', '', '23'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(values(b.child1), [11, 12, 13, 14])
+        self.assertEqual(values(b.child2), [21, 22, 23])
+
+    def test_multi_fullsplit(self):
+        result = self.import_(['const', 'child1/value', 'child2/value'], [
+            ['5', '11', ''],
+            ['', '12', ''],
+            ['', '13', ''],
+            ['', '14', ''],
+            ['', '', '21'],
+            ['', '', '22'],
+            ['', '', '23'],
+        ])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+        [b] = self.browse()
+        self.assertEqual(b.const, 5)
+        self.assertEqual(values(b.child1), [11, 12, 13, 14])
+        self.assertEqual(values(b.child2), [21, 22, 23])
+
+class test_realworld(common.TransactionCase):
+    def test_bigfile(self):
+        data = json.loads(pkgutil.get_data(self.__module__, 'contacts_big.json'))
+        result = self.registry('res.partner').load(
+            self.cr, openerp.SUPERUSER_ID,
+            ['name', 'mobile', 'email', 'image'],
+            data)
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), len(data))
+
+class test_date(ImporterCase):
+    model_name = 'export.date'
+
+    def test_empty(self):
+        self.assertEqual(
+            self.import_(['value'], []),
+            {'ids': [], 'messages': []})
+
+    def test_basic(self):
+        result = self.import_(['value'], [['2012-02-03']])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+    def test_invalid(self):
+        result = self.import_(['value'], [['not really a date']])
+        self.assertEqual(result['messages'], [
+            message(u"'not really a date' does not seem to be a valid date "
+                    u"for field 'unknown'",
+                    moreinfo=u"Use the format '2012-12-31'")])
+        self.assertIs(result['ids'], False)
+
+class test_datetime(ImporterCase):
+    model_name = 'export.datetime'
+
+    def test_empty(self):
+        self.assertEqual(
+            self.import_(['value'], []),
+            {'ids': [], 'messages': []})
+
+    def test_basic(self):
+        result = self.import_(['value'], [['2012-02-03 11:11:11']])
+        self.assertFalse(result['messages'])
+        self.assertEqual(len(result['ids']), 1)
+
+    def test_invalid(self):
+        result = self.import_(['value'], [['not really a datetime']])
+        self.assertEqual(result['messages'], [
+            message(u"'not really a datetime' does not seem to be a valid "
+                    u"datetime for field 'unknown'",
+                    moreinfo=u"Use the format '2012-12-31 23:59:59'")])
+        self.assertIs(result['ids'], False)
+
+# function, related, reference: written to db as-is...
+# => function uses @type for value coercion/conversion

=== modified file 'openerp/tests/test_misc.py'
--- openerp/tests/test_misc.py	2012-08-31 13:23:37 +0000
+++ openerp/tests/test_misc.py	2012-10-08 13:46:29 +0000
@@ -2,12 +2,12 @@
 # > PYTHONPATH=. python2 openerp/tests/test_misc.py
 
 import unittest2
+from ..tools import misc
 
-class test_misc(unittest2.TestCase):
+class append_content_to_html(unittest2.TestCase):
     """ Test some of our generic utility functions """
 
     def test_append_to_html(self):
-        from openerp.tools import append_content_to_html
         test_samples = [
             ('<!DOCTYPE...><HTML encoding="blah">some <b>content</b></HtMl>', '--\nYours truly', True,
              '<!DOCTYPE...><html encoding="blah">some <b>content</b>\n<pre>--\nYours truly</pre>\n</html>'),
@@ -15,7 +15,37 @@
              '<html><body>some <b>content</b>\n\n\n<p>--</p>\n<p>Yours truly</p>\n\n\n</body></html>'),
         ]
         for html, content, flag, expected in test_samples:
-            self.assertEqual(append_content_to_html(html,content,flag), expected, 'append_content_to_html is broken')
+            self.assertEqual(misc.append_content_to_html(html,content,flag), expected, 'append_content_to_html is broken')
+
+class test_countingstream(unittest2.TestCase):
+    def test_empty_stream(self):
+        s = misc.CountingStream(iter([]))
+        self.assertEqual(s.index, -1)
+        self.assertIsNone(next(s, None))
+        self.assertEqual(s.index, 0)
+
+    def test_single(self):
+        s = misc.CountingStream(xrange(1))
+        self.assertEqual(s.index, -1)
+        self.assertEqual(next(s, None), 0)
+        self.assertIsNone(next(s, None))
+        self.assertEqual(s.index, 1)
+
+    def test_full(self):
+        s = misc.CountingStream(xrange(42))
+        for _ in s:
+            pass
+        self.assertEqual(s.index, 42)
+
+    def test_repeated(self):
+        """ Once the CountingStream has stopped iterating, the index should not
+        increase anymore (the internal state should not be allowed to change)
+        """
+        s = misc.CountingStream(iter([]))
+        self.assertIsNone(next(s, None))
+        self.assertEqual(s.index, 0)
+        self.assertIsNone(next(s, None))
+        self.assertEqual(s.index, 0)
 
 if __name__ == '__main__':
-    unittest2.main()
\ No newline at end of file
+    unittest2.main()

=== modified file 'openerp/tools/misc.py'
--- openerp/tools/misc.py	2012-09-12 10:47:13 +0000
+++ openerp/tools/misc.py	2012-10-08 13:46:29 +0000
@@ -1221,4 +1221,38 @@
             with self:
                 return func(*args, **kwargs)
         return deco
+
+_ph = object()
+class CountingStream(object):
+    """ Stream wrapper counting the number of element it has yielded. Similar
+    role to ``enumerate``, but for use when the iteration process of the stream
+    isn't fully under caller control (the stream can be iterated from multiple
+    points including within a library)
+
+    ``start`` allows overriding the starting index (the index before the first
+    item is returned).
+
+    On each iteration (call to :meth:`~.next`), increases its :attr:`~.index`
+    by one.
+
+    .. attribute:: index
+
+        ``int``, index of the last yielded element in the stream. If the stream
+        has ended, will give an index 1-past the stream
+    """
+    def __init__(self, stream, start=-1):
+        self.stream = iter(stream)
+        self.index = start
+        self.stopped = False
+    def __iter__(self):
+        return self
+    def next(self):
+        if self.stopped: raise StopIteration()
+        self.index += 1
+        val = next(self.stream, _ph)
+        if val is _ph:
+            self.stopped = True
+            raise StopIteration()
+        return val
+
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== modified file 'setup.py'
--- setup.py	2012-09-22 11:10:33 +0000
+++ setup.py	2012-10-08 13:46:29 +0000
@@ -117,6 +117,7 @@
       extras_require = {
           'SSL' : ['pyopenssl'],
       },
+      tests_require = ['unittest2'],
       **py2exe_options()
 )