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) »
  • External Identifier - too short
Pages: [1]

Author Topic: External Identifier - too short  (Read 556 times)

frank

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.35
  • PHP version: 5.4.24
External Identifier - too short
March 24, 2014, 06:31:24 pm
Dear All,
I have imported my contacts into CiviCRM with an external identifier from SugarCRM. Since the external ID was too long (36 characters), I increase the length of the external_identifier in the database to 64 characters. The import worked great, but now I have the problem, whenever I want to edit the contacts and save the changes, CiviCRM tells me: "External ID: Please enter no more than 32 characters."
How can I solve that problem?
Best,
Frank

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: External Identifier - too short
March 24, 2014, 11:11:51 pm
I would suggest you to stop changing the structure of the database by hand and create a custom field "sugarID" with the proper length.

Have you developed custom scripts to ease the migration or did you do a regular import?
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

frank

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.35
  • PHP version: 5.4.24
Re: External Identifier - too short
March 25, 2014, 01:25:03 am
I did a regular import. Is there an easy way to enlarge the external id field.

frank

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.26
  • MySQL version: 5.5.35
  • PHP version: 5.4.24
Re: External Identifier - too short
March 25, 2014, 07:51:53 am
Is there an easy way to transfer the data from external ID field to the custom field SugarID?

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: External Identifier - too short
March 25, 2014, 08:13:41 am
two options:

1. decrease the length of your sugar's external id field

2. u'll need to modify the civicrm contact form (maybe via the buildform hook and overwrite the external id field and rules) and extend the length of the field

3.for your last question, u can potentially do it via a sql query and populate the custom field that way

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • External Identifier - too short

This forum was archived on 2017-11-26.