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.

Bring Clarity to your SharePoint with MS Clarity

/in , , , , /by

Introduction

There has been an exponential growth in SharePoint usage over the past few decades due to its vast set of capabilities to fulfill the most challenging business requirements especially transformation towards the modern workplace. One of the primary milestones on the road to the modern workplace is setting up an Intranet Portal which servers a one-stop-shop for information and communication and that’s where SharePoint shines the brightest. However, soon site owners realize the need for understanding how their portal sites are being used or not used and which features are the most popular among the users. One of the key ingredients of improving user experience is to gather insights on the site user behaviours. In order to facilitate this, Microsoft has released a new free-to-use tool called Clarity that comes with some innovative user analytics features to understand how site users are using the sites in real-time in order to help site managers improve their site experiences by better understanding site visitor behaviour.  In this article, we will take an in-depth look at Microsoft Clarity, what it brings to the site, and user analytics table and how it can be integrated in the SharePoint site.

Read more

AxioWorks Newsletter March 2021: Our first!

/in , , , , , /by

We have just sent out our first newsletter and, being it our first one, we thought we dedicate a post to it. All future ones will go out just by email so, if you find this one interesting, please do subscribe!!!

First of all, thank you to all of our current subscribers! We hope you will find this content interesting, We are new at this and very excited about it.

Our plan is to make it a monthly issue and include updates about our company and products, interesting and relevant articles, and anything else we think you may find interesting like – in this issue – the winner of the Logitech C930-E Business Webcam prize draw!

Read more

7 Reasons why SQL Server tables are a better option for reporting then SharePoint Lists

/in , , , , , , /by

SharePoint Lists plays a pivotal role in any SharePoint development primarily because it is the preferred source of data storage in SharePoint. All the great features like security permissions trimming, views, various types of columns, data validations, and entry forms that come out of the box and can be easily configured give SharePoint Lists an edge over any other data storage options. However, there are several scenarios that make SharePoint Lists less desirable especially when it comes to reporting. Reporting becomes very critical when we store business-critical data in SharePoint since it is vital for business users to make decisions. E.g. if you are storing customer orders in SharePoint Lists then soon you will need to develop some reports to get insights on your customer buying trends.

Read more

AxioWorks SQList New Version

New version of AxioWorks SQList released (6.2.1.0)

/in , , , , , , , /by

A new version of AxioWorks SQList is out today!

It’s been a while since we released a new version, it was back in April 2020 and a lot has happened since! (and not much of it was good…)

Anyways, here we are, version 6.2.1.0 is out, let’s take a look at what comes with it.

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

SharePoint lists to PowerBI

Power BI Master/Detail Report from live SharePoint data

/in , , , , /by

In the real-world, reporting often includes master/detail scenario in which a master list item is selected in order to get more details about the entity. In SharePoint, master data will be stored in a list that contains a lookup column of detail list/s, and getting data from multiple lists would require multiple data sources and then modelling their relationships in Power BI. In this blog, I will show you how easy it is to achieve a master-detail scenario on live data coming from SharePoint lists using AxioWorks SQList. We will start off by looking at the lists which we are going to use in this scenario and followed by how we can use SQList to synchronise data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate a report which shows master data in one table and details in the other based on a selection.

Read more

Google Data Studio with SharePoint Data

Use Google Data Studio with SharePoint data

/in , , , /by

In this blog, we will go through essential steps on how to generate a report and chart in Google Data Studio using data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to replicate data from SharePoint Lists to SQL Server database which will later be used in Google Data Studio to generate a chart and to finish things off, we will look at how to display the report in SharePoint.

Read more

Generate Excel Charts and Reports from live SharePoint list data

/in , , , /by

In this blog, I will show you the best way of creating a chart in Ms Excel on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster.

Read more