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) »
  • Data not displaying after import
Pages: [1]

Author Topic: Data not displaying after import  (Read 1130 times)

anothername

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 3
  • CiviCRM version: CiviCRM 4.2.6
  • CMS version: Drupal 7.19
  • MySQL version: 5.1.66-0+squeeze1-log
  • PHP version: 5.3.3-7+squeeze14
Data not displaying after import
April 02, 2012, 12:23:46 pm
I am having an interesting problem. I imported a set of populated fields custom fields and standard fields. The standard fields were displayed in the database but the custom fields were not. However, when I exported the data the fields had data in them. So it appears that the data was successfully loaded into the database but Civi is not displaying it.

Anyone had this problem or have any idea on what a solution would be?

Thank!!

anothername

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 3
  • CiviCRM version: CiviCRM 4.2.6
  • CMS version: Drupal 7.19
  • MySQL version: 5.1.66-0+squeeze1-log
  • PHP version: 5.3.3-7+squeeze14
Re: Data not displaying after import
April 03, 2012, 09:16:57 am
Another detail to add. Using bulk update via profile or a standard profile does work. The problem only seems to occur with import.

anothername

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 3
  • CiviCRM version: CiviCRM 4.2.6
  • CMS version: Drupal 7.19
  • MySQL version: 5.1.66-0+squeeze1-log
  • PHP version: 5.3.3-7+squeeze14
Re: Data not displaying after import
April 03, 2012, 09:43:45 am
And one other detail! Importing data into these same custom fields was successful prior to a Civi 4.1.1 upgrade.

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: Data not displaying after import
April 07, 2012, 11:00:54 pm
If I had to make an educated guess, I would guess that this is a contact subtype issue.  Are you using contact subtypes?  If so, what contact subtype is your custom field groups set up to work with?
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

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: Data not displaying after import
April 07, 2012, 11:02:41 pm
Also, have you seen this thread?  It outlines another possibility (that you're using read-only fields): http://forum.civicrm.org/index.php/topic,23363.0.html
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

anothername

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 3
  • CiviCRM version: CiviCRM 4.2.6
  • CMS version: Drupal 7.19
  • MySQL version: 5.1.66-0+squeeze1-log
  • PHP version: 5.3.3-7+squeeze14
Re: Data not displaying after import
April 09, 2012, 07:13:17 am
The contact subtype is the standard organisations and the view only box is not checked in the custom data field. I read that other thread too, my problem looks distinct from that one...

anothername

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 3
  • CiviCRM version: CiviCRM 4.2.6
  • CMS version: Drupal 7.19
  • MySQL version: 5.1.66-0+squeeze1-log
  • PHP version: 5.3.3-7+squeeze14
Re: Data not displaying after import
April 10, 2012, 11:15:18 am
Problem solved.

The data in the .cvs did not match the "Values" of the custom fields because of spacing and capitalisation. However, the data was close enough that in synced with the database. I guess because the spelling matched the value. This is why when exported the data appeared and also why when searching the Civi for those fields resulted in contacts with the data but it was not displayed.

So the lesson is, make sure that the Values match the spreadsheet. Especially the data can be successfully imported in the database but know show up in the GUI.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Data not displaying after import

This forum was archived on 2017-11-26.