pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|

Why the f**k not eh? Like old times.
Got some hideous powershell to write today that is going to export our SIMS calendar to a public Office365 calendar and then update an .ics link on our website.
What's everyone else up to?
|
IvIarkgraham
Premium Member
Registered: 27th Mar 04
Location: Ellesmere Port, Cheshire
User status: Offline
|

just been to the gym now going back to bed
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
I wanna go back to bed, saw every hour last night
|
johnny86
Premium Member
Registered: 15th Feb 10
Location: in a bus stop.
User status: Offline
|
just woke up.
There hasn't been a morning thread in ages.
Plan for today is badger beardy to get my car back. Haha
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
Wouldnt mind that script when youre finished
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Lol gotta work out the the best way to do it yet!
|
Mike
Organiser: North West and North Wales Premium Member
Registered: 20th May 06
Location: nr. Skipton, North Yorkshire
User status: Offline
|
Morning 
Been a while since I've seen one of these.
|
Marc
Member
Registered: 11th Aug 02
Location: York
User status: Offline
|

Eugh. Spent all day in bed yesterday after being out drinking rum all night. Not big, and not clever.
|
johnny86
Premium Member
Registered: 15th Feb 10
Location: in a bus stop.
User status: Offline
|
quote: Originally posted by Marc

Eugh. Spent all day in bed yesterday after being out drinking rum all night. Not big, and not clever.
I had a night on the piss the other Weekend. Only stuck to vodka like I have for years and I experienced my 1st 2 day hangover. Needless to say drinking is getting calmed well down.
|
Gary
Premium Member
Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
|
Stayed in the pub too long yesterday. Feeling it today. Not good.
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
quote: Originally posted by pow
I wanna go back to bed, saw every hour last night
The Cat-Aids medication will do that to you
|
Ian W
Member
Registered: 8th Nov 03
Location: Wirral, Merseyside
User status: Offline
|
quote: Originally posted by johnny86
quote: Originally posted by Marc

Eugh. Spent all day in bed yesterday after being out drinking rum all night. Not big, and not clever.
I had a night on the piss the other Weekend. Only stuck to vodka like I have for years and I experienced my 1st 2 day hangover. Needless to say drinking is getting calmed well down.
Had my first 2 day hangover after drinking a few bottles of wine a few months ago, fuck me I wanted my head chopping off it hurt so bad
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Beginning to get there, love a bit of powershell. Why is it you always end up stumbling on a bloody date/time format or some rubbish like that.
|
Leighton
Member
Registered: 21st Feb 01
Location: Liverpool
User status: Offline
|
Erm Pow! the morning thread needed to be started at 8: 00 exactly i think you will find 
[Edited on 15-06-2015 by Leighton]
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
quote: Originally posted by pow
Beginning to get there, love a bit of powershell. Why is it you always end up stumbling on a bloody date/time format or some rubbish like that.
Try and stick to using ISO formats
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Once again I'm hampered by the output from the MIS system, which is:
Date,Time
19/06/2015,09 0
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
No string altering functions in PS?
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
Any good? https://technet.microsoft.com/en-us/library/ee692801.aspx
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
It would be grand if I want using the current date. But I'm importing from a CSV
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
There's got to be something you can do with it
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
It's really weird, it just won't do anything with the variable while going through the CSV file!
[Edited on 15-06-2015 by pow]
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Nailed it. Fully automated using Exchange EWS and SIMS command line tool @
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
And now it's a scheduled task on a server running at 2:30 every morning. Published an HTML page on our website (Static link) and also an iCAL file so it can go on anything!
|
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
|
You'd have been better off writing some PHP that reads the CSV file
|
spencer88
Member
Registered: 6th Oct 08
Location: cornwall
User status: Offline
|
Off to the Guinness factory, then around Dublin.
|