Posts

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.

AxioWorks SQList New Version

New version of AxioWorks SQList released (7.0.0.0)

/in , , /by

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 BI, Crystal Reports, or SSRS.

Read more

AxioWorks Newsletter

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

/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.

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.

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

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

Create a Power Virtual Agent and integrate it with a SharePoint list

/in , , , /by

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

Introduction

Virtual agents and bots have become an essential part of customer support in every business. It provides the fastest way to provide the information a customer is looking for without waiting for a customer support agent or searching through a website. They can cover large no of use-case scenarios including providing product information, helping with flight/hotel bookings, or tracking orders.
Today we will take a look at how easy it is to create a Power Virtual Agent and integrate it with a SharePoint list using PowerAutomate Flow.

Read more

AxioWorks SQList: Export SharePoint Lists to SQL Server

Access live SharePoint data from SQL Server

/in , /by

In this blog, We will take an in-depth look into how SQList transforms SharePoint lists into SQL tables and how it stores data into each column. We will also look at how all changes made in SharePoint are continuously synchronized into their corresponding SQL Server tables.

Read more

The best way to access SharePoint data from Power BI, SSRS, and other BI tools

/in , , , , /by

Watch our presentation, where we are going to show you the best way to access live SharePoint data from any reporting and BI tool, like Power BI, SSRS, or Crystal Reports.

Read more