AxioWorks Newsletter

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

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

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

AxioWorks SQList New Version

New version of AxioWorks SQList released (7.0.0.0)

A new version of AxioWorks SQList is out today!

We have been really busy for the past few months, but here we are with a brand new release of AxioWorks SQList! Version 7, a major one.

Let’s see what cool new features come with it…

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BICrystal Reports, or SSRS.

Read more

AxioWorks Newsletter

AxioWorks Newsletter June 2021: May has been a month of new releases

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.

From this month, we will do the SQList feature of the month in the form of Vlog (video blog).

What has AxioWorks been up to?

It has been another month full of excitement here @AxioWorks as we launched our new and improved website featuring well-structured content, user-friendly navigation, and a stylish dark theme.

Please check it out and let us know what you think: https://www.axioworks.com

Further more, the wait is finally over and we are pleased to inform you that our most anticipated and feature-rich version SQList version 7 has been released!

Our engineering team have worked extremely hard to include some of the most popular user voice features including:

  • Column selection: to select and rename columns to export at individual list level;
  • Dashboard monitor: see live progress of all lists being replicated;
  • Enhanced multithreading: faster replications across multiple databases;
  • and some more…

Read all the details about the new version in our blog article: New version of AxioWorks SQList released (7.0.0.0)

Focus blog entry: Form Configuration Editor, Built-in SharePoint List Form editor

One of the best features of SharePoint Lists is the out-of-the-box data entry forms. However, most of the time you will need to customize the forms in order to make them more user-friendly for business users. The only way to customize List forms was by using PowerApps but now Microsoft has introduced a new way to do some quick customizations by using Form configuration editor.

Read all about it in this month’s article: Form Configuration Editor, A Lightweight and Built-in SharePoint List Form editor.

SQList feature of the month: Re-sync replicated SQL tables from SharePoint Lists

Sometimes, we need to resynchronize a specific replicated SQL table to the linked SharePoint list. This can be caused by SQL table being accidentally deleted, data getting corrupted, or most commonly list schema or data being updated. This feature can be accessed from the replications section in SQList and it has three different options for resynchronization including:

  • Resynchronise existing rows which has been modified in the SharePoint List;
  • Resynchronise all rows;
  • Drop and recreated a table from scratch.

If you want to know more details about this feature, check out the video blog explaining how it works: Resynchronise SQL tables from SharePoint Lists

Featured articles

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

Two ways to manage row-level security in a SharePoint list

In this article, you will find out how to maintain row-level security in a SharePoint list using row-level security and folder-level security.
Read more…

Microsoft Lists – Create a List from Excel

In this tutorial, Step by step we will discuss how to create an excel file and then we will see how we can use the excel file to create a list in Microsoft lists.
Read more…

5 ways to invite external users to a SharePoint site

Guest access in SharePoint and the ability to collaborate on documents with external users is one of SharePoint’s primary advantages. There are multiple ways to invite external users to the SharePoint site, though. In this article, author will show different options available for inviting external users.
Read more…

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

That’s all folks, till next time.

AxioWorks Newsletter

AxioWorks Newsletter May 2021: April flew by faster than SpaceX

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 Newsletter April 2021: A busy month!

AxioWorks Newsletter April 2021: A busy month!

Welcome to our second Newsletter!

Did you enjoy the first one? Or maybe you didn’t? Either way, do give us some feedback using the links at the bottom of this email, that’ll help us a lot.

Ok, let’s get cracking…

Read more

MS Lists has finally landed in MS Teams

During this Pandemic era, working remotely has significantly increased throughout the world and so is the usage of tools to facilitate collaboration and communication. One such tool is Microsoft Teams which now has 115 million daily active users. That’s a more than 50 percent rise from the 75 million that Microsoft reported almost six months ago. MS Teams has become a preferred tool of communication for companies using Microsoft stack which is why it makes perfect sense to improve its usage for collaboration. SharePoint Lists has been widely used for maintaining and storing data in SharePoint and with the recent launch of Microsoft Lists the usage has grown significantly as well.

Read more

AxioWorks Newsletter March 2021: Our first!

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

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)

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