Tag Archives: microsoft
How to fix QuickBooks desktop 2023 keeps crashing after update?
Troubleshooting Solutions : QuickBooks desktop 2023 keeps crashing
Experiencing frequent QuickBooks desktop 2023 keeps crashing can be frustrating and disrupt your workflow. However, several troubleshooting steps can help identify and resolve the underlying issues causing these crashes.
1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop 2023 installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.
2. Verify System Requirements: Confirm that your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware or outdated software can lead to performance issues and crashes. Visit the QuickBooks support website to review the system requirements for your version.
3. Run QuickBooks Diagnostic Tool: QuickBooks comes with a built-in diagnostic tool that can help identify and fix common issues. Run the QuickBooks Install Diagnostic Tool, which automatically scans and repairs problems related to installation, .NET Framework, MSXML, and C++. Download and run the tool from the Intuit website for best results.
4. Disable Compatibility Mode: Compatibility mode settings can sometimes conflict with QuickBooks Desktop and cause crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.
5. Verify Company File: A corrupted company file can lead to frequent crashes in QuickBooks Desktop. Use the Verify Data utility to check for data integrity issues and resolve them. Go to the File menu, select Utilities, and then Verify Data. Follow the on-screen instructions to repair any detected issues.
6. Rebuild Data: If the Verify Data utility detects problems with your company file, use the Rebuild Data tool to fix them. This tool reconstructs the damaged data, resolving issues that could cause QuickBooks Desktop to crash. Go to the File menu, select Utilities, and then Rebuild Data. Follow the prompts to complete the process.
7. Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks Desktop and cause it to crash. Temporarily disable any add-ons or extensions and check if the crashing issue persists. If the software runs smoothly without them, consider updating or reinstalling the problematic add-ons.
8. Clean Install QuickBooks Desktop: If all else fails, perform a clean install of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Make sure to backup your company file before proceeding with the reinstall.
By following these troubleshooting solutions, you can effectively address the QuickBooks desktop 2023 keeps crashing issue and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for further assistance.
Troubleshooting Solutions : QuickBooks desktop 2023 keeps crashing Experiencing frequent QuickBooks desktop 2023 keeps crashing can be frustrating and disrupt your workflow. However, several troubleshooting steps can help identify and resolve the underlying issues causing these crashes. 1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop 2023 installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.2. Verify System Requirements: Confirm that your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware or outdated software can lead to performance issues and crashes. Visit the QuickBooks support website to review the system requirements for your version.3. Run QuickBooks Diagnostic Tool: QuickBooks comes with a built-in diagnostic tool that can help identify and fix common issues. Run the QuickBooks Install Diagnostic Tool, which automatically scans and repairs problems related to installation, .NET Framework, MSXML, and C++. Download and run the tool from the Intuit website for best results.4. Disable Compatibility Mode: Compatibility mode settings can sometimes conflict with QuickBooks Desktop and cause crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.5. Verify Company File: A corrupted company file can lead to frequent crashes in QuickBooks Desktop. Use the Verify Data utility to check for data integrity issues and resolve them. Go to the File menu, select Utilities, and then Verify Data. Follow the on-screen instructions to repair any detected issues.6. Rebuild Data: If the Verify Data utility detects problems with your company file, use the Rebuild Data tool to fix them. This tool reconstructs the damaged data, resolving issues that could cause QuickBooks Desktop to crash. Go to the File menu, select Utilities, and then Rebuild Data. Follow the prompts to complete the process.7. Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks Desktop and cause it to crash. Temporarily disable any add-ons or extensions and check if the crashing issue persists. If the software runs smoothly without them, consider updating or reinstalling the problematic add-ons.8. Clean Install QuickBooks Desktop: If all else fails, perform a clean install of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Make sure to backup your company file before proceeding with the reinstall. By following these troubleshooting solutions, you can effectively address the QuickBooks desktop 2023 keeps crashing issue and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for further assistance. Read More
How to fix QuickBooks desktop 2023 keeps shutting down after update?
Troubleshooting Solutions : QuickBooks desktop 2023 keeps shutting down
Experiencing frequent QuickBooks desktop 2023 keeps shutting down can be frustrating and hinder your productivity. However, several troubleshooting steps can help identify and resolve the underlying issues causing these shutdowns.
1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop 2023 installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.
2. Verify System Requirements: Check if your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware or outdated software can lead to performance issues and unexpected shutdowns. Refer to the QuickBooks support website to review the system requirements for your version.
3. Inspect Event Viewer Logs: Review the Event Viewer logs on your computer to identify any system errors or warnings related to QuickBooks Desktop shutdowns. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for critical or error events under Windows Logs > Application.
4. Disable Antivirus or Security Software: Occasionally, antivirus or security software can mistakenly flag QuickBooks Desktop processes as threats, leading to unexpected shutdowns. Temporarily disable your antivirus or security software and check if the issue persists. If the shutdowns stop, add QuickBooks Desktop to the software’s exceptions list.
5. Clean Company File: A corrupted or damaged company file can cause QuickBooks Desktop to shut down unexpectedly. Use the Verify Data utility to check for data integrity issues and the Rebuild Data tool to fix them. Navigate to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.
6. Check for Data Damage: Utilize the File Doctor tool, a built-in feature of QuickBooks Desktop, to diagnose and repair data damage that may be causing the shutdowns. Download and run the File Doctor tool from the QuickBooks Tool Hub, available on the Intuit website. Follow the on-screen instructions to scan and repair your company file.
7. Reinstall QuickBooks Desktop: If none of the above solutions resolve the issue, consider performing a clean reinstall of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling.
8. Contact QuickBooks Support: If you’re still experiencing shutdowns after trying the troubleshooting steps, reach out to QuickBooks support for further assistance. They can provide personalized guidance and additional troubleshooting steps to effectively address the issue.
By following these troubleshooting solutions, you can identify and resolve the underlying issues QuickBooks desktop 2023 keeps shutting down unexpectedly. Restoring stability to your accounting software will help minimize disruptions and ensure smooth workflow continuity.
Troubleshooting Solutions : QuickBooks desktop 2023 keeps shutting down Experiencing frequent QuickBooks desktop 2023 keeps shutting down can be frustrating and hinder your productivity. However, several troubleshooting steps can help identify and resolve the underlying issues causing these shutdowns. 1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop 2023 installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.2. Verify System Requirements: Check if your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware or outdated software can lead to performance issues and unexpected shutdowns. Refer to the QuickBooks support website to review the system requirements for your version.3. Inspect Event Viewer Logs: Review the Event Viewer logs on your computer to identify any system errors or warnings related to QuickBooks Desktop shutdowns. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for critical or error events under Windows Logs > Application.4. Disable Antivirus or Security Software: Occasionally, antivirus or security software can mistakenly flag QuickBooks Desktop processes as threats, leading to unexpected shutdowns. Temporarily disable your antivirus or security software and check if the issue persists. If the shutdowns stop, add QuickBooks Desktop to the software’s exceptions list.5. Clean Company File: A corrupted or damaged company file can cause QuickBooks Desktop to shut down unexpectedly. Use the Verify Data utility to check for data integrity issues and the Rebuild Data tool to fix them. Navigate to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.6. Check for Data Damage: Utilize the File Doctor tool, a built-in feature of QuickBooks Desktop, to diagnose and repair data damage that may be causing the shutdowns. Download and run the File Doctor tool from the QuickBooks Tool Hub, available on the Intuit website. Follow the on-screen instructions to scan and repair your company file.7. Reinstall QuickBooks Desktop: If none of the above solutions resolve the issue, consider performing a clean reinstall of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling.8. Contact QuickBooks Support: If you’re still experiencing shutdowns after trying the troubleshooting steps, reach out to QuickBooks support for further assistance. They can provide personalized guidance and additional troubleshooting steps to effectively address the issue. By following these troubleshooting solutions, you can identify and resolve the underlying issues QuickBooks desktop 2023 keeps shutting down unexpectedly. Restoring stability to your accounting software will help minimize disruptions and ensure smooth workflow continuity. Read More
How do I fix QuickBooks Error H505 after update windows 11?
Troubleshooting Solutions: QuickBooks Error H505
QuickBooks Error H505 is a common issue that occurs when QuickBooks Desktop is unable to communicate with the company file on another computer. This error typically arises in multi-user mode and can be caused by various factors. Here are several troubleshooting steps to resolve Error H505:
Verify Hosting Settings: Ensure that hosting is turned on only on the computer where the company file is stored (the server). Open QuickBooks on the server computer, go to the File menu, select Utilities, and verify that the option “Host Multi-User Access” is enabled. Disable hosting on all other workstations.Check Firewall and Security Settings: Firewall or security software may be blocking communication between QuickBooks and the company file. Configure your firewall settings to allow QuickBooks through the firewall. You may need to create exceptions for QuickBooks programs and ports.Update QuickBooks and QuickBooks Database Server Manager: Ensure that both QuickBooks Desktop and QuickBooks Database Server Manager are updated to the latest versions. QuickBooks frequently releases updates to address compatibility issues and improve performance. Update both the server and workstation installations.Use QuickBooks Connection Diagnostic Tool: QuickBooks Connection Diagnostic Tool can help diagnose and fix connectivity issues between QuickBooks and the company file. Download and run the tool on the computer hosting the company file. Follow the on-screen instructions to diagnose and repair network issues.Edit Hosts File: Edit the hosts file on each workstation to include the IP address and computer name of the server hosting the company file. The hosts file is located in the following directory: C:WindowsSystem32driversetc. Add an entry for the server’s IP address and computer name, then save the changes.Switch to Multi-User Mode: If you’re encountering Error H505 while in single-user mode, try switching to multi-user mode. Close QuickBooks, reopen it, and select File > Switch to Multi-User Mode. This can sometimes reset network configurations and resolve connectivity issues.Restart QuickBooks Services: Restart the QuickBooksDB and QBCFMonitorService services on the server computer. Press Win + R to open the Run dialog, type services.msc, and press Enter. Locate QuickBooksDBXX and QBCFMonitorService in the list, right-click each service, and select Restart.Create a New Folder for Company File: Create a new folder on the server computer and move the company file (.qbw) into it. Then, use QuickBooks to open the company file from the new location. This can sometimes resolve file path or permission issues causing Error H505.Contact QuickBooks Support: If you’re unable to resolve Error H505 using the above steps, contact QuickBooks support for further assistance. They can provide advanced troubleshooting guidance and may be able to help diagnose and fix the issue remotely.
By following these troubleshooting steps, you should be able to resolve QuickBooks Error H505 and regain access to your company file in multi-user mode. Remember to regularly update QuickBooks and perform routine maintenance to prevent similar issues in the future.
Troubleshooting Solutions: QuickBooks Error H505 QuickBooks Error H505 is a common issue that occurs when QuickBooks Desktop is unable to communicate with the company file on another computer. This error typically arises in multi-user mode and can be caused by various factors. Here are several troubleshooting steps to resolve Error H505: Verify Hosting Settings: Ensure that hosting is turned on only on the computer where the company file is stored (the server). Open QuickBooks on the server computer, go to the File menu, select Utilities, and verify that the option “Host Multi-User Access” is enabled. Disable hosting on all other workstations.Check Firewall and Security Settings: Firewall or security software may be blocking communication between QuickBooks and the company file. Configure your firewall settings to allow QuickBooks through the firewall. You may need to create exceptions for QuickBooks programs and ports.Update QuickBooks and QuickBooks Database Server Manager: Ensure that both QuickBooks Desktop and QuickBooks Database Server Manager are updated to the latest versions. QuickBooks frequently releases updates to address compatibility issues and improve performance. Update both the server and workstation installations.Use QuickBooks Connection Diagnostic Tool: QuickBooks Connection Diagnostic Tool can help diagnose and fix connectivity issues between QuickBooks and the company file. Download and run the tool on the computer hosting the company file. Follow the on-screen instructions to diagnose and repair network issues.Edit Hosts File: Edit the hosts file on each workstation to include the IP address and computer name of the server hosting the company file. The hosts file is located in the following directory: C:WindowsSystem32driversetc. Add an entry for the server’s IP address and computer name, then save the changes.Switch to Multi-User Mode: If you’re encountering Error H505 while in single-user mode, try switching to multi-user mode. Close QuickBooks, reopen it, and select File > Switch to Multi-User Mode. This can sometimes reset network configurations and resolve connectivity issues.Restart QuickBooks Services: Restart the QuickBooksDB and QBCFMonitorService services on the server computer. Press Win + R to open the Run dialog, type services.msc, and press Enter. Locate QuickBooksDBXX and QBCFMonitorService in the list, right-click each service, and select Restart.Create a New Folder for Company File: Create a new folder on the server computer and move the company file (.qbw) into it. Then, use QuickBooks to open the company file from the new location. This can sometimes resolve file path or permission issues causing Error H505.Contact QuickBooks Support: If you’re unable to resolve Error H505 using the above steps, contact QuickBooks support for further assistance. They can provide advanced troubleshooting guidance and may be able to help diagnose and fix the issue remotely. By following these troubleshooting steps, you should be able to resolve QuickBooks Error H505 and regain access to your company file in multi-user mode. Remember to regularly update QuickBooks and perform routine maintenance to prevent similar issues in the future. Read More
ÐLP and Microsoft Defender
Hello, I recently got a false positive DLP :warning: alert and I went to Microsoft Defender to classify as false positive and got resolved.
Now the problem is when I go to DLP portal I still see the alert active.
Is this normal?
Hello, I recently got a false positive DLP :warning: alert and I went to Microsoft Defender to classify as false positive and got resolved.Now the problem is when I go to DLP portal I still see the alert active. Is this normal? Read More
Startups Assemble Virtual Conference Recap
Startups Assemble Virtual Conference Recap
Event Highlight: Panel Session
Event Highlight: Startup Showcase
Event Highlight: Founders’ Hub
Join Microsoft for Startups Founders’ Hub today!
Microsoft Tech Community – Latest Blogs –Read More
Hide Class template in Microsoft Teams
Hello,
Our tenant is an education-tenant, where we have Academic A1 and A5-licenses.
When our users are creating a new team in Teams they are met with this view:
Is it possible to hide the templates connected to education, such as “Class”, “Professional learning..”, “Staff” and “Other” from the view when a user is to create a Team? Only a basic template would be needed.
As far as I can see, you can add/hide other templates via the Admin Centre, but not specifically the core templates such as “Class”. Is there a way to do this?
Hello, Our tenant is an education-tenant, where we have Academic A1 and A5-licenses. When our users are creating a new team in Teams they are met with this view:Is it possible to hide the templates connected to education, such as “Class”, “Professional learning..”, “Staff” and “Other” from the view when a user is to create a Team? Only a basic template would be needed. As far as I can see, you can add/hide other templates via the Admin Centre, but not specifically the core templates such as “Class”. Is there a way to do this? Read More
エクセル画面が縮小してしまう
コントロールキーを押すと勝手に縮小してしまい、ショートカットが使えず困っています。
古い記事ではマウスが鯨飲とのことでしたが、マウスの電源を切っても変わらず縮小してしまいます。
解決方法をご指示ください。
コントロールキーを押すと勝手に縮小してしまい、ショートカットが使えず困っています。古い記事ではマウスが鯨飲とのことでしたが、マウスの電源を切っても変わらず縮小してしまいます。解決方法をご指示ください。 Read More
AI Semantic Search for Your Website with Azure Cosmos DB | E-commerce
Build low-latency recommendation engines with Azure Cosmos DB and OpenAI. Elevate user experience with vector-based semantic search, going beyond traditional keyword limitations to deliver personalized recommendations in real-time. With pre-trained models stored in Cosmos DB, tailor product predictions based on user interactions and preferences. Explore the power of augmented vector search for optimized results prioritized by relevance.
Kirill Gavrylyuk, Azure Cosmos DB General Manager, shows how to build recommendation systems with limitless scalability, leveraging pre-computed vectors and collaborative filtering for next-level, real-time insights.
Build low-latency recommendation engines.
Use Azure Cosmos DB and Azure OpenAI Service, and get started.
Elevate search functionality with vector-based semantic search.
Discover relevant items with user intent. Check it out.
Personalized product predictions
Generate predictions based on user and product interactions. See how it works in Azure Cosmos DB.
Watch our video here:
QUICK LINKS:
00:00 — Build a low latency recommendation engine
00:59 — Keyword search
01:46 — Vector-based semantic search
02:39 — Vector search built-in to Cosmos DB
03:56 — Model training
05:18 — Code for product predictions
06:02 — Test code for product prediction
06:39 — Augmented vector search
08:23 — Test code for augmented vector search
09:16 — Wrap up
Link References
Walk through an example at https://aka.ms/CosmosDBvectorSample
Try out Cosmos DB for MongoDB for free at https://aka.ms/TryC4M
Unfamiliar with Microsoft Mechanics?
As Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
Keep getting this insider knowledge, join us on social:
Follow us on Twitter: https://twitter.com/MSFTMechanics
Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Video Transcript:
-Imagine finding your next purchase just by describing what you want to do, using natural language, with results returned in real-time, like asking for everything you’ll need to climb Mount Kilimanjaro that links directly to the appropriate items in your catalog to return the results for you to consider in just a matter of milliseconds, along with a just-in-time recommendation for items you are statistically likely to purchase.
-Now, as a developer, building a next-level and low-latency recommendation engine for distributed apps like this is not as difficult as you may think: We’ll use a combination of the vCore-based Azure Cosmos DB for MongoDB along with Azure OpenAI to generate vector embeddings and Cosmos DB’s built-in vector search for super fast similarity lookups over conversational data.
-And we’ll use a popular collaborative filtering model, Alternating Least Squares, ALS, in PySpark for learned and predictive recommendations. To show you what’s possible, let’s first look at the experience without AI and Vector Search. This is our e-commerce website, specializing in winter outdoor sports equipment.
-I’ll start with a classic text-based keyword search and type snowboards here in our text box and press Enter. And as you’d expect, I get a results page with a few snowboards. But what if I don’t know exactly what I want? Or maybe I want something very specific that is not in our keyword index.
-This time, I’ll try something different. I’ll type, “I want to snowboard like an Olympic champion.” And as you can see, this yields zero results. As you’ve probably experienced, keyword search works well when words or text strings are found in a database or search index, but it cannot apply semantic meaning.
-Let me now show you the difference with vector-based semantic search. I’ll type the same query as before, “I want to snowboard like an Olympic champion.” And here you can see I get a page of results. The very first result is a Shaun White snowboard from the three-time Olympic champion.
-In this case, we’re combining the power of our predictive recommendation model, ALS, along with the results from Cosmos DB’s built-in vector search, and Azure OpenAI GPT-4 for personalization of the response. And to keep me engaged and to stop me from clicking away, if I click on the Shaun White snowboard here, I’m also presented with a list of other products that I might like based on my preferences, my location, similarity between items, and user ratings. More on that in a moment.
-And as you saw, this happens in real time without delays that could make me hit the back button. Speed and relevance of results is important here, which is why Cosmos DB with its single digit millisecond latency and built-in vector search for semantic similarity is such an advantage. Let me explain how it works.
-First on the backend, for data in your database, we use a helper function that calls Azure OpenAI’s text embedding 3 model to automatically generate vector embeddings in real time as data is ingested into Cosmos DB. Think of embeddings as a coordinate-like way to refer to chunks of data in your database. And later, those are used for lookups.
-Then in the app frontend, when a user performs a search, their search string is also converted to a vector embedding by Azure OpenAI, and the lookup will try to find the dimensionally closest matches between the search string embedding and the embeddings in the product database. We then use the ALS model that has been trained on data, including the user’s purchase history, products entries in the database, and their ratings to re-rank the results by likelihood of purchase with collaborative filtering.
-This is then presented to the Azure OpenAI GPT-4 arge language model to generate a conversational response. And because vector search is built-in to Azure Cosmos DB, you don’t have to move the data to a separate vector database. Let me show you the steps to build this recommendation engine, first by looking at model training.
-This is where you’ll want to do the predictions ahead of time; store them in Cosmos DB and use them for real-time personalized recommendations. We’ll use the ALS model from the PySpark package to make our recommendations Now we’ll skip over some of the configuration setup and get right into the model. We’ve split the data so 80% was used to train the model, and 20% was used to evaluate how well it performs.
-And then we created an ALS model and configured it to train multiple different models so we could choose the one with the best parameters. The training itself takes a while, so we skipped that here to have a fully trained model. Now we’ve picked the best model and see that it has a root mean square error of 0.64. This means that, on average, we would expect it to be about 0.64 off the predicted rating, which in our case ends up being less than 10%. Not too bad.
-Then we used the model to make predictions for all of our users, and all of the products they have not rated before, and saved those to Cosmos DB. This way when we look up predictions for specific users, we can simply do a point read with the user ID to retrieve the predictions from Cosmos DB in under 10 milliseconds. Now, let’s look at the code for product predictions based on specific users and the products they’re viewing.
-This function takes the current user ID and the product ID from the product page that the user has opened and returns the user’s predicted products. The first step is to execute this point read for this user’s product predictions. Next, we need to remove the current product if it is one of the predicted products for this user. This is an important step as we don’t want to display a recommendation for the same product they’re actively looking at.
-Finally, we will fetch the product details to display to the user for each of the product predictions. And add the ratings for each product to the resulting list. Then return the list to the user. And now with the code complete for our function, let’s test it out. Here I have some values to feed into the function we’ve defined above.
-This includes user_id, product_id for the Shaun White snowboard we saw earlier, and we’ll return 10 results just so you can see a more complete list. Let’s run the function. And here you can see the recommended products. Notice the ratings on the right-hand side are in descending order. The higher the rating, the stronger the prediction If you remember, this list is what we saw on the right side of the screen when we clicked on the Shaun White snowboard.
-Now we’ll move on to our augmented vector search where we can again use these calculated predictions to improve the results based on what the user is most likely to buy. I’ll show what that code looks like. The first step is to generate vector embeddings from the user’s search text. Here we’re using our helper function to generate Azure OpenAI embeddings.
-Next, we execute a point read to grab all of the predicted products for the user. And this time, we’ll return every product so we can have a more complete set of results from our vector search. This is what we will use to perform our filtered vector search in Cosmos DB, so we’ll pass a list of product IDs to the $in operator for our vector query. Hybrid queries like this is an advantage of using a database with built-in vector search.
-Now it’s time for the vector search itself. This takes the array of embeddings from the user’s search and the filter criteria of predicted products. Then in my projection, I’ll return the entire product document, as well as the similarity score that I’ll show you in a minute. Next, after the vector search executes, I want to add in the prediction rating for that user to each product in my results. And our last step is to rank the results.
-As I mentioned, we want to return the top result from our vector search, which will have the highest similarity score. Then order the remaining results by the prediction rating for each of the remaining products. So I’ll remove the top vector search result, then sort the remaining results by their rating, then re-insert the top vector result back at the top of the list. And after all that, we can return the results to the user.
-With all the logic coded for our augmented semantic search to provide the best result for the user’s query and top-rated additional products, we can now test it out. I’ll use the same user_id I showed in the web app before, And I’ll also use the same text for the search we used earlier. Let’s run the cell. And notice how the top result is our Shaun White snowboard.
-This, of course, has the highest similarity score in our results. Coincidentally, it also has the highest rating too. The rest of the ratings are in descending order, but similarity scores are not. This is because of the sorting we did earlier to prioritize the order of the list based on rating as the highest prediction to buy, which is why these results are not all snowboards.
-And these are the results that we saw on the website when we enabled vector search. And with that, I’ve shown you the power of using pre-computed vectors in Azure Cosmos DB, combined with collaborative filtering and large language models for generative AI to help you build next-level, real-time recommendation systems of limitless scale.
-You can walk through this entire example yourself; we’ve published the eShop and our notebook on GitHub at aka.ms/CosmosDBvectorSample And you can try out Cosmos DB for MongoDB for free. Check out our quickstart at aka.ms/TryC4M. Keep watching Microsoft Mechanics for the latest updates. and thank you for watching!
Microsoft Tech Community – Latest Blogs –Read More
Liste déroulante
Bonjour Monsieur,
Je voulais savoir comment rechercher un élément dans une liste déroulante basée sur un tableau dans excel.
Merci pour la réponse
Bonjour Monsieur, Je voulais savoir comment rechercher un élément dans une liste déroulante basée sur un tableau dans excel. Merci pour la réponse Read More
Excel stepped formula
Hi,
I hope someone can assist me with a formula to apply to a large dataset. Volumes are currently both produced and sold simultaneously, with the price per hour fluctuating. The objective is to sell the volumes produced at the highest available price on the day that it gets produced. However, there is a limit to the volumes that can be sold on an hourly basis. Therefore, the formula should consider the daily volumes and aim to sell them at the highest prices available throughout the day.
Hi,I hope someone can assist me with a formula to apply to a large dataset. Volumes are currently both produced and sold simultaneously, with the price per hour fluctuating. The objective is to sell the volumes produced at the highest available price on the day that it gets produced. However, there is a limit to the volumes that can be sold on an hourly basis. Therefore, the formula should consider the daily volumes and aim to sell them at the highest prices available throughout the day. Read More
Tenant restricted from sending email
Hello
Please i need your help on this issue.
We have received alert that our email service has been barred “Tenant restricted from sending email”. Last night we had issue, and this might have contributed to large number of email alerts generated from platform. Could this service be restored at earliest.
Here is the error message of the email we received:
Then when trying to send an email i get this error message below:
Hello Please i need your help on this issue. We have received alert that our email service has been barred “Tenant restricted from sending email”. Last night we had issue, and this might have contributed to large number of email alerts generated from platform. Could this service be restored at earliest. Here is the error message of the email we received: Then when trying to send an email i get this error message below: Read More
Check and confirm a member of a DL received an email
Hello Microsoft Family,We have an important member reporting another VIP member of a DL not having received an important email sent to a DL.How do I know and where do I check, using which tool I should operate this search to 100% confirm the person received, or not at all received?And how do I know who all received and who all not receiving the email sent to a DL?I believe this same method of confirmation will apply to a mail sent to a Group, or Shared mailbox. If it’s not, how about checking for shared-mailbox, and group?Thank you in advance to all of you for taking your precious time to help me.Kind regardsVan Read More
What’s New in Excel (April 2024)
Welcome to the April 2024 update.
Generating multiple formula columns, creating complex formula columns that span across multiple tables, and new ways to engage with Copilot in Excel are now available to Excel users on web and Windows. Copying and pasting improvements and sharing links to sheet views are also available in Excel for the web, and the ink to text pen is rolling out to Insiders running Excel for Windows.
Excel for Web:
Generating multiple formula columns with Copilot in Excel
Creating complex formula columns that span multiple tables with Copilot in Excel
Copying and pasting Improvements #FIA
Sharing link to sheet views #FIA
Excel for Windows:
Generating multiple formula columns with Copilot in Excel
Creating complex formula columns that span multiple tables with Copilot in Excel
New ways to engage with Copilot in Excel
Ink to text pen (Insiders)
Excel for Web
1. Generating multiple formula columns with Copilot in Excel
Copilot in Excel now supports generating multiple formula columns from a single prompt. Ask one question, and Copilot can return two formula columns simultaneously. For instance, you can extract both the first name and last name from a single prompt, neatly separating the information into distinct columns. Read more here.
2. Creating complex formula columns that span multiple tables with Copilot in Excel
Additionally, now you can use Copilot to create complex formula columns that span across multiple tables, utilizing functions like XLOOKUP and SUMIF. This capability streamlines data processing and empowers you to handle more complex data analysis tasks efficiently, even when using multiple tables. Read more here.
#FIA
3. Copying and pasting improvements
Based on feedback we’ve received from many of you, we’ve made the following improvements to the copying and pasting experience:
Drag and Drop Enhancements: Provides a more seamless and intuitive way to manipulate data.
Autofill: Enables you to drag data to fill series, copy cells, and split data.
Paste options improvements: Allows you to choose the right paste option for your needs by right-clicking or accessing the auto-recovery paste options.
#FIA
4. Sharing link to sheet views
You can now share a link to a Sheet view that captures a subset of a workbook’s contents. This new capability can help you more efficiently collaborate on large, complex workbooks and more easily gather feedback and input from others. Read more here >
Excel for Windows
1. Generating multiple formula columns with Copilot in Excel
Copilot in Excel now supports generating multiple formula columns from a single prompt. Ask one question, and Copilot can return two formula columns simultaneously. For instance, you can extract both the first name and last name from a single prompt, neatly separating the information into distinct columns. Read more here.
2. Creating complex formula columns that span multiple tables with Copilot in Excel
Additionally, now you can use Copilot to create complex formula columns that span across multiple tables, utilizing functions like XLOOKUP and SUMIF. This capability streamlines data processing and empowers you to handle more complex data analysis tasks efficiently, even when using multiple tables. Read more here.
3. New ways to engage with Copilot in Excel
We’ve enhanced Copilot in Excel to make the experience even more seamless and efficient. Now, with Copilot in Excel, you can use the Microphone feature to prompt Copilot verbally, eliminating the need for manual typing. In addition, for fresh prompt ideas tailored to your specific data, now you can select the View Prompts icon to explore the Prompt Guide in the chat pane.. This feature is currently rolling out to Windows users. Read more here.
(Note: Copilot in Excel is currently in preview. Learn more about Copilot in Excel here.)
4. Ink to text pen (Insiders)
The Ink to Text Pen lets you use your digital pen (or stylus) to automatically convert your handwriting into text as you go, helping you quickly enter content into cells. Additionally, you can use pen gestures to select and delete cell content.
NOTE: The Ink to Text Pen replaces the functionality of the Action Pen in Excel.
Read more here >
Check if a specific feature is in your version of Excel
Click here to open in a new browser tab
Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—“Give a compliment” or “Make a suggestion”.. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.
Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month’s What’s New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel.
Microsoft Tech Community – Latest Blogs –Read More
Add MS Project to a channel in Teams
Hello
Please i need your help on this issue.
I am trying to add MS Project to a channel in Teams, I get an error that says “Looks like Project isn’t turned on for your organization. To use Project, contact your Office 365 admin.” But I just signed up for a trial of Project.
Hello Please i need your help on this issue. I am trying to add MS Project to a channel in Teams, I get an error that says “Looks like Project isn’t turned on for your organization. To use Project, contact your Office 365 admin.” But I just signed up for a trial of Project. Read More
How To Fix QuickBooks Multi-User Mode Problems : H202
QuickBooks is widely used for managing finances and accounting tasks in businesses, and its multi-user mode allows multiple users to work on the same company file simultaneously. However, users may encounter issues with the multi-user mode, such as QuickBooks Error H202. This error can disrupt collaboration and hinder productivity if not addressed promptly. In this article, we’ll explore what QuickBooks Error H202 signifies, examine its potential reasons, and provide detailed solutions to resolve it effectively.
What is QuickBooks Error H202?
QuickBooks Error H202 is an error code that occurs when a user attempts to switch to multi-user mode in QuickBooks Desktop but encounters issues connecting to the company file hosted on another computer. This error is often accompanied by an error message stating, “Error H202: An error occurred when trying to access the company file in multi-user mode.” When encountering this error, users may find themselves unable to access the company file in multi-user mode, leading to delays in collaborative accounting tasks.
Reasons for QuickBooks Error H202:
Several factors can contribute to the occurrence of QuickBooks Error H202. Some common reasons include:
Network Connection Issues: Problems with the network configuration or connectivity issues between the computer hosting the company file and the computer attempting to access it can lead to error H202.
Incorrect Hosting Configuration: Improper setup of QuickBooks hosting settings on the computer hosting the company file, or incorrect firewall and security software configurations, can trigger error H202.
Blockage by Firewall or Security Software: Overly restrictive firewall or security software settings may block QuickBooks communication ports, preventing proper access to the company file and resulting in error H202.
Damaged QuickBooks Installation: Corruption within the QuickBooks installation files or components related to multi-user mode functionality can interfere with proper file access, causing error H202.
Issues with QuickBooks Database Server Manager: Problems with the QuickBooks Database Server Manager, such as outdated or corrupted components, can prevent proper communication between QuickBooks and the company file, resulting in error H202.
Solutions to Fix QuickBooks Error H202:
To resolve QuickBooks Error H202, follow these comprehensive solutions:
Verify Hosting Settings:
Open QuickBooks on the computer hosting the company file.Go to the File menu and select Utilities.Ensure that Multi-User Access is enabled. If not, select it to enable multi-user mode.Repeat these steps on each computer attempting to access the company file to ensure proper hosting configuration.
Check Network Connectivity:
Verify that all computers are connected to the same network.Test network connectivity by pinging the host computer from the client computer(s) and vice versa.If there are any network issues, troubleshoot and resolve them to ensure proper communication between computers.
Configure Firewall and Security Settings:
Adjust firewall and security software settings to allow QuickBooks communication ports (specifically, ports 8019, 56726, and 55368) through both inbound and outbound rules.Add QuickBooks executable files (e.g., QBW32.exe, QBDBMgr.exe) to the list of trusted applications in firewall and security software settings.
Restart QuickBooks Services:
Close QuickBooks Desktop on all computers.Open the Run dialog by pressing Windows Key + R, type “services.msc,” and press Enter.Locate the QuickBooksDBXX service (XX represents the version of QuickBooks) and QuickBooksDBXX service, right-click each one, and select Restart.After restarting the services, reopen QuickBooks Desktop and attempt to switch to multi-user mode to see if error H202 persists.
Update QuickBooks and QuickBooks Database Server Manager:
Ensure that QuickBooks Desktop and QuickBooks Database Server Manager are updated to the latest versions.Open QuickBooks Desktop and go to the Help menu to check for updates. Similarly, update QuickBooks Database Server Manager to the latest version.
Use QuickBooks Database Server Manager:
Open QuickBooks Database Server Manager from the Start menu on the computer hosting the company file.Click on the Start Scan button to scan for company files.Once the scan is complete, attempt to switch to multi-user mode on the client computer(s) to see if error H202 is resolved.
Recreate QuickBooks.ND File:
Close QuickBooks Desktop on the computer hosting the company file.Navigate to the folder where the company file is located and locate the QuickBooks.ND file.Right-click on the QuickBooks.ND file and select Delete.Open QuickBooks Desktop to automatically recreate the QuickBooks.ND file.
Conclusion:
QuickBooks Error H202 can hinder collaboration and productivity in multi-user mode, but with the right troubleshooting steps, you can resolve it effectively. By addressing potential causes such as network connection issues, incorrect hosting configuration, firewall settings, damaged installations, and database server manager issues, you can overcome error H202 and ensure seamless collaboration among users in QuickBooks Desktop.
QuickBooks is widely used for managing finances and accounting tasks in businesses, and its multi-user mode allows multiple users to work on the same company file simultaneously. However, users may encounter issues with the multi-user mode, such as QuickBooks Error H202. This error can disrupt collaboration and hinder productivity if not addressed promptly. In this article, we’ll explore what QuickBooks Error H202 signifies, examine its potential reasons, and provide detailed solutions to resolve it effectively. What is QuickBooks Error H202? QuickBooks Error H202 is an error code that occurs when a user attempts to switch to multi-user mode in QuickBooks Desktop but encounters issues connecting to the company file hosted on another computer. This error is often accompanied by an error message stating, “Error H202: An error occurred when trying to access the company file in multi-user mode.” When encountering this error, users may find themselves unable to access the company file in multi-user mode, leading to delays in collaborative accounting tasks. Reasons for QuickBooks Error H202: Several factors can contribute to the occurrence of QuickBooks Error H202. Some common reasons include:Network Connection Issues: Problems with the network configuration or connectivity issues between the computer hosting the company file and the computer attempting to access it can lead to error H202.Incorrect Hosting Configuration: Improper setup of QuickBooks hosting settings on the computer hosting the company file, or incorrect firewall and security software configurations, can trigger error H202.Blockage by Firewall or Security Software: Overly restrictive firewall or security software settings may block QuickBooks communication ports, preventing proper access to the company file and resulting in error H202.Damaged QuickBooks Installation: Corruption within the QuickBooks installation files or components related to multi-user mode functionality can interfere with proper file access, causing error H202.Issues with QuickBooks Database Server Manager: Problems with the QuickBooks Database Server Manager, such as outdated or corrupted components, can prevent proper communication between QuickBooks and the company file, resulting in error H202. Solutions to Fix QuickBooks Error H202: To resolve QuickBooks Error H202, follow these comprehensive solutions:Verify Hosting Settings:Open QuickBooks on the computer hosting the company file.Go to the File menu and select Utilities.Ensure that Multi-User Access is enabled. If not, select it to enable multi-user mode.Repeat these steps on each computer attempting to access the company file to ensure proper hosting configuration.Check Network Connectivity:Verify that all computers are connected to the same network.Test network connectivity by pinging the host computer from the client computer(s) and vice versa.If there are any network issues, troubleshoot and resolve them to ensure proper communication between computers.Configure Firewall and Security Settings:Adjust firewall and security software settings to allow QuickBooks communication ports (specifically, ports 8019, 56726, and 55368) through both inbound and outbound rules.Add QuickBooks executable files (e.g., QBW32.exe, QBDBMgr.exe) to the list of trusted applications in firewall and security software settings.Restart QuickBooks Services:Close QuickBooks Desktop on all computers.Open the Run dialog by pressing Windows Key + R, type “services.msc,” and press Enter.Locate the QuickBooksDBXX service (XX represents the version of QuickBooks) and QuickBooksDBXX service, right-click each one, and select Restart.After restarting the services, reopen QuickBooks Desktop and attempt to switch to multi-user mode to see if error H202 persists.Update QuickBooks and QuickBooks Database Server Manager:Ensure that QuickBooks Desktop and QuickBooks Database Server Manager are updated to the latest versions.Open QuickBooks Desktop and go to the Help menu to check for updates. Similarly, update QuickBooks Database Server Manager to the latest version.Use QuickBooks Database Server Manager:Open QuickBooks Database Server Manager from the Start menu on the computer hosting the company file.Click on the Start Scan button to scan for company files.Once the scan is complete, attempt to switch to multi-user mode on the client computer(s) to see if error H202 is resolved.Recreate QuickBooks.ND File:Close QuickBooks Desktop on the computer hosting the company file.Navigate to the folder where the company file is located and locate the QuickBooks.ND file.Right-click on the QuickBooks.ND file and select Delete.Open QuickBooks Desktop to automatically recreate the QuickBooks.ND file. Conclusion: QuickBooks Error H202 can hinder collaboration and productivity in multi-user mode, but with the right troubleshooting steps, you can resolve it effectively. By addressing potential causes such as network connection issues, incorrect hosting configuration, firewall settings, damaged installations, and database server manager issues, you can overcome error H202 and ensure seamless collaboration among users in QuickBooks Desktop. Read More
Files disappeared?
5 years ago I downloaded a bunch of free cookbooks. Like hundreds. I saved them in my Onedrive in folders by topic, then author. Some I saved under topic, not in an author folder.
It’s been awhile since I’ve opened this folder. Well today I go in and anything under an author folder is gone. Anything just under topic is there. Any idea how this happened? Seems like files outside of the books folder are all there.
5 years ago I downloaded a bunch of free cookbooks. Like hundreds. I saved them in my Onedrive in folders by topic, then author. Some I saved under topic, not in an author folder.It’s been awhile since I’ve opened this folder. Well today I go in and anything under an author folder is gone. Anything just under topic is there. Any idea how this happened? Seems like files outside of the books folder are all there. Read More
Cancel Subscription
Hello
Please i need help on this issue.
How do i request for a refund and to cancel his subscription.
How do i qualify to get a refund.
Hello Please i need help on this issue. How do i request for a refund and to cancel his subscription. How do i qualify to get a refund. Read More
New Bookings
Hey,
I’m new to bookings and have looked through here and on YouTube, but I still need help finding what I’m looking for.
I’m looking to set up a bookings page for company health assessments. These appointments are 30 minutes long, and one of the teams that is in will complete the assessment. No single staff member will be assigned to the booking.
When setting it up, I used the shared booking pages and wanted to link this to a shared mailbox calendar that the entire team could access. I have had the below problems.
1) I have not been able to get the bookings calendar to link with the mailbox calendar.
2) When testing with my calendar, when blocking out time as off or busy, this still allows bookings even though I have turned on the Outlook events, which affects booking availability.
3) When a booking has been made through the booking page, it still displays the time slot as available and returns the error message after the staff member fills out the form. Can this be updated so that it does not show times when they are booked?
Any help would be greatly appreciated,
I appreciate any help you can provide.
Hey, I’m new to bookings and have looked through here and on YouTube, but I still need help finding what I’m looking for. I’m looking to set up a bookings page for company health assessments. These appointments are 30 minutes long, and one of the teams that is in will complete the assessment. No single staff member will be assigned to the booking. When setting it up, I used the shared booking pages and wanted to link this to a shared mailbox calendar that the entire team could access. I have had the below problems. 1) I have not been able to get the bookings calendar to link with the mailbox calendar.2) When testing with my calendar, when blocking out time as off or busy, this still allows bookings even though I have turned on the Outlook events, which affects booking availability.3) When a booking has been made through the booking page, it still displays the time slot as available and returns the error message after the staff member fills out the form. Can this be updated so that it does not show times when they are booked? Any help would be greatly appreciated, I appreciate any help you can provide. Read More
Week commencing column fill
Hello,
Can anyone help please?
I want to fill a column with successive Mondays, ie June 3, June 10, June 17.
Can anyone advise how to do this?
Many thanks
Sonja84
Hello,Can anyone help please?I want to fill a column with successive Mondays, ie June 3, June 10, June 17.Can anyone advise how to do this?Many thanksSonja84 Read More
Remove staff from Dynamic distribution group.
I have a dynamic distribution group that pulls all licenses premium users, and we use it to add access to applications. I need to remove accounts that have a premium license but don’t need access to the application. I just cannot get the syntax quite right.
This is the systex rule that I have now.
user.assignedPlans -any (assignedPlan.servicePlanId -eq “23456778-df34-3dfg-fe35-lpn3r07bb09d” -and assignedPlan.capabilityStatus -eq “Enabled”)
I have a dynamic distribution group that pulls all licenses premium users, and we use it to add access to applications. I need to remove accounts that have a premium license but don’t need access to the application. I just cannot get the syntax quite right. This is the systex rule that I have now. user.assignedPlans -any (assignedPlan.servicePlanId -eq “23456778-df34-3dfg-fe35-lpn3r07bb09d” -and assignedPlan.capabilityStatus -eq “Enabled”) Read More