Importing a list with boolean, date and nullable fields

[Anonymous]

Hi,

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
 

[Anonymous]

The best way to figure this out is to export a CSV of a few leads from your lead database, and then use this as a model for the data value of these fields. 

[Anonymous]

Thanks Murtza, I was thinking about that but the export functionality does not allow selective export, and the database has about 45k or records, couple that with more than 100 fields, I can imagine that it will take a long time.

Will give it a try .. Thanks!

[Anonymous]

Based on the exported data, it looks like:

1) "1" should be for true, empty for false

2) Date should be something like "2014-08-04 04:25:03"

3) Still not sure about this. "NULL" or "null" or empty field value? 

[Edward_Masson]

NULL works to empty fields. Just try it on a string field (text box). I do it all the time for my multiple city field for roadshows, I need to clear that field each year as we might not run the roadshow in the same cities following year.