Bulk uploading can be an effective way to maintain large sets of users on an LMS when connecting to external databases and self enrolment are not options. This can often be the case in a corporate environment when an LMS is in its early phase of deployment or when HR systems are in the middle of an upgrade.
Moodle provides powerful and flexible bulk user upload and update facility. If you can learn to exploit all of the functionality it removes a lot of the pain from managing users and enrolments. So are you ready to transform your monthly upload from a brain-trauma into a breeze? Try my top ten tips for CSV success.
1. Get the best out of your spreadsheet software
A spreadsheet application such as Microsoft Excel can be used to maintain the user upload file, just save it as a comma delimited CSV file. Here’s how to ensure a successful upload:
- The format for the user upload file requires the first line to contain field names and the following lines to contain the user values for these fields. All data must be separated by a delimiter of your choice, typically a comma.
- Use the TRIM function in Excel in order to remove any leading and trailing spaces. These can cause errors when uploading especially if they occur in the username column as they are not permitted.
- If formulas have been used to create columns (such as when using Excel’s TRIM function), make sure to use value paste using Excel’s special paste feature to copy over the generated data.
- Check the output file in a text editor after saving the file in Excel. Look out for trailing commas which might be artefacts of deleted columns.
2. Build in safeguards using the upload settings
The settings section can be used as an invaluable safety tool when uploading users:
- The “Upload type” setting can restrict whether new users can be created or existing users updated.
- Further restrictions can be put on whether renaming, deleting and suspending is allowed by the user upload operation.
- The “Existing user details” option setting gives you more fine grain control on what to do with existing users.
- To avoid any unnecessary headaches, always use the most reserved settings required to achieve your goal.
3. Make big changes with bulk user actions
You may select new, updated or all users uploaded for a bulk user action such as sending them a message, forcing them to change their passwords or adding them to a cohort.
4. Get your country names correct
The country field must be populated with a capitalised two letter country code following the ISO 3166-1 standard. GB would be used for United Kingdom, for example. These codes can be found on the ISO website.
5. Forget manual enrolments and auto-enrol with cohorts
This can be a great way to automatically enrol users onto courses when combined with the cohort synch enrolment method.
- Users can be added to cohorts by including cohort columns such as cohort1, cohort2, etc in the user upload file. You can add users to as many cohorts as you need.
- Cohort IDs must be used for the values.
- Watch out when removing users from a cohort as this may result in unenrolling them from multiple courses which involves deletion of all user data from the affected courses.
6. Have custom profile fields? Not to worry!
Custom profile fields can be populated by including their “shortname” with the profile_field_ prefix. So for a custom profile field called “role”, the column should be titled profile_field_role.
7. Use it to delete and suspend users
Existing users can be deleted or suspended in bulk by including the deleted / suspended columns in the user upload file.
- A value of 1 in either column will mark that user to be suspended / deleted.
- A value of 0 in the suspended column will unsuspend the user. Please be aware that a delete operation is permanent!
- “Allow deletes”/ “Allow suspending and activating of accounts” setting must be set to “Yes” and the “Upload type” setting must allow the updating of existing users for this to work.
8. Yes, you can bulk update usernames too!
Often it’s a good idea to align usernames with email addresses or Active Directory IDs, but these can change with IT system updates. Don’t worry – usernames can be updated by including an oldusername column in the user upload file.
- The oldusername column should be set to the existing user’s username and the username column must contain the new desired username.
- The “Allow renames” setting must be set to “Yes” for this to work.
9. Explore more detailed results to solve upload problems
After the upload operation completes, you are presented with a results page showing the status of each individual user upload along with a summary at the bottom of the page:
- The summary allows us to quickly check if there were any errors with our upload and these can explored in more detail by tracking them down through the status column.
- If you are experiencing cryptic errors, enabling debugging should provide you with a more verbose error output.
- Be sure to also check that the users created and updated values match what you are expecting. It can be easy to miss something like a misspelled user name resulting in a new user to be created instead of the existing one getting updated.
10. Try it in a test environment first
Getting it wrong can result in undesired data being created in the system and/or existing data being overwritten or lost.
- Mockaroo is a great tool for generating sample data with all of the columns you require. This can then be output as a CSV file to use for testing.
- Make sure to always perform user uploads in a test environment first.
I hope you found my ten tips useful. Learning about the more detailed functionality of Moodle and the supporting tools we use to manage it is a great investment of time for LMS administrators who want to improve their productivity and performance, so I’ll be posting more indispensable tips soon. And if you have a trickier LMS issue, then why not contact Saffron to speak with one of our consultants?
For consumers and many companies, gone are those days where low bandwidth and connection problems were an issue with accessing the internet. But because of those problems, elearning companies or developers are used to taking the ‘minimum’ approach to visual and animated assets when designing elearning experiences.
At Learning Technologies 2015 we delivered an interactive seminar with IBC, a leading Danish business school, which is shaking up the market for online business education. In partnership with Saffron Interactive, IBC is spearheading the move to offer learners a ‘consumer-technology’ user experience on any device.
When was the last time you spent a day without receiving any performance feedback?
I don’t mean just at work (that was probably quite recently). I mean generally.
Such as: when was the last time you walked down a street with no awareness of how you were affecting other pedestrians, motorists… street furniture? Or how about the last time you received no ‘performance feedback’ at all from a nagging partner about an annoying habit you have? Or the last time someone rolled their eyes instead of chuckling at your particularly dull anecdote and you completely ignored the put-down, and told another boring story? Without the vital impact of performance feedback in the latter two cases you would be a very lonely human. And in the first case, you would more than likely be a very dead one too.
Browser testing has to be a key part of any project process. Everything from IE8 to iPads are now widely used in corporate environments, and, users are beginning to expect multi-device options, meaning that all software is subject to increasingly rigorous browser testing.
Automated testing for web-based applications is a cost-saving tool way which allows us to focus manual testing where it adds the most value. Recently, organisations have started to rely on open source test automation tools (which have now become so advanced they rival the commercial ones) instead of investing in their costly commercial counterparts. With no licensing costs, these open source testing tools provide competitive features for automating the testing of software applications as well as web platforms.
On 16 February 2015 the Spicy Learning Blog was placed at number one by eLearning Feeds, whose team of experts rank and score hundreds of elearning blogs. The blog was rated on criteria including its publication frequency, levels of social sharing and the impact articles make on the wider elearning community.
The Spicy Learning Blog shares the top table with e-Learning Industry, the industry analyst and publisher of the well-known ‘Top 20’ lists, along with the LearningStone Blog and Speexx Exchange.
The blog is produced collaboratively by the entire team at Saffron, along with guest contributors. There are hundreds of posts available as far back as 2008 which share insights and document ever-evolving best practices in learning technologies and instructional design.
“The top rating by eLearning Feeds is a credit to the thought leadership which is regularly produced by the dedicated team at Saffron,” says Noorie Sazen, CEO at Saffron. “As a business which helps our clients to unlock the power of insight within their organisations, we think it’s equally important to give back to the community and the industry by sharing our insights, top tips and advice. Thank-you to everyone who reads and shares the blog!”
The Spicy Learning Blog is published weekly on Saffron Interactive’s website. Many blog posts are extended in the Insights area, which features longer articles by expert Saffron team members and industry thought leaders on key topics for learning and development.
A full list of the top rated blog is available at http://elearningfeeds.com/top-elearning-blogs/
Did you miss Learning Technologies this year? Or perhaps the whole mêlée was so overwhelming that you’re still struggling to process some of the great ideas you saw in action? Either way, there’s no need to worry. Here’s four of our favourite trends and highlights from the event. It’s almost as good as being there, and you needn’t leave the comfort of your desk!
Saffron Interactive and AVA win silver at Learning Awards in coveted category of External Learning Solution of the Year
On 5 February, Saffron Interactive, the award-winning digital learning company, collected silver in the sought-after category during a ceremony at The Dorchester in London. Judges were impressed by the experiential elearning and unique knowledge platform developed in close partnership with Against Violence & Abuse (AVA). The project aims to educate practitioners working with children and young people about how to identify, challenge and respond to violence against women and girls.
Saffron’s free, interactive seminar with IBC takes place in Theatre 1 at 10.15am on 28 January at the Learning Technologies exhibition.
I like to think that 2015 is the year that most of us realised we were now, in fact, living in the future. As I drunkenly yelled for several hours on New Year’s Eve, 2015 is in fact ‘the future’ of Back To The Future.
Trade shows can be perilous places – sore feet, leaflet overload and worst of all, being sucked into a conversation about the ‘next big thing’ in learning technologies without being able to decipher the sense from the spiel. Here are a few questions you might want to ask to translate the trends into success at this year’s Learning Technologies.
Learning Technologies seminar to reveal how award-winning Digital Prevention Platform unlocked the power of viral learning campaigns
Creating a performance-focused platform using crowd-sourced content is the focus of Saffron Interactive’s seminar at 10:30am in Theatre 7 at Learning Technologies on 29 January. The Digital Prevention Platform, created in partnership with AVA, went viral to transform approaches towards safeguarding at a national level and won a European MEDEA Award.
Lists. Often when talking to clients about designing a dashboard for an LMS, we have to gently remind them that ‘at the end of the day, guys, it’s just a list’. A list of courses, a list of action points, a list of statuses or a list of things to do. That’s not a bad thing, as lists are also deeply satisfying things – they are how we throw a hoop around our complex lives so we can sit back and say: ‘that’s under control.’ And as BuzzFeed’s success demonstrates, absolutely any content is immediately more appealing if it’s in a numbered list.
Saffron to share how IBC are reinventing learning platforms with “OpenIBC” in free seminar at Learning Technologies
IBC, an innovative Danish business school, is disrupting the market for online business education. The seminar on 28 January at the Learning Technologies exhibition will present the radical new face of online learning, based on personalisation and networked learning, for a digital native audience.
After Christmas’s over-indulgence, self-improvement is most definitely at the top of everyone’s agenda come the New Year. In that spirit, we’ve compiled a list of our favourite learning apps. There’s no excuse not to get learning when these resources are at your fingertips (plus, they’re less taxing than joining a gym)!
Creating a sequel is easier said than done. We’ve seen some software, games and movies losing the plot completely. But, with Storyline 2, Articulate have excelled themselves. Storyline 2 includes new and enhanced features, giving us multiple ways to bring our content to life with more control over how it looks and behaves. The new and enhanced features are exciting but I should warn you: as much as I love it, it runs a little sluggishly.
Upcoming webinar to showcase Saffron Interactive and AVA’s award winning Digital Prevention Platform
This Thursday 11 December at 3pm GMT, MEDEAnet will host a free webinar to showcase the winners of this year’s MEDEA Awards and interview the successful entrants. AVA (Against Violence and Abuse) and Saffron Interactive will be participating as winners of the MEDEA Professional Production Award.
The 360 assessment tool began life in the Second World War as the German military sought to appraise one another’s performance. Nowadays, it’s not (always) a case of life or death, but the idea of personalising a method of assessment to achieve an impact has remained an important one when it comes to performance management.
AVA and Saffron Interactive win MEDEA Award for Digital Prevention Platform at international conference
The MEDEA Award for Professionally Produced Educational Media 2014 is European-wide and is awarded to the best educational media produced by a professional company or semi-professional production unit. The accolade was handed to Saffron and AVA at a ceremony which took place during the Media & Learning Conference in Brussels on 21 November.
With a new office and new website, the past few months have been a busy time for Saffron! To top it all off, we’ve also introduced new brand guidelines. Two of our team members, Sonja Gebetshammer and Carina Weingast, have been charged with updating Saffron’s branding, and they’re here to share their insider knowledge about how they’ve transformed the Saffron brand.
Count ‘em – three! Saffron Interactive and AVA’s Digital Prevention Platform is finalist for three prestigious awards
Saffron and Against Violence and Abuse (AVA) have been selected as a Finalist at the European MEDEA Awards and shortlisted by judges at the Learning Awards for both External Learning Solution and Social & Collaborative Learning Solution of the Year. The triple nomination recognises the impact of a Comic Relief funded project to help practitioners implement a whole-school approach to prevent violence against women and girls (VAWG).
A pictogram, also called pictograph, picto or simply icon, is the most simple and efficient way to convey a message or an idea and has been used throughout civilization – from the prehistoric age, to ancient Egypt, until today. Pictograms have constantly evolved over the centuries. Often they’ve been associated with magic powers, used to convey religious ideas or even been used as a secret code.
Saffron Interactive to create experiential elearning platform and marketplace for leading Danish business school
Saffron Interactive, recently named on Training Industry’s Top 20 Learning Portals Watch List, has been selected by International Business College (IBC) to realise its vision for a learning experience network. The Open IBC project will use open source technology and the Tin-Can API to act as a force-multiplier for IBC’s digital presence for a new generation of students.
When it comes to iconic figures in pedagogy, you can’t deny that Mary Poppins’ learning approaches were well ahead of the curve. Whilst watching Saving Mr Banks last weekend (if you haven’t seen it, I highly recommend it), I realised that there’s plenty we can learn from Mary P’s approach. She knew about everything: from gamified learning, to the endowment principle. This blog post will take a look at a few occasions on which Mary P showed us how a successful learning intervention can be done: Read more
TrainingIndustry.com has selected Saffron Interactive as part of its first ever “Top 20 Gamification Companies” list, published this week. Saffron Interactive’s inclusion recognises its history in the area of gamification and its commitment to pushing the boundaries of learning technologies.
On Tuesday I was invited to attend the Parliamentary launch of a new report which has found that that our failure to fully address perinatal mental health problems carries a total economic and social long-term cost to society of over £8 billion for each one-year cohort of births in the UK. Of that, £1.7 billion is borne directly by the public sector. It would cost a mere £337 million to raise perinatal mental health care standards to recommended levels.
It’s #everyonesbusiness! Saffron Interactive develops website and branding for key campaign on perinatal mental health
The Everyone’s Business campaign 1 has launched a new website and vibrant brand identity aimed at senior decision-makers in government and the NHS. The campaign is dedicated to ensuring that all women in the UK have access to specialist perinatal mental health care during pregnancy and postnatally.
Having completed my induction at Saffron as the IT Technician/Developer intern, I had a feeling of accomplishment. It can be overwhelming when multiple systems are thrown at you. However, the implementation model we’ve got in place makes new starters feel at ease. Shortly after completing my induction, I was thrust into developing an internal ERP system that the company will use on a day to day basis.
When I started as a new Instructional Designer at Saffron, I had to get my head around an abundance of new ‘systems’ in a short space of time. Of course, I didn’t think of them all as systems at the time, but when I stopped to think about what the word meant, I realised that countless new ones must be learnt and familiarised with whenever you enter a new environment. From working out how to get to work on time every day (still a struggle!), to mastering the various software applications that Saffron use; my cognitive faculties were busy getting to grips with systems all day.
This post is part of a sequence of articles which draw upon a book called the Six Disciplines of Breakthough Learning. This month, I’m exploring one of my favourite chapters: Deliver for application. The most prescient part of this chapter is all about reflection, a key to retention which all too often we do not retain! To understand why it’s so important, we first need to revisit some fundamentals.
Imagine, you’re in an airport and your flight has been delayed for a few hours. You walk around the terminal, go shopping, use the washrooms, get something to eat. You’ve managed to navigate a strange environment and find out all the details about your flight without having to talk to anyone. Who’s helped you out? How have you been able to do this?
Saffron Interactive has been named as ‘one to watch’ on this year’s Learning Portal Companies Watch List. Training Industry has recognised Saffron and its open source LMS, Saffron Grow, as an industry trailblazer amongst a growing list of clients that value innovation and user-impact.
Ruth: “Nick, When do you think you’ll have your proposed blog entry ready?”
Nick: “I’m hoping to be able to sketch you something soon.”
Ruth: “Is ‘something soon’ your target?”
Ruth: “It doesn’t sound all that SMART a target to me.”
Ruth is, of course absolutely spot on; my suggested ‘target’ was neither SMART nor was it smart. You’re probably familiar with the acronym SMART in the context of setting targets – it’s the idea that targets must be Specific, Measurable, Achievable, Realistic and Timely in order to be successful. Using this checklist, you can see that my target was too vague, and therefore bound to fail.
Saffron Interactive, leading innovators in the learning technologies sector, are thrilled to announce the launch of their latest change campaign. Saffron have been working alongside AVA (Against Violence and Abuse) in a Comic Relief funded project to create a Digital Prevention Platform and elearning course to help practitioners take the correct steps to safeguard children who disclose instances of abuse and implement a whole school approach to prevent violence against women and girls.
Following on from our webinar last week (you can find the recording here), we wanted to show that improving knowledge management doesn’t always have to cost a great deal of time and money. Here are seven easy-to-implement changes and smart investments you can make to improve knowledge management systems.
Saffron Interactive, creators of innovative learning content and platforms, will be exhibiting at Learning Live 2014 in London this week, returning to the event as a premium sponsor and launching its vision for the future of knowledge management.
Increasingly here at Saffron, we’ve been asked to create courses so that they’re suitable for translation. In today’s globalised business world, working across linguistic borders has become extremely common. This means it’s essential that you remember that any content you’re writing may need to be translated throughout the design process.
Picture the scene – having submitted your work in time to meet a tight deadline, you take a moment to collect your thoughts whilst perusing the very work you’ve just submitted with an air of pride.
This month Saffron Interactive, leading innovator in the digital learning sector, has been re-accredited by the Learning and Performance Institute (formerly the Institute of IT Training) for the sixth year running. The rigorous accreditation process requires that vendors demonstrate consistently excellent performance and give evidence of strategic transformation and innovation.
Who doesn’t like cartoons? Illustrations are designed to break up large amounts of text, introducing fun and laughter into the process. More than any other type of television, I can still remember the cartoons that brought me so much joy as a child.
In April we published our top ten tips for building a learning website in a reasonable timeframe and on a reasonable budget. Well, since then it seems like everyone at Saffron has been hard at work on website building (and not just ‘reasonable’ ones either!), so the logical conclusion was… ten more tips. This time we share some of the secret sauce that goes into a flamin’ hot website so good your audience will want to eat it up!
Recently, England cricket Captain Alastair Cook, came under fire for his ineffectiveness, which was apparently affecting the performance of the other players. But he proved all of them wrong by leading from the front: scoring runs and making tactical field placements in the very next game.
As teachers and other learning professionals will often tell you, imparting information to students is one thing, but to get them to remember and then apply it is a whole different ball game. So how do we achieve this holy grail of learning? It all comes down to the way information is retrieved and processed.
Recently, Toby and I attended the launch of AVA’s Digital Prevention Platform. The AVA Project is an online initiative aiming to keep education and social care workers informed about maintaining good practice when reporting disclosures of Violence against Women and Girls (VAWG).
Saffron Interactive, leading innovators in the learning technology sector, are preparing to unveil their new vision for the future of the enterprise knowledge-base at the 2014 Learning Live show in Bishopsgate from 10-11th September.
Missed Saffron’s free seminar at the Learning Technologies Summer Forum last month? Don’t worry! A full recording, with all the slides, has now been posted.
In a free seminar at tomorrow’s Learning Technologies Summer Forum, Saffron (Stand 20) will ask why we put up with LMS products and content repositories which are ten years behind the sites learners actually use. In their place, the seminar will introduce a radical new model for online learning environments, the Learning Experience Network (LEN), which leverages behavioural principles such as framing, peer comparison and the endowment effect.
2014 is the season of systems training. As we emerge from a period of economic difficulty, companies are finding the confidence to invest in new infrastructure and make acquisitions. This makes systems training a flaming hot topic – and an opportunity for all kinds of training devils to resurface!
More and more often, a website is part of the blend for a successful change campaign. The most obvious example is a learning programme which engages with a wide, public, audience. This will require a place to host elearning which also performs a few other functions: links to resources, news updates and contact details. A website is the logical solution.
In February I reflected on the Learning Technologies Exhibition 2014 with a post called ‘Design the complete experience’. Thinking about the end-to-end learner experience was a major theme of the show, and my title was inspired by the continuing relevance of The Six Disciplines of Breakthrough Learning, which was first published in 2006 and republished in 2010. The idea behind this book is to provide a toolkit for learning professionals who want to design programmes that make a genuine business impact, summarised in the six ‘Ds’.