CGFAILnn.LOG file

Another way to create your changes file is through the CGFAIL.LOG file.  If your import definition is completed, you may go ahead and import your data as a test before editing your Changes file.  Anything that IMW can't convert will be written to the CGFAIL.LOG file.  This log file can be copied directly to the .CNG file and edited.  Keep in mind that if you don't know how to convert something, delete that line from the .CNG file so you can add it later.

If after importing you had error messages in your CGFAIL.LOG file, you will be told to view the file.  It might look something like this:

-2                DAMAGESEV                                00                PSGR CAR OR VAN

-2                ROADSURFTYPE                00                PSGR CAR OR VAN

12                VEH1DIR                                                00                U

13                VEH2DIR                                                00                U

14                VEH1MOVE                                00

This file tells you that it didn't have lookups or changes associated with text values that were imported.  In which case, these would just be turned into blanks when viewing a record.  The fourth column tells you the values that it found in the source data file during the import.  If the values are not valid for the field name shown, as in the first two lines of this example, you may ignore them.  However if the values are valid and should be shown, as in the next two lines, then you need to add them to your changes file (.CNG), and possibly your lookup file (.LUS).

More:

Adding a new value to your lookup file

Adding a new value to your changes file