HI, got a small csv file encoded in utf-8 like this:

Titel;Ersteller;Beschreibung;Beginn;Ende
Somit;hl;Sörensen;20.02.2010 08:00;24.02.2010 09:00;

In UTF-8 the title doesn't get mapped. It is blank in the created note, everything else is mapped. When I switch encoding to ansi using notepad the title gots mapped but spcial characters like öäü don't show up.

CommentFileSizeAuthor
#4 results_link_termin-utf.txt104 bytesnchase

Comments

alex_b’s picture

Status: Active » Closed (duplicate)
nchase’s picture

not 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.

alex_b’s picture

Title: CSV Title mapping doesn't work when encoded in uft-8 » CSV Title mapping doesn't work when encoded in utf-8
Status: Closed (duplicate) » Active

I 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.

nchase’s picture

StatusFileSize
new104 bytes

thank 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,
);

alex_b’s picture

snicers - 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.

nchase’s picture

Status: Active » Closed (fixed)

solved... 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.

summit’s picture

may be the feeds_excel module can help? www.drupal.org/project/feeds_excel ?
greetings, Martijn

morelight’s picture

I 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)"