SharePoint Meta Data Tags during Import

We’ve often discussed with client looking to utilize some of the features in SharePoint for document management the benefits of using meta data and tags to make finding document easier.  One of the challenges often faced with this approach is the migration of an existing file share or a large number of documents from another source.  Tagging such a large amount of files can prove problematic.

We have a current client facing such a situation.  There are 3rd party tools that can help with such a migration, but with recent changes and updates to the Microsoft Office 365 platform, those Office 365 customers can not benefit from a customized PowerShell script to tag files as they migrate.

We have a few options when tagging files as the script uploads them into their online SharePoint environment.  We could use the current folder structure to pull relevant tags, for example using a containing folder name to serve as a tag.  We could hard code the values for tags and perform multiple migrations, moving only folders we wish to take with a certain set of tags.  A more complicated migration may require an excel spreadsheet listing all the files to be migrated, their current location, and the tags for each file listed in cells on the same row as the file information.  The process can be catered to the needs of the customer thanks to the customization available in writing the script.

PowerShell provides us the flexibility and more importantly the efficiency needed to apply a large set of meta tag data to a large amount of documents in an automated fashion.  Combining the tags for documents with the new document library experience available in SharePoint allows any user to quickly find the documents via searching and filtering, and with PowerShell scripting – we can make the process of achieving a cleanly tagged document library a hassle free experience.


Chamber Breakfast Event

Wake Up Westmoreland Breakfast

This past week we had the honor presenting at the Westmoreland County Chamber of Commerce monthly breakfast event.  The topic of the morning was the development and demonstration of the new ShopMP application built for the Mt. Pleasant Business District Authority.  It was a great experience to share with other business  people of the area the whole process of developing a custom phone application such as the ShopMP app, and all the decisions that get made in conjunction with the customer as you build toward a final product.

Some of the newer features were introduced to those in attendance including the integration of the phone platform’s navigation software that allows users to be taken or navigated to a business or event location.  Calendar integration was added to improve the experience for users when viewing events, allowing them to add an event to their phone’s calendar with a click of the button.  Push notification improvements now take users directly to the deal, business, or event rather than just opening the front page of the app providing a direct path from a push notification to the desired page within the app.

It’s exciting to be able to share these improvements and the ShopMP application in general with the business owners in the Westmoreland County Chamber of Commerce.  The ShopMP app is available both in the Apple App Store as well as the Google Play Store for download free of charge.


Challenges of Custom Application Development

We recently had a client ask us to build a custom application to run on their environment.  We love these types of jobs because of the challenges they present and the creativity they unleash when it comes to building the solution.  We have plenty of options to choose from when building a custom application in terms of technology.  In some cases we might simply utilize an existing SharePoint /  Office 365 package and build them a small SharePoint portal that utilizes Microsoft Flow to satisfy the requirements of the client.  In other cases we may build a custom .NET web application in .NET Core with a back end SQL database to really customize each aspect of the application for the client.

Challenges

There are some challenges we encounter when building a custom application for a client that, in this case, would like to host the application within their network.  In this case we opted for a .NET application with a back end database.  Typically if we are hosting the application or if the application is going to be hosted on Microsoft Azure, we have a SQL Server available.  This particular client did not have a SQL Server available, so we had to use an alternative to host the small amount of data that will be contained in the application.

The hosting environment can also play a part in what technology we employ.  This client did have a Windows 2012 Server available to host the application, which was something we could take advantage of for our .NET Core application.

Creativity

The creativity kicks in when designing and building the application, blending client side JavaScript and JQuery code to increase the usability of the application for the users.  Optionally we have developers who can build a similar custom application utilizing other front-end technologies like Angular or React to handle UI/UX challenges.  In some cases we’ve taken on a custom application that was previously written in PHP and needed only to make a few small changes to the application.  Custom Application development always has a few challenges with it, but with all the tools available to us and the expertise on our staff, we usually find a path to a success.


SharePoint / Office 365 serving as a Virtual Data Room

We recently had a request to set up a SharePoint environment to serve as a less featured version of a virtual data room so that an organization could make available documents to external users and organizations. SharePoint was chosen as the environment by the client because of the relative speed in which the needed components could be set up.

In this particular case, the client needed various other organizations to access certain files they would make available for a short amount of time. Rather than setting up a dropbox and going through the motions of inviting users to it and worrying about limitations imposed by drop box, the team asked us to spin up a SharePoint site for the purpose of sharing the files.

A single document library was created with the necessary folders for each outside organization. Access to each folder was granted to a corresponding group, so that each user into the system would only see their folder. The client could then drop the correct documents into each organization folder, and then simply invite those external users into the site and into the corresponding group.

This was set up in half a day and required minimal training to the client. External sharing in SharePoint and Office 365 is the driving force behind this particular solution. For this particular case, the invited users only needed a Microsoft account of some kind whether that be another Office 365 account, or an outlook account. More information on external sharing can be found here https://support.office.com/en-us/article/external-sharing-overview-c8a462eb-0723-4b0b-8d0a-70feafe4be85.


