Category: Microsoft
Category Archives: Microsoft
Next-Gen Customer Service: Azure’s AI-Powered Speech, Translation and Summarization
Active Azure subscription. If you don’t have an Azure subscription, you can create one for free
Create a Speech resource in the Azure portal.
Create a Translator resource in the Azure portal.
Create a Language resource in the Azure portal
Create a Container Registry in the Azure portal.
Create Azure Web PubSub for Socket.IO resource using
NODE_ENV=’development’
PORT=3000
SOCKET_PORT=29011
SOCKET_ENDPOINT=https://<SOCKET_IO_SERVICE>.webpubsub.azure.com
SOCKET_CONNECTION_STRING=<SOCKET_IO_CONNECTION_STRING>
SPEECH_KEY=<SPEECH_KEY>
SPEECH_REGION=westeurope
LANGUAGE_KEY=<LANGUAGE_KEY>
LANGUAGE_REGION=westeurope
LANGUAGE_ENDPOINT=https://<LANGUAGE_SERVICE>.cognitiveservices.azure.com/
TRANSLATE_KEY=<TRANSLATE_KEY>
TRANSLATE_ENDPOINT=https://api.cognitive.microsofttranslator.com/
TRANSLATE_REGION=westeurope
LOCATION=westeurope
CONTAINER_APP_NAME=aiservices
CONTAINER_APP_IMAGE=<CONTAINER_REGISTRY>.azurecr.io/aiservices:latest
CONTAINER_APP_PORT=80
CONTAINER_REGISTRY_SERVER=<CONTAINER_REGISTRY>.azurecr.io
CONTAINER_REGISTRY_IDENTITY=system
CONTAINER_ENVIRONMENT_NAME=env-ai-services
LOGS_WORKSPACE_ID=<LOGS_WORKSPACE_ID>
LOGS_WORKSPACE_KEY=<LOGS_WORKSPACE_KEY>
SUBSCRIPTION_ID=<SUBSCRIPTION_ID>
“clientId”: “00000000-0000-0000-0000-000000000000”,
“clientSecret”: “00000000000000000000000000000000”,
“subscriptionId”: “00000000-0000-0000-0000-000000000000”,
“tenantId”: “00000000-0000-0000-0000-000000000000”,
“activeDirectoryEndpointUrl”: “https://login.microsoftonline.com”,
“resourceManagerEndpointUrl”: “https://management.azure.com/”,
“activeDirectoryGraphResourceId”: “https://graph.windows.net/”,
“sqlManagementEndpointUrl”: “https://management.core.windows.net:8443/”,
“galleryEndpointUrl”: “https://gallery.azure.com/”,
“managementEndpointUrl”: “https://management.core.windows.net/”
}
Set the CONTAINER_REGISTRY variable to the name of the Azure Container Registry.
Set the RESOURCE_GROUP variable for the resource group where you Container registry.
Set the CONTAINER_APP_NAME variable to the name of the Azure Container App.
npm install
npm run dev
./setup.sh
–name $CONTAINER_APP_NAME
–resource-group $RESOURCE_GROUP
–query properties.configuration.ingress.fqdn
Spoken language: Select the language of the speaker.
Translated language: Select the language to which the spoken language will be translated.
Listen: Start the speech-to-text transcription, this will use the Speech to text SDK for JavaScript package.
// intialize the speech recognizer
const speechConfig = speechsdk.SpeechConfig.fromAuthorizationToken(tokenObj.token, tokenObj.region);
const audioConfig = speechsdk.AudioConfig.fromDefaultMicrophoneInput();
recognizer = new speechsdk.SpeechRecognizer(speechConfig, audioConfig);
// register the event handlers
…
// listen and transcribe
recognizer.startContinuousRecognitionAsync();
// stop the speech recognizer
recognizer.stopContinuousRecognitionAsync();
…
const res = await axios.post(`${config.translateEndpoint}translate?api-version=3.0&from=${from}&to=${to}`, data, headers);
return res.data[0].translations[0].text;
const jobId = res.headers[‘operation-location’];
let completed = false
while (!completed) {
res = await axios.get(`${jobId}`, headers);
completed = res.data.tasks.completed > 0;
}
const conv = res.data.tasks.items[0].results.conversations[0].summaries.map(summary => {
return { aspect: summary.aspect, text: summary.text }
});
return conv;
// intialize the speech synthesizer
speechConfig.speechSynthesisVoiceName = speakLanguage;
const synthAudioConfig = speechsdk.AudioConfig.fromDefaultSpeakerOutput();
synthesizer = new speechsdk.SpeechSynthesizer(speechConfig, synthAudioConfig);
…
// speak the text
synthesizer.speakTextAsync(text,
function (result) {
if (result.reason === speechsdk.ResultReason.SynthesizingAudioCompleted) {
console.log(“synthesis finished.”);
} else {
console.error(“Speech synthesis canceled, ” + result.errorDetails +
“nDid you set the speech resource key and region values?”);
}
});
clearMessages = () =>
socket.emit(‘clear’);
syncMessages = () =>
socket.emit(‘sync’);
Container Registry: for the Next.js app container image.
Container App (& Container App Environment): for the Next.js app.
Language Service: for the conversation summarization.
Log Analytics Workspace: for the logs of the container app.
Web PubSub for Socket.IO: for the real-time, duplex communication between the client and the server.
Speech service: for the speech-to-text transcription capabilities.
Translator service: for the translation capabilities.
Create a project and choose a model. Use a Speech resource that you create in the Azure portal. If you train a custom model with audio data, choose a Speech resource region with dedicated hardware for training audio data. For more information, see footnotes in the regions table.
Upload test data. Upload test data to evaluate the speech to text offering for your applications, tools, and products.
Test recognition quality. Use the Speech Studio to play back uploaded audio and inspect the speech recognition quality of your test data.
Test model quantitatively. Evaluate and improve the accuracy of the speech to text model. The Speech service provides a quantitative word error rate (WER), which you can use to determine if more training is required.
Train a model. Provide written transcripts and related text, along with the corresponding audio data. Testing a model before and after training is optional but recommended.
Deploy a model. Once you’re satisfied with the test results, deploy the model to a custom endpoint. Except for batch transcription, you must deploy a custom endpoint to use a custom speech model.
Microsoft Tech Community – Latest Blogs –Read More
Dynamic Filtering lists – Slow page responses
Has anyone else experienced slow page responses when using the dynamic filtering of two lists? I’m doing this on a modern SharePoint Online page and it is a very slow response. This is an old feature (was available in SharePoint On-prem 2013, so not sure why it is so slow. Any suggestions?
Has anyone else experienced slow page responses when using the dynamic filtering of two lists? I’m doing this on a modern SharePoint Online page and it is a very slow response. This is an old feature (was available in SharePoint On-prem 2013, so not sure why it is so slow. Any suggestions? Read More
How to fix Payroll Error Code 40003 QuickBooks Desktop Windows 10?
I encountered Payroll Error Code 40003 on QuickBooks Desktop Windows 10 while processing payroll. Each attempt to resolve it proves unsuccessful. Seeking expert assistance to troubleshoot and resolve this issue promptly.
I encountered Payroll Error Code 40003 on QuickBooks Desktop Windows 10 while processing payroll. Each attempt to resolve it proves unsuccessful. Seeking expert assistance to troubleshoot and resolve this issue promptly. Read More
Data Entry Mode to Edit Mode(?)
We are currently having a database built for our company. When selecting a Form, it opens on a Blank Record, however, when we search for a record and select it, it will open the first record we ever entered into the database and then populate the record we are searching for. Is there a work around for this? We are told it is going from Data Entry mode, to edit mode and that is what is causing the temp record to populate. It is better to be shown in video than a picture, but I have uploaded a picture.
We are currently having a database built for our company. When selecting a Form, it opens on a Blank Record, however, when we search for a record and select it, it will open the first record we ever entered into the database and then populate the record we are searching for. Is there a work around for this? We are told it is going from Data Entry mode, to edit mode and that is what is causing the temp record to populate. It is better to be shown in video than a picture, but I have uploaded a picture. Read More
Re: Attrition Rate calculation in Excel
Hello! You’ve posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I’m moving your question to the Excel space – please post Excel questions here in the future.
@Vinod_Sir
Hello! You’ve posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I’m moving your question to the Excel space – please post Excel questions here in the future. Read More
Copilot on premise
I promise I searched this community before asking this question 🙂
Is there a way to grant copilot access to on-premise file share data to form it’s model in order to ask questions/prompt? Copilot seems powerful when used against M365 account/Azure tenant data. Is there a way to include on-premise data in this model?
I promise I searched this community before asking this question 🙂 Is there a way to grant copilot access to on-premise file share data to form it’s model in order to ask questions/prompt? Copilot seems powerful when used against M365 account/Azure tenant data. Is there a way to include on-premise data in this model? Read More
Need help setting print areas
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”.
I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom.
Can anyone help?
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”. I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom. Can anyone help? Read More
Auto Classify Power BI Reports
Hello,
Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you.
Hello, Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you. Read More
Assigned staff member not showing in confirmation email
I’ve seen many, many complaints about this but no response/resolution being posted.
The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to.
I’ve seen many, many complaints about this but no response/resolution being posted. The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to. Read More
Average a set of values based on date
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.
Data Set 1: 3/31/24
Data Set 2: 4/1/24
End Result average compilation:
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.Data Set 1: 3/31/24Data Set 2: 4/1/24End Result average compilation: Read More
azure automation hybrid worker platform best practice
Hi
We’re moving services around and checking that some of your architecture is according to best practices.
What is the recommendations on where to install Azure automation hybrid worker?
Can we install on an AD server?
AD Sync Server?
Dedicated server?
Kind Regards
HiWe’re moving services around and checking that some of your architecture is according to best practices.What is the recommendations on where to install Azure automation hybrid worker?Can we install on an AD server? AD Sync Server?Dedicated server?Kind Regards Read More
Conditional Formatting a Table
I am new to this so bare with me.
I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows:
A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full.
currently, the rows are correctly shading with the selected number of hours and in the in the correct colors.
Here are the problems:
1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes.
2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?
3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening?
Conditional Formatting rules entered in each row for each user.
Row 1 =AND($A$2=”DAVE”, C5>=1) ….
Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….
Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) ….
Any help is appreciated.
I am new to this so bare with me. I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows: A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full. currently, the rows are correctly shading with the selected number of hours and in the in the correct colors. Here are the problems:1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes. 2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening? Conditional Formatting rules entered in each row for each user. Row 1 =AND($A$2=”DAVE”, C5>=1) ….Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) …. Any help is appreciated. Read More
External email senders appear in DLP Activity Explorer
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization.
I’m going crazy, any guidance would help!
ty
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization. I’m going crazy, any guidance would help!ty Read More
Linked Cells between sheets not crossing over properly
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one.
The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number.
I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem.
I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all.
='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one. The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number. I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem. I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all. ='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86 Read More
Run batch job on remote VM from Azure Data Factory
Hello,
I am new to Azure and work in an environment that is mixed Azure and on-prem.
I do not have access to alter firewall rules.
I do have Managed virtual networks set up for at least 1 Azure item.
I have an on prem REST application.
I have an Azure VM that is able to access REST on its vnet.
I have an Azure ADF instance on a vnet that can contact the VM but not the REST application.
I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.
Anyone with experience on this can outline what I should be trying to do?
thank you!
Hello, I am new to Azure and work in an environment that is mixed Azure and on-prem.I do not have access to alter firewall rules. I do have Managed virtual networks set up for at least 1 Azure item. I have an on prem REST application.I have an Azure VM that is able to access REST on its vnet.I have an Azure ADF instance on a vnet that can contact the VM but not the REST application. I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.Anyone with experience on this can outline what I should be trying to do? thank you! Read More
Attrition Rate calculation in Excel
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)
MTD – Total Nos of attrition/ Total Nos of Head count
YTD – total attrition from starting month to end month / average HC of starting month to end month
Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)MTD – Total Nos of attrition/ Total Nos of Head countYTD – total attrition from starting month to end month / average HC of starting month to end month Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation Read More
GCCH Monthly M365 Webinar: New Teams Updates and Cross-Cloud Collaboration Envisioning
We’re looking forward to our next GCCH M365 Webinar on Tuesday, April 30, at 1200 EDT. It’s the Dave show as we’ll be joined by both Dave Jennings (new Teams) and Dave Nobles (empowering secure and effective collaboration between GCCH and DoD). To receive a calendar invite, please register here.
In addition, please find attached a roll up of April M365 roadmap highlights. Happy to field any questions with what is included.
Microsoft Tech Community – Latest Blogs –Read More
Sharing Recorded Teams session when external sharing is restricted
Hi all,
I have a question about recorded sessions from TEAMs
As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings.
The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available?
Or is there a way to have this restrictions for SharePoint but not for OneDrive?
Hi all, I have a question about recorded sessions from TEAMs As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings. The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available? Or is there a way to have this restrictions for SharePoint but not for OneDrive? Read More
How to stop “Convert to Stocks” popup
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice?
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice? Read More
MS 203 Microsoft 365 Certified: Messaging Administrator Associate has been retired
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me.
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me. Read More