hexagon logo
Register Sign in
  • Replies 10 replies
  • Subscribers 223 subscribers
  • Views 333 views
  • Users 0 members are here
Options
Related

Auto save serialized pdf report

KKann
I have a Basic Script at the beginning of my program that prompts the operator to enter the serial number of a part. Then at the end of the program I have an excel form report being created and auto-saved as the serial number.
I would like to accomplish the same thing but with a PDF report. I can get the PDF to auto-save, but not as the serial number. Below is the end of my program. The green text is where i would assume some type of variable could be placed. Until i get it right i am manually saving. Thanks in Advance guys!



CS2 =SCRIPT/FILENAME= C:\USERS\PUBLIC\DOCUMENTS\HEXAGON\PC-DMIS\2019 R2\REPORT_REFRESH.BAS
FUNCTION/Main,SHOW=YES,,
STARTSCRIPT/
ENDSCRIPT/
ASSIGN/SERI=STR(GETTEXT(193,1,{FILEHEDR}))
ASSIGN/FILENAME=SERI
EXCEL_FORM1=EXCELFORMREPORT/TEMPLATE=H.I.2, TYPE=XLSX
RESULT FOLDER/O:\1Customers\XXXXXX\130XXXXX\Purchase Orders\2611-1
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=ON,OVERWRITE=O:\1Customers\XXXXX\130XXXX 1\Purchase Orders\2611-1\ PN00 SN00.PDF,AUTO OPEN=ON,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=ON,FILE_OPTION=APPEND,FILENAME=O:\1 Customers\XXXXXX\13XXXXXX\Purchase Orders\2611-1,$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMEN SIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES
  • I do my PDF output like this--> 

    GROUP_PRINT_COMMANDS=GROUP/SHOWALLPARAMS=YES
ASSIGN/NUMOOT=GETPROGRAMINFO("NUMOOT")
ASSIGN/PROG_NAME=GETPROGRAMINFO ("PARTNAME")
ASSIGN/DATE=STR(SYSTEMDATE ("dMMMyyyy"))
ASSIGN/TIME=STR(SYSTEMTIME ("HHmmss"))
ASSIGN/REJECT="____REJECT____"
IF/NUMOOT=="0"
ASSIGN/REPORT_NAME="O:\\CMM PROGRAMS\\CMM_PDF_PC DMIS\\AG0OFFLINETEST\\"+PROG_NAME+"__"+VAR_SERIAL_ NUMBER+"__"+VAR_RUNNUMBER+"__"+DATE+"__"+TIME+"__. PDF"
END_IF/
ELSE/
ASSIGN/REPORT_NAME="O:\\CMM PROGRAMS\\CMM_PDF_PC DMIS\\AG0OFFLINETEST\\"+PROG_NAME+"__"+VAR_SERIAL_ NUMBER+"__"+VAR_RUNNUMBER+"__"+DATE+"__"+TIME+"__" +REJECT+".PDF"
END_ELSE/
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=ON,AUTO=1,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=OVERWRITE,FILENAME= [B]REPORT_NAME[/B],$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=KEEP_INSTANCES
ENDGROUP/ID=GROUP_PRINT_COMMANDS


    Operator sees this. Everything is serialized, you don't have to open it to know if its good or not.

  • I don't think you need the last + sign after "+TIME+" or "+REJECT+". It might get rid of the __001 at the end of the pdf filenames.
  • I'm actually hoping to use custom serial numbers. We do not Run 100% of this particular part through the CMM. I have code (basic script) at the beginning of the program to input the part/serial number of the part being checked (they are pre-engraved). I am looking to save as the same thing that's input at the beginning of the program. So maybe not exactly "Serializing" but a custom naming convention.
  • I do something very simple. I just need to put the part's serial number in the report and save the pdf as the parts serial number. So operator scans barcode ABC1234, I have a report comment that displays "Part SN is ABC1234" and the filename in my network folder is ABC1234.pdf 

    SERIAL_NUMBER =COMMENT/INPUT,YES,FULL SCREEN=NO,[COLOR=#e74c3c]<--------INPUT COMMENT, ENTER IN THE SERIAL NUMBER, YES TO DISPLAY ON REPORT[/COLOR]
SCAN PART SERIAL NUMBER
ASSIGN/SN=SERIAL_NUMBER.INPUT

**PROGRAM STUFF GOES HERE**


ASSIGN/REPORT_LOC="\\\\CMM\\"[COLOR=#e74c3c]<-------------NETWORK LOCATION[/COLOR]
ASSIGN/REPORT_NAME=REPORT_LOC+SN[COLOR=#e74c3c]<---------------ASSIGNMENT FOR PRINT COMMAND, COMBINES NETWORK LOCATION AND SERIAL NUMBER[/COLOR]

PRINT/REPORT,EXEC MODE=END,$
TO_FILE=ON,OVERWRITE=[COLOR=#3498db]REPORT_NAME[/COLOR],AUTO OPEN=ON,$
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=KEEP_INSTANCES

  • , can you point me in the right direction for that Basic Script to get the serial number and Excel report? I'm having a time trying to find this stuff.
  • in reply to bjgalbreath
    I've haven't worked with scripts other than in hex classes. Do you have to use a script?
  • in reply to bjgalbreath
    I don't NEED a script if there's a way around needing one. I just want to get my reports into an Excel spreadsheet that has less information than the Report Window Print Setup and keeps it all on one page. My last job used it and I can't find it anywhere.
  • in reply to DAN_M
    Is there a way to do this entirely with C#? I am trying to save both the pdf report and a csv in a specific folder based on some tracefield information at the run time of the program. I would prefer to not have to add this code to every prg file. I have been able to add specific tracefield information to the csv reports but I want to use that same data to save the reports to a specific folder without prompting anything to the operator.


  • In response to your Post 2.2...

    Great question, I have no idea my friend, I don't work with C#. There are people on this forum who do, though.

    If you make an individual post about this hopefully someone will jump in. Goodluck Slight smile
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement