2 Part Loop with Excel Form Report

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2 Part Loop with Excel Form Report

    I have a program with a excel form report command at the end. I'm trying to loop it so I can do 2 parts at once. I've successfully looped it but when it fills my spreadsheet, it won't populate the GD&T dimensions of the 2nd part. I suspect this is because there is not a 2nd CAD model it the program. Am I correct in assuming this and how would I properly place the 2nd CAD model in the program. The parts are 33 inches apart in the X-axis.
    I'm programming on a Global S 15.30.10 with a HP-S-X1H Scanning Probe, and using 2020 R2.

  • #2
    It has nothing to do with a second CAD model, Do you have Print Commands in your program, I assume you do not, because after the first part is ran, it should stop and ask you to save the first part that was run.
    (In Memory of my Loving wife, "Ronda" who I lost March 7, 2016. I love you baby.)
    They say "Nobody's Perfect." I must be Nobody.

    Comment


    • KIRBSTER269
      KIRBSTER269 commented
      Editing a comment
      If you do have the Print command in there it should be placed BEFORE- LOOP/END

    • S_Cliff
      S_Cliff commented
      Editing a comment
      Does my Excel Form Report command count as a print command? I do have it placed before the end of the loop. For these particular parts I don't want to save the PDF Reports. I only need the data in spreadsheet form. Can I use a Print Command to my running spreadsheet?

  • #3
    https://www.pcdmisforum.com/forum/pc...partial-report POST#3

    As I showed in here. Using Excel is fine. With Print Commands its the same thing as "Report Window Print Setup" but it treats it great in looping.
    Last edited by KIRBSTER269; 10-14-2020, 03:34 PM.
    (In Memory of my Loving wife, "Ronda" who I lost March 7, 2016. I love you baby.)
    They say "Nobody's Perfect." I must be Nobody.

    Comment


    • KIRBSTER269
      KIRBSTER269 commented
      Editing a comment
      You need to turn "Report Window Print Setup" off, Put your Print Commands in right click on them and Edit, and set it up that way

  • #4
    Code:
    [COLOR=#2980b9]V1 =LOOP/START,ID=YES,NUMBER=0,START=1,SKIP=,
    OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0[/COLOR]
    
    [COLOR=#c0392b]PRINT/REPORT,EXEC MODE=END,$
                    TO_FILE=OFF,AUTO=1,AUTO OPEN REPORT=OFF,$
                    TO_PRINTER=OFF,COPIES=1,$
                    TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
                    REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
                    TO_EXCEL_OUTPUT=OFF,
                 PREVIOUS_RUNS=DELETE_INSTANCES<<<<<<<<<<<<<<<<<<<<[/COLOR]DELETE INSTANCES
      FCF_PROFILE_LEFT_NVS_2 =SURFACE PROFILE : SCN_LEFT
                  FEATCTRLFRAME/SHOWPARAMS=NO,SHOWEXPANDED=NO
                    PRIMARY DIMENSION/PROFILE OF SURFACE,0.1,,,
                    NOTE/FCF_PROFILE_LEFT_NVS_2
                  FEATURES/SCN_LEFT,,
      FCF_PROFILE_RIGHT_NVS_2 =SURFACE PROFILE : SCN_RIGHT
                  FEATCTRLFRAME/SHOWPARAMS=NO,SHOWEXPANDED=NO
                    PRIMARY DIMENSION/PROFILE OF SURFACE,0.1,,,
                    NOTE/FCF_PROFILE_RIGHT_NVS_2
                  FEATURES/SCN_RIGHT,,
                  DATDEF/FEATURE=DATUM_D,D
      FCFWHOLE_SPHERE =SURFACE PROFILE : SPHERE
                  FEATCTRLFRAME/SHOWPARAMS=NO,SHOWEXPANDED=NO
                    PRIMARY DIMENSION/PROFILE OF SURFACE,0.1,D, ,,
                    NOTE/FCFWHOLE_SPHERE
                  FEATURES/SPHERE,,
    [COLOR=#c0392b]PRINT/REPORT,EXEC MODE=END,$
    TO_FILE=OFF,AUTO=1,AUTO OPEN REPORT=OFF,$
    TO_PRINTER=ON COPIES=1,$ <<<<<<<<<<<<<<<<<<<<<<<<<<<<<[/COLOR][COLOR=#000000]printer is on, in this instance you can type OFF[/COLOR]
    [COLOR=#c0392b]TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
    REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMEN SIONS=NO,$
    TO_EXCEL_OUTPUT=OFF,
    PREVIOUS_RUNS=KEEP_INSTANCES<<<<<<<<<<<<<<<<<<<<<<[/COLOR][COLOR=#000000]KEEP INSTANCES[/COLOR]
    [COLOR=#2980b9]LOOP/END[/COLOR]

    right click on the second one and click edit to set it up how you want to export it.
    (In Memory of my Loving wife, "Ronda" who I lost March 7, 2016. I love you baby.)
    They say "Nobody's Perfect." I must be Nobody.

    Comment


    • #5
      I can't seem to get the Print Command and the Excel Form Report to work in concert. This is what I tried.

      Code:
      V2 =LOOP/START,ID=YES,NUMBER=2,START=1,SKIP=,
      OFFSET:XAXIS=33,YAXIS=0,ZAXIS=0,ANGLE=0
      PRINT/REPORT,EXEC MODE=END,$
      TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
      TO_PRINTER=OFF,COPIES=1,$
      TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
      REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMEN SIONS=NO,$
      TO_EXCEL=OFF,$
      PREVIOUS_RUNS=DELETE_INSTANCES
      -
      -
      -FEATURES AND DIMENSIONS
      -
      -
      EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=MEDIUM_CHASSIS_TEMPLATE, TYPE=XLSX
      RESULT FOLDER/C:\Users\Public\Documents\Hexagon\PC-DMIS\2019 R2\ExcelFormReport\Results
      ASSIGN/EFR=GETPROGRAMINFO("EXCEL_FORM1")
      PRINT/REPORT,EXEC MODE=END,$
      TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
      TO_PRINTER=OFF,COPIES=1,$
      TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
      REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMEN SIONS=NO,$
      TO_EXCEL=ON,AUTO=3,FILENAME=EFR,AUTO OPEN=OFF,$
      PREVIOUS_RUNS=KEEP_INSTANCES
      LOOP/END
      I'm programming on a Global S 15.30.10 with a HP-S-X1H Scanning Probe, and using 2020 R2.

      Comment


      • #6
        It still ends up saving like this, the first part saves fine but the 2nd part is missing the measured GD&T.

        spreadsheet.png
        I'm programming on a Global S 15.30.10 with a HP-S-X1H Scanning Probe, and using 2020 R2.

        Comment


        • #7
          ok your not even using the print command, I was under the impression that's what you were using. This is actually what is dumping your info. and populating your form. So you can get rid of the Print Commands.

          Code:
           EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=MEDIUM_CHASSIS_TEMPLATE, TYPE=XLSX RESULT FOLDER
          /C:\Users\Public\Documents\Hexagon\PC-DMIS\2019 R2
          \ExcelFormReport\Results ASSIGN/EFR=GETPROGRAMINFO("EXCEL_FORM1")

          Is the info actually missing or is the information doubled in each slot in Excel? Can you expand the slots and see if the second reading is hidden?
          Last edited by KIRBSTER269; 10-15-2020, 08:08 AM.
          (In Memory of my Loving wife, "Ronda" who I lost March 7, 2016. I love you baby.)
          They say "Nobody's Perfect." I must be Nobody.

          Comment


          • S_Cliff
            S_Cliff commented
            Editing a comment
            I expanded my row height and the info is in fact missing. I tried running my loop over without any offsets. I ran the loop 4 times and I get the same results, it populates all the data on the first run and excludes the GD&T in the remaining 3 runs.

        • #8
          Code:
          V1 =LOOP/START,ID=[COLOR=#c0392b]NO[/COLOR],NUMBER=0,START=1,SKIP=,
          OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0
          
          **********************************
          
          PROGRAM
          
          **********************************
          EXCEL_FORM1=EXCELFORMREPORT/TEMPLATE=B69678(MEDIUM)_TEMPLATE, TYPE=XLSX
          RESULT FOLDER/C:\Users\Public\Documents\Hexagon\PC-DMIS\2019 R1\ExcelFormReport\Results
          
          LOOP/END
          Try turning your ID to NO shown above in RED, Also not sure what the line ASSIGN/EFR=GETPROGRAMINFO("EXCEL_FORM1") DOES FOR YOU????
          Last edited by KIRBSTER269; 10-15-2020, 03:27 PM.
          (In Memory of my Loving wife, "Ronda" who I lost March 7, 2016. I love you baby.)
          They say "Nobody's Perfect." I must be Nobody.

          Comment


          • S_Cliff
            S_Cliff commented
            Editing a comment
            Changing the ID to NO worked! The ASSIGN/EFR=GETPROGRAMINFO("EXCEL_FORM1") was just me experimenting trying to get the Print Command to talk to the Excel Form Report Command (it didn't work haha).

        Related Topics

        Collapse

        Working...
        X