Document Sharing Options in Office 365 (OneDrive, SharePoint, etc)

At McKula Inc., we often work with and recommend Microsoft’s Office 365 service when potential customers ask about document management and sharing. Various plans that include different services are offered by Microsoft, often times the featured offered in these plans depend on the level of the plan you purchase. Specifically when it comes to document sharing options utilizing Office 365, we talk about the business and enterprise plans, though there are educational, nonprofit, government, and home plans. One of the benefits of an Office 365 plan, is the suite of products included, which often includes all the Office applications such as Word, Excel.

Microsoft bills the plans on a per user basis, so for example if you have 5 users in your office and you want them to have access to the Office 365 Business Premium plan, each user would need a license purchased for their account. If that particular user leaves, and a new user is hired, you can transfer the license to the new user fairly easily through the administration area offered in Office 365. Each user would have access to those Office applications mentioned above, as well as other features included in the Office 365 Business Premium plan such as SharePoint.

Microsoft has essentially split file sharing service into two parts – OneDrive and SharePoint. OneDrive is the user-based file sharing. We would describe is as a “My Documents in the cloud”. It is effective for helping users store their own documents in a safe, secure location – while providing them with some sharing capabilities with other users as needed. It is effective for getting attachments out of email and great for backing up material (so it doesn’t exist solely on a PC). OneDrive is available on all the Office 365 Business plans.

SharePoint is a broad set of tools that allows you to build more customized collaborative solutions. It serves a wide set of purposes. In the case of file sharing, you may want to use a canned SharePoint solution called Office 365 Teams. This particular solution is geared towards file sharing and collaboration between set groups of users like departments, project teams, company initiatives, etc. Teams is a very slimmed down, lean, easy-to-learn version of it – that also combines file sharing with conversations, OneNote, and chat. SharePoint is only available on the Office 365 Business Premium and Office 365 Business Essentials plan, as well as the Enterprise E1, E3, and E5 plans.

The solution that works best for you can depend on many factors. If you have any questions or just wish to learn more about what Microsoft offers within it’s Office 365 plans, contact us today.


What Google’s Security Flag Means to Your Web Site and SEO

Google has been pushing more and more for web sites to secure themselves with HTTPS encryption and in July 2018 they will take a larger step utilizing their Chrome browser to identify non-secure sites to users.  According to google, over 68% of traffic in Chrome on both Android and Windows is now secure while over 78% of Chrome traffic on Chrome OS and Mac is secure.  If your current web site is not secured with HTTPS encryption, you are currently falling behind certainly other sites on the internet, but more importantly you may be falling behind your competitors web sites.

Could this damage your search engine rankings (SEO)?

It is rumored that security of a site may factor in how the site is rated and ranked in their search engine algorithms.  This may mean that if your site is not secured, you may begin to lose your ranking in google’s search results.  While Google does not often release how it’s algorithm works or changes, it can be assumed at some point the ranking of the site may partly be determined by security of a web site the same way Google may determine the ranking of a site based on how responsive it is to mobile platforms.  Certainly with the number of Chrome users, the security of a web site now being placed front and center by Chrome may have your visitors going elsewhere if they noticed you are not a secure site.

Ensure your web site is secured with an SSL certificate.

HTTPS encryption involves the installation of an SSL certificate on the web server that serves your web site.  It activates a secure connection between the user’s browser and the server that is hosting the web site.  There are numerous ways to ensure your site is secured with an SSL certificate, both freely and with a cost.  The difference usually depends on how long the certificate is valid and whether it’s a feature that is included with a hosting package.

What McKula Inc. is doing.

McKula Inc. is currently converting all the sites we host to a platform which will allow us to take advantage of a free certificate system to ensure that our clients web sites are secured at no cost to them.  If you have any questions about a web site that you own with regards to security, please do not hesitate to call us at (724) 424-1130.

 

 


ShopMP Phone Application Launch

A phone application for Mt. Pleasant businesses and customers

The developers here at McKula Inc. recently had the great experience of working with the Mt. Pleasant business district authority to bring a phone application idea to fruition.  It’s always enjoyable to work on something that will benefit the entire community and the businesses within, and that’s the opportunity we had over the past few months.  ShopMP is a phone application that will help connect the small businesses in the Mt. Pleasant area with their customers.  We’ve seen large corporations make various specials available to users who download their application, and ShopMP does that only in a wide scale to all the businesses in the business authority area.

This particular application was developed utilizing Cordova with Ionic serving as the front end, and was developed for both Android and Apple phones.  The application utilizes push notifications to alert users of new specials or deals that have been added by local businesses in the area.  When opening the app, users are first presented with a “business of the day” providing information about a local business as well as a special or deal that the business may be offering at that time.

