Search found 43 matches

by Chris70
06 Mar 2020, 15:06
Forum: Ask For Help
Topic: Need help creating a mirror image of a folder
Replies: 1
Views: 116

Re: Need help creating a mirror image of a folder

OK, now I feel stupid. I think I figured it out. I was neglecting to set the initial folder size to zero on each iteration of the script. Once I changed it to the following, it worked! Thanks me for figuring that out! #NoEnv ; Recommended for performance and compatibility with future AutoHotkey rele...
by Chris70
06 Mar 2020, 14:53
Forum: Ask For Help
Topic: Need help creating a mirror image of a folder
Replies: 1
Views: 116

Need help creating a mirror image of a folder

Hello AHKers - I have a script that I can't seem to get to work correctly no matter how many iterations I try. It seems like this should be simple and I am missing something somewhere. Any help would be appreciated. OK, so I want to look at a folder (Folder1). If the folder contains any files, I wan...
by Chris70
06 Mar 2020, 10:27
Forum: Ask For Help
Topic: Need help creating a script to show the contents of the five newest files in a folder
Replies: 3
Views: 219

Re: Need help creating a script to show the contents of the five newest files in a folder

@Odlanir - Thank you so much for the help. I tested what you provided and it works perfectly! My only question is, I am trying to follow the subroutine where you are creating the .txt file and appending the data from each batch file, which line in your code adds the extra line space between the data...
by Chris70
05 Mar 2020, 17:06
Forum: Ask For Help
Topic: Need help creating a script to show the contents of the five newest files in a folder
Replies: 3
Views: 219

Need help creating a script to show the contents of the five newest files in a folder

Hello AHKers, I am still very new to using AHK and I have a script I want to modify that I need help with. I have a script that I am using to show the contents of a .csv file in a GUI window. It currently reads the newest .csv file in the referenced folder location. It displays the header row and th...
by Chris70
30 Jan 2020, 13:05
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

just me Thanks for the response. I actually just commented out the message boxes in the two IF FileOpen lines and the script has been working perfectly. It just keeps trying to open the file and eventually gets it to open to process the batch file. Since I did that (code below), it hasn't missed a ...
by Chris70
29 Jan 2020, 15:30
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

FlyingDman I tested your script suggestion using test data and it appeared to work fine. It created unique batch files with each appended iteration of the source file. However, when I tested the script on the live log file (that is updating every 1-3 minutes depending on the production throughput o...
by Chris70
28 Jan 2020, 14:21
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 3572

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

TLM - I hadn't heard from you in a while, I was beginning to think perhaps this project was taking up too much of your time and you stopped following it. I appreciate your latest update and I will definitely work on testing it soon. In the meantime, I posted a couple other forum threads asking for h...
by Chris70
28 Jan 2020, 13:29
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

Just Me - Thank you very much for the sample code for the batch file. I am currently testing the code as shown below and it is working very nicely on the live log data (been running about . I did comment out the message boxes (not needed) and added a line to save the batch files to a network locatio...
by Chris70
27 Jan 2020, 15:47
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

FlyingDman - Your script worked very well and yielded the batch files like I was looking for in my problem description. Thank you SO MUCH for that. Quick question about your script (and scripts in general as I am very new to them), suppose I want the log file to be a defined variable that I can upda...
by Chris70
27 Jan 2020, 12:16
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

FlydingDman - Thanks for the reply. To answer your question: FlyingDman: I presume the log files will be numbered sequentially 01, 02, 03 etc. (what happens at 99 ?). Actually, the log file will have the same file name. The log file is being written to by a barcode reader application and it is simpl...
by Chris70
24 Jan 2020, 17:47
Forum: Ask For Help
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 354

Re: Constantly display the last five lines of an Excel or CSV file

AlphaBravo -

I just checked this out and it works perfectly! :bravo: I am live testing it on the file and it is running great. This is going to help me immensely, thank you thank you thank you!!!! :dance:

Have a fantastic weekend!

Thanks!
Chris70
by Chris70
24 Jan 2020, 17:33
Forum: Ask For Help
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 354

Re: Constantly display the last five lines of an Excel or CSV file

AlphaBravo -

Thank you for the post. I will give it a try and let you know how it works out! I am getting ready to leave for the weekend, but I will check it out on Monday and circle back. I really appreciate the help.

Thanks!

Chris70
by Chris70
24 Jan 2020, 17:30
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Re: Need help creating batch files by comparing appended csv files

Just me - Thank you for the post. I will test out what you provided. I did not see where this saves just the new data (data lines added between the "CheckPeriod" duration) as a unique separate file with each iteration of discovered new lines. It looks to just fire a message box when new lines are de...
by Chris70
24 Jan 2020, 15:26
Forum: Ask For Help
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 825

Need help creating batch files by comparing appended csv files

I am trying to write a script that will create unique batch csv files by looking at only the new data being added to an appended csv file. I have attached three sample files for reference. Each file is a successive iteration of the same file with new appended data saved to a file called "Log.csv" by...
by Chris70
24 Jan 2020, 14:58
Forum: Ask For Help
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 354

Constantly display the last five lines of an Excel or CSV file

I am working with a .csv file that is updating every 1-2 minutes with appended new data. I am wanting a script that runs continuously and just displays the last 5 lines of data in the file (or less if there are less than 5 lines of data) in a window on the screen. I would like the csv header to be s...
by Chris70
24 Jan 2020, 14:26
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 3572

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

TLM - Ok, so I think I figured out how to fix the situation when the output file has a product ID but no quantity as I detailed in my earlier post from today (1/24/2020). This section of code in the original script is where the issue appears to be: if ( pallet_spid && !pallet_quantity ) pallet_quant...
by Chris70
24 Jan 2020, 09:18
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 3572

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

TLM - Attached is the log file and output file for the past 24 hours (zipped together) along with my analysis xlsx file. This batch only had one repeated issue for one ID (48663) in that it captured the pallet ID and product ID (and subsequent lookup of the location), but it did not fill in the miss...
by Chris70
23 Jan 2020, 12:54
Forum: Ask For Help
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 3572

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: 3572

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: 3572

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...

Go to advanced search