P Squared Myriad Upgrade from v3 to v4

Below is a little document I made up after upgrading the Myriad Playout system at Hospital Radio Chelmsford (www.hrc.org.uk). It uses SQL Authentication as the method of linking to the database rather than windows authentication but this should not be a problem for station running less that 10 playout instances.

Hope you find it useful for your install.

Software Needed:-

SQL Server software (SQL 2008R2 Standard or Express recommended)
SQL Native Client software (needed for each workstation – 32bit version) sqlncli_x86.msi
Latest P Squared Full Release software i.e. Myriad Playout / Myriad Autotrack (along with relevant licensing details)


P Squared Bootstuff software to auto launch software on completion of set tasks i.e. server share available.
Firewall Exceptions batch file from P Squared Forum – http://forum.psquared.net/6688/SQL-Firewall-Exceptions


1 – Backup all of your ‘Myriad’ folder contents.



1 – Run Windows Update to ensure server is up to date.
2 – Install SQL Server software
2.1 – Recommended practise is software installed on system (c:) drive and data directories location is set to D: drive i.e. d:\psquared\myriad.
2.2 – Create user in Management Studio with sysadmin and public rights
2.3 Run Windows update again to ensure SQL server software is up to date.

Autotrack Workstation (recommended to install Autotrack before Playout)

1 – Run Windows update to ensure machine is up to date.
2 – Install Native SQL Client software on machine
3 – Install Myriad Autotrack
4 – Connect to SQL server using SQL Authenication with user details you created on server (this allows anyone to log onto windows on the machine and it not affect the access to the Database).
5 – Once Autotrack is installed and licensed go to File – Import/Upgrade Database and choose your Autotrack Database found in the ‘Autotrck’ folder on your server. This upgrade can take some time and your system will look like it is not responding but just leave it alone!
6 – Run the user importer tool to import your current v3 users.
7 – Run the application and ensure it loads correctly and click on ‘allow’ to any firewall requests. 8 – Run the firewall exceptions batch file on workstation.

Playout Workstation

1 – Run Windows update to ensure machine is up to date.
2 – Install Native SQL Client software on machine
3 – Install Myriad Playout 4 – Connect to SQL server using SQL Authenication with user details you created on server (this allows anyone to log onto windows on the machine and it not affect the access to the Database).
4 – Run the application and ensure it loads correctly and click on ‘allow’ to any firewall requests. 5 – Run the firewall exceptions batch file on workstation.


1 – When entering the server details do not leave anything of the pre-existing text before /SQLExpress. If your server is on a domain you may need to enter the whole domain string rather than just server\SQLEXPRESS.

2 – Don’t forget to install the Native Client software else things just won’t work.

Simple Audio Recorder

With the installation of our newsroom software we needed a simple recorder for use by the News team to record audio cuts and so I visited my friend Charlie’s Site to see if he had something suitable and he does. It is called ‘Urecord’. You can use F keys and also some other shortcuts keys to create a new recording, record and stop recording, play, top n tail the audio and save it. It records as .wav files and it really is nice and simple to use. Charlie and I are working together to improve it but if you are looking for a simple audio recorder for your studio I can recommend this and for only £15 it is a bargain.


Nextrad.io write up

Last week I attended the Nextrad.io conference at the Magic Circle in London. As with most radio things I attend I have various hats on when listening to people talk. I have my BBC World Service hat on most of the time but I also have a Hospital Radio hat on having been involved in HR for over 20 years and I also have a podcasting hat and general radio loving hat on too. So I was greatly looking forward to this event.

It was designed for people who ‘do’ radio and I would say I ‘do’ it in various places. The talks were short, either 9 or 18 minutes long. This meant a packed programme. Here are some things I took from the event.

Nik Goodman spoke about the Top 5 things that work in radio across the world – Entertaining, Emotion, Creativity, Storytelling, Honesty are the things I got down. It was an enjoyable talk.

Francesca Panetta from the Guardian Audio team spoke about why podcasts are different from radio. I have podcast since October 2005 and although have been quiet with my podcasts recently is something I am interested in still. Her main points were

  • You don’t need to follow the old ‘cue – package – backanno’ style of radio presentation.
  • It can be brave
  • It’s in stereo – most of the time you are being played on headphones
  • Treasurable
  • A Space for Innovation

