File not found error

[gagsoft]

I have a table storing backup logs. The fields are:
LogDate, LogTime, Fullpath (path and filename)
I am trying to write a restore script, but keep getting �file not found� error. The file opened using explorer and no achive attributes. This is the code that was used for testing on the interactive script panel: "vBack" is the variable holding the contents of the Fullpath field of the Backup log table
?vback
= "C:\ATC\AccommoBook\Backups\backup19.zip "
? alltrim(vback)
= "C:\ATC\AccommoBook\Backups\backup19.zip"
unzip_files(alltrim(vBack), "*.*", "c:\temp")

Is there anything wrong with this code?

[Stan Mathews]

Re: File not found error

Instead of

? alltrim(vback)

try

? file.exists(alltrim(vback))

to see if vback contains what you want it to contain.

[gagsoft]

Re: File not found error

Stan thanks for the reply.
I tried
?vback
= "C:\ATC\AccommoBook\backups\backup27.zip "
? alltrim(vback)
= "C:\ATC\AccommoBook\backups\backup27.zip"
? file.exists(alltrim(vback))
= .F.

The file does exist and it can be opened with a zip utility.

Any suggestions?

[Tom Cone Jr]

Re: File not found error

Peter, use Windows explorer to verify that the path is correct. What you're showing indicates that the file called "backup27.zip" is not in the path "C:\ATC\AccommoBook\backups"

Be careful to check spelling.

[gagsoft]

Re: File not found error

Hi tom

Thank you for your input
That is exactly my point. The script indicates that the file does not exist.
But looking at the folder with windows explorer, it is listed in the backups folder c:\atc\accommobook\backups\backup27.zip. And it can be opened.

....Weird

Thanks
Peter

[Tom Cone Jr]

Re: File not found error

Peter, I'm unable to replicate this issue here. Alpha Five can determine if my file exists whether I store in on the root drive, or whether I store it buried 6 levels deep in the directory structure. file.exists() works fine whether I use the actual path or first store the path in a variable, using the variable with file.exists() instead of the actual path.

Here are some ideas to check, though candidly each is along shot:

a)Check the file attributes. Is it hidden? is there anything unusual about the attributes since it's a backup file? i.e. is it marked as a system file or something else that's atypical? My testing here has been with simple text files that are not protected, locked, or hidden.

b) Is the file on the local machine or on a different machine? Does the user have access to that folder? Is the folder shared?

c) try your file.exist() statement without using the variable. (Supply the actual path instead). Can Alpha Five determine that the file is there? If not try to figure out why Windows is blocking access?

d) try using file.exist() with other files. Begin with files on your local machine. Then look for differences between them and the backup zip file.

[gagsoft]

Re: File not found error

Hi Tom

Thanks for all the help. Found the problem further back.
Here is the actual code:

'added alltrim() to "zip_filename" below to remove any spaces that might exist
full_zip_filename = alltrim(path) + chr(92)+ "backups" + chr(92) + alltrim(zip_filename)
tblog.backupfile=full_zip_filename
'Check to see if zip file exists. If it does, delete it.
If file.exists(full_zip_filename ) then
file.remove(full_zip_filename)
End if
file.zip(full_zip_filename,path + chr(92) + "*.*")
vFullPath = alltrim(full_zip_filename)+".zip"

What I do find strange is the fact that Microsoft Explorer did not show any spaces in the actual filename.

Thanks
Peter

[Tom Cone Jr]

Re: File not found error

Peter, thanks for posting your explanation & solution. -- tom