Odoo Server (MOVED TO GITHUB)

Export / Import bugs and inconsistencies [dev-6.0rc1]

Bug #672763 reported by mvhman on 2010-11-08

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Odoo Server (MOVED TO GITHUB)	Fix Released	Medium	OpenERP's Framework R&D

Bug Description

1) Export of column headers in compatible mode cannot be imported.
2) New imported resource create duplicate default values in Configuration Parameters.

Eg 1:
When exporting Product Categories in compatible mode:
Column headers are:
type db_id id name parent_id sequence
normal 1 product.cat0 All products 0
-> These cannot be used when importing new records.

Column headers need to be adjusted to:
type ID Name Parent Category/ID sequence
normal c2 Sellable product.cat0 0
-> parent_id has to be changed to Parent Category/ID
This makes it very difficult to export and import data correctly.

Eg 2:
When importing new records, new default values for the specific record are created in Configuration Parameters.
when importing the above record, 3 new default records with a specific resource All Products - Sellabe are created.
property_account_expense_categ
property_stock_journal
property_account_income_categ

This gives rise to large lists of Configuration Parameters when importing products.
Configuration Parameters list can be in the 1000's for just 300 imported products.

Please can you verify that this is indeed a bug or whether I am missing something.
[dev-6.0rc1] ubuntu 9.10 desktop revision 2979

thanks.

Revision history for this message

Jay Vora (Serpent Consulting Services) (jayvora) wrote on 2010-11-11:

Hello Michael,

I guess you might have missed something.

This is what we followed to justify your post:

1. Export these fields of categories: type db_id id name parent_id sequence
--- Here we got all the categories with first row type db_id id name parent_id sequence(as it was import compatible, you get column names of db, not labels line Name,Type,Parent Category,etc.)

2. Imported 2 records:
--- I modified the same file,I removed all except 2 records, I modified one and added another.

After the completion, I saw my existing category modified and new category added as expected.

Note: Make sure you do not supply DB_ID or ID to new records to be added.

Hope this helps.

Let me know if this still does not occur at your end.

Thanks.

Changed in openobject-server:
status:	New → Invalid

Revision history for this message

mvhman (michael-openrevolution) wrote on 2010-11-11:

export and import ods spreadsheets Edit (8.8 KiB, application/vnd.oasis.opendocument.spreadsheet)

thanks Jay,

I tried the export and immediate import with no luck.
Used the web-client to export.
When using the import in GTK got this error on server, with message showing similar error. (could not copy and paste the gtk error so used the server warning to illustrate.
==> [2010-11-11 23:12:12,885][fdrc1template105] WARNING:import:Relation not found: All products / Sellable on 'product.category'
On the web client I recieved no error: nothing happens. However server shows same error.

please view attached ods document to see the export and import on sheet 1 and 2. Does not seem to read: parent_id in that format.

Using: Openerp 6.0 from launchpad on ubuntu 9.10.

regards,
Michael?field.comment=thanks Jay,

please view attached ods document to see the export and import on sheet 1 and 2.

Using: Openerp 6.0 from launchpad on ubuntu 9.10.

regards,
Michael

Revision history for this message

Jay Vora (Serpent Consulting Services) (jayvora) wrote on 2010-11-16:

Looks like an issue with name_get(), I will come back on this soon.
Thanks.

JMA(Open ERP) (jma-openerp) on 2010-11-23

Changed in openobject-server:
assignee:	nobody → OpenERP's Framework R&D (openerp-dev-framework)
importance:	Undecided → Medium
status:	Invalid → Confirmed