I am trying to import a VERY large RSS feed (science publications) and when I try to import all, I get an error "String data, right truncated: 1406 Data too long for column 'title' at row 1".

This error is eliminated if I limit my import and thus chunk up the RSS. Would it be possible to get the Feeds module to loop through the RSS-feed in steps, so that the error is eliminated?

Svend

Comments

STNyborg’s picture

STNyborg commented

Could it be that some of my records (scientific publications with VERY long titles) conflict in length with a 255 character limit. If this is the case, what can I do to overcome this issue? I am not interested in cutting down on the titles.

Svend

twistor’s picture

twistor commented

Indeed. It sounds like you're hitting the 255 character limit for a node title. That's set by node.module, so there's not much we can do about it.

As for a workaround, you could add a separate field that is larger than the title and map to that.

STNyborg’s picture

STNyborg commented
Status: Active » Closed (fixed)

Great simple solution. Did not think of that.

Svend

littledynamo’s picture

littledynamo commented

I had the same issue, my publication titles are too large for the node title field meaning that they fail to import. I used feeds tamper to truncate the title field to 255 chars. This, coupled with the advice from twistor above has proved to be a decent solution.