Importing a list with boolean, date and nullable fields | Community
Skip to main content
A
Anonymous
August 4, 2014
Question

Importing a list with boolean, date and nullable fields

  • August 4, 2014
  • 4 replies
  • 1667 views
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
 
 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

A
Anonymous
August 4, 2014
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. 
A
Anonymous
August 5, 2014
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!
A
Anonymous
August 7, 2014
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
Edward_Masson
Level 10
August 8, 2014
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.
Terms & ConditionsAccessibility statement

Loading footer...