Search found 46 matches

by Chris70
23 Jan 2020, 12:54
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - OK, I tested your updated ProcessLogFile() function and it did solve the problem with the missing product ID on the data I sent you this morning from the past 24 hours (thank you!). However, I clocked the time it took to run the file using the old script vs. the updated one and the updated one...
by Chris70
23 Jan 2020, 10:30
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Thanks for the updated script, I will test it today and then start using it on the machine. Don't forget to change the product ID string dimension for: NeedleArray := [ "[-`,](?<quantity>\d{1,3})\D", "\D(?<prid>\d{3,5}(-\d{1,3}|))\D", "\D(?<spid>RO\d{8})\D" ] change d{3,5} to d{4,6} to avoid t...
by Chris70
23 Jan 2020, 09:32
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Please find the attached zipped log file with corresponding output CSV file along with an Excel file with my data review for the last 24 hours. In this batch, there were only two bad data points and both captured the pallet ID and the quantity, but failed to find the product ID and subsequentl...
by Chris70
22 Jan 2020, 17:51
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - TLM Wrote: Hey Chris quick question, does the computer that you're running the ProcessLogFile script on have Ms Word standalone or in Ms Office? Thanks The computer is running MS Office suite (office 360 under a corporate license). As for the duplicate tag issue mentioned before, this is the f...
by Chris70
22 Jan 2020, 09:33
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - I have attached a .zip folder with the log file and corresponding csv file for the past 24 hours. I also am attached an Excel file where I went through the data to do a quick verification check. I copied the data into a table and sorted it by pallet tag ID, then looked through the data line by...
by Chris70
21 Jan 2020, 10:49
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM -

Now I feel stupid for asking about the pallet count. All I had to do was change the starting pallet count to 0 and that fixes the problem.

So, I changed this:

Code: Select all

	PalletCnt := 1 ; init counter
to this:

Code: Select all

	PalletCnt := 0 ; init counter

Duh...

Thanks!

Chris
by Chris70
21 Jan 2020, 09:59
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - By the way, I appreciate you adding the running/final pallet count and last pallet scanned data to the information display. One thing I noticed though is that the pallet counter is presently including the header line in it's count. What would be the change needed to take the current pallet cou...
by Chris70
21 Jan 2020, 09:46
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Here is the log file and resulting output file from the last 24 hours (~7am 1/20/2020 through ~7am 1/21/2020) for your reference and testing purposes. I'll just post these each day when I changeover the log file and script each day (manually changing the file name date extension at the moment)...
by Chris70
21 Jan 2020, 09:41
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - TLM wrote: If whenever possible please also attach as many varying logs as you can. Please find zipped folders of the Test1, Test2, and Test3 data log files used to test the batching script. Test3 contains data collected from Friday, 1/17/2020 starting about 7am through Monday, 1/20/2020 at ab...
by Chris70
20 Jan 2020, 17:54
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - I confirmed the Product ID fix worked, but I had to change D{3,5} to D{4,6} because the 3 was pulling in the 3-digit quantity as the ID, and our product IDs are never less than 4 digits, but can be up to 6 before any potential "-90" modifier. So that is good. However, the testing on the batch ...
by Chris70
20 Jan 2020, 11:36
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - TLM Wrote: Just a FYI, my time has become severely constrained so I can only check in on the progress a few times today. I completely understand and appreciate all of time time you have given and continue to give to this project with me. TLM Wrote: The function parameters are abbreviations: Pr...
by Chris70
17 Jan 2020, 17:47
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - I have attached an updated copy of the log file and csv file from testing today. You will notice several lines with missing quantity data, which is concerning because I know that information is available via lookup on the IDs and it is not populating for some reason. Each of the ones I saw the...
by Chris70
17 Jan 2020, 12:52
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Below is the updated script I am currently running on the machine. It has the current PID logic/function call setup and I simply added a few items for copying both the log file and output file to our shared network folder so I can monitor the status of the scanner (if the save date/time differ...
by Chris70
16 Jan 2020, 17:51
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Thank you for the updated script with the loop built in, it is making more sense now. You created a master function call and looped that, then detailed all the functions below it and they are not directly in the loop, but are pulled in by the function call within the loop, clever. I updated my...
by Chris70
14 Jan 2020, 17:43
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - I appreciate the information on how to do the mouse click function for the log save feature. I already had a script for that that I cobbed together from researching other forum posts and AHK help. The hardest part was trying figure out how to reference a window, find the AHK class names and ID...
by Chris70
02 Jan 2020, 17:50
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Thanks for the recent post. I hope you enjoyed your holiday time off! I have been using a modified version of your previous version to save a copy of the .csv file every 3 min. of the current log file. I have been simply stopping the scripts in the morning, manually renaming the file to the cu...
by Chris70
30 Dec 2019, 11:57
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - I have attached an Excel file which shows what I believe would be the progression of the file sequence I would want. So, here is how I am seeing this working: 1. Assuming I am saving live data to a .log file like before and it is updating constantly, every three minutes the script will interru...
by Chris70
27 Dec 2019, 18:00
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM -

I got tied up on the floor today. I will walk through the steps and provide sample files of what I think I am looking for and let you figure out how to make it happen! So far, you have been on point with everything and I really appreciate it.!
by Chris70
26 Dec 2019, 11:42
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - OK, so I tried running the script again with the modification and didn't even try opening it with Excel, but opted to open in Notepad first to test it. It gave an error saying that it could not open because it was still being used by another process. Then, I noticed the script was still runnin...
by Chris70
26 Dec 2019, 09:19
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 4268

Re: New to AHK & script writing, need help on project

TLM - Sorry for the delayed response, I was off the past couple of days for Christmas. I came in this morning and tested the latest revision (Test Filter-5.ahk and resulting output file test-output5.csv attached for reference). There is some sort of error that has been introduced into the output fil...

Go to advanced search