Tip o’ the Week 474 – Parse and Flow

Posted on April 5, 2019 by ewand

Microsoft Flow was introduced a couple of years ago, and covered in ToW #401; it’s basically a glue between different online applications, allowing the exchange of data between them and being driven by events and actions.

Sign up, sign in, and when you go to create a new Flow, you can start with a blank canvas, or by customising a pre-built template, of which there are many.

Learn how to build Flows here.

Many of the templates for Flow are quite esoteric – when a tweet on a particular topic appears, write a log to a Sharepoint site and send a notification to a Teams channel, that kind of thing. But there are plenty of really useful connectors that can be combined in time-saving ways; here’s a really handy way of bringing traditional data sources into the modern era: an email parser, called Parserr.

After signing up with Parserr – free if you only need a few uses per month – you can then crack open mail that is consistent in format and contains some information you’d like to extract and use elsewhere, such as confirmation of an appointment or maybe a travel booking. In practice, you get given an inbox with a unique email address within Parserr and you’d set up a rule in Office365 or Outlook.com to send mails that meet some inbox rule to that address, where it would be parsed for you and key data fields then sent back to Flow.

e.g. if email comes from a specific source address or it has a subject that indicates it’s a particular type of reservation, then forward to your nnnnn@mg.parserr.com inbox address, extract the details of the booking then do something with them within Flow.

Start by sending an example mail to your Parserr inbox, then you can define rules to identify content within it (by looking for set keywords, going to specific line numbers and so on).

Create a rule for each piece of information you want to extract, and it will effectively create a field:

Once set up, you create the Flow by choosing the connectors for Parserr and whatever other applications you need to work on the information.

In this example, we’re using Office 365 to create an appointment that matches a reservation – the arrival and departure dates are provided by the source email, and converted to YYYY-MM-DD format within Parserr, then dragged across in Flow to match the Start & End times of an “event”. We’ll tack on T16:00 to the arrival time and T10:00 to the departure as that’s the check in and check out times, and thus create an ISO8601-compliant date/time such as 2019-04-05T08:00, which Office365 will use as the start or end time of an appointment.

“Advanced options” gives you further control (such as adding body text that might contain static text and other fields provided by Parserr, other addresses to forward the invite to, setting if you want it to be free/busy/tentative, reminder duration, time zones etc).

And that’s it: you can test the logic is working within each system – in Parserr, you can continually re-run the processing of your initial sample mail until you know the data is being extracted as you’d like, and within Flow you can keep testing your formatting etc by either triggering a new input or by working with the last set of data that came over from the source.

Once you’re happy just save the Flow, and it will automatically create an appointment in your calendar every time you get a matching email forwarded to the Parserr system – all in a few seconds.

See more on using Parserr with Flow and here’s a worked example.

Tip o’ the Week 473 – Teams Shortcuts

Posted on April 5, 2019 by ewand

Many people who rely on the same applications to do repetitive tasks, will want to learn quicker ways of doing them – and use shortcut keys to good effect. Shortcuts have been covered in ToW previously – eg. how to start modern apps quickly, or navigating between running apps.

As world+dog moves from internal corporate email to Teams, Slack etc, it’s handy to know how to get the best out of the new messaging environment. Before abandoning Outlook already, here’s a reminder of some especially useful shortcut keys:

CTRL-2 – jumps to Calendar; useful if you’re in mail and want to quickly check something in the diary.
CTRL-1 – sets focus to “mail” – whatever folder you were looking at before moving away to check your calendar etc. CTRL-SHIFT-i will jump to your Inbox regardless of where you are in the UI (eg you might be in another mail folder, or looking at Calendar/Tasks etc)
CTRL-3 – jumps to Contacts (or “People” as Outlook now calls it)
CTRL-4 – jump to Tasks.
CTRL-5, -6, -7 and -8 will take you to long-dead Outlook features. Try them. Take a teary trip down memory lane.

And there are lots and lots more.

When it comes to using Teams, one of the most useful shortcut tips is essentially the same as the Outlook set above – CTRL-number takes you to one of the nodes on the side-bar that corresponds to the number from the top – eg CTRL-4 will jump to Meetings, which is handy if you have Teams calls in you calendar and want to join the calls from there rather than Outlook.

Incidentally, if you normally go into an appointment in Outlook and click the “Join Teams Meeting” link in the text body, you may tire of continually telling Outlook that yes, you did mean to switch applications, and it’s OK, you already have the desktop app…

Click the “Join Teams Meeting” icon on the Ribbon in Outlook instead, and you’ll skip this. If you’re super-skilful then you can jump straight to that command without lifting your fingers from the keyboard – just press the ALT key and you’ll see shortcut letters appear under each of the sections of the Ribbon; press the corresponding one (“H” if you’ve opened the meeting up in Outlook already), and you’ll then see a letter combo that will activate the Ribbon commands – Y1 in this case will jump straight into the meeting.

