Results 1 to 5 of 5

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

  1. #1
    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

  2. #2
    Join Date
    May 2009
    Posts
    529

    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.

  3. #3
    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

  4. #4
    Join Date
    May 2008
    Posts
    4,088

    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".

  5. #5
    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.

Similar Threads

  1. make file name list in excel using batch file
    By shibinpanayi in forum Windows Software
    Replies: 1
    Last Post: 04-06-2011, 03:44 AM
  2. Replies: 1
    Last Post: 19-03-2011, 01:28 AM
  3. Export file names to excel
    By PRIYAPEARL in forum Windows Software
    Replies: 2
    Last Post: 12-06-2009, 08:07 AM
  4. Batch extraction in 1 Excel file
    By Pikachoo in forum Software Development
    Replies: 5
    Last Post: 27-02-2009, 01:00 PM
  5. Batch file to list directories, export to CSV
    By chickenfriedsteak in forum Windows Server Help
    Replies: 1
    Last Post: 16-02-2009, 07:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •