How to import bom revisions update without duplicating their values?

AI generated answer (using internal Slack threads):

To import BOM revisions update without duplicating their values, you can follow these steps: 1. Export the BOM revision records. You can do this by creating a saved search for member items. Make sure to export the revisions, not the assemblies, as they are different record types. 2. Remove the unwanted lines from the exported data. This could be any data that you do not want to include in the new revisions. 3. Reimport the data as new revisions. This will require multiple imports. The first import should inactivate the old revision. The second import should create the new revisions. 4. When reimporting, you will need to add end dates to the existing revisions and new revision names and start dates (day after) to the new revisions. 5. Remove the internal IDs from the data before reimporting. This is because you want to create new revisions, not modify the existing ones. 6. The last import should be done as 'add only'. This will ensure that you are not duplicating any values. Remember, if you're updating the BOM (adding, changing, or removing a component, etc.), that's likely a BOM revision. If you're selling it or identifying it differently, you should create a new item. If you're building it at two locations with different inputs, you should set up multiple BOMs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******