Rename Folders/Subfolders/Files and other doubt

I'd do what Jared said because I just set up an environment with the exact same directory structure and file name, copy and pasted your script, and ran it and it does exactly what it's supposed to do.



I'm at a loss at this point.  The only things I can think of is that there's some sort of permission deal with one of the folders that TestComplete is not allowed access to alter it.  Either that, or you have one of the files still locked as open, especially if it has been edited and altered by TestComplete and then not closed by TestComplete.



Sorry, not much help from here.

Hi, I'd suggest that you run your script step by step and check the exact parameter values (evaluate things like Path&"\01 - LGComponentes" and see the evaluation results) and monitor the changes in the directory structure on each step. This will help you to narrow the problem down and make sure that everything is OK with the values you use. Also, what exact TC version are you using?

Jared,



My TC's version is 7.52

I'd do what Jared said because I just set up an environment with the exact same directory structure and file name, copy and pasted your script, and ran it and it does exactly what it's supposed to do. I'm at a loss at this point.  The only things I can think of is that there's some sort of permission deal with one of the folders that TestComplete is not allowed access to alter it.  Either that, or you have one of the files still locked as open, especially if it has been edited and altered by TestComplete and then not closed by TestComplete. Sorry, not much help from here.

Robert,



I'm sure that no folders or files that I'm trying to alter with my script is openned. About permission, I don't know what to think... I'll try to do this in another directory and will let you know if it worked or not.



______



Now, another doubt (you might hate me):

    I'm trying to compare two files contents. Both have numbers varying from 1 to 10000.



I'm using this code:

Sub CompareStrings

    PathLogsCreate = "D:\Scripts\Logs\SQL\SQL2K\LogsCreate"

    PathLogsFinais = "D:\Scripts\Logs\SQL\SQL2K\LogsFinais"

    s = aqString.Compare(pathLogsCreate&"\1-1.txt", pathLogsFinais&"\1-1.txt", 0)

    If (s <> 0) Then

        Log.Error(s)

    Else

        Log.Message(s)

    End If

End Sub

Both files have the number "2" on it. And just it.

So, it should return the value "0", right? But it is returning "-1"... How can I fix it?



Or the idea of aqString.Compare isn't that?

aqString.Compare compares the two strings, not the contents of the two files.  The -1 means that the first string in your call has a combined ASCII value that is less than the value of string 2, which is correct because of the values of the path being different.



So, if you want to compare the contents of the files, there are three ways of doing this.  The first way is to do a strict comparison of the files to determine if they are the same or different.

Sub CompareStrings

    PathLogsCreate = "D:\Scripts\Logs\SQL\SQL2K\LogsCreate"

    PathLogsFinais = "D:\Scripts\Logs\SQL\SQL2K\LogsFinais"

    if not Files.Compare(pathLogsCreate&"\1-1.txt", pathLogsFinais&"\1-1.txt")

    Then

        Log.Error("The files do not match")

    Else

        Log.Message("The files match")

    End If

End Sub

The second, is to read out the contents of each file into variables and then compare those contents whole-sale.

Sub CompareStrings

    PathLogsCreate = "D:\Scripts\Logs\SQL\SQL2K\LogsCreate"

    PathLogsFinais = "D:\Scripts\Logs\SQL\SQL2K\LogsFinais"

    File1Contents = aqFile.ReadWholeTextFile(pathLogsCreate&"\1-1.txt", ctANSI)

    File2Contents = aqFile.ReadWholTextFile(pathLogsFinais&"\1-1.txt", ctANSI)

    CompareResult = aqString.Compare(File1Contents, File2Contents, 0)

    if (CompareResult <> 0)

    Then

        Log.Error("The files do not match")

    Else

        Log.Message("The files match")

    End If

End Sub

The third is more complex but will give your a cleaner look as to what the specific differences are on a line by line basis.

Sub CompareFiles

    PathLogsCreate = "D:\Scripts\Logs\SQL\SQL2K\LogsCreate"

    PathLogsFinais = "D:\Scripts\Logs\SQL\SQL2K\LogsFinais"

    LineCount = 0

    Set File1 = aqFile.OpenTextFile(PathLogsCreate&"\1-1.txt")

    Set File2 = aqFile.OpenTextFile(PathLogsFinais&"\1-1.txt")

    While not File1.IsEndOfFile()

        File1Line = File1.Readln()

        File2Line = File2.Readln()

        LineCount = LineCount + 1

        CompareResult = aqString.Compare(File1Line, File2Line, 0)

        if (CompareResult <> 0) then

            Log.Error("Line number " + VartoStr(LineCount) + " is different")

        WEnd

