In this example, we will be setting up attribute tables for each of the Fin Presses. The attributes will be for Die Letters, Hole Diameter, Pattern Number, and Maximum Fin Rows. First we will map the user defined fields, then we will setup the tables to referenced the newly mapped fields.
1. Determine which fields to map, and which View to map them to. In our example, we will map U_Fin_Row, U_Fin_Id, U_Fin_Hole, and U_Fin_Pattern from the WOR1 table in the Navigator database to the APS_Operation view in the PlanetTogether import database called “ProductionOneAPS_Import”. This is done by first selecting the fields in the APS_OperationHelper view, which will then pass the values on to the APS_Operation view:
3. Now the attributes of a resource have to be mapped to PlanetTogether. We gather information from the APS_Operation view, which receives information from the Navigator tables: @NBS_RESOURCE, OWOR, WOR1, and OITM. The information is first sent to the APS_AttributeHelper and then through to the APS_Attributes view:
8. Add attribute names and values. The names must correspond to the names used in creating the APS_Attributes view in step 4 above. For the Die Letter (FinDie attribute), we have substituted a number corresponding to the letter of the alphabet, A = 1, B = 2, C = 3, etc.