WEBVTT NOTE This file was generated by Descript 00:00:03.119 --> 00:00:07.169 so I've got a little technique to go through that process. 00:00:07.769 --> 00:00:14.159 The first thing I do is I export out my bombs Okay. 00:00:15.239 --> 00:00:17.159 And save them in a file. 00:00:18.059 --> 00:00:23.309 Then I come over here to my part and I call up my soon to be bad 00:00:23.309 --> 00:00:29.189 part and I call it dot old or anything else you would like. 00:00:29.489 --> 00:00:33.389 And there's an import export to rename parts and change their status. 00:00:34.949 --> 00:00:40.379 And so now I can take and create a new part that's a 9 0 1 1 00:00:42.299 --> 00:00:44.249 and then re-import my bombs. 00:00:44.669 --> 00:00:47.819 And the bomb doesn't know that we've changed it from inventory to 00:00:47.819 --> 00:00:54.899 non-inventory, so it's on the bomb without having to go fix all the bombs themselves. 00:00:55.379 --> 00:00:55.649 Yep. 00:00:56.129 --> 00:00:56.939 Makes sense. 00:00:57.359 --> 00:00:58.348 Yep, that makes sense. 00:00:58.348 --> 00:00:59.681 That's how we've been fixing it. 00:00:59.681 --> 00:01:04.361 So wanted to see if there was another way that was simpler, like converting 00:01:04.361 --> 00:01:07.241 it to an inventory item, if there was a way to convert it back, but 00:01:07.285 --> 00:01:09.050 yeah, no it's a one way street. 00:01:09.143 --> 00:01:09.443 Okay. 00:01:09.743 --> 00:01:11.663 It's all about database integrity. 00:01:12.443 --> 00:01:17.536 But we do have this great you do have this renaming spreadsheet right 00:01:17.536 --> 00:01:24.136 here that if you have to do a lot of them and it's a very spreadsheet, old 00:01:24.136 --> 00:01:26.566 part number, new part number, okay. 00:01:27.466 --> 00:01:30.586 So you can take out your p if so, let's say I had a whole 00:01:30.586 --> 00:01:31.816 bunch I wanted to change. 00:01:31.966 --> 00:01:32.986 This is what I do. 00:01:33.616 --> 00:01:38.446 I'd export out my ppv, I would export out my bombs. 00:01:39.136 --> 00:01:44.506 I would create this spreadsheet, creating renaming things as old . Okay. 00:01:45.796 --> 00:01:51.706 Then I would go through my PPV and change those from type 10 to type 30, which is 00:01:51.706 --> 00:01:54.166 from type inventory to non-inventory. 00:01:54.796 --> 00:01:55.186 Okay. 00:01:55.516 --> 00:02:00.766 Create the new parts using the ppv, and then I'd bring in the bomb spreadsheet. 00:02:01.846 --> 00:02:02.206 Okay. 00:02:02.776 --> 00:02:05.746 And that way it's a lot less data entry. 00:02:07.996 --> 00:02:08.386 Okay. 00:02:08.986 --> 00:02:09.436 All right.