Looping a program for a capability study, reporting out with Excel Form Report. I have it set up for 30 parts.
2020R2.
It keeps reporting the first part rather than each new part. This used to work. What may have changed?
I have similar problem. I created my own template and write data only in first column, if I choose Hexagon template it works, reports data in multiple columns... Send my template to Hexagon to investigate, but until now no feedback.
If you want to export measurement results from more than one measurement to the same excel report, you also have to export "PCD ID" value to your template. Not only "Measured Value". Otherwise only first column will be filled by measured values. In addition exported file name cannot contain time.
New to PC-DMIS here too. The upper management at where I work prefers to use excel as internal reporting preference.
Also trying to do something similar, except to have the {PCD ID} on different row in excel with the data below by 7 rows to show all the capability study data.
Data only gets reported and appended to one column. I'm not sure if my colleague and I have something set wrong in the command line or from the dialog box choices.
Advice on things to check would be greatly appreciated. Then I can report back on success or failure...
Played around with PC-DMIS and the did studies between the template my company want's to use and the supplied Hexagon 5 part / extended 5 part files. My colleague and I thinking that the {requirement} field is needed to go from 1 column to the next otherwise PC-DMIS will default to appending in one column.
$$ NO,
DO NOT EDIT ANY OF THE TRACEFIELDS! YOU WILL FILL THEM IN AFTER STARTING THE PROGRAM.
------------------------------------------------------------------------------------
TRACEFIELD/DISPLAY=YES,REPORT=NO,DISPLAY MESSAGE=WO_PO ; WO_PO :
TRACEFIELD/DISPLAY=YES,REPORT=NO,DISPLAY MESSAGE=OP_RID ; OP_RID :
TRACEFIELD/DISPLAY=YES,REPORT=NO,DISPLAY MESSAGE=CMMSERNUM ; CMMSERNUM :
TRACEFIELD/DISPLAY=YES,REPORT=NO,DISPLAY MESSAGE=OPERATOR ; OPERATOR :
ASSIGN/WW=GETTRACEVALUE("WO_PO")
ASSIGN/PROG_NAME=GETPROGRAMINFO("PARTNAME")
ASSIGN/REPTNAME=GETPROGRAMINFO("PARTPATH")
ASSIGN/RV=GETPROGRAMINFO("REVISION")
QTY =COMMENT/INPUT,NO,FULL SCREEN=NO,
How many parts are you running?
IF_GOTO/LOOP==1,GOTO = ONE
IF_GOTO/LOOP==2,GOTO = TWO
IF_GOTO/LOOP==3,GOTO = THREE
IF_GOTO/LOOP==4,GOTO = FOUR
ONE =LABEL/
$$ NO,
SERIAL NUMBER
P1
TRACEFIELD/DISPLAY=NO,REPORT=YES,DISPLAY MESSAGE=1ST POSITION ; SERIAL NUMBER : P1
IF_GOTO/LOOP==1,GOTO = SKIP1
TWO =LABEL/
REPORT/LABEL, FILENAME= FILE_HEADER.LBL
$$ NO,
SERIAL NUMBER
ASSIGN/P2=P1+1
TRACEFIELD/DISPLAY=NO,REPORT=YES,DISPLAY MESSAGE=1ST POSITION ; SERIAL NUMBER : P2
IF_GOTO/LOOP==2,GOTO = SKIP1
THREE =LABEL/
REPORT/LABEL, FILENAME= FILE_HEADER.LBL
$$ NO,
SERIAL NUMBER
ASSIGN/P3=P2+1
TRACEFIELD/DISPLAY=NO,REPORT=YES,DISPLAY MESSAGE=1ST POSITION ; SERIAL NUMBER : P3
IF_GOTO/LOOP==3,GOTO = SKIP1
FOUR =LABEL/
REPORT/LABEL, FILENAME= FILE_HEADER.LBL
$$ NO,
SERIAL NUMBER
ASSIGN/P4=P3+1
TRACEFIELD/DISPLAY=NO,REPORT=YES,DISPLAY MESSAGE=1ST POSITION ; SERIAL NUMBER : P4
SKIP1 =LABEL/
/-/-/-/-/-/-/-/-/-/-/-/-/-/
program goes here
/-/-/-/-/-/-/-/-/-/-/-/
$$ NO,
START OF AUTOSAVE LOOP REPORTING
THE BELOW WILL BUILD THE HEADER FOR EACH REPORT NO NEED TO EDIT UNLESS
YOU ARE RUNNING MORE THAN 4 PARTS.
__________________________________
IF_GOTO/LOOP==1,GOTO = PONE
IF_GOTO/LOOP==2,GOTO = PTWO
IF_GOTO/LOOP==3,GOTO = PTHREE
IF_GOTO/LOOP==4,GOTO = PFOUR
PONE =LABEL/
ASSIGN/V1=P1
IF_GOTO/LOOP==1,GOTO = SKIP2
PTWO =LABEL/
ASSIGN/V1=P2
IF_GOTO/LOOP==2,GOTO = SKIP2
PTHREE =LABEL/
ASSIGN/V1=P3
IF_GOTO/LOOP==3,GOTO = SKIP2
PFOUR =LABEL/
ASSIGN/V1=P4
IF_GOTO/LOOP==4,GOTO = SKIP2
SKIP2 =LABEL/
ASSIGN/DUMP=REPTNAME+PROG_NAME+" REV "+RV+" PART "+V1
$$ NO,
/-/-/-/-/-/-/-/-/-/-/
DONT EDIT THE "PRINT/REPORT" COMMAND BELOW. JUST SAVE THIS PROGRAM TO THE WO FOLDER YOU CREATE BEFORE RUNNING THE PART(S).
THE ABOVE "AUTOSAVE" WILL SAVE THE REPORT TO THAT SAME FOLDER.
/-/-/-/-/-/-/-/-/-/-/
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=ON,OVERWRITE=DUMP,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
REPORT_THEORETICALS=ALL,REPORT_FEATURE_WITH_DIMENS IONS=YES,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES
PROGEND =LABEL/
LOOP/END
The excel form report requires you to use the PCD ID and if you're needing to measure 30 parts make sure you have at least 30 columns with {Measured Value} in the data field. When using the excel form report with a loop, you need to turn the loop ID to NO. And I put a print command inside the start of the loop to delete previous instances or you could put it before the loop end but after the excel form report command.
Looping a program for a capability study, reporting out with Excel Form Report. I have it set up for 30 parts. 2020R2. It keeps reporting the first part rather than each new part. This used to work. What may have changed?
