Jump to content

Outputting two sets of Table Files


---
 Share

Recommended Posts

So currently, I send my table files to an SPC program, good old Enhanced Reporting Software, and it uses them before the table files are archived away. I can't get my SPC program to read my table files unless I use the default calypso nomenclature.

What I would like to do, is use PCM or a Batch file to output the table files again, but with a different name and saved to a different file location. This is probably an easy thing to do; However, I am a total batch file newb. I'm not completely lost, I use VBA in excel and access so i'm at least familiar with the syntax. Also, I'm not asking anyone to do the work for me because i'm actually trying to learn, just need pointed in the right direction.
Link to comment
Share on other sites

We use a spc program that gobbles up the table files too, so I changed the output path to a holding file, then I copy and paste the table files into the results folder. This works ok after a final inspection, but your post got me thinking. XCOPY might be what your looking for. I'm a batch newbe too, but I found this on line, might be the way go, or at least start.122_f1965a13711ae08a97753a643cce5611.docx
Comes with an explanation of switches.
Link to comment
Share on other sites

Do you have PCM?
See if this may be what you're looking for. Its very labor intensive (the way i do it) for the first program, but fairly easy once you get 1 program up and running to copy code into subsequent programs.
Let me know, im willing to help where i can, but this week is F'd because im gone training at "the enemy" software site all week, except for a little bit of time i stop in on my way out and back.
We use text files to send data to WinSPC. my format can just as easily send Excel files.

I've been told several times by people who actually know code that my code sux, and there are easier ways to accomplish this task, but it is what it is and i just use the more difficult version because that's all i know

viewtopic.php?f=13&t=244&p=1913&hilit=text+file#p1913

The finished reports look like the one attached

xxxxxY xxXX-0000 SCAN# 19 .txt

Link to comment
Share on other sites

I believe copying the files is your best bet. You can change the output path or keep it the default. The protocols.log file resides in the measurement plan directory or wherever you store the actuals. This file contains the paths of the output files for the last measured part of the measurement plan. You could use a batch file to read the protocols.log file and copy what you want to where you want after every run.
Link to comment
Share on other sites

David,
This is exactly what I currently do. What I would like to do is repeat the process but the second set of files to have a different name than the first.
Link to comment
Share on other sites

 Share

×
×
  • Create New...