hexagon logo
Register Sign in
  • Replies 35 replies
  • Subscribers 224 subscribers
  • Views 369 views
  • Users 0 members are here
Options
Related

Excel Form Report and Looping

BrianG
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?
Parents 
  • EFR command

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

loop end


    The only thing its doing is deleting the data from the previous part. Otherwise it retains the data from the initial part and fills the EFR with the initial part data only.
  • in reply to S_Cliff
    No change. same thing happening. See below:

    PLN_FLAT_SURFACE =FEAT/PLANE,CARTESIAN,TRIANGLE,NO,LEAST_SQR
    THEO/<20.934,57.363,0>,<0,0,1>
    ACTL/<20.933,57.362,-0.18>,<0.0009803,0.0013251,0.9999986>
    CONSTR/PLANE,BF,PNT8,PNT9,PNT10,PNT11,PNT12,PNT13,PNT14,PNT15,PNT16,PNT17,PNT18,PNT19,PNT20,PNT21,PNT22,PNT23,PNT24,PNT25,PNT26,PNT27,PNT28,PNT29,,
    OUTLIER_REMOVAL/OFF,3
    FILTER/OFF,WAVELENGTH=0
    MOVE/CLEARPLANE
    MOVE/POINT,NORMAL,<0,175,25.4>
    FLATNESS =GEOMETRIC_TOLERANCE/STANDARD=ASME Y14.5,SHOWEXPANDED=NO,
    SEGMENT_1,FLATNESS,0.5,TOL_ZONE_MATH=DEFAULT,
    ADD
    FEATURES/PLN_FLAT_SURFACE,,
    EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Dimensional Data Sheet_REV7, TYPE=XLSX
    RESULT FOLDER/C:\Users\Public\Documents\Hexagon\PC-DMIS\2020 R2\ExcelFormReport\Results
    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_DIMENSIONS=NO,$
    TO_EXCEL=OFF,$
    PREVIOUS_RUNS=DELETE_INSTANCES
    LOOP/END
Reply
  • in reply to S_Cliff
    No change. same thing happening. See below:

    PLN_FLAT_SURFACE =FEAT/PLANE,CARTESIAN,TRIANGLE,NO,LEAST_SQR
    THEO/<20.934,57.363,0>,<0,0,1>
    ACTL/<20.933,57.362,-0.18>,<0.0009803,0.0013251,0.9999986>
    CONSTR/PLANE,BF,PNT8,PNT9,PNT10,PNT11,PNT12,PNT13,PNT14,PNT15,PNT16,PNT17,PNT18,PNT19,PNT20,PNT21,PNT22,PNT23,PNT24,PNT25,PNT26,PNT27,PNT28,PNT29,,
    OUTLIER_REMOVAL/OFF,3
    FILTER/OFF,WAVELENGTH=0
    MOVE/CLEARPLANE
    MOVE/POINT,NORMAL,<0,175,25.4>
    FLATNESS =GEOMETRIC_TOLERANCE/STANDARD=ASME Y14.5,SHOWEXPANDED=NO,
    SEGMENT_1,FLATNESS,0.5,TOL_ZONE_MATH=DEFAULT,
    ADD
    FEATURES/PLN_FLAT_SURFACE,,
    EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Dimensional Data Sheet_REV7, TYPE=XLSX
    RESULT FOLDER/C:\Users\Public\Documents\Hexagon\PC-DMIS\2020 R2\ExcelFormReport\Results
    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_DIMENSIONS=NO,$
    TO_EXCEL=OFF,$
    PREVIOUS_RUNS=DELETE_INSTANCES
    LOOP/END
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement