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

Milicron Mike over 7 years ago

ASSIGN/ST_TM=SYSTEMTIME("HH-mm-ss")
            ASSIGN/SYS_DT=SYSTEMDATE("MM-dd-yyy'")
            ASSIGN/MTI1="S:\[COLOR=#FF0000][B]MAKE THIS THE PATH YOU WANT TO WRITE TO[/B][/COLOR]\\"
            ASSIGN/MTI2="[COLOR=#FF0000][B]MAKE THIS YOUR FILE NAME[/B][/COLOR]"
            ASSIGN/MTI3=CONCAT(MTI2," CAVITY-",C1.INPUT," ",ST_TM," ",SYS_DT) [B][COLOR=#FF0000]<----<<< THIS LINE ADDS CAVITY NUMBER "C1.INPUT" AND SYS DATE AND TIME TO THE FILE NAME [/COLOR][/B]
            ASSIGN/MTI4=CONCAT(MTI1,MTI3) [B][COLOR=#FF0000]<----<<< THIS LINE CONCATINATES EVERYTHING TOGETHER INTO A PATH AND FILE NAME[/COLOR][/B]
            PRINT/REPORT,EXEC MODE=END,$
              TO_FILE=[B][COLOR=#FF0000]ON[/COLOR][/B],[COLOR=#0000FF]APPEND[/COLOR]=MTI4,AUTO OPEN REPORT=[COLOR=#0000FF]OFF[/COLOR],$ [B][COLOR=#FF0000]<----<<< WRITES OUT A PDF TO YOUR PATH AND FILE NAME ABOVE WILL OVERWRITE OR [/COLOR][COLOR=#0000FF]APPEND AND WILL OPEN THE REPORT TO BE VIEWED BY THE OPERATOR[/COLOR][/B]
              TO_PRINTER=OFF,COPIES=1,$[B][COLOR=#FF0000]<----<<< [/COLOR][/B][B][COLOR=#FF0000]THIS LINE SENDS THE pdf TO THE PRINTER 1 COPY OR SEVERAL[/COLOR][/B]
              TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
              REPORT_THEORETICALS=ALL,REPORT_FEATURE_WITH_DIMENSIONS=YES,$
              TO_EXCEL_OUTPUT=OFF,[B][COLOR=#FF0000]<----<<< [/COLOR][/B][B][COLOR=#FF0000]THIS LINE SENDS EXCEL OUTPUTS TO THE ABOVE DIRECTORY[/COLOR][/B]
              PREVIOUS_RUNS=DELETE_INSTANCES

If you turn off the DELETE INSTANCES you can stack another one of these below the first and send all of this data to another location as PDF, EXCEL, or hard copy.

Reply

Milicron Mike over 7 years ago

ASSIGN/ST_TM=SYSTEMTIME("HH-mm-ss")
            ASSIGN/SYS_DT=SYSTEMDATE("MM-dd-yyy'")
            ASSIGN/MTI1="S:\[COLOR=#FF0000][B]MAKE THIS THE PATH YOU WANT TO WRITE TO[/B][/COLOR]\\"
            ASSIGN/MTI2="[COLOR=#FF0000][B]MAKE THIS YOUR FILE NAME[/B][/COLOR]"
            ASSIGN/MTI3=CONCAT(MTI2," CAVITY-",C1.INPUT," ",ST_TM," ",SYS_DT) [B][COLOR=#FF0000]<----<<< THIS LINE ADDS CAVITY NUMBER "C1.INPUT" AND SYS DATE AND TIME TO THE FILE NAME [/COLOR][/B]
            ASSIGN/MTI4=CONCAT(MTI1,MTI3) [B][COLOR=#FF0000]<----<<< THIS LINE CONCATINATES EVERYTHING TOGETHER INTO A PATH AND FILE NAME[/COLOR][/B]
            PRINT/REPORT,EXEC MODE=END,$
              TO_FILE=[B][COLOR=#FF0000]ON[/COLOR][/B],[COLOR=#0000FF]APPEND[/COLOR]=MTI4,AUTO OPEN REPORT=[COLOR=#0000FF]OFF[/COLOR],$ [B][COLOR=#FF0000]<----<<< WRITES OUT A PDF TO YOUR PATH AND FILE NAME ABOVE WILL OVERWRITE OR [/COLOR][COLOR=#0000FF]APPEND AND WILL OPEN THE REPORT TO BE VIEWED BY THE OPERATOR[/COLOR][/B]
              TO_PRINTER=OFF,COPIES=1,$[B][COLOR=#FF0000]<----<<< [/COLOR][/B][B][COLOR=#FF0000]THIS LINE SENDS THE pdf TO THE PRINTER 1 COPY OR SEVERAL[/COLOR][/B]
              TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
              REPORT_THEORETICALS=ALL,REPORT_FEATURE_WITH_DIMENSIONS=YES,$
              TO_EXCEL_OUTPUT=OFF,[B][COLOR=#FF0000]<----<<< [/COLOR][/B][B][COLOR=#FF0000]THIS LINE SENDS EXCEL OUTPUTS TO THE ABOVE DIRECTORY[/COLOR][/B]
              PREVIOUS_RUNS=DELETE_INSTANCES

If you turn off the DELETE INSTANCES you can stack another one of these below the first and send all of this data to another location as PDF, EXCEL, or hard copy.

Children

No Data