Import Excel form to Plexus

[Horizon101]

I need to import the cmm data to exel sheet so our Plexus system can import the data to our checksheets. I made an customized excel form and can sucessfully download the cmm data. but when i try to import to plexus i get get this error. Lil help The following errors occurred during import:

SpecNo and/or Value columns not defined. Cannot complete import. Valid header values include the following: 'SpecNo', 'Value', 'CavityCode', 'SerialNo'

[AndersI]

Make sure the correct headers are in the template, spelled exactly as Plexus (what is that?) wants them.

[Horizon101]

Plex manufacturing is our software data base

[SABarber]

Ask the makers of Plexus what the error means?

[bfire85]

Are you doing an XLSX or CSV file? We use Plex and it needs to be in a CSV file. You need to have SpecNo column for Plex to read the specification number and Value column for Plex to read the measurement. When I get to the CMM, I'll post some of my code for you. I use the File I/O with PC-DMIS instead of Excel output.

[bfire85]

Place this code before the FILE/WRITELINE of the measurements you want to record:

FPTR         =FILE/OPEN,C:\temp\test.csv,WRITE
                     FILE/WRITELINE,FPTR,SpecNo,Value

Dimensions....then after the measurements, put in a code similiar to this:

DIM 1= LOCATION OF PLANE PLN2  UNITS=MM ,$
  GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
  AX    NOMINAL       MEAS       +TOL       -TOL        MAX        MIN        DEV     OUTTOL
  Y        7.870      7.870      0.500      0.500      7.935      7.828      0.000      0.000 ----#---
  END OF DIMENSION 1
[B] ASSIGN/D1=1+","+GETTEXT(328,1,{1})
              FILE/WRITELINE,FPTR,D1[/B]

The Gettext 328 is the measurement. True position has a different code of 688, I believe. These call can be found when you do a HELP search for "A List of Available Data Types". I use the GETTEXT variable because you can't do 1.Y.MEAS for some reason. Reminder: The number you enter in the assignment for the spec number needs to match what Plex says. So if Plex says 1.1, then you need to have 1.1 instead of 1.

Then when everything is done, at the end of the program add this:

FILE/CLOSE,FPTR,KEEP

Hope this helps.