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) »
  • [SOLVED] Importing from .csv broken "A non-recoverable error has occurred."
Pages: [1]

Author Topic: [SOLVED] Importing from .csv broken "A non-recoverable error has occurred."  (Read 2182 times)

artfulrobot.com

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 4
[SOLVED] Importing from .csv broken "A non-recoverable error has occurred."
October 07, 2010, 12:12:19 pm
I have a small .csv file (14 records + header) that won't import.

Import contacts -> select CSV, includes headers, ORganisations type, skip dupes, use field mapping -> confirm fields are correct -> ask it to create new group for imported contacts -> import.

I then get the white pop-up and Importing Contacts... then it jumps to a crash page saying:

Sorry. A non-recoverable error has occurred.
is not of type String

I don't think there's anything odd about the file.

Anyone else found this behaviour? [and a way to fix?!]

Thanks.
rich
« Last Edit: October 19, 2010, 07:11:17 am by artfulrobot.com »

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: Importing from .csv broken "A non-recoverable error has occurred."
October 07, 2010, 11:40:14 pm
i would check your data if it is pointing to 'string' - alternatively, i find that any csv that i have saved, closed and reopened (in NeoOffice) tends to fail, so i always ensure i use an 'unopened' csv

you may also want to do an export of a sample set of data and check you have the data correct, but that would usually spew a different error msg.

good luck
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

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Importing from .csv broken "A non-recoverable error has occurred."
October 08, 2010, 12:14:43 am
Also, if it is 14 records, don't spend too long on it..........typing in the UI is an alternative for that size of .csv  ;D
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

artfulrobot.com

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 4
Re: Importing from .csv broken "A non-recoverable error has occurred."
October 11, 2010, 03:49:02 am
Thanks, I think I'll try it line by line to see what breaks civicrm. I plan on doing a lot of importing, so I have to find out exactly what's wrong. If I discover anything useful I'll post back because "unrecoverable error" is a bit sub optimal!

thanks guys

adixon

  • I post frequently
  • ***
  • Posts: 314
  • Karma: 19
    • Blackfly Solutions
Re: Importing from .csv broken "A non-recoverable error has occurred."
October 11, 2010, 07:07:10 am
I think your most important and useful tool with importing is to look at the log file it generates - it's no doubt some kind of formatting of the input file that isn't right.

artfulrobot.com

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 4
Re: Importing from .csv broken "A non-recoverable error has occurred."
October 19, 2010, 06:41:21 am
I've checked the .csv file by hand - looks fine.

Hmmm, here's the backtrace

/my_drupal_root/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 254
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/DAO.php, fatal, 941
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/DAO.php, composeQuery, 892
/my_drupal_root/sites/all/modules/civicrm/CRM/Import/Form/Preview.php, singleValueQuery, 215 , formRule,
/my_drupal_root/sites/all/modules/civicrm/packages/HTML/QuickForm.php, call_user_func, 1596
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/Form.php, validate, 293
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/StateMachine.php, validate, 149
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
/my_drupal_root/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/my_drupal_root/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 279
/my_drupal_root/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 219
/my_drupal_root/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 351 , civicrm_invoke,
/my_drupal_root/includes/menu.inc, call_user_func_array, 348
/my_drupal_root/index.php, menu_execute_active_handler, 18

Will update post if I ever get to the bottom of it!

artfulrobot.com

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 4
[BUG?] Re: Importing from .csv broken "A non-recoverable error has occurred."
October 19, 2010, 06:56:32 am
It's the creating a new group that it fails on!

  • I can import without adding to group
  • I can import and include in existing group
  • I cannot import and create new group. For reference, the new group name I was using was "Imported - Wallingford Businesses"

Should I report this on Jira?

artfulrobot.com

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 4
Re: Importing from .csv broken "A non-recoverable error has occurred."
October 19, 2010, 07:10:03 am
It appears (tried it on the demo site) that this bug has been fixed in the latest version.

Yay, thanks, guys.  :)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • [SOLVED] Importing from .csv broken "A non-recoverable error has occurred."

This forum was archived on 2017-11-26.