Steve Martin (who I have a bizarre relationship with, having done some work with him in the past and have spoken to on the phone but he doesn’t know what I look like in public yet we work in the same building) did a talk about Creative Perils which he has put on his website was enjoyable and made me think about promotions in radio.

The Prison Radio association spoke about their work in the UK and it was an interesting talk and one I could turn around to my work with Hospital Radio. They had some targets for their radio.

  • Make them think
  • Make them feel inspired
  • Make them feel emotional
  • Mark them feel good
  • Mark them reflect
  • Mark them dream

Paul Chantler (a man who employed me once but probably didn’t know he did) spoke about Libel and Slander which although not a sexy subject did make me think about the way many Hospital Radio stations probably break these rules all the time and that they need to be careful – perhaps I should ask him to attend an HBA conference?

Steve Ackerman from Somethin’ Else spoke about the company and some of the projects he has been involved in and it was refreshing to hear about audio being used outside of radio. As a technical sound person it also gave me a little view as to something else I could do with my audio/radio skills outside of the BBC. They have worked on a iphone app called Papa Sangria and did some work with Wrigleys on a game called Nightjar – both of which are audio based games.

The final session which made me write things down was from Dick Stone. All about prep and he has written this up on his blog here so again won’t recite it.

I must also mention Mark Channon who did a session all about remembering things. This was a breath of fresh air and acted as a good ‘wake up’ session during the afternoon.

Conclusion – it was an enjoyable day and I did learn some things I could take with me but I think mostly it showed me what else is going on around the industry. It is quite easy to remain enclosed within the BBC bubble but in these changing times it is important we all look out else we could find ourselves outside the school gates without any friends. Hopefully another one next year.

Emailing files into Myriad

** This is only of interest if you are a user of Psquared’s Myriad System **

As part of my work for Radio Scilly I was asked to investigate who to be able to email files in and them be sucked into Psquared’s Myriad system. We also wanted the ability to upload something to dropbox also.

We have already setup some automatic downloads of syndicated programmes so had already been using the Psquared Audio Wall Auto Importer which seems to be a pretty stable piece of software now.

Here is the process I set-up
1 – set up new email address ‘sendaudiotomystation@gmail.com’ for example
2 – download GearMage’s software Email Attachment Downloader
3 – configure it to access your new gmail/email server (would suggest you get it to move the file to another folder once it has downloaded the attachment). This then downloads the attachment to a folder location you set (for our use this was a dropbox folder)
4 – configure the Audiowall Auto Importer to look at this dropbox folder for new files which begin with the cart number you want to use on the Audio Wall. Make sure you get it to delete the file after import else it will get in a loop.

That’s it. There are dangers involved if you do not restrict the cart numbers and you may also want to configure the email attachment downloader to only download messages which perhaps have a secret code in the subject line of the email as a way of safeguarding your system as once the email is sent it is purely an automated system from then on. I have the Auto Importer email on success so I know if it has worked or not.

If you didn’t want to bother with the email then you can upload it directly to the dropbox folder itself but the email way could be useful if you were at an internet cafe and didn’t have dropbox installed.

*** UPDATE ***

I have found that the Email Attachment Downloader sometimes stops working so I have found http://sendtodropbox.com/ which creates you a special email address and will send any email with attachments to a specific folder on your dropbox account. So if you attach a .mp3 file it will put that into the folder.

Quick Overview of Marantz PMD620

A very quick overview of the PMD620. Useful if you have already setup the profiles and you are just wanting to go out and record.

Radio Presenters: Tools for reading stuff from the web on air

So with the ability to surf the web whilst on air in most studios I thought I would share some web-tools you can use which may make reading text from website easier to do whilst on air. Now of course plenty of people will say “well you should edit the text and make it more radio friendly” but sometimes you either can’t be bothered or you run out of time.

So the first tool is called ‘Readability’ and is available here. You setup readability on the site and then create a bookmark for it (it works with safari and firefox, maybe IE) then go to the site you want to read from and when on that site click on your ‘Readability’ bookmark. It takes whichever website you are on at the time and strips out all the distractions such as ads and flash banners and gives you the main text in an easy to read layout.

The second tool is called ‘Autoscroll’ and is available here. Now after you have sent your webpage through Readability. Create a bookmark from the Autoscroll site and click on it and this will start automatically scrolling the webpage for you – just like autocue on the tv. You can control the speed of the scroll etc with the number keys.

It is worth giving them a go and see how you get on. I have found them very useful – Matt