hexagon logo
Register Sign in
  • Replies 131 replies
  • Subscribers 34 subscribers
  • Views 4225 views
  • Users 0 members are here
Options
Related

Help with OLE Automation

kellyh
Now that I have information in a way that imports and exports the information correctly, I have been tasked with creating an OLE to automatically import the data into the SPC software. I have one that sort of works (as in opens the program, logs in, opens the right collection plan, etc) and I can get put in static information, but I am unsure how to call the information out of PC DMIS to have it be placed in the spots we need in the SPC software being used.

Has anyone else done this? Can anyone explain to me how find the variable and the measurement output in PC DMIS? I am using version 4.2 if that helps any.

Thanks so much.
Parents
  • And just in case it helps, here is a portion of the file that I have to work with.

    DATE=6/4/2013 TIME=12:31:10 PM
    PART NAME : 566875-BAFFLE
    REV NUMBER :
    SER NUMBER :
    STATS COUNT : 37
    STARTUP =ALIGNMENT/START,RECALL:,LIST=YES
    ALIGNMENT/END
    MODE/DCC
    FORMAT/ ,OPTIONS, ,HEADINGS,SYMBOLS, ;NOM,TOL,MEAS,DEV,OUTTOL, ,
    LOADPROBE/PROBE6
    TIP/T1A0B0, SHANKIJK=0, 0, 1, ANGLE=0
    MOVESPEED/ 25
    TOUCHSPEED/ 0.75
    PREHIT/ 0.2
    RETRACT/ 0.2
    STATS/ON,DATAPAGE,$
    DIRECTORY=J:\1671\CMM DATA\1675 PCDMIS\DATAPAGE FOR PCDMIS,$
    DIRECTORY=,$
    READ=10,WRITE=20,MEMPAGES=64,DIMENSION NAME,CONTROLCALC OFF,$
    STATS/END
    C1 =COMMENT/INPUT,YES,'PLEASE ENTER MACHINIST CLOCK NUMBER'
    COMMENT/OPER,NO,DO NOT PUT BAFFLE ON FIXTURE UNTIL PROGRAM TELLS YOU!!!
    MOVE/POINT,NORMAL,<5.6878,15.8426,-7.8828>
    PLANE1 =FEAT/PLANE,CARTESIAN,TRIANGLE
    THEO/<6.9764,7.8351,-19.0982>,<0.0011614,0.0001585,0.9999993>
    ACTL/<6.9764,7.8351,-19.116>,<0.0011339,0.0001583,0.9999993>
    MEAS/PLANE,3
    HIT/BASIC,NORMAL,<5.2572,8.8095,-19.0964>,<0.0011614,0.0001585,0.9999993>,<5.2572,8.8096,-19.1142>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.813,8.8488,-19.1005>,<0.0011614,0.0001585,0.9999993>,<8.8126,8.8485,-19.1182>,USE THEO = YES
    HIT/BASIC,NORMAL,<6.8592,5.847,-19.0978>,<0.0011614,0.0001585,0.9999993>,<6.8593,5.8472,-19.1155>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<7.0299,6.3756,-18.9957>
    CIR1 =FEAT/CIRCLE,CARTESIAN,IN,LEAST_SQR
    THEO/<7.0294,7.8992,-19.3031>,<0,0,1>,3.5358
    ACTL/<7.0305,7.8686,-19.3028>,<0,0,1>,3.5335
    MEAS/CIRCLE,9,WORKPLANE
    HIT/BASIC,NORMAL,<6.7839,6.1532,-19.303>,<0.1440895,0.9895647,0>,<6.7799,6.1238,-19.3027>,USE THEO = YES
    HIT/BASIC,NORMAL,<7.0535,6.1327,-19.303>,<-0.0141001,0.9999006,0>,<7.0534,6.1028,-19.3027>,USE THEO = YES
    HIT/BASIC,NORMAL,<7.2578,6.1447,-19.3031>,<-0.1328797,0.9911322,0>,<7.2612,6.1145,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.6647,8.4798,-19.3031>,<-0.9527832,-0.3036513,0>,<8.6909,8.4907,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.5469,8.7962,-19.3031>,<-0.867853,-0.4968211,0>,<8.5363,8.7918,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.3913,9.0175,-19.3031>,<-0.7749532,-0.6320186,0>,<8.3758,9.0059,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.735,9.0623,-19.303>,<0.7610421,-0.6487025,0>,<5.735,9.065,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.4337,8.6482,-19.303>,<0.8988226,-0.4383127,0>,<5.4435,8.643,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.3063,8.3242,-19.303>,<0.9688725,-0.2475604,0>,<5.3166,8.3217,-19.3028>,USE THEO = YES
    ENDMEAS/
    PLANE2- BOTTOM OF BAFFLE=FEAT/PLANE,CARTESIAN,TRIANGLE
    THEO/<7.0037,7.868,-19.2547>,<0.0008384,0.0005591,0.9999995>
    ACTL/<7.0033,7.8586,-19.2724>,<0.0009688,0.0003399,0.9999995>
    MEAS/PLANE,3
    HIT/BASIC,NORMAL,<7.0051,6.1157,-19.2282>,<0.0008384,0.0005591,0.9999995>,<7.0047,6.1159,-19.2719>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.5503,8.7784,-19.2565>,<0.0008384,0.0005591,0.9999995>,<8.5499,8.778,-19.2743>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.4554,8.6818,-19.2538>,<0.0008384,0.0005591,0.9999995>,<5.4554,8.682,-19.2712>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<5.7746,8.3003,-18.3843>
    MOVE/POINT,NORMAL,<4.9509,20.8308,-17.6851>
    L2D1 =FEAT/LINE,CARTESIAN,UNBOUNDED
    THEO/<4.9508,19.6258,-21.3031>,<1,-0.0000662,0>
    ACTL/<4.9507,19.5978,-21.3028>,<1,0.0002452,0>
    MEAS/LINE,2,WORKPLANE
    HIT/BASIC,NORMAL,<4.9508,19.6258,-21.3029>,<0.0000661,1,0>,<4.9507,19.5978,-21.3026>,USE THEO = YES
    HIT/BASIC,NORMAL,<12.4048,19.6253,-21.3032>,<0.0000661,1,0>,<12.4044,19.5996,-21.3029>,USE THEO = YES
    ENDMEAS/
    A1 =ALIGNMENT/START,RECALL:STARTUP,LIST=YES
    ALIGNMENT/LEVEL,ZPLUS,PLANE1
    ALIGNMENT/TRANS,ZAXIS,PLANE1
    ALIGNMENT/TRANS,XAXIS,CIR1
    ALIGNMENT/TRANS,YAXIS,CIR1
    ALIGNMENT/END
    MOVE/POINT,NORMAL,<5.6484,12.2572,1.577>
    COMMENT/OPER,NO,PLEASE PLACE BAFFLE ON FIXTURE AT THIS TIME
    ,VERIFY THAT THE BAFFLE IS RESTING AGAINST ALL 3 LOCATORS
    MOVE/POINT,NORMAL,<3.3206,0.383,2.2668>
    CIR2- OUTER CIRCLE ABOVE STEP=FEAT/CIRCLE,CARTESIAN,OUT,LEAST_SQR
    THEO/<0.0031,-0.0347,0.2653>,<0,0,1>,3.646,0
    ACTL/<0.0022,-0.0384,0.2651>,<0,0,1>,3.6435,0
    MEAS/CIRCLE,10,WORKPLANE
    HIT/BASIC,NORMAL,<1.8261,-0.0347,0.265>,<1,0,0>,<1.8243,-0.0347,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<1.4779,1.0368,0.265>,<0.809017,0.5877852,0>,<1.4746,1.0343,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<0.5664,1.699,0.265>,<0.309017,0.9510565,0>,<0.5649,1.6939,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-0.5603,1.699,0.265>,<-0.309017,0.9510565,0>,<-0.5591,1.6945,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.4718,1.0368,0.265>,<-0.809017,0.5877853,0>,<-1.4703,1.0355,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.8199,-0.0347,0.265>,<-1,0,0>,<-1.8195,-0.0348,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.4718,-1.1063,0.265>,<-0.809017,-0.5877852,0>,<-1.4726,-1.1071,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-0.5603,-1.7685,0.265>,<-0.309017,-0.9510565,0>,<-0.5613,-1.7709,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<0.5664,-1.7685,0.265>,<0.309017,-0.9510565,0>,<0.567,-1.7704,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<1.4779,-1.1063,0.265>,<0.809017,-0.5877853,0>,<1.4777,-1.1065,0.265>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<2.2735,-0.4024,0.3874>
    DIM CIRC2 DIA
    AX NOMINAL +TOL -TOL MEAS DEV OUTTOL
    D 3.6460 0.0020 0.0020 3.6435 -0.0025 0.0005 <-----
    END OF DIMENSION CIRC2 DIA
    DIM CIR2 ROUNDNESS
    AX NOMINAL +TOL -TOL MEAS DEV OUTTOL
    M 0.0000 0.0050 0.0000 0.0011 0.0011 0.0000 -#----

    It may help or may muddy the water.

    Thanks for any other guidance you can give me.
