AxioWorks Newsletter

AxioWorks Newsletter July 2021: Building up a successful release in June

/in , , , /by

Hello Reader,

Welcome to another exciting issue of our monthly Newsletter!

Each month, we try our best to bring to you content that is relevant and beneficial for you. So, if you would like us to cover any specific SQList feature or if you want to learn more about any SharePoint feature then please do let us know.

What has AxioWorks been up to?

After the successful release of SQList 7.0, the primary focus this month was to get some feedback on the new features and to finalize the feature roadmap for the next release which is planned for the end of July. All our hard work was duly paid off by some very positive feedback from the community and the overall consensus is that the new features have improved the overall user experience and unlocked some use case scenarios which were difficult to implement previously, like Column selection.

If you haven’t checked it out yet, you can find all the details in our blog article: New version of AxioWorks SQList released (7.0.0.0)

Furthermore, team expansion is on the horizon and we are working on expanding our team with the addition of one Developer and one Sales Manager to join our awesome team.

Focus blog entry: Mover, One-stop shop for your Cloud Content Migration to SharePoint

One of the biggest conundrums of any organization planning to move to SharePoint is how to move all content stored in one or more locations efficiently to SharePoint. This becomes even more important if the company wants to use SharePoint as a document management system which is one of the strongest features of SharePoint. Microsoft understood the pressing need of having a consolidated migration tool to ease the process of migration and has acquired Mover.io which is now part of the O365 products and is now available in SharePoint Migration Manager.

Read all about it in this month’s article: Mover: Only Migration tool you will ever need to move your cloud content to SharePoint.

SQList feature of the month: Column selector

In SQList 7.0, we have introduced a great new feature that provides a capability to include, exclude, and rename columns exported by SQList for individual lists. This feature is very useful in situations where you need to export a particular column for a list that would otherwise be excluded by default. This feature can be accessed from the replication list where you can select a list in the desired replication and click on Select columns. From here you can:

  • Change whether a column is included or excluded by SQList in the exported SQL table;
  • Change the name of the SQL column generated by SQList.

If you want to know more details about this feature, check out the video blog explaining how it works: AxioWorks SQList Column Selector

Featured articles

Here is a small selection of interesting articles from the net.

15 ways to make your SharePoint Site more secure

In this article, you will find out how to ensure your SharePoint site is not just visually appealing and has the right content, but is also secure in terms of inadvertent deletions and data loss.
Read more…

How to upload files to SharePoint using PowerShell

SharePoint Admins are often tasked to upload documents from network drives to SharePoint and an automated script can really come in handy. In this tutorial, we will see how to migrate all the documents from a network drive to the SharePoint document library using a PowerShell script.
Read more…

5 places to use formulas in SharePoint lists and libraries

Formulas play an important role in modern SharePoint and in this article, the author will briefly explain the importance of formulas in SharePoint and will cover different ways to use formulas in SharePoint lists and libraries to make them more intelligent and user-friendly.
Read more…

Let us know what you think about this newsletter
(it only takes a click…)

That’s all folks, till next time.

Mover : Only Migration tool you will ever need to move your cloud content to SharePoint

/in , , , , /by

by Danish Ali Detho | O365 & Power Platform Solution Architect///

One of the biggest conundrum of any organization planning to move to SharePoint is how to move all their documents stored in various different locations to efficiently to SharePoint. This becomes even more important if the company wants to use SharePoint as a document management system which is one of the strongest features of SharePoint. In past, you had to use a combination of third-party tools to move all the files to SharePoint if they are stored both in-network shared drives and SaaS platforms like Box or Google drive.  Microsoft understood the pressing need of having a consolidated migration tool to ease the process of migration and has acquired Mover which is now part of the O365 products and is now available in SharePoint Migration Manager. In this article, we will have a quick look at Migration Manager and then Mover and how we can use to migrate files from Google Drive to SharePoint.

Read more

Form Configuration Editor: Lightweight and Built-in SharePoint List Form editor

/in , , /by

[*SP] Lists provides an easy and robust way of storing and manipulating data in SharePoint.  When you set up a new custom list, you also get OOTB data entry forms to perform CRUD (Create, Read, Update, Delete) operations easily. However, most of the time we will need to customize those OOTB forms in order to make them more user-friendly for business users or implement some business rules to control the User interface. Previously, The only way to customize List forms was by using [*PAPPS] but now Microsoft has introduced a new built-in form editor to do some quick customizations without using Power Apps or any other external tool.  Today we will look at essentially what we can or can’t do by form editor feature and we will be using an Issue Tracker List scenario.

