Tuesday, December 22, 2020

15 cool Features of Microsoft Teams by Sameer Mohammed

Microsoft Teams is a great tool for collaboration of employees at work. Teams provide a complete platform which comprises of document storage, chat, and online meeting environment. 

The video consists of 15 cool features of Microsoft Teams which makes work and communication easy.  

AQL Technologies will assist you in planning and implementation of Microsoft Teams roll out in your organization. Our team of experts will walk you through the
 process of onboarding to adoption across the complete organization.


List of Tips in the video are:

  1. Blur Technology 
  2. Name Your Chat Group 
  3. Pin Your Chat & Apps 
  4. Edit Last Message using Up Arrow 
  5. Use Commands in Teams 
  6. Add Applications as Tabs to Teams 
  7. Save Chat Messages  
  8. Email a Teams Channel 
  9. Join Team Using Code 
  10. Whiteboard 
  11. Integration with Outlook 
  12. Messaging Extension 
  13. Code Snippets in Team Message 
  14. Keyboard Shortcuts for Microsoft Teams  
  15. Transcribe Recorded Meetings

  To know more about Microsoft Teams, please contact us at reachit@aqltech.com.

Friday, December 18, 2020

Connecting SharePoint Online with BCS

Business Connectivity Services (BCS) is a brand new way for SharePoint users to seamlessly access and integrate data from any application or databases within SharePoint 2010. In this blog, we explore how to connect BCS in SharePoint Online.

SharePoint Online, lets you create BCS connections to data sources that are outside the SharePoint site, like SQL Azure databases or Windows Communication Foundation (WCF) web services. Once you’ve created these connections, you can manage or edit BCS information in the SharePoint admin center.

Understanding BCS Permissions

SharePoint Online uses BCS along with Secure Store Services to access and retrieve data such as BDC Models from external data systems.
BCS has two types of permissions:

  • Object Permissions
  • Meta Data Store Permissions
These are shown in the figure below.


1. Understanding Object Permissions

Object Permissions apply only to a specific External System, BDC Model, or External Content Type (ECT).


2. Understanding Metadata Store Permissions

Metadata Store Permissions apply globally to the whole BCS store. This includes BDC Models, external systems, ECTs, methods, and methods instances that are defined for that external data system. You can set permissions on the metadata store to determine who can edit items and set permissions for the store.

FIGURE 3:SET METADATA STORE PERMISSIONS


The next section explains the various options to connect SharePoint Online to SQL Server On-Premises with BCS/SharePoint Apps using Hybrid Connection and WCF Services.

Exploring Ways to Connect SharePoint Online With Online Data Sources

SharePoint Online cannot directly connect to on-premises data sources such as SQL Server. A recommended approach is to use Hybrid with SharePoint 2013/2016 but adds an overhead of infrastructure and maintenance costs. Using Azure Hybrid Connection and BCS with Azure Web App hosting WCF endpoint, it is possible to expose on-premises SQL data to SharePoint Online and Cloud by External Content Types (ECTs) or SharePoint Hosted Apps.

Connecting Different Data Sources to SharePoint

This section presents two approaches by which BCS can connect on-premise data sources to SharePoint:-
1. Azure Web App hosting WCF Service and External Lists
2. Azure Web App hosting WCF Data Service and Hosted Apps

Connecting Azure Web App hosting WCF Service and External Lists

Using this approach, you can host an Azure Web App hosting WCF Service in Azure which will connect to the SQL Server on-premise using Azure Hybrid connection. After having the data exposed via Azure WCF Service, you can use SharePoint BCS Service to create an External Content Type using SharePoint Designer based on a Web Service.

FIGURE 4: CONNECTING SQL DATABASE (ON-PREMISE) TO MICROSOFT AZURE



Connecting Azure Web App hosting WCF Data Service and Hosted Apps

Using this approach you can host a WCF Data service in Azure Web App and then create a SharePoint hosted app that will consume the fields in the WCF Data service to create an external list. After the external list is created in the SharePoint App, you can use the App Hope page to display the content as needed.


FIGURE 5: CONNECTING AZURE WEB APP HOSTING WCF DATA SERVICE AND HOSTED APPS



Exploring Seven Steps to Connect Office 365/SharePoint Online with External Data


This section explains the seven steps needed to connect Office 365/SharePoint Online with External Data:

1. Selecting an appropriate Microsoft Plan

The first step is to ensure that you have an appropriate Office 365 plan. Microsoft Business Connectivity Services are only available in the Office 365 Enterprise E3 or E4 plans for business or, if you are in the education sector, you can use Education E2 licenses.

2. Considering the Limitations

Compared to the on-premises editions of SharePoint, there are still some limitations vis-a-vis cloud edition. These limitations are:
• No profile pages for external content types
• No offline availability or rich-client integration
• No search integration

