Importing into Checkbox fields in notes view

Posted on 2007-04-11
Last Modified: 2013-12-18
Hi all,

I am having a problem trying to import values into a checkbox fields.  When I export, multivalue fields is inserted into the next rows, so how would I be able to import them.  In the view they are displayed as comma separated.  Need to get these done ASAP, can someone please help.
Question by:hu8mypho
  • 3
  • 2
LVL 22

Expert Comment

ID: 18888926
If you are using the Import feature from the File menu, you will need to create a COL file.  A COL file allows you to apply @Formulas to your import data (@Explode, for example).  Search the Designer Help database for "col file" and you should find what you need.

Author Comment

ID: 18890354
I'm looking for the help for the COL file, and I'm not really understanding how to import a list field. will keep looking, but is trying to wrap this up urgently so any more specific pointer is greatly appreciated, thanks for the help.
LVL 22

Expert Comment

ID: 18890807
What format is the import file?
Are you using the Import feature from the File menu?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 18956109
I'm using wk4 import function from file menu.

Author Comment

ID: 18956110
my temporary fix was this:  Create text field, import into text field, use translation @explode(textfield) to get it working.  There should be a better way to do this no??

Accepted Solution

Computer101 earned 0 total points
ID: 19154168
PAQed with points refunded (500)

EE Admin

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus notes forward mail problem 5 432
Using @Prompt in a Queryclose Event 14 88
Migration Lotus to Exchange 2016 4 211
Lotus Notes – Domino Document Manager 4 125
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question