Read more

AxioWorks Newsletter

AxioWorks Newsletter May 2021: April flew by faster than SpaceX

/in , , , /by

Hello Reader,

Welcome to another issue of our monthly Newsletter!

Thank you for the great feedback on the past newsletters, our team has been working hard to incorporate it and add more value for you, our readers. Please keep ’em coming and we hope you enjoy this month’s edition.

Read more

AxioWorks Sales Agent Opportunity 2021

Grow with Us : An Opportunity to Work with AxioWorks

/in , , , , , /by

We are building our Sales network and are actively looking for Sales Agents to join our network. Are you looking for a new challenge or additional products to add to your portfolio? Read on!

Read more

SharePoint Syntex : A Collaboration between Knowledge worker and AI

/in , , , /by

by Danish Ali Detho | O365 & Power Platform Solution Architect///

Background

The use of SharePoint among knowledge workers has significantly increased over time which also increases the reliance of business users on it to make decisions. The content which is getting generated in SharePoint is only useful if business users can make sense of it and understand it in a timely manner and artificial intelligence is the key to improving the efficiency of understanding and processing unstructured content. This can only be achieved through a partnership between knowledge workers and artificial intelligence and in order to facilitate it Microsoft launched Project Cortex at last year’s ignite which focuses on bringing native AI in the world of SharePoint and SharePoint Syntex is the first product to emerge from Project Cortex.

Read more

Use Power Apps AI Builder to extract data from invoices and store them in SharePoint

/in , , , , , /by

by Danish Ali Detho | O365 & Power Platform Solution Architect///

Introduction

Organizations all over the world are trying to find new ways of automating their business processes in order to reduce redundancies, minimize manual data entry and human error. Artificial intelligence plays a significant role when it comes to improving the business process by taking automation to the next level where the process is not only automated but smart and self-sufficient as well.

Microsoft Power Automate provides businesses the capability to automate their business processes easily using their suite of low-code/no-code solutions in Power Platform and now they released a new tool in order to provide them the ability to add artificial intelligence in the form of AI Builder. In this article, we will take a look at AI Builder and the different types of models available for various purposes. We will then create a Form processing model that will extract the form data and then save it in a SharePoint List.

Read more

AxioWorks blog -Microsoft Lists

Microsoft Lists: The Evolution of SharePoint Lists

/in , , /by

SharePoint Lists has played a pivotal role in building customised solutions on top of SharePoint making SharePoint not just a CRM or DMs but a development platform for developing solutions delivering a wide range of business scenarios. Every SharePoint developer/end-user have used lists in one way or another whether it’s just for creating announcements/tasks or storing complex relational data for an application.

But when it comes to list-based scenarios that include share, track and view list-based information, SharePoint Lists out of the box fall short and require some customisation by developers to fulfil business requirements. In order to fill the gap, Microsoft introduced the launch of a new tool in the Microsoft365 world called Microsoft Lists at the MS Built Conference 2020. According to  Microsoft, Lists “makes it simple to create, share and track data and information,” and will offer features like issue tracking and status reporting from within Teams and SharePoint.

Today, we are going to take a good look at this new and shiny tool of Microsoft and how it compares against the SharePoint Lists.

Read more

Which industry hold the lion’s share of SharePoint usage and why?

/in , /by

SharePoint, which was once written off as a failed CMS incapable of gaining a significant user base has now become one of the most widely used ECM and Collaboration product with more than 250,000 organizations including (85% of fortune 500 companies) and over 190 million people using SharePoint/SharePoint Online. One of its main success factors is the ever-increasing rise of digitization and globalization, organizations want their content to be accessible from everywhere by anyone weather it’s an office worker or an engineer in the field. They want to ensure that employees work in a productive environment and don’t face any obstacles in collaboration and communication.

Read more

How secure is your data in SharePoint On-Premise vs Online?

/in , /by

Over the past two decades, Microsoft has made SharePoint one of the most powerful enterprise content management and team collaboration platform available in the market loaded with massive functionality and state of the art security. Data protection and security plays a key role in deciding which variant of SharePoint to go with especially for organizations with critical compliance and governance regulations.

This brings up the question, how secure is your data in SharePoint On-Premises and Online? This article will help you in analyzing the security and data protection features available in SharePoint On-Premise and Online in terms of authentication types, disaster recovery etc.

Read more