Sign in to follow this  
Followers 0
Rigest

How to log the use of your AutoIT script?

10 posts in this topic

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



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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

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

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

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  
Followers 0