Skip to main content

O365: The SharePoint Data Harvest

O365: The SharePoint Data Harvest


An earlier post on getting data into SharePoint libraries touched on the various methods of building data stores for use across the business.

The methods range from creating files, documents and data in SharePoint Lists and Libraries, importing into SharePoint Lists and Libraries and scanning into Lists and Libraries.

The importance of import and scan in this context is that valuable communication data generally has two parts -
Outwards communication - files, data and documents that are sent out 
and
Inwards communication - files, data and documents that are received.

The email Issue

Let's take a look at what happens with email.
In a sales department email will often be sent from and received by an individual. A well organised salesperson will probably create folders in the inbox to sort incoming mail so that communications from customers are easily found.
But, what happens to outgoing mail?
This usually resides in the Sent Mail folder on the individuals account. Sent folders are often cleared when content reaches a certain age. 
At a later date you may wish to analyse the processing of an order. The salesperson can provide the incoming record from the inbox folders, but outgoing means sorting through everything in the outbox, some of which may already have bee deleted.

Enter the CRM

When seeking a solution to such common problems a business will often be advised to take on a CRM package.
These come in all shapes and sizes from free-ware to very extensive and expensive software suites.
One thing they all have in common is that for successful deployment users will all be required to store their data in one place and will all be required to store their data in a format acceptable to the CRM.
In return the CRM will deliver lots of out-of-the-box forms and reports on what is happening across the sales business, who in the business owns responsibility for what and what the work load balance is across the business.

In order to achieve this the CRM will need feeding with data. Incoming and outgoing email, incoming and outgoing paper documents and incoming and outgoing electronic documents, such as email attachments and Internet downloads.

In short the CRM will teach data discipline and require data discipline across the organisation.

All well and good.

Where Does Office 365 Come in?

As already discussed, Office 365 delivers the functionality to create communications data directly from a SharePoint List or a SharePoint Library, offers extensive tools to import and scan communications data directly into Lists and Libraries. It also offers the functions of  group or team email and facilitates the capture of incoming and outgoing email content directly into the List and Library structure.

Once the data is stored within the Office 365 domain it is simple, using the powerful search tools to locate, list and categorise in order to allow for organisation wide dissemination of information and analysis of performance.

Does that Mean Office 365 is a CRM?

Not really, it is in fact an organisation Content Management System, that can be easily and without programming skills be made to perform the functions of a CRM.

Additional factors are that use of a CRM external to Office 365 requires manual or automated interaction between the two data repositories. 
Users need to learn two systems.
There is an update latency between the two systems.

All of that scanning and importing. Doesn't that mean a lot more work?

Yes it does. So, how you organise that work could mean the difference between a system that works for you and a system that is just another dysfunctional electronic filing system.

Getting paper documents into a system has always been a bottle neck. In the past field workers would collect invoices and receipts from their travels and sort and file them on return to the office.
Paper communications would come through the post and be sorted and placed on the desks of the addressee.

The Office 365 One Drive app for Android and IoS helps resolve this as you can photo scan any document, receipt or invoice as soon as it comes into your hand. This can be filed as a PDF directly into the SharePoint Library where it is required





You can also use any other scanning device to achieve the same result. 

email attachments and downloaded files and documents can be quickly filed in similar fashion, as can the content of email exchanges.

In addition a simple Power Automate flow can capture the To and From fields and the body portion of any email to SharePoint Lists.

All The Data you Need

This is not to say that no organisation ever needs an external CRM. Just that, if you chose a CRM, or any other business software application, it needs to fit comfortably within your organisational information storage strategy. 

Data duplication should be avoided where possible with the primary system being where addition, removal and update of data should take place. Sub systems should be fed from the primary system.

  

 We can show you how, or we can do it for you.




Labels:

Comments

Post a Comment

Popular posts from this blog

O365: SharePoint List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...
Post a Comment
Read more

The New Computer Age: Infrastructure and the cloud

Most business managers don’t know it but this is very close to the truth. IT teams across the world live in day to day hope that their servers and networks hold together and pray that the disaster recovery schemes will be adequate in the event of catastrophe. IT people are highly professional and, of course, their server networks do deliver. Massive and expensive failure is surprisingly rare, provided that the IT department gets what the IT department needs in terms of budget. But, where budget is restricted, where the IT manager fails to make the business case for upgrade, then performance and security start to become threatened. In addition, a complex IT infrastructure brings with it the penalties of restrictive practise where a department head can’t get the software, services or technology required for a lean department because what is needed will not fit with the current IT infrastructure. So, what’s the answer? Sole Trader - Read more SME - Read more En...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more