Jump to content
Sign in to follow this  
Rigest

How to log the use of your AutoIT script?

Recommended Posts

Rigest

My new script will be used by several users on the same network. I really would like to see how much they use the scripts. A simple solution would be to use Excel and each time add one. The problem with that is that when two users use the script at the same time they can't both open the same Excel document. I hope someone has encountered this problem before and found a solution, because I really can't think of anything...

Share this post


Link to post
Share on other sites
water

Excel will slow down your script.

I would create a file for each computer on a network share and write a line each time the script is started.

Then combine all files and use it as an input to Excel.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Rigest

Hmm ok, tnx Water. What kind of file do you recommend? Something like a .dat file?

Share this post


Link to post
Share on other sites
water

A simple text file. I would use FileWriteLine. As extension you can use whatever you like (.txt, .log ...)

Something like:

FileWriteLine("Y:\YourApplication\" & @ComputerName & ".txt",@YEAR & "/" & @MON & "/" & @MDAY & " " & @HOUR & ":" & @MIN & ":" & @SEC & " " & @UserName)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
willichan

I was doing something similar for a while, but found that my log file was corrupting. You need to do some sort of file locking while you are writing to the log, or you could have two machines writing at the same time.

Try take a look at my File Locking with Cooperative Semaphores UDF.

Share this post


Link to post
Share on other sites
water

No problem here as long as you use a different file for each computer as suggested in my sample code.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Mat

If you write it to a csv file (easy to do), you can open it in excel just by clicking the file.

Share this post


Link to post
Share on other sites
saywell

If you write it to a csv file (easy to do), you can open it in excel just by clicking the file.

That's a nifty idea if you want to use a spreadsheet.

Another possibility would be a database. Autoit has UDFs for SQLite and MySQL. Use the former if it's one for each user, but the latter if you want one databse on the network which all the users write to. Both are free.

William

Share this post


Link to post
Share on other sites
Rigest

If you write it to a csv file (easy to do), you can open it in excel just by clicking the file.

Even better! Tnx for all your replies people :graduated:

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  

×