Search found 46 matches

by Chris70
06 Aug 2020, 15:21
Forum: Ask for Help (v1)
Topic: Move files based on file date
Replies: 3
Views: 1410

Re: Move files based on file date

Thanks for catching the typo! That was definitely the issue, I think. However, I also determined that the GetFileTime function was not grabbing the modified date value like I wanted, so I changed the script to the following and it works! Loop, Files, %Folder%\*.* { move_it := false { time = %A_LoopF...
by Chris70
06 Aug 2020, 14:52
Forum: Ask for Help (v1)
Topic: Move files based on file date
Replies: 3
Views: 1410

Re: Move files based on file date

OK, so I think I got a better script after doing some more research, I realize I couldn't just compare the time values, I have to use the EnvSub function to do math first, then compare the results. So, here my current version of the script: #NoEnv ; Recommended for performance and compatibility with...
by Chris70
05 Aug 2020, 10:22
Forum: Ask for Help (v1)
Topic: Move files based on file date
Replies: 3
Views: 1410

Move files based on file date

Hello AHKers! It's been a while since I worked with AHK scripts and I am a bit rusty. I tried searching the forum to find my exact issue, but haven't had any luck, so I am going to ask for help. Here is what I want to do: search a folder for any files modified prior to the current month and move the...
by Chris70
06 Mar 2020, 15:06
Forum: Ask for Help (v1)
Topic: Need help creating a mirror image of a folder
Replies: 1
Views: 241

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 (v1)
Topic: Need help creating a mirror image of a folder
Replies: 1
Views: 241

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 (v1)
Topic: Need help creating a script to show the contents of the five newest files in a folder
Replies: 3
Views: 433

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 (v1)
Topic: Need help creating a script to show the contents of the five newest files in a folder
Replies: 3
Views: 433

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 6421

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 625

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 (v1)
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 625

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Need help creating batch files by comparing appended csv files
Replies: 14
Views: 1367

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 (v1)
Topic: Constantly display the last five lines of an Excel or CSV file
Replies: 4
Views: 625

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 (v1)
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 6421

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 (v1)
Topic: New to AHK & script writing, need help on project
Replies: 50
Views: 6421

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

Go to advanced search