Excel Files lost

Hello All!
I am relatively new to the CMM programming world and am curious about a potential coding work around for Poor network connectivity issues. In short, our CMM is set to save the excel files directly to a pre-specified network folder so that they may be accessed by our engineering team in another facility about 40 miles away. our network connectivity is quite shoddy at times and when that port goes down all Excel data appears to be "Lost" is this information stored anywhere locally? or is it simply gone? if it isnt backed up anywhere is there a way i can set up PC-DMIS to duplicate the export in another location?

Parents

louisd over 7 years ago

This is what we use to output via assignments and file/writeline commands.
There are a bunch of omitted comment inputs, and it's segmented because there are loop iterations also omitted.
-But it's a great baseline to understand how to output data to excel.

At the end if you didn't notice, we are taking a locally created C drive file, and moving it over to a network path (t drive). We've had instances of PCDMIS skipping sections of data output when writing directly to network location, this was the fix.

ASSIGN/T_PATH="T:\MEASURLINK_TRANSFER\CMM CM-004\M44_CARRIER_CAP_SU_IMPORT.CSV"
            ASSIGN/C_PATH="C:\PRODUCTION\MERIDIAN\CARRIER CAP\M44_CARRIER_CAP_SU.CSV"
            ASSIGN/C_TEMP="C:\PRODUCTION\C_TRANSFER\M44_CARRIER_CAP_SU.CSV"
TFILE_CHECK=FILE/EXISTS,T_PATH
            IF/TFILE_CHECK==1
            FILE/DELETE,T_PATH
            END_IF/
CFILE_CHECK=FILE/EXISTS,C_TEMP
            IF/CFILE_CHECK==1
            FILE/DELETE,C_TEMP
            END_IF/
C_FILE     =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE,"/PART NUMBER/" + "," + PART
            FILE/WRITELINE,C_FILE,"/ROUTINE NAME/" + "," + ROUTINE
            FILE/WRITELINE,C_FILE,"/LOT#/" + "," + RUN_ID
            FILE/WRITELINE,C_FILE,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
            FILE/WRITELINE,C_FILE,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
            FILE/CLOSE,C_FILE,KEEP
C_TEMPFILE1=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE1,"/PART NUMBER/" + "," + PART
            FILE/WRITELINE,C_TEMPFILE1,"/ROUTINE NAME/" + "," + ROUTINE
            FILE/WRITELINE,C_TEMPFILE1,"/LOT#/" + "," + RUN_ID
            FILE/WRITELINE,C_TEMPFILE1,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
            FILE/WRITELINE,C_TEMPFILE1,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
            FILE/CLOSE,C_TEMPFILE1,KEEP
C_FILE2    =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V1 + "," + POS1
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V1 + "," + AB_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V1 + "," + AC_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V1 + "," + AD_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V1 + "," + AF_1.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V2 + "," + POS2
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V2 + "," + AB_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V2 + "," + AC_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V2 + "," + AD_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V2 + "," + AF_2.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V3 + "," + POS3
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V3 + "," + AB_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V3 + "," + AC_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V3 + "," + AD_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V3 + "," + AF_3.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V4 + "," + POS4
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V4 + "," + AB_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V4 + "," + AC_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V4 + "," + AD_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V4 + "," + AF_4.MEAS
C_TEMPFILE2=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V1 + "," + POS1
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V1 + "," + AB_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V1 + "," + AC_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V1 + "," + AD_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V1 + "," + AF_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V2 + "," + POS2
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V2 + "," + AB_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V2 + "," + AC_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V2 + "," + AD_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V2 + "," + AF_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V3 + "," + POS3
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V3 + "," + AB_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V3 + "," + AC_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V3 + "," + AD_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V3 + "," + AF_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V4 + "," + POS4
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V4 + "," + AB_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V4 + "," + AC_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V4 + "," + AD_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V4 + "," + AF_4.MEAS
            FILE/CLOSE,C_TEMPFILE2,KEEP
C_FILE     =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE,"/END/"
            FILE/CLOSE,C_FILE,KEEP
