4 Replies Latest reply on Aug 7, 2014 5:09 PM by Edward Masson

    Importing a list with boolean, date and nullable fields


      What should be the data in the import file for fields of the following data types:

      1) Boolean - "true","false","yes","no"

      Subscribed,Company Name
      True;Company AAA

      2) DateTime - What format should it be? yyyy-mm-dd hh:mm:ss?

      Is "2014-08-04T04:25:03Z" allowed?

      3) To clear the existing value for a DateTime field, should the data be "null" or just an empty value? Is the example below valid?

      Mobile Phone Number,Completed Date,Company Name
      123456789,,Company AAA