There are many other shortcuts in Teams, with varying degrees of usefulness. Customising the UI is still a bit clunky (eg you can’t add shortcuts straight to the sidebar or move items on it up and down) but you may be able to find a quick way of doing the things you need most. To see a summary of shortcut keys whilst in teams, just press CTRL-. (ie CTRL and full stop/period ‘.’).

Tip o’ the Week 472 – Update Store & Office apps

Posted on April 5, 2019 by ewand

We’re all used to Windows Update or other software automatically downloading and installing updates (on phones, TVs, cars…). Sometimes the updates are at more of a leisurely pace than keen users might want though occasionally the recipients demand to hold back the updates until they elect to install.

The Windows 10 October 2018 is now being pushed to (nearly) everyone, though business users will have the option of pausing Windows Updates in case they want to enact a temporary delay for some particular reason – you’re about to go on a trip, for example – though it’s not meant as a centralised policy control: IT departments have other ways to do that. Windows 10 Homes users will soon get the ability to defer updates for up to 35 days, too.

How often applications update themselves is largely down to the publisher, but it’s usually possible to give the apps a prod to see if there are published updates before they get pushed out to you.

In the Microsoft Store app, for example, go to the ellipsis menu on the top right. You’ll see Downloads and updates, which will force the check for updates for all your installed Store apps. Even if you’ve turned on the automatic app update checks, it’s worth taking a look periodically as some of the apps you use most often might have updates pending.

If you find that most of the stuff you’re offered is updates to boring apps that you don’t use, then you could just wait for them to fetch their own in time. If, however, you spot an individual update to an app that you know you want to have the latest version of, then click the down arrow to the right to get it right away, or click the app name to look at its page in the Store and see what’s new.

Of course, non-Store apps may still offer their own updates directly – to check for updates to the Microsoft Office suite, for example, try going into Word (or Excel or PowerPoint if those are your most-used Office apps) and from the start screen that offers a few previously-opened files, templates you’ll never use etc, look to the bottom-left and you’ll see Account.

Click Account to go to the product information page, which will let you check for updates, show you the current installed version number of the the application, and maybe even let you sign up for more updates through the Insider program.

After you’ve installed any pending updates, the What’s New option will be active and will show you a summary of what has changed, in a pane within the app itself.

Or check the View Updates option at any time, and it’ll take you to the web to see what the latest updates contain.

Tip o’ the Week 471 – Buying stuff at auction

Posted on March 22, 2019 by ewand

As the web turns 30 and its role in the End Of the World As We Know It starts to become more clear, it’s worth reflecting on how the technology has disrupted more traditional businesses, sometimes ironically turning them on their head before turning into them.

One literally dusty and old-school business that is reinventing its traditional method, is that of the auction house. As any Brit hooked on Bargain Hunt or Cash in the Attic might attest, the auctioneer will let any amount of old toot pass under their gavel on the basis that they’re making some commission from the seller and gathering a not-insubstantial buyer’s premium from the successful bidder, too.

ToW#359 covered auctions a while ago, and covered some strategies in making sure you get the best deal.

It seems that the auction market is growing, and not just in high value art or fancy motoring. If you go to the saleroom of a bricks & mortar auctioneer these days, there is likely to be at least as much bidding action coming in online as there is in the room, but it’s all dealt with in real-time by a real-life master of the hammer, even if at some places and times nobody knows what they’re actually saying.

So, as well as perusing the ‘Bay for used stuff to fill your abode, and looking on Gumtree / Craigslist for clutter that’s not only cheap but nearby, it’s worth searching on some sites who provide aggregation services to real auctioneers, listing their catalogues online and providing real-time online bidding too. For a small fee, of course. Examples include The Saleroom, EasyLiveAuctions, iBidder or Invaluable.

You may want to look for your quarry on any one – or all – of the platforms, find an item you like, have a look at the photos etc, then go straight to the auctioneer’s own website and make a commission bid. These are entered on your behalf by the auction house, supposedly only high enough to win the auction unless you’re outbid. In practice, if you put a commission bid of £200 for something because you can’t attend in person or be online live to watch & interact with the auction, then be prepared to secure the item for £200… plus maybe 28% buyers premium, and a hefty charge for post and packaging if you’re not nearby enough to collect in person. Still, you might save the 6% or so that an aggregator would charge on top.

In truth, buying most things at auction is a bad idea: there’s little to no legal protection and if the thing you’ve bought it a dud, then it’s on your head to fix it. Many bidders at auctions are dealers themselves, and they’ll have a canny eye for what to get and what to avoid – and their “good” stuff will end up in their antique shop, with a 100% mark-up, or it’ll be cursorily cleaned up and shoved on eBay.

