Tag Archives: microsoft
Exchange Admin – Recover deleted emails
Currently having a issue with a user that have deleted their email.
When trying to recover it through Exchange Admin the mail dont appear in their mailbox and the recovered mails still exist as a option to recover to the user. Anyone have any clue what this can be caused by? I don’t get any errors while doing it. I also can’t recover anything from their deleted inbox.
The deleted mail that the user wants are only located in Exchange Admin portal but still persists when recovering them to the inbox.
I have already checked the permissions and i’m allowed to do these changes.
Currently having a issue with a user that have deleted their email.When trying to recover it through Exchange Admin the mail dont appear in their mailbox and the recovered mails still exist as a option to recover to the user. Anyone have any clue what this can be caused by? I don’t get any errors while doing it. I also can’t recover anything from their deleted inbox.The deleted mail that the user wants are only located in Exchange Admin portal but still persists when recovering them to the inbox. I have already checked the permissions and i’m allowed to do these changes. Read More
Unsanctioned to all, exclude to some
Dear reader,
I have configured the asset rules en device tagging.
I need to deploy certain apps as unsanctioned to all W11 devices and exclude the same apps to certain devices who have a device tag I configured for exclusion.
The problem i am having is that the devices that need to be excluded, with the device tag “Exclude”
Are also part of the device tag “W11”
I could exclude them from the W11 device tagging but that would mean they would be excluded from all other policies that are targeted to the W11 tag. Which is not desirable.
I was hoping for a solution as how you would deploy in Intune, with includes and exludes groups, but it doenst look like the defender platform supports this.
I have been testing with exclude entities but this does not give the result i am looking for.
Can someone help me?
Maybe you had the same issue and found something smart way around this? 🙂
Thank you in advance!
Dear reader, I have configured the asset rules en device tagging. I need to deploy certain apps as unsanctioned to all W11 devices and exclude the same apps to certain devices who have a device tag I configured for exclusion. The problem i am having is that the devices that need to be excluded, with the device tag “Exclude”Are also part of the device tag “W11” I could exclude them from the W11 device tagging but that would mean they would be excluded from all other policies that are targeted to the W11 tag. Which is not desirable. I was hoping for a solution as how you would deploy in Intune, with includes and exludes groups, but it doenst look like the defender platform supports this. I have been testing with exclude entities but this does not give the result i am looking for. Can someone help me? Maybe you had the same issue and found something smart way around this? 🙂 Thank you in advance! Read More
App installation failed: Company Portal (Error code: 0x8024001E)
Operating system: Windows 11 Enterprise
Machine: Latitude 5540
Hi All,
I’m having trouble with one of our machines failing to install Company Portal.
Can you shed any light on this?
The error message from Managed Apps is:
App installation failed
18/06/2024 09:37:27
Hide details
Error code: 0x8024001E
Unknown
I’ve gone through the IntuneManagementExtension logs and can see these messages which relate to the Company Portal app ID “dc644022-cb6b-4c8a-b083-005392143a58”
[Win32App][WinGetApp][WinGetAppDetectionExecutor] Completed detection for app with id: dc644022-cb6b-4c8a-b083-005392143a58.
WinGet operation result:
Operation result = NotDetected
Installed version =
Reboot required = False
Installer Error code =
Extended error code =
Detection result:
Action status: Success
Detection state: NotDetected
Detected version:
Error code: IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015)
[Win32App] Toast message with: “C:Program Files (x86)Microsoft Intune Management Extensionagentexecutor.exe” -toast “ToastFailureMessage” “ODk3LU9TLUNvbXBhbnkgUG9ydGFs” “eyJDb21wYW55TmFtZSI6IkJyb3duIGFuZCBCcm93biwgSW5jIiwiQ29sb3JCYWNrZ3JvdW5kTG9nb1VyaSI6Imh0dHBzOi8vZmVmLm1zdWEwMS5tYW5hZ2UubWljcm9zb2Z0LmNvbS9Db250ZW50U2VydmljZS9TQ1NlcnZpY2UvQ29udGVudHMvYjBiMmQyNTgtOWM1YS00NDNjLWJiOTEtZTlmZGI1ZmE4YmZhIiwiV2hpdGVCYWNrZ3JvdW5kTG9nb1VyaSI6Imh0dHBzOi8vZmVmLm1zdWEwMS5tYW5hZ2UubWljcm9zb2Z0LmNvbS9Db250ZW50U2VydmljZS9TQ1NlcnZpY2UvQ29udGVudHMvMGE3NWZhYzUtYzE4NS00NTE3LWFiNWUtODkxNjY5ZDQwZWU3IiwiQWNjZW50Q29sb3IiOi0xNjc0NzgzNH0=” “0” IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015)
[Win32App][ReportingManager] Sending status to company portal based on report: {“ApplicationId”:”dc644022-cb6b-4c8a-b083-005392143a58″,”ResultantAppState”:2,”ReportingImpact”:{“DesiredState”:3,”Classification”:2,”ConflictReason”:0,”ImpactingApps”:[]},”WriteableToStorage”:true,”CanGenerateComplianceState”:true,”CanGenerateEnforcementState”:true,”IsAppReportable”:true,”IsAppAggregatable”:true,”AvailableAppEnforcementFlag”:0,”DesiredState”:2,”DetectionState”:2,”DetectionErrorOccurred”:false,”DetectionErrorCode”:null,”ApplicabilityState”:0,”ApplicabilityErrorOccurred”:false,”ApplicabilityErrorCode”:null,”EnforcementState”:5000,”EnforcementErrorCode”:-2145124322,”TargetingMethod”:0,”TargetingType”:2,”InstallContext”:2,”Intent”:3,”InternalVersion”:1,”DetectedIdentityVersion”:null,”RemovalReason”:null} IntuneManagementExtension 24/06/2024 10:10:02 21 (0x0015)
[Win32App][WinGetApp][WinGetAppApplicabilityExecutor] Completed applicability check for app with id: dc644022-cb6b-4c8a-b083-005392143a58.
WinGet operation result:
Operation result = Ok
Installed version =
Reboot required = False
Installer Error code =
Extended error code =
Applicability result:
Action status: Success
Applicability state: Applicable
Applicability state message: Applicable
Error code: IntuneManagementExtension 24/06/2024 10:09:59 21 (0x0015)
[Win32App][WinGetApp][AppPackageManager] An error occurred during app install or upgrade.
Installer error code: -2145124322.
Exception: System.Exception: Exception from HRESULT: 0x8024001E. IntuneManagementExtension 24/06/2024 10:10:01 16 (0x0010)
[Win32App][WinGetApp][WinGetAppExecutionExecutor] Completed execution for app with id: dc644022-cb6b-4c8a-b083-005392143a58.
WinGet operation result:
Operation result = InstallError
Installed version =
Reboot required = False
Installer Error code = -2145124322
Extended error code = -2145124322
Execution result:
Action status: Failed
Enforcement state: Error
Reboot status: Clean
Error code: -2145124322 IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015)
Operating system: Windows 11 EnterpriseOperating system version: 10.0.22631.3737Machine: Latitude 5540 Hi All, I’m having trouble with one of our machines failing to install Company Portal.Can you shed any light on this? The error message from Managed Apps is:App installation failed18/06/2024 09:37:27Hide detailsError code: 0x8024001EUnknown I’ve gone through the IntuneManagementExtension logs and can see these messages which relate to the Company Portal app ID “dc644022-cb6b-4c8a-b083-005392143a58” [Win32App][WinGetApp][WinGetAppDetectionExecutor] Completed detection for app with id: dc644022-cb6b-4c8a-b083-005392143a58.WinGet operation result:Operation result = NotDetectedInstalled version =Reboot required = FalseInstaller Error code =Extended error code =Detection result:Action status: SuccessDetection state: NotDetectedDetected version:Error code: IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015)[Win32App] Toast message with: “C:Program Files (x86)Microsoft Intune Management Extensionagentexecutor.exe” -toast “ToastFailureMessage” “ODk3LU9TLUNvbXBhbnkgUG9ydGFs” “eyJDb21wYW55TmFtZSI6IkJyb3duIGFuZCBCcm93biwgSW5jIiwiQ29sb3JCYWNrZ3JvdW5kTG9nb1VyaSI6Imh0dHBzOi8vZmVmLm1zdWEwMS5tYW5hZ2UubWljcm9zb2Z0LmNvbS9Db250ZW50U2VydmljZS9TQ1NlcnZpY2UvQ29udGVudHMvYjBiMmQyNTgtOWM1YS00NDNjLWJiOTEtZTlmZGI1ZmE4YmZhIiwiV2hpdGVCYWNrZ3JvdW5kTG9nb1VyaSI6Imh0dHBzOi8vZmVmLm1zdWEwMS5tYW5hZ2UubWljcm9zb2Z0LmNvbS9Db250ZW50U2VydmljZS9TQ1NlcnZpY2UvQ29udGVudHMvMGE3NWZhYzUtYzE4NS00NTE3LWFiNWUtODkxNjY5ZDQwZWU3IiwiQWNjZW50Q29sb3IiOi0xNjc0NzgzNH0=” “0” IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015)[Win32App][ReportingManager] Sending status to company portal based on report: {“ApplicationId”:”dc644022-cb6b-4c8a-b083-005392143a58″,”ResultantAppState”:2,”ReportingImpact”:{“DesiredState”:3,”Classification”:2,”ConflictReason”:0,”ImpactingApps”:[]},”WriteableToStorage”:true,”CanGenerateComplianceState”:true,”CanGenerateEnforcementState”:true,”IsAppReportable”:true,”IsAppAggregatable”:true,”AvailableAppEnforcementFlag”:0,”DesiredState”:2,”DetectionState”:2,”DetectionErrorOccurred”:false,”DetectionErrorCode”:null,”ApplicabilityState”:0,”ApplicabilityErrorOccurred”:false,”ApplicabilityErrorCode”:null,”EnforcementState”:5000,”EnforcementErrorCode”:-2145124322,”TargetingMethod”:0,”TargetingType”:2,”InstallContext”:2,”Intent”:3,”InternalVersion”:1,”DetectedIdentityVersion”:null,”RemovalReason”:null} IntuneManagementExtension 24/06/2024 10:10:02 21 (0x0015) [Win32App][WinGetApp][WinGetAppApplicabilityExecutor] Completed applicability check for app with id: dc644022-cb6b-4c8a-b083-005392143a58.WinGet operation result:Operation result = OkInstalled version =Reboot required = FalseInstaller Error code =Extended error code =Applicability result:Action status: SuccessApplicability state: ApplicableApplicability state message: ApplicableError code: IntuneManagementExtension 24/06/2024 10:09:59 21 (0x0015) [Win32App][WinGetApp][AppPackageManager] An error occurred during app install or upgrade.Installer error code: -2145124322.Exception: System.Exception: Exception from HRESULT: 0x8024001E. IntuneManagementExtension 24/06/2024 10:10:01 16 (0x0010) [Win32App][WinGetApp][WinGetAppExecutionExecutor] Completed execution for app with id: dc644022-cb6b-4c8a-b083-005392143a58.WinGet operation result:Operation result = InstallErrorInstalled version =Reboot required = FalseInstaller Error code = -2145124322Extended error code = -2145124322Execution result:Action status: FailedEnforcement state: ErrorReboot status: CleanError code: -2145124322 IntuneManagementExtension 24/06/2024 10:10:01 21 (0x0015) Read More
Data Import Advice (Formatting)
Hi all,
I have searched for this on Google and struggle to get a clear answer.
I am importing data into excel from another workbook using Data > Get Data > From File > Excel .xls
This then creates a data connection and then a new sheet with the imported data.
However, when I try to query this imported sheet with VLOOKUP or INDEX/MATCH or XLOOKUP etc, sometimes I get a “#N/A” error. I have established that this is due to some issue with the lookup value formatting. For example:
=IFERROR(VLOOKUP($A$1,’ImportedSheet’$A$1:$C$8,2,),””)
A1 is for instance a number = 26
In the imported sheet data, A4 for example is 26. However the VLOOKUP produces the N/A error.
When I change the lookup value to VLOOKUP(“26”,’ImportedSheet…) it works.
My guess is something to do with the formatting when imported. Can anyone help clarify this for me and advise on the best way of dealing with data in this way?
Thanks for your help!
Hi all, I have searched for this on Google and struggle to get a clear answer. I am importing data into excel from another workbook using Data > Get Data > From File > Excel .xlsThis then creates a data connection and then a new sheet with the imported data. However, when I try to query this imported sheet with VLOOKUP or INDEX/MATCH or XLOOKUP etc, sometimes I get a “#N/A” error. I have established that this is due to some issue with the lookup value formatting. For example: =IFERROR(VLOOKUP($A$1,’ImportedSheet’$A$1:$C$8,2,),””) A1 is for instance a number = 26 In the imported sheet data, A4 for example is 26. However the VLOOKUP produces the N/A error.When I change the lookup value to VLOOKUP(“26”,’ImportedSheet…) it works. My guess is something to do with the formatting when imported. Can anyone help clarify this for me and advise on the best way of dealing with data in this way? Thanks for your help! Read More
What’s New in Copilot for Sales – June 2024
Microsoft Copilot for Sales is reimagining sales. Integrated seamlessly into your daily tools across Microsoft 365 and Teams, Copilot for Sales harnesses the power of generative AI and customer data to keep sellers in their flow of work so they can spend more time with customers.
In June, we’re adding features to multiple surfaces, including Microsoft Outlook, Microsoft Teams, and to Microsoft Copilot Studio! We’re pleased to announce new capabilities in the Outlook suggested actions card, new options for saving email and meetings, and the ability to view recent communications. In Teams, we’ve added a new action items service and improved discoverability for Sales in meeting recap. And now you can enable Power Connector plugins in Copilot Studio to extend Copilot for Sales (in preview). We wrap up the blog with resources for getting started, learning more, and staying connected.
Copilot for Sales capabilities highlighted in this post are released during the month of June 2024. It may take time for specific capabilities to reach every tenant in each market.
In Outlook
New capabilities added to Suggested CRM actions card
We’re excited to announce several new capabilities for the Suggested CRM actions card. Copilot for Sales scans email conversations and compares the data with data in the CRM when determining which updates to suggest – looking for changes in monetary value (such as budgets, revenue, or fees), timeline, and deal progression.
This month, we’re adding these new capabilities.
We now support scanning emails in additional languages, including Italian.
CRM record details are made available as soon as an email is connected to a record.
Inline editing is fully available to all customers for users with permission and for fields marked editable by admin settings. When not available, and for calculated fields, we deep link to the connected CRM.
Learn more about suggested CRM updates.
New options when saving email and meetings to the CRM
Copilot for Sales supports the capability to save email and meetings to the CRM. With this release, we’re enhancing the save capability with new actions on save, including the ability to save selected attachments and to add additional fields.
Include choice of email attachments on save
Today, emails and meetings are saved to the CRM without associated attachments. This means sellers need to manually add desired attachments to the CRM, adding to their process and taking them outside the flow of work.
In this release, we’re pleased to announce sellers can now select one or more eligible Outlook email or meeting attachments to save to the CRM when the email or meeting is saved. Sellers stay in the flow of work by eliminating the manual process of saving attachments to their CRM.
Categorize Outlook emails and events when saving to CRM
Sellers often want to add additional details about a meeting (such as whether it was face-to-face, or a site visit) or about an email (such as whether it has personal information) when saving it to the CRM. Today, sellers must leave their flow of work and manually update the activities in CRM with this additional information.
With our June release, sellers can now provide additional data to be saved along with the email or meeting right when they save the activities to CRM from copilot, allowing them to stay in the flow of work in Outlook.
This capability will be available once the Copilot for Sales administrator configures which fields will accept additional data when saving to the CRM by using the documentation to configure how Outlook email and events are saved to the CRM.
View recent communications
Relevant information about past interactions with a customer is scattered across multiple surfaces, including emails in Outlook and meetings in Teams. Consolidating this information is tedious, manual work.
By surfacing recent communications and insights in the flow of work, sellers can quickly catch up on the latest context and move deals forward with accurate, relevant responses.
In this release, available by the end of June, we’ve added a new “Recent communications” card that’s displayed in the context of an email or meeting opened in Outlook. By default, the card shows the most recent email thread and Teams meeting involving the first external contact* in the email or meeting.
*Contact is the first external email address in the list (sender, to, and CC for emails; and organizer, required attendees, and optional attendees for meetings). If the email or meeting is in Compose mode, the list does not include the sender/organizer.
Sellers can get AI-based summaries of recent email conversations and open recent email threads and meeting invitations in Outlook.
Sellers can see up to three of the most recent email threads and Teams meetings from the last 30 days with the first external contact in the email or meeting by choosing the See all link on the card.
In Teams
New action items service
To be more efficient, sellers need systems which can automatically and accurately record their commitments and action items during meetings for efficient tracking and follow-up.
With our June release of Copilot for Sales, we’ve improved how we handle action item recording during meetings. These enhanced capabilities, now generally available, include:
An action item service based on LLM (GPT4)
A consistent structure for action items with topic, description, and assignee.
Improved quality with a higher “hit rate” for mentioned follow-ups.
Improved discoverability for Sales in Teams meeting recap
Sellers need a system allowing easy access to sales meeting summaries in the Teams recap for quick reference and action, saving their valuable time.
We’re happy to announce that we’ve improved the discoverability of sales meeting summaries with our current release! Now in general availability, eligible users will receive a notification when their meeting summary is ready for review, along with a link to the Sales section in the Teams meeting recap for easy access. By selecting the link from the notification, the seller will be taken directly to the sales meeting summary.
In Microsoft Copilot Studio
Enable Power Connector plugins to extend Copilot for Sales (In Preview)
Currently, customers need to reach out to Microsoft to enable plugins for users of Copilot for Sales. With our June release, customers can use the plugin management features in Microsoft Copilot Studio to deploy custom plugins for specific users connecting to specific CRM environments. This is a preview capability.
Simply have your Copilot for Sales administrator enable custom or certified plugins for copilot users in Copilot Studio. If a plugin is no longer required, the Copilot for Sales administrator can also disable them in Copilot Studio.
Get started
Ready to join us and other top-performing sales organizations worldwide? Reach out to your Microsoft sales team or visit our product web page.
Ready to install Copilot for Sales? Have a look at our deployment guide for Dynamics 365 Sales users or our deployment guide for Salesforce users.
Learn more
Ready for all the details? Check out the Copilot for Sales product documentation.
Ready for the latest tips…and more? Copilot for Sales Tip Time can serve as a foundation for your training of Copilot for Sales users, customers, or partners! This content includes use cases and demonstrates how each feature will benefit sellers, administrators, and sales managers.
Looking for the latest adoption resources? Visit the Copilot for Sales Adoption Center and find the latest information about how to go from inspiration to adoption.
Stay connected
Want to stay connected? Learn about the latest improvements before everyone else at https://aka.ms/copilotforsalesupdates. Join our community in the community discussion forum and we always welcome your feedback and ideas in our product feedback portal.
Microsoft Tech Community – Latest Blogs –Read More
M365AdoptionUG: Manage Employee Attention using MOCA #HumanFirst Approach
What more could you want than to have Microsoft’s Behaviour & Modern Work Architect, Rishi Nicolai with over fifteen years’ comprehensive experience working with various elements of Adoption, Organizational Change Management, IT Service Management and Business Process Re-engineering back in the house?!
We’re excited to have a session that provides us a walkthrough of the updated MOCA (modern collaboration architecture) model (that now includes Copilot) with guidance on how to integrate it with their organisation’s adoption programs.
BONUS, win a ticket to the Digital Workplace Conference to the value of $1375! Home – DWCAU
Afterwards, stick around to hear all the latest on what’s new and coming to Microsoft 365 & the ACM space!
Online Teams Meeting Link: https://aka.ms/M365UG
DETAILS
AGENDA:
12:00 – 12:05 Welcome: Kirsty McGrath
12:05 – 12:50 Managing Employee Attention using the Extended MOCA – a #HumanFirst approach to Adoption with Rishi Nicolai
12:50 – 1:50 What’s New & Coming to Microsoft 365 & ACM
1:25 – 1:30 What’s Next & Close: Kirsty McGrath
SYNOPSIS:
Copilot is a once in a generation leap in revolutionizing the way leaders can enable employees to boost individual, team and organizational productivity. Microsoft has enhanced the Modern Collaboration Architecture (MOCA), to include the “Which Copilot When” story. Please go to http://aka.ms/MOCA for all to download.
The notion of employee productivity has been disrupted since the general availability of GenAI based tools available to consumers. employees are exploring how they use these tools within their organisations to streamline the way they work and improve personal and team effectiveness. This brings forward a significant opportunity on how technology can support “attention harnessing behaviours”, and if adoption programs are set up correctly, eliminate “distraction behaviours” within employees, resulting in a productivity multiplier. The MOCA updates look to explore how the Copilot suite of technologies can be used to focus on developing a “productivity focused” adoption program within the organisation, building on the ‘which tool to achieve which outcome’ for Microsoft 365 (and other Microsoft Cloud components). This session provides adoption leads a walkthrough of the updated MOCA model with guidance on how to integrate it with their organisation’s adoption programs.
If you missed Rishi speaking at the M365 Adoption User Group previously about MOCA, you can see his presentation & listen here: M365 Adoption Rishi
BIO:
Rishi Nicolai is the Behaviour & Modern Work Architect at Microsoft with over fifteen years’ comprehensive experience working with various elements of Adoption, Organizational Change Management, IT Service Management and Business Process Re-engineering. Rishi has been involved in large-scale change implementations ($1B+) as well as some medium size complex projects. Rishi has worked with over 150 customers worldwide on developing and executing M365 and Copilot adoption programs and is also a Prosci Certified Advanced Instructor (PCAI) with degrees in Psychology (Monash), Change Management (UNSW), Information Technology (QUT) and is current pursuing his MBA (UNSW).
What more could you want than to have Microsoft’s Behaviour & Modern Work Architect, Rishi Nicolai with over fifteen years’ comprehensive experience working with various elements of Adoption, Organizational Change Management, IT Service Management and Business Process Re-engineering back in the house?!
We’re excited to have a session that provides us a walkthrough of the updated MOCA (modern collaboration architecture) model (that now includes Copilot) with guidance on how to integrate it with their organisation’s adoption programs.
BONUS, win a ticket to the Digital Workplace Conference to the value of $1375! Home – DWCAU
Afterwards, stick around to hear all the latest on what’s new and coming to Microsoft 365 & the ACM space!
Online Teams Meeting Link: https://aka.ms/M365UG
DETAILS
AGENDA:
12:00 – 12:05 Welcome: Kirsty McGrath
12:05 – 12:50 Managing Employee Attention using the Extended MOCA – a #HumanFirst approach to Adoption with Rishi Nicolai
12:50 – 1:50 What’s New & Coming to Microsoft 365 & ACM
1:25 – 1:30 What’s Next & Close: Kirsty McGrath
SYNOPSIS:
Copilot is a once in a generation leap in revolutionizing the way leaders can enable employees to boost individual, team and organizational productivity. Microsoft has enhanced the Modern Collaboration Architecture (MOCA), to include the “Which Copilot When” story. Please go to http://aka.ms/MOCA for all to download.
The notion of employee productivity has been disrupted since the general availability of GenAI based tools available to consumers. employees are exploring how they use these tools within their organisations to streamline the way they work and improve personal and team effectiveness. This brings forward a significant opportunity on how technology can support “attention harnessing behaviours”, and if adoption programs are set up correctly, eliminate “distraction behaviours” within employees, resulting in a productivity multiplier. The MOCA updates look to explore how the Copilot suite of technologies can be used to focus on developing a “productivity focused” adoption program within the organisation, building on the ‘which tool to achieve which outcome’ for Microsoft 365 (and other Microsoft Cloud components). This session provides adoption leads a walkthrough of the updated MOCA model with guidance on how to integrate it with their organisation’s adoption programs.
If you missed Rishi speaking at the M365 Adoption User Group previously about MOCA, you can see his presentation & listen here: M365 Adoption Rishi
BIO:
Rishi Nicolai is the Behaviour & Modern Work Architect at Microsoft with over fifteen years’ comprehensive experience working with various elements of Adoption, Organizational Change Management, IT Service Management and Business Process Re-engineering. Rishi has been involved in large-scale change implementations ($1B+) as well as some medium size complex projects. Rishi has worked with over 150 customers worldwide on developing and executing M365 and Copilot adoption programs and is also a Prosci Certified Advanced Instructor (PCAI) with degrees in Psychology (Monash), Change Management (UNSW), Information Technology (QUT) and is current pursuing his MBA (UNSW). Read More
SQL Server Management Studio
Hello,
I am new to Sql Express. (2022)
So I have a few questions that would help me along, thank you.
I am programming in Visual Studio 2022.
1. Is it imperitive that I use SQL Server Management Studio to create MDF in SQLEXPRESS DATABASE ENGINE? OR, just use VS2022?
2. Do I need to utilise SQL Server Management Studio to create a Report Server Project (and have ‘report run’ feature functionality) OR, just use Visual Studio 2022?
3. Do I need to ‘buy’ a Server Certificate?
I have been using localdb and creating reports using a Report Server Project. But of course I can not get them to run under localdb. I have read and tried everything that I can. Besides creating a SqlExpress database server, I only managed to allow open the correct port in Microsoft Firewall Defender. Regarding permissions, certificates ect…, I am lost.
Any help and guidance is appreciated.
Many thanks,
Shane1961
Hello, I am new to Sql Express. (2022) So I have a few questions that would help me along, thank you. I am programming in Visual Studio 2022. 1. Is it imperitive that I use SQL Server Management Studio to create MDF in SQLEXPRESS DATABASE ENGINE? OR, just use VS2022? 2. Do I need to utilise SQL Server Management Studio to create a Report Server Project (and have ‘report run’ feature functionality) OR, just use Visual Studio 2022? 3. Do I need to ‘buy’ a Server Certificate? I have been using localdb and creating reports using a Report Server Project. But of course I can not get them to run under localdb. I have read and tried everything that I can. Besides creating a SqlExpress database server, I only managed to allow open the correct port in Microsoft Firewall Defender. Regarding permissions, certificates ect…, I am lost. Any help and guidance is appreciated. Many thanks, Shane1961 Read More
Auto Turn off Teams/Channel notification
Hi All! We have a situation where a user has a specific teams/channel. It has 10 members and has roster duties. If 5 of them is off duty do you think is there any way to disabled the notification to a specific Teams/Channel automatically? Then enabled automatically again the notification if they are on duty?
Hi All! We have a situation where a user has a specific teams/channel. It has 10 members and has roster duties. If 5 of them is off duty do you think is there any way to disabled the notification to a specific Teams/Channel automatically? Then enabled automatically again the notification if they are on duty? Read More
The Best GPS Tracking Software for Your Fleet Business
GPS Tracking System
Running a fleet business isn’t just about getting from point A to point B; it’s about doing so efficiently, safely, and cost-effectively. This is where GPS tracking software comes into play. In this guide, we’ll delve into how the best GPS tracking systems can meet the diverse needs of your fleet business, ensuring smoother operations and improved bottom lines.
What is a GPS Tracking System?
A GPS tracking system is a technology that uses the Global Positioning System to monitor the location and movement of vehicles. It comprises a network of satellites, a GPS receiver in the vehicle, and software that processes the data. This technology enables real-time tracking, route planning, and performance analysis.
Why Your Fleet Business Needs a GPS Tracking System
Improved Efficiency: GPS tracking systems provide real-time data on vehicle locations, helping fleet managers optimize routes and reduce idle times. This leads to faster deliveries and better resource utilization.
Enhanced Safety: With GPS tracking, you can monitor driver behavior, set speed limits, and receive alerts for any unauthorized vehicle use, ensuring that safety protocols are adhered to.
Cost Savings: By optimizing routes and reducing fuel consumption, GPS tracking systems can significantly lower operational costs. Maintenance alerts also help in avoiding costly repairs by addressing issues early.
Key Features of GPS Tracking Systems
Real-time Tracking: Know where your vehicles are at all times, enabling quicker response to unexpected situations.
Route Optimization: Efficient route planning reduces travel time and fuel consumption, improving overall productivity.
Geofencing: Set virtual boundaries and receive alerts when vehicles enter or exit designated areas, enhancing security and operational control.
Maintenance Alerts: Schedule regular maintenance and get alerts for upcoming services, ensuring your fleet stays in top condition.
Driver Behavior Monitoring: Track and analyze driver performance, promoting safer driving habits and reducing accident risks.
How GPS Tracking Systems Work
GPS tracking systems use satellites to triangulate the location of the GPS receiver installed in the vehicle. The data collected is then transmitted to a central server via cellular or satellite networks. This information is processed and made accessible through software that offers insights into vehicle locations, routes, and driver behavior.
Top GPS Tracking Systems for Fleet Management
Secure Path Premium: Known for its comprehensive features and reliability, Secure Path Premium offers real-time tracking, route optimization, and robust reporting tools. It’s designed to meet the needs of both small and large fleet businesses.
Shahin Sira Dubai: This system is tailored specifically for the needs of fleet businesses in the Middle East, providing unique features like region-specific maps and compliance with local regulations. It’s an excellent choice for companies operating in this region.
Other Notable Systems: There are several other GPS tracking systems worth considering, including Fleet Complete, Geotab, and Samsara, each offering unique features and benefits.
Secure Path Premium: A Comprehensive Solution
Features and Benefits: Secure Path Premium offers a range of features, including real-time tracking, driver behavior monitoring, geofencing, and detailed reporting. Its user-friendly interface and robust support make it a favorite among fleet managers.
User Testimonials: Many fleet businesses have reported significant improvements in efficiency and cost savings after implementing Secure Path Premium. The system’s reliability and comprehensive features are often highlighted in reviews.
Shahin Sira Dubai: Tailored for Fleet Businesses
Unique Offerings: Shahin Sira Dubai stands out for its focus on the Middle Eastern market, offering region-specific features and compliance with local regulations. It provides excellent support and customization options to meet the unique needs of businesses in this area.
Case Studies and Success Stories: Numerous companies have successfully integrated Shahin Sira Dubai into their operations, reporting increased efficiency, better compliance, and improved safety records.
Choosing the Right GPS Tracking System for Your Business
Assessing Your Needs: Start by identifying what you need from a GPS tracking system. Consider factors like fleet size, types of vehicles, and specific operational challenges.
Comparing Features and Costs: Look at the features offered by different systems and compare their costs. Ensure that the system you choose provides good value for money.
Implementation Considerations: Consider how the system will be integrated into your existing operations. Look for systems that offer easy installation and user-friendly interfaces.
Integrating GPS Tracking with Fleet tracking Softwares
Importance of Integration: Integrating GPS tracking with your Fleet Management System ensures seamless data flow and better decision-making. It allows for comprehensive tracking and management from a single platform.
Best Practices: To get the most out of your GPS tracking system, ensure regular updates, provide training for your team, and use the data collected to continuously improve your operations.
Benefits of GPS Tracking in Fleet Management
Increased Productivity: By optimizing routes and reducing downtime, GPS tracking can significantly boost productivity.
Enhanced Customer Satisfaction: Real-time tracking allows you to provide accurate delivery times and updates to customers, improving service quality.
Reduced Environmental Impact: Efficient route planning and reduced idling times lead to lower fuel consumption and emissions, making your operations more eco-friendly.
Overcoming Common Challenges with GPS Tracking Systems
Data Privacy Concerns: Ensure that your GPS tracking system complies with data privacy regulations. Implement policies to protect driver privacy and secure data.
Technical Issues: Choose a reliable system with good customer support to minimize technical issues. Regular maintenance and updates are also crucial.
Employee Resistance: Address concerns through clear communication and training. Highlight the benefits of the system to gain employee buy-in.
Future Trends in GPS Tracking for Fleet Management
Advancements in Technology: Expect improvements in GPS accuracy, integration with other technologies, and more intuitive user interfaces.
Emerging Features and Innovations: Look out for features like AI-driven analytics, predictive maintenance, and enhanced connectivity with IoT devices, which will further revolutionize fleet management.
Conclusion
Implementing a GPS tracking system can transform your fleet business, bringing about improved efficiency, enhanced safety, and significant cost savings. Whether you opt for Secure Path Premium, Shahin Sira Dubai, or another system, the key is to choose a solution that aligns with your business needs and goals. Stay ahead of the curve by embracing the latest technologies and continuously optimizing your operations.
FAQs
What is the best GPS tracking system for small fleets?
For small fleets, systems like Secure Path Premium and Geotab offer robust features and scalability to grow with your business.
How does GPS tracking improve fleet safety?
GPS tracking monitors driver behavior, provides real-time alerts for unsafe practices, and helps enforce safety protocols, reducing the risk of accidents.
Can GPS tracking help reduce fuel costs?
Yes, by optimizing routes and reducing idle times, GPS tracking can significantly lower fuel consumption and associated costs.
What are the legal considerations for using GPS tracking?
Ensure compliance with data privacy laws and obtain consent from employees where required. It’s also important to use the data ethically.
How often should GPS tracking systems be updated?
Regular updates are essential to ensure the system remains accurate and secure. Check for updates from the provider and schedule regular maintenance.
GPS Tracking SystemRunning a fleet business isn’t just about getting from point A to point B; it’s about doing so efficiently, safely, and cost-effectively. This is where GPS tracking software comes into play. In this guide, we’ll delve into how the best GPS tracking systems can meet the diverse needs of your fleet business, ensuring smoother operations and improved bottom lines.What is a GPS Tracking System?A GPS tracking system is a technology that uses the Global Positioning System to monitor the location and movement of vehicles. It comprises a network of satellites, a GPS receiver in the vehicle, and software that processes the data. This technology enables real-time tracking, route planning, and performance analysis.Why Your Fleet Business Needs a GPS Tracking SystemImproved Efficiency: GPS tracking systems provide real-time data on vehicle locations, helping fleet managers optimize routes and reduce idle times. This leads to faster deliveries and better resource utilization.Enhanced Safety: With GPS tracking, you can monitor driver behavior, set speed limits, and receive alerts for any unauthorized vehicle use, ensuring that safety protocols are adhered to.Cost Savings: By optimizing routes and reducing fuel consumption, GPS tracking systems can significantly lower operational costs. Maintenance alerts also help in avoiding costly repairs by addressing issues early.Key Features of GPS Tracking SystemsReal-time Tracking: Know where your vehicles are at all times, enabling quicker response to unexpected situations.Route Optimization: Efficient route planning reduces travel time and fuel consumption, improving overall productivity.Geofencing: Set virtual boundaries and receive alerts when vehicles enter or exit designated areas, enhancing security and operational control.Maintenance Alerts: Schedule regular maintenance and get alerts for upcoming services, ensuring your fleet stays in top condition.Driver Behavior Monitoring: Track and analyze driver performance, promoting safer driving habits and reducing accident risks.How GPS Tracking Systems WorkGPS tracking systems use satellites to triangulate the location of the GPS receiver installed in the vehicle. The data collected is then transmitted to a central server via cellular or satellite networks. This information is processed and made accessible through software that offers insights into vehicle locations, routes, and driver behavior.Top GPS Tracking Systems for Fleet ManagementSecure Path Premium: Known for its comprehensive features and reliability, Secure Path Premium offers real-time tracking, route optimization, and robust reporting tools. It’s designed to meet the needs of both small and large fleet businesses.Shahin Sira Dubai: This system is tailored specifically for the needs of fleet businesses in the Middle East, providing unique features like region-specific maps and compliance with local regulations. It’s an excellent choice for companies operating in this region.Other Notable Systems: There are several other GPS tracking systems worth considering, including Fleet Complete, Geotab, and Samsara, each offering unique features and benefits.Secure Path Premium: A Comprehensive SolutionFeatures and Benefits: Secure Path Premium offers a range of features, including real-time tracking, driver behavior monitoring, geofencing, and detailed reporting. Its user-friendly interface and robust support make it a favorite among fleet managers.User Testimonials: Many fleet businesses have reported significant improvements in efficiency and cost savings after implementing Secure Path Premium. The system’s reliability and comprehensive features are often highlighted in reviews.Shahin Sira Dubai: Tailored for Fleet BusinessesUnique Offerings: Shahin Sira Dubai stands out for its focus on the Middle Eastern market, offering region-specific features and compliance with local regulations. It provides excellent support and customization options to meet the unique needs of businesses in this area.Case Studies and Success Stories: Numerous companies have successfully integrated Shahin Sira Dubai into their operations, reporting increased efficiency, better compliance, and improved safety records.Choosing the Right GPS Tracking System for Your BusinessAssessing Your Needs: Start by identifying what you need from a GPS tracking system. Consider factors like fleet size, types of vehicles, and specific operational challenges.Comparing Features and Costs: Look at the features offered by different systems and compare their costs. Ensure that the system you choose provides good value for money.Implementation Considerations: Consider how the system will be integrated into your existing operations. Look for systems that offer easy installation and user-friendly interfaces.Integrating GPS Tracking with Fleet tracking SoftwaresImportance of Integration: Integrating GPS tracking with your Fleet Management System ensures seamless data flow and better decision-making. It allows for comprehensive tracking and management from a single platform.Best Practices: To get the most out of your GPS tracking system, ensure regular updates, provide training for your team, and use the data collected to continuously improve your operations.GPS Tracking System in DubaiBenefits of GPS Tracking in Fleet ManagementIncreased Productivity: By optimizing routes and reducing downtime, GPS tracking can significantly boost productivity.Enhanced Customer Satisfaction: Real-time tracking allows you to provide accurate delivery times and updates to customers, improving service quality.Reduced Environmental Impact: Efficient route planning and reduced idling times lead to lower fuel consumption and emissions, making your operations more eco-friendly.Overcoming Common Challenges with GPS Tracking SystemsData Privacy Concerns: Ensure that your GPS tracking system complies with data privacy regulations. Implement policies to protect driver privacy and secure data.Technical Issues: Choose a reliable system with good customer support to minimize technical issues. Regular maintenance and updates are also crucial.Employee Resistance: Address concerns through clear communication and training. Highlight the benefits of the system to gain employee buy-in.Future Trends in GPS Tracking for Fleet ManagementAdvancements in Technology: Expect improvements in GPS accuracy, integration with other technologies, and more intuitive user interfaces.Emerging Features and Innovations: Look out for features like AI-driven analytics, predictive maintenance, and enhanced connectivity with IoT devices, which will further revolutionize fleet management.ConclusionImplementing a GPS tracking system can transform your fleet business, bringing about improved efficiency, enhanced safety, and significant cost savings. Whether you opt for Secure Path Premium, Shahin Sira Dubai, or another system, the key is to choose a solution that aligns with your business needs and goals. Stay ahead of the curve by embracing the latest technologies and continuously optimizing your operations.FAQsWhat is the best GPS tracking system for small fleets?For small fleets, systems like Secure Path Premium and Geotab offer robust features and scalability to grow with your business.How does GPS tracking improve fleet safety? GPS tracking monitors driver behavior, provides real-time alerts for unsafe practices, and helps enforce safety protocols, reducing the risk of accidents.Can GPS tracking help reduce fuel costs?Yes, by optimizing routes and reducing idle times, GPS tracking can significantly lower fuel consumption and associated costs.What are the legal considerations for using GPS tracking?Ensure compliance with data privacy laws and obtain consent from employees where required. It’s also important to use the data ethically.How often should GPS tracking systems be updated?Regular updates are essential to ensure the system remains accurate and secure. Check for updates from the provider and schedule regular maintenance. Read More
Copiot en Word no funciona igual que Copilot Web
El mismo Promt relativamente complejo en Word no lo reconoce y en Web funciona perfectamente.
El mismo Promt relativamente complejo en Word no lo reconoce y en Web funciona perfectamente. Read More
extracting car plate from cell
I have to extract car plate from bank reference column. there are more than 10000 lines per month. The position of the car plate in the string varies. The car plate has min of 5 and max 10 alphabet+ numbers in it. What formula can I use for this?
I have to extract car plate from bank reference column. there are more than 10000 lines per month. The position of the car plate in the string varies. The car plate has min of 5 and max 10 alphabet+ numbers in it. What formula can I use for this? Read More
Prepare for Your Next Certification
Introduction
Have you studied for a certification before and struggled with memorizing some of the content you have read?
I have indeed struggled with it! An example is that I studied for the Endpoint Administrator (MD-102) certification, where I had to memorize the different app types in Intune. Do you know what helped me? Flashcards!
I am excited to tell you more about a workshop where you can create your own flashcards later in this blog.
First, I will give you my tips and tricks for studying for a certification.
Studying for a Microsoft Certification
Are you looking at starting with a Microsoft certification and are wondering how to get started? Look no further, I will give you some tips and tricks below.
First of all, I would recommend you take a look at the study guide. For this example, I will be using the MD-102 study guide. The study guide will be give you some insights on how much each topic will be covered in percentage on the exam.
Once you have become familiar with the study guide, it’s time to learn! There isn’t a better place learning, then Microsoft Learn. Here you have free materials that will help you prepare for your exam.
Lastly, you will have to test your knowledge to see if you are ready for the exam. On the MD-102 exam, there are free practice assessments that will give you an idea of whether you are ready for the exam.
I hope these tips and tricks will help you prepare for your certification. If you have any other tips, let us know in the comment section!
Flashcards with Microsoft Fabric and Azure OpenAI
When I had to use flashcards, I always had to create them manually. It takes a lot of time, which is better spent on reading and learning about the certification you are trying to achieve. You wouldn’t believe me if I told you that, with a little work, you could actually use content directly from Microsoft Learn. This workshop will help you create your own flashcards with Fabric and OpenAI.
If you are interested in getting started, I would recommend you take a look at Github.
There is a guide on how to setup the environment for the workshop with step-by-step guidance.
Conclusion
Flashcards are great if you have to memorize certain topics when you are reading content for a certification. It takes a lot of time to create manually, but I hope this solution can help you in the future. It’s important to say that this solution can also help you prepare for certification renewals.
I hope that the tips from this blog can help you get started on your next Microsoft certification!
Microsoft Tech Community – Latest Blogs –Read More
Using MLX Framewrok with Phi-3
Previously, I shared with you how to use Phi-3-mini on AIPC’s NPU and iPhone. Some people want to know more about the experience of using macOS and how to use Apple Silicon to accelerate SLM models. This blog will share with you relevant knowledge, including how to use Apple MLX Framework to accelerate Phi-3-mini operation, fine-tune, and combine Llama.cpp for quantitative operation.
What’s MLX Framework
MLX is an array framework for machine learning research on Apple silicon, brought to you by Apple machine learning research.
MLX is designed by machine learning researchers for machine learning researchers. The framework is intended to be user-friendly, but still efficient to train and deploy models. The design of the framework itself is also conceptually simple. We intend to make it easy for researchers to extend and improve MLX with the goal of quickly exploring new ideas.
LLMs can be accelerated in Apple Silicon devices through MLX, and models can be run locally very conveniently.
Installation
Installing MLX is easy, you will need Python 3.11.x+, then install it in the terminal
pip install mlx-lm
Run MLX’s instructions
1. Running Phi-3-mini in Terminal with MLX
python -m mlx_lm.generate –model microsoft/Phi-3-mini-4k-instruct –max-token 2048 –prompt “<|user|>nCan you introduce yourself<|end|>n<|assistant|>”
2. Quantizing Phi-3-mini with MLX in Terminal
python -m mlx_lm.convert –hf-path microsoft/Phi-3-mini-4k-instruct
3. Running Phi-3-mini with MLX in Jupyter Notebook
Note: Please read Inference Phi-3 with Apple MLX Framework to Learn more
Fine-tuning with MLX Framework
We generally need GPU acceleration to complete model training or fine-tuning, but in Apple devices you can use Apple silicon’s MPS(Metal Performance Shaders) to replace the GPU to complete model training and fine-tuning.
What’s Metal Performance Shaders
The Metal Performance Shaders framework contains a collection of highly optimized compute and graphics shaders that are designed to integrate easily and efficiently into your Metal app. These data-parallel primitives are specially tuned to take advantage of the unique hardware characteristics of each GPU family to ensure optimal performance.
Sample – Using LoRA to fine-tuning Phi-3-mini with MLX
1. Data preparation
By default, MLX Framework requires the jsonl format of train, test, and eval, and is combined with Lora to complete fine-tuning jobs.
Note:
jsonl data format :
{“text”: “<|user|>nWhen were iron maidens commonly used? <|end|>n<|assistant|> nIron maidens were never commonly used <|end|>”}
{“text”: “<|user|>nWhat did humans evolve from? <|end|>n<|assistant|> nHumans and apes evolved from a common ancestor <|end|>”}
{“text”: “<|user|>nIs 91 a prime number? <|end|>n<|assistant|> nNo, 91 is not a prime number <|end|>”}
….
Our example uses TruthfulQA’s data , but the amount of data is relatively insufficient, so the fine-tuning results are not necessarily the best. It is recommended that learners use better data based on their own scenarios to complete.
The data format is combined with the Phi-3 template
Please download data from this link , please inculde all .jsonl in data folder
2. Fine-tuning in your terminal
Please run this command in terminal
python -m mlx_lm.lora –model microsoft/Phi-3-mini-4k-instruct –train –data ./data –iters 1000
Note: This is LoRA fine-tuning, MLX framework not published QLoRA
3. Run Fine-tuning adapter to test
You can run fine-tuning adapter in terminal,like this
python -m mlx_lm.generate –model microsoft/Phi-3-mini-4k-instruct –adapter-path ./adapters –max-token 2048 –prompt “Why do chameleons change colors? “ –eos-token “<|end|>”
and run original model to compare result
python -m mlx_lm.generate –model microsoft/Phi-3-mini-4k-instruct –max-token 2048 –prompt “Why do chameleons change colors? “ –eos-token “<|end|>”
You can try to compare the results of Fine-tuning with the original model
4. Merge adapters to generate new models
python -m mlx_lm.fuse –model microsoft/Phi-3-mini-4k-instruct
5. Running quantified fine-tuning models using ollama
Before use, please configure your llama.cpp environment
git clone https://github.com/ggerganov/llama.cpp.git
cd llama.cpp
pip install -r requirements.txt
python convert.py ‘Your meger model path’ –outfile phi-3-mini-ft.gguf –outtype f16
Note:
Now supports quantization conversion of fp32, fp16 and INT 8
The merged model is missing tokenizer.model, please download it from https://huggingface.co/microsoft/Phi-3-mini-4k-instruct
set Ollma Model file(If not install ollama ,please read [Ollama QuickStart](../02.QuickStart/Ollama_QuickStart.md)
FROM ./phi-3-mini-ft.gguf
PARAMETER stop “<|end|>”
run command in terminal
ollama create phi3ft -f Modelfile
ollama run phi3ft “Why do chameleons change colors?”
Note: Please read Fine-tuning Phi-3 with Apple MLX Framework to Learn more
Resources
Read Phi-3 CookBook https://aka.ms/phi-3cookbook
MLX framework Repo https://github.com/ml-explore
Learn more about MLX Framework https://ml-explore.github.io/mlx/
Hugging face Phi-3 Family https://huggingface.co/collections/microsoft/phi-3-6626e15e9585a200d2d761e3
Microsoft Tech Community – Latest Blogs –Read More
How to deploy Angular + Java Springboot into Azure app service using Azure Release Pipeline ?
Hi everyone. Good morning/evening.
We are working on developing a new POC application & need some help with the Azure CI/CD pipeline. Our application is based on frontend as angular & backend as java springboot. We were able to run the build pipeline successfully and publish the artifacts to JFrog artifactory. However, the next challenge we have is how to deploy it to an Azure App Service.
Our frontend is running on Angular 16 and backend is java springboot. We have 2 separate artifacts, frontend is generating a dist folder wrapped with tar.gz file & backend is generating a jar file. How can we deploy this together into an Azure App Service using azure devops release pipeline?
Hi everyone. Good morning/evening.We are working on developing a new POC application & need some help with the Azure CI/CD pipeline. Our application is based on frontend as angular & backend as java springboot. We were able to run the build pipeline successfully and publish the artifacts to JFrog artifactory. However, the next challenge we have is how to deploy it to an Azure App Service. Our frontend is running on Angular 16 and backend is java springboot. We have 2 separate artifacts, frontend is generating a dist folder wrapped with tar.gz file & backend is generating a jar file. How can we deploy this together into an Azure App Service using azure devops release pipeline? Read More
Not able to integrate ai multi service
HI am having just the hardest time trying to integrate the Azure AI multi-service in to any sort of copilot (teams, copilot studio, 365 in ms 365 app or teams app or outlooks app, or any copilot. It seems impossible to get this in to a copilot or any ai bot. Any help at all? With at least services like Decision, L, S, V and DI. or – at least least – V, L, DI. Thanks! Matt
HI am having just the hardest time trying to integrate the Azure AI multi-service in to any sort of copilot (teams, copilot studio, 365 in ms 365 app or teams app or outlooks app, or any copilot. It seems impossible to get this in to a copilot or any ai bot. Any help at all? With at least services like Decision, L, S, V and DI. or – at least least – V, L, DI. Thanks! Matt Read More
“Organize mail by thread” for Outlook for Mac
Hello, when do you think we can expect the “Organize mail by thread” feature for Outlook for Mac?
Hello, when do you think we can expect the “Organize mail by thread” feature for Outlook for Mac? Read More
Can anyone record me an easy to use Windows screen recorder?
Sometimes I need to record tutorial videos on my computer for our customers. I search and found that Xbox game bar is a good option. I use it, it did capture my screen. However, it failed to record popup from the software and did not capture all my operations.
Can anyone record me a simple screen recorder for PC? It should allow me to:
Record part of my screenRecord app and file explorer Record screen and webcam at the same timeCapture screen in high resolution
I really need to have such a screen recorder for my work. Thanks!
Please don’t record me OBS studio. I downloaded the open-source app and used it. Sorry, it is so hard for me to record selected area of my screen. It seems that I need to input the distance by pixels.
Sometimes I need to record tutorial videos on my computer for our customers. I search and found that Xbox game bar is a good option. I use it, it did capture my screen. However, it failed to record popup from the software and did not capture all my operations. Can anyone record me a simple screen recorder for PC? It should allow me to: Record part of my screenRecord app and file explorer Record screen and webcam at the same timeCapture screen in high resolution I really need to have such a screen recorder for my work. Thanks!Please don’t record me OBS studio. I downloaded the open-source app and used it. Sorry, it is so hard for me to record selected area of my screen. It seems that I need to input the distance by pixels. Read More
Project Online – Project Owner is changing to old owner automatically.
In project online the owner of project keeps changing to previous(old) owner automatically. Even if we change it back to new owner after some days it will revert back to old owner. Can anyone help me solving this issue.
In project online the owner of project keeps changing to previous(old) owner automatically. Even if we change it back to new owner after some days it will revert back to old owner. Can anyone help me solving this issue. Read More
Windows Login MFA via Intune
Dear Experts,
Does Microsoft support MFA on windows login via Intune?
I know there are third party tools for this but can we enforce windows login MFA via Intune?
Dear Experts,Does Microsoft support MFA on windows login via Intune?I know there are third party tools for this but can we enforce windows login MFA via Intune? Read More
Create Your First Visual Agent Using AOAI and AI Search – Search Product Catalog Images
Search Product Catalog Images Using Azure Search and OpenAI with Langchain
In the ever-evolving landscape of retail, businesses are continually seeking innovative solutions to streamline their operations and enhance customer experiences. One such breakthrough is the implementation of artificial intelligence (AI) to search product catalog images efficiently. This transformative technology not only simplifies the search process but also empowers businesses to provide personalized and seamless shopping experiences for their customers.
The Need for AI in Product Catalog Image Search: Traditional methods of searching through product catalogs involve manual tagging and categorization, which can be time-consuming and prone to human error. As the volume of products in a catalog grows, managing and searching for specific items becomes a daunting task. AI, particularly computer vision, addresses these challenges by automating the recognition and categorization of products in images.
Key Features of AI-Powered Product Catalog Image Search:
Object Recognition and Tagging: AI algorithms can identify and tag objects within images, providing accurate and consistent categorization of products. This reduces the reliance on manual tagging, ensuring that products are correctly labeled in the catalog.
Visual Similarity Search: AI enables visual similarity search, allowing users to find products based on visual attributes rather than relying solely on text-based queries. This feature is especially valuable for customers who may struggle to describe a product in words but can easily recognize it visually.
Enhanced Product Discovery: By understanding the visual characteristics of products, AI facilitates a more sophisticated recommendation system. Customers can discover related or complementary items, leading to increased cross-selling opportunities and a more engaging shopping experience.
Improved Accuracy and Efficiency: AI-powered image recognition is highly accurate and can process large volumes of images in a fraction of the time it would take a human. This efficiency not only reduces operational costs but also enhances the speed at which customers can find and purchase products.
Integration with E-Commerce Platforms: AI-driven image search can seamlessly integrate with existing e-commerce platforms, making it easy for businesses to adopt this technology without major disruptions. This integration allows for a smoother transition and ensures that the AI-enhanced search becomes an integral part of the overall shopping experience.
Now lets try to implement this with Azure OpenAI.
Firs you need to import some libraries
import azure.cognitiveservices.speech as speechsdk
import datetime
import io
import json
import math
import matplotlib.pyplot as plt
import numpy as np
import openai
import os
import random
import requests
import sys
import time
from azure.core.credentials import AzureKeyCredential
from azure.search.documents import SearchClient
from azure.search.documents.indexes import SearchIndexClient
from azure.search.documents.indexes import SearchIndexerClient
from azure.search.documents.indexes.models import (
SearchIndexerDataContainer,
SearchIndexerDataSourceConnection,
)
from azure.storage.blob import BlobServiceClient, generate_blob_sas, BlobSasPermissions
from azure.cognitiveservices.speech import (
AudioDataStream,
SpeechConfig,
SpeechSynthesizer,
SpeechSynthesisOutputFormat,
)
from azure.cognitiveservices.speech.audio import AudioOutputConfig
from azure.search.documents.models import VectorizedQuery,VectorizableTextQuery
from dotenv import load_dotenv
from io import BytesIO
from IPython.display import Audio
from PIL import Image
import os
import base64
import re
from datetime import datetime, timedelta
import requests
import os
from tenacity import (
Retrying,
retry_if_exception_type,
wait_random_exponential,
stop_after_attempt
)
import json
import mimetypes
Initiate some environmental variable for your
Azure OpenAI Endpoint
Azure Cognitive Service End point
Azure Search End point
load_dotenv(“azure.env”)
# Azure Open AI
openai_api_type = os.getenv(“azure”)
openai_api_base = os.getenv(“AZURE_OPENAI_ENDPOINT”)
openai_api_version = os.getenv(“AZURE_API_VERSION”)
openai_api_key = os.getenv(“AZURE_OPENAI_KEY”)
# Azure Cognitive Search
acs_endpoint = os.getenv(“ACS_ENDPOINT”)
acs_key = os.getenv(“ACS_KEY”)
# Azure Computer Vision 4
acv_key = os.getenv(“ACV_KEY”)
acv_endpoint = os.getenv(“ACV_ENDPOINT”)
blob_connection_string = os.getenv(“BLOB_CONNECTION_STRING”)
container_name = os.getenv(“CONTAINER_NAME”)
# Azure Cognitive Search index name to create
index_name = “azure-fashion-demo”
# Azure Cognitive Search api version
api_version = “2023-02-01-preview”
Now lets create a function to create text embedding using vision API
def text_embedding(prompt):
“””
Text embedding using Azure Computer Vision 4.0
“””
version = “?api-version=” + api_version + “&modelVersion=latest”
vec_txt_url = f”{acv_endpoint}/computervision/retrieval:vectorizeText{version}”
headers = {“Content-type”: “application/json”, “Ocp-Apim-Subscription-Key”: acv_key}
payload = {“text”: prompt}
response = requests.post(vec_txt_url, json=payload, headers=headers)
if response.status_code == 200:
text_emb = response.json().get(“vector”)
return text_emb
else:
print(f”Error: {response.status_code} – {response.text}”)
return None
Lets Now lets create a function to create Image embedding using vision API
def image_embedding(image_path):
url = f”{acv_endpoint}/computervision/retrieval:vectorizeImage”
mime_type, _ = mimetypes.guess_type(image_path)
headers = {
“Content-Type”: mime_type,
“Ocp-Apim-Subscription-Key”: acv_key
}
for attempt in Retrying(
retry=retry_if_exception_type(requests.HTTPError),
wait=wait_random_exponential(min=15, max=60),
stop=stop_after_attempt(15)
):
with attempt:
with open(image_path, ‘rb’) as image_data:
response = requests.post(url, params=params, headers=headers, data=image_data)
if response.status_code != 200:
response.raise_for_status()
vector = response.json()[“vector”]
return vector
Next thing we require is to create a function which takes a text prompt as input and search Azure Search for most relevant images. Here Buy Now Link is a dummy link which can be replaced with actual product URL
def prompt_search(prompt, topn=5, disp=False):
“””
Azure Cognitive visual search using a prompt
“””
results_list = []
# Initialize the Azure Cognitive Search client
search_client = SearchClient(acs_endpoint, index_name, AzureKeyCredential(acs_key))
blob_service_client = BlobServiceClient.from_connection_string(blob_connection_string)
container_client = blob_service_client.get_container_client(container_name)
# Perform vector search
vector_query = VectorizedQuery(vector=text_embedding(prompt), k_nearest_neighbors=topn, fields=”image_vector”)
response = search_client.search(
search_text=prompt, vector_queries= [vector_query], select=[“description”], top = 2
)
for nb, result in enumerate(response, 1):
blob_name = result[“description”] + “.jpg”
blob_client = container_client.get_blob_client(blob_name)
image_url = blob_client.url
sas_token = generate_blob_sas(
blob_service_client.account_name,
container_name,
blob_name,
account_key=blob_client.credential.account_key,
permission=BlobSasPermissions(read=True),
expiry=datetime.utcnow() + timedelta(hours=1)
)
sas_url = blob_client.url + “?” + sas_token
results_list.append({“buy_now_link” : sas_url,”price_of_the_product”: result[“description”], “product_image_url”: sas_url})
return results_list
Lets ingest some Product Images to the Azure Search. Here we are basically the idea is we have folder called images having all the product images stored. We are basically creating a container and uploading all the images from the folder to the specific container.
EMBEDDINGS_DIR = “embeddings”
os.makedirs(EMBEDDINGS_DIR, exist_ok=True)
image_directory = os.path.join(‘images’)
embedding_directory = os.path.join(’embeddings’)
output_json_file = os.path.join(embedding_directory, ‘output.jsonl’)
for root, dirs, files in os.walk(image_directory):
for file in files:
local_file_path = os.path.join(root, file)
blob_name = os.path.relpath(local_file_path, image_directory)
with open(local_file_path, “rb”) as data:
blob_client.upload_blob(data, overwrite=True)
Next we will create the embedding of the product images and store the same locally in the embedding directory. Point to note is that we have used only 2 metadata id and description. You can basically extend to many more metadata like price, buy now link etc.
with open(output_json_file, ‘w’) as outfile:
for idx, image_path in enumerate(os.listdir(image_directory)):
if image_path:
try:
vector = image_embedding(os.path.join(image_directory, image_path))
except Exception as e:
print(f”Error processing image at index {idx}: {e}”)
vector = None
filename, _ = os.path.splitext(os.path.basename(image_path))
result = {
“id”: f'{idx}’,
“image_vector”: vector,
“description”: filename
}
outfile.write(json.dumps(result))
outfile.write(‘n’)
outfile.flush()
print(f”Results are saved to {output_json_file}”)
Now since have created the local embedding file , we can upload the same into a Azure Search. Before that lets create an index .
from azure.search.documents.indexes import SearchIndexClient
from azure.search.documents.indexes.models import (
SimpleField,
SearchField,
SearchFieldDataType,
VectorSearch,
HnswAlgorithmConfiguration,
VectorSearchProfile,
SearchIndex
)
credential = AzureKeyCredential(acs_key)
# Create a search index
index_client = SearchIndexClient(endpoint=acs_endpoint, credential=credential)
fields = [
SimpleField(name=”id”, type=SearchFieldDataType.String, key=True),
SearchField(name=”description”, type=SearchFieldDataType.String, sortable=True, filterable=True, facetable=True),
SearchField(
name=”image_vector”,
hidden=True,
type=SearchFieldDataType.Collection(SearchFieldDataType.Single),
searchable=True,
vector_search_dimensions=1024,
vector_search_profile_name=”myHnswProfile”
),
]
# Configure the vector search configuration
vector_search = VectorSearch(
algorithms=[
HnswAlgorithmConfiguration(
name=”myHnsw”
)
],
profiles=[
VectorSearchProfile(
name=”myHnswProfile”,
algorithm_configuration_name=”myHnsw”,
)
],
)
# Create the search index with the vector search configuration
index = SearchIndex(name=index_name, fields=fields, vector_search=vector_search)
result = index_client.create_or_update_index(index)
print(f”{result.name} created”)
Once you have created the index , you can upload the locally stored index file.
from azure.search.documents import SearchClient
import json
data = []
with open(output_json_file, ‘r’) as file:
for line in file:
# Remove leading/trailing whitespace and parse JSON
json_data = json.loads(line.strip())
data.append(json_data)
search_client = SearchClient(endpoint=acs_endpoint, index_name=index_name, credential=credential)
results = search_client.upload_documents(data)
for result in results:
print(f’Indexed {result.key} with status code {result.status_code}’)
Congratulations you have finally ready to implement your Agent using OpenAI
Lets create tool called image search which will be used by the Agent
from typing import Optional
from langchain_core.callbacks import CallbackManagerForToolRun
from langchain_core.tools import BaseTool
from util import prompt_search
class ImageSearchResults(BaseTool):
“””Tool that queries the Fashion Image Search API and gets back json.”””
name: str = “image_search_results_json”
description: str = (
“A wrapper around Image Search. “
“Useful for when you need search fashion images related to cloth , shoe etc”
“Input should be a search query. Output is a JSON array of the query results”
)
num_results: int = 4
def _run(
self,
query: str,
run_manager: Optional[CallbackManagerForToolRun] = None,
) -> str:
“””Use the tool.”””
return str(prompt_search(prompt = query, topn=self.num_results))
Here we will be using Langchain to implement our Fashion Agent called Luca
from langchain_core.prompts.chat import (
BaseMessagePromptTemplate,
ChatPromptTemplate,
HumanMessagePromptTemplate,
MessagesPlaceholder,
SystemMessagePromptTemplate,
PromptTemplate,
)
from langchain_core.messages import AIMessage, HumanMessage, SystemMessage
from langchain_core.runnables import Runnable, RunnablePassthrough
from langchain_community.tools.convert_to_openai import format_tool_to_openai_function
from langchain_core.utils.function_calling import convert_to_openai_function
from langchain.agents.output_parsers.openai_functions import (
OpenAIFunctionsAgentOutputParser,
)
from langchain.agents.format_scratchpad.openai_functions import (
format_to_openai_function_messages,
)
from langchain.agents import AgentExecutor
from langchain_openai import AzureChatOpenAI
from langchain_core.runnables import RunnableConfig
from custom_tool import ImageSearchResults
import openai
Lets initialize our LLM
from langchain_openai import AzureChatOpenAI
llm = AzureChatOpenAI(
api_key=os.environ[“AZURE_OPENAI_KEY”],
api_version=”2023-12-01-preview”,
azure_endpoint=os.environ[“AZURE_OPENAI_ENDPOINT”],
model=”gpt-4-turbo”,
)
llm(messages=[HumanMessage(content = “Hi”)])
prefix=”””You are Luca a helpful Fashion Agent who help people navigating and buying products online
Note:
\ Show Prices always in INR
\ Always try user to buy from the buy now link provided”””
suffix = “”
Lets attach tool we created, here we are using LCEL to implement out agent
tools = [ImageSearchResults(num_results=5)]
llm_with_tools = llm.bind(
functions=[convert_to_openai_function(t) for t in tools]
)
messages = [
SystemMessage(content=prefix),
HumanMessagePromptTemplate.from_template(“{input}”),
AIMessage(content=suffix),
MessagesPlaceholder(variable_name=”agent_scratchpad”),
]
input_variables = [“input”, “agent_scratchpad”]
prompt = ChatPromptTemplate(input_variables=input_variables, messages=messages)
agent = (
RunnablePassthrough.assign(
agent_scratchpad=lambda x: format_to_openai_function_messages(
x[“intermediate_steps”]
)
)
| prompt
| llm_with_tools
| OpenAIFunctionsAgentOutputParser()
)
Congratulation !! You are ready to test your Agent
response = agent_executor.invoke(
{
“input”: “I am looking for some summer dress as I am travelling to new Delhi”,
“chat_history”: [
HumanMessage(content=”hi! my name is bob”),
AIMessage(content=”Hello Bob! How can I assist you today?”),
],
}
)
Hurray !! You are now ready to deploy this Agent to a Enterprise App with some good looking UI.
Here is the reference github repo with all the code artifact.
https://github.com/monuminu/AOAI_Samples/tree/main/content_product_tagging
Favor : Please clap if you like this and Follow me for more such content.
References:
Microsoft Tech Community – Latest Blogs –Read More