Create dummy blank files from excel list
#1
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
Reply
#2
- vbscript in excel ?

or save it as a textfile and make a dosbatch from it..
Reply
#3
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 $_}
Reply
#4
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.
Reply

Logout Mark Read Team Forum Stats Members Help
Create dummy blank files from excel list0