Closed (fixed)
Project:
Feeds
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
24 Feb 2010 at 09:38 UTC
Updated:
23 May 2012 at 10:39 UTC
Jump to comment: Most recent file
Comments
Comment #1
alex_b commentedThis is a duplicate of #704532: CSV import problems with characters like æ ø å ö ä ü - no?
Comment #2
nchase commentednot completely, 704532 deals with csv not formated in utf-8 ,like they come from Excel. this one is about the title mapping which doesn't work when files are in utf-8 (which I have to use in order to get the characters discussed in 704532) working.
Comment #3
alex_b commentedI see - can you post the file that causes the problem and your PHP version? It doesn't need to be the full file, I can do a portion of it, too. What is important is that you verify that the problem exists with whatever you upload. Generally speaking, I need the best possible instructions to reproduce the problem myself.
Thanks.
Comment #4
nchase commentedthank you. find the file I try to import attached. Whenever I import it everything gots mapped expect the title (in German: titel). The title stays empty. When I upload the same csv encoded with ansi everythings fine. I'm using notepad to change the encoding format.
The export of the feed csv import:
$feeds_importer = new stdClass;
$feeds_importer->disabled = FALSE; /* Edit this to true to make a default feeds_importer disabled initially */
$feeds_importer->api_version = 1;
$feeds_importer->id = 'termin';
$feeds_importer->config = array(
'name' => 'termin',
'description' => 'Importiert Termine via CSV',
'fetcher' => array(
'plugin_key' => 'FeedsFileFetcher',
'config' => array(),
),
'parser' => array(
'plugin_key' => 'FeedsCSVParser',
'config' => array(
'delimiter' => ',',
),
),
'processor' => array(
'plugin_key' => 'FeedsNodeProcessor',
'config' => array(
'content_type' => 'termin',
'update_existing' => 1,
'expire' => '-1',
'mappings' => array(
'0' => array(
'source' => 'Titel',
'target' => 'title',
'unique' => FALSE,
),
'1' => array(
'source' => 'Beschreibung',
'target' => 'field_te_beschreibung',
'unique' => FALSE,
),
'2' => array(
'source' => 'Beginn',
'target' => 'field_datum:start',
'unique' => FALSE,
),
'3' => array(
'source' => 'Ende',
'target' => 'field_datum:end',
'unique' => FALSE,
),
'4' => array(
'source' => 'Ersteller',
'target' => 'taxonomy:2',
'unique' => FALSE,
),
),
),
),
'content_type' => '',
'update' => 0,
'import_period' => '-1',
'expire_period' => 3600,
'import_on_create' => 1,
);
Comment #5
alex_b commentedsnicers - thanks so much for uploading the file. This will be helpful. Unfortunately I am *slammed* with other work right now so I won't be able to look at right away. Of course, there is no need to wait for me. Anybody should be free to jump in and try to find out what exactly is going wrong here.
Comment #6
nchase commentedsolved... notepad outputs in utf-8 with signature instead of the wanted plain uft-8 , so feeds isn't incapable of importing files form Windows Notepad or Excel. Anyway, seems like a big showstopper to me.
Comment #7
summit commentedmay be the feeds_excel module can help? www.drupal.org/project/feeds_excel ?
greetings, Martijn
Comment #8
morelight commentedI think the main issue in both this and http://drupal.org/node/704532 is that there are three ways of saving linebreaks in a UTF-8 file.
Classic Mac (CR)
Unix (LF)
Windows (CRLF)
TextWrangeler (for mac) has the capability of changing the "Line breaks"
I've tried "Windows (CRLF)" and it works, however "Classic Mac (CR)" does not work. Have not tried "Unix (LF)"