VBA Rubberducking

Duga

12:01 AM

RELOAD!

[banane-io/pdb-frontend] 1 commit. 40 additions. 7 deletions.

[rubberduck-vba/Rubberduck] 1 issue comment.

[rubberduck-vba/RubberduckWeb] 3 commits. 95 additions. 31 deletions.

[Minesweeper] Games Played: 109, Bombs Used: 78, Moves Performed: 15372, New Users: 18

this

1:24 AM

Because of the discussion about SQL injection lately, I put out a stripped down PoC for reviews to see if it could be broke (hopefully not but I'll be happy to have it broken, better broken in CR than by black hats)

0

Q: Safe dynamic SQL for generic search

Prompted by discussion about SQL injection, I wanted to put a proof of concept forward to get feedback about whether this is in fact safe and protected against SQL injection or other malicious use. For good reference on the subject of constructing a dynamic search with dynamic SQL, I'd probably l...

Hosch250

1:46 AM

> Remember, you always have to talk to Google like it's a baby with an extensive knowledge of porn

LOL.

IvenBach

3:50 AM

@Hosch250 where you find that?

QHarr

8:49 AM

\o anyone in the pond?

IvenBach

9:49 AM

Only insomniac Iven at this hour.

Duga

10:10 AM

[rubberduck-vba/Rubberduck] mansellan assigned mansellan to issue #5008: Add ~> Existing Module

[rubberduck-vba/Rubberduck] mansellan removed label up-for-grabs from issue #5008: Add ~> Existing Module

FreeMan

11:13 AM

@IvenBach bwahahaha!

@MathieuGuindon I suggested submitting to one of those funniest video programs - may as well make some cash outta the program...

Hosch250

12:09 PM

@IvenBach Reddit.

FreeMan

Just exactly how dynamic can I make an SSIS file import?

I'm going to be receiving CSV/XLS files and I'd like to design a very simple interface for a very non-technical person to map columns in the file to appropriate columns in the table(s) in which the data is stored.

Is it possible to pass this mapping info into SSIS as parameters to allow it to import a (relatively) arbitrary file format?

(Some assumptions about the intelligence of the mapper must be made: i.e. not putting FirstName into the DateOfBirth column, etc.)

FreeMan

12:36 PM

by "very simple" interface, I know it will be "very complex", but I'm hoping it will be user friendly and, hopefully somewhat error resistant

this

Hmm. My position has been that if there's data massaging or manual intervention involved, SSIS isn't appropriate.

I'd use Access since that can be then used to preview the data, do the mapping and correct any issues before putting it in SQL Server table.

SSIS is perfect when you need to fully automate it without any human intervention.

The fact that you're asking about arbitrary file format worries me because that tend to require a human to look at it, no?

FreeMan

We get files from insurance carriers and usually the format is consistent from month-to-month, but sometimes it does change, usually without warning. So yes, a human would have to intervene when the format changes.

this

So, here's a hybrid approach.

You get a new format, you can set up the mapping in Access

FreeMan

The issue is that we get files from different carriers and they're all in different formats. We want to ingest them all, store the data, be able spit out the original in the original format if necessary (mostly to prove that I haven't lost any data), then export in a variety of formats for other purposes.

My intent was to do this all via Access, but my recent successful foray into SSIS got me wondering how much was possible with it.

this

Right - so what you really want to do is transform the inputs into a uniform format.

Mathieu Guindon

12:44 PM

Didn't EDI solve this?

this

Don't know about EDI - what is that?

FreeMan

I'd like one (non-technical) person to be able to scan the incoming file, ensure the format hasn't changed, then kick off the processing for that file. If it has changed, they can fire up the mapper and adjust for the new format

Electronic Data Interchange. Yeah - they email us a CSV file. Its data, it's interchanged, and it's done via electronic means, therefore EDI.

this

LOL

Gonna love dem high-tech solutions like that

FreeMan

To get really fancy, I think one or two providers actually have an SFTP site we use to download the data. That's super electronic!

Duga

[rubberduck-vba/Rubberduck] ufo2mstar synchronized pull request #5015: Enhancing the GettingStarted guide

FreeMan

12:48 PM

My thought was that this was beyond the capability/scope/purpose of SSIS, but I figured I would ask.

this

Anyway.

I'm trying to envision how you would provide a new mapping. The problem is that when you use a flat file provider, it hard-codes all the column metadata for downstream processing

As such, I do not think you can use a flat file source.

Rather you'd have to write a script task to read the file yourself and transform it into the format you want

So earlier I was saying that you could write a hybrid solution where you can use an Access application as a "viewer" and "mapper builder" to write metadata into a table

your SSIS package can then read off the same table to be then used in the script task to determine how to process the file

Don't count on doing it in a single Friday afternoon, though.

FreeMan

@this I'm counting on a month of single Friday afternoons, a couple of blue moons and Christmas before it's fully debugged and working.

@this Interesting concept. My initial intent was to use sprocs and/or parameterized queries to import the data directly from the Access app. Would you recommend this instead?

this

That would be less programming, yes but that mean you must have a human intervention.

FreeMan

this method would take more learning on my part and, therefore, more time, but learning

this

The hybrid concept is to support automation for all known file formats

e.g. you don't have to have someone to babysit the import all the time

Duga

12:54 PM

[rubberduck-vba/Rubberduck] ufo2mstar commented on docs/GettingStarted.md of pull request #5015: Enhancing the GettingStarted guide

FreeMan

@this which "that" would be less programming?

this

doing all imports via an Access application

FreeMan

gotcha

I would think that once the mapping is set up, the only human intervention is saving the file from email into the correct location and manually kicking off the process.

this

assuming htere's no other errors but yes, that's correct but you'll have to do it even for a known file formats

FreeMan

Could have a file watcher, but we don't get enough that I think it would be practical to set that up up front.

Yeah, then fixing everything that went wrong if it blows up. ;)

this

12:56 PM

right - if you only have a handful of files a day, ROI probably won't be there for the hybrid solution.

Hybrid start to make sense when you have too many files of same file format that should just get processed straightaway

FreeMan

files a day? we're talking maybe 20 files/month...

maybe...

this

Yeah, I wouldn't bother w/ hybrid then. ROI would be positively awful.

FreeMan

we seem to specialize in that 'round these parts...

thanks again for the feedback.

this

yw!

Duga

[rubberduck-vba/Rubberduck] ufo2mstar created comment on pull request #5015: Enhancing the GettingStarted guide

> Perfect @retailcoder.. will put together some pages and get back to you when I find some time 🙂 I hope Office 365 is not too radically different!

Duga

1:23 PM

[rubberduck-vba/Rubberduck] Vogel612 commented on docs/GettingStarted.md of pull request #5015: Enhancing the GettingStarted guide

Mathieu Guindon

@this it's a set of standardized "electronic data interchange" formats any vendor should be familiar with :)

this

Evidently not Freeman's....

I am also assuming that it's not a OOB source. There's probably a third party company that provides EDI as a source.

FreeMan

1:39 PM

> HL7 and its members provide a framework (and related standards) for the exchange, integration, sharing, and retrieval of electronic health information. These standards define how information is packaged and communicated from one party to another, setting the language, structure and data types required for seamless integration between systems.

HL7. Most of the software we use supports it, but our company (as I've understood it) doesn't want to implement it.

so...

6 mins ago, by this

Evidently not Freeman's....

'cause that would make sense, and we're just not into that.

this

I know for a fact that there are 3rd party component selling HL7 as a source task in SSIS

FreeMan

holy HIPAA violation Batman!!!!

It looks like this id10t posted a real person's info on a public forum.

Hosch250

@FreeMan Report it.

FreeMan

1:56 PM

Wow. I actually have a Windows Live account and it hasn't been deactivated. I have no idea how long it's been since I last logged in...

@Hosch250 Where's the "Report" option? I'm not seeing it.

Hosch250

@FreeMan ocrportal.hhs.gov/ocr/smartscreen/main.jsf

FreeMan

Ah. Gotcha. I was looking at the live.com site to report it to them to have it cleaned up/genericized.

Mathieu Guindon

@FreeMan wah wtf

FreeMan

^Yeah, that's what I thought.

Is there somewhere on the ms site to report that to get it sanitized/cleaned up/removed? I looked at the HHS link @Hosch250 found, but I'm not sure that I want to go through all that, plus, they limit reporting to 180 from the event (waaaat?) or you'd better have a darn good reason for holding out on us!

Hosch250

@FreeMan You can report it, but you have to have a good reason to have waited that long.

FreeMan

2:07 PM

^ see edit :)

Mathieu Guindon

"I reported it when I saw it" isn't good enough?

FreeMan

dunno. They want all sorts of personal info to report it.

Guess I really should. There's enough in that post to make it look legit...

Dunno if they can go after the guy who posted, but they should be able to get MS to take down the post, censure the user and attempt to delete it from the wayback machine.

this

tomorrow's headline: "My life is now hell because everyone knows my SSN, thanks to a developer looking for help."

2

FreeMan

LOLish

IvenBach

@this that’s no developer, that’s a Pineapple.

FreeMan

2:17 PM

Doesn't appear to be an SSN in there, but there are biometric values, dates and what appear to be actual names. No "Test Testerson" or "Cliff Claven" names.

Duga

[rubberduck-vba/Rubberduck] ufo2mstar commented on docs/GettingStarted.md of pull request #5015: Enhancing the GettingStarted guide

[rubberduck-vba/Rubberduck] retailcoder added label user-interface to issue #5016: Code Pane context menu is misplaced in Office 365

[rubberduck-vba/Rubberduck] retailcoder opened issue #5016: Code Pane context menu is misplaced in Office 365

> Discovered by accident in #5015; the Rubberduck code pane context menu is buried in the "Toggle" sub-menu in Office 365:

![wtf](https://user-images.githubusercontent.com/2426264/59856707-75ce6d80-9345-11e9-90d9-7240a639e448.png)

The context menu location is configured at the `AddIn` level, here:

https://github.com/rubberduck-vba/Rubberduck/blob/4f387a27228c881a76258dce1aba8f35c73ed847/Rubberduck.VBEditor.VBA/SafeComWrappers/VB/AddIn.cs#L9-L34

[rubberduck-vba/Rubberduck] retailcoder added label bug to issue #5016: Code Pane context menu is misplaced in Office 365

[rubberduck-vba/Rubberduck] retailcoder commented on docs/GettingStarted.md of pull request #5015: Enhancing the GettingStarted guide

Mathieu Guindon

2:41 PM

@Duga what other reason than "Microsoft decided to change control IDs for the heck of it" could there be for that?

this

I don't think control IDs are unique

Mathieu Guindon

within a parent menu?

this

My recollection is fuzzy but I remember that you had to specify both the menu and the control

um, I think it should be unique within a single menu/toolbar

Has to be but it's not globally unique

Vogel612

are you sure that the context menu is set up there?

this

I know for certain I hated the whole commandbars system. It's a hodge-podge

BTW, I just checked. I'm on Office365, and I don't have that

Vogel612

2:45 PM

it's getting weirder and weirder.

Mathieu Guindon

wtf.. we were using IDs because captions are localized

this

#FunTimes

FreeMan

@MathieuGuindon Isn't that MS's favorite reason for changing things?

Mathieu Guindon

@FreeMan for renaming things, yes =)

this

where are we setting the ID?

Mathieu Guindon

2:50 PM

What do you mean?

Vogel612

@this we're not. They are hardcoded constants

Mathieu Guindon

@this github.com/rubberduck-vba/Rubberduck/blob/…

basically, at the top level

mansellan

Command bar IDs are an absolute PITA. from what I recall, we can't really guarantee where an insertion will occur, because the IDs are not unique, can change over releases, and the user may have customised their menus

it's kinda best-guess

this

I guess here is also used to insert: github.com/rubberduck-vba/Rubberduck/blob/…

Mathieu Guindon

Yup

the idea was "let's have a known built-in ID to insert our stuff immediately before"

this

2:55 PM

"... and cross our fingers"

mansellan

^

Mathieu Guindon

I think we went with "cut" or "paste", or something highly unlikely to ever change. #YeahRight

FreeMan

@MathieuGuindon Change in general, in my experience/opinion

As I process my CSV files to import them, I'm going to be taking one wide denormalized row and breaking it down and inserting into multiple linked tables to normalize it.

They only way I know to do this is RBAR
1) Find "Person" info and see if he exists in `PersonTable`. if so, grab ID for future use, if not, insert & grab ID.
2) Find "Coverage" info and see if it exists in `CoverageTable. If not, insert
3) etc
4) lather, rinse, repeat for each row

Is there a better methodology?

FreeMan

3:21 PM

this looks reasonably promising.

KySoto

4:17 PM

hmm

that was bizarre

i managed to lock up access as if i had a modal form open

without actually having one open

i could run code, but couldnt click on anything in the main window

it would chime at me

this

did you check if it's hidden behind another form?

this is a problem with newer Windows - lot of modal dialogs in various application just don't come in front.

a trick I do is to do Show Desktop then show the application. That usually gets the modal dialog in front again

Hosch250

4:33 PM

104

Q: Is it possible to remove the Careers banner with the dying starfish?

Is it possible to remove the annoying ad with the dying starfish? Certainly, this is not what my career should feel like.

discussion status-completed advertising

:joy:

I never knew there were so many ways to be "offended".

KySoto

@this its a custom form, and i closed it

:/

at least i can save it

Mathieu Guindon

4:57 PM

best response

67

A: Is it possible to remove the Careers banner with the dying starfish?

Yeah. And there's a lot more wrong with that ad than just that. The orange of the starfish is potentially offensive for people who don't like dutch royalty and/or victims of the Orange Free State. the Careers logo looks like the reception bars on your mobile phone; the fact that there's six bar...

man that whole thread is hilarious

This is what your career should feel like followed by a bottom bar in the colour of crap, yeah, nothing at fault with that. — yannis Aug 11 '12 at 11:38

KySoto

5:17 PM

how did you guys even find that ancient question?

Hosch250

I don't know.

Just browsing questions on SE

Mathieu Guindon

@Hosch250 is having a very busy day at work lol

Hosch250

I've had nothing but very sporadic fires for the last week.

I have (I think) 4 tickets in my queue for the next release that are probably about 4 hours worth of work.

FreeMan

5:38 PM

@Hosch250 That's what's so great about America - we can be offended by any and everything. BTW - would you stop breathing, I find it offensive.

I am dutch, and I am offended by orange (especially during soccer season) — Toon Krijthe Aug 14 '12 at 9:45

and if you're a victim of the Orange Free State, you should be not only happy, but quite surprised to still be breathing and should no longer be taking offense at anything.

KySoto

5:57 PM

so my co-worker sent me this.. if someone was to be offended, id say it be about this

engadget.com/2019/06/20/…

IvenBach

20 hours ago, by IvenBach

yesterday, by IvenBach

Jun 7 at 16:44, by IvenBach

yesterday, by IvenBach

21 hours ago, by IvenBach

CoworkerWalkingIntoGlassDoor++;

KySoto

lol

IvenBach

Sweet Jesus when will people learn?

KySoto

after they die?

IvenBach

Darwin awards prove death doesn't mean learning occurred.

KySoto

5:59 PM

to be fair, can you tell they didnt?

IvenBach

<smugly>I'm confident in my assessment they didn't.</smugly>

FreeMan

@KySoto Wait. "Loot Box" as in the random things that get dropped in some FPS games? People are so up in arms about that that governments are "investigating"? No wonder they can't do anything actually remotely useful. :(

@IvenBach Is it the same person or different people?

IvenBach

6:25 PM

@FreeMan This time it was a different person.

FreeMan

Indicating that there have been episodes of the same person hitting it more than once? Nope. No learning going on there at all!!

IvenBach

27 mins ago, by IvenBach

<smugly>I'm confident in my assessment they didn't.</smugly>

@KySoto ... We truly do live in A Brave New World now.

Mathieu Guindon

6:42 PM

@IvenBach 5 then? is the count accurate?

Hosch250

@MathieuGuindon It got messed up due to not properly locking access to prevent simultaneous updates ;P

mansellan

@FreeMan I'd never heard of them either. But reading the wiki entry suggests that these things are paid for with real money, hence being a type of gambling.

pay-to-win

Duga

[rubberduck-vba/Rubberduck] mansellan created comment on issue #5008: Add ~> Existing Module

> Currently, the Add button drop-down comes from the same resource entry as the Add context (sub) menu. If we add an entry for 'File...' there, it will show up in both places. That being so, the Import... menu item seems somewhat redundant. Did we want to keep it?

mansellan

6:58 PM

@Duga wishes he'd persevered with refactoring menu \ command injections, it would have helped here

FreeMan

@mansellan who knew. Still a waste of time at the national government level.

Duga

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5008: Add ~> Existing Module

> Indeed this makes the "Import..." menu item <s>somewhat</s> completely redundant, the "Existing Item..." menu item means to replace it, leaving "Export" close to "Remove", and effectively moving "Import" closer to the "Add" commands.

Peilonrayz

@mansellan The ones I've seen have all been "pay to look pretty".

mansellan

7:16 PM

@Peilonrayz lol!

Mathieu Guindon

damn

the calling function which is used to instantiate the class and call a method is a UDF called from the worksheet - sounds like the root of the problem: you're abusing UDFs and making them do something they're clearly not meant to be doing. UDFs are intended to be pure functions, not side-effecting hacks that schedule other calls to other side-effecting hacks. This has all ingredients of a classic X-Y problem. Instead of trying to hack up a solution for not-the-real-problem Y, why not tell us more about the actual problem (X) you're trying to solve? — Mathieu Guindon 1 min ago

BigBen

:bombshell:

Mathieu Guindon

like, sorry if this is a brutal awakening, but a UDF has no business scheduling member calls on anything whatsoever, be it in a standard module or an instance of some class

BigBen

yep. Couldn't agree more.

wow just actually read the question, once I hit the UDF sentence ... wtf?

Mathieu Guindon

In other words: implement stuff in a macro rather than a UDF, and the "problem" poofs away in a glittering purple haze of magical unicorn dust. — Mathieu Guindon 10 secs ago

BigBen

7:24 PM

haha the alliteration, problem poof purple, we need some more ps.

powder?

Mathieu Guindon

lol

BigBen

the "problem" poofs away in a pretty purple ploosh of potent pixie powder

Mathieu Guindon

aw but I wanted an excuse to use the word "glittering"

this

7:47 PM

pottering works.

or, po-glittering

poop-gilttering!

BigBen

the gaffe/glitch/god-awful gobbledygook of code glides away in a glittering green glow of gremlin gems... oh yuck, that went sideways quickly.

Mathieu Guindon

gosh

BigBen

that was just an excuse to use "gobbledygook"

FreeMan

8:03 PM

Having a thought on my data import task: On the client side, I simply import the data into an appropriately shaped temp table, then kick off a big 'ol sproc on the server to parse its way through all the data, determine what's new and insert records as necessary.

Advantage: Once it's on the server, there's zero network latency involved, and the server hardware is (probably) beefier than our desktop machines.

Cons: It's all got to be written and maintained on the server in TSQL and I don't get to practice writing some good classes.

Thoughts?

Quack Exchange

0

Q: Excel - Visual Basic For Applications - Mastermind Game

For those who are unfamiliar with the game: https://en.wikipedia.org/wiki/Mastermind_(board_game) A link to the workbook: https://github.com/Evanml2030/Excel-Mastermind Had trouble getting the form and scroll bar to adjust based on the resolution of the monitor that it is inside. It does not...

game vba excel winapi

this

Sure that's what I do typically, using staging tables.

FreeMan

@QuackExchange get yer brokeback code off to SO!

@this It can still be pretty modular, and I s'pose I can git my sql source code.

IvenBach

@MathieuGuindon There were a few that occurred before I officially created the backing field.

FreeMan

Another con: if the file format changes, I have to adjust the temp table. I guess on the client side I can confirm that the columns provided in this month's file matches what is expected prior to attempting to load and give a warning and abort if they don't

this

8:11 PM

that'd be a case where you do the massaging in the Access

e.g. let it filter what columns to put in the temp table until you actually need some new column for some reason

so if they're in habit of adding random columns that aren't interesting to you, that might make sense

FreeMan

Since I'll have a map of the CSV, I can confirm that it matches the current file and refuse to process if it doesn't. Then the user can go fix up the mapping & reprocess. If the temp table doesn't match the mapping, I can drop and rebuild the temp table on the fly.

@BigBen ♫great green globs of greasy grimy monkey guts, mutilated monkey nu...♪ yeah, never mind.

BigBen

@FreeMan now that's stuck in my head lol

isn't it gopher guts?

FreeMan

My work here is complete.

oh, yeah, guess it is.

and on that fine ♪, my work is actually complete for the day. TTFN

</FreeMan>

this

and with that, freedom died.

QHarr

8:43 PM

\o anyone mind answering a quick question regarding two versions of a short piece of code I have written?

Basically just wanna know what best practice is....or have I completely missed the point.....

Exhibit A: Original code using If Else to manage return of function

Public Function Bar(ByVal id As String) As String
    Dim json As Object
    With CreateObject("MSXML2.XMLHTTP")
        .Open "GET", "http://www.dhl.com.au/shipmentTracking?AWB=" & id & "&countryCode=au&languageCode=en&_=", False
        .setRequestHeader "Referer", "http://www.dhl.com.au/en/express/tracking.html?AWB=3010931254&brand=DHL"
        .setRequestHeader "User-Agent", "Mozilla/5.0"
        .setRequestHeader "X-Requested-With", "XMLHttpRequest"
        .setRequestHeader "Accept", "application/json, text/javascript, */*; q=0.01"

Exit B re-write as thought, do I really need the Else as I am only assigning as vbNullString

Public Function Foo(ByVal id As String) As String
    Dim json As Object
    With CreateObject("MSXML2.XMLHTTP")
        .Open "GET", "http://www.dhl.com.au/shipmentTracking?AWB=" & id & "&countryCode=au&languageCode=en&_=", False
        .setRequestHeader "Referer", "http://www.dhl.com.au/en/express/tracking.html?AWB=3010931254&brand=DHL"
        .setRequestHeader "User-Agent", "Mozilla/5.0"
        .setRequestHeader "X-Requested-With", "XMLHttpRequest"
        .setRequestHeader "Accept", "application/json, text/javascript, */*; q=0.01"

Do I need to have the Else? As in first version?

Vogel612

the first version does not have an End If for starters

QHarr

Ooops

Vogel612

also you could extract the json("results")(1) into a with block variable

QHarr

Imagine I hadn't deleted the End If!

@Vogel612 Lemme take a look

Vogel612

AFAIK the default value for a String is vbNullString, if only because it can't be Variant/Empty

QHarr

8:48 PM

Yeah... so I decided I didn't need the Else and could rely on that behaviour.

Vogel612

seems semi-reasonable

QHarr

oh dear....

so better to be explicit?

Vogel612

almost always, yes

Mathieu Guindon

*semi-always

QHarr

Thanks. With respect to the With statement.... how do you see that working? I can't . in front of the accessor?

Vogel612

8:51 PM

those are default member accesses in the first place, aren't they :)

QHarr

So, I can't do:

With json("results")(1)
    if .("delivery")("status") = "banana" Then
        Bar = .("checkpoints")(1)("date")
    Else
       Bar = vbNullString
    End If
End With

but you are saying I don't need the "." ?

Vogel612

ParseJson returns an Object? I'd assume Items is the default member there

QHarr

Yes it returns a dict

Vogel612

well, assign it to a Dict then

BigBen

lol

@MathieuGuindon double lol

QHarr

8:56 PM

What I am not seeing is how it would work with a With as don't I still need . within With?

(I know I'm slow...)

Vogel612

9:12 PM

If .Items("delivery")("status") = "banana" Then

this

9:26 PM

FWIW, I'd insist on .Items("delivery").Value.Items("status").Value = "banana" or whatever it is.

Vogel612

ya, that's probably better, though it might miss a .Value in between, doesn't it?

this

probably - i was winging it a bit

The problem is that it's late-bound

No compile-time validation after the first Value

Vogel612

yea...

mansellan

TFW you promise a PR and don't deliver... github.com/canton7/RestEase/issues/113#issuecomment-504207854

gosh, I suck

Vogel612

9:47 PM

it's not really cool to be stuck in the reverse situation, though

I have a PR that's been open for almost two years

mansellan

eesh no. Yet to experience that one, still pretty new to OSS, not PR'd to anything except RD.

(and not PR'd to RD for far too long, hence picking up an up-for-grabs ;-) )

@Vogel612 would it be unseemly to comment :tumbleweed: to that PR? (kidding!)

Vogel612

that repo is basically abandoned anyways

mansellan

well, it is Java </flamebait>

Vogel612

actually it's a google project

mansellan

> Guice (pronounced 'juice') is a lightweight dependency injection framework for Java 6 and above

meh, next!

;-)

Vogel612

9:55 PM

Java 6 has been deprecated for literal years by now

this

@mansellan Not enough fire in your belly, eh?

this day has been a living hell

mansellan

@this lol

Vogel612

it's madness to still target it with a DI framework that's being developed

mansellan

Monday, I have to be at work at 00:30 (huge release)

fun times...

@this Oh?

Mathieu Guindon

@mansellan alt. pronunciation: "goose", I guess

this

10:00 PM

Murphy's being a particularly hardass today.

NOTHING MUST GO RIGHT TODAY

mansellan

@MathieuGuindon Heh, the duck would kick the goose's ass :-)

Mathieu Guindon

haha

mansellan

@this bt;dt... I sympathise.

this

@mansellan wait, why would a goose have a donkey to begin with?

2

mansellan

@this lmao!

IvenBach

10:08 PM

@this Aren't you Mr. belts-n-suspenders?

It must be really bad then.

this

@IvenBach I forgot my overalls and coveralls today.

IvenBach

Then you at least have your Suspenders, belt, pants waist button, and underwear (both boxers AND briefs) then. #YoureGoodToGo

mansellan

@IvenBach Real risk-averters also add an elasticated waistband

this

may have to add hazmat to my daily clothing wear, too.

IvenBach

Can't have a beard with most breathing apparatus.

this

10:12 PM

i think you can have one in a hazmat

you're wearing a hood, after all

IvenBach

:thinks: did you have one in the picture with mug?

Those style yeah.

Of course you'd go for the full body style.

this

nah, just some scruffy scaggy hairs on my chin

IvenBach

Ergh my spelling is particularly bad today.

this

On the contrary, your speeling is particularly wünderkind.

IvenBach

I try. And in todays school system that means I pass.

I just made myself sad with that comment. Why has the bar been lowered so much.

2

this

10:19 PM

because their little Bobby is a special snowflake and nobody dares to say otherwise?

Vogel612

what with that weird name anyways

this

I blame King of the Hill

IvenBach

That boy sure ain't bright.

this

IIRC, Hank always said "that boy ain't right" or something like that.

IvenBach

I've not seen it in ~15years. Bound to mess up the quote.

mansellan

10:35 PM

Tried watching it once, didn't see the appeal

And generally, I love American animation. Rick and Morty, omg...

fires up Netflix

IvenBach

I still haven't seen that show.

mansellan

@IvenBach you have to see that show.

this

had to google it

mansellan

Any episode, they're all good

IvenBach

Don't have the time. I barely have enough time with my family as it is.

this

10:39 PM

<-- a bit outdated

mansellan

@this uh, wut?

IvenBach

^^ More so than I am.

I've at least heard about it.

this

seeing it's Adult Swim, probably why.

I don't have cable.

Just Netflix.

IvenBach

No cable, Hulu, Netflix, Prime. None

mansellan

hmm, TIL... in the UK, adult swim, HBO stuff all turns up on Sky (satellite), which is $ - you have to pay $$$ for those?

IvenBach

10:41 PM

I win that outdated/hermitish contest.

this

@IvenBach I tip my hat to you, sir

@mansellan worse. You get ads, too.

mansellan

@this yeah, knew that, seen some live streams... we get ads, but like every 15 mins. you get them every 5...

this

I mean, Netflix and Hulu at least make sense. Pay $, no ads. Cable wants you to pay $ and watch ads? Uh....

IvenBach

^ The purpose of paying for specialty channels was so you wouldn't have adds.

this

So yeah, can't see me paying for more ads.

mansellan

10:43 PM

In the UK, BBC is ad-free (obvs), and so is Sky Movies (they'd love to, but its a big and historical selling point). Everything else has ads.

this

Don't care if they have great shows or whatnots. I don't want to be interrupted by some lame kid toy or some new candy or a creepy medical ads with mile-long disclaimer

mansellan

American ads are creepy

this

ok, i have an excel spreadsheet with a column that's 65,530 rows tall.

IvenBach

CableCompany: We want to give you all these channels. It's blah blah blah...
Iven: You're making me pay to view shows that show ads?
CableCompany: But of course. It's our business model. Hello? hello?

this

It's TRUE/FALSE but of those, only 23 are false.

question: how do I find the 23 FALSE?

(short of using VBA)

IvenBach

10:45 PM

Filter.

mansellan

^

this

blargh. long day. dumb me.

IvenBach