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

PCDMIS to CSV File

John Kugler
There are a ton of threads regarding PCDMIS to a CSV/Excel file. Most of them are for older versions of PCDMIS.

We are trying to get this to work with 2019 r1. Our goal is to get our PCDMIS data into a single CSV file for all of our part types for each run.


The PCDMIS to Excel option is VERY clunky and not real great for multiple parts of the same part type.


Anybody have a solution we could try??

Thanks
Parents
  • C1 =COMMENT/INPUT,NO,FULL SCREEN=NO,
    Sample Number



    ASSIGN/PTNUM=C1.INPUT
    ASSIGN/PTN=STR(PTNUM)+1
    RUN =LABEL/
    DCC program routine code ( this area is whatever program routine one has created)
    Right after last line of routine code


    $$ NO,
    *****************************************
    ASSIGN/FIL_CSV="C:\Users\Public\Documents\WAI\PC-DMIS\2015.1\CSV_FILES\\125ml_CAP_Substrate.csv" Place where you have pcdmis on drive via installation... use of undescore helps
    ASSIGN/SYSDAT=SYSTEMDATE("MM dd yy")
    ASSIGN/SYSTIM=SYSTEMTIME("HH:mm:ss")
    ASSIGN/V10=SYSDAT+","+SYSTIM
    ASSIGN/V11=DIST1.MEAS
    ASSIGN/V12=LOC1.D.MEAS
    ASSIGN/V13=LOC4.D.MEAS
    ASSIGN/V14=FCFPARL1.MEAS
    ASSIGN/V15= PTN
    ASSIGN/V16=V15+","+V14+","+V13+","+V12+","+V11+","+V10
    FPTR =FILE/OPEN,FIL_CSV,APPEND
    FILE/WRITELINE,FPTR,V16
    FILE/CLOSE,FPTR,KEEP

    Assign/V... whatever dimension you desire via assn drop down table/window. Report(s) that need to have single result columns will require each dimension must be singularly assigned!!!!

    *Open in excel to see results ;but keep as CSV format/style. ** will not append if this csv file is open at time of appending. Each part program will require its on CSV file!!!​
Reply
  • C1 =COMMENT/INPUT,NO,FULL SCREEN=NO,
    Sample Number



    ASSIGN/PTNUM=C1.INPUT
    ASSIGN/PTN=STR(PTNUM)+1
    RUN =LABEL/
    DCC program routine code ( this area is whatever program routine one has created)
    Right after last line of routine code


    $$ NO,
    *****************************************
    ASSIGN/FIL_CSV="C:\Users\Public\Documents\WAI\PC-DMIS\2015.1\CSV_FILES\\125ml_CAP_Substrate.csv" Place where you have pcdmis on drive via installation... use of undescore helps
    ASSIGN/SYSDAT=SYSTEMDATE("MM dd yy")
    ASSIGN/SYSTIM=SYSTEMTIME("HH:mm:ss")
    ASSIGN/V10=SYSDAT+","+SYSTIM
    ASSIGN/V11=DIST1.MEAS
    ASSIGN/V12=LOC1.D.MEAS
    ASSIGN/V13=LOC4.D.MEAS
    ASSIGN/V14=FCFPARL1.MEAS
    ASSIGN/V15= PTN
    ASSIGN/V16=V15+","+V14+","+V13+","+V12+","+V11+","+V10
    FPTR =FILE/OPEN,FIL_CSV,APPEND
    FILE/WRITELINE,FPTR,V16
    FILE/CLOSE,FPTR,KEEP

    Assign/V... whatever dimension you desire via assn drop down table/window. Report(s) that need to have single result columns will require each dimension must be singularly assigned!!!!

    *Open in excel to see results ;but keep as CSV format/style. ** will not append if this csv file is open at time of appending. Each part program will require its on CSV file!!!​
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement