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

Acquiring Market Share. MD, MD, how does your business grow?

Gaining an increase in market share may become necessary for a number of reasons. You may need to shift focus from one product line to another in the face of a declining market, you may wish to expand to fend off a market place squeeze or you may just be growing towards your planned capacity. Whatever the reason, you will need to form an acquisition strategy. There are three ways to obtain an increase in market share – Earn it. Use competitive trading to buy it. Acquire a competitor. Each of the three approaches bring along its own strategy requirements and its own issues. Selecting the best approach depends entirely on circumstance. Outperform the competition. Earning market share by supplying a better product, better service, better support, better delivery is an honorable way of expanding a customer base. It is steady, progressive and undemanding in that production/purchasing is not subject to stresses caused by sudden up-shifts in supply/delivery. Even so, there are issues. Attaini...
Post a Comment
Read more

The New Computer Age: Office 365 Vs Google, Dropbox and Others

Differences in Software as a Service ( SaaS ) This is the 21st century, the New Computer Age. Cloud services and SaaS are available for all to use. Word on-line, Excel on-line and Power Point on-line are just such services. They are available to all who want them, they are free, if taken via One Drive Live, and they enable the creation, editing and viewing of Word documents, Excel spreadsheets and PP presentations on ANY device that has a browser installed. This without any need to install software on the device used. The on-line software that is used to create the files is the same on-line software used to view them. There can be no incompatibilities and no missing fonts. Open Document Standards, to which these most office applications conform, requires that any document file should contain the properties of style, layout, font etc. These elements are the property of the document file and will travel with it wherever it is stored or sent. However, issues can still aris...
Post a Comment
Read more

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...
Post a Comment
Read more