Rigest Posted November 2, 2010 Share Posted November 2, 2010 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... Link to comment Share on other sites More sharing options...
water Posted November 2, 2010 Share Posted November 2, 2010 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Rigest Posted November 2, 2010 Author Share Posted November 2, 2010 Hmm ok, tnx Water. What kind of file do you recommend? Something like a .dat file? Link to comment Share on other sites More sharing options...
water Posted November 2, 2010 Share Posted November 2, 2010 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Rigest Posted November 2, 2010 Author Share Posted November 2, 2010 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) So simple yet brilliant. Tnx m8! Link to comment Share on other sites More sharing options...
willichan Posted November 2, 2010 Share Posted November 2, 2010 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. My UDFs: Barcode Libraries, Automate creation of any type of project folder, File Locking with Cooperative Semaphores, Inline binary files, Continue script after reboot, WinWaitMulti, Name Aggregator, Enigma, CornedBeef Hash Link to comment Share on other sites More sharing options...
water Posted November 3, 2010 Share Posted November 3, 2010 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Mat Posted November 3, 2010 Share Posted November 3, 2010 If you write it to a csv file (easy to do), you can open it in excel just by clicking the file. AutoIt Project Listing Link to comment Share on other sites More sharing options...
saywell Posted November 3, 2010 Share Posted November 3, 2010 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 Link to comment Share on other sites More sharing options...
Rigest Posted November 4, 2010 Author Share Posted November 4, 2010 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now