End Sub

I've actually combined, in my experience, method 1 and method 3 to use method 1 to determine if the files are different and, if so, then use method 2 to find out which lines are different.



I'm sure we could even get into doing a character by character comparison to find out exactly which values are different in each line but that could just get rather silly and complex if all you need to know is whether or not they are the same.

Thanks Robert.

Call aqFileSystem.RenameFolder("C:\SQL Server", "C:\SQLServer")

I'm using this simple code and it isn't renaming properly. It creates a new folder named SQLServer and pastes the "SQL Server" folder inside of it.



I've tried this way too:

Path = "C:"

Call aqFileSystem.RenameFolder(Path&"\SQL Server", Path&"\SQLServer")

And the same problem happens.



----

Not long ago in this topic you showed me how to count itens inside of a file. It worked perfectly on the first 10 files. And then, with no reason, it just stop counting in a file, and, on the 12th file it counts correctly again. So, I separated the code from my sub and tested that file alone, and it counted normally.

Any idea about why it happens?

I'm using this simple code and it isn't renaming properly. It creates a new folder named SQLServer and pastes the "SQL Server" folder inside of it.

I'm sorry, I just did the exact same thing with no issue.  What version of TestComplete are you using?  What operating system version?  Are you a local administrator for the machine being tested?  Is there something else, some other process, using or populating that directory (such as another script that is writing files to that folder that may have that folder locked as in use)?  There are all things that would cause a folder to not be able to be renamed.  However, by itself, the code you posted successfully renamed a folder in Windows XP SP 3, TestComplete 8.5, and with the login as a local admin.  Note, if the folder is in use or a file in the folder is in use, the Test Log will record this (see screenshot attached) but it won't log it as an error because a rename/move occurred.  Could you double check your log files and see if you have any messages like this?

Not long ago in this topic you showed me how to count itens inside of a file. It worked perfectly on the first 10 files. And then, with no reason, it just stop counting in a file, and, on the 12th file it counts correctly again. So, I separated the code from my sub and tested that file alone, and it counted normally.

It's getting really hard to track all these different questions in one thread.  Could you repost this to a different thread, including the code causing your problem and, if possible, the file that you were trying to run through?

I'm sorry, I just did the exact same thing with no issue.  What version of TestComplete are you using?  What operating system version?  Are you a local administrator for the machine being tested?  Is there something else, some other process, using or populating that directory (such as another script that is writing files to that folder that may have that folder locked as in use)?  There are all things that would cause a folder to not be able to be renamed.  However, by itself, the code you posted successfully renamed a folder in Windows XP SP 3, TestComplete 8.5, and with the login as a local admin.  Note, if the folder is in use or a file in the folder is in use, the Test Log will record this (see screenshot attached) but it won't log it as an error because a rename/move occurred.  Could you double check your log files and see if you have any messages like this?

TestComplete version = 7.52.678.7

Operatin System version = Windows XP Professional SP3

I am local administrator.

The folder is new. I created it just to test the RenameFolder script.

My log stays blank.



Now, I've tried to rename a file with the following code and it worked perfectly.

Call aqFileSystem.RenameFile("C:\teste.txt","C:\teste2.txt")

It's getting really hard to track all these different questions in one thread.  Could you repost this to a different thread, including the code causing your problem and, if possible, the file that you were trying to run through?

Here you go: http://smartbear.com/forums/forum/post/?mode=singleThread&thread=6c2de87d-7e0a-4d89-b7f8-a485e971a753

The folder is new. I created it just to test the RenameFolder script.

Is the folder open in windows explorer?  If so, it's "in use" and TestComplete will not be able to rename it but simply make a copy of it.

Is the folder open in windows explorer?  If so, it's "in use" and TestComplete will not be able to rename it but simply make a copy of it.

I've tried closing all windows explorer's instances and it didn't work either.



:(

Are any of the files in that folder open and in use, as in your SQL Query editor or in a Text file editor?  Are any of the files left in an open state from TestComplete's access (after you call aqFile.OpenTextFile you should close the file)?