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?
  • 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?

    Yes, sort of, lots of work.
  • Yes, sort of, lots of work.


    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.
  • 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?


    Is the data (several runs) stored in the same database?
  • 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?
  • 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?


    Ugh ~ I feel molested ~ Will digest and try ~ Thank You
  • Multiple datasets into one spc chart

    Hi Gary,

    When I started out, I was the guy everyone came to, to format their data files. We have all been there, and remember your pain.

    I just posted this option elsewhere on this forum, but you might want to consider a graphical SPC reporting software that can import data files from last week, or last year, no matter the measurement device, and standardize your reporting methods.

    I'm in New Business Development for a company called DCS, and we sell a Graphic Data Managment (GDM-3D) software. Shoot me a message, I can show you some examples, and we can talk more.

    Thanks,
    Phil Johnson
    Dimensional Control Systems, Inc.
    New Business Development
    248.269.9777 - office
    248.269.9770 - fax
    pjohnson@3dcs.com - email
    https://www.3dcs.com - website
    http://www.linkedin.com/in/philjohnsondcs
    Dimensional Control Systems Inc. 2009. All rights reserved. The copying, extracting or other use of the wording or information contained in this document or any attached files is prohibited and is intended solely for the use of the individual to whom it is addressed.