PRJ: How to Interpret Message Received When You Open .mpx File

This article was previously published under Q141261
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
If Microsoft Project comes across invalid data when you attempt to open an.mpx file, you receive error messages similar to the following:
An error occurred during import (line #32)

Work not valid

Select Yes to continue, No to continue without error messages, or Cancel to stop import.
-or-
Row 3 Column 6

Rate value not valid

Choose Yes to continue messages, No to stop messages, Cancel to stop import.
NOTE: Row and column messages are generated for Task and Resource records only (record 70 for a Task and 50 for a Resource). Line messages are generated for the remainder of the .mpx file records.
MORE INFORMATION
Each line in an .mpx file starts with a record number except for the firstline. Within each record are fields that contain the information for theproject. A description of the records can be found in the followingdocuments:
  • Mpxfile.wri (Windows)
    -and-
  • MPX File Format (Macintosh)
If Microsoft Project generates a message indicating a Line number when youopen an .mpx file, such as:
An error occurred during import (line #32)

Work not valid

Select Yes to continue, No to continue without error messages, or Cancel to stop import.
The first line of this example message indicates that the .mpx file's 32ndline contains invalid data. The line number correlates with the number oflines from the top, when you view the .mpx file in a text editor that doesnot wrap text. In this example, assume that line 32 starts with the recordnumber of 75. Using the .mpx description document, you can determine thatrecord number 75 is a Resource Assignment Record.

If you receive an error message indicating a row and column, the meaningfor the Row will be different depending on your version of MicrosoftProject.

You can determine whether the row and column message is referring to a taskor resource by the second line of the message: for example, "Rate notvalid," relates to a resource, while "Duration not valid" relates to atask.

If You Are Using Microsoft Project 4.0 or 4.1

If you receive a message indicating a Row and Column in Project 4.0or 4.1, such as:
Row 3 Column 6

Rate value not valid

Choose Yes to continue messages, No to stop messages, Cancel to stop import.
Row 3 in this example is identifying the third resource or a record numberof 50 with an ID number of 3. To locate the line in the .mpx file that isgenerating this message, open the .mpx file in a Text editor and findrecords that start with "50" that identifies it as a Resource record andthen the ID number 3, such as 50,3,2,Bob,

If You Are Using Microsoft Project Version 3.0

In Microsoft Project 3.0 opening the same .mpx file would generate the message below:
Row 20 Column 6

Rate value not valid

Choose Yes to continue messages, No to stop messages, Cancel to stop import.
Microsoft Project 3.0 is identifying a specific line or row in the .mpxfile (you can see this line if you view the file in a text editor such asWindows Notepad). In this example, the 20th line or row down from the topis where the error would be found.

Column 6 in both examples can be identified by looking at record 40 (or 41,or 70/71 for a Task) which is the Text Resource Table Definition--thisrecord lists the resource fields, in order, that are being imported orexported.
REFERENCES
For more information, see the appropriate file for your version ofMicrosoft Project:
  • Mpxfile.wri (Windows)

    -and-

  • MPX File Format (Macintosh)
Or, click the article number below to view the article in the Microsoft Knowledge Base:
270139 PRJ: Description of the MPX Project File Exchange Format
prj2000 prj98 prj4 prj41 mprj4
Properties

Article ID: 141261 - Last Review: 02/28/2014 08:00:09 - Revision: 5.0

  • Microsoft Project 2000 Standard Edition
  • Microsoft Project 98 Standard Edition
  • Microsoft Project 4.1 Standard Edition
  • Microsoft Project 3.0 Standard Edition
  • Microsoft Project 4.0 Standard Edition
  • Microsoft Project 3.0 for Macintosh
  • Microsoft Project 4.0 for Macintosh
  • kbnosurvey kbarchive kbhowto kbusage KB141261
Feedback