C_TEMPFILE3=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE3,"/END/"
            FILE/CLOSE,C_TEMPFILE3,KEEP
            FILE/MOVE,C_TEMP,T_PATH

Reply

louisd over 7 years ago

ASSIGN/T_PATH="T:\MEASURLINK_TRANSFER\CMM CM-004\M44_CARRIER_CAP_SU_IMPORT.CSV"
            ASSIGN/C_PATH="C:\PRODUCTION\MERIDIAN\CARRIER CAP\M44_CARRIER_CAP_SU.CSV"
            ASSIGN/C_TEMP="C:\PRODUCTION\C_TRANSFER\M44_CARRIER_CAP_SU.CSV"
TFILE_CHECK=FILE/EXISTS,T_PATH
            IF/TFILE_CHECK==1
            FILE/DELETE,T_PATH
            END_IF/
CFILE_CHECK=FILE/EXISTS,C_TEMP
            IF/CFILE_CHECK==1
            FILE/DELETE,C_TEMP
            END_IF/
C_FILE     =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE,"/PART NUMBER/" + "," + PART
            FILE/WRITELINE,C_FILE,"/ROUTINE NAME/" + "," + ROUTINE
            FILE/WRITELINE,C_FILE,"/LOT#/" + "," + RUN_ID
            FILE/WRITELINE,C_FILE,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
            FILE/WRITELINE,C_FILE,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
            FILE/CLOSE,C_FILE,KEEP
C_TEMPFILE1=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE1,"/PART NUMBER/" + "," + PART
            FILE/WRITELINE,C_TEMPFILE1,"/ROUTINE NAME/" + "," + ROUTINE
            FILE/WRITELINE,C_TEMPFILE1,"/LOT#/" + "," + RUN_ID
            FILE/WRITELINE,C_TEMPFILE1,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
            FILE/WRITELINE,C_TEMPFILE1,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
            FILE/CLOSE,C_TEMPFILE1,KEEP
C_FILE2    =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V1 + "," + POS1
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V1 + "," + AB_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V1 + "," + AC_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V1 + "," + AD_1.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V1 + "," + AF_1.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V2 + "," + POS2
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V2 + "," + AB_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V2 + "," + AC_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V2 + "," + AD_2.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V2 + "," + AF_2.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V3 + "," + POS3
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V3 + "," + AB_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V3 + "," + AC_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V3 + "," + AD_3.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V3 + "," + AF_3.MEAS
            FILE/WRITELINE,C_FILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V4 + "," + POS4
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_1 + V4 + "," + AB_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_2 + V4 + "," + AC_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_3 + V4 + "," + AD_4.MEAS
            FILE/WRITELINE,C_FILE2,"/DATA/" + "," + CHAR_4 + V4 + "," + AF_4.MEAS
C_TEMPFILE2=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V1 + "," + POS1
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V1 + "," + AB_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V1 + "," + AC_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V1 + "," + AD_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V1 + "," + AF_1.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V2 + "," + POS2
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V2 + "," + AB_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V2 + "," + AC_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V2 + "," + AD_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V2 + "," + AF_2.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V3 + "," + POS3
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V3 + "," + AB_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V3 + "," + AC_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V3 + "," + AD_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V3 + "," + AF_3.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position " + V4 + "," + POS4
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_1 + V4 + "," + AB_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_2 + V4 + "," + AC_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_3 + V4 + "," + AD_4.MEAS
            FILE/WRITELINE,C_TEMPFILE2,"/DATA/" + "," + CHAR_4 + V4 + "," + AF_4.MEAS
            FILE/CLOSE,C_TEMPFILE2,KEEP
C_FILE     =FILE/OPEN,C_PATH,APPEND
            FILE/WRITELINE,C_FILE,"/END/"
            FILE/CLOSE,C_FILE,KEEP
C_TEMPFILE3=FILE/OPEN,C_TEMP,APPEND
            FILE/WRITELINE,C_TEMPFILE3,"/END/"
            FILE/CLOSE,C_TEMPFILE3,KEEP
            FILE/MOVE,C_TEMP,T_PATH

Children

No Data