Skip to main content

Business System Interfacing with O365



We all use business systems, these are the software items we employ, like payroll software, accounting software and industry specific applications that make sure we run our businesses within a framework of rules.

We can't do without them in many cases as the software vendor spends megabucks ensuring that the checks and balances within the software keep us on the legal and moral straight and narrow. This means licencing particular users within the organisation to use and maintain them and this in turn sometimes leads to situations where a few users, or sometimes one user, becomes 'keeper of the key', holding business vital data that only they can access or disseminate.

Most business systems offer reporting functions where selected business essential data can be extracted and distributed to none licenced operatives for use outside the system. Such data is often extracted in some form of textual flat file, such as Comma-Separated-Value, XML, or just plain text. In some cases the business system allows direct queries to be made on a core database.

The data extracted is sometimes used for analysis, but is often ported into other business systems on the same network.

O365 offers a huge range of functionality to import data, convert or transform data and export data. But, additional to this an O365 collection can also be configured as a full workflow system, triggereing tasks for individual operatives or groups, notifying that data is available for analysis and tracking the action taken in a task list for supervisor oversight or later audit.

While there is nothing new about business system interfacing. Extracting data from one business system and importing it into another in a conventional computer network does require a considerable amount of IT knowhow. Even today I often come across business processes where such data is printed out and re-typed in to another system as the interfacing expertise is not available, or is deemed too expensive.

Within O365 there lies the means to import data, filter data, extract partial strings of data, build new strings of data and export the result in a form that is consumable by another business application. Additionally, this does not require extensive IT expertise, or large chunks of administrative effort to achieve.

An on-line demonstration will demonstrate how this can be harnessed to improve your business - email authoring@ffox.biz and please start the subject line with the word Interface. 


Comments

Post a Comment

Popular posts from this blog

Microsoft Teams

Microsoft Teams – Not only but also... What is Teams? Chat, Meetings, Calling, Collaboration | Microsoft Teams That’s the legend that Microsoft uses to head their Google listing. And it does those things really well. But -  There’s more . Teams also delivers a gateway to the fabulous world of SharePoint file storage, SharePoint and Office 365 index and search and Office 365 file security. All without the need for technical knowledge or extensive configuration. All well and good... What exactly does that mean? When you create a new team, simply click the ‘Join or Create a Team’ box at the lower left of the teams window, you launch a new team that has all the necessary attributes. This includes a mailbox, chat, call and video meeting area and a SharePoint file space with a basic library. Move shared documents, of any type, into the library and they are shared with other team members (the share facility is configurable to exclude individuals in the team who do not have sufficient righ...
Post a Comment
Read more

O365: Getting Really Useful Data into SharePoint Libraries

O365: Getting Really Useful Data into SharePoint Libraries See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow ,   Bulk Invoicing  and  Spreadsheet Data 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 C...
Post a Comment
Read more

O365: Create a SharePoint-On-Line Library

O365 is a tremendous resource. It can serve a business better when SharePoint on-line libraries are used as a repository for files and documents on which collaboration is required.  Instead of circulating documents for input by different users, simply save them to a SharePoint library where selected personnel can access them for update. Creating a library is a simple process which needs no technical expertise greater than the ability to use a computer. For this exercise we will create and start to populate a library for storing invoice documents.  Select the Site  An O365 domain can contain many sites. Libraries and Lists within a site can be made to interact with one another so data can be readily shared across the site and recycled. For example, if we choose to create a Customer List within a site and we populate the list with customer names and addresses we can allow other libraries and lists within the site to access and use the name and address data. So, the first jo...
Post a Comment
Read more