Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-12-2010
Member
 
Join Date: Dec 2010
Posts: 3
question run Batch-file export in excel (its for a Movie database)
  

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

Reply With Quote
  #2  
Old 22-12-2010
Member
 
Join Date: May 2009
Posts: 523
Re: run Batch-file export in excel (its for a Movie database)

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.
Reply With Quote
  #3  
Old 22-12-2010
Member
 
Join Date: Dec 2010
Posts: 3
Re: run Batch-file export in excel (its for a Movie database)

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
Reply With Quote
  #4  
Old 22-12-2010
Member
 
Join Date: May 2008
Posts: 4,085
Re: run Batch-file export in excel (its for a Movie database)

In your batch file you just have to call the specific file ie.
Code:
call results.xls
You write bat files in notepad or any other PlainText editor and then save with the extention ".bat".
Reply With Quote
  #5  
Old 22-12-2010
Member
 
Join Date: Dec 2010
Posts: 3
Re: run Batch-file export in excel (its for a Movie database)

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

Last edited by rayg : 22-12-2010 at 07:40 PM.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "run Batch-file export in excel (its for a Movie database)"
Thread Thread Starter Forum Replies Last Post
make file name list in excel using batch file shibinpanayi Windows Software 1 04-06-2011 03:44 AM
code for using a batch file to parse html (.htm) files and export values in .csv format jamesnovello Software Development 1 19-03-2011 01:28 AM
Export file names to excel PRIYAPEARL Windows Software 2 12-06-2009 08:07 AM
Batch extraction in 1 Excel file Pikachoo Software Development 5 27-02-2009 01:00 PM
Batch file to list directories, export to CSV chickenfriedsteak Windows Server Help 1 16-02-2009 07:35 PM


All times are GMT +5.5. The time now is 12:56 PM.