1 Reply Latest reply on Oct 27, 2017 12:48 PM by Ian Pommer

    (Inspection 2017) Sheet Properties Zone Parameters Exporting to Excel

    Ian Pommer

      Hello -

       

      I am currently trying out Inspection 2017 to see if it can cut down on our labor hours spent making new FPAI/FAIR documents. The only thing left to try and automate is our "Zone" column which is used to say where the balloon/feature is to help our inspection team quicken their processes.

       

      Although I can set up zones in Sheet Properties > Zone Parameters, I am unable to figure out how to pull that information about what grid section each balloon is in.

       

      The exporter for Inspection 2017 uses expressions like:

       

      iex:INSPECTIONXPERT/SAMPLE_SHEET/CAD/ATTRIBUTES/ATTRIBUTE[@selected='True']/@prefix

      iex:INSPECTIONXPERT/SAMPLE_SHEET/CAD/ATTRIBUTES/ATTRIBUTE[@selected='True']/@value

       

      So I tried doing:

      iex:INSPECTIONXPERT/SAMPLE_SHEET/CAD/ATTRIBUTES/ATTRIBUTE[@selected='True']/@zone

       

      It may not come as a surprise that this did not work. But there *has* to be a way to pull that information from a drawing using "code", no? Why would that feature even be in SW if you are not able to pull that information?

       

      Thank you for your time,

       

      Ian

        • Re: (Inspection 2017) Sheet Properties Zone Parameters Exporting to Excel
          Ian Pommer

          I have the answer, which requires some Excel functions.

           

          The first step is to call for the location, and sheet number in two separate cells:

          iex:INSPECTIONXPERT/SAMPLE_SHEET/CAD/ATTRIBUTES/ATTRIBUTE[@selected='True']/@location

          iex:INSPECTIONXPERT/SAMPLE_SHEET/CAD/ATTRIBUTES/ATTRIBUTE[@selected='True']/@drawingSheet

           

          Then, make a "Zone X" cell, a "Zone Y" cell with the following respective functions:

          =LOOKUP((LEFT(F7,FIND(",",F7)-1))/0.0254,{0,2.595,4.564,6.532,8.501,10.47,12.439,14.407},{8,7,6,5,4,3,2,1})

          =LOOKUP((MID(F7,FIND(",",F7)+1,10))/0.0254,{0,2.955,5.517,8.08,10.642},{"A","B","C","D"})

           

          From there it is some simple concatenation, I chose to break my concatenation up into two stages. The first is combining the "ZoneX and ZoneY" cells, called "DRWG ZONE". Then combine the "DRWG ZONE" cell with the sheet number cell from up above.

           

          Hopefully this can help anyone in the future who has similar needs.

           

          P.S. Although I know how to program, I did not come up with those for the Y and Z zone functions on my own.

           

          EDIT: my bad, I forgot to mention that those cells being referenced "F7" is the location cell being exported from Inspection for that specific feature.