Category: Microsoft
Category Archives: Microsoft
Look for dates/times that are closest to specified date/time
Hello everyone,
In my worksheet, I have a list of events that I need to schedule flights for (both to and from the event). The flights to be scheduled depend on the time of the event, and there is a large list to look through, so I want to try and automate this each month.
On one sheet, I have a list of the events that I want to schedule flights for. Each event has a route, along with either the “latest arrival time” (for outbound flights), or “earliest departure time” (for return flights). These times are compared to a full list of scheduled flights (Sheet 2). I’ve also attached a sample with the expected results.
For the outbound flight:
For the listed route (column B), look at the ARRIVAL times for flights in Sheet 2Return the flight (flt #, departure time, arrival time) for the flight is closest to – but no later than – the “out latest arrival” date/time (column c)
So for event A: LAXPHX, with latest arrival time of 7/1 @ 20:30. There is a LAXPHX flight that arrives at 20:39, but since that is after the “latest arrival”, the next earliest one would be flight # 5, with an arrival time of 19:44. This information is returned to columns D-F on Sheet 1
For the return flight,
For the listed route (column H), look at the DEPARTURE times in Sheet 2Return the flight (flt #, departure date/time, arrival date/time) for the flight that is closest to – but no earlier than – the “return earliest departure” date/time (column I)
The return for event A: PHXLAX, earliest departure of 7/3 @ 5:45. There is a PHXLAX flight that departs @ 5:30, but that is too early; the desired one is flt # 14, departing @ 6:25, and arriving @ 7:19. This information is returned to columns J-L on Sheet 1.
Note: if it will be simpler to put the scheduled flights for each route in different sheets, that will be fine!
Thank you for any guidance you can provide!
Hello everyone, In my worksheet, I have a list of events that I need to schedule flights for (both to and from the event). The flights to be scheduled depend on the time of the event, and there is a large list to look through, so I want to try and automate this each month. On one sheet, I have a list of the events that I want to schedule flights for. Each event has a route, along with either the “latest arrival time” (for outbound flights), or “earliest departure time” (for return flights). These times are compared to a full list of scheduled flights (Sheet 2). I’ve also attached a sample with the expected results. For the outbound flight:For the listed route (column B), look at the ARRIVAL times for flights in Sheet 2Return the flight (flt #, departure time, arrival time) for the flight is closest to – but no later than – the “out latest arrival” date/time (column c) So for event A: LAXPHX, with latest arrival time of 7/1 @ 20:30. There is a LAXPHX flight that arrives at 20:39, but since that is after the “latest arrival”, the next earliest one would be flight # 5, with an arrival time of 19:44. This information is returned to columns D-F on Sheet 1 For the return flight, For the listed route (column H), look at the DEPARTURE times in Sheet 2Return the flight (flt #, departure date/time, arrival date/time) for the flight that is closest to – but no earlier than – the “return earliest departure” date/time (column I) The return for event A: PHXLAX, earliest departure of 7/3 @ 5:45. There is a PHXLAX flight that departs @ 5:30, but that is too early; the desired one is flt # 14, departing @ 6:25, and arriving @ 7:19. This information is returned to columns J-L on Sheet 1. Note: if it will be simpler to put the scheduled flights for each route in different sheets, that will be fine! Thank you for any guidance you can provide! Read More
IBM Maximo Application Suite migration and modernization with Azure Red Hat OpenShift
IBM Maximo has been a leading enterprise asset management solution in the industry for four decades, helping customers streamline work processes with a centralized platform for managing tasks, inventory, regulatory compliance and reporting capabilities. IBM Maximo Application Suite (MAS), the next generation of IBM Maximo, delivers a better user experience, faster integration, robust AI analytics, and a broad range of cloud deployment options. MAS provides organizations with a robust and modern asset management solution.
Red Hat OpenShift, the industry’s leading hybrid cloud application platform powered by Kubernetes, brings together tested and trusted services to reduce the friction of developing, modernizing, deploying, running and managing applications. OpenShift delivers a consistent experience across public cloud, on premises, hybrid cloud or edge architecture.
Microsoft Azure Red Hat OpenShift (ARO) provides highly available, fully managed OpenShift clusters on demand, monitored and operated jointly by Microsoft and Red Hat. OpenShift brings added-value features to complement Kubernetes, making it a turnkey container PaaS with a significantly improved developer and operator experience.
Maximo customers will be required to move to MAS when Maximo 7.x reaches end of life. MAS has been containerized to run specifically on Red Hat OpenShift. To ease this transition for customers who are unfamiliar with running containers in production, IBM, Microsoft and Red Hat have teamed up to provide a validated architecture for running MAS on Azure Red Hat OpenShift.
This blog will walk through the recommended options for running MAS on Azure and describe how the IBM, Red Hat and Microsoft Azure components come together and provide a solid foundation for running MAS. We will also explore the architectural decisions to consider, so you can choose the one that best fits your organization’s needs.
For each option below, there are two components to keep in mind: the MAS application and the platform MAS runs on (Red Hat OpenShift or Microsoft Azure Red Hat OpenShift).
Option 1 provides a scripted install process for the MAS application and the underlying OpenShift Container Platform (OCP). This process makes the overall installation process simpler. However, the ability to customize the MAS installation is limited since it is script-based. Additionally, because the underlying platform is a self-managed OCP, the customer has complete control over the infrastructure in exchange for monitoring and maintaining that OCP cluster.
Option 2a requires the customer to install MAS themselves but allows for greater customization of MAS during the installation process. This option also provides complete control over the underlying OCP but requires the customer to install, monitor and maintain OCP.
Option 2b requires the customer to install MAS themselves but allows for greater customization of MAS during the installation process. In this option, the underlying platform is Microsoft ARO, a managed version of OCP offered by Microsoft. The installation of ARO is scripted, and Red Hat site reliability engineers (SREs) are responsible for monitoring and maintaining the OCP cluster. However, because Red Hat SREs manage the cluster, customers will have less control over the platform infrastructure than in options 1 and 2a.
Installation option
MAS installation
MAS installation customization
Platform creation
Platform control
Platform (OCP) management
Option 1
Scripted
Less customization
Scripted
Complete control
Customer managed
Option 2a
Manual by customer
More customization
Customer driven
Complete control
Customer managed
Option 2b
Manual by customer
More customization
Scripted
Less control
Red Hat SRE managed
Option 1: MAS on self-managed Red Hat OpenShift through Marketplace
This deployment option involves setting up MAS on an OpenShift cluster, which runs on the Azure platform. Azure Marketplace serves as the conduit through which this deployment is made possible.
One of the primary advantages of choosing this deployment option is the ease of deployment. Azure Marketplace simplifies the process by providing pre-configured templates and scripts that are deployed on the customer’s behalf. One can use this pattern to set up MAS quickly and efficiently, reducing software deployment complexity.
You can deploy a new cluster, use an existing one or deploy a new one into an existing network. However, you must provide the expected database and email configurations before the deployment. This flexibility enables organizations to optimize their infrastructure and adapt to changing needs. The Azure Marketplace pattern simplifies the deployment process, allowing businesses to focus on using MAS to enhance their asset management practices quickly.
It’s essential to carefully consider resource allocation, data security, integration and support to enable a successful deployment and maximize the benefits of MAS. With the right planning and execution, organizations can unlock the full potential of MAS in their asset management journey through Azure Marketplace with minimal effort.
Option 2a: MAS on self-managed Red Hat OpenShift through “do it yourself” option
Deploying MAS on a self-installed OpenShift cluster on Microsoft Azure through the “do it yourself” option means you have complete control over the installation process. Unlike other deployment methods, where the environment is pre-configured, this approach empowers you to customize your MAS deployment to align with your specific requirements.
One of the primary advantages of choosing the “do it yourself” option is its unparalleled level of control. You can tailor the deployment to your unique needs, ensuring every component is configured to optimize the asset management processes.
With this option, you can select your preferred installer from various options, including installer provisioned infrastructure, user provisioned infrastructure and even an airgap configuration. This flexibility allows you to use your existing expertise or choose the installer that aligns best with your infrastructure and security requirements.
However, it’s essential to recognize this option’s need for skilled resources, the potential complexity of the deployment process and the ongoing support and maintenance responsibilities. With the right expertise and a well-thought-out plan, the “do it yourself” option can be a powerful choice for organizations looking to maximize the potential of MAS in their asset management journey.
Option 2b: MAS deployment on Azure Red Hat OpenShift managed by Microsoft Azure
MAS is deployed on ARO in this option. This strategic combination offers a range of advantages for businesses looking to streamline their processes. This option provides a middle ground between the previous two options.
MAS on ARO is straightforward to set up and will require less effort than the “do it yourself” approach while giving you similar levels of control over OpenShift and MAS. It is mainly for those who prefer not to manage OpenShift themselves, but who still want control over the hosting platform. However, as you’ll be interfacing with OpenShift directly, you will still need team members skilled in OpenShift to make this option work. While this option requires less work from an ongoing management perspective, as OpenShift management is taken care of, it will take additional upfront work because you will be deploying MAS by yourself.
The advantages of MAS deployment on ARO are multifaceted. First, it lowers the entry barrier and requires a smaller OpenShift/Kubernetes resources skill set on day one to get started. Most importantly, you no longer need to spend time and effort setting up OpenShift and applying subsequent updates.
Second, it provides a managed experience through a PaaS offering supported by Microsoft and RedHat. It provides distinct benefits for those prioritizing rapid access to support services. It simplifies the overall experience of managing the health and updates of OpenShift, as Microsoft is responsible for that.
Each MAS on Azure deployment option has its advantages and limitations. You should review these factors to align their deployment with your business needs and requirements. You should assess their infrastructure, customization and cost considerations to make an informed decision that ensures a successful and efficient MAS deployment. By understanding the strengths and limitations of each option, customers can choose the deployment option that meets their business objectives.
Work with IBM Maximo on Azure
Self deploy Maximo with our GitHub guide
Deploy Maximo through the marketplace (client managed)
Deploy Maximo through the marketplace (BYOL)
Microsoft Tech Community – Latest Blogs –Read More
AD Security Groups not available for purview ?
What is the fastest way to add users to a rule if a security group is not available for Purview ?
SetDLPComplianceRule – ?
Thanks
What is the fastest way to add users to a rule if a security group is not available for Purview ? SetDLPComplianceRule – ? Thanks Read More
Subject: Retrieving Lost Microsoft Excel 2013 Expert Certification
Dear Excel Administrator,
I am writing to inquire about retrieving a lost Microsoft Excel 2013 Expert certification. I successfully obtained the certificate and credentials, including the logo, from Certiport in approximately 2017.
Unfortunately, after several years, I have misplaced the certificate and logo files. I understand that Microsoft no longer directly issues certifications for Microsoft Office 2013 versions, as the program has been retired.
However, I would be grateful if you could advise on the possibility of retrieving a copy of my certification record or logo from Certiport. Since I no longer have access to the email address used during registration, I can only provide my Centennial College Student ID as verification (which I can send in a separate, private email if necessary).
I am actively seeking employment and having access to a copy of the certificate or logo would significantly enhance my application.
Thank you for your time and assistance in this matter.
Dear Excel Administrator,I am writing to inquire about retrieving a lost Microsoft Excel 2013 Expert certification. I successfully obtained the certificate and credentials, including the logo, from Certiport in approximately 2017.Unfortunately, after several years, I have misplaced the certificate and logo files. I understand that Microsoft no longer directly issues certifications for Microsoft Office 2013 versions, as the program has been retired.However, I would be grateful if you could advise on the possibility of retrieving a copy of my certification record or logo from Certiport. Since I no longer have access to the email address used during registration, I can only provide my Centennial College Student ID as verification (which I can send in a separate, private email if necessary).I am actively seeking employment and having access to a copy of the certificate or logo would significantly enhance my application.Thank you for your time and assistance in this matter. Read More
WSL won’t install after upgrading to Windows 11 24H2
Help! I am running the current Dev Windows 11 build (version 24H2 OS Build 26100.1). Ever since I upgraded from 23H2 to 24H2 I’ve been unable to get WSL to work. When I run “wsl.exe” I get the following message:
Windows Subsystem for Linux must be updated to the latest version to proceed. You can update by running ‘wsl.exe –update’.
For more information please visit https://aka.ms/wslinstall
Press any key to install Windows Subsystem for Linux.
Press CTRL-C or close this window to cancel.
This prompt will time out in 60 seconds.
When I run “wsl.exe –install” or “wsl.exe –update”, I get this:
Downloading: Windows Subsystem for Linux 2.1.5
Installing: Windows Subsystem for Linux 2.1.5
Catastrophic failure
I’ve tried uninstalling the distro (Ubuntu), uninstalling WSL from the Windows features screen (from Programs and Features in Control Panel), making sure “New apps will save to” is set to C: drive (where “Windows” is located) in Settings > System > Storage > Advanced storage settings > Where new content is saved … and rebooted between each step during several attempts and nothing changes. Everything else on my system works fine, it’s just WSL and this only started when I upgraded to 24H2. I can’t get any more information that “Catastrophic failure” (“–verbose” adds nothing). I’ve even tried installing a Linux kernel manually and it tells me I already have a newer version of WSL installed. I have tried basically everything that is suggested by any Google result I can find and nothing works.
Help! I am running the current Dev Windows 11 build (version 24H2 OS Build 26100.1). Ever since I upgraded from 23H2 to 24H2 I’ve been unable to get WSL to work. When I run “wsl.exe” I get the following message: Windows Subsystem for Linux must be updated to the latest version to proceed. You can update by running ‘wsl.exe –update’.For more information please visit https://aka.ms/wslinstall Press any key to install Windows Subsystem for Linux.Press CTRL-C or close this window to cancel.This prompt will time out in 60 seconds. When I run “wsl.exe –install” or “wsl.exe –update”, I get this: Downloading: Windows Subsystem for Linux 2.1.5Installing: Windows Subsystem for Linux 2.1.5Catastrophic failure I’ve tried uninstalling the distro (Ubuntu), uninstalling WSL from the Windows features screen (from Programs and Features in Control Panel), making sure “New apps will save to” is set to C: drive (where “Windows” is located) in Settings > System > Storage > Advanced storage settings > Where new content is saved … and rebooted between each step during several attempts and nothing changes. Everything else on my system works fine, it’s just WSL and this only started when I upgraded to 24H2. I can’t get any more information that “Catastrophic failure” (“–verbose” adds nothing). I’ve even tried installing a Linux kernel manually and it tells me I already have a newer version of WSL installed. I have tried basically everything that is suggested by any Google result I can find and nothing works. Read More
Enterprise application app secrete key need to update for SharePoint Online access.
Hi,
I need to update the app secrete key which is already expired so that client can access SharePoint online site with app id and key.
Problem is that this app I can only see under “Enterprise application” in “Azure AD” as “Service Principle” where I am not getting any option to update the secret key.
And this app not showing under “App Registration” in “Azure AD”.
How to update the secret key via GUI or PowerShell command.
Need help.
Hi,I need to update the app secrete key which is already expired so that client can access SharePoint online site with app id and key.Problem is that this app I can only see under “Enterprise application” in “Azure AD” as “Service Principle” where I am not getting any option to update the secret key.And this app not showing under “App Registration” in “Azure AD”. How to update the secret key via GUI or PowerShell command.Need help. Read More
Can’t add Planner plan (basic or premium) to General Channel Teams Tab
I have the new Planner. I’ve created a basic and a premium plan in Planner via the Teams interface and added to a group (my Team). When I go to my Team and try to add a tab at the top of the General Channel for these Planner Plans, they do not show up in “Use an existing plan from this team”, even though in Planner it says the plan is Shared with my Teams Team. I am an owner and member of the group/Team. Is this functionality not available yet?
If I go to tasks.office.com and create a new blank (basic) plan there (instead of creating via the Planner app in Teams), then I CAN add to my Teams General Channel as this basic plan appears in the ‘Use an existing plan from this team’.
I have the new Planner. I’ve created a basic and a premium plan in Planner via the Teams interface and added to a group (my Team). When I go to my Team and try to add a tab at the top of the General Channel for these Planner Plans, they do not show up in “Use an existing plan from this team”, even though in Planner it says the plan is Shared with my Teams Team. I am an owner and member of the group/Team. Is this functionality not available yet? If I go to tasks.office.com and create a new blank (basic) plan there (instead of creating via the Planner app in Teams), then I CAN add to my Teams General Channel as this basic plan appears in the ‘Use an existing plan from this team’. Read More
How Do I Fix When QuickBooks Subscription has Lapsed
Encountering a QuickBooks subscription lapse can be daunting, but fear not! In this community, we delve deep into what it means, the reasons behind it, and effective solutions, all with a human touch.
What is a QuickBooks Subscription Lapse?
A QuickBooks subscription lapse occurs when your subscription expires, leading to restricted access to crucial features and services.
Reasons Behind Subscription Lapses:
Several factors can contribute to a QuickBooks subscription lapse:
Payment Failure: Insufficient funds, expired credit cards, or billing issues.Oversight: Forgetting to renew the subscription on time.Changes in Business Needs: Shifts in business requirements may render the current subscription inadequate.Technical Glitches: Unexpected system errors or issues with payment processing.
Solutions for QuickBooks Subscription Lapses:
Payment Update: Ensure your payment details are up to date to prevent interruptions. Double-check card expiration dates and account balances.Renewal Reminders: Set up automatic renewal or calendar reminders to stay informed about subscription expirations.Review Subscription Plans: Regularly assess your business needs and upgrade or downgrade your subscription accordingly.Contact Support: Reach out to QuickBooks customer support for personalized assistance in resolving payment or subscription-related issues.
Join Our Community:
Share your experiences, ask questions, and connect with fellow users who have navigated through similar challenges. Let’s support each other through the maze of QuickBooks subscription lapses, ensuring uninterrupted access to essential accounting tools. Together, we’ll keep your QuickBooks journey smooth and hassle-free!
Encountering a QuickBooks subscription lapse can be daunting, but fear not! In this community, we delve deep into what it means, the reasons behind it, and effective solutions, all with a human touch. What is a QuickBooks Subscription Lapse? A QuickBooks subscription lapse occurs when your subscription expires, leading to restricted access to crucial features and services. Reasons Behind Subscription Lapses: Several factors can contribute to a QuickBooks subscription lapse:Payment Failure: Insufficient funds, expired credit cards, or billing issues.Oversight: Forgetting to renew the subscription on time.Changes in Business Needs: Shifts in business requirements may render the current subscription inadequate.Technical Glitches: Unexpected system errors or issues with payment processing.Solutions for QuickBooks Subscription Lapses: Payment Update: Ensure your payment details are up to date to prevent interruptions. Double-check card expiration dates and account balances.Renewal Reminders: Set up automatic renewal or calendar reminders to stay informed about subscription expirations.Review Subscription Plans: Regularly assess your business needs and upgrade or downgrade your subscription accordingly.Contact Support: Reach out to QuickBooks customer support for personalized assistance in resolving payment or subscription-related issues. Join Our Community: Share your experiences, ask questions, and connect with fellow users who have navigated through similar challenges. Let’s support each other through the maze of QuickBooks subscription lapses, ensuring uninterrupted access to essential accounting tools. Together, we’ll keep your QuickBooks journey smooth and hassle-free! Read More
How To Fix QuickBooks Won’t allow multiple users in Windows 10/11
Encountering roadblocks while attempting to enable multiple users in QuickBooks on Windows 10/11 can be frustrating. This issue prevents seamless collaboration and hampers productivity, posing challenges for businesses relying on QuickBooks for their accounting needs.
Reasons for Why Not Switching to Multi-User Mode:
Several factors could lead to QuickBooks not allowing multiple users on Windows 10 and 11. These may include:
Firewall Restrictions: Windows Firewall or third-party firewall settings may be blocking QuickBooks from communicating over the network, inhibiting multi-user access.
Incorrect Network Configuration: Improper network settings, such as network sharing being disabled or incorrect permissions assigned, can prevent multiple users from accessing QuickBooks simultaneously.
Outdated QuickBooks or Windows: Using outdated versions of QuickBooks or operating systems may result in compatibility issues, leading to the inability to enable multi-user mode.
Solutions For QuickBooks Won’t allow multiple users in Windows 10/11:
Check Firewall Settings: Verify that QuickBooks is allowed through the firewall by configuring firewall settings. Navigate to the firewall settings in Windows Security or your third-party firewall software and ensure that QuickBooks is listed as an allowed application.
Verify Network Settings: Confirm that network sharing is enabled and that appropriate permissions are set for QuickBooks folders. Adjust network settings as necessary to facilitate communication between users and the QuickBooks database.
Update QuickBooks and Windows: Ensure that both QuickBooks and Windows are up to date with the latest patches and updates. Installing the latest versions can resolve compatibility issues and improve overall performance.
Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair network-related issues that may be preventing multi-user access. This tool can identify and resolve various networking problems within QuickBooks.
Restart Hosting: Restart QuickBooks Database Server Manager and ensure that hosting is enabled for multi-user access. Navigate to the File menu within QuickBooks and select Utilities > Host Multi-User Access.
Conclusion:
By following these comprehensive solutions, you can overcome the hurdle of QuickBooks not allowing multiple users on Windows 10/11. Remember to troubleshoot systematically and reach out to QuickBooks support or community forums for further assistance if needed. With the right approach, you can restore seamless multi-user functionality and optimize collaboration within your organization.
Encountering roadblocks while attempting to enable multiple users in QuickBooks on Windows 10/11 can be frustrating. This issue prevents seamless collaboration and hampers productivity, posing challenges for businesses relying on QuickBooks for their accounting needs. Reasons for Why Not Switching to Multi-User Mode: Several factors could lead to QuickBooks not allowing multiple users on Windows 10 and 11. These may include:Firewall Restrictions: Windows Firewall or third-party firewall settings may be blocking QuickBooks from communicating over the network, inhibiting multi-user access.Incorrect Network Configuration: Improper network settings, such as network sharing being disabled or incorrect permissions assigned, can prevent multiple users from accessing QuickBooks simultaneously.Outdated QuickBooks or Windows: Using outdated versions of QuickBooks or operating systems may result in compatibility issues, leading to the inability to enable multi-user mode.Solutions For QuickBooks Won’t allow multiple users in Windows 10/11: Check Firewall Settings: Verify that QuickBooks is allowed through the firewall by configuring firewall settings. Navigate to the firewall settings in Windows Security or your third-party firewall software and ensure that QuickBooks is listed as an allowed application.Verify Network Settings: Confirm that network sharing is enabled and that appropriate permissions are set for QuickBooks folders. Adjust network settings as necessary to facilitate communication between users and the QuickBooks database.Update QuickBooks and Windows: Ensure that both QuickBooks and Windows are up to date with the latest patches and updates. Installing the latest versions can resolve compatibility issues and improve overall performance.Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair network-related issues that may be preventing multi-user access. This tool can identify and resolve various networking problems within QuickBooks.Restart Hosting: Restart QuickBooks Database Server Manager and ensure that hosting is enabled for multi-user access. Navigate to the File menu within QuickBooks and select Utilities > Host Multi-User Access.Conclusion: By following these comprehensive solutions, you can overcome the hurdle of QuickBooks not allowing multiple users on Windows 10/11. Remember to troubleshoot systematically and reach out to QuickBooks support or community forums for further assistance if needed. With the right approach, you can restore seamless multi-user functionality and optimize collaboration within your organization. Read More
I had error and i cant update my windows 11 (Windows 11 Insider Preview 26200.5001 (ge_prerelease)
I can’t update my Windows it says Install error – 0x80070002 version
My OS build 26063.1
i use CANARY
I can’t update my Windows it says Install error – 0x80070002 version My OS build 26063.1i use CANARY Read More
Forwarding Teams meeting from my user account to a Teams device email address
Right now, what I just want to do. Is if my user gets an external Teams meeting to his account, he would like to forward that calendar meeting to our Teams room device this way you could have the meeting in the Teams conference room.
Now I have done testing and open the calendar event and then select forward from the toolbar and forward it to the e-mail address that’s tied to the Teams device. Afterwards I would go to the Teams device, and I would see nothing on the Teams device showing that meeting.
Do I need to do anything for that to work? I saw information regarding Zoom meetings being forwarded to MS Teams devices needing some background work. I didn’t see nothing special from external MS Teams to a user account to forward to Teams conference room device.
Right now, what I just want to do. Is if my user gets an external Teams meeting to his account, he would like to forward that calendar meeting to our Teams room device this way you could have the meeting in the Teams conference room.Now I have done testing and open the calendar event and then select forward from the toolbar and forward it to the e-mail address that’s tied to the Teams device. Afterwards I would go to the Teams device, and I would see nothing on the Teams device showing that meeting.Do I need to do anything for that to work? I saw information regarding Zoom meetings being forwarded to MS Teams devices needing some background work. I didn’t see nothing special from external MS Teams to a user account to forward to Teams conference room device. Read More
Flags for Resources
I have more than 20 group resource on my project, so i need more flags to create a color for each. How can I add more flags?
I have more than 20 group resource on my project, so i need more flags to create a color for each. How can I add more flags? Read More
SharePoint sites
Hello
Please i need your help on this issue.
I would like know when ever i upload a document to SharePoint sites it is going to my OneDrive storage, but i want it to stay in SharePoint.
Hello Please i need your help on this issue. I would like know when ever i upload a document to SharePoint sites it is going to my OneDrive storage, but i want it to stay in SharePoint. Read More
What To Do When Getting QBmapi64 out of memory error on windows 10/11
Using the 64-bit version of Windows 11 on Desktop 23
My computer updated from Windows 10 to Windows 11 last night, and now I’m receiving the message “qbmapi64 out of memory”
Please Help me.
Using the 64-bit version of Windows 11 on Desktop 23My computer updated from Windows 10 to Windows 11 last night, and now I’m receiving the message “qbmapi64 out of memory”Please Help me. Read More
Pnp Modern Search Results shows duplicate values
Hi all,
I have a PnP Modern Search and the results webpart shows only for one column double entries.
So in my case for the telephone number value it shows: “+1234 56789 +1234 56789”.
It is only in the results this way the list entries are fine. I only map one crawled property to one managed property.
I have already reindexed and also deleted the list.
Any ideas ?
Hi all,I have a PnP Modern Search and the results webpart shows only for one column double entries. So in my case for the telephone number value it shows: “+1234 56789 +1234 56789”.It is only in the results this way the list entries are fine. I only map one crawled property to one managed property. I have already reindexed and also deleted the list.Any ideas ? Read More
What To Do When Unable to Send QuickBooks Emails Through Outlook
when trying to send emails from QuickBooks to outlook i get an error that says Unable to Send QuickBooks Emails Through Outlook, restart outlook…this doesn’t work.
when trying to send emails from QuickBooks to outlook i get an error that says Unable to Send QuickBooks Emails Through Outlook, restart outlook…this doesn’t work. Read More
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