Import Errors

Owned by Mary Lukowski
Last updated: Jun 20, 2014Version comment

Data Dictionary errors when click on bat file to create an XML file:

  1. "object reference not set to an instance of an object":  
    1. one cause is a blank row in the spreadsheet
    2. possibly also if there isn't an 'intervals' tab (this may depend on the bat file)
  2. "exception trying to convert value of 'no' into type 'System.Double':  "No" is entered where there should be a value
    1. A 'no' is entered instead of a value in a Missing Value
    2. A 'no' is entered instead of a value in a pick list option
    3. A comma is missing in the pick list options (e.g. 0,no Male)
  3. "Unable to process variable"
    1. The variable code may be a duplicate

Tips

  1. If pick list options will include commas in them, the name must be in quotes.  For example:  1,no,"Yes, additional text"
  2. If pick list options have spaces, the latest import will accommodate the spaces
  3. If pick list options are specified but not imported, check the format of the column heading it can't be changed