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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.5 Release Testing »
  • Records do not update using update or fill
Pages: [1]

Author Topic: Records do not update using update or fill  (Read 398 times)

jodee

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5beta9
  • CMS version: joomla3.3
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Records do not update using update or fill
September 08, 2014, 05:26:19 am
Hi there

I am having to delete all my contacts records and import them as new because the import update doesnt work. I originally only updated from 446 to 45 because the yes/no wouldn't work but now i cant simply import those fields to update the records. The first columns in my data file are first name, last name and email address but no changes occur.

Thanks Jodee

jodee

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5beta9
  • CMS version: joomla3.3
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
[FIXED - workround] Records do not update using update or fill
September 08, 2014, 05:59:22 am
I have done lots of googling and it appears that whilst initial import allows for both standard and custom fields to be imported in one go, if you need to update you have to split your file into two imports - one for standard fields and the second for custom fields (with first name last name and email for identification). This is incredibly labour intensive.

At least Ive found a work round though so I can carry on ;)

cheers jodee

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Records do not update using update or fill
September 09, 2014, 02:42:51 am
Hey there,

Not sure how old your install is but
Quote
delete all my contacts records and import them as new
should be a last resort since if those contacts have other related objects like events, memberships, relationships, etc, you would have to import those as well.
Quote
import update doesnt work
might be an idea to expand on this a little so that people can suggest other approaches.
Quote
whilst initial import allows for both standard and custom fields to be imported in one go, if you need to update you have to split your file into two imports - one for standard fields and the second for custom fields (with first name last name and email for identification).
This wasn't the case last time I used the import functionality. What kind of custom fields are they? You might want to consider following these instructions for this issue: http://civicrm.org/bug-reporting
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.5 Release Testing »
  • Records do not update using update or fill

This forum was archived on 2017-11-26.