mibuso.com

Hello all,
I got a question I hope someone knows the answer for

In the current project I got to import a csv into Nav, no problem thats all done.
But now there's the boolean field if I get the file from a client in the UK it says No, if I get it from France it says Non, if I get it from the Netherlands it says Nee,ect....

Is there a way to check if the value is boolean language independent.

Boolean in CSV should be 0 or 1. Navision can automatically map 0-false and 1-true

As Devid described. You can use the Format property to set the format for exporting and you can use the format 9 (XML) or another one to export bolean as integer. Same for Option fields...

That's assuming the csv will get will be from another Nav product which we aren't sure.

You can use the info from these pages to create a "catch all" import:
http://users.elite.net/runner/jennifers/yes.htm & http://users.elite.net/runner/jennifers/no.htm

That is if you have enough time on your hands

Yes and no on the time question, yes I still got time.
No I don't have time
The project had to be finished last friday, off course the client still hasn't delivered any information on what's going to be in the csv.