Pc Dmis To Excel

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

  • Pc Dmis To Excel

    I want to bring some of my report comments and assignments over to an Excel sheet I'm working on. Can I do this? If so any Suggestions.

  • #2
    I would export what you need to a text file and import from within excel from there. PCDMIS only prints to .RTF / .PDF files which won't work with excel.
    I used to be high on life but I built up a tolerance.

    Brown & Sharpe Global Advantage
    PCDMIS CAD++ v2011mr2
    PH10MQ/SP600M


    sigpic

    Comment


    • #3
      Originally posted by Underspec View Post
      I would export what you need to a text file and import from within excel from there. PCDMIS only prints to .RTF / .PDF files which won't work with excel.

      I can send dimensions to a excel sheet why not comments and assignments?

      Comment


      • #4
        Yes comment is a member of commands and the Comment.GetLine method should do it. It is of data type Long. variables have methods that retrieve their data as well. It depends on what version you have as to whether or not these methods are supported.
        <internet bumper sticker goes here>

        Comment


        • #5
          Originally posted by craiger_ny View Post
          Yes comment is a member of commands and the Comment.GetLine method should do it. It is of data type Long. variables have methods that retrieve their data as well. It depends on what version you have as to whether or not these methods are supported.
          I'm using Version 4.1. Do you happen to know what command I would need to get the varables to come across?

          Comment


          • #6
            Originally posted by Tested View Post
            I'm using Version 4.1. Do you happen to know what command I would need to get the varables to come across?
            You can try the PCD to Excel wizard to see if it handles them. If it does, the source code for the wizard is supplied and you should be able to dig the commands out of there. If not then I don't know.

            HTH,

            t.
            Global Image 555
            PH10M-TP200
            PC-DMIS Cad ++
            Win7 64 bit
            V2014.1

            Comment


            • #7
              Originally posted by dtmtim View Post
              You can try the PCD to Excel wizard to see if it handles them. If it does, the source code for the wizard is supplied and you should be able to dig the commands out of there. If not then I don't know.

              HTH,

              t.
              That wizard gives me a run time error "339" I can't run it.

              Comment


              • #8
                Originally posted by Tested View Post
                That wizard gives me a run time error "339" I can't run it.
                Bummer, I'll try it here. Did it work before or are the variables causing it to fail?
                Global Image 555
                PH10M-TP200
                PC-DMIS Cad ++
                Win7 64 bit
                V2014.1

                Comment


                • #9
                  I've never gotten it to work here.

                  Comment


                  • #10
                    I does work for me. It doesn't handle the variable assignments though. Can you give me a screen shot of the assignment you are looking to get to so I have something to go by? I'll see if I can work something out for you here.

                    Thanks!

                    t.
                    Global Image 555
                    PH10M-TP200
                    PC-DMIS Cad ++
                    Win7 64 bit
                    V2014.1

                    Comment


                    • #11
                      like those in red

                      ASSIGN/V8 = " A DIRECTION "
                      ASSIGN/V9 = LOC1.Z.DEV
                      END_IF/
                      IF/LOC1.Z.MEAS>0
                      ASSIGN/V8 = " B DIRECTION "
                      END_IF/
                      COMMENT/V3,"MOVE THE SHORT END " + V8 + " " + V9 +"mm " ,**********************************************
                      ,
                      FORMAT/TEXT,OPTIONS, ,HEADINGS, , ;DEV, , , , , ,DEVANG
                      ASSIGN/V3 = "YESNO"
                      C4 =COMMENT/V3,NO,CONCENTRICITY IS HIGH DO YOU WANT TO STOP HERE AND FIX IT

                      Comment


                      • #12
                        I think I found it. There is something in the help file under flowcontrolcommand.getrightsideofexpression - once we get the value for the assignments we'll have to get the comment string and do some concatenation to output what you want.
                        Global Image 555
                        PH10M-TP200
                        PC-DMIS Cad ++
                        Win7 64 bit
                        V2014.1

                        Comment


                        • #13
                          flowcontrolcommand.getrightsideofexpression will return "A Direction" or "B Direction" correctly.

                          LOC1.Z.DEV will have to be retrieved and stored in a separate variable just like you would any other measurement because flowcontrolcommand.getrightsideofexpression will only return a string "LOC1.Z.DEV"

                          You can then concatentate a string using these variables and store it in a cell on your worksheet.

                          HTH,

                          t.
                          Global Image 555
                          PH10M-TP200
                          PC-DMIS Cad ++
                          Win7 64 bit
                          V2014.1

                          Comment

                          Related Topics

                          Collapse

                          Working...
                          X