Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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)

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