Easy to Create, Easy to Change - Easy to use!


Importing a yes/no field


Started by George Washington
Search
You will need to Sign In to be able to add or comment on the forum!

Importing a yes/no field

Hi there,

I am trying to import data from a text file using the import dialog (and then this will be saved into a .dbi), but I am having hard time to import a yes/no field; I tried to use the word yes and no (using quotes ' , double quotes and without quotes), 1 and 0, true and false, but I did not succeed in any case; what keyeord should I use?

Regards

Written by George Washington 26/04/16 at 10:26:09 Dataease [{8}]FIVE

Re:Importing a yes/no field



Just did a test and it worked fine.

SomeText~YesNo~Choice

First record~yes~One

Second Record~no~Two

Third Record~yes~Three

Fourth Recrod~no~Four

See attached file.

Exported from and imported into the same form.

What version of DataEase are you using?

Written by DataEase 26/04/16 at 11:53:10 Dataease [{8}]FIVE

Re:Importing a yes/no field

The name of the field in the first row of import file was mispelled (blush).

Written by George Washington 26/04/16 at 11:59:51 Dataease [{8}]FIVE

Re:Re:Importing a yes/no field

Don't beat yourself up over it. The majority of bugs we "struggle" with in the DataEase code too is misspelling...

We have an internal procedure of copy/pasting variable names as the first "debugging" round simply to help with the widespread "dyslexia" in this organisation.

Written by DataEase 28/04/16 at 09:53:51 Dataease [{8}]FIVE