Jump to content
Sign in to follow this  
corgano

Check if file is already open (on another computer)

Recommended Posts

corgano

I searched this problem, and found this answer, which works brilliantly

However, it does not help me because I want to check if $file is opened on ANOTHER computer

I have a bunch of pdf files on a network drive, and I'm using autoit and Acrobat to process them. I have multiple computers processing the PDF's, but sometimes they pick the same file, and they fail to save because the file is open by another program. How do I check if the file is open on another computer?


0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Share this post


Link to post
Share on other sites
mLipok

What operating system shares files.

I use almost the same solution, and would rather not complain about the problem.


Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF *

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * 

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2018-03-17

Share this post


Link to post
Share on other sites
jdelaney

command = net files

Above command gives a report of all open file shares.

Use psexec to run that locally on your server, and then parse the data

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
corgano

umm... I'm not understanding how I'm supposed to use that? Can you give an example?


0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Share this post


Link to post
Share on other sites
allSystemsGo

You could try something like this (run it where your files are located)

$file='\\localshare\openfiles.txt'
RunWait(@ComSpec & " /c " & "net files > " & $file, "", @SW_HIDE) ; this will create a txt file that shows all open files on the server

And then some code that checks file names against that list. If they are in the list, then they are open.

Share this post


Link to post
Share on other sites
jdelaney

Unfortunately, allSystemsGo, you need to run that command on the actual server housing the files.

But yes, allSystemsGo showed what it is, it's a command prompt command.

Google PSExec, or PAExec, you will need to initiate the 'net files' command on the file share server.  You can pipe back the output to your local station (wherever the autoit script is running), and then parse it.

edit: there are plenty of examples you can search for on this forum as well.  You would still need to download the exe (it's free...well, not sure about psexec, but paexec is still freeware...I think Microsoft bought out psexec?  it's all the same thing, same params, at least, if not more in paexec)

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
water

I have a bunch of pdf files on a network drive, and I'm using autoit and Acrobat to process them. I have multiple computers processing the PDF's, but sometimes they pick the same file, and they fail to save because the file is open by another program. How do I check if the file is open on another computer?

So this means you run program A on many computers in parallel? All computers process the same list of PDF files?

 

If yes, I would do the following. Create a lock file for each PDF you process on the network share:

If FileExists(PDFtoBeProcessed.Lock) Then
    try next PDF
Else
   Create PDFtoBeProcessed.Lock
   Process PDFtoBeProcessed.PDF
   Delete PDFtoBeProcessed.Lock
EndIf

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
jdelaney

Another thought.  Have one application reading for the PDFs, and creating a file that your other script uses to determine which pdf to manipulate.  That way, there will be no conflicts.  Have a dir that is station specific, like the comp name, and only have the script running from that station read from it's own folder's files.

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
allSystemsGo

Unfortunately, allSystemsGo, you need to run that command on the actual server housing the files.

Correct, which is why I said to run in where the files are located.

Share this post


Link to post
Share on other sites
corgano

I can't run on the computer hosting the files

By lock file, you mean just a blank, temp file, that I can check if ti exists? That could work

Is there a way to see if creating a file fails? I mean I could..

 

for file in list

    if fileexists(file&".lock") then

        next file

    else

        filewrite(file&".lock","asdf")

        <do processing crap here>

        filedelete(file&".lock")

    endif

next

I'm just afraid that I'll end up with two acrobats checking the file exists at the exact same time, and then both of them ccreating a lock file and colliding. It might be better if....

for file in list

    filewrite(file&".lock","asdf")

    if @error (file already exists) then next file

    <do processing crap here>

    filedelete(file&".lock")

    

next


0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Share this post


Link to post
Share on other sites
water

By lock file, you mean just a blank, temp file, that I can check if ti exists? That could work

Is there a way to see if creating a file fails? I mean I could..

 

I'm just afraid that I'll end up with two acrobats checking the file exists at the exact same time, and then both of them ccreating a lock file and colliding. It might be better if....

A lock file is just a file. Content doesn't matter.

If you need to be 100% sure that a file isn't being processed by another computer do the check twice with a random wait time between.

Check if the lock file exists
Sleep(Random(10, 2000)) ; sleep up to 2 seconds
Check if the lock file exists

If both checks are successfull then create the lock file.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
orbs

the content of the lock file can be quite useful: you can have it indicate the hostname that locked it, or the time it was locked, so if the hostname is dead or too much time passed, another process can unlock it... but the general idea is well explained.

  • Like 1

Share this post


Link to post
Share on other sites
corgano

Awesome, I think I have an idea of what to do. I'll post back


0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×