How I translate yes/no to true/false when importing?

[vince591]

I'm importing a csv file which has yes as a value for a checkbox field.   However, SN has True/False.   How do I interpret that?

[Mussie]

Hi Jamie,

I have used the following but it isn't working for me:

if (source.u_staff == 'Yes'){  

answer = true;  

else{  

answer = false;  

}

I also tried:

if (source.u_staff == 'Yes'){  

return true;  

else{  

return false;  

}

This is what it looks like:

Any ideas?

Mussie

[vince591]

Mussie,

If you have control over your import data, make the source value 'Yes' and use the original script.

If you don't have control over your import data, then most likely, the source is among the following plausible values;

      all upper case (YES), all lower case (yes), or Proper case like your test (Yes)  

Expand your if test to include the above:

if (source.u_staff == 'Yes' || source.u_staff == 'YES' || source.u_staff == 'yes') {

        answer = true;

else {

        answer = false;

}

I'm sure somebody else out there might have a simpler solution but this should do the trick for now.

[vince591]

I forgot this after the if test and before the end of the function:

        return answer;

})(source);

[Mussie]

Thanks Vincent, that did the trick. I some how forgot to put the below code at the end of the function.

return answer;

Thank you for your help.

Mussie

[vince591]

Mussie,

You're welcome. Glad I could help.

Vincent.