Beyond these limitations, you can use BCS to connect to different data sources like WCF web services, O-Data sources and SQL Azure databases.

3. Creating a Security Store Application

The first step is to create a target application in the Secure Store Service. This is needed in order to map a group of users to a single, external data account that can act on their behalf. In SharePoint Online, the only group restricted credentials are possible. In on-premise versions, there are also individual and mappings available. For SQL Azure Databases, the credential type needs to be set to “Windows User Name” and “Windows Password.”

4. Setting Up Connection and External Content Type (ECT)

The easiest way to create a new external content type is to use SharePoint Designer 2013, which can be used to create external content types for Microsoft SQL Azure ta-bles, views or stored procedures. For this you just need to open it and connect it to your site collection using credentials having site collection admin permission. On the left-hand side is a menu item, “External Content Types.” The connection and all CRUD methods such as read list, read item, create, update and delete can be created from here.

5. Understanding the Read / Write Operations

The Read/Write operations are explained in detail below.

Read List Operation:
 The Read List operation is like a select statement without a where clause. It returns by default all columns and all rows from the selected table. Filters can be created allowing the results to be trimmed.

Read Item: The Read Item operation is created so that a specific row of data can be identified and used. Each table, view or stored procedure will require a column where-by each of its values is unique, such as a primary key.

Create Operation:
 The Create Operation is used by the external list when data is being created. The Create Operation contains the statement allowing data to be inserted into the table.

Update Operation: The Update operation provides the ability to make and submit changes back to the external data source via the external list and some Office applications such as Microsoft Excel.

Delete Operation:
 The Delete Operation provides the ability to select a specific row and delete it via the external list.

6. Creating Public Content-Type and Create List

The next step involved in this process is to create an external list that enables users to see and use the data. 
To do this, click “Create Lists & Forms” in the Ribbon. You can specify a name and the default operation for this list.

7. Granting Permissions

To make the newly created external content type available to business users, it is important to set the permissions in the Business Connectivity Service application. This is done through the SharePoint admin center. To do this,

Select Manage BDC Models and External Content Types.

Check the box next to the name of the content type you just created, and then click the Set Object Permissions button. In the dialog box that appears, select the checkboxes for all the permissions that the SharePoint Online users need.

Conclusion

This blog showcased some key steps to connect to Business Connectivity Services in SharePoint Online.
To know more on this topic, feel free to write to us at reachit@aqltech.com.
To check more on customized solutions for Office 365 do visit our website
 http://aqltech.com






Thursday, December 17, 2020

Building a Covid-19 Compliant Workspace for Employees Returning to Work

Covid-19 has left an indelible impact on how we operate as a team, a community, a workforce, and an organization. As we gear up to go back to work, our existing co-working and collaborating concepts need some rethinking. Primarily since so little is known about the disease, and there is no cure yet. Expecting employees who have recovered from Covid-19 to rejoin work can cause anxiety – not only to the employee but also to all the others around them.

Prominent industry organizations like the World Health Organization (WHO), the Center for Disease Control (CDC), Occupational Safety and Health Administration (OSHA), and American Industrial Hygiene Association (AIHA) have collectively arrived at Employee Health and Safety (EHS) guidelines specific to Covid-19 for organizations. The instructions are to ensure a safe return to work and making every workspace safe or ‘Covid-19 compliant.

This blog highlights some of these critical guidelines for businesses planning to restart their operations.

C:\Users\aqlad\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\E86A8017.tmp

Getting a Covid-19 recovered employee to resume work: What employers need to do 

In the current scenario, organizations need to be extra vigilant about all employees’ health, especially those that make a comeback after recovery from Covid-19. This section explains what employers need to do before getting a Covid-19 recovered employee back to work. 

Categorizing Covid-19 Cases:

There are still many uncertainties surrounding Covid-19 and regarding their symptoms, infectiousness, severity, treatment, and recovery. Public health organizations are trying to make sense of what they have seen so far. Based on the severity of the infection, they have been able to categorize patients as follows:

Category 1
: Unconfirmed Covid-19 patients – Patients who were not tested for Coronavirus but exhibited the symptoms and were in self-quarantine.
Category 2: Asymptomatic but confirmed Covid-19 patients.
Category 3: Confirmed Covid-19 patients who recovered without hospitalization. 
Category 4: Confirmed Covid-19 patients who underwent hospitalization. 

Employees falling in any one of the above categories need to resume work on fulfilling the conditions mentioned below by the health associations

Adherence to guidelines for Covid-19 positive cases returning to work   

Covid-19 positive employees should return to work only after complete recovery. Complete recovery implies a whole set of conditions, some of these are listed below. 

  • Employee does not have a fever without a fever-reducing medicine for at least three days (72 hours). 
  • The patient has noticeable and visible improvements in the respiratory system (such as cough /breathlessness) for at least a week (seven days) after the symptoms first appeared.  
  • The patient undergoes double tests where two consecutive tests are conducted with a gap of 24 hours and, both are negative.  
  • It is recommended that the patient limit contact with others for three days after isolation ends. 

