moving files one by one according file created time.

[Ram]

Hi,

I have a folder which has many XLS files but I am not sure with the names of file. I would like to move file by file to another folder. This is accordingly to file created time or something like that.

For eg:

I have two folders - Temp and final. I have 50 files in Temp folder. I would like move one file and do some calculation to it and delete the file. The same I have to move the second file do some callculation and delete it. Moving file should be accoridng to file created time. Is this possible?

Oh btw: I am not with the file name that gets stored in temp folder.?

How do i go about doing it? Is there a file to find out file created time and move only XLS file accordingly? Or is there any other way to do this?

It would be great if I get some help!

Awaitng your response!

Thanks!

Edited December 13, 2007 by Ram

[smashly]

Hi,

Functions you maybe should look at to accomplish your task, all can be found in AutoIt help file.

_FileListToArray() (Found in the User Defined Function Section under File Management)

FileGetTime() (Found in Function Reference Section under File, Directory and Disk Management)

StringTrimRight() (Found in Function Reference Section under String Management)

FileMove() (Found in the User Defined Function Section under File Management)

Cheers

[Ram]

Hi,

Functions you maybe should look at to accomplish your task, all can be found in AutoIt help file.

_FileListToArray() (Found in the User Defined Function Section under File Management)

FileGetTime() (Found in Function Reference Section under File, Directory and Disk Management)

StringTrimRight() (Found in Function Reference Section under String Management)

FileMove() (Found in the User Defined Function Section under File Management)

Cheers

Thanks a lot Smashly...for giving me ideas... Now i have till here and I am sure i am doing something wrong:

#Include <File.au3>
#Include <Array.au3>

While 1

If FileExists("D:\a") Then
$FileList=_FileListToArray("D:\Temp")
$a = "D:\Temp\" & $FileList[1]
FileMove($a, "D:\Final\")

Else
    MsgBox (0,"","No Files\Folders Found.")
                Sleep (1000)

EndIf
WEnd

I thought this will give me message "No files found found" if the file doesn't exist instead it keeps giving me an error:

D:\test.au3 (10) : ==> Subscript used with non-Array variable.:

$a = "D:\a\" & $FileList[1]

$a = "D:\a\" & $FileList^ ERROR

Why would it need to go in to the array first case because the folder is empty? Any help will be appreciated!

Thanks!

Edited December 13, 2007 by Ram

[smashly]

Hi again, try this..

#Include <File.au3>

$Source = "D:\Temp"
$Destination = "D:\Final"

If FileExists($Source) Then
    $FileList = _FileListToArray($Source, "*.xls", 1) ;*.xls files only added to array
    If Not @error Then
        For $i = 1 To $FileList[0]
            FileMove($Source & "\" & $FileList[$i], $Destination & "\" & $FileList[$i], 8)
        Next
    Else
        MsgBox (0,"Error: " & @error, "Look at _FileListToArray() function in AutoIt help file to find what this error means.")
    EndIf
EndIf

Cheers

[Ram]

Hi again, try this..

#Include <File.au3>

$Source = "D:\Temp"
$Destination = "D:\Final"

If FileExists($Source) Then
    $FileList = _FileListToArray($Source, "*.xls", 1) ;*.xls files only added to array
    If Not @error Then
        For $i = 1 To $FileList[0]
            FileMove($Source & "\" & $FileList[$i], $Destination & "\" & $FileList[$i], 8)
        Next
    Else
        MsgBox (0,"Error: " & @error, "Look at _FileListToArray() function in AutoIt help file to find what this error means.")
    EndIf
EndIf

Cheers

Wow.. Thanks a lot. It worked. I didn't some alternation so that it keep checking for files all the times..~~

Thanks again!