Feeds is a lovely utility that has blossomed greatly in Drupal 7. As with Drupal 6 both Feeds and Feeds Tamper are Features compatible and now even more versatile with add-ons like Feeds SQL. There are a several caveats to getting Feeds happy when working with CSV formats. I’m coming from a Mac environment, often mapping excel spreadsheets over in to Drupal. These are my ongoing notes, am doing a lot in Feeds and will keep this post as a list of my remarkably consistent failures. (NB: if you’re in D6 Node Import just seems way more forgiving on all these points, just not nearly as “Drupal Hep”)
Remember to get your csv UTF-8 compatible – I like Text Wrangler for this – especially when coming from Micro$oft Excel your content may have some odd-ball encoding. So if saving as Windows, Unix, or MS-Dos CSV fails on you just open up your CSV file in there and resave
Caveats: Another common quandary with Feeds is using it with fields outside of core CCK or Entities. While it’ll map to CCK Select Other it has a tough time, especially with multiple values. Even with the values put in the drop-down selection area it always mapped to “Other” and then stuck in the value.
Unlike in Drupal 6 this field will throw errors if indexed, doesn’t seem to work with the Facet API, or be good for much of nothin’. Perhaps Select Or will work better, however it seems to have view limitations too. So while none of this reflects on Feeds it’s worth noting because you may end up needing some UI tidbits… it may map to them, but it’s