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) »
  • CSV Files will not import at all
Pages: 1 [2]

Author Topic: CSV Files will not import at all  (Read 5439 times)

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CSV Files will not import at all
October 25, 2010, 03:34:41 am
Jeremy,

Quote from: xevioso on October 22, 2010, 09:15:22 am
elementValue
[...]

Ok, that looks right - I was hoping there is some problem with file reading, but that's not the case.

Quote from: xevioso on October 22, 2010, 09:15:22 am
Now, the website is www.bluestarpr.com, and I did have to make a change to the domain name for the base url from just bluestarpr.com to www.bluestarpr.com, but I did not change this for the base directory.

Our wesbite root is at www.bluestarpr.com/site, but we have the domain redirecting to that directory so hat it looks like it would be www.bluestarpr.com and not bluestarpr.com/site.  Not sure if this makes a difference.  But our base directory path is listed as /var/www/vhosts/bluestarpr.com/httpdocs/site/media/

Don't see potential problem here (although might be missing something).

Quote from: xevioso on October 22, 2010, 09:15:22 am
Also, for the Legacy Encoding, yes, I meant it was set by default to Windows-1252 and I have changed it to UTF8 when I export; I was referring to the delimiter field, which was set at a comma but which I have tried changing back and forth to a semi-colon to test.

Legacy encoding is used on import, so setting it on export will not have any influence. One more thing to try is to leave legacy encoding field blank and try import, however it should assume uft-8, so the same as the value you say this option has.

In general, I'm running out of ideas on what might be wrong. I think the best course of action for you is to hire somebody on Professional Services to do a quick assist for you, take a look at your install from inside and figure out the problem. I'm pretty sure it's not something very complicated, it just needs to be looked at from inside. Also, please let is know what was the problem when you solve it, so we can potentially improve error reporting if feasible, to avoid such cases in the future.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: CSV Files will not import at all
November 24, 2010, 01:22:50 pm
The main problem appeared to be with the regex being used by civi to determine validity.

I've attached a patch to CRM-7131 but since it requires mbstring I figured I'd post to see if people think that's a problem. The standard drupal install tells you about it if you don't have it enabled, and I think it's pretty common to have it available.

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CSV Files will not import at all
November 29, 2010, 07:46:15 am
I've applied the patch conditionally - if extension is available, it's used, otherwise old ways of doing things is performed.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

Ozlem

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: CiviCRM 3.3
  • CMS version: Joomla
  • MySQL version: ?
  • PHP version: PHP 5
Re: CSV Files will not import at all
February 24, 2011, 05:58:46 am
Quote from: demeritcowboy on November 24, 2010, 01:22:50 pm
The main problem appeared to be with the regex being used by civi to determine validity.

I've attached a patch to CRM-7131 but since it requires mbstring I figured I'd post to see if people think that's a problem. The standard drupal install tells you about it if you don't have it enabled, and I think it's pretty common to have it available.

Dear demeritcowboy,

I have exactly the same problem. My CiviCRM won't import at all. I've tried everything but no solution. It seems you have solved it. Can you please explain more in detail how you did it? How to attach a patch to CRM-7131?

Thanks a lot.

Özlem.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: CSV Files will not import at all
February 24, 2011, 06:11:46 am
A modified version of the patch is included in 3.3 already, so your problem must be something else if you are using 3.3.

Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • CSV Files will not import at all

This forum was archived on 2017-11-26.