Excel Forms

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Forms

    I am new to PCDIMS and having a hard time exporting results to excel. I tried using the built in excel forms but I'm not having much luck.
    The problem I'm having is that PCDIMS will save a new excel spreadsheet for every part I run. I want all my results to go into the same spreadsheet. I have done this in other CMM software. Is this possible in PCDIMS? In my picture, I want the next part to populate column #2, but instead I get a new spreadsheet with only one pc each time.
    Excel form report.JPG
    Last edited by destiny; 12-11-2019, 01:39 PM.

  • #2
    Look up file/writeline in the forum. You can write to CSV files using this method.
    There are some newer PCD to Excel outputs with newer versions, i'm sure others will chime in on the capabilities. Are you using a recent version of PCDMIS?

    Comment


    • #3
      Every program I write has it's own excel file that the CMM will append dimensional data to.

      I control this by going into--> File/Printing/Report Window Print Setup. Click over to the "Excel" tab.

      I then fill out the options shown below.

      Note1: Change end of file path. Everything BEFORE the double backslashes are the FILE LOCATION where the excel will go. Those files MUST EXIST prior to running your program for the first time. Everything AFTER the double backslashes is the name of the excel that PC DMIS will create (first time you run the prg)/append to (all subsequent part runs).

      Note2; For your example, make sure append is selected.

      pic group.PNG






      Data in the excel file looks like this-->

      pic 2.PNG
      Last edited by DAN_M; 12-11-2019, 02:04 PM.
      SF7107(PCD), SF454(PCD), 152614(Quindos), 9159(Quindos), 7107(Quindos), B&S Manual, M&M Gear Checker

      Comment


      • #4
        Originally posted by louisd View Post
        Look up file/writeline in the forum. You can write to CSV files using this method.
        There are some newer PCD to Excel outputs with newer versions, i'm sure others will chime in on the capabilities. Are you using a recent version of PCDMIS?
        I am using 2019 R1

        Comment


        • #5
          Originally posted by DAN_M View Post
          Every program I write has it's own excel file that the CMM will append dimensional data to.

          I control this by going into--> File/Printing/Report Window Print Setup. Click over to the "Excel" tab.

          I then fill out the options shown below.

          Note1: Change end of file path. Everything BEFORE the double backslashes are the FILE LOCATION where the excel will go. Those files MUST EXIST prior to running your program for the first time. Everything AFTER the double backslashes is the name of the excel that PC DMIS will create (first time you run the prg)/append to (all subsequent part runs).

          Note2; For your example, make sure append is selected.

          pic group.PNG






          Data in the excel file looks like this-->

          pic 2.PNG
          Thank you for your example. I played around with that a bit and got it to work with CSV only. Ultimately what I'm trying to do is own spreadsheet with the CMM results. It is similar to the 5 pc study example in my original post. I do not want the nominal, tolerances, OOT, etc to populate the spreadsheet again, just the actuals to next to the 1st set.

          Comment


          • #6
            destiny

            No problem. Happy to help!

            To only send measured value, not all of the other stuff....

            Go to your edit window. BEFORE your dimensions, click somewhere in your edit window.

            Hit F10 to open "Parameter Settings". Click to the "Dimension " tab. Everything that you see checked will be shown on your inspection report and will ALSO go to your excel file. For your example, un-check everything EXCEPT for "Measured". Click "apply" and then "ok". Doing this will insert code into your edit window that looks like this:

            Code:
            FORMAT/TEXT,OPTIONS,ID,HEADINGS,SYMBOLS, ;MEAS, , , , , ,
            Once you run your program with the above setting used, your insp report will look like this:
            pic_1.PNG


            And you should only get what is displayed on your report sent to the excel.

            SF7107(PCD), SF454(PCD), 152614(Quindos), 9159(Quindos), 7107(Quindos), B&S Manual, M&M Gear Checker

            Comment


            • #7
              Originally posted by destiny View Post
              The problem I'm having is that PCDIMS will save a new excel spreadsheet for every part I run. I want all my results to go into the same spreadsheet.
              You need to go into the Report Settings and remove anything that makes the generated file name unique, such as Date and Time (and Serial number, if you change that for each run):

              efr.PNG

              AndersI
              SW support - Hexagon Metrology Nordic AB

              Comment


              • #8
                Originally posted by AndersI View Post

                You need to go into the Report Settings and remove anything that makes the generated file name unique, such as Date and Time (and Serial number, if you change that for each run):

                efr.PNG
                Anders, thanks.

                I took out serial number, date, and time and it's still not doing what I need. Here is a picture of my form settings.
                excel form 2.JPG

                Comment


                • #9
                  Since we are talking about excel forms, I followed the help file on how to access excel forms and I don't have the folder within my pcdmis directory. Running 2019 R1. Do I need to purchase something? My module list is empty.

                  C:\Users\Public\Documents\Hexagon\PC-DMIS\<version>\ExcelFormReport\Templates
                  Last edited by acgarcia; 12-12-2019, 04:41 PM.

                  Comment


                  • #10
                    Just create the folder - that happened to me also...
                    AndersI
                    SW support - Hexagon Metrology Nordic AB

                    Comment


                    • acgarcia
                      acgarcia commented
                      Editing a comment
                      Thanks. That worked.

                  • #11
                    Has anyone used any of the built in forms successfully? I am most interested in the 5 pc study form, as my spreadsheet is very similar to that.
                    Do I need to purchase something else to achieve what I'm trying to do?

                    Comment


                    • AndersI
                      AndersI commented
                      Editing a comment
                      Yes.I have no problems with the 5 pc study. What problems do you have?

                    • michaelwildschutz
                      michaelwildschutz commented
                      Editing a comment
                      It will work for a program that is looped 5 times and that is it.I tried to get it to append for more runs but it does not work...I also tried to alter it for a customers template to run and append for only 1 part not 5 and it too would not append no matter what I did with the naming strategy..

                  • #12
                    This is hexagons first attempt at this excel reporting thing and they still have a lot of bugs to work out..I have been working with them (for several months,since they came out with this new add on) to get a few of my customers templates resolved but they (Hexagon) have stopped helping me now because even their expert could not get it to work properly..
                    Michael A Wildschutz Sr
                    I Walk on The WildSide
                    "To Each is Own"

                    Comment


                    • #13
                      When I generate a report, I can see the FCF's populate certain cells just fine. However, they show up as jibberish to anyone else looking at it on the server.

                      pcd2excel.JPG
                      sigpicTAU ALPHA PI INDIANA DELTA CHAPTER
                      "Due to the highly confidential nature of my job, I am not allowed to know what I am doing" - author unknown

                      Comment


                      • bherrin
                        bherrin commented
                        Editing a comment
                        I've never noticed a Pcdmis font before, does everyone else trying to view it have that available?

                    • #14
                      You have to have the GD&T font installed on the PC you are viewing the form on. Installed PC-DMIS font and I can see it just fine. When PCDMIS2EXCEL outputs, it should embed the font file and have prompt tel the user to install in order to view FCF's
                      sigpicTAU ALPHA PI INDIANA DELTA CHAPTER
                      "Due to the highly confidential nature of my job, I am not allowed to know what I am doing" - author unknown

                      Comment


                      • #15
                        Originally posted by Benedictj1 View Post
                        When I generate a report, I can see the FCF's populate certain cells just fine. However, they show up as jibberish to anyone else looking at it on the server.

                        pcd2excel.JPG
                        That's almost a carbon copy of the report I'm trying to populate direct from PC-DIMS to excel. Can you please tell me how you do it? Are you using any other external apps?

                        Comment

                        Related Topics

                        Collapse

                        Working...
                        X