I like to PRINT a portion (or all of it sometimes) of the History file. Until recently, I have been copying it to the clipboard, and dropping it in an Excel 2010 spreadsheet. Once there, I could parse the cells, sort it the way I wanted, add or remove columns & rows and print it out the way I like it done. But it has stopped working. I can no longer get the clipboard data to properly import & format into Excel. I can’t seem to figure out what is wrong. It used to be so simple.
Does anyone have a method for this that is currently working? Or another way to retrieve and work with the History Data? I am currently on v2.4.7 about to go to v2.4.8.
Hi Goose! Thanks for helping. As I said in my post, “… I could parse the cells, sort it the way I wanted, add or remove columns & rows and print it out the way I like it done.”. When it was working right, I literally just “Pasted” it into Excel and Excel would match the data column for column, row for row. NOW, when I try to paste it in, it just dumps everything into 2 or 3 columns, starting with column “D”. It used to be so clean, now it is a mess and impossible to work with the data. I especially like to PARSE the data in the cells. I don’t need to see “\Server3\Videos\Duped\Recorded TV\MP4” in front of every recording 3000 times, you know? So I either parse it or split the cells up into smaller cells using Excel’s “Text to Columns” feature and just print what I want to see. I would only print the entire History if i wanted a complete updated Catalog of all my recordings. Otherwise, I might just print the last 2 weeks or so. Excel also gives you the ability to run multi-level sorts, like maybe Title/Season/Episode etc.
Hi Goose, sorry for the delay. I was away all day yesterday with no PC access.
That is EXACTLY how I have always done it! But for some unknown reason, it’s just not formatting correctly anymore.
I will try it one more time - this time with a NEW sheet - instead of populating erased data in my old sheet. Maybe that has something to do with it. I was just trying to avoid having to re-do all my formatting and the parsing formulas.