« first day (2259 days earlier)      last day (77 days later) » 

12:01 AM
RELOAD!
[rubberduck-vba/Rubberduck] 2 opened issues. 5 issue comments.
[Zomis/FactorioMods] 1 commit. 182 additions.
[Minesweeper] Games Played: 115, Bombs Used: 77, Moves Performed: 16519, New Users: 8
 
 
1 hour later…
1:19 AM
@MathieuGuindon i'm curious - did you run restsharp requests out of a SSIS script task?
 
1:35 AM
Hm, no... using RestEase though, but a console app running on a schedule is simpler to maintain, no?
 
OK, was just curious. You might be correct about just running a console.
 
2:22 AM
@this IDK, you're right SSIS sounds like the right tool for the job here, ...except I've grown increasingly hesitant to use SSIS, for several reasons.
Likely I just suck at SSIS
but I find it slow and painful to maintain
 
I 100% agree with you RE: SSIS project being a PITA in general.
the only reason I even consider it is just because it's easier to integrate with SQL Server jobs and abstract out the tedious parts of programming the data flow manually
the scenario here is to call some stupid web API that has some throttling (yay exception handling!) and updating the database with the results.
 
2:50 AM
aye, that's exactly the scenario. really the main thing holding me back is the embedded VSTA
it's just too much trouble for the value it brings
 
 
7 hours later…
10:06 AM
[rubberduck-vba/Rubberduck] MDoerner pushed 11 commits to next (only showing some of them below)
Fixes #4913

Removes BlockNode demarcation from analysis allowing localVariables to
represent ProcedureScope regardless of where they are declared.
Remove false-positive result where an assignment is made using a
preceding assignment.
Modify tests to avoid false-positive test result(s)

Added tests for #4913.
Modified tests to verify flagged results contain expected references and
do not contain unexpected references. Checking result 'counts' can
allow failing tests to pass.
[rubberduck-vba/Rubberduck] BZngr pushed commit dc812cf2 to next: Merge branch '5456_AssignNotUsed_Jumps' into UnusedAssignment_FalsePositives
Remove evaluation by blocks

Introduces AssignExpressionNode and rewrites evaluation of declarations
and references. Closes #4913. Added handling of Static variables.
[rubberduck-vba/Rubberduck] BZngr pushed commit adb2693c to next: Merge branch 'rubberduck-vba/next' into UnusedAssignment_FalsePositives
[rubberduck-vba/Rubberduck] BZngr pushed commit 5a01f0a5 to next: Ignore RubberduckParsing.xml
[rubberduck-vba/Rubberduck] BZngr pushed commit 67dbca5b to next: Merge branch 'rubberduck-vba/next' into UnusedAssignment_FalsePositives
Address PR comments

Corrects GoTo LineNumber label handling.
[rubberduck-vba/Rubberduck] BZngr pushed commit bb1b1dd4 to next: Add test per review comments
Merge pull request #5541 from BZngr/UnusedAssignment_FalsePositives

AssignmentNotUsedInspection false positives - incorrect variable scoping and others
 
11:25 AM
Yay! New build
 
11:52 AM
2
Q: Any tips to Speed up the process of the VB Script code? trimming whitespace at end of each line

Tedi Carandang below vbscript code took me 3hours just to complete trimming whitespaces of a 24MB file any tips to speed up the process below? dim filename, path \'variables Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.GetFile(Wscript.ScriptFullName) strFolder =...

 
12:19 PM
Wow... I have a process that runs at 01:00 each day to download some data from a vendor via their API & send it to another vendor. On Monday it took 25 seconds to execute on my machine at the office.
It seems that at some point between Mon evening when I logged out and this morning when I logged in (I was off yesterday), my office machine was turned off, so the automated process didn't run Tues morning or this AM.
So, I kicked it off by hand this morning from my work laptop, at home, connected via the VPN - all processing here instead of directly on the office network.
it took 23 MINUTES to run!
Oh, sure, there's more network traffic at 8am than there is at 1am, but that's ridiculous!!!
 
12:36 PM
Our VPN sucks...
 
 
4 hours later…
4:28 PM
0
Q: Copy-Paste-Find-Replace (weekly update)

Patates PiléesHeres a code that update weekly datas from production reports Known flaws : The code is repetitive but i havent found a simple way to simplify it (since it work fine and its not complex, i dont know how to simplify it. But its still repetitive which is counter coding intuitive) There is most li...

 
 
3 hours later…
7:38 PM
@MathieuGuindon Is there anything still missing for the next release?
 
7:51 PM
@M.Doerner not that I can think of - I have started looking at the diff vs 2.5.0 to draft up an announcement article - let's shoot for Saturday?
 
8:23 PM
 
 
3 hours later…
10:56 PM
@Feeds I don't see knocking down Amazon satellites on that Venn diagram. I guess we can file that under Revenge?
 

« first day (2259 days earlier)      last day (77 days later) »