I am trying to edit a large set of BOMs that were improperly set up. While the work centers are correct, the operations names are either wrong or have typos, the sequence and blocked by columns need setup, and a new operation needs added to the end of each one.
Doing it manually in Odoo is taking forever, and While I tried to export the BOMs as a spreadsheet, edit the operation names, and import it back, I keep getting an error for the Operations even if I use an ID or External ID column.
Ambiguous specification for field 'Operations', only provide one of name, external id or database id at multiple rows |
How should I set up the operation name exporting so I can import them back with consistent spelling and formatting? If that is not possible, what would be the fastest way to fix this problem?
Solved. Turns out I had some conflicting redundant external keys for both operations and work centers. Deleting the work center one fixed the issue.