+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+--- Thread: Create dummy blank files from excel list (/showthread.php?tid=56945)
Create dummy blank files from excel list - abba77 - 2009-08-26
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
- vbscript in excel ?
or save it as a textfile and make a dosbatch from it..
- havix - 2009-08-27
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
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.