You’d be better off finding the people directly with things to sell if you can, or ferret around in a charity shop; for some goods, like watches, there are free aggregators (the likes of WatchRecon or WatchPatrol) who scrape all of the private “for sale” ads and let you deal directly with the vendor, rather than going through a middleman like an auctioneer or eBay. For cars, there are both free and paid-for advert platforms (eg ClassicCarsForSale, PistonHeads) that make it easy to find either the dealer or private owner who’s selling up.

Selling via auction doesn’t make too much sense a lot of the time, either – you’ll pay fees and you’ll be reliant on them bothering to describe and photograph your item properly, and put some effort into talking it up on the day.

Here’s an example of a consignment to an auctioneer – a box of books, with titles like “A Fortune in your Attic” or “Treasures in your Home”.

The box sold for £2.

So, if you’re buying cheap rubbish, then don’t think twice about which platform you use.

If you’re buying Paul Newmans, though, it could even be worth flying in and doing it in person.

Tip o’ the Week 470 – Chrome Activities on Time

Posted on March 22, 2019 by ewand

As many of now know, the Edge browser in Windows 10 is going to change.

In short, the browser application will be rewired to use the open-source Chromium rendering engine, meaning that Edge will be every bit as compatible as Chrome is in displaying web pages and apps. It doesn’t mean that Edge will look and feel the same as Chrome, though – if the latter is a skin on the Chromium engine that provides a load of additional functionality, so Edge will be a different skin but will look and act much the same as it does today.

For now, at least, there are a lot of Chrome users on Windows 10 and various teams at Microsoft have gone to some lengths to build Chrome extensions to support other services or software, maybe in the same way they work on Edge or even beyond. See here for a list of Chrome extensions published by Microsoft.

One such extension was published recently, which allows the activity that a user is doing in Chrome, to be published to the Windows Timeline feature.
Install the Activities extension here.
(assuming you’re using Chrome… Edge users who just clicked on that link, go and have a word with yourselves).

After installation, then any browsing you do in Chrome while will show up in Timeline – press WindowsKey + TAB or click the Timeline button that is generally found next to the Start button on your taskbar, and use the slider at the side to jump to a particular date, or click the search bar on the top right (keyboardistas, just press CTRL-F) and search for a keyword within the content you were browsing earlier.

It’s a fantastic way of searching not just browser history, but other activities – like Office docs or many Windows apps.

Look under the icon for the Activities extension, and you can choose which browser you’d like to use to open the tile from the Timeline – in the example above, a Google search within Chrome took us to a content page, and clicking or tapping that tile will re-open the website.

So, if you’re currently using Chrome under sufferance but would like to keep most of your browsing in Edge, having browsed in Chrome and gone back to the Timeline, it will give you the option of using your default – Edge – or using the other one, er, Edge…

Tip o’ the Week 469 – To-Do Files and Accounts

Posted on March 22, 2019 by ewand

ToW has featured Wunderlist and To-Do on a number of occasions; it’s good to see new functionality being added to the To-Do app & service, and the hits just keep on coming. If you haven’t tried it out yet, get To-Do from the Store, or just play with it online. Install it on your phone, too – fruit | robot.

Recently, the Windows To-Do app was updated with a couple of key features, including the ability to add files (up to 25Mb in size) to items – though not yet if your list is shared.

It’s also now possible to add multiple accounts to the Windows To-Do app; so you can have several Office 365 or personal Microsoft Accounts – and switch between them without needing to sign out and in again. Maybe something that Teams could aspire to…

To keep up with further news, check out the To-Do blog, or the Twitter account.

Tip o’ the Week 468 – Get Office, My Office, Office app appears

Posted on March 22, 2019 by ewand

For a while now, new PCs have been installed with an app that “encouraged” users to install and use Office. Even users with Office already installed sometimes complained that Get Office was nagging them to, er, Get Office.

Get Office became “My Office”, which was a lot more useful in the sense that it was showing documents you used etc, but its main aim appeared to still be to help you find and launch Office apps, or buy them if you’re not already using them.

The latest incarnation – simply called “Office” – moves the game on a whole lot more. For one, it’s a portal into all the Office documents you work with on your machine or online, allowing you to search content across not just the docs themselves – so you can search for documents in your most-recently-used lists, something that the File dialog in Word/Excel/PowerPoint annoyingly won’t do.

The search bar also reaches across SharePoint sites you use, OneDrive locations you have and even brings in the global address list so you can get to people details really quickly, including a really fast org chart ability.

