c2c-oerpscenario team mailing list archive

[YannickB <yannick.buron@xxxxxxxxxxx>]

Hi Raphael, thanks for the answer.

I assure you that I can't reproduce the bug without
base_external_referential. For example, with OpenERP demo product (so
define by XML), they have an ID like "product.product_product_pc3". Only
one dot, between module name and xml identifier, no problem.

Also I did some complementary test. I consult for example an ir.view :
sale.view_order_form.

Here also, only one dot so no problem with CSV export-import. In Administration / Customization / Database Structure / External Referential / Data, it has :
Module : sale
XML Identifier : view_order_form

It seems that OpenERP will do the concatenation "Module"."XML
Identifier". So only one dot, no problem. But we saw that ID generated
by base_external_referential like
"extref.society_name.product.product_8" use some dots in fields "Module"
and "XML Identifier", here is the problem according to me. The only dot
should be the dot in  "Module"."XML Identifier", that implies no dot in
"Module" and "XML Identifier".

About your suggestion, we tried before submit the report to change . in
_, with no success (we can't modify the ID by CSV). Of course for our
customer we'll find an answer, but we don't want that future
product/sale order etc... will still be generated with several dots.

PS : It seems  Administration / Customization / Database Structure /
External Referential / Data, really useful for my test, is no longer
accessible on new base with recent version of magentoerpconnect and
base_external_referential. I did test on customer's OpenERP, which use
magentoerpconnect for more than six month. But the problem occurred also
on new OpenERP base.

-- 
Base_external_referential : ID problem with export-import CSV
https://bugs.launchpad.net/bugs/673614
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in Magento Open ERP Connector: New

Bug description:
Hi everyone,

Today I needed to tick a checkbox field on 2000+ product in OpenERP with magentoerpconnect enabled. To do it, I used the easiest method : a CSV export of all the products with column "Database ID", "Name", and the field checkbox.

I modified the checkbox field to True in my OpenOffice Calc, and then I re-imported the CSV in OpenERP.

But I had a very ugly message : 

Error trying to import this record :
	track_production: True

Error message :
Line 1 : "extref.society_name.product.product_8" contains too many dots. XML ids should not contain dots ! These are used to refer to other modules data, as in module.reference_id

I should precise that I didn't try to import the column "Id". But after this I did a CSV export with the column "Id" and I effectively get the value "extref.society_name.product.product_8".

I don't know why I had a bug with a field that was not imported, probably because it was the field "Id" that is relatively important for OpenERP.

Anyway, my devs men say to me that this absolutely not normal that we have an Id with several dots, and so there is several very bad consequences on the CSV system. For example here, Impossible to modify a product by update CSV.

I see in Administration / Customization / Database Structure / External Referential / Data two interesting fields  : module and XML identifier. For example with the example product, I have 
Module : product.product_8
XML identifier : extref.society_name

This quite obvious that the id is generated by base_external_referential with the concatenation "Module"."XML identifier". But this is bad because with this approach we have an id with several dots. I am already surprised that only the CSV system was compromised.

What do you think?