2 Part Loop with Excel Form Report

[S_Cliff]

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.

[KIRBSTER269]

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.

[KIRBSTER269]

If you do have the Print command in there it should be placed BEFORE- LOOP/END

[S_Cliff]

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?

[KIRBSTER269]

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.

[KIRBSTER269]

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

[KIRBSTER269]

[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.

[S_Cliff]

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

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

[S_Cliff]

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

spreadsheet.png

[KIRBSTER269]

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.

 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?

[S_Cliff]

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.

[KIRBSTER269]

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????

[S_Cliff]

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).