run Batch-file export in excel (its for a Movie database)

[rayg]

Hi

I would like a Batch file that read the folders and files and Export in *.TXT or *.Excel
I have my movies arranged, each movie has its own folder.

Like this:

>Movies
>>The Boondock Saints (1999)
>>>the.boondock.saints.avi
>>>Seen.txt

>>The Matrix (1999)
>>>matrix.MKV
>>>unseen.txt

>>Troy
>>>troy.WMV
>>>

The Batch file should do the following:

-After i run the Batch file it export a TXT or Excel,
-If the batch does not read any of TXT like the one in TROY. It display Unknown

-a Filter should display All unseen first then, Second Unknown, third SEEN
-a Filter should display Unseen, unKnown, Seen in different colors LOL
-a Filter should display the Title from A-Z and Number first for example: 1234Abcd-z

-The batch file need to count all Folders in Movies

-Export TXT or excel in C:\

THe content of the TXT/ Excel looks
Like this:

Unseen The Matrix
Unknown Troy
Seen Bad boys
Seen The Boondock Saints (1999)
Seen Titanic

Total movies 5

- Is this possible ?
- If I Run an batch file daily is that bad for the computer?
- Does batch files also work in Windows 7. I still got XP Later upgrade to Windows 7

Thank you alll
Ray

[Author]

For this purpose you can use Batch File Maker. This is a nice tool to create batch files as per your need. Sometime this software is slow and consumes times but it is very effective. It is possible to create your own batch file via simple processor. Later on you can then modify the same batch file for more improvement. It also supports a listing function that will help you more in working with the file.

[rayg]

Thank you for replying .

I will check out a Batch File Maker.

If someone know a script that can do the trick, plz do not hesitate
Plz leave it behind

[Solomon]

In your batch file you just have to call the specific file ie.

call results.xls

You write bat files in notepad or any other PlainText editor and then save with the extention ".bat".

[rayg]

Yes, I am aware where i can make a batchfile, which is in notepad.
And save extension as .BAT.


The problem is I dont know the Batch language well enough to right myself.

If some one can help me please .

This is my script for now:

-------------------------------------------

@echo off


echo Hello this is a test batch file


@echo off
find "seen"*.txt> results.txt
if %errorlevel%==0 (
echo Found! logged files into results.txt
) else (
echo No matches found
)


pause

-------------------------------------
BTW not working