Tag Archives: microsoft
How to integrate continuous integration and deployment with WordPress on App Service
Why use Continuous integration and deployment with WordPress?
CI/CD is a system that automates steps in software delivery. For WordPress developers, it means less manual work: once you push updates, the system automatically tests and deploys them. It’s like having a assistant that not only speeds up your work but also checks for errors with each update, ensuring your WordPress site runs smoothly. This constant testing and feedback loop means you can fix bugs quickly and improve your site continuously without disrupting the live version. In short, CI/CD makes your development process faster, more efficient, and less error prone.
How to get started with Continuous integration and deployment in WordPress on App Service?
Note: This code integration feature is currently enabled with WordPress on App Service images having tags PHP 8.2 or greater. https://github.com/Azure/wordpress-linux-appservice/tree/main?tab=readme-ov-file#image-details
Part 1: Before integrating code with Git, it is important to decide which files to include. It is recommended that you keep track of a smaller number of files. For example, keeping track of files in wp-content/uploads is inefficient as it might contain large static files. Instead, files like these must be stored on blob storage. Another example is wp_config.php file, since this file contains separate settings for development and production environments.
You should also choose to ignore WordPress core files if you are not making any changes to them.
This is a simple .gitignore file to get you started: (ref: https://github.com/github/gitignore/blob/main/WordPress.gitignore)
*~
*.log
.htaccess
wp-content/uploads/
wp-content/upgrade/
wp-content/cache/
wp-content/backups/
wp-content/backup-db/
wp-content/blogs.dir/
wp-content/advanced-cache.php
wp-content/object-cache.php
wp-content/wp-cache-config.php
sitemap.xml
sitemap.xml.gz
# WP Core
/wp-admin/
/wp-content/index.php
/wp-content/languages
/wp-content/plugins/index.php
/wp-content/themes/index.php
/wp-includes/
/index.php
/license.txt
/readme.html
/wp-*.php
/xmlrpc.php
# Configuration
wp-config.php
Part 2: Downloading WordPress code from App Service
Step 1: Go to Kudu dashboard https://<sitename>.scm.azurewebsites.net/newui (Ref: Kudu Dashboard explained)
Step 2: Go to file manager and download the /site/wwwroot folder as a zip file
Step 3: Extract the zip file, use the gitignore file from step 1, and push it to your remote repository.
Part 3: Enabling CI/CD with GitHub
Step 1: Go to Deployment Center on your app service dashboard.
Step 2: From the Source dropdown, select ‘GitHub’
Step 3: Select the repository and the branch from step 2.
Step 4: Select ‘Add a workflow’ from the workflow options.
Step 5: Under ‘Authentication settings’, it is recommended that you select User-assigned authentication type.
Step 6: Click on Save
Support and Feedback
In case you need any support, you can open a support request at New support request – Microsoft Azure.
For more details about the offering, please visit Announcing the General Availability of WordPress on Azure App Service – Microsoft Tech Community.
If you have any ideas about how we can make WordPress on Azure App Service better, please post your ideas at Post idea · Community (azure.com)
or you could email us at wordpressonazure@microsoft.com to start a conversation.
Microsoft Tech Community – Latest Blogs –Read More
Time incorrect on my Win 11
Hi, I am running Windows 11 23H2 Build 22631.3593
My time zone is set to Dublin, Edinburgh, Lisbon, London which is correct.
Region is United Kingdom
Set time automatically is set to – on
Set time automatically is set to – on
Show time & date in system tray is set to – on
I have synced the the time – Time server – time.windows.com
HOWEVER the time is an hour behind what it should be.
Any ideas on how to get this rectified?
Many thanks
Hi, I am running Windows 11 23H2 Build 22631.3593My time zone is set to Dublin, Edinburgh, Lisbon, London which is correct.Region is United KingdomSet time automatically is set to – onSet time automatically is set to – onShow time & date in system tray is set to – onI have synced the the time – Time server – time.windows.comHOWEVER the time is an hour behind what it should be.Any ideas on how to get this rectified? Many thanks Read More
Lost access to form and responses
Recently, I conducted a survey and had the responses transfer into an excel file so the extended team could track the results. As of yesterday, I tried to check in, as well as someone else with access, and we have both lost access.
I believe it might be due to me deleting a Teams environment that the Form was created in, not knowing that that would lock me out of the form. It is not in my deleted forms, so I believe it still exists, but as I was the sole owner and have no ability to get back into the Teams environment that was removed, I’m wondering if there is any solution to this!
Recently, I conducted a survey and had the responses transfer into an excel file so the extended team could track the results. As of yesterday, I tried to check in, as well as someone else with access, and we have both lost access. I believe it might be due to me deleting a Teams environment that the Form was created in, not knowing that that would lock me out of the form. It is not in my deleted forms, so I believe it still exists, but as I was the sole owner and have no ability to get back into the Teams environment that was removed, I’m wondering if there is any solution to this! Read More
How to set up staging slots in WordPress on App Service
What is a staging site?
A staging site, also called as a development site, testing site, or sandbox – is a clone of your actual WordPress website which cannot be accessed by your visitors. This can only be accessed by people who have the staging URL.
Why do you need a staging site for your WordPress website?
A staging site is extremely useful when you are working on a WordPress website. It provides a safe area for development, testing, and experimentation. When you are trying out a new plugin, theme or custom code, there are chances that the website might break leading to downtime for your users, or even cause irreparable damage to your website like loss of content and data.
Users would not be able to see your work in progress. You can make the changes live when you are ready. A staging site helps you experiment with new plugins without being locked to the changes and troubleshoot in case there are any issues. You do not have to rush making changes since your users are safely using the original version.
Although the staging site is a clone of your original website, the changes do not reflect in the original site until you publish the changes, also known as ‘swapping’. In case a new deployment causes issues, you can easily swap the slots back to previous versions, effectively rolling back the changes.
Staging sites can be immensely useful for scenarios such as A/B testing, allowing you to gather feedback from users and make informed decisions.
How to create a staging site in WordPress on Azure App Service?
Note: We will make use of Deployment slots feature of App Service to create staging sites for our WordPress application. However, this scenario is not completely same as WordPress on App Service also uses an Azure database for MySQL instance.
Scenario 1: Creating a staging site while creating WordPress sites on App Service
Step 1: Go to https://ms.portal.azure.com/#create/WordPress.WordPress . Go to Deployment tab. Check ‘Add staging slot’.
Scenario 2: Creating a staging site for an already created WordPress site on App Service.
There are five parts to this:
Part 1: Create the App Service deployment slot.
Step 1: Once you have a WordPress website on Azure App Service (See how to create one here), go to the App Service Overview. Then go to Deployment Slots.
Step 2: Click on Add Slot
Step 3: Enter your preferred name for the staging slot. In the ‘Clone settings from:’ select the deployment slot from there you wish to copy the settings. In this case, the name of the staging slot is ‘staging’ and deployment slot is ‘wpsite01’. Notice that the staging site can be accessed using the link wpsite01-staging.azurewebsites.net
Click on Add.
Step 4: Now you can see that the staging slot has been added. Click on Close.
Part 2: Connect the staging slot to VNET.
Step 1: Go to App service staging slot.
Step 2: Go to networking.
Step 3: Check outbound networking. If not configured, click on link.
Step 4: Click on connect.
Part 3: Create a new Database in your Azure database for MySQL instance
Step 1: Go to phpMyAdmin by using the URL: https://<yourappname>.azurewebsites.net/phpmyadmin
Step 2: Login using your database credentials. Tip: you will find your database credentials in App Settings.
Step 3: Go to your database
Step 4: Go to Operations. You will see the option “Copy database to”. Add database name. Click on Go.
Part 4: If you are using CDN/AFD with your WordPress site, create a new CDN/AFD endpoint and Blob storage container.
Part 5: Map App Service staging slot to the staging database, CDN, Blob storage.
Step 1: Go to App Service staging slot. Go to Environment Variables.
Step 2: Edit ‘Database name’ to new database name
Step 3: Edit CDN endpoint
Step 4: Edit Blob storage container name
Step 5: Apply. Confirm.
Swapping
Step 1: Now visit the staging site by visiting the website by clicking on the staging slot.
Step 2: This will open the overview page for the staging slot. Notice that this is similar to the overview page of the original web app, only the name of the staging slot is different as set in step 3. Click on the website URL to visit the website. In this case, https://wpsite01-staging.azurewebsites.net/
Step 3: As you can see, the default website appears as the original slot. Since we have made no changes to the original slot, the default website appears.
Step 4: Go to the admin panel of WordPress by adding ‘/wp-admin’ after the address and logging in using your credentials that are same as the original website. Make the desired changes on the website. In this case, the changes look like this:
Step 5: Now go to the original website. In this case, https://wpsite01.azurewebsites.net/
We can see that the original website is present in the original state.
Step 6: Go to the Deployment slots page in Azure Portal. Click on Swap. This will swap the staging and production sites.
Step 7: Select the staging slot as the source and the production slot as the Target. Click on Swap.
Step 8: You can see that the swap operation has been completed. Click on Close.
Step 9: Now visit the original website. In this case, https://wpsite01.azurewebsites.net/
We see that the changes have successfully been published to the production slot. Now your website visitors can see the changes.
Further reading
Deployment slots (Staging sites) can be used for more advanced use cases. Please go through Set up staging environments – Azure App Service | Microsoft Learn to understand more about deployment slots.
Support and Feedback
In case you need any support, you can open a support request at New support request – Microsoft Azure.
For more details about the offering, please visit Announcing the General Availability of WordPress on Azure App Service – Microsoft Tech Community.
If you have any ideas about how we can make WordPress on Azure App Service better, please post your ideas at Post idea · Community (azure.com)
or you could email us at wordpressonazure@microsoft.com to start a conversation.
Microsoft Tech Community – Latest Blogs –Read More
3D styling for indoor maps
Is it possible to extrude walls for an Azure indoor map so rooms give a 3D appearance in a pitch view?
Is it possible to extrude walls for an Azure indoor map so rooms give a 3D appearance in a pitch view? Read More
Issue with document Synchronization in OneDrive and SharePoint
Great day,
I am encountering an issue with the synchronization of photos between the OneDrive app on my mobile device and the SharePoint server. Photos that I upload via my mobile device to a specific folder on SharePoint are visible to other users, but I am unable to see them on my device. Reinstalling the OneDrive app temporarily resolves the issue, but I am seeking a more permanent solution. Could you please assist me in identifying and resolving the cause of this problem?
Thank you for your assistance.
Great day,I am encountering an issue with the synchronization of photos between the OneDrive app on my mobile device and the SharePoint server. Photos that I upload via my mobile device to a specific folder on SharePoint are visible to other users, but I am unable to see them on my device. Reinstalling the OneDrive app temporarily resolves the issue, but I am seeking a more permanent solution. Could you please assist me in identifying and resolving the cause of this problem? Thank you for your assistance. Read More
Change excel file in batch
Hi all,
I have a lot of identical files in the same folder, all born from the same template: the only difference between them is their file name and the values inserted manually in the unlocked cells of each sheet. I’m guessing if there is any way to change the formulas of each file by just changing the original one and get it all reflected at once (let’s say I find out I did a mistake in some cells and want to change for all the files).
I’m up to any solution, even using power automate or some crazy script.
Really hope someone can help,
Many thanks
Hi all, I have a lot of identical files in the same folder, all born from the same template: the only difference between them is their file name and the values inserted manually in the unlocked cells of each sheet. I’m guessing if there is any way to change the formulas of each file by just changing the original one and get it all reflected at once (let’s say I find out I did a mistake in some cells and want to change for all the files). I’m up to any solution, even using power automate or some crazy script. Really hope someone can help,Many thanks Read More
Is it possible to create a fully functional database in excel or should I use Access?
With all the changes happening with Access, Excel, the new Dataverse, etc., I wonder which direction to take.
I am a sole trader and have Microsoft Business Standard. I am willing to justify the cost of this subscription for my business, but I can’t justify any additional expenses.
So, my question concerns business records and the best application for these.
For example, I would like to design a fully functional database that includes a chart of accounts, various client accounts, invoicing capabilities, profit and loss, balance sheets, etc, amongst other things. It will need to have linked categories and subcategories, the ability to auto-complete, and the capability to be complex.
So, should I build it in Access or Excel? Access is now only available on desktops, and Excel is becoming more capable. I seem to be jumping between the two, unable to decide my future direction. Your opinion and expertise would be much appreciated regarding my conundrum.
With all the changes happening with Access, Excel, the new Dataverse, etc., I wonder which direction to take.I am a sole trader and have Microsoft Business Standard. I am willing to justify the cost of this subscription for my business, but I can’t justify any additional expenses.So, my question concerns business records and the best application for these.For example, I would like to design a fully functional database that includes a chart of accounts, various client accounts, invoicing capabilities, profit and loss, balance sheets, etc, amongst other things. It will need to have linked categories and subcategories, the ability to auto-complete, and the capability to be complex.So, should I build it in Access or Excel? Access is now only available on desktops, and Excel is becoming more capable. I seem to be jumping between the two, unable to decide my future direction. Your opinion and expertise would be much appreciated regarding my conundrum. Read More
Project operations with nonprofit accelerator
Is there any native integration between Microsoft project operations with nonprofit accelerator?
Is there any native integration between Microsoft project operations with nonprofit accelerator? Read More
Windows 11 Insider Preview 10.0.22635.3640 (ni_release) Download error – 0x80248007
I have been trying to update Windows 11 Insider Preview 10.0.22635.3640 (ni_release) all day the update keeps on failing have been getting Download error all day I am now up to Download error – 0x80248007 if you can help email me email address removed for privacy reasons.
I have been trying to update Windows 11 Insider Preview 10.0.22635.3640 (ni_release) all day the update keeps on failing have been getting Download error all day I am now up to Download error – 0x80248007 if you can help email me email address removed for privacy reasons. Read More
Build a chatbot service to ensure safe conversations: Using Azure OpenAI & Azure Content Safety
Build a chatbot service to ensure safe conversations: Using Azure OpenAI & Azure Content Safety
Why should we care about the safety of our chat service?
When you deploy a chat service on a website, users may enter inappropriate or harmful messages that can lead to unwanted responses from the chatbot. This can pose significant risks, including the potential for revealing sensitive company information or allowing other users’ messages to influence the chatbot’s responses. That’s why it’s critical to implement a content filtering mechanism that can inspect messages from users. Azure Content Safety provides a robust solution for inspecting and filtering inappropriate content, ensuring safe and secure interactions. This tutorial is ideal for anyone who wants to build a chat service with strong content moderation capabilities. In this tutorial, you will learn how to build a chatbot service that interacts with users using Azure Cosmos DB, Azure Content Safety, and Azure OpenAI. This service provides the following features:
Analyze user messages for safety: Analyze messages entered by users using Azure Content Safety to evaluate them for hate, self-harm, sexual content, and violence.
Conversations with chatbot: Conduct conversations about safe messages using Azure OpenAI.
Manage conversation history: Store a user’s conversation history in Azure Cosmos DB and load or clear the history as needed.
Here is an overview of this tutorial.
This tutorial is related to the following topics:
AI Engineer
Developer
Azure CosmosDB
Azure Content Safety
Azure OpenAI
Semantic Kernel
Prerequisites
Python
Azure subscription
Visual Studio Code
Microsoft Cloud Technologies used in this Tutorial
Azure CosmosDB
Azure Content Safety
Azure OpenAI Service
Table of Contents
Create an Azure CosmosDB
Create an Azure Content Safety
Create an Azure OpenAI
Set up the project and install the libraries
Set up the project in Visual Studio Code
Set up and initialize the ChatbotService class with Azure Services
Implement core functions in ChatbotService
Run the main function and test the ChatbotService
Congratulations!
Full code for tutorial
Create an Azure CosmosDB
To store and load your chat history, you need to create an Azure Cosmos DB resource.
In this exercise, you will:
Create an Azure Cosmos DB account to store your chat history.
Create a container within Azure Cosmos DB to store and manage chat messages.
Create an Azure CosmosDB account
Type cosmos db in the search bar at the top of the portal page and select Azure Cosmos DB from the options that appear.
Select + Create from the navigation menu.
Select Azure Cosmos DB for NoSQL from the navigation menu.
Perform the following tasks:
Select your Azure Subscription.
Select the Resource group to use (create a new one if needed).
Enter Account Name. It must be a unique value.
Select the Availability Zones to Disable.
Select the Location you’d like to use.
Select the Capacity mode to Provisioned throughput.
Select the Apply Free Tier Discount to Apply.
Select the Limit total account throughput to prevent unexpected charges.
Select Review + Create.
Select Create.
Create an Azure CosmosDB database and container
Navigate to the Azure CosmosDB resource that you created.
Select Data Explorer from the left side tab.
Select New Container from the navigation menu.
Perform the following tasks:
Select the Database id to Create new.
Enter database id. It must be a unique value.
Select the Database throughtput (autoscale) to Autoscale.
Enter Database Max RU/s as 1000.
Enter Container id. It must be a unique value.
Select the Indexing to Automatic.
Enter Partition key as /userId.
Select OK.
Create an Azure Content Safety
To create a service to detect inappropriate content, you need to create an Azure Content Safety resource.
In this exercise, you will:
Create an Azure Content Safety to detect inappropriate content.
Create an Azure Content Safety resource
Type content safety in the search bar at the top of the portal page and select Content safety from the options that appear.
Select + Create from the navigation menu.
Perform the following tasks:
Select your Azure Subscription.
Select the Resource group to use (create a new one if needed).
Select the Region you’d like to use.
Enter Content safety name. It must be a unique value.
Select the Free F0 pricing tier.
Select Review + Create.
Select Create.
Create an Azure OpenAI
To enable your chat service to provide answers based on chat history stored in Azure Cosmos DB, you need to create and deploy an Azure OpenAI resource.
In this exercise, you will:
Create an Azure OpenAI resource.
Deploy Azure OpenAI models.
Note
Access to the Azure OpenAI service is currently available by request. To request access, please fill out the form on the Azure OpenAI request page.
Create an Azure OpenAI resource
Type azure openai in the search bar at the top of the portal page and select Azure OpenAI from the options that appear.
Select + Create from the navigation menu.
Perform the following tasks:
Select your Azure Subscription.
Select the Resource group to use (create a new one if needed).
Select the Region you’d like to use.
Enter Azure OpenAI Name. It must be a unique value.
Select the Standard S0 pricing tier.
Note
To minimize costs, try to create all the resources in the same region.
Select Next to move to the Network page.
Select a network security Type.
Select Next to move to the Tags page.
Select Next to move to the Review + submit page.
Select Create.
Deploy Azure OpenAI models
Navigate to the Azure OpenAI resource that you created.
Select Go to Azure OpenAI Studio from the navigation menu.
Inside Azure OpenAI Studio, select Deployments from the left side tab.
Select + Create new deployment from the navigation menu to create a new gpt-35-turbo deployment.
Perform the following tasks:
For the model, select gpt-35-turbo.
For the Model version, select Default.
For the Deployment name, add a name that’s unique to this cloud instance. For example, gpt-35-turbo.
Select Create.
Now you’ve learned how to set up Azure resources to implement features that allow the Azure Content Safety resource to analyze conversations and Azure OpenAI to generate responses. In the next exercise, you will develop a Python program that interacts with users to ensure safe conversations.
Set up the project and install the libraries
Now, you will create a folder to work in and set up a virtual environment to develop a program.
In this exercise, you will
Create a folder to work inside it.
Create a virtual environment.
Install the required packages.
Create a folder to work inside it
Open a terminal window and type the following command to create a folder named safety-chatbot in the default path.
mkdir safety-chatbot
Type the following command inside your terminal to navigate to the safety-chatbot folder you created.
cd safety-chatbot
Create a virtual environment
Type the following command inside your terminal to create a virtual environment named .venv.
python -m venv .venv
Type the following command inside your terminal to activate the virtual environment.
.venvScriptsactivate.bat
Note
If it worked, you should see (.venv) before the command prompt.
Install the required packages
Type the following commands inside your terminal to install the required packages.
pip install azure-cosmos==4.6.0
pip install azure-ai-contentsafety==1.0.0
pip install semantic-kernel==0.9.7b1
Set up the project in Visual Studio Code
To develop a program that uses the Azure resources that you created, you need config.py file to enter Azure information.
In this exercise, you will:
Create an example.py file.
Import the required packages.
Create a config.py file to enter Azure information.
Set up example.py file
Open Visual Studio Code.
Select File from the menu bar.
Select Open Folder.
Select the safety-chatbot folder that you created, which is located at C:UsersyourUserNamesafety-chatbot.
In the left pane of Visual Studio Code, right-click and select New File to create a new file named example.py.
Add the following code to the example.py file to import the required libraries.
# Library imports
import asyncio
from datetime import datetime, timezone
from concurrent.futures import ThreadPoolExecutor
# Azure imports
from azure.ai.contentsafety.aio import ContentSafetyClient
from azure.ai.contentsafety.models import AnalyzeTextOptions, TextCategory
from azure.core.credentials import AzureKeyCredential
from azure.core.exceptions import HttpResponseError
from azure.cosmos import CosmosClient
# Semantic Kernel imports
import semantic_kernel as sk
import semantic_kernel.connectors.ai.open_ai as sk_oai
from semantic_kernel.connectors.ai.open_ai import AzureChatCompletion
from semantic_kernel.prompt_template import PromptTemplateConfig
from semantic_kernel.prompt_template.input_variable import InputVariable
from semantic_kernel.functions.kernel_arguments import KernelArguments
Set up config.py file
In the left pane of Visual Studio Code, right-click and select New File to create a new file named config.py.
Note
Complete folder structure:
└── YourUserName
└── safety-chatbot
├── example.py
└── config.py
Add the following code to the config.py file to include your Azure information.
# Azure Cosmos DB settings
AZURE_COSMOSDB_ACCOUNT_NAME = ‘your-cosmosdb-account-name’ # ‘safetychatbot-storage’
AZURE_COSMOSDB_DATABASE_NAME = ‘your-cosmosdb-database-name’ # ‘safetychatbot-database’
AZURE_COSMOSDB_CONTAINER_NAME = ‘your-cosmosdb-container-name’ # ‘safetychatbot-container’
AZURE_COSMOSDB_ENDPOINT = f’https://{AZURE_COSMOSDB_ACCOUNT_NAME.lower()}.documents.azure.com:443/’
AZURE_COSMOSDB_KEY = ‘your-cosmosdb-key’
# Azure Content Safety settings
AZURE_CONTENT_SAFETY_NAME = ‘your-content-safety-name’ # ‘safetychatbot-contentsafety’
AZURE_CONTENT_SAFETY_ENDPOINT = f’https://{AZURE_CONTENT_SAFETY_NAME.lower()}.cognitiveservices.azure.com/’
AZURE_CONTENT_SAFETY_KEY = ‘your-content-safety-key’
# Azure OpenAI settings
AZURE_OPENAI_NAME = ‘safetychatbot-openai’
AZURE_OPENAI_ENDPOINT = f’https://{AZURE_OPENAI_NAME.lower()}.openai.azure.com/’
AZURE_OPENAI_KEY = ‘your-openai-key’
AZURE_OPENAI_API_VERSION = ‘your-API-version’ # ‘2023-08-01-preview’
AZURE_OPENAI_CHAT_DEPLOYMENT_NAME = ‘your_chat_deployment_name’ # ‘gpt-35-turbo’
Add Azure Environment Variables
Perform the following tasks to add the Azure Cosmos DB account name:
Navigate to the Azure CosmosDB resource that you created.
Copy and paste your account name into the config.py file.
Perform the following tasks to add the Azure Cosmos DB database name:
Navigate to the Azure Cosmos DB resource that you created.
Select Data Explorer from the left side tab.
Copy and paste your database name into the config.py file.
Perform the following tasks to add the Azure Cosmos DB container name:
Navigate to the Azure Cosmos DB resource that you created.
Select Data Explorer from the left side tab.
Copy and paste your container name into the config.py file.
Perform the following tasks to add the Azure Cosmos DB key:
Navigate to the Azure CosmosDB resource that you created.
Select Keys from the left side tab.
Copy and paste your key into the config.py file.
Perform the following tasks to add the Azure Content Safety name:
Navigate to the Azure Content Safety resource that you created.
Copy and paste your resource name into the config.py file.
Perform the following tasks to add the Azure Content Safety key:
Navigate to the Azure Content Safety resource that you created.
Select Keys and Endpoint from the left side tab.
Copy and paste your key into the config.py file.
Perform the following tasks to add the Azure OpenAI name:
Navigate to the Azure OpenAI resource that you created.
Copy and paste your resource name into the config.py file.
Perform the following tasks to add the Azure OpenAI key:
Navigate to the Azure OpenAI resource that you created.
Select Keys and Endpoint from the left side tab.
Copy and paste your key into the config.py file.
Perform the following task to add the Azure OpenAI API versions:
Select the appropriate Azure OpenAI API version. you can refer to the Azure OpenAI Service REST API reference documents.
Note
In this tutorial, you use the 2024-02-15-preview version of the Azure OpenAI API.
Copy and paste your Azure OpenAI API versions into the config.py file.
Set up and initialize the ChatbotService class with Azure Services
To implement the ChatbotService for handling chat interactions and Azure services, you need to import the Azure information from the config.py file into the example.py file and implement a class that efficiently orchestrates these functionalities.
In this exercise, you will:
Import Azure information from the config.py file into the example.py file.
Create the ChatbotService class to efficiently manage chat interactions and integrate Azure service capabilities.
Note
The complete code for this tutorial is provided at the end to make it easy to connect the pieces and understand the overall implementation.
Set up and initialize the ChatbotService class with Azure Services
To implement the ChatbotService for handling chat interactions and Azure services, you need to import the Azure information from the config.py file into the example.py file and implement a class that efficiently orchestrates these functionalities.
In this exercise, you will:
Import Azure information from the config.py file into the example.py file.
Create the ChatbotService class to efficiently manage chat interactions and integrate Azure service capabilities.
Note
The complete code for this tutorial is provided at the end to make it easy to connect the pieces and understand the overall implementation.
Import Azure information from the config.py file
Add the following code to the example.py file to import the values from config.py file.
# Configuration imports
from config import (
AZURE_COSMOSDB_DATABASE_NAME,
AZURE_COSMOSDB_CONTAINER_NAME,
AZURE_COSMOSDB_ENDPOINT,
AZURE_COSMOSDB_KEY,
AZURE_CONTENT_SAFETY_ENDPOINT,
AZURE_CONTENT_SAFETY_KEY,
AZURE_OPENAI_ENDPOINT,
AZURE_OPENAI_KEY,
AZURE_OPENAI_CHAT_DEPLOYMENT_NAME
)
Create the ChatbotService Class
Add the following code to the example.py file to set up the ChatbotService class. This class initializes Azure Cosmos DB for NoSQL, which is a NoSQL database service that handles database operations synchronously.
class ChatbotService:
def __init__(self, loop, user_id):
“””
Initialize the ChatbotService with event loop, user ID, and necessary Azure CosmosDB clients.
“””
# Set up the event loop and thread pool executor for managing asynchronous tasks,
# allowing Azure Cosmos DB operations to be handled in an asynchronous environment
self.loop = loop
self.executor = ThreadPoolExecutor()
# Store the user ID, which is used as the partition key (/userId) in Azure CosmosDB
self.user_id = user_id
# Initialize the Azure Cosmos DB client
self.cosmos_client = CosmosClient(AZURE_COSMOSDB_ENDPOINT, credential=AZURE_COSMOSDB_KEY)
# Initialize the Azure Cosmos DB database client
self.database = self.cosmos_client.get_database_client(AZURE_COSMOSDB_DATABASE_NAME)
# Initialize the Azure Cosmos DB container client
self.container = self.database.get_container_client(AZURE_COSMOSDB_CONTAINER_NAME)
Add the following code to the example.py file to initialize the Azure Content Safety client and the Semantic Kernel within the ChatbotService class. This step sets up the asynchronous operations required for Content Safety analysis and chatbot interactions.
async def init(self):
“””
Initialize the Content Safety client and Semantic Kernel.
“””
# Initialize the Azure Content Safety client
self.content_safety_client = ContentSafetyClient(AZURE_CONTENT_SAFETY_ENDPOINT, AzureKeyCredential(AZURE_CONTENT_SAFETY_KEY))
# Initialize the Semantic Kernel
self.kernel = sk.Kernel()
# Initialize the chat service for Azure OpenAI
self.chat_service = AzureChatCompletion(
service_id=’chat_service’,
deployment_name=AZURE_OPENAI_CHAT_DEPLOYMENT_NAME,
endpoint=AZURE_OPENAI_ENDPOINT,
api_key=AZURE_OPENAI_KEY
)
# Add the chat service to the Semantic Kernel
self.kernel.add_service(self.chat_service)
# Define the prompt template configuration for the chatbot
self.prompt_template_config = PromptTemplateConfig(
template=”””ChatBot can have a conversation with you about any topic.
It can give explicit instructions or say ‘I don’t know’ if it does not have an answer.
{{$history}}
User: {{$user_message}}
ChatBot: “””,
name=’chat_prompt_template’,
template_format=’semantic-kernel’,
input_variables=[
InputVariable(name=’user_message’, description=’The user message.’, is_required=True),
InputVariable(name=’history’, description=’The conversation history’, is_required=True),
],
execution_settings=sk_oai.OpenAIChatPromptExecutionSettings(
service_id=’chat_service’,
ai_model_id=’gpt-3.5-turbo’,
max_tokens=500,
temperature=0.7
)
)
# Add the chat function to the Semantic Kernel
self.chat_function = self.kernel.add_function(
function_name=”chat_function”,
plugin_name=”chat_plugin”,
prompt_template_config=self.prompt_template_config,
)
return self
Note
Why is the Constructor Split?
When setting up the ChatbotService, the constructor is split into two parts: __init__ and async init. This separation is critical for effectively managing both synchronous and asynchronous operations required by different Azure services. Azure Cosmos DB for NoSQL operates in a synchronous environment, while Azure Content Safety and the Semantic Kernel benefit from asynchronous operations. This requires a clear distinction between synchronous and asynchronous initialization.
Implement core functions in ChatbotService
To implement the core functions of the ChatbotService for handling chat interactions and integrating with Azure services, you need to add several methods to the class. These methods enable text analysis, chatbot interactions, and conversation history management.
In this exercise, you will:
Implement a method to analyze text for safety using Azure Content Safety.
Implement a method to interact with the chatbot using the Semantic Kernel.
Implement methods to store, load, and clear the conversation history in Azure Cosmos DB.
Add the following code to the ChatbotService class to create the analyze_text function that analyze the input text for safety using Azure Content Safety.
async def analyze_text(self, text):
“””
Analyze the input text for safety using Azure Content Safety.
“””
# Create a request with the input text to be analyzed
request = AnalyzeTextOptions(text=text)
try:
# Send the request to the Azure Content Safety client and await the response
response = await self.content_safety_client.analyze_text(request)
# Get the analysis results for different categories
results = {
‘hate’: next((item for item in response.categories_analysis if item.category == TextCategory.HATE), None),
‘self_harm’: next((item for item in response.categories_analysis if item.category == TextCategory.SELF_HARM), None),
‘sexual’: next((item for item in response.categories_analysis if item.category == TextCategory.SEXUAL), None),
‘violence’: next((item for item in response.categories_analysis if item.category == TextCategory.VIOLENCE), None),
}
# Print content safety analysis results
print(“n<– Content Safety Analysis Results –>”)
for category, result in results.items():
if result:
print(f”{category.capitalize()} severity: {result.severity}”)
print(“<– End of Content Safety Analysis Results –>n”)
# Define a threshold for the text to be considered unsafe
threshold = 2
# Based on the threshold, determine if the text is safe
is_safe = not any(result and result.severity >= threshold for result in results.values())
return is_safe, results
except HttpResponseError as e:
# Handle any HTTP response errors that occur during the request
print(f”Failed to analyze text. Error: {e}”)
Add the following code to the ChatbotService class to create the chat_with_kernel function that interacts with the chatbot using the semantic kernel and history provided.
async def chat_with_kernel(self, user_message, history):
“””
Interact with the chatbot using the Semantic Kernel and provided history.
“””
# Create arguments for the chat function using the user message and conversation history stored in Azure Cosmos DB
arguments = KernelArguments(user_message=user_message, history=history)
# Invoke the chat function in the Semantic Kernel with the provided arguments and await the response
response = await self.kernel.invoke(self.chat_function, arguments)
# Return the chatbot’s response
return response
Add the following code to the ChatbotService class to create the store_interaction and _store_interaction_sync functions that store user interactions with the chatbot in Azure Cosmos DB.
async def store_interaction(self, user_message, chat_response):
“””
Store the user interaction with the chatbot in Azure Cosmos DB.
“””
# Run the _store_interaction_sync method in an asynchronous execution environment
await self.loop.run_in_executor(self.executor, self._store_interaction_sync, user_message, chat_response)
def _store_interaction_sync(self, user_message, chat_response):
“””
Synchronously store the interaction in Azure Cosmos DB.
“””
# Get the current time in UTC
current_time = datetime.now(timezone.utc)
# Upsert (insert or update) the interaction data into the Cosmos DB container
self.container.upsert_item({
‘id’: str(current_time.timestamp()), # Use the current timestamp as a unique ID
‘user_message’: user_message, # Store the user message
‘bot_response’: chat_response, # Store the chatbot response
‘timestamp’: current_time.isoformat(), # Store the timestamp in ISO format
‘userId’: self.user_id # Store the user ID for partition key
})
Add the following code to the ChatbotService class to create the load_historical_context and _load_historical_context_sync functions that load the user’s chat history from Azure Cosmos DB.
async def load_historical_context(self):
“””
Load the user’s chat history from Azure Cosmos DB.
“””
# Run the _load_historical_context_sync method in an asynchronous execution environment
return await self.loop.run_in_executor(self.executor, self._load_historical_context_sync)
def _load_historical_context_sync(self):
“””
Synchronously load the user’s chat history from Azure Cosmos DB.
“””
# Define the query to select items for the current user, ordered by timestamp
query = “SELECT * FROM c WHERE c.userId = @userId ORDER BY c.timestamp DESC”
parameters = [{“name”: “@userId”, “value”: self.user_id}]
# Execute the query and retrieve the items
items = list(self.container.query_items(query=query, parameters=parameters, enable_cross_partition_query=True))
# Include only the last 5 conversations
history_items = items[:5]
# Format the conversion history
return “n”.join([f”User: {item[‘user_message’]}nChatBot: {item[‘bot_response’]}” for item in history_items])
Add the following code to the ChatbotService class to create the clear_historical_context and _clear_historical_context_sync functions that clear the user’s chat history from Azure Cosmos DB.
async def clear_historical_context(self):
“””
Clear the user’s chat history from Azure Cosmos DB.
“””
# Run the _clear_historical_context_sync method in an asynchronous execution environment
await self.loop.run_in_executor(self.executor, self._clear_historical_context_sync)
def _clear_historical_context_sync(self):
“””
Synchronously clear the user’s chat history from Azure Cosmos DB.
“””
# Define the query to select items for the current user
query = “SELECT * FROM c WHERE c.userId = @userId”
parameters = [{“name”: “@userId”, “value”: self.user_id}]
# Execute the query and retrieve the items
items = list(self.container.query_items(query=query, parameters=parameters, enable_cross_partition_query=True))
# Clear the chat history by deleting all items for the current user
for item in items:
self.container.delete_item(item, partition_key=self.user_id)
Run the main function and test the ChatbotService
In this exercise, you will implement the main function that manages user interactions, analyzes and stores conversation history using Azure Cosmos DB, Azure Content Safety, Azure OpenAI, and the Semantic Kernel.
In this exercise, you will:
Create the main function to manage user interactions and perform safety checks.
Run the program to see if it works well.
Add the following code to create the main function in the example.py file that handles user inputs, manages chat history, and interacts with the chatbot service.
async def main():
“””
Main function to run the chatbot service.
“””
# Enter the User ID to join the chat.
# A conversation history is stored based on the user ID.
user_id = input(“User ID: “)
# Get the event loop to allow synchronous operations in Azure Cosmos DB for NoSQL to run asynchronously.
loop = asyncio.get_running_loop()
# Initialize the ChatbotService with the event loop and user ID
chatbot_service = await ChatbotService(loop, user_id).init()
# Main loop for the interaction with the user
while True:
user_message = input(“You: “)
# Exit the chat loop if the user types ‘exit’
if user_message.lower() == ‘exit’:
break
elif user_message.lower() == ‘history’:
# Load and print the chat history if the user types ‘history’
history = await chatbot_service.load_historical_context()
print(f”n<– Chat history of user ID: {user_id} –>”)
print(history)
print(f”<– End of chat history of user ID: {user_id} –>n”)
elif user_message.lower() == ‘clear’:
# Clear the chat history if the user types ‘clear’
await chatbot_service.clear_historical_context()
print(“Chat history cleared.”)
else:
# Analyze the text for safety
is_safe, _ = await chatbot_service.analyze_text(user_message)
if is_safe:
# Load chat history and interact with the chatbot if the message is safe
history = await chatbot_service.load_historical_context()
chat_response = await chatbot_service.chat_with_kernel(user_message, history)
print(“Chatbot:”, chat_response)
# Store the interaction in Cosmos DB
await chatbot_service.store_interaction(user_message, str(chat_response))
else:
# Inform the user if their message is not safe
print(“Chatbot: Your message is not safe to process. Please rephrase and try again.”)
if __name__ == “__main__”:
asyncio.run(main())
Type the following command inside your terminal to run the program and see if it can answer questions.
python example.py
This will start the chatbot service, prompting you to enter a User ID and interact with the chatbot. You can enter exit to end the session, history to view past interactions, and clear to current user’s chat history. Here’s an example of the results.
Congratulations!
You’ve completed this tutorial
Congratulations! You’ve successfully learned how to integrate Azure Content Safety with Azure OpenAI. In this tutorial, you have navigated through a practical journey of integrating Azure Cosmos DB, Azure Content Safety, and Azure OpenAI to create a robust chatbot service. By leveraging these Azure services, you now have a chatbot that can safely and effectively interact with users, analyze and store conversations, and ensure content safety.
Clean Up Azure Resources
Cleanup your Azure resources to avoid additional charges to your account. Go to the Azure portal and delete the following resources:
The Azure Cosmos DB resource
The Azure Content Safety resource
The Azure OpenAI resource
Next Steps
Documentation
Azure AI Content Safety documentation
Azure OpenAI Service documentation
Training Content
Get started with Azure Cosmos DB for NoSQL
Moderate content and detect harm with Azure AI Content Safety Studio
Develop Generative AI solutions with Azure OpenAI Service
Full code for tutorial
Note
This exercise is designed to provide the complete code used in the tutorial. It is a separate exercise from the rest of the tutorial.
config.py
# Azure Cosmos DB settings
AZURE_COSMOSDB_ACCOUNT_NAME = ‘your-cosmosdb-account-name’ # ‘safetychatbot-storage’
AZURE_COSMOSDB_DATABASE_NAME = ‘your-cosmosdb-database-name’ # ‘safetychatbot-database’
AZURE_COSMOSDB_CONTAINER_NAME = ‘your-cosmosdb-container-name’ # ‘safetychatbot-container’
AZURE_COSMOSDB_ENDPOINT = f’https://{AZURE_COSMOSDB_ACCOUNT_NAME.lower()}.documents.azure.com:443/’
AZURE_COSMOSDB_KEY = ‘your-cosmosdb-key’
# Azure Content Safety settings
AZURE_CONTENT_SAFETY_NAME = ‘your-content-safety-name’ # ‘safetychatbot-contentsafety’
AZURE_CONTENT_SAFETY_ENDPOINT = f’https://{AZURE_CONTENT_SAFETY_NAME.lower()}.cognitiveservices.azure.com/’
AZURE_CONTENT_SAFETY_KEY = ‘your-content-safety-key’
# Azure OpenAI settings
AZURE_OPENAI_NAME = ‘safetychatbot-openai’
AZURE_OPENAI_ENDPOINT = f’https://{AZURE_OPENAI_NAME.lower()}.openai.azure.com/’
AZURE_OPENAI_KEY = ‘your-openai-key’
AZURE_OPENAI_API_VERSION = ‘your-API-version’ # ‘2024-02-15-preview’
AZURE_OPENAI_CHAT_DEPLOYMENT_NAME = ‘your_chat_deployment_name’ # ‘gpt-35-turbo’
example.py
# Library imports
import asyncio
from datetime import datetime, timezone
from concurrent.futures import ThreadPoolExecutor
# Azure imports
from azure.ai.contentsafety.aio import ContentSafetyClient
from azure.ai.contentsafety.models import AnalyzeTextOptions, TextCategory
from azure.core.credentials import AzureKeyCredential
from azure.core.exceptions import HttpResponseError
from azure.cosmos import CosmosClient
# Semantic Kernel imports
import semantic_kernel as sk
import semantic_kernel.connectors.ai.open_ai as sk_oai
from semantic_kernel.connectors.ai.open_ai import AzureChatCompletion
from semantic_kernel.prompt_template import PromptTemplateConfig
from semantic_kernel.prompt_template.input_variable import InputVariable
from semantic_kernel.functions.kernel_arguments import KernelArguments
# Configuration imports
from config import (
AZURE_COSMOSDB_DATABASE_NAME,
AZURE_COSMOSDB_CONTAINER_NAME,
AZURE_COSMOSDB_ENDPOINT,
AZURE_COSMOSDB_KEY,
AZURE_CONTENT_SAFETY_ENDPOINT,
AZURE_CONTENT_SAFETY_KEY,
AZURE_OPENAI_ENDPOINT,
AZURE_OPENAI_KEY,
AZURE_OPENAI_CHAT_DEPLOYMENT_NAME
)
class ChatbotService:
def __init__(self, loop, user_id):
“””
Initialize the ChatbotService with event loop, user ID, and necessary Azure CosmosDB clients.
“””
# Set up the event loop and thread pool executor for managing asynchronous tasks,
# allowing Azure Cosmos DB operations to be handled in an asynchronous environment
self.loop = loop
self.executor = ThreadPoolExecutor()
# Store the user ID, which is used as the partition key (/userId) in Azure CosmosDB
self.user_id = user_id
# Initialize the Azure Cosmos DB client
self.cosmos_client = CosmosClient(AZURE_COSMOSDB_ENDPOINT, credential=AZURE_COSMOSDB_KEY)
# Initialize the Azure Cosmos DB database client
self.database = self.cosmos_client.get_database_client(AZURE_COSMOSDB_DATABASE_NAME)
# Initialize the Azure Cosmos DB container client
self.container = self.database.get_container_client(AZURE_COSMOSDB_CONTAINER_NAME)
async def init(self):
“””
Initialize the Content Safety client and Semantic Kernel.
“””
# Initialize the Azure Content Safety client
self.content_safety_client = ContentSafetyClient(AZURE_CONTENT_SAFETY_ENDPOINT, AzureKeyCredential(AZURE_CONTENT_SAFETY_KEY))
# Initialize the Semantic Kernel
self.kernel = sk.Kernel()
# Initialize the chat service for Azure OpenAI
self.chat_service = AzureChatCompletion(
service_id=’chat_service’,
deployment_name=AZURE_OPENAI_CHAT_DEPLOYMENT_NAME,
endpoint=AZURE_OPENAI_ENDPOINT,
api_key=AZURE_OPENAI_KEY
)
# Add the chat service to the Semantic Kernel
self.kernel.add_service(self.chat_service)
# Define the prompt template configuration for the chatbot
self.prompt_template_config = PromptTemplateConfig(
template=”””ChatBot can have a conversation with you about any topic.
It can give explicit instructions or say ‘I don’t know’ if it does not have an answer.
{{$history}}
User: {{$user_message}}
ChatBot: “””,
name=’chat_prompt_template’,
template_format=’semantic-kernel’,
input_variables=[
InputVariable(name=’user_message’, description=’The user message.’, is_required=True),
InputVariable(name=’history’, description=’The conversation history’, is_required=True),
],
execution_settings=sk_oai.OpenAIChatPromptExecutionSettings(
service_id=’chat_service’,
ai_model_id=’gpt-3.5-turbo’,
max_tokens=500,
temperature=0.7
)
)
# Add the chat function to the Semantic Kernel
self.chat_function = self.kernel.add_function(
function_name=”chat_function”,
plugin_name=”chat_plugin”,
prompt_template_config=self.prompt_template_config,
)
return self
async def analyze_text(self, text):
“””
Analyze the input text for safety using Azure Content Safety.
“””
# Create a request with the input text to be analyzed
request = AnalyzeTextOptions(text=text)
try:
# Send the request to the Azure Content Safety client and await the response
response = await self.content_safety_client.analyze_text(request)
# Get the analysis results for different categories
results = {
‘hate’: next((item for item in response.categories_analysis if item.category == TextCategory.HATE), None),
‘self_harm’: next((item for item in response.categories_analysis if item.category == TextCategory.SELF_HARM), None),
‘sexual’: next((item for item in response.categories_analysis if item.category == TextCategory.SEXUAL), None),
‘violence’: next((item for item in response.categories_analysis if item.category == TextCategory.VIOLENCE), None),
}
# Print content safety analysis results
print(“n<– Content Safety Analysis Results –>”)
for category, result in results.items():
if result:
print(f”{category.capitalize()} severity: {result.severity}”)
print(“<– End of Content Safety Analysis Results –>n”)
# Define a threshold for the text to be considered unsafe
threshold = 2
# Based on the threshold, determine if the text is safe
is_safe = not any(result and result.severity >= threshold for result in results.values())
return is_safe, results
except HttpResponseError as e:
# Handle any HTTP response errors that occur during the request
print(f”Failed to analyze text. Error: {e}”)
async def chat_with_kernel(self, user_message, history):
“””
Interact with the chatbot using the Semantic Kernel and provided history.
“””
# Create arguments for the chat function using the user message and conversation history stored in Azure Cosmos DB
arguments = KernelArguments(user_message=user_message, history=history)
# Invoke the chat function in the Semantic Kernel with the provided arguments and await the response
response = await self.kernel.invoke(self.chat_function, arguments)
# Return the chatbot’s response
return response
async def store_interaction(self, user_message, chat_response):
“””
Store the user interaction with the chatbot in Azure Cosmos DB.
“””
# Run the _store_interaction_sync method in an asynchronous execution environment
await self.loop.run_in_executor(self.executor, self._store_interaction_sync, user_message, chat_response)
def _store_interaction_sync(self, user_message, chat_response):
“””
Synchronously store the interaction in Azure Cosmos DB.
“””
# Get the current time in UTC
current_time = datetime.now(timezone.utc)
# Upsert (insert or update) the interaction data into the Cosmos DB container
self.container.upsert_item({
‘id’: str(current_time.timestamp()), # Use the current timestamp as a unique ID
‘user_message’: user_message, # Store the user message
‘bot_response’: chat_response, # Store the chatbot response
‘timestamp’: current_time.isoformat(), # Store the timestamp in ISO format
‘userId’: self.user_id # Store the user ID for partition key
})
async def load_historical_context(self):
“””
Load the user’s chat history from Azure Cosmos DB.
“””
# Run the _load_historical_context_sync method in an asynchronous execution environment
return await self.loop.run_in_executor(self.executor, self._load_historical_context_sync)
def _load_historical_context_sync(self):
“””
Synchronously load the user’s chat history from Azure Cosmos DB.
“””
# Define the query to select items for the current user, ordered by timestamp
query = “SELECT * FROM c WHERE c.userId = @userId ORDER BY c.timestamp DESC”
parameters = [{“name”: “@userId”, “value”: self.user_id}]
# Execute the query and retrieve the items
items = list(self.container.query_items(query=query, parameters=parameters, enable_cross_partition_query=True))
# Include only the last 5 conversations
history_items = items[:5]
# Format the conversion history
return “n”.join([f”User: {item[‘user_message’]}nChatBot: {item[‘bot_response’]}” for item in history_items])
async def clear_historical_context(self):
“””
Clear the user’s chat history from Azure Cosmos DB.
“””
# Run the _clear_historical_context_sync method in an asynchronous execution environment
await self.loop.run_in_executor(self.executor, self._clear_historical_context_sync)
def _clear_historical_context_sync(self):
“””
Synchronously clear the user’s chat history from Azure Cosmos DB.
“””
# Define the query to select items for the current user
query = “SELECT * FROM c WHERE c.userId = @userId”
parameters = [{“name”: “@userId”, “value”: self.user_id}]
# Execute the query and retrieve the items
items = list(self.container.query_items(query=query, parameters=parameters, enable_cross_partition_query=True))
# Clear the chat history by deleting all items for the current user
for item in items:
self.container.delete_item(item, partition_key=self.user_id)
async def main():
“””
Main function to run the chatbot service.
“””
# Enter the User ID to join the chat.
# A conversation history is stored based on the user ID.
user_id = input(“User ID: “)
# Get the event loop to allow synchronous operations in Azure Cosmos DB for NoSQL to run asynchronously.
loop = asyncio.get_running_loop()
# Initialize the ChatbotService with the event loop and user ID
chatbot_service = await ChatbotService(loop, user_id).init()
# Main loop for the interaction with the user
while True:
user_message = input(“You: “)
# Exit the chat loop if the user types ‘exit’
if user_message.lower() == ‘exit’:
break
elif user_message.lower() == ‘history’:
# Load and print the chat history if the user types ‘history’
history = await chatbot_service.load_historical_context()
print(f”n<– Chat history of user ID: {user_id} –>”)
print(history)
print(f”<– End of chat history of user ID: {user_id} –>n”)
elif user_message.lower() == ‘clear’:
# Clear the chat history if the user types ‘clear’
await chatbot_service.clear_historical_context()
print(“Chat history cleared.”)
else:
# Analyze the text for safety
is_safe, _ = await chatbot_service.analyze_text(user_message)
if is_safe:
# Load chat history and interact with the chatbot if the message is safe
history = await chatbot_service.load_historical_context()
chat_response = await chatbot_service.chat_with_kernel(user_message, history)
print(“Chatbot:”, chat_response)
# Store the interaction in Cosmos DB
await chatbot_service.store_interaction(user_message, str(chat_response))
else:
# Inform the user if their message is not safe
print(“Chatbot: Your message is not safe to process. Please rephrase and try again.”)
if __name__ == “__main__”:
asyncio.run(main())
Microsoft Tech Community – Latest Blogs –Read More
Excel (Copy)
After closing a worksheet, the next day when I go back to this sheet it has a second file with the same name ,but it says (Copy). Why is this happening?
Thank you,
Jim Kirk
After closing a worksheet, the next day when I go back to this sheet it has a second file with the same name ,but it says (Copy). Why is this happening? Thank you,Jim Kirk Read More
Cannot boot into Windows 11 to reset
When my system was running Windows 10 in the Dev Channel of the Insider Program I was informed that Windows 11 would be pushed to it through Windows Update, even though the machine did not officially meet the requirements for Windows 11, and that this represented thanks for participating in the Dev Channel. I was also told that this upgrade would be temporary and that at some point I would either be prompted to reinstall Windows 10 or else a reinstall of Windows 10 would be pushed to the machine [I can’t remember which].
The system was indeed moved to Windows 11, but the later prompt to reinstall [or pushed reinstallation of) Windows 10 never came, and I was actually running Windows 11 21H without problems until very recently, when I needed to reset it from the recovery options menu at boot. That reset worked as expected. But now, for unrelated reasons, I need to reset Windows again, but I cannot get it even to boot to the recovery options menu, much less into Windows 11 itself. I do see the Windows logo briefly and then a spinner and an arrow, also briefly, and then the screen just alternates between dull dark blue and black. Depressing F8 at the appropriate time during boot to access the recovery options menu [which action the system has been configured to accept) doesn’t work, although that’s what I used when I reset Windoes just a week or so ago. Turning off the machine with the power button, then starting it and then allowing it to proceed to just pass POST, and then restarting it again a couple of times in quick succession doesn’t work either. Unless there is some other way to access the recovery options menu that I haven’t been able to discover, it looks as though I am going to need to use a USB recovery drive, and unfortunately the one that I made is not accessible, so I’m going to have to create one anew. The problem is that this build of Windows 11 that I have, which I believe is the last build of 21H, doesn’t seem to be available for download, and I’m afraid that if I attempt to install what is available that the installation will be aborted because the system is not officially ready for Windows 11, even though it was running Windows 11 and that at the Insiders Program option.
The BIOS is in legacy mode. Attempts to move to UEFI have been unsuccessful.
Can anyone offer a suggestion on how to proceed, ideally to the recovery options menu at boot, but if not that, then how to proceed with reinstalling Windows 11 in a way that will not abort?
When my system was running Windows 10 in the Dev Channel of the Insider Program I was informed that Windows 11 would be pushed to it through Windows Update, even though the machine did not officially meet the requirements for Windows 11, and that this represented thanks for participating in the Dev Channel. I was also told that this upgrade would be temporary and that at some point I would either be prompted to reinstall Windows 10 or else a reinstall of Windows 10 would be pushed to the machine [I can’t remember which]. The system was indeed moved to Windows 11, but the later prompt to reinstall [or pushed reinstallation of) Windows 10 never came, and I was actually running Windows 11 21H without problems until very recently, when I needed to reset it from the recovery options menu at boot. That reset worked as expected. But now, for unrelated reasons, I need to reset Windows again, but I cannot get it even to boot to the recovery options menu, much less into Windows 11 itself. I do see the Windows logo briefly and then a spinner and an arrow, also briefly, and then the screen just alternates between dull dark blue and black. Depressing F8 at the appropriate time during boot to access the recovery options menu [which action the system has been configured to accept) doesn’t work, although that’s what I used when I reset Windoes just a week or so ago. Turning off the machine with the power button, then starting it and then allowing it to proceed to just pass POST, and then restarting it again a couple of times in quick succession doesn’t work either. Unless there is some other way to access the recovery options menu that I haven’t been able to discover, it looks as though I am going to need to use a USB recovery drive, and unfortunately the one that I made is not accessible, so I’m going to have to create one anew. The problem is that this build of Windows 11 that I have, which I believe is the last build of 21H, doesn’t seem to be available for download, and I’m afraid that if I attempt to install what is available that the installation will be aborted because the system is not officially ready for Windows 11, even though it was running Windows 11 and that at the Insiders Program option. The BIOS is in legacy mode. Attempts to move to UEFI have been unsuccessful. Can anyone offer a suggestion on how to proceed, ideally to the recovery options menu at boot, but if not that, then how to proceed with reinstalling Windows 11 in a way that will not abort? Read More
copilot pro with powerpoint “please wait for the pane to finish loading”
Copilot pro is not working with powerpoint.
everytime i try to use copilot pro i get the following message which never ends
“please wait for the pane to finish loading”
Copilot pro is not working with powerpoint. everytime i try to use copilot pro i get the following message which never ends”please wait for the pane to finish loading” Read More
Access Releases 7 Issue Fixes in Version 2404 (Released April 27th, 2024)
In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel.
If you see a bug that impacts you, and if you are on the current monthly channel Version 2404, you should have these fixes. Make sure you are on Access Build # 16.0.17531.20120 or greater.
Bug Name
Issue Fixed
Characters in the extended range of support not correctly exported to HTML
When exporting data to HTML, some characters would not be represented properly when the HTML file was viewed, and would display as question marks or boxes
Characters in the extended range of support not correctly displayed in charts
When creating a chart with data that contained characters from the extended range of support, some characters would not be represented properly and would display as question marks or boxes
Data appears incorrect when exporting tables with multiple relationships
Dataverse does not support multiple relationships between two tables, so we now alert you when attempting to export such tables and give some options to safely proceed
Application.Run would not execute code when Macro Settings require signed macros, even if the target database is signed
If Application.Run executes code from an external database, we now validate the signature on the external database, and allow the code to run if the database is signed.
An error may occur when trying to filter for a selection
When selecting a substring in a field, and then choosing to filter for values that contain the selected string, you could get an error that you used an invalid expression.
Slow performance when executing query against linked SQL Server table that restricts on Large Number field
In general, when a query applies a restriction to a linked SQL Server table, SQL Server performs the restriction, so only the filtered data is returned to Access. This was not being done for Large Number fields, so the entire table was being downloaded, then filtered locally.
Access terminates unexpectedly when using right-click on a macro or query in the Navigation Pane
Access will now handle this correctly in all cases
Microsoft Tech Community – Latest Blogs –Read More
MS Project and PWA
When I try to upload a new MS Project schedule into PWA, the window for PWA does not appear to type in the Project Name and view the Enterprise fields. The window that appears is a typical Save As to my computer vs PWA. I’m clearly connected to PWA as the Info option indicates it. I also don’t have the Publish feature at this point either. Strange thing is that I use to be able to upload a new schedule to PWA and now I cannot. After seeking company IT support and not being successful, I received a new laptop, hoping it would fix my issue. It fixed it for 1d. Any ideas as to why I can’t upload to PWA?
Note: I can open a project that’s on PWA via the Desktop App via Browse, show me a list of all projects.
When I try to upload a new MS Project schedule into PWA, the window for PWA does not appear to type in the Project Name and view the Enterprise fields. The window that appears is a typical Save As to my computer vs PWA. I’m clearly connected to PWA as the Info option indicates it. I also don’t have the Publish feature at this point either. Strange thing is that I use to be able to upload a new schedule to PWA and now I cannot. After seeking company IT support and not being successful, I received a new laptop, hoping it would fix my issue. It fixed it for 1d. Any ideas as to why I can’t upload to PWA? Note: I can open a project that’s on PWA via the Desktop App via Browse, show me a list of all projects. Read More
Cannot delete organisation from Teams
Hello,
I tried hundreds of times to delete (Leave) the organization I used to work for 5 years ago. It appears to be impossible to delete an organization from my account
When I try to Leave (delete), then I receive the next message
When I try to change organization in order to delete Spirit from my account
Then I receive the next message
I tried everything and numerous times and also tried contacting you before and received no answer. I need someone to help me deleting Spirit from my account PLEASE.
THANK YOU
Hello, I tried hundreds of times to delete (Leave) the organization I used to work for 5 years ago. It appears to be impossible to delete an organization from my account When I try to Leave (delete), then I receive the next message When I try to change organization in order to delete Spirit from my account Then I receive the next messageI tried everything and numerous times and also tried contacting you before and received no answer. I need someone to help me deleting Spirit from my account PLEASE. THANK YOU Read More
Editing a Document
Howdy everyone, I’m a Financial Advisor and I need help with one page of my document that needs to be edited. It needs to be lined up and cleaned up. I need to save the copy to a PDF. The page did not come from a word document.
Howdy everyone, I’m a Financial Advisor and I need help with one page of my document that needs to be edited. It needs to be lined up and cleaned up. I need to save the copy to a PDF. The page did not come from a word document. Read More
Windows 2022 Server Standard SHA256 Checksum
Hi everyone,
I’ve recently downloaded the Windows Server 2022 ISO from the Microsoft Evaluation Center, and I want to ensure the integrity of the file by verifying its SHA256 checksum. Unfortunately, I couldn’t find the official checksum listed anywhere on the Microsoft site or documentation.
Could any experts here guide me on where to find the official SHA256 checksum for the Windows Server 2022 ISO? Alternatively, if anyone has successfully verified their download, could you please share the checksum value and the source of verification?
I appreciate any help or insights you can provide. Thank you!
Best regards,
Richie
Hi everyone, I’ve recently downloaded the Windows Server 2022 ISO from the Microsoft Evaluation Center, and I want to ensure the integrity of the file by verifying its SHA256 checksum. Unfortunately, I couldn’t find the official checksum listed anywhere on the Microsoft site or documentation. Could any experts here guide me on where to find the official SHA256 checksum for the Windows Server 2022 ISO? Alternatively, if anyone has successfully verified their download, could you please share the checksum value and the source of verification?I appreciate any help or insights you can provide. Thank you! Best regards,Richie Read More
Got hacked a while back
Hi, you know the drill downloaded something sketch of the internet lost my Microsoft account and all the things connected to it. To be honest at first i wasn’t upset till it realized I’d lost my Minecraft account along side it due to the migration. I dont know how to get it back to be completely honest and atp im kinda miffed about it. I bought Minecraft waaay back. but im sure the receipt is still floating in my inbox somewhere. Does anyone know what to do here? I have the email that the account is connected to. Not sure of the rules so I’m not gonna just post it. But if anyone higher up see this I can definitely provide it. The reason ive taken to posting here is because i tried filling out the support form except i dont use many of the Microsoft products its requesting proof of. I didnt use outlook and I never purchased anything off the Microsoft store. If you need proof I owned the account once I’m sure I can provide it, I just hope someone who can help me sees the post
Hi, you know the drill downloaded something sketch of the internet lost my Microsoft account and all the things connected to it. To be honest at first i wasn’t upset till it realized I’d lost my Minecraft account along side it due to the migration. I dont know how to get it back to be completely honest and atp im kinda miffed about it. I bought Minecraft waaay back. but im sure the receipt is still floating in my inbox somewhere. Does anyone know what to do here? I have the email that the account is connected to. Not sure of the rules so I’m not gonna just post it. But if anyone higher up see this I can definitely provide it. The reason ive taken to posting here is because i tried filling out the support form except i dont use many of the Microsoft products its requesting proof of. I didnt use outlook and I never purchased anything off the Microsoft store. If you need proof I owned the account once I’m sure I can provide it, I just hope someone who can help me sees the post Read More