Exporting Dimesnions Question

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

  • Exporting Dimesnions Question

    I have a need to export my dimensional information to excel. I have been able to do that but I notice that It will only let you choose a single alignment prior to exporting my data. Some of my dimensions are going be taken from different alignments. How can I overcome this problem with out having to output all my dimensions several times in each of the necessary alignments? I need to do this without the Advantage of Datapage.
    Last edited by rerun_lives; 08-17-2007, 02:04 PM.
    sigpic
    Cold Beer MMMmmmm........

    Dell Precision T5400
    Windows 7
    B&S XCEL
    WENZEL LH1512
    PCDMIS 2011 MR1

  • #2
    If you have Datapage, send it all the dimensions to DP, then Export to a file from DP. Import that file into Excel.

    Stu

    Comment


    • #3
      Originally posted by rerun_lives View Post
      I have a need to export my dimensional information to excel. I have been able to do that but I notice that It will only let you choose a single alignment prior to exporting my data. Some of my dimensions are going be taken from different alignments. How can I overcome this problem with out having to output all my dimensions several times in each of the necessary alignments?
      Send them to Datapage, then dump it out as a text file and pull it into Excel.
      sigpic
      Originally posted by AndersI
      I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

      Comment


      • #4
        Export whatever you want directly to a .TXT file using the Insert/File I/O Command/Writing Commands. Then pull the .TXT file into Excel.


        Jan.
        ***************************
        PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
        Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.

        Comment


        • #5
          Why not just use one of the excel scripts
          sigpic
          if you had soap on a rope it would be tied to yer ankle

          Comment


          • #6
            Jan D. The problem is having a way to export the dimensions as a generic text file having the export reference more than one aligment using a single export. Clear as Mud?
            sigpic
            Cold Beer MMMmmmm........

            Dell Precision T5400
            Windows 7
            B&S XCEL
            WENZEL LH1512
            PCDMIS 2011 MR1

            Comment


            • #7
              T Miller what Excel Scripts and where would I find them so I can look at them?
              sigpic
              Cold Beer MMMmmmm........

              Dell Precision T5400
              Windows 7
              B&S XCEL
              WENZEL LH1512
              PCDMIS 2011 MR1

              Comment


              • #8
                http://www.wilcoxassoc.com/home.htm
                go to the users area and scripts you have to register to download them but it is no big deal. You may also have to change the version of pcdmis you use in the excel file. Make a copy of it.
                sigpic
                if you had soap on a rope it would be tied to yer ankle

                Comment


                • #9
                  The way I do this is that I do my alignments and dimensions. Then I open the file and append whatever dimensions I need to the text file. Then I close the file. Then I go through my next alignments and do the same thing. This always gives me data in the latest alignment.

                  Sorry, but I think I still not get what the issue is.... Yes, muddy.... Hey, it's almost Miller time!


                  Jan.
                  ***************************
                  PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
                  Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.

                  Comment


                  • #10
                    Just type this on the end of the program

                    And that's it


                    CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
                    FUNCTION/LoadExcel,SHOW=YES,,
                    STARTSCRIPT/
                    ENDSCRIPT/
                    GOTO/C2



                    B&S
                    Global-image.
                    3.7mr3

                    Comment


                    • #11
                      Still not working!!!

                      Originally posted by fmred79 View Post
                      Just type this on the end of the program

                      And that's it


                      CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
                      FUNCTION/LoadExcel,SHOW=YES,,
                      STARTSCRIPT/
                      ENDSCRIPT/
                      GOTO/C2



                      Sorry Gang,
                      Was hoping this issue would be resolved by now. I am using 4.1 and I have downloaded the pcdmistoexcel_auto.zip file from the Wilcox website and followed the instructions of where to copy the files (C: drive) but when I go to try and type the above command line it will not let me do it. I have to use the "Insert\Script" command from the Insert dropdown menu and put a script in manually and then try to change it to match the line above. It refuses to let me type in the line "ENDSCRIPT/". I tried running it anyway without the line and it WILL NOT WORK, any other suggestions? I must be missing something - what is the "GOTO/C2" Line all about as well?
                      sigpic
                      Cold Beer MMMmmmm........

                      Dell Precision T5400
                      Windows 7
                      B&S XCEL
                      WENZEL LH1512
                      PCDMIS 2011 MR1

                      Comment


                      • #12
                        I could never type the endscript it shows up after the first run.
                        sigpic
                        if you had soap on a rope it would be tied to yer ankle

                        Comment


                        • #13
                          You NEVER type in the ENDSCRIPT/ line. PC-DMIS will put that there automatically after you finish the first time run of the script.

                          I have no idea what can cause your script problem. You will have to be more specific with what the message is that it returns when it poops out..



                          Jan.
                          ***************************
                          PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
                          Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.

                          Comment


                          • #14
                            You may have to edit the excel file to be used with 4.1
                            sigpic
                            if you had soap on a rope it would be tied to yer ankle

                            Comment


                            • #15
                              Here is the error message I am getting:

                              "Error on line 4 4 - OLE Automation Method Exception"

                              OK All you VB Experts Jump on in!
                              sigpic
                              Cold Beer MMMmmmm........

                              Dell Precision T5400
                              Windows 7
                              B&S XCEL
                              WENZEL LH1512
                              PCDMIS 2011 MR1

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X