Differences

This shows you the differences between two versions of the page.

--- rpsc_matrix_load [2016/04/14 11:24 (8 years ago)] – [What you need] sjackson
+++ rpsc_matrix_load [2016/04/14 11:25 (8 years ago)] – [How to get things ready for import into System Five] sjackson
@@ Line 56: / Line 56: @@
   - Import **qry-Step02-A, Matrix Parents.csv**, but make sure you save the results. We need to get the unique ID of the first Matrix Parent added for later use in a query to update Part Numbers
   - **WARNING:** I had a problem when first running this file because I ran it before the **qry-Step03-A, Matrix Children.csv** query. I was getting messages about the part already existing. I am trying to run things in this order to prevent this error. I have also Imported the new format sku into the item number field in System Five because I think this is the cause of the problem.
-  - **Caution:** We need to test PO's for matrix parent items working because I don't know if we will have a problem if the Supplier is not attatched to the matrix parent.
+  - **Caution:** We need to test PO's for matrix parent items working because I don't know if we will have a problem if the Supplier is not attached to the matrix parent.
-  - Import **qry-Step03-B, Matrix Children Kit Load** via a kit load which will attatch the child parts to the parent parts.
+  - Import **qry-Step03-B, Matrix Children Kit Load** via a kit load which will attach the child parts to the parent parts.
-  - Since the Item Number is now updated to the NewSKU format, it does not have any size inforamtion in it. Also we need to check about the clients searching methods to make sure things work for them. All of the updates for these can be done afterwards.
+  - Since the Item Number is now updated to the NewSKU format, it does not have any size information in it. Also we need to check about the clients searching methods to make sure things work for them. All of the updates for these can be done afterwards.
   - Behavior: The system will not pull up matrix children when you search for the main parent part. ex: VOLCSHIMCRANE01 will only bring up the parent part in the search window at this time.
   - A query will need to be ran to update all Parts with a unique less than the first Parent Matrix Part Number<code>update Inventry set Part = Item where InvUnique < 10</code> Just make sure you replace 10 with the unique number of the first Parent Matrix Part Number you loaded. Remember there are lots of parts that were not matrix parts that still have only a part number as the primary search method.