[abba77]

Hi,

I have over 700 movies listed in an excel file over the last few years. I would like to catalog these within XBMC by creating a dummy file with the movie name, year and extension of avi or mkv.

Instead of creating them or typing them all out, anyone know of a tool that will automate the task from an excel, text, or csv file?

thanks

[blittan]

- vbscript in excel ?

or save it as a textfile and make a dosbatch from it..

[havix]

Perfect reason to learn powershell. Save as a csv and then off the top of my head the command would be something like
import-csv C:\movies.csv | foreach-object{new-item -path c:\movies -name $_}

[abba77]

will try powershell.

i actually, with a friend of mine created a small app in visual studio that does it for me. he took just a few mins. there is no error handling as such, but hard to mess up.