Hi,
I tried almost all comments and issues... for feeds (latest version).
My csv comes from a mac but I tried also all the ini-sets from the comments, (meaning in my settings & in the .inc file) to recognize the line-endings. So I tried also with one line. Nothing helps. The message "Could not retrieve title from feed" keeps popping up and even giving a title and starting a feed import from there leaves the fields empty... I tried both possibilties, a given path and an upload for the csv.
Strange situation, I don't seem to find what's wrong. I also tried to save the xls to standard-csv, to csv(windows), to csv(dos)... giving quotes in an editor, checking utf-8, ... All target-fields are standard and source fields are matching.
Maybe it is something trivial but I don't find it.
I asked myself if has something to do with language settings, but the mapping indicates to the correct column in the csv and the target is also correct (pops up automatic in the correct language in the selection). The node is set to language neutral but still no result.
Does anybody has the same issue?

With friendly regards, Johan

Comments

johan2’s picture

johan2 CreditAttribution: johan2 commented

Hi,
I found out that the permissions of the csv file were 664 and in this case the import doesn't work.
Changing it to 777 makes it working.
Further existing nodes, that are already in the database, are not updated or replaced.
Is there a setting for this? I have made the title in the mapping a unique target as GUID, and this title is also a source with target "title".
Maybe this is wrong?

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Status: Active » Fixed

There is a setting for replacing/updating existing nodes @ admin/build/feeds/edit/[feed name]/settings/FeedsNodeProcessor. Look for the setting Update existing nodes. Though it seems like you've solved the original problem on this ticket so I'm marking this as fixed.

vip_sa’s picture

vip_sa CreditAttribution: vip_sa commented

I get the same error. I am on a windows machine on the localhost. I added the first node's title and it imported all the nodes but it gave me an error that said it could retrieve the title so I was left with a whole bunch of records without titles. Shouldn't Drupal prevent the import if it cannot get the title? Any case how do I fix this please?

vip_sa’s picture

vip_sa CreditAttribution: vip_sa commented
Status: Fixed » Active
vip_sa’s picture

vip_sa CreditAttribution: vip_sa commented
Priority: Normal » Critical
Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Status: Active » Postponed (maintainer needs more info)

@vip_sa do you find that the issue is fixed if you correct the permissions as johan2 did?

vip_sa’s picture

vip_sa CreditAttribution: vip_sa commented

Like I said I am on a windows machine and so all I am doing is uploading the file and clicking save. It then imports all the records that is in the csv file but it leaves out the title. I don't quite understand how I should give the file permissions in a Windows environment before I upload the file. Please help

uwe_a’s picture

uwe_a CreditAttribution: uwe_a commented

Im having the same problem, im using feeds_xpathparser

im fetching the file via http

mattlo’s picture

mattlo CreditAttribution: mattlo commented

I'm having the same exact issue as the people above. I'm wanting to import a CSV file into a custom content type.

When I attempt to import the CSV file, I go to /import, then it sends me off to /node/add/statlocalareas (statlocalareas = my custom content type)

I have changed the file permissions to 777 for the CSV file, as recommended, but this hasn't made a difference.

Any more ideas?

Cheers

Matt

mattlo’s picture

mattlo CreditAttribution: mattlo commented

I have worked out why I was getting the ""Could not retrieve title from feed"" error upon attempting to import CSV data into nodes. THis may be useful for some.

In the basic settings page when you go to edit the feed importer, you will need to ensure the importer is not set to any particular content type. Select "use standalone form".

Also, if you are attempting to use CSV files saved from Excel on Mac, it is unlikely they will compatible with the feed reader by default. Use windows machine or try windows formatted CSV in Excel etc.

Matt

sydneyshan’s picture

sydneyshan CreditAttribution: sydneyshan commented

#10 fixed my issue - thanks!!!

francis55’s picture

francis55 CreditAttribution: francis55 commented

Yes, I had the same error message, and setting the "Attached to content type" in Basic settings to "Use standalone form" solved the problem.

A message for the designers of this very useful module: offering a list of content types at this "Basic" level is somewhat confusing because you automatically believe you are choosing the output type of the feed - which is the selection you expect to have to make. Actually this happens in Processor - Node processor - settings, which is much lower down in the interface.

Dave Reid’s picture

Dave Reid
he/him
Primary language English
Location Nebraska USA
CreditAttribution: Dave Reid commented
Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Fixed

Please file an issue with a patch to improve the UI description or help!

Marking as fixed as per #10.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

handsolo’s picture

handsolo CreditAttribution: handsolo commented

I am using standalone and have set import to replace current nodes.

My permissions are 777

When i import it says 6 nodes created but there is no actual content created. I am using tab delimited .txt.

If i use comma separated .csv then the nodes get created but the actual content is not there (the data in fields).

I am using excel on a windows 7 to create the feeds.

any idea what i could be doing wrong?

di_p’s picture

di_p CreditAttribution: di_p commented

Thank you, Thank you #10. It fixed the problem :)

ChrisValentine’s picture

ChrisValentine CreditAttribution: ChrisValentine commented
Issue summary: View changes

Well said francis55 in #12 - the option to pick your target content type in the first stage of the importer definition is extremely misleading - and the on-screen text If "Use standalone form" is selected a source is imported by using a form under http://your.domain/reporting/?q=import. If a content type is selected a source is imported by creating a node of that content type is even more misleading. Why have this feature at all?

erin814’s picture

erin814 CreditAttribution: erin814 commented

I would just like to agree with francis55 and ChrisValentine. I had the same confusion on my initial setup and this thread has helped clarify things for me.

breaktheissue’s picture

breaktheissue CreditAttribution: breaktheissue commented

I have the same issue. No matter how you map fields it is going to give you error
when you do this
In the basic settings page when you go to edit the feed importer, you will need to ensure the importer is not set to any particular content type. Select "use standalone form".

It will import with out error.

#10 fixed my issue - thanks!!!