Try removing the check box format and use an Edit box format to examine the data exactly as it was imported. FileMaker separates check box values with return characters. I don't know what Excel uses to separate selected values. You'll need to figure that out and may need to use the substitute function to replace Excel's list delimiter with FileMaker's return character. Once you have a return character separating each value, you'll get a display of selected check boxes if the values exactly match values of the field's value list.
Also, make sure that you are importing data into a text field, not a number field.
Thank you PhiModJunk
Would you know if the return character you mention as a delimiter is CHAR(10) or CHAR9(13)?
You can just use: ¶ in your calculations such as the substitute function. but it's Char (13) as shown when you use: Code ( ¶ ) to check the value.
I am having a similar problem. I am updating an old library DB from FM5 to FM14. I have one check box field which essentially lists book genres. After exporting data to CSV I nave noticed that some of the values within the value list have two words with spaces and or other types of hyphenation such as periods.
When I view as edit box i FM I can see all of my values have imported. However, I have two questions.
1) I am thinking it would be worthwhile to rename the genres with one word and no additional potential delimiters and re-export.
2) How do I replace existing delimiters with a return in excel. Find replace? Or are you suggesting above that I should replace the delimiter in FM after export?
I am am very, very, new to FM so thank you for your advice.
keep in mind that a "checkbox field" is really a regular field with return-delimited list of values. When you format the field in layout mode, you 'assign' the value-list and any matching values (IN the field) will be viewed as 'checked'.
You may wish to place the same field beside your checkbox-formatted field on the layout, then you can see where there may be values incorrectly imported. This may assist you in finding and replacing the incorrect values for the correct one.
Renaming may help in the long run, but if you change the value list and not the values in the field, then you will have similar mis-matching. Find and replace the old values with the new ones, if you decide to change the value-list.
Thanks for your input. When in check box mode none of the fields show up.
I would change the values for export as well as the value list in the new DB to correspond.
My larger problem is question 2 above - as I will face the same issue when exporting and importing via excel if FM only accepts returns as delimiters.
Does the return-in-cell-list (Excel) get imported into a FileMaker field correctly?
What "delimiters" are you getting from Excel?