hexagon logo
Register Sign in
  • Replies 131 replies
  • Subscribers 34 subscribers
  • Views 4301 views
  • Users 0 members are here
Options
Related

Help with OLE Automation

kellyh
Now that I have information in a way that imports and exports the information correctly, I have been tasked with creating an OLE to automatically import the data into the SPC software. I have one that sort of works (as in opens the program, logs in, opens the right collection plan, etc) and I can get put in static information, but I am unsure how to call the information out of PC DMIS to have it be placed in the spots we need in the SPC software being used.

Has anyone else done this? Can anyone explain to me how find the variable and the measurement output in PC DMIS? I am using version 4.2 if that helps any.

Thanks so much.
Parents
  • But if I use a dimension command object, I get zero. So, I have to use something.

    That's because your code is incorrect.

    There are a lot of problems in the last code you posted, and I apologize, but I just can't spend the time required to explain/discuss. To do so accurately, I would have to do it from work (with pcdmis in front of me), and that is not what they pay me to do.

    You may want to look into QC-Calc RealTime. This is a package that absolutely excels at collecting data from all types of measuring equipment, and then exporting in formats that can be used by other softwares (including WinSPC). "From QC-Calc to WinSPC in 2 seconds flat" according to their website. It is very inexpensive as well. Using this tool, no scripting would be required, but very minor modifications to part programs would be necessary. (STATS/ON or XMLSTATS/ON depending on your pc-dmis version).

    http://www.prolinksoftware.com/specific.aspx?type=rt
    http://www.prolinksoftware.com/product_article.aspx?id=170

    Edit: one last thought - if you consider the path you are currently on, you are looking at having a custom import script for each program, or in the best case, a generic script with some sort of text files containing the mapping between pcdmis tolerances and WinSPC. This is all time consuming setup and maintenance over time. QC-Calc should be an easy sell to management.
Reply
  • But if I use a dimension command object, I get zero. So, I have to use something.

    That's because your code is incorrect.

    There are a lot of problems in the last code you posted, and I apologize, but I just can't spend the time required to explain/discuss. To do so accurately, I would have to do it from work (with pcdmis in front of me), and that is not what they pay me to do.

    You may want to look into QC-Calc RealTime. This is a package that absolutely excels at collecting data from all types of measuring equipment, and then exporting in formats that can be used by other softwares (including WinSPC). "From QC-Calc to WinSPC in 2 seconds flat" according to their website. It is very inexpensive as well. Using this tool, no scripting would be required, but very minor modifications to part programs would be necessary. (STATS/ON or XMLSTATS/ON depending on your pc-dmis version).

    http://www.prolinksoftware.com/specific.aspx?type=rt
    http://www.prolinksoftware.com/product_article.aspx?id=170

    Edit: one last thought - if you consider the path you are currently on, you are looking at having a custom import script for each program, or in the best case, a generic script with some sort of text files containing the mapping between pcdmis tolerances and WinSPC. This is all time consuming setup and maintenance over time. QC-Calc should be an easy sell to management.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement