Skip to main content

O365: Getting Really Useful Data into SharePoint Libraries

O365: Getting Really Useful Data into SharePoint Libraries


A really useful SharePoint Library structure will give you something like this - 

Just typing the words 'Credit Card' into the SharePoint search box returns a list of items relating to credit card across the entire Office 365 site.

Security

Don't worry about users accessing documents that are restricted. If you create or place a document into a Teams Document Library, it will be available to members of that Team by default. However, each document can be locked down to no access, view only or edit. You can also stop sharing any document, or alternatively share only with the members of the team you select.

Users with whom the document has not been shared with will not be able to access it.

Being More Specific  

That's fine if you know which Credit Card statement you are looking for. Let's say you need to find a particular payment for a specific vendor somewhere in a credit card statement.

 
I'm looking for a company credit card purchase of diesel from Morrisons, but I can't remember the date or amount. So, I've searched for Morrisons. The result shows all credit card statements where Morrisons appears in the body of the statement. I only have to look at each and locate the item for fuel purchase and I have the data I need.

In this example the data is stored as PDF, the same search facility is available for data in any Office or  Open Office file stored in Office 365. 

Getting Really Useful Data into a Library


Many documents can be created straight from the library


This will use the templates for Word, Excel etc that are a part of the library structure. You can also modify the templates, or import new templates as shown in the post Invoicing.

Emailed and Downloaded Documents

These can be imported into a library using the 'Upload' menu item

This will allow you to browse to the file and import it into the library.

Scan

Items can be scanned from almost any scanning device, including photo scan from a mobile phone.

Using an Android Mobile -
  1. Install the One Drive app
  2. Launch the One Drive app and log into your SharePoint domain and select Libraries
  3. Select the library you wish to scan to

  4. Tap the camera icon on screen, select document and photograph the document. If there are several pages click the + icon and add photos as required. 
  5. When the whole document is captured, click the tick for done.
  6. Save the document as a PDF and name the file.
  7. The document will appear in the library listing after a few seconds.
The same method can be used with tablets, laptops and other image capture devices.


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



Labels:

Comments

Post a Comment

Popular posts from this blog

Electronic Document Storage and Management (EDMS)

EDMS is not just a means of storing computer files. A full EDMS system allows for the process of importing both paper and computer generated documents into a computer system and indexing the files for easy and swift retrieval. In effect you can dispose of your traditional paper filing system. No more gathering letters, invoices and orders into filing groups and no more slotting them into the correct folders. Of course, you only use a paper filing system because you know you may need that document again in the future. Equally, when you do want that document it's invariably missing, either misfiled, or on someone else's desk. With EDMS documents are where you placed them and they are available for you to use where ever you are. All you need is a computer, tablet or smart phone and an Internet connection.As most modern businesses already use the Internet for everyday interaction with banks, Inland Revenue, Companies House, insurance companies, suppliers and customers it no longer
1 comment
Read more

Leadership: So you want to be Powerful?

Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions.     In a recent post on LinkedIn a n Influencer wrote that she had been asked the question ' Who is the most powerful person you ever met? '     The question was posed by a 17 year old and the author guessed that the answer being sought was the name of some sort of X-Factor figure, This strikes a cord with me. Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions. This applies to all generations, 'Boomer, X-Gen and Millennial, it applies to individuals of all levels of intelligence, and to individuals at all levels of authority.     The desire for someo ne to appear, like a genie from a lamp, wit h either ' the answer' to a problem , or ' the power' to solve the problem, or
1 comment
Read more

Law and Order: The Anonymous Text Tip-Off

The following article came out of an interview conducted with Max Doleh - Law enforcement organisations and Crime Stopper programs are turning to technology which enables text tip-off from the public to facilitate a police response. In September 2007 Master Sergeant Charles Phillips of the Oklahoma City Police Department published an item on the Oklahoma City Crime Stoppers web site (http://www.okccrimetips.com/ ) calling for increased resources to bring this technology to OKC. In November 2007 it was announced that Crime Stoppers of Oklahoma City have engaged technology company ProductiveT to develop an SMS system that is radically different to others in use in the country. Max Doleh, ProductiveT president and CEO answers questions – 1 . What makes the Oklahoma City system so different? The ProductiveT technology differs greatly from other offerings. The police department have their own dedicated number for receiving the messages and unlike most systems there is no need for the sender
1 comment
Read more