Along with the business directory, users can browse upcoming events in the area, a list of important local contacts, and a business directory that is searchable by category.  They also have access to a list of specials or deals that are currently being offered locally.  Businesses will have access to all the data associated with views and clicks of both their business individually as well as any specials or deals that they offer.  Download the application today by searching “ShopMP” on Google Play or the App Store.  For more information about the Mount Pleasant Business District Authority, click here.


SharePoint Branding and Customization

Often times a client interested in SharePoint wants to do something, sometimes small and sometimes drastic, to change the look of the out of the box SharePoint site. The basic branding changes include a few color palette changes and a logo placement. Eventually though, a client will want to alter some of the layout, remove a menu, or wish to lay out a page that just is not possible with the page layouts offered in SharePoint.

The first place to start branding your site can be with the SharePoint’s master page. SharePoint’s most recent version offers two out of the box master page layouts, named Oslo and Seattle. Seattle is the layout that most people who have used SharePoint are accustomed to, and Oslo utilizes a top line of navigation as opposed to a left menu that Seattle employs. These master pages can be customized to fit the branding requirements of the client as needed.

Web Parts are a fairly popular option for adding content to a SharePoint site. When creating a page in SharePoint, the user can opt for certain layout options that provide positions to place Web Parts. In some cases a client may find these layout options limited and unsuited for their needs. Custom page layouts can fill the void and provide these clients with the customization that meets their requirements.

Microsoft recently released the SharePoint color pallette tool which will provide an easier method for customizing all the colors involved in a SharePoint layout. Previously, a custom css stylesheet was the method for making site wide color changes, but utilizing SharePoint color pallettes make this job a whole lot easier. Stylesheets and css can still be used in certain cases to make precision like changes to a layout, along with some client side javascript or jquery.

A client may want to match their SharePoint environment to their external facing web site, or may just want to provide their users with a fresh look as opposed to the default SharePoint experience. In either case, there are plenty of avenues to make things look just right when it comes to a SharePoint site to change the generic out of the box look.


What is the most cost effective way to convert complex Lotus Notes databases?

Lotus Notes was a very effective tool for its time.   The platform allowed for the effective deployment of applications that could range in size – from simple expansions of existing database templates to highly customized and complex applications.

Converting mail files and templates has been done.     Many partners have developed advanced tools and techniques that makes performing a Lotus Notes migration a very painless process for the consumer.    But what do you do about the more complex applications?

The McKula Inc solution

Our methodology with complex Lotus Notes migrations is to take a very detailed and specific look at the application.   We do not rely on tools to attempt to estimate the application based upon forms, views, and agents.    We rely on our team and their experience to give you the best estimates for effort to convert your applications.     We perform a detailed assessment that includes interviews with the business users and a detailed analysis of the application by our own Lotus Notes developers.     Once we have completed our interviews and assessment, we will present you with a path to moving the application to a possible technology (such as SharePoint) along with an estimate of effort to do so.

When it comes to actual database conversion, we again rely on our experience working with both Lotus Notes and Microsoft technologies to build a new solution.     We are also available to assist with any data migration and constructing tools (if necessary) to assist you in moving your Lotus Notes data.    Our team has experience with common Lotus Notes data migration tools – including DocAve, Dell Migrator, and SWING.

Our strategy has been successful in converting complex Lotus Notes applications for many large, enterprise clients.     Contact us today if you have a challenging Lotus Notes migration on your schedule or would just like to ask some questions regarding a potential Lotus Notes migration opportunity.


I can’t find files in our file share – You need SharePoint

The File Share Problem

We’ve got a current customer that is facing a common problem as their file share grows. Nobody follows a naming convention, versioning is done with random bits of information like the date or month mixed into the document name, and files that may belong in more than one place are impossible to find. This is one of the perfect situations to leverage SharePoint metadata for files and document libraries.

The SharePoint Solution

Tagging documents with metadata is similar to tagging your friends in a Facebook photo. SharePoint allows you to manage what data you would like to be tag-gable to an uploaded document or even a document library. Rather than organizing your files into folders, which could get layers deep with no easy way to determine where a document current exists or should exists – leveraging SharePoint metadata would allow you to store your documents with a more linear approach – utilizing search and filter features that would use the selected metadata to find the documents you are looking for.

Our current customer has a need for a document to belong to a few separate areas. In their current file storage solution, this document can only live in one of those areas, and whomever is looking for it either must know this location or search through multiple areas until they find it. SharePoint’s metadata allows them to tag this document with multiple tags – making this document far easier to find. This also solves a concurrency problem, the document only lives once on the site as well.

Document versioning is another sore spot that SharePoint solves for this current customer. Rather than having users making versioned copies of files and inevitably failing to adhere to a naming convention, SharePoint takes care of all versioning issues – providing a clean way to retrieve older versions of the documents in the library.

For this customer – SharePoint’s document library functionality and metadata solution was a perfect solution to their needs.