Excel Forms

[destiny]

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

[louisd]

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?

[DAN_M]

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

[destiny]

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

[destiny]

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.

[EMUPlasticslab]

Question: How do you setup Excel to always open in the last attach sheet? Mine always open in the last saved

[DAN_M]

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:

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.

[AndersI]

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

[destiny]

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

[acgarcia]

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

[AndersI]

Just create the folder - that happened to me also...

[acgarcia]

Thanks. That worked.

[destiny]

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?

[AndersI]

Yes.I have no problems with the 5 pc study. What problems do you have?

[michaelwildschutz]

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

[michaelwildschutz]

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

[Benedictj1]

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

[bherrin]

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

[Benedictj1]

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

[destiny]

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?