Blogs

Blogs

Using Outlook Email Tracker to manage SLA's
17th September 2018
Outlook Tracker, SLA Management, Customer Service
Did you know recent research has proven that on average, in an office environment workers spend a third of their productive time reading and replying
Developing a Website using Umbraco CMS
11th September 2018
.Net Technology, Umbraco CMS, Website Development
Recently we decided to launch a new website to promote our comprehensive customer base and the wide range of IT development services that we now offer
How to make your worklife 'Appier
25th July 2018
Apps, Customers, Development
One of the most fascinating practical sessions at the recent #GoDigital Conference 2018 in Lincoln centred around local Lincolnshire businesses use of
#GoDigital Conference 2018
23rd July 2018
Networking, Local Networking, Strategy
PSP-IT recently participated in #GoDigital conference hosted by Business Lincolnshire at the University of Lincoln. The aim of the conference was to b
Gizza Job!
2nd July 2018
Staff, Training, Commu
We have recently had the pleasure of a student from University Academy Holbeach for a week’s work experience. We set him to work across the company ob
To Test or Not to Test
20th June 2018
Website Development, CMS, Staff
Imagine having a piece of software designed specifically for you and your business needs, then discovering snags which result in slowing down the busi
Are you Focussed?
13th April 2017
Communication, CRM, Database
Targeted marketing allows you to focus your marketing and brand message to a specific market and investing your time in the preparation of your compan
Creating Charts with Microsoft Excel
3rd April 2017
Excel, Formatting Documents, Microsoft
Creating charts with Microsoft Excel 2013 has come a long way since previous versions.  This blog briefly covers how to use the Chat Wizard.   As w
Managing your Brand
21st March 2017
Branding Guidelines, Customer Relationships, IT Systems
Managing your Brand There are many marketing vehicles which are now available for increasing your brand awareness. It is important that they match ho
Customer Satisfaction
13th March 2017
Communication, Customer Relationships, Customer Service
Customer Satisfaction: “a measure of how happy customers feel when they do business with a company” (Source: Cambridge Dictionary) Customer Service
Have you planned a Spring Clean?
6th March 2017
Custom Development, Responsive Web Design, Web Design
How often do you refresh or re-write the copy on your website? Google – and other browsers – love changes that you make to your website rather than l
Do People See the Best of You?
7th February 2017
Development, Responsive Web Design, Web Design
What value do you place on your Brand? How do you view your current website – is it your ‘shopfront’ or ‘just a presence’? Would your prospective
DevExpress XtraScheduler – Show Full Date On Calendar Views
6th September 2016
DevExpress, Support
Scenario One of our clients came to us with an issue they keep having when entering appointments onto their XtraScheduler calendar view. On specific
TSQL – ISNULL or COALESCE
20th June 2016
ISNULL, SQL, SQL Server
What? Really! Just Use ISNULL… I hear this all the time (especially from developers that are new to SQL). Here is a story about George and how Jim ch
Google Search Console – Episode 1
12th June 2016
Support, Training, Tutorial
What is Google Search Console? Google Search Console is a free service from Google. Search Console allows you to add your website to their online web
jQuery Form Validator
7th June 2016
jQuery, PSP Knowledge, Tutorial
Recently I had to add some client side validation to a form, after some research I came across one jquery plugin that I particularly liked. It is cal
Go the extra mile…
1st June 2016
Communication, Customer Care, PSP Knowledge
Standing out from the crowd is important when it comes to your customer services department! Here at People Systems and Process (PSP), we pride ourse
DevExpress XAF – Change Continue/Cancel Action Size On Popup Window
23rd May 2016
Coding, Development, DevExpress
Scenario During recent development of a DevExpress XAF application that was being designed to be mainly used on touch screen devices, we found that t
Why we use Jing…
3rd May 2016
Customer Care, PSP Knowledge, Quality Assurance Testing
One of our main responsibilities within the customer service team here at PSP is to test any developments that our development team complete. When te
DevExpress Dashboards
29th April 2016
Development, DevExpress
Scenario We created a GeoPoint map on a DevExpress Dashboard and enabled clustering to group together many points that are close together when zoomin
Proof Reading: Chore or necessity?
18th April 2016
Customer Care, Customer Relationships, Customer Service
In today’s world you could say proof reading isn’t seen as much as it was this could be due to more organisations publishing web/digital content quick
DevExpress XtraReports - Add Clear Action To Dynamic Look Up List Parameters
29th March 2016
DevExpress
Scenario By default when adding a dynamic list look up parameter to an XtraReport at design time by assigning the parameter to your data source, when
Love and Technology
12th February 2016
Communication, Customer Care, Customer Relationships
We thought that we would look at how finding love has changed over the years, ranging right back to the 1700s, when putting an advert in the local pap
Protecting a Word Document
31st December 2015
Customer Service, Formatting Documents, Microsoft
How to Mark a Document as Final With Word 2016 you can now mark a document as ‘final’ this means users will receive a read-only copy of the document.
Speed up document formatting!
10th December 2015
Microsoft, Microsoft Word, Personalisation
As we all know from experience Word has its quirks and likes to sometimes ‘do its own thing’ this can make editing a document an admin chore which is
Want to Modify a Pre-Set Style?
29th October 2015
Formatting Documents, Microsoft Word, PSP Knowledge
Do you have an important document that needs a tweak to the pre-set/used style and want to achieve this without having to go through the entire docume
Creating your Own Document Styles
2nd October 2015
Branding Guidelines, Customer Care, Customer Service
Are you bored of Standard Styles? Could you use some simple formatting tips to improve your documents?Want to add your company branding styles into a
Does your Business Need Consistency with your Word Templates?
2nd October 2015
Branding Guidelines, Customer Care, Customer Service
Fed-up with your company branding not being used correctly?  Were you aware that you can update the standard Blank template in Microsoft Word? By
DevExpress Unbound Fields
4th September 2015
Bespoke Development, C#, Custom Development
Scenario Recently we implemented the DevExpress Notifications module into one of our projects. The functionality worked great however we wanted to im
Less & Sass
4th September 2015
Less, PSP Knowledge, Sass
What is Less & Sass? Less & Sass are CSS preprocessors, what that means is that they add features to CSS such as the ability to add variables
DevExpress XAF – Default HTML Editor Table On Object Creation
1st July 2015
Bespoke Development, C#, DevExpress
Scenario As shown within our previous post called 'DevExpress XAF - Default Administration Items on Object Creation' we are able to set default value
DevExpress XAF – Printing & Exporting Record Using Custom Actions and Templates
1st July 2015
Bespoke Development, C#, DevExpress
Scenario Within the DevExpress application we can create records such as Invoices, Purchase Orders or Credit Notes. We required the ability to print
Gaming - Old Memories Revived with LoG
29th June 2015
Dungeon Crawler, Legend of Grimrock, Log
History Growing up, I would spend vast amounts of time squirreled away in my bedroom sat in front of a screen either building my coding skills or pou
Can you Learn to be a Project Manager?
17th June 2015
Communication, Conflict Management, Project Life Cycle
Are there just some people out there that are born to manage projects, or can we learn the tricks of the trade? Come on, we can all learn something if
SQL Server - Linked Server Between SQL Server 2012 and SQL Server 2000
2nd June 2015
Linked Servers, PSP Knowledge, SQL
The Issue If you have ever used Linked Servers within SQL then you will appreciate the benefits of being able to connect directly from one SQL Server
Tip: Windows Shortcut Keys – Part 3
1st June 2015
Productivity, PSP Knowledge, Windows
Introduction So, if you read the previous post in this series, by now you should be wizzing around Windows 10 like a cat chasing a laser pen. With th
Expression Engine Update Function
29th May 2015
PHP, PSP Knowledge
This php code gets an item with the same URL title, if one exists then it updates it in expression engine. <?php ee()->load->library('api')
Two Useful php Functions
29th May 2015
PHP, PSP Knowledge
Ensure that the user has access to a page with a query string.The code below ensures that the user has a specific query string, this can be useful esp
HTML5 Structural Elements
29th May 2015
HTML, PSP Knowledge
If you want to start learning HTML5 then you should really look at what new Tags it has to offer before starting. For full list of tags use the follow
HTML5 New Input Types
29th May 2015
HTML, PSP Knowledge
If you're new to HTML5 then the below list of new input types and their descriptions will help you on your way to a better understanding. I
Backup Microsoft SQL Server 2014 Express Databases Automatically
11th May 2015
Microsoft, PSP Knowledge, SQL
We have a client who has SQL Express 2014 and wanted to automate backups. Please find the steps to create automated backups using SQL Express 2014.Ste
DevExpress XtraReports – Filtering Report Via Script
8th May 2015
DevExpress, PSP Knowledge
Scenario Usually when creating XtraReports via the XtraReports designer at runtime the standard Filter String functionality within the report propert
DevExpress XAF – Add a List View Group Footer
8th May 2015
Bespoke Development, C#, Custom Development
Scenario DevExpress by default gives you the functionality within the Model to group list views together based on a selected field and show a count o
Responsive Websites – Is it that Important?
5th May 2015
Mobile Phones, Mobile SEO, PSP Knowledge
Yes! Having a responsive website opens you up to the world of mobile device users…..Here are a few facts for you: In 2014 the number of mobile use
Life Online!
4th May 2015
Life Online
Have you thought about what happens to your life online if you or a loved one passes away…Like it or not, more and more of our lives are being lived a
Powershell - Copy Files and Folders and Delete Files Older Than X Days
1st May 2015
Powershell, PSP Knowledge, Windows
Recently I needed to copy all files and folders in one location to another and then delete files older than X days in the destination folder and I wou
Tip: Windows Shortcut Keys – Part 1
1st May 2015
Productivity, PSP Knowledge, Shortcut Keys
Introduction As a seasoned developer I remember the days before every desk had a computer, but those that did sport some magnificent magical box that
Tip: Windows Shortcut Keys – Part 2
1st May 2015
PSP Knowledge, Windows, Windows 8
Introduction Following on from the first post in this series, we shall look at, in my opinion, the nicest of all shortcut keys - Windows 8 shortcut k
DevExpress XAF – Default Administration Items on Object Creation
30th April 2015
DevExpress, PSP Knowledge
Scenario When entering client information into tables, many of the clients may have the same value such as VAT rate, payment terms or membership stat
What is MVC?
22nd April 2015
MVC, PSP Knowledge
What is MVC? MVC stands for Model View Controller. So, what purpose do each of these have you ask! The Model this contains all of your classes. E
DevExpress XAF - Scheduler Control Change Event Display Text
20th April 2015
DevExpress, PSP Knowledge
By default when using the Win Scheduler List Editor List Editor Type when viewing your Events using the Scheduler Control, the time of the Event will
DevExpress XAF – Scheduler Control Change Event Colours Depending on a Custom Field
14th April 2015
DevExpress, PSP Knowledge
By default when using the Win Scheduler List Editor List Editor Type when viewing your Events using the Scheduler Control, the colour of the Event wil
Activating Survey App in SharePoint 2013
7th April 2015
PSP Knowledge, SharePoint
In SharePoint 2013 there is a Survey App out of the box, but this is not always available without activating a feature. To activate the Survey app you
Look After Your Customer
31st March 2015
Customer Care, Customer Relationships, Customer Service
If you don’t look after your customers, someone else will! Customer Care never ends, it is paramount to give outstanding service to your customers.&nb
Customer Services – The 4 P’s
23rd March 2015
Customer Care, Customer Relationships, Customer Service
There are many different types of customer service that are provided by organisations, the type of which customers will encounter will depend on the p
DevExpress XAF – Filter Child Field Based on Selected Parent
17th March 2015
DevExpress, PSP Knowledge
In many scenarios it is necessary to filter dropdown fields values based on a parent value entered within another field. The requirement we had for th
SQL Server Tips: SQL CRUD
11th March 2015
Create, CRUD, Delete
Overview CRUD? Create Read Update Delete – CRUD. This term refers to the four general actions that can be taken when it comes to data. This is a glob
Understanding Expectations is Crucial for Customer Service
9th March 2015
Customer Care, Customer Relationships, Customer Service
Let’s face it, Customer Service is about expectations. Expectations are shaped by previous experiences which may have been good or bad and it is these
DevExpress – Run Report Straight From Navigation
6th March 2015
DevExpress, PSP Knowledge
Normal 0 false false false EN-GB X-NONE X-NONE
DevExpress – Display Icon Within List View Instead of Text
5th March 2015
DevExpress, PSP Knowledge
Normal 0 false false false EN-GB X-NONE X-NONE
DevExpress – Hide Nested List View Columns Based on Parent
5th March 2015
DevExpress, PSP Knowledge
In a recent project we had the need to hide certain fields within a nested list view based on certain values set against the parent. We had never done
Never Make the Same Mistake Twice!
3rd March 2015
Customer Care, Customer Service, QMS
One thing that must always be valued and that is your mistakes.  We are only human, so of course mistakes are made, but at PSP IT we want to give
SQL Server Tips: Primary Keys, Foreign Keys and Indexes
26th February 2015
Columns, Foreign Keys, Indexes
Overview When it comes to retrieving data from your tables, indexes play a fundamental role in finding that data you require and finding it fast. Pre
DevExpress XAF - Chart Module - Customisable Hover Values & Formatting on Stacked Bar Charts
24th February 2015
Bespoke Development, Charts, Custom Development
The DevExpress XAF Charting module can be used to quickly create charts which can then be used on dashboards or reports. The module does contain a lot
Customer Experience vs. Customer Service
23rd February 2015
Customer Relationships, Customer Service
As a Customer Service manager I pride myself on ensuring that the experience of dealing with our company for our customers is professional, enjoyable
Installing SharePoint 2010 Fails with FIPS Validated Cryptographic Algorithms
28th January 2015
PSP Knowledge, SharePoint
When installing SharePoint 2010 on a client site recently I came across an issue where half through the SharePoint configuration it hit an error with
Opening PDFs in SharePoint 2010 Without Having to Save to Local Machine
26th January 2015
PSP Knowledge, SharePoint
To enable user of SharePoint 2010 to open PDFs documents without having to save to local machine and then open you need to make a change to the allowe
5 Ways VISION CRM Can Save you Money!
21st January 2015
CRM, Customer Relationships, Customer Service
VISION is PSP’s very own off-the-shelf Customer Relationship Management System (CRM), designed and built to enable businesses to display, process, man
SQL Server: Databases
16th January 2015
Database, PSP Knowledge, SQL
Overview Databases are formed, primarily, from tables with each table containing columns and rows similar in appearance to that of a spreadsheet. Thi
SQL Server Tips: Tables and Columns
16th January 2015
Columns, PSP Knowledge, SQL
Overview A database is made up primarily of tables, a table is made up of columns and rows and each row contains data for each column. When creating
SQL Server: Security
16th January 2015
Security, SQL
Overview Like many things, databases contain a method of keeping data secure.  Where the operating system handles security at a file level, SQL
Managing an Online Helpdesk and the Importance of Meeting SLA
16th January 2015
Customer Relationships, Customer Service, Helpdesk Support
As a provider of IT solutions one of PSP’s key business functions is the provision of system support and maintenance for our clients.Whether it be a w
Open XML Usage - Part Four
15th January 2015
C#, OpenXML, PSP Knowledge
Part Four Adding a text watermark. Please refer to Part One of this series to see the Word document output and calling code. The TextWatermark class
SQL Server: Databases via a Service
13th January 2015
PSP Knowledge, Service, SQL
Overview Microsoft SQL Server, along with many other enterprise level database solutions, runs as a service. It is important to understand the differ
The Importance of Software Testing in Preparation for User Acceptance Testing
5th January 2015
Application Testing, Custom Development, Planning
We live in a world of up and coming technology, we are surrounded by it. There are always new developments taking place, new ways of completing tasks
ISO9001:2008 a Case Study Reference Annual Compliance Audit
15th December 2014
Audits, ISO, ISO 9001:2008
Back in September PSP welcomed our annual ISO 9001:2008 external audit. An External Quality Audit is how your Quality Awarding Body examines the quali
IT and Web Project Implementation: Specification, Development, Testing, Quality and Expectations
24th November 2014
Coding, Customer Care, Customer Service
PSP's Customer Service Manager Richard shares with you the process of implementing an IT and or web development project. What is involved in the proce
Data Warehousing – The SME Legacy
13th November 2014
Data Warehouse, Excel, Investments
Once only larger companies needed to consolidate ‘big’ data sets from multiple systems into a single reporting and analysis Data Warehouse but with SM
How Do You Write a Good Case Study?
7th November 2014
Case Study, Customer Relationships, Project Life Cycle
Preparation What do you need to do in order to create a case study which adds value to the reader? First ask why are you writing them? What is it you
Open XML Usage - Part Three
3rd November 2014
C#, OpenXML, PSP Knowledge
Part Three Add a header and footer.The following code adds a header and footer parts.When these are added then text and images can appear on each pag
SQL: String Concatenation
16th October 2014
Concatenation, ISNULL, Join
The Issue A few days ago I was asked to look over some SQL statements written by someone new to SQL.  They were getting some unexpected results
Open XML Usage – Part Two
13th October 2014
OpenXML, PSP Knowledge
Part Two Add styles and tables.I found it much easier to create re-usable code when creating Word documents.The CreateAndAddCharacterStyle method tak
Tip: Retrieving SQL Commands from SQL Profiler
13th October 2014
PSP Knowledge, SQL, SQL Profiler
The Issue So, the other day I am sitting around watching a bit of SQL Profiling on the old laptop, to see what a set of API requests were actually do
Open XML Usage – Part One
9th October 2014
OpenXML, PSP Knowledge
Part One This will be the first in a short series of articles to show how we use Open XML.Open XML is a Microsoft format which can be used to program
Optimising Images for your Website
18th September 2014
PSP Knowledge, Tutorial, Web Design
Why should I optimise images you might ask? Well, it improves the load time of your website, this is because there is less for the browser to downloa
DevExpress - View Detail View Straight From Navigation
15th September 2014
C#, Development, DevExpress
Many applications require a System Configuration record which contains all of the settings for the application, there will only ever be the need for o
Error Logging Helper
9th September 2014
.NET Error, C#, Error Logging
As a developer it is not uncommon that at some point in time your code is going to crash out and you will be hit with the classic .Net error page. It
Creating Customised Views Programmatically in SharePoint
8th September 2014
C#, PSP Knowledge, SharePoint
In Sharepoint, I had trouble creating views as they can be created in different ways. Here are some generic examples which I arrived at through trial
Responsive Web Design (RWD) in the Developing Digital Era
2nd September 2014
PSP Knowledge, Responsive Web Design, Web Design
People use the internet in different ways and access it from a wide variety of devices and platforms. A website that looks good on a desktop with a la
IIS: Retrieve Application Pool Identity Credentials
1st September 2014
Active Directory, AD, Application Pool
The Issue Recently one of our clients found themselves in a situation where they no longer knew the password for an AD account that was being used to
Open Source Network Security Tools Part 1: Event Log Management
15th August 2014
Network, OSSEC, PSP Knowledge
Good quality network security tools aren’t cheap and more often than not multiple tools are required in order to meet the various and often strict req
DevExpress XtraReports – Filtering Subreports Via XtraReports Scripts
8th August 2014
Bespoke Development, C#, Custom Development
Here at PSP IT Design and Development we create many DevExpress XAF projects which include embedded reports for the end users of the application, due
SharePoint: Adding a Publishing Image Field Programmatically
16th July 2014
PSP Knowledge, SharePoint
The Issue Here at PSP we produce custom solutions for SharePoint 2010 and 2013 for many of our clients. These solutions range from themes to fully mi
5 Top Visual Studio Extensions
10th July 2014
Development, PSP Knowledge
Increasing your productivity during development time is essential for any developer here is a list of 5 top visual studio extensions that we use at PS
DevExpress Model.User Security Issue
1st July 2014
CRM, Development, DevExpress
The Issue We recently found a security issue on our in house CRM system caused by a vulnerability with the Model.User.xafml file and many users using
PC Security: Remember the Basics
23rd June 2014
PSP Knowledge, Security
Network, computer and data security has been a hot topic of late with significant press column inches dedicated to keeping us informed of newly exploi
This website uses cookies to provide the best possible experience. By continuing to use our website you are agreeing to our use of cookies.