The new Office app will be delivered automatically for a lot of people as it will replace the My Office and Get Office apps in due course; if you’d like to check it out sooner, go to the Store.

See more about the app here, or here.

Tip o’ the Week 467 – Gardyloo, It’s the News!

Posted on February 15, 2019 by ewand

Edinburghers will know of the term, “Gardyloo” – perhaps a corruption of a French warning that “water” was about to need avoiding, like dodging the gutters in Blackadder. As well as regarding the loos, it’s in everyone’s interest to make sure your source of news is clean and fresh. Not fake.

A startup called NewsGuard hit the, er, news recently, after launching a service that uses real journalists to assesses sources of news, and scores them on various criteria on how they source, handle and attribute the stories they report.

The Mobile version of Edge browser was updated in January 2019, to include the NewsGuard plugin (though it wasn’t enabled by default), and at the time it was widely reported that their vetting had decided the UK’s Daily Mail, a popular newspaper and at one time the largest newspaper website in the world, was not to be trusted. (Screenshots above & right were taken on 24 Jan 2019).

More people probably read about the warning that was gleefully propagated by the Mail’s competitors, than there are actual users of the Edge mobile browser itself (if you use Edge on your PC, give it a try on your phone – it’s really rather good).

If you’d like to add the NewsGuard addin to the Edge browser on your PC, go to the Settings menu (…) on the top right of the Edge toolbar, and look under Extensions – then find NewsGuard in the Store to add it to the browser from there.

NewsGuard has since worked with the Daily Mail and decided that it’s not quite as bad as all that, so has backtracked and removed the klaxon warning.

It’s still not giving a completely clean bill of health – see the “nutrition label” – but the feedback NewsGuard has shared with some other news websites may well help to improve the quality of their output.

The same extension is available on other browsers too.

Tip o’ the Week 466 – Mobile Teams Tips

Posted on February 15, 2019 by ewand

Teams is more than just a replacement for Skype for Business on your PC, it’s also a consummate mobile app that functionally eclipses its predecessor in many ways, and even its desktop sibling in some. If you haven’t installed the Teams mobile app on your phone, go and get it (and other Office apps) for Googly Devices or Fruity Phones. The remaining Windows Phone users can follow the setup link here, though be prepared for disappointment.

The “Calls” tab on the mobile version on the app is more usable in some senses than Calls on the PC version of Teams is, since it exposes phone numbers more easily. On the desktop Teams app, if you want to use the service to call an existing contact via the POTS, the actual phone number you use can at times be somewhat obscured.

On the PC app, for example, if you look at History, you’ll often seen a list of people but it’s not clear which number they called from (or you called them on), and you’ll need to use the Contacts list within Calls to be able to direct a new call to a specific number.

In the Teams mobile app, if you look at the Calls tab, under History, tap on a line and then the card to the right side of the list of icons, you’ll get a contact card and the ability to respond back – using Teams – to any one of the listed phone numbers.

Under Settings, you also get a bit more direct control over do not disturb functionality with quiet hours and days.

Finally, one of the great new functions in Teams mobile is the building-in of Org Chart functions, so you can browse the global address list hierarchy while on the move (assuming such info is populated in the directory).

Just search for a contact’s name, and their organisational tree is only a tap away.

For more tips on using Teams Mobile, see here.

Tip o’ the Week 465 – Cortana, remind me To-Do sync

Posted on February 4, 2019 by ewand

The ongoing post-Wunderlist improvements to To-Do, continue apace. The app has been updated again recently, to include a bunch of additional functionality, like Cortana integration.

In fact, the Store listing name for To-Do is now appended with some additional context of what it can now do, at least if your language is English and you’re in US, UK, India or Australia.

By asking Cortana to remind you of something, she’ll add it to your Outlook Tasks and To-Do reminders – if you’re set up that way – and you can manage lists within the To-Do app itself, or access the same To-Do Lists or Reminders from within the Cortana Notebook.

You don’t even need to go into the Cortana UI (or say “Hey Cortana”) to add things to be reminded – any app that implements Share functionality, like the Edge browser’s Share page toolbar command – will let you target Cortana Reminders.

You can set a reminder time, which will then sync to Outlook Tasks and on to To-Do, if you’ve set up Office 365 or Outlook.com integration, and will trigger a reminder using those mechanisms (get ready for toast overload…) Alternatively, get Cortana to ping you when you arrive at a place or next talk with a known contact.

Cortana’s past tells a good story, and her future is changing somewhat – after deciding to stop positioning her as a potential competitor to Amazon Alexa or Google assistants, a forthcoming release of Windows 10 will break the bond between Windows Search & Cortana, and the voice prompts from Cortana during Windows Setup will be silenced when installing a non-Home version of Windows too.