CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Invalid value for field(s) error attempting to import Activities custom fields
Pages: [1]

Author Topic: Invalid value for field(s) error attempting to import Activities custom fields  (Read 2495 times)

Gary Palmer

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.0.3
  • CMS version: Drupal 7.2
  • MySQL version: 5.1.52
  • PHP version: 5.2.16
Invalid value for field(s) error attempting to import Activities custom fields
July 15, 2011, 05:57:01 am
I have added 2 Custom groups relating to all Activities. I am attempting to import data that maps some fields to standard activities fields and some to the custom fields.

The data mapped to standard activities fields goes through fine, but if I try to add a custom field I get "Invalid value for field(s) : field ID;"

If I try all five custom fields I get "Invalid value for field(s) : field ID; ; field ID; ; field ID; ; field ID; ;field ID;"

The custom fields are of various formats, date, text, select - and I am sure the data is not actually invalid for any of them..

Has anybody else had problems inporting to custom fields in Activities??
« Last Edit: July 19, 2011, 08:07:05 am by Gary Palmer »

Gary Palmer

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.0.3
  • CMS version: Drupal 7.2
  • MySQL version: 5.1.52
  • PHP version: 5.2.16
Re: Invalid value for field(s) error attempting to import Activities custom fields
July 19, 2011, 07:52:30 am
This is looking like a bug to me.

We did a large migration from our legacy system to Activities, both standard and custom fields, early in the year. We would have been somewhere around version 3.3.3 to 3.3.5 at that point.

 Taking one of the same files through the same mapping now is just getting Invalid value errors for all the custom fields.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Invalid value for field(s) error attempting to import Activities custom fields
July 19, 2011, 01:09:18 pm

probably is a bug :( to double check, can you try to do a simple import on the demo server with activities

also would be great if you / your org can investigate and provide a patch that fixes the issue

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Invalid value for field(s) error attempting to import Activities custom fields
November 09, 2011, 11:50:35 am
Hi Gary,

I just came across this same bug, and submitted a bug report three days ago: issues.civicrm.org/jira/browse/CRM-9151

Just heard this morning that the bug is now patched, so the next release should contain the fix.  Hope this helps you!

Jon
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Invalid value for field(s) error attempting to import Activities custom fields
February 23, 2012, 09:41:06 pm
Excellent - thanks for reporting - and for the fix - tried it on 4.0.7 and it solved the problem.
http://issues.civicrm.org/jira/browse/CRM-9151
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Invalid value for field(s) error attempting to import Activities custom fields

This forum was archived on 2017-11-26.