Write BOM Operations

This page is a Work in Progress and not completed yet, please check back again soon

Summary of article's major steps

• Create a new Property Mapping

• Add 2 new export rules to format the object and make it ready for Odoo BOM

BOM operations are individual operations that are performed on the item. This page follows on the progress from the previous topic Read BOM Operations

The best way to manage operations is to be consistent in your naming convention for your operations.

In other words, if you are going to assemble something, always give it the exact same name (e.g. Assembly or Assemble).

Create a new Property Mapping

To write these operations to the Odoo BOM, we map to the Odoo property

mrp.bom.operation_ids

The first step is to create a Property Mapping in addition to the Property Mapping created in the previous article.

Create a new Property Mapping with the following settings :

Setting	Value
Property Name / Header	BOM Operations
Accessor	bomOperations
Primary Property	(Unmapped) (or a related property in the Primary Source)
Secondary Property	mrp.bom.operation_ids
List Name	mrp.workcenter
List Value Selector	{id}:{name}
Update Odoo on Submit	false
Rendering Type	Advanced List
List Display Selector	operationName
List Value Selector	workCenterId
List items	Here is a sample of what you can insert, but it can be anything, whatever you use most frequently [more on this below]** [ { "workCenterId": 1, "name": "Drill", "operationName" : "Drill", "value": { "sequence": 10, "name": "Drill", "workcenter_id": 2, "time_mode": "manual", "time_mode_batch": 10, "time_cycle_manual": 60 } }, { "workCenterId": 2, "name": "Galvanize", "operationName" : "Galvanize", "value": { "sequence": 20, "name": "Galvanize", "workcenter_id": 1, "time_mode": "manual", "time_mode_batch": 10, "time_cycle_manual": 60 } }, // add as many as you like.... ]
Enabled	true
Prefer Odoo Value	true

Property Mapping Setting	Old value	New value
Update Odoo On Submit?	false	true

Add new Export Rules

After adding the new Property Mapping, add 2 new export rules

Setting	Value
Type	export
Name	Text Manipulation
Process for {Primary}	false
Process for Odoo	true
JavaScript expression	let bomOperations = []; let updateValue = []; let existingOperationIds = [ { id: 0, operationId: 0 }, { id: 0, operationId: 0 }, ]; /* bopOperation1 */ if (rowData.modifications.bomOperation1 !== "") { if (rowData.differences.bomOperation1 && rowData.differences.bomOperation1 !== "") { existingOperationIds[0].id = JSON.parse(rowData.differences.bomOperations)[0]?.id || 0; existingOperationIds[0].operationId = rowData.modifications.bomOperation1; } if (rowData.modifications.bomOperation1 && rowData.modifications.bomOperation1 !== "") { existingOperationIds[0].id = JSON.parse(rowData.differences.bomOperations)[0]?.id || 0; existingOperationIds[0].operationId = rowData.modifications.bomOperation1; } bomOperations = bomOperations.concat(rowData.modifications.bomOperation1); } else return updateValue; /* bopOperation2 */ if (rowData.modifications.bomOperation2 !== "") { if (rowData.differences.bomOperation2 && rowData.differences.bomOperation2 !== "") { existingOperationIds[1].id = JSON.parse(rowData.differences.bomOperations)[1]?.id || 0; existingOperationIds[1].operationId = rowData.modifications.bomOperation2; } if (rowData.modifications.bomOperation2 && rowData.modifications.bomOperation2 !== "") { existingOperationIds[1].id = JSON.parse(rowData.differences.bomOperations)[1]?.id || 0; existingOperationIds[1].operationId = rowData.modifications.bomOperation2; } bomOperations = bomOperations.concat(rowData.modifications.bomOperation2); } const pmObjectListItems = JSON.parse(pm.objectListItems); for (let i = 0; i < bomOperations.length; i++) { const bomOp = bomOperations[i]; pmObjectListItems.forEach((item) => { if (item.workCenterId === bomOp) { item.value.id = JSON.parse(rowData.differences.bomOperations)[i]?.id || 0; item.value.id = JSON.parse(rowData.differences.bomOperations)[i]?.id || 0; updateValue.push(item.value); } }); } return updateValue;

What this rule does

For the mapped BOM operations, get the id of the existing BOM operation line. Use this to determine if the BOM operation should be added or updated

Setting	Value
Type	export
Name	Export Manipulation
Process for {Primary}	false
Process for Odoo	true
JavaScript expression	if (rowData.modifications.bomOperations && rowData.modifications.bomOperations.length == 0) delete s["bomOperations"]; return s;

What this rule does

If there is no value for the bomOperations value, then remove it, clearing the operations from Odoo