Answers.Body: <p>I would double-check that the none of the custom data that you are importing exceeds the length constraint set for those custom fields, and raise that constraint if necessary for the long fields.</p>
  
  <p>I believe default is 255 characters for most, and I believe that includes all options for multi-value sets smashed together, not just 255 characters per option.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-14T21:36:54.177Z
Answers.LastActivityDate: 2016-01-14T21:36:54.177Z
Answers.UserDisplayName: Eli Lisseck
Answers.Body: <p>You can check in custom field settings if "Is this Field Searchable?" is enabled. I think it is necessary to mark it, to appear in the import selectable fields.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-14T22:13:06.713Z
Answers.Text: they are all marked as searchable :)
Answers.UserDisplayName: SproutMediaLab
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-14T21:45:53.533Z
Answers.LastActivityDate: 2015-12-14T21:45:53.533Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>I created several custom fields &amp; groups but I am not seeing all of them when I try to import my contacts. </p>
  
  <p>Like I have a few custom sets/groups and custom fields within each. But only one set is showing when I import my contacts &amp; try to match them up to the fields. I have checked the settings, and everything is the same. Any ideas?</p>
  
  <p>Update: I found the "import multi-value custom data" part of the import contacts ... almost impossible for anyone to find without spending too much time looking through this forum. </p>
  
  <p>HOWEVER when I import it does its normal "column names", "import data (row 1)", "import data (row 2)" thing.... problem is, its putting half of my row 1 in row 2 and not importing all of row one. If that makes sense? In fact not all the column names are in there either. And YES I did check the CSV before uploading &amp; after the error. There is nothing wrong with it. When I imported that same doc for the main import contacts screen it worked fine.</p>
  
  <p>Any ideas? Thanks in advanced!</p>
  
  <p>Update: I decided to upload the multi-value's in smaller chunks to match the specific custom data field that I created. The custom data is broken down into one custom field with a bunch of options in the checkbox setting. When I go to upload the content pertaining to just that, I will go through everything and just set it to the base custom field (since I cannot choose the options). When I do that it processes &amp; then throws out a "DB Error: constraint violation" .</p>
  
  <p>Any ideas, anyone? </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-14T22:16:16.693Z
Comments.Text: Multi-record and a field with multiple options are not the same thing in case that is causing confusion. Ie if you have a field that has the options Apple, Orange, Banana - and you want to import data to that field, then you need a single cell with the values in that cell, ie for Contact A it might be 'Apple, Orange', and for Contact B it might be 'Apple, Banana' and Contact C might be just 'Orange'. If you have a field that allows for multiple 'records' then that is a different scenario. just not sure which you have.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-15T20:22:56.710Z
Comments.Text: If you're receiving a "DB Error: constraint violation", that means there's a more detailed error you're not seeing.  In CiviCRM, please go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save".  Repeat the problem that caused your error, and you'll see much a much more detailed error.  Please update this question with the expanded error and backtrace - and don't forget to disable debugging/backtrace when you're done!
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <custom-fields><import><error><multi-record><field-mapping>
Title: multi-value import issue
ThreadText: # multi-value import issue
  
  (Asked by: username_0 on 2015-12-14)
  
  I created several custom fields & groups but I am not seeing all of them when I try to import my contacts.
  
  Like I have a few custom sets/groups and custom fields within each. But only one set is showing when I import my contacts & try to match them up to the fields. I have checked the settings, and everything is the same. Any ideas?
  
  Update: I found the "import multi-value custom data" part of the import contacts ... almost impossible for anyone to find without spending too much time looking through this forum.
  
  HOWEVER when I import it does its normal "column names", "import data (row 1)", "import data (row 2)" thing.... problem is, its putting half of my row 1 in row 2 and not importing all of row one. If that makes sense? In fact not all the column names are in there either. And YES I did check the CSV before uploading & after the error. There is nothing wrong with it. When I imported that same doc for the main import contacts screen it worked fine.
  
  Any ideas? Thanks in advanced!
  
  Update: I decided to upload the multi-value's in smaller chunks to match the specific custom data field that I created. The custom data is broken down into one custom field with a bunch of options in the checkbox setting. When I go to upload the content pertaining to just that, I will go through everything and just set it to the base custom field (since I cannot choose the options). When I do that it processes & then throws out a "DB Error: constraint violation" .
  
  Any ideas, anyone?
  
  **Tags:** custom-fields, import, error, multi-record, field-mapping
  
  > **Comments:**
  > **username_1**: Multi-record and a field with multiple options are not the same thing in case that is causing confusion. Ie if you have a field that has the options Apple, Orange, Banana - and you want to import data to that field, then you need a single cell with the values in that cell, ie for Contact A it might be 'Apple, Orange', and for Contact B it might be 'Apple, Banana' and Contact C might be just 'Orange'. If you have a field that allows for multiple 'records' then that is a different scenario. just not sure which you have.  
  > **username_2**: If you're receiving a "DB Error: constraint violation", that means there's a more detailed error you're not seeing.  In CiviCRM, please go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save".  Repeat the problem that caused your error, and you'll see much a much more detailed error.  Please update this question with the expanded error and backtrace - and don't forget to disable debugging/backtrace when you're done!  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_3 on 2016-01-14. Score: 1
  
  I would double-check that the none of the custom data that you are importing exceeds the length constraint set for those custom fields, and raise that constraint if necessary for the long fields.
  
  I believe default is 255 characters for most, and I believe that includes all options for multi-value sets smashed together, not just 255 characters per option.
  
  
  ---
  
  ### Answer by username_4 on 2015-12-14. Score: 1
  
  You can check in custom field settings if "Is this Field Searchable?" is enabled. I think it is necessary to mark it, to appear in the import selectable fields.
  
  > **Comments:**
  > **username_0**: they are all marked as searchable :)  
  
  ---
  
  