hexagon logo

Multiple run files into one spc or chart

We have runs of 7 parts. Part names of the same part will include different job #'s therefore creating multiple part files over several runs. Can multiple part runs (files) be combined into datapage to yield a history to date of a part number for SPC bar chart, Histogram? Perhaps an appending in text spreadsheet?
Parents
  • If I were to throw everything into one file, kind of in reverse of combining, and break the file later to achieve seperation. Lots of Work?

    Thanks Matt and sorry for my shortcoming with Datapage. Just getting on-line with it.

    I wondered how long it was gonna be before you asked HOW instead of just "can you?" Slight smile

    OK, to COMBINE the parts into ONE database, there is only ONE WAY that I know of off the top of my head to do this in/with Datapage....

    1) ALL the programs MUST MUST MUST use the same save-stats ID (either DIM-IDS or FEATURE-IDS)
    2) ALL the program MUST MUST MUST use the same ID for the same FEATURE, (you can't measure the 'top-left" hole on one part/program and call it H001 and then call the same hole on a different part/program H002)
    3) The data CAN BE saved to different databases
    4) Using DpEditor, do an ASCII DUMP of one of the parts. Edit the file it made and CHANGE THE PART NAME to the one you want to combine all the data in.
    5) Using DpEditor, load the ASCII file you dumped and edited, the data will now be in the part name you changed in the file.
    6) Continue until you have done this for all the identical parts.

    You can now make combined reports for all parts.



    Here is how to do it with Pcdmis (easiest way, IMO)

    OK, you have 7 identical parts, checked with 7 "identicle" programs except for the PART NAME they save the data under.

    1) Rename the PART NAME in the program (very top line when header is shown) so that they are ALL THE SAME. This will put ALL the data into the same database without changing the PROGRAM NAME you are running.
    2) ADD a TRACEFIELD to EACH program, this tracefield will be the JOB number you currently have them sorted by. Once you get it into the program, you can have it NOT SHOW so that none of the monkeys will change it and it has to be AFTER the STAT/ON command in the program.
    2a) Instead of keeping all 7 of the programs, leave the tracefield showing and have the operator enter the correct job number for the parts he is running and have just the one program to run, no matter the job number.
    3) In the DpEditor, add a QUERY (and I don't mean Spaz) to sort by this tracefield. Once it is created, you can sort by this tracefield in Datapage when makgin reports OR choose ALL the parts.

    The option for Pcdmis must be done before running any parts. However, if you have already run parts, you can do the datapage method above to put all the data into one database, but FIRST you would ahve to add the tracefield to each part, edit the value for all transactions before you dump the ASCII file and edit the part name.

    So, are you totally confused now?
Reply
  • If I were to throw everything into one file, kind of in reverse of combining, and break the file later to achieve seperation. Lots of Work?

    Thanks Matt and sorry for my shortcoming with Datapage. Just getting on-line with it.

    I wondered how long it was gonna be before you asked HOW instead of just "can you?" Slight smile

    OK, to COMBINE the parts into ONE database, there is only ONE WAY that I know of off the top of my head to do this in/with Datapage....

    1) ALL the programs MUST MUST MUST use the same save-stats ID (either DIM-IDS or FEATURE-IDS)
    2) ALL the program MUST MUST MUST use the same ID for the same FEATURE, (you can't measure the 'top-left" hole on one part/program and call it H001 and then call the same hole on a different part/program H002)
    3) The data CAN BE saved to different databases
    4) Using DpEditor, do an ASCII DUMP of one of the parts. Edit the file it made and CHANGE THE PART NAME to the one you want to combine all the data in.
    5) Using DpEditor, load the ASCII file you dumped and edited, the data will now be in the part name you changed in the file.
    6) Continue until you have done this for all the identical parts.

    You can now make combined reports for all parts.



    Here is how to do it with Pcdmis (easiest way, IMO)

    OK, you have 7 identical parts, checked with 7 "identicle" programs except for the PART NAME they save the data under.

    1) Rename the PART NAME in the program (very top line when header is shown) so that they are ALL THE SAME. This will put ALL the data into the same database without changing the PROGRAM NAME you are running.
    2) ADD a TRACEFIELD to EACH program, this tracefield will be the JOB number you currently have them sorted by. Once you get it into the program, you can have it NOT SHOW so that none of the monkeys will change it and it has to be AFTER the STAT/ON command in the program.
    2a) Instead of keeping all 7 of the programs, leave the tracefield showing and have the operator enter the correct job number for the parts he is running and have just the one program to run, no matter the job number.
    3) In the DpEditor, add a QUERY (and I don't mean Spaz) to sort by this tracefield. Once it is created, you can sort by this tracefield in Datapage when makgin reports OR choose ALL the parts.

    The option for Pcdmis must be done before running any parts. However, if you have already run parts, you can do the datapage method above to put all the data into one database, but FIRST you would ahve to add the tracefield to each part, edit the value for all transactions before you dump the ASCII file and edit the part name.

    So, are you totally confused now?
Children
No Data