Reply
  • And just in case it helps, here is a portion of the file that I have to work with.

    DATE=6/4/2013 TIME=12:31:10 PM
    PART NAME : 566875-BAFFLE
    REV NUMBER :
    SER NUMBER :
    STATS COUNT : 37
    STARTUP =ALIGNMENT/START,RECALL:,LIST=YES
    ALIGNMENT/END
    MODE/DCC
    FORMAT/ ,OPTIONS, ,HEADINGS,SYMBOLS, ;NOM,TOL,MEAS,DEV,OUTTOL, ,
    LOADPROBE/PROBE6
    TIP/T1A0B0, SHANKIJK=0, 0, 1, ANGLE=0
    MOVESPEED/ 25
    TOUCHSPEED/ 0.75
    PREHIT/ 0.2
    RETRACT/ 0.2
    STATS/ON,DATAPAGE,$
    DIRECTORY=J:\1671\CMM DATA\1675 PCDMIS\DATAPAGE FOR PCDMIS,$
    DIRECTORY=,$
    READ=10,WRITE=20,MEMPAGES=64,DIMENSION NAME,CONTROLCALC OFF,$
    STATS/END
    C1 =COMMENT/INPUT,YES,'PLEASE ENTER MACHINIST CLOCK NUMBER'
    COMMENT/OPER,NO,DO NOT PUT BAFFLE ON FIXTURE UNTIL PROGRAM TELLS YOU!!!
    MOVE/POINT,NORMAL,<5.6878,15.8426,-7.8828>
    PLANE1 =FEAT/PLANE,CARTESIAN,TRIANGLE
    THEO/<6.9764,7.8351,-19.0982>,<0.0011614,0.0001585,0.9999993>
    ACTL/<6.9764,7.8351,-19.116>,<0.0011339,0.0001583,0.9999993>
    MEAS/PLANE,3
    HIT/BASIC,NORMAL,<5.2572,8.8095,-19.0964>,<0.0011614,0.0001585,0.9999993>,<5.2572,8.8096,-19.1142>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.813,8.8488,-19.1005>,<0.0011614,0.0001585,0.9999993>,<8.8126,8.8485,-19.1182>,USE THEO = YES
    HIT/BASIC,NORMAL,<6.8592,5.847,-19.0978>,<0.0011614,0.0001585,0.9999993>,<6.8593,5.8472,-19.1155>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<7.0299,6.3756,-18.9957>
    CIR1 =FEAT/CIRCLE,CARTESIAN,IN,LEAST_SQR
    THEO/<7.0294,7.8992,-19.3031>,<0,0,1>,3.5358
    ACTL/<7.0305,7.8686,-19.3028>,<0,0,1>,3.5335
    MEAS/CIRCLE,9,WORKPLANE
    HIT/BASIC,NORMAL,<6.7839,6.1532,-19.303>,<0.1440895,0.9895647,0>,<6.7799,6.1238,-19.3027>,USE THEO = YES
    HIT/BASIC,NORMAL,<7.0535,6.1327,-19.303>,<-0.0141001,0.9999006,0>,<7.0534,6.1028,-19.3027>,USE THEO = YES
    HIT/BASIC,NORMAL,<7.2578,6.1447,-19.3031>,<-0.1328797,0.9911322,0>,<7.2612,6.1145,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.6647,8.4798,-19.3031>,<-0.9527832,-0.3036513,0>,<8.6909,8.4907,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.5469,8.7962,-19.3031>,<-0.867853,-0.4968211,0>,<8.5363,8.7918,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.3913,9.0175,-19.3031>,<-0.7749532,-0.6320186,0>,<8.3758,9.0059,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.735,9.0623,-19.303>,<0.7610421,-0.6487025,0>,<5.735,9.065,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.4337,8.6482,-19.303>,<0.8988226,-0.4383127,0>,<5.4435,8.643,-19.3028>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.3063,8.3242,-19.303>,<0.9688725,-0.2475604,0>,<5.3166,8.3217,-19.3028>,USE THEO = YES
    ENDMEAS/
    PLANE2- BOTTOM OF BAFFLE=FEAT/PLANE,CARTESIAN,TRIANGLE
    THEO/<7.0037,7.868,-19.2547>,<0.0008384,0.0005591,0.9999995>
    ACTL/<7.0033,7.8586,-19.2724>,<0.0009688,0.0003399,0.9999995>
    MEAS/PLANE,3
    HIT/BASIC,NORMAL,<7.0051,6.1157,-19.2282>,<0.0008384,0.0005591,0.9999995>,<7.0047,6.1159,-19.2719>,USE THEO = YES
    HIT/BASIC,NORMAL,<8.5503,8.7784,-19.2565>,<0.0008384,0.0005591,0.9999995>,<8.5499,8.778,-19.2743>,USE THEO = YES
    HIT/BASIC,NORMAL,<5.4554,8.6818,-19.2538>,<0.0008384,0.0005591,0.9999995>,<5.4554,8.682,-19.2712>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<5.7746,8.3003,-18.3843>
    MOVE/POINT,NORMAL,<4.9509,20.8308,-17.6851>
    L2D1 =FEAT/LINE,CARTESIAN,UNBOUNDED
    THEO/<4.9508,19.6258,-21.3031>,<1,-0.0000662,0>
    ACTL/<4.9507,19.5978,-21.3028>,<1,0.0002452,0>
    MEAS/LINE,2,WORKPLANE
    HIT/BASIC,NORMAL,<4.9508,19.6258,-21.3029>,<0.0000661,1,0>,<4.9507,19.5978,-21.3026>,USE THEO = YES
    HIT/BASIC,NORMAL,<12.4048,19.6253,-21.3032>,<0.0000661,1,0>,<12.4044,19.5996,-21.3029>,USE THEO = YES
    ENDMEAS/
    A1 =ALIGNMENT/START,RECALL:STARTUP,LIST=YES
    ALIGNMENT/LEVEL,ZPLUS,PLANE1
    ALIGNMENT/TRANS,ZAXIS,PLANE1
    ALIGNMENT/TRANS,XAXIS,CIR1
    ALIGNMENT/TRANS,YAXIS,CIR1
    ALIGNMENT/END
    MOVE/POINT,NORMAL,<5.6484,12.2572,1.577>
    COMMENT/OPER,NO,PLEASE PLACE BAFFLE ON FIXTURE AT THIS TIME
    ,VERIFY THAT THE BAFFLE IS RESTING AGAINST ALL 3 LOCATORS
    MOVE/POINT,NORMAL,<3.3206,0.383,2.2668>
    CIR2- OUTER CIRCLE ABOVE STEP=FEAT/CIRCLE,CARTESIAN,OUT,LEAST_SQR
    THEO/<0.0031,-0.0347,0.2653>,<0,0,1>,3.646,0
    ACTL/<0.0022,-0.0384,0.2651>,<0,0,1>,3.6435,0
    MEAS/CIRCLE,10,WORKPLANE
    HIT/BASIC,NORMAL,<1.8261,-0.0347,0.265>,<1,0,0>,<1.8243,-0.0347,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<1.4779,1.0368,0.265>,<0.809017,0.5877852,0>,<1.4746,1.0343,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<0.5664,1.699,0.265>,<0.309017,0.9510565,0>,<0.5649,1.6939,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-0.5603,1.699,0.265>,<-0.309017,0.9510565,0>,<-0.5591,1.6945,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.4718,1.0368,0.265>,<-0.809017,0.5877853,0>,<-1.4703,1.0355,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.8199,-0.0347,0.265>,<-1,0,0>,<-1.8195,-0.0348,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-1.4718,-1.1063,0.265>,<-0.809017,-0.5877852,0>,<-1.4726,-1.1071,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<-0.5603,-1.7685,0.265>,<-0.309017,-0.9510565,0>,<-0.5613,-1.7709,0.2651>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<0.5664,-1.7685,0.265>,<0.309017,-0.9510565,0>,<0.567,-1.7704,0.265>,USE THEO = YES
    MOVE/CIRCULAR
    HIT/BASIC,NORMAL,<1.4779,-1.1063,0.265>,<0.809017,-0.5877853,0>,<1.4777,-1.1065,0.265>,USE THEO = YES
    ENDMEAS/
    MOVE/POINT,NORMAL,<2.2735,-0.4024,0.3874>
    DIM CIRC2 DIA
    AX NOMINAL +TOL -TOL MEAS DEV OUTTOL
    D 3.6460 0.0020 0.0020 3.6435 -0.0025 0.0005 <-----
    END OF DIMENSION CIRC2 DIA
    DIM CIR2 ROUNDNESS
    AX NOMINAL +TOL -TOL MEAS DEV OUTTOL
    M 0.0000 0.0050 0.0000 0.0011 0.0011 0.0000 -#----

    It may help or may muddy the water.

    Thanks for any other guidance you can give me.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement