The Official Status Thread
-
!
Engine is probably a little out of control at the moment.... adding to the timeout corner...
-
Status: Working from the former intern's computer again. The IT guy who worked on upgrading my machine didn't get the stuff from my profile folder correctly so it completely trashed my login in Windows 10, so it's being restored back to Windows 7 and bring tried again (by the other IT guy, who has done this before).
-
-
Status: representative database table
-
That has to be my favorite way to convert a count to zero-index ever. </sarcasm>
-
Ark: Survival Evolved
is one that comes out from the top of the head.My son has that in his shared library. Maybe I shouldn't try to play it on my 6GB machine.
-
Status: Excel is so mad at me right now....
Calculation is sucking because we'reSumProduct
-ing over 25k rows, and deleting junk data so the calculations can work is sucking because 32-bit? Idk. It's taking about half an hour to clear out junk records...
-
Maybe I shouldn't try to play it on my 6GB machine.
You can try. I think there was a command-line switch to kick it into "low memory mode" or something that "should" help, if you run into problems...
-
Numbers tables are handy. I have one that goes to 100 million.
-
Status: Making lunch. So far, the ground beef more nearly resembles red granite than anything edible.
-
looking for just one more quarter
Sure would be nice if they could keep the damn dollar-bill accepters working, right? My building's soda machine, you can use coins or a credit card; the other building, that takes bills all the time, has more people, so it's usually out of Coke[1].
[1] as opposed to coke.
-
@Tsaukpaetra said:
What you do with your blue balls is all on you,
..... ICK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1!!!!!!!!!!!!!!!!!!!!!!!!
Is it any better if it's on someone else?
-
Why don't you use interop to read the data out into a nice C# program or something and do the calculations there?
-
Because interop is awful.
Why don't you save as CSV and do the processing with a real language?
-
Why don't you
Lacking the tools/knowledge needed to do so.
Essentially the logic goes "Is this the first time we've seen this happen for this account"?, across three columns (which have different criteria, including "is this the first time I've seen this account at all?")Why don't you save as CSV and do the processing with a real language?
Then it's not contained in one neat-o file that does everything at the click of a button. I guess?
Filed under: This project has long outlasted its' 6-month lifespan...
-
IDK, TypeHandlers are quite nice.
See also: Booleans that can be Y/N/y/n/1/0/null/Yes/No
<inb4
-
You should add an order by, you never know when SQL might decide to give those numbers to you in a different order.
That sounds like a joke, but it genuinely isn't.
-
Because interop is awful.
Nitpick. That's just the first thing I thought of. "Read CSV into a C# or whatever program" is fine and--for the purposes of this discussion--functionally equivalent.
Why don't you save as CSV and do the processing with a real language?
Well, I personally don't enjoy writing CSV read programs.
-
Lacking the tools/knowledge needed to do so.Essentially the logic goes "Is this the first time we've seen this happen for this account"?, across three columns (which have different criteria, including "is this the first time I've seen this account at all?")
If you have to do this more than a handful of times, the odds are you'll eventually save enough time that it'll have been worth learning how to do it. In spite of my last comment, writing a program to read in a CSV's not terribly difficult--although in Progress, it's literally, define a bunch of variables and then put a read statement like
import stream my-csv delimiter "," var1 var2 var3 var4.
Then you bung stuff into a set of array/lists[1] and process when you're done.
[1] Sure, you could create an object or use a DataSet or something more complex. If all you need to do is some basic manipulation it might be more effort than it's worth.
-
uhm, the "CSV reading" part of your program should be resolved. if not, change plattform now
-
-
uhm, the "CSV reading" part of your program should be resolved. if not, change plattform now
Never done it in .Net, actually. Is it literally as easy as my one-liner above? (To be fair, that's just the read statement. A full program to read stuff into a temp table (ignoring the part where you actually process data) would look like this:)
define stream my-csv. define temp-table tt field tt-number as integer field tt-result as integer. input stream my-csv from value("blargle.csv"). repeat: create tt. import stream my-csv delimiter "," tt-number tt-result. end. input stream my-csv close. for each tt: /* do something with the current row */ end.
-
more than a handful of times
Yeah, I did it once for a project. Any since the project continued, the file grew beyond the anticipated growth of the original scope, so the messy formulae started failing (If I'm thinking this correctly, the formula ends up as a o(4*n^2) operation).
It was never meant to be this big. Luckily, it generates a lot of fluff data, so deleting that stuff left me from 25k records to 7k records, which is all we need (for now).
-
something that turns out to be a shiny blue ball....
WTF?! why would i have that in my desk?
@PJH, stop stalking people.
-
It does have an index.
-
-
-
-
The Windows one is. I also have an Ubuntu machine named australium and a dhromebook named daisy.
-
i don't remember how you do it in .Net.
but in PHP it's like this:<?php $csv = fgetcsv('blargle.csv'); foreach($csv as $row) { foreach($row as $column) { // do something } }
i think .Net had something to load csv's like that too
-
Status: I'm one very happy boy now.
-
So you're sure it isn't some kind of mutant trackball?
-
if it is it's not mine. my trackball is a solid 2" diameter, not a 1.5" diameter
-
Hence 'mutant'.
-
Well, there you go, then.
-
dhromebook named daisy.
I know another computer that likes your dhromebook:
-
Status Wondering why Windows 10 only gives me the following options for date display
I am in the UK, can I not have d/M/yyyy? Why only give me one option in the right order, and make it look like balls?
-
Status:
-
Status: …yeah, there's no hiding the fact this is an automated e-mail. And it's 15 days early.
-
-
an automated e-mail
Clearly, they care!
It was too difficult for him to determine the Long Date format from the Short Date format?
-
What the fuck? What settings do you have to get that to work? I'm set to the UK in the regional settings and it still gives me the fucking American style dates!
-
It was too difficult for him to determine the Long Date format from the Short Date format?
It's more how we both have our systems set to UK, yet get different date format choices.What the fuck? What settings do you have to get that to work? I'm set to the UK in the regional settings and it still gives me the fucking American style dates!
UK settings; what else would I have? ;)
-
yet get different date format choices.
Must be on a different update level then?
Also, NoRepro:
;)
Edit: huh, pressing Ctrl-Break closes this particular window. Who'da thunk it?
-
Status: Discourse seems to be pretty peppy at the moment!
-
Got it! It is the language pack. Despite being set to UK settings, Windows decides to ignore those and just use the language pack to decide what region settings it will show you. Remove the US English pack and it works. FFS, things are never simple are they?
-
things are never simple are they?
Indeed not. I only have English US installed, yet it worked for me in the way you wanted.
'Tis odd indeed.
-
Status: In IRC, how does one test that a user-user message was received or not? What about messages that are sent to (probably) offline users?
Darn edge cases!
-
What about messages that are sent to (probably) offline users?
The server returns an error that the nick doesn't exist.
-
The server returns an error that the nick doesn't exist.
Huh. It seems server info message like that aren't (currently) being logged...