Feeds is (are?) a handy module for importing great tracks of table information. It likes CSV (Comma Separated Values) and it is very, very, very picky about how those values are prepared. Turns out, there are a ton of different kinds of variable width encoding format versions of UTF8. Turns out, Feeds doesn’t like any of the kinds that Excel (on a Mac) kicks out. Turns out that you get little square indentations on your forehead when you beat your face against a keyboard. I downloaded Text Wrangler to, um, wrangle (which I think means to argue with?) Anyway, I argued with it good. I got it to work after a long battle which I will post the details when I can get it to work again. At some point I was given PHPMyAdmin to use and it helps a little bit, but that is a whole ‘nother learning curve.
as Bugs bunny would say “Oh the irony, the Eye Roe Knee!” But here I am, documenting what I’ve been up to. My job so far has been to download modules to extend usability and to understand how those modules stack on top of each other. Many times you will find that you download and install a module and then find that you need to have another module installed for everything to go. I needed Scheduler to run Feeds.
My challenge is to figure out the best way to store information about a digitized video file. I’d like to attach all the fields from an extant Access database. The information is a bit hierarchical in that there are series programs that have numerous episodes as well as single programs. I need to store information about both kinds in a searchable way. Since I’m dealing with (potentially) hundreds of files with 10 fields apiece, I’d like to automate it…somehow.