Recent Posts

951

General Software Discussion / email troubles

« Last post by Target on May 12, 2011, 11:02 PM »

hoping someone here may be able to assist with an issue we've just started experiencing at home

intermittent emails are 'hanging' the receive process, ie when an offending email is encountered the process hangs and we cannot download any further messages.

Happens on both PC's at our house (XP SP3 with outlook express, and Vista with windows mail, and now Live Mail).

Stopping and restarting has no effect.

Messages are accessible via webmail, but there is nothing untoward in them that I can see.

None of the messages are large (we're stuck with dialup so anything much more than a meg gets deleted out of hand), and there does not appear to be any consistency between the offenders - the senders, sizes, etc all vary (in fact we received one message from a particular sender fine, but the next one - 24hrs later - failed)

I've checked all the settings (nothing has been changed) and as far as I can see everything should be fine. Beyond this I have no idea how to even begin troubleshooting this

Any ideas?

952

Developer's Corner / Re: Apples, Walled Gardens, and Screw Deals - Oh My!

« Last post by Target on May 11, 2011, 06:46 PM »

However, once something looks like it will really take off big time, all it will take is a rule change to push the innovators out so the big companies can take over and "properly exploit the opportunities" such an emerging "new use" will create.

-40hz (May 11, 2011, 06:28 PM)

seems like this is an 'innovative' take on an old tactic

In the past the big guys paid squillions to buy up the competition.  Apple seems to have come up with a new approach where they make money out of closing the competition, then more money by capitalising on the 'new' opportunities...

953

Living Room / Re: If a tree falls (in c#)

« Last post by Target on May 10, 2011, 05:19 PM »

Remember we had N-1 string * N+1 drinks, making a grand total of 2N-1 (drinks/string whatever) So if N > 10, then we have almost double the string, and way too much to drink.

Remember not to do calculus when drinking though: don't drink and derive :p

-Fred Nerd (May 10, 2011, 04:55 AM)

I'm a bit confused - I've been following the process and all I ended up with was zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

954

DC Gamer Club / Re: looking for some suggestions

« Last post by Target on May 10, 2011, 01:45 AM »

my mom really liked samarost and samarost2.

-mouser (May 10, 2011, 01:00 AM)

yeah I thought of that (actually I saw machinarium in the shops) but I was looking for offline games

and FWIW the idea of her being loose on the net terrifies me...

955

DC Gamer Club / looking for some suggestions

« Last post by Target on May 10, 2011, 12:35 AM »

for some games for my mother in law 

preferably puzzle or platform/side scrolling games, and nothing to difficult (this is for a person who can't remember a 5 character password from one day to the next)

scrollers should be run and jump or run and jump and shoot (no space games)

oh, and they need to run happily on Win7 X64...

I suspect the old Monkey Island series could be a contender (anyone know?), but this is way outside of my normal gaming preferences so I have no idea

956

Living Room / Re: If a tree falls (in c#)

« Last post by Target on May 08, 2011, 09:05 PM »

Actually, I have always found the length of a piece of string to be N-1 where n is the required length....
And my programming also comes up short

-Fred Nerd (May 08, 2011, 09:57 AM)

And the solution to the N-1 string length problem is to have N+1 drinks~!

-Renegade (May 08, 2011, 11:18 AM)

this is not a solution as the only output is 2X(N-1)

957

Living Room / Re: When Growing Online Pressures Backfire

« Last post by Target on April 15, 2011, 01:01 AM »

I'm currently working on a tool that will extract a stack of information from some of our systems in order to build a report whose value i am far from convinced of.

It was someone else's idea, and despite the fact that they're clearly motivated purely by convenience, and that they haven't really thought about either the requirements, the intended audience (minimal input so far, and mostly from another area with completely different requirements), or the possible use/value of the final outputs they managed to catch the attention of our manager, and, well, you know how it goes...

It had been floating around for about 12 months and there were rumblings about engaging a 3rd party to build the damn thing.  Having just seen the 'mock ups' I was rather concerned that we were going to buy a pup, so I said so.  This was interpreted by my manager as a wish to be involved (is there a pattern emerging here?)

To rub salt into the wound whatever I come up with probably won't even be the final solution - looks like another group (a group that 'specialises' in these sorts of apps but which had 'avoided' involvement to this point) will take my workings and use it as the basis of 'their' solution 

958

General Software Discussion / Re: Excel 2007 workbook bloat - potential fix?

« Last post by Target on April 09, 2011, 04:19 AM »

2Target
I had similar issue recently and it appeared that there were few hundred thousands of empty cells added to my XLSX file. Since each one requires proper tags in XML file whole document size was enormous.

I've simply deleted additional rows/cols and it helped. No need for any further magic.

-fenixproductions (April 08, 2011, 03:18 AM)

This is a common issue - it usually occurs when 'someone' enters something in a cell way outside of the used range, though adding formatting to unused cells/rows/columns will do it as well.  The supposed fix is to highlight and delete ALL the unused columns and/or rows and delete them (thus removing the any/all unnecessary content/formatting)

Thanks for posting that.

I've had other Office documents passed to me that were horribly slow to work with. They weren't particularly large (large, but not massive), but just sssssllllloooooowwwww... Did you have any of that in the bloated excel file?

-Renegade (April 08, 2011, 03:31 AM)

no, it was purely data (though there was a bit of formatting that I think is unnecessary, but not in the sheets that were affected).  Watch out for lots of calculations as these can (and will) slow things down enormously (calculations done in VBA are several orders of magnitude worse) - if you think this might be the culprit try turning off the auto calculate function.  There is one bug that pops up a bit in Google searches that indicates something wierd with cell borders.  According to the various post simply removing the offending formatting doesn't work but copying and pasting the content (only) to a new sheet seems to do the trick (YMMV of course)

959

General Software Discussion / Excel 2007 workbook bloat - potential fix?

« Last post by Target on April 07, 2011, 07:47 PM »

It appears that inexplicable bloat in Excel workbooks is a reasonably common issue, so my experiences with this phenomenon may be useful to others

A shared workbook had blown out in size considerably for no reason that I could see (ie from 4M to 33M)

I had already gone through and removed as much unnecessary formatting as I could (it's a shared resource) but it made no difference

Googling didn't turn up anything particularly useful (the main fix seems to be removing unnecessary formatting, which I'd already done), but it did remind me that office 2007 files are zipped xml bundles.

When I opened the (zip) file, I found 2 worksheets were considerably larger than the others (one was 180M and the other was 89M).  AHA! says I

I went back into Excel and MOVED the sheets out, saved, then checked the size, and...no change

I went back into the bundle and found that the bloat had moved to the next sheets (WTF?), so instead of sheet26 being 180M, now sheet25 was 180M.

I made a fresh copy and this time I COPIED the offending sheets out, then went back into the bundle and DELETED the offenders, saved, then checked the size.

This time the file had come back to a more reasonable 4M, so I re-opened it with the intention of copying the deleted sheets back in.

On opening the file Excel threw up a 'this file is corrupted, do you want to repair' message to which I answered yes. After letting it do it's stuff I saved and went to copy the deleted sheets in only to discover that Excel had automagically reinstated them!!

I've done as much testing as I can (the workbook contains data only, no additional functionality) and as far as I can see no data was lost to the exercise, and the aforementioned bloat is now gone (woohoo...)

I can't vouchsafe this method, however it seems to have worked in this instance.  YMMV, so if you're going to use it I would suggest you make a copy of your file(s)  first, then confirm the results yourself before you replace your originals.
   

960

Living Room / Re: unboxing videos

« Last post by Target on April 06, 2011, 09:09 PM »

Not more gallows humour, I'm already at the end of my rope!

check again, I think you'll find knot

961

Living Room / Re: unboxing videos

« Last post by Target on April 06, 2011, 05:41 PM »

As ever, you put the xing back into boring!

-cranioscopical (April 06, 2011, 01:48 PM)

I read recently that hanging is to good for people who pun

they should in fact be drawn and quoted...

962

Living Room / Re: unboxing videos

« Last post by Target on April 05, 2011, 11:49 PM »

unboxing-videos

-Target (April 05, 2011, 05:47 PM)

Better than having to unwrestle with stuff…

-cranioscopical (April 05, 2011, 09:53 PM)

like it mat-ters

963

Living Room / unboxing videos

« Last post by Target on April 05, 2011, 05:47 PM »

I can't believe people actually go to the trouble of actually doing this stuff, but I saw this on how-to-geek this morning

unboxing videos

as it happens, it pretty much sums up how I feel about ewetube

Edited to correct spelling misteak in the subject line

964

Coding Snack Guidelines / Re: IDEA: Remind User a Flash Drive is Plugged In During Shutdown

« Last post by Target on April 04, 2011, 07:19 PM »

another option would be to use Last Chance to schedule a checking routine at shutdown

otherwise it would be relatively easy to do in AHK, though detecting the shutdown request (ie methodology) may be an issue

965

Finished Programs / Re: IDEA: Auto-mount ISO file on doubleclick, copy its contents to a folder...

« Last post by Target on March 30, 2011, 05:38 PM »

It's not automated, but there's a plugin for total commander that allows you to open/view ISO files like any other folder or archive. 

You can't modify the image, but files can be copied out without a problem

I assume this functionality is available in other file managers as well...

966

Living Room / Re: My Movie Fantasy

« Last post by Target on March 22, 2011, 05:46 PM »

I would love to see a horror film that takes place during a sunny warm day with cute, cuddly critters that everyone in the audience loves, but the critters are out to do bad things.

And no flickering lights in abandoned buildings and no rain.

I suppose the closest so far is Lesbian Vampire Killers.

-Renegade (March 22, 2011, 04:02 AM)

when I saw the subject line I thought you were going to go Charlie Sheen on us....

967

Living Room / Re: Ever wondered what happens to all the old hardware when you move office

« Last post by Target on March 20, 2011, 09:27 PM »

Don't love them too much... They'll all be like that once the Zombie Apocalypse arrives on December 12th, 2012~!

he, that day comes hopefully I'll be on the side with all the big guns ('come get some' as someone once said...)

968

Living Room / Re: Ever wondered what happens to all the old hardware when you move office

« Last post by Target on March 20, 2011, 08:19 PM »

thanks App

love those old buildings, though I think that one lost something in the translation - I can't decide if fits too well in it's new context (and loses it's histerical identity), or if it doesn't fit at all

969

Living Room / Ever wondered what happens to all the old hardware when you move office

« Last post by Target on March 19, 2011, 04:26 AM »

this might be a clue (is your old office in here?)

Eerie world of abandoned computers

970

General Software Discussion / Re: Excel - pattern matching in cells

« Last post by Target on March 16, 2011, 07:15 PM »

what is it you want to do, and how are you trying to do it?

is the format of the invoice numbers consistent, ie 3 letters and 3 numbers?

this quick formula will give you a flag

=IF(AND(TYPE(LEFT(A14,3))=2,ISNUMBER(VALUE(RIGHT(A14,3)))),"","XX")

Note that it doesn't properly test the alpha segment, ie WHS and WH2 both evaluate as text in my quick test

Unless you have a consistent naming convention you may need to test each character

and string length may be another test...

971

Mini-Reviews by Members / Re: Mini Review of SugarSync and DropBox

« Last post by Target on March 08, 2011, 04:31 PM »

I always had a 'thing' for Wilma off the Flintstones. But I knew it could never be...

... she'd never leave Fred.

-timns (March 08, 2011, 11:52 AM)

There'd be a Barney were she to do so.

-cranioscopical (March 08, 2011, 01:25 PM)

bam bam...

972

Site/Forum Features / Re: Shortcomings of DC and How to Improve

« Last post by Target on March 06, 2011, 06:22 PM »

Despite this thread's persistance I still can't see that it's produced anything solid (no doubt the OP is chortling smugly to himself)

Other than a general perception that the look and feel of the site hasn't changed for some time so far no one has come up with a single thing that 'needs to be fixed', or with some 'must have' functionality that we currently don't have.

That's not to say that there aren't things that might be done better, but changing things in order to maintain an illusion of progress is pointless (don't forget that the lions share of the work involved in doing any changes will fall to just a couple of people).  

I think the idea of a poll/survey is a good one - lets drag this out into the sunlight and see whether or not there's really an issue here (after all, it really is an issue for the community to decide).  

973

Living Room / Re: A Point About Grammar

« Last post by Target on March 02, 2011, 07:26 PM »

Their language buffers in their brains are too small, and they can't double buffer, so you get choppy playback.

-Renegade (March 02, 2011, 07:24 PM)

so it's an issue of blandwidth?

974

Living Room / Re: A Point About Grammar

« Last post by Target on March 02, 2011, 06:33 PM »

the trouble with interpretising grammatical expression is that so much of it is contextual, and what is correct in one context is incorrect in another.

To use Stoic's example 7 chairs are countable or mass, whereas furniture is not.  But if you were referring specifically to the chairs you wouldn't say furniture, even though it is potentially correct.

975

Living Room / Re: A Point About Grammar

« Last post by Target on March 02, 2011, 05:23 PM »

unfortunately we've come to accept that close enough is good enough, instead of saying that's wrong, do it again

("speliing"?  luckily I knew what you meant )