Employees can return to work only after meeting the above conditions and the guidelines laid by prominent organizations like CDC, OSHA, and AIHA. 

Returning employees should be aware of the caution they need to exercise, especially limiting their physical interaction with others. At work, they must maintain the six-feet distance, avoid shaking hands, wear a mask, gloves, any other gear as mandated by the job. 

For more information, check the guidelines recommended by the CDC here.
 

(
Link https://www.cdc.gov/coronavirus/2019-ncov/community/guidance-business-response.html) 

Employee health and hygiene at the workplace 

Organizations need to be extra cautious about employee health and hygiene. 

  • Employee health screening is mandatory and should be done every day as a quick detection and proactive preventive measure. The observations must be recorded. Any recordings outside the permissible range can call for further action, like asking the employee to undergo quarantine. 
  • Employers need to scale up hygienic practices across the premises, such as disinfecting commonly used surfaces, protecting keypads at sign-in or payment points, ensuring uninterrupted supply of sanitizer at all times in strategic locations.   
  • As hand washing is one of the most effective defenses, employers need to make sure that employees have ready access to washing facilities. Moreover, these facilities should be well-stocked with soap and paper towels.  
  • Distribution of alcohol-based hand sanitizers and sanitizing wipes should be done throughout the workplace. Routine cleaning of all frequently touched surfaces such as workstations, countertops, and doorknobs is essential. Increased cleaning of common areas using standard cleaning agents can also reduce the risk of the spread of respiratory disease.  

To know more about employers’ role, refer to the CDC’s “Interim Guidance for Businesses and Employers” here. 

Incident reporting and management 

Return to work request management system can be very instrumental, it can be used to implement all the necessary steps to make sure employees and organizations are ready when the employee is coming back at work. Using an Incident Management system with a custom action plan is highly recommended to respond to all Covid-19 related concerns quickly and correctly. The incident management and reporting solution should ensure a quick action for a Covid-19 related emergency. Ideally, the incident management system should be a central portal where employees across locations and offices can report an incident or request coming back to work and expect a response and resolution. 

Sounds daunting? Allow technology to give a helping hand and make you Covid-19 Compliant

The new guidelines, regulations, and practices in the post-pandemic situation add many new operational responsibilities and is a bit overwhelming. More so as there are different aspects to it, like detailed surveillance, monitoring, communication, operational precision, and management.

Besides, the treatment of this situation differs and demands quick response speed with no tolerance for any delays.
 

In such a scenario, a tool that can automate and quicken this can be life-changing, literally, and figuratively. Reporting, handling, tracking, and monitoring operations can be automated with tools like AQL Technologies’ Covid-19 Rapid Response Application.  
 

Rapid Response Application for Covid-19 from AQL Technologies   

AQL’s Covid-19 Rapid Response Application helps organizations track their employee coronavirus concerns, view their incident, response, and health status in rich dashboards, and provide a portal with relevant CDC documentation and other resources. A web-based application built on the Microsoft platform AQL’s Covid-19 Response tool is compatible with Office 365, Azure & Power platform.  

Supported by a desktop and mobile self-service portal, the Covid-19 response tool fully addresses employers’ and employees’ concerns about Covid-19. 
 

Here are some of the key features of the product.  

Customization:
  Can be customized as per an organization’s unique response workflows, processes, and policies.

Portal:
 Serves as a portal for making announcements and sharing relevant information. Updates, FAQs, and newsworthy articles can be shared through the tool. 

Reporting
: Offers enhanced reports and dashboards that give management improved ability to manage teams and employees during the Covid-19 times effectively. 

Contact Tracing:
 Maintains employees’ personal and work emergency contacts along with their current projects. Equipped to handle emergency alert notification via email, text messages, phone calls as needed. Capable of Contact traceability by tracking employee’s daily contact with others, reducing notification time in case of Covid-19 positive outbreak. 

Incident management
: Can keep in touch with quarantine employees regularlyTracks Quarantines & Back to work employees.

Scheduling:
 Allows to manage schedules – whether onsite or remotely – of employees to ensure optimization. 

Operational assistance
: Capable of sharing trigger requests and concerns for sanitization.   

Transparency
:
 Allows businesses to appoint a Covid-19 response team with clearly chalked out responsibilities. 

An enterprise-level application like this can indeed be a powerful tool to restart business operations and put employees at ease. Moreover, it also puts the responsibility of action on every individual, making it a healthy and transparent ecosystem. To know more about the software solution,

write to us today at reachit@aqltech.com or
visit our website : https://aqltech.com/health-safety-application-for-reopening-your-business/