Campus M Phone based information for students

For the last few weeks the LRT team, Business Improvement and the Marketing team have been working with the makers of CampusM to produce a version of the mobile web site for MMU. We now have a beta Iphone app and a beta wap site that allows students to see
Alerts
This will allow MMU to send alerts about major disruptions
Staff Directory
This allows users to search the staff directory for telephone numbers and email address
Locations
Maps and photos of MMU locations, can use Google maps to guide you to the location
Library
Tells you what books you have out, reservations and fines outstanding
News & events
RSS feed of MMU news
Pocket Guide
A link to MMU information for MMU students both new and returning
My Course
Shows the Students what units they are enrolled on

You can look at the beta on your mobile on https://mymmu.ombiel.co.uk and we would love your comments

My MMU Re-branding

For the last few weeks we have looking at a re-branding exercise for the My MMU portal. The current design is a standard Sharepoint web part site that while the students say the like the content but hate the design
So we set up a working party with representatives from
New Media and marketing
Library
ICTS
Students Union
And of course the LRT team
We asked 5 companies to take part in the process and after looking at their suggested designs we asked Novtronix Ltd to design our new site. You can find them at http://www.novotronix.com
After an initial meeting they offered their first take on the design, if was apparent that we are content driven and Novtronix are less so. After sending them our comments including a mock up Sharepoint site https://testmy.mmu.ac.uk/sites/feedback Novotronix have come up with the goods. A Strong but simple visual design allied with our contentFor a quick preview on how it will look have a look the jpeg

Home page
HoemPage

Sql Inserting Multiple rows into a Table

After spending hours trying to work out why the sql bulk insert command refused to work. (it always claimed it could not open the file but the permission sets looked fine) I found Pinalkumar Dave’s blog at http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/ and the example code worked wonderfully for me. So I had to do was to edit the data file, but a few change and replaces are better the inserting the values n times

A quick example

Insert into usage (Forename,Surname,Town)
Select ‘Fred’,’Smith’,’Manchester’
union all
Select ‘Bob’,’Jones’,’Wigan’
union all
Select ‘Anna,’Bell’,Stockport’’
Go

So thank you again Pinal Dave