Create dummy blank files from excel list

abba77 · 2009-08-26 18:25

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** · 2009-08-26 20:48

- vbscript in excel ?

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

havix · 2009-08-27 02:21

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 · 2009-08-27 05:20

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.

abba77 Senior Member Posts: 104 Joined: Mar 2009 Reputation: 0	2009-08-26 18:25 Post: #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
	find quote

havix Junior Member Posts: 30 Joined: Sep 2008 Reputation: 0	2009-08-27 02:21 Post: #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 $_}
	find quote

abba77 Senior Member Posts: 104 Joined: Mar 2009 Reputation: 0	2009-08-27 05:20 Post: #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.
	find quote