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) »
  • Import issues- unfathomable to mortals
Pages: [1]

Author Topic: Import issues- unfathomable to mortals  (Read 1648 times)

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Import issues- unfathomable to mortals
February 10, 2012, 01:44:42 pm
Have spent whole day on Civi Imports.
Joomla 1.7 , CiviCRM 4.08/4.1beta3

Every time I import custom fileds to an Org subtype of school it fails on the same record in a small test set.
I even singled out the record for a one line import and went thru the variations of mapping and 'do-not-import' routines looking for the bad data. There simply isnt any.Well ....

Headers CSV
"School","School Type","Borough","Caterer"
Fields/Cols
"Belleville Primary School","Primary","Wandsworth","Unknown"

IMportcConsistently rejects custom field for Borough with value of  "Wandsworth". If I replace the borough with a different value eg "Ealing" the import runs fine.

So what is going on here?

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: Import issues- unfathomable to mortals
February 10, 2012, 03:40:59 pm

is Wandsworth the only problematic county or are they others? I would narrow it down 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

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Re: Import issues- unfathomable to mortals
February 11, 2012, 01:12:06 am
With one record/row and a change in one value, and an examination of the CSV file can it get much narrower? ie change just one variable in the equation...

I just tried an update import with only one column of custom fields [as opposed to three, with two as 'do-not-import-'] which sailed thru but didn't update......

I am using OO [Open Office]  to make my csv exports and found differences on other projects with Excel exports but looking at the csv in a text editor I cant see the import file as the problem :P

I am lucky there are only a handful of records not thousands so might just add by hand if need be

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import issues- unfathomable to mortals
February 11, 2012, 03:16:00 am
Hi,

Do agree that import might be somewhat stubborn indeed.

Just to be sure, did you check if Wandsworth is one of the counties indeed (in civi)?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Re: Import issues- unfathomable to mortals
February 13, 2012, 11:38:10 am
Thanks - it doesnt appear to be in the db apart from the cache table.
If importing to a custom field list does the value have to be in the system already for successful import?

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: Import issues- unfathomable to mortals
February 13, 2012, 11:55:35 am
Can you clarify - are you trying to import in to a Custom Field - or the default civicrm County field?

Your first post referred to 'custom' and 'borough' so I assumed you were importing to a field you created. Correct?
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

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Re: Import issues- unfathomable to mortals
February 13, 2012, 12:45:46 pm
Yes. Custom field is regional boroughs of London.
They exist an an option list [select type] but just wouldn't import certain records, namely the borough of 'Wandsworth'

I notice that Wandsworth s not in the option list due to error on creation of said list. Could this be the issue?

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: Import issues- unfathomable to mortals
February 13, 2012, 12:57:55 pm
Absolutely - if you don't have the Option there then it won't be able to show the data even if you managed to import it i expect
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

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import issues- unfathomable to mortals
February 13, 2012, 02:27:17 pm
Yeap, import doesn't automatically fill the option lists if the item is missing. Thankfully.

We had to import from ACT! recently that didn't do that, and they were 30 different "us, us.a, u.s.a,united states, united states of amerika...", wasn't fun to put back on shape

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import issues- unfathomable to mortals

This forum was archived on 2017-11-26.