Category: Microsoft
Category Archives: Microsoft
Formula Assistance
Hi there
I would be grateful for some help with creating a formula please. I’ve attached a screenshot below.
I have a spreadsheet where staff enter each new job as it comes into the office. I want the cells in the Date Required column to automatically fill themselves as the staff member enters a date in the Date Received column. The date to automatically fill should be 14 days after the date entered in the Date Received column.
THEN we would like to quickly see which jobs in the Date Required column are about to come due. To do this we would like see the cell which is displaying a date within 2 days of todays date to turn red (background colour of the cell not the letters) unless the word ‘Completed’ is written in the Job Status column.
I trust this makes sense and hope someone can help me.
Thank you very much.
Kim
Hi thereI would be grateful for some help with creating a formula please. I’ve attached a screenshot below.I have a spreadsheet where staff enter each new job as it comes into the office. I want the cells in the Date Required column to automatically fill themselves as the staff member enters a date in the Date Received column. The date to automatically fill should be 14 days after the date entered in the Date Received column.THEN we would like to quickly see which jobs in the Date Required column are about to come due. To do this we would like see the cell which is displaying a date within 2 days of todays date to turn red (background colour of the cell not the letters) unless the word ‘Completed’ is written in the Job Status column. I trust this makes sense and hope someone can help me. Thank you very much.Kim Read More
Unable to Sign in to Azure Portal
Hi team,
I am unable to sign in to Azure Portal. I am on a free trial on azure and have running VMs that I need to deallocate. It never used to ask me verification email this time and when I put the right verification email I do not receive a security code there in the recovery email. I am able to login to my Hotmail which does not ask me for verification email. I am also sure that the verification email matches the one I put. Please someone from the team help me resolve this issue.
Hi team, I am unable to sign in to Azure Portal. I am on a free trial on azure and have running VMs that I need to deallocate. It never used to ask me verification email this time and when I put the right verification email I do not receive a security code there in the recovery email. I am able to login to my Hotmail which does not ask me for verification email. I am also sure that the verification email matches the one I put. Please someone from the team help me resolve this issue. Read More
Outlook on mobile devices
Hello
Please i need your help on this issue.
I am experiencing issues with Outlook on mobile devices. Specifically, PDFs are not opening properly, and there seems to be a sync problem with IMAP on iPhones.
Hello Please i need your help on this issue. I am experiencing issues with Outlook on mobile devices. Specifically, PDFs are not opening properly, and there seems to be a sync problem with IMAP on iPhones. Read More
Cannot create email groups in exchange admin center – 2
Hello
Please i need help on this issue.
Cannot create email groups in exchange admin center
When I attempt to create and email group using EAC I get the following error.
We couldn’t create the group.
Exception of type ‘Microsoft.Online.BOX.Util.Exceptions.InternalException’ was thrown.
I have tried with different web browsers using private or incognito mode and it still doesn’t work. I am able to create the Exchange groups using PowerShell commands, but I cannot create them using the Exchange web portal.
Hello Please i need help on this issue.Cannot create email groups in exchange admin centerWhen I attempt to create and email group using EAC I get the following error. We couldn’t create the group.Exception of type ‘Microsoft.Online.BOX.Util.Exceptions.InternalException’ was thrown. I have tried with different web browsers using private or incognito mode and it still doesn’t work. I am able to create the Exchange groups using PowerShell commands, but I cannot create them using the Exchange web portal. Read More
Executing FileSavePicker.PickSaveFileAsync on .NET MAUI causes the application to crash.
Executing following code on .NET MAUI causes the application to crash.
public async Task<bool> ShowAsync(string fileName, byte[] bytes, SaveFilePickerOptions options)
{
ArgumentNullException.ThrowIfNull(options);
FileSavePicker fileSavePicker = new()
{
SuggestedStartLocation = PickerLocationId.DocumentsLibrary,
SuggestedFileName = fileName,
};
foreach(var item in options.WindowsFileTypes)
{
fileSavePicker.FileTypeChoices.Add(item.Key, item.Value);
}
if(MauiWinUIApplication.Current.Application.Windows[0].Handler.PlatformView is MauiWinUIWindow window)
{
InitializeWithWindow.Initialize(fileSavePicker, window.WindowHandle);
}
StorageFile file = await fileSavePicker.PickSaveFileAsync();
if(file == null)
{
return false;
}
using(FileStream fileStream = new(file.Path, FileMode.OpenOrCreate))
{
fileStream.Write(bytes, 0, bytes.Length);
}
return true;
}
When PickSaveFileAsync is executed, the following dialog is displayed in Debug mode.
Please let me know what to do.
Executing following code on .NET MAUI causes the application to crash. public async Task<bool> ShowAsync(string fileName, byte[] bytes, SaveFilePickerOptions options)
{
ArgumentNullException.ThrowIfNull(options);
FileSavePicker fileSavePicker = new()
{
SuggestedStartLocation = PickerLocationId.DocumentsLibrary,
SuggestedFileName = fileName,
};
foreach(var item in options.WindowsFileTypes)
{
fileSavePicker.FileTypeChoices.Add(item.Key, item.Value);
}
if(MauiWinUIApplication.Current.Application.Windows[0].Handler.PlatformView is MauiWinUIWindow window)
{
InitializeWithWindow.Initialize(fileSavePicker, window.WindowHandle);
}
StorageFile file = await fileSavePicker.PickSaveFileAsync();
if(file == null)
{
return false;
}
using(FileStream fileStream = new(file.Path, FileMode.OpenOrCreate))
{
fileStream.Write(bytes, 0, bytes.Length);
}
return true;
} When PickSaveFileAsync is executed, the following dialog is displayed in Debug mode.Please let me know what to do. Read More
Cant access my Edge since I crashed it
In an effort to obtain more vivid colours I went into
edge://flags
color
and selected sRGB which was fine.
Because it was so simple, I figured I’d go in again and select the next on the drop down menu but as soon as I did Edge crashed and I cant get back into it nor does it respond to anything.
Can someone please advise me what I should do?
I have tried to reset it, but the problem persists.
I’d be happy if it was reset back to factory specs, even if I lose all the other stuff, its no big deal
Please help, I love Edge
In an effort to obtain more vivid colours I went intoedge://flagscolorand selected sRGB which was fine.Because it was so simple, I figured I’d go in again and select the next on the drop down menu but as soon as I did Edge crashed and I cant get back into it nor does it respond to anything.Can someone please advise me what I should do?I have tried to reset it, but the problem persists.I’d be happy if it was reset back to factory specs, even if I lose all the other stuff, its no big dealPlease help, I love Edge Read More
Announcing the General Availability of GPT-4 Turbo with Vision on Azure OpenAI Service
We are excited to announce the general availability (GA) of GPT-4 Turbo with Vision on the Azure OpenAI Service. The GA model, gpt-4-turbo-2024-04-09, is a multimodal model capable of processing both text and image inputs to generate text outputs. This model replaces the following preview models:
gpt-4-1106-preview
gpt-4-0125-preview
gpt-4-vision-preview
Our customers and partners have been utilizing GPT-4 Turbo with Vision to create new processes, enhance efficiencies, and innovate within their businesses. Applications range from retailers improving the online shopping experience, to media and entertainment companies enriching digital asset management, and various organizations deriving insights from charts and diagrams. We will be showcasing detailed case studies from these applications at the upcoming Build conference.
Existing Azure OpenAI Service customers can now deploy gpt-4-turbo-2024-04-09 in Sweden Central and East US 2. For more information, please visit our model availability page.
Guide to Deploying GPT-4 Turbo with Vision GA
To deploy this GA model from the Studio UI, select “GPT-4” and then choose the “turbo-2024-04-09” version from the dropdown menu. The default quota for the gpt-4-turbo-2024-04-09 model will be the same as current quota for GPT-4-Turbo. See the regional quota limits.
Upgrade Path from Preview to GA Models
We are targeting the upgrade of deployments that utilize any of the three preview models (gpt-4-1106-preview, gpt-4-0125-preview, and gpt-4-vision-preview) and are configured for auto-update on the Azure OpenAI Service. These deployments will be upgraded to gpt-4-turbo-2024-04-09 starting on June 10th or later. We will notify all customers with these preview deployments at least two weeks before the start of the upgrades. We will publish an upgrade schedule detailing the order of regions and model versions that we will follow during the upgrades in our public documentation.
Upcoming Features for image (vision) inputs: JSON Mode and Function Calling
JSON mode and function calling for inference requests involving image (vision) inputs will be available in GA in the coming weeks. Please note that text-based inputs will continue to support both JSON mode and function calling.
Changes to GPT-4 Vision Enhancements
Enhancements such as Optical Character Recognition (OCR), object grounding, video prompts, and “Azure OpenAI Service on your data with images”, that were integrated with the gpt-4-vision-preview model will not be available with the GA model. We are dedicated to enhancing our products to provide value to our customers, and are actively exploring how to best integrate these features into future offerings.
To Get Started, Explore the Following Resources
Learn more about What’s new in Azure OpenAI Service?
Learn more about GPT-4 Turbo with Vision on Azure OpenAI Service
Azure Open AI Quickstart for GPT-4 Turbo with Vision
Azure Open AI How-To Guide: How to use the GPT-4 Turbo with Vision model on Azure OpenAI Service
GPT-4 Turbo with Vision pricing explained in detail: Text and Image tokens
Apply now for access to Azure OpenAI Service
If you are a current Azure OpenAI customer and would like to add additional use cases, fill out the Azure OpenAI Additional Use Case form.
Responsible AI: Transparency Note for Azure OpenAI Service
Microsoft Tech Community – Latest Blogs –Read More
Excel- Help transfering dropdown lists to new sheet
I have an excel estimate sheet I made for doing comstruction estimates. My idea is to make drop down lists in the estimate sheet for products needed for the job. Each line item will have a drop down list of the supplies/materials to choose from. I want to take supplies/materials that were chosen from the drop downs and add them to another sheet, supplies/materials sheet. The part I’m not sure how to do, is getting the selected items from each drop down list and putting it into another sheet, and then being able to use that sheet to show all the materials and supplies needed for the job. Any help would be greatly appreciated. Thank you.
I have an excel estimate sheet I made for doing comstruction estimates. My idea is to make drop down lists in the estimate sheet for products needed for the job. Each line item will have a drop down list of the supplies/materials to choose from. I want to take supplies/materials that were chosen from the drop downs and add them to another sheet, supplies/materials sheet. The part I’m not sure how to do, is getting the selected items from each drop down list and putting it into another sheet, and then being able to use that sheet to show all the materials and supplies needed for the job. Any help would be greatly appreciated. Thank you. Read More
April V2 end of month Title Plan out now!
The Monthly Title Plan for April V2 is attached to this post. The Title Plan can also be found in the following locations:
MPN Partner Portal Learning Resources page Resource page for Training Services Partners (Title Plan publishing takes 2-3 business days)
MCT Lounge Brand-new lounge for MCTs
New courses are coming soon!
AZ-2005: Develop AI agents using Azure OpenAI and the Semantic Kernel SDK – May 24th, 2024
SC-5008: Configure and manage entitlement with Microsoft Entra ID – June 28th, 2024
SC-5006: Get started with Microsoft Copilot for Security – July 5th, 2024
RETIRED AS OF APRIL 30TH 2024:
DP-500T00: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Major update for AZ-400T00: Designing and Implementing Microsoft DevOps solutions:
Change Log is now available on LDC to better support deliveries ahead of 5/3 update.
MS-102T00: Microsoft 365 Administrator — Major update pushed back.
Major Update now rescheduled for May 24th, 2024
The Monthly Title Plan for April V2 is attached to this post. The Title Plan can also be found in the following locations:
MPN Partner Portal Learning Resources page Resource page for Training Services Partners (Title Plan publishing takes 2-3 business days)
MCT Lounge Brand-new lounge for MCTs
New courses are coming soon!
AZ-2005: Develop AI agents using Azure OpenAI and the Semantic Kernel SDK – May 24th, 2024
SC-5008: Configure and manage entitlement with Microsoft Entra ID – June 28th, 2024
SC-5006: Get started with Microsoft Copilot for Security – July 5th, 2024
RETIRED AS OF APRIL 30TH 2024:DP-500T00: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Major update for AZ-400T00: Designing and Implementing Microsoft DevOps solutions:Change Log is now available on LDC to better support deliveries ahead of 5/3 update.
MS-102T00: Microsoft 365 Administrator — Major update pushed back.Major Update now rescheduled for May 24th, 2024
Read More
Let’s Fix QuickBooks Express Web Connect error- By Expert
The QuickBooks Express Web Connect error occurs when users experience problems connecting their financial institution accounts to QuickBooks using the Express Web Connect feature. This error can manifest as a connection problem or an inability to download a transaction from your bank or bank.
Reasons Behind QuickBooks Express Web Connect Error:
1.Temporary Server Issues:
Sometimes, the error may occur due to temporary server issues on either QuickBooks or your financial institution’s end, disrupting the connection process.
2.Incorrect Credentials:
Entering incorrect login credentials for your financial institution account in QuickBooks can lead to authentication failures, resulting in the Express Web Connect Error.
3.Unsupported Account Type:
Certain account types, such as savings or investment accounts, may not be compatible with the Express Web Connect feature, leading to connectivity issues.
4.Outdated QuickBooks Version:
Running an outdated version of QuickBooks software may cause compatibility issues with the Express Web Connect feature, resulting in errors during data synchronization.
Solutions to Resolve QuickBooks Express Web Connect Error:
1.Verify Credentials and Account Type:
Double-check the login credentials for your financial institution account in QuickBooks, ensuring they are accurate. Additionally, confirm with your financial institution if your account type supports Express Web Connect.
2.Update QuickBooks Software:
Ensure your QuickBooks software is up-to-date by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to resolve.
3.Retry Connection and Refresh Data:
Attempt to reconnect your financial institution account using the Express Web Connect feature in QuickBooks. After reconnecting, refresh the account to retrieve the latest transactions.
4.Contact QuickBooks Support:
If the issue persists, don’t hesitate to reach out to QuickBooks customer support for personalized assistance. Their experts can guide you through advanced troubleshooting steps tailored to your specific scenario.
Conclusion
While QuickBooks Express Web Connect Error can be challenging, understanding its causes and implementing effective solutions ensures a smooth financial process. By managing credentials, updating software, and accessing support when needed, users can overcome obstacles and customize their QuickBooks experience with confidence and ease.
The QuickBooks Express Web Connect error occurs when users experience problems connecting their financial institution accounts to QuickBooks using the Express Web Connect feature. This error can manifest as a connection problem or an inability to download a transaction from your bank or bank. Reasons Behind QuickBooks Express Web Connect Error: 1.Temporary Server Issues: Sometimes, the error may occur due to temporary server issues on either QuickBooks or your financial institution’s end, disrupting the connection process. 2.Incorrect Credentials: Entering incorrect login credentials for your financial institution account in QuickBooks can lead to authentication failures, resulting in the Express Web Connect Error. 3.Unsupported Account Type: Certain account types, such as savings or investment accounts, may not be compatible with the Express Web Connect feature, leading to connectivity issues. 4.Outdated QuickBooks Version:Running an outdated version of QuickBooks software may cause compatibility issues with the Express Web Connect feature, resulting in errors during data synchronization. Solutions to Resolve QuickBooks Express Web Connect Error: 1.Verify Credentials and Account Type:Double-check the login credentials for your financial institution account in QuickBooks, ensuring they are accurate. Additionally, confirm with your financial institution if your account type supports Express Web Connect. 2.Update QuickBooks Software:Ensure your QuickBooks software is up-to-date by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to resolve. 3.Retry Connection and Refresh Data: Attempt to reconnect your financial institution account using the Express Web Connect feature in QuickBooks. After reconnecting, refresh the account to retrieve the latest transactions. 4.Contact QuickBooks Support:If the issue persists, don’t hesitate to reach out to QuickBooks customer support for personalized assistance. Their experts can guide you through advanced troubleshooting steps tailored to your specific scenario. Conclusion While QuickBooks Express Web Connect Error can be challenging, understanding its causes and implementing effective solutions ensures a smooth financial process. By managing credentials, updating software, and accessing support when needed, users can overcome obstacles and customize their QuickBooks experience with confidence and ease. Read More
NEW ILT 1-Day Course Coming June 28th!
Release Date: June 28th, 2024
(Release dates are subject to change)
SC-5008: Configure and manage
entitlement with Microsoft Entra ID
Course Description:
1-Day ILT
No Credential
This intensive one-day course offers a deep dive into Microsoft Entra Entitlement Management, Access Reviews, Privileged Access, and Monitoring. Participants will learn how to streamline access management with Entitlement Management, conducted thorough Access Reviews to maintain least privilege, manage high-risk Privileged Access, and implement robust Monitoring strategies to detect and respond to security events promptly.
Labs are integrated throughout the course to provide hands-on experience with the tools and techniques covered. By the end of the training, attendees will be equipped with the best practices and actionable insights to enhance their organization’s security posture.
Audience:
This course is targeted at people who want to implement an end-to-end entitlement management solution based on the principles of Zero Trust. Students should have experience with Azure and experience in the creation of identities and granting those identities access to resources.
Release Date: June 28th, 2024
(Release dates are subject to change)
SC-5008: Configure and manage
entitlement with Microsoft Entra ID
Course Description:
1-Day ILT
No Credential
This intensive one-day course offers a deep dive into Microsoft Entra Entitlement Management, Access Reviews, Privileged Access, and Monitoring. Participants will learn how to streamline access management with Entitlement Management, conducted thorough Access Reviews to maintain least privilege, manage high-risk Privileged Access, and implement robust Monitoring strategies to detect and respond to security events promptly.
Labs are integrated throughout the course to provide hands-on experience with the tools and techniques covered. By the end of the training, attendees will be equipped with the best practices and actionable insights to enhance their organization’s security posture.
Audience:
This course is targeted at people who want to implement an end-to-end entitlement management solution based on the principles of Zero Trust. Students should have experience with Azure and experience in the creation of identities and granting those identities access to resources.
Read More
Using Trial ‘Hyper-V Server 2019’
There is information on the Hyper-V Server 2019 homepage suggesting that it can be used for free, and VM companies are supplying this product for free.
However, we understand that this product requires purchasing a valid Windows Server license to use it legally. We would like to confirm with Microsoft whether this product can be officially used by businesses and institutions without issues.
https://www.microsoft.com/ko-kr/evalcenter/evaluate-hyper-v-server-2019
There is information on the Hyper-V Server 2019 homepage suggesting that it can be used for free, and VM companies are supplying this product for free.However, we understand that this product requires purchasing a valid Windows Server license to use it legally. We would like to confirm with Microsoft whether this product can be officially used by businesses and institutions without issues.https://www.microsoft.com/ko-kr/evalcenter/evaluate-hyper-v-server-2019 Read More
NEW ILT Applied Skills course coming May 24th!
Release Date: May 24th, 2024
(Release dates are subject to change)
AZ-2005: Develop AI agents using
Azure OpenAI and the Semantic Kernel SDK
Course Description:
1-Day ILT
Credential: Applied Skills Assessment
This course teaches C# developers how to use the Semantic Kernel SDK to connect their applications to Large Language Models. Students will learn the core functions of the SDK and will develop features that use the LLM’s natural language processing ability.
Audience:
Students in this course are familiar with C# development and interested in integrating applications with AI.
Release Date: May 24th, 2024
(Release dates are subject to change)
AZ-2005: Develop AI agents using
Azure OpenAI and the Semantic Kernel SDK
Course Description:
1-Day ILT
Credential: Applied Skills Assessment
This course teaches C# developers how to use the Semantic Kernel SDK to connect their applications to Large Language Models. Students will learn the core functions of the SDK and will develop features that use the LLM’s natural language processing ability.
Audience:
Students in this course are familiar with C# development and interested in integrating applications with AI.
NEW ILT Copilot course coming July 5th!
Release Date: July 5th, 2024
(Release dates are subject to change)
SC-5006: Get started with
Microsoft Copilot for Security
Course Description:
1-Day ILT
No Credential
The Learning Path, “Get stated with Microsoft Copilot for Security.” is currently available on MS Learn for self-paced Learners.
This July, we will release the ILT delivery for this course. The ILT release will include lab-like exercises that will give Learners the opportunity to FIRST experience the capabilities of the product through a simulated demo environment. Stay tuned!
Self-paced Learning Path can be found here:
Get started with Microsoft Copilot for Security – Training | Microsoft Learn
Release Date: July 5th, 2024
(Release dates are subject to change)
SC-5006: Get started with
Microsoft Copilot for Security
Course Description:
1-Day ILT
No Credential
The Learning Path, “Get stated with Microsoft Copilot for Security.” is currently available on MS Learn for self-paced Learners.
This July, we will release the ILT delivery for this course. The ILT release will include lab-like exercises that will give Learners the opportunity to FIRST experience the capabilities of the product through a simulated demo environment. Stay tuned!
Self-paced Learning Path can be found here:
Get started with Microsoft Copilot for Security – Training | Microsoft Learn Read More
Azure Functions Newsletter – May 2024
Welcome to the May 2024 edition of Azure Functions newsletter! We’ll share the latest news for Azure Functions here on the Apps on Azure blog.
Azure Functions monthly community live stream
Join us for our upcoming live stream on May 02, 2024, at 9:30 AM PST (16:30 UTC). Tune in to hear from Madhura Bharadwaj, Ramya Oruganti, and Thiago Almeida as they discuss the latest releases in Azure Functions, provide insights into HTTP streams support for Node.js, and Functions on Azure Container Apps. Mark your calendars for this informative session!
Subscribe to the Azure Developers YouTube channel!
Product News
Following is the list of new Azure Functions features released since February 2024:
AREAS
Since February 2024
Retirements
Support for .NET 6 ends on 12 November 2024
Support for .NET 7 ends on 14 May 2024
Support for the in-process model for .NET apps in Azure Functions ends 10 November 2026
Update to Azure Functions Service Bus extension v5.x by 31 March 2025 for continued support
Triggers and Bindings
GA: Azure SQL Trigger support for Azure Functions
Languages
Public Preview: PowerShell 7.4 support for Azure Functions
GA: Azure Functions Support for Node.js 20
Public Preview: Azure Functions Support for HTTP Streams in Node.js
Get notified when we publish future newsletters, subscribe to the Apps on Azure blog. Connect with the Azure Functions team on GitHub and Twitter.
Microsoft Tech Community – Latest Blogs –Read More
Recommendations for best voip to buy US numbers from Canada without having US address for business
Please let me know the best VOIP providers for small business to buy US numbers from Canada without having the US address.
Thank you!
Please let me know the best VOIP providers for small business to buy US numbers from Canada without having the US address. Thank you! Read More
What To Do When Getting Express Web Connect Error in QuickBooks
Encountering Express Web Connect errors in QuickBooks can be frustrating, but there are several steps you can take to troubleshoot and resolve the issue:
Check QuickBooks Service Status: Sometimes, the issue might be with QuickBooks servers. Visit the QuickBooks Service Status page to see if there are any reported outages or issues with the Express Web Connect service.
Update QuickBooks: Ensure that your QuickBooks software is up to date. Sometimes, outdated software can cause compatibility issues with the Express Web Connect feature.
Check Internet Connection: Make sure that your internet connection is stable and working properly. Poor internet connectivity can cause communication errors with the financial institution’s servers.
Restart QuickBooks: Sometimes, simply restarting QuickBooks can resolve temporary glitches or errors.
Update Financial Institution Information: If the error persists, try updating the financial institution information in QuickBooks. Go to the Banking menu, select Bank Feeds, and then choose Bank Feeds Center. From there, select the financial institution experiencing the error and click on the Edit :pencil: icon. Follow the prompts to update the connection information.
Deactivate and Reactivate Account: If updating the financial institution information doesn’t work, you can try deactivating and then reactivating the affected account. Go to the Banking menu, select Bank Feeds, and then choose Bank Feeds Center. Select the account experiencing the error, and click on the Deactivate :heavy_multiplication_x: icon. After deactivating, repeat the process to reactivate the account.
Contact Customer Support: If none of the above steps resolve the issue, it’s recommended to contact QuickBooks customer support for further assistance. They can provide specific guidance tailored to your situation and help troubleshoot the problem.
Encountering Express Web Connect errors in QuickBooks can be frustrating, but there are several steps you can take to troubleshoot and resolve the issue: Check QuickBooks Service Status: Sometimes, the issue might be with QuickBooks servers. Visit the QuickBooks Service Status page to see if there are any reported outages or issues with the Express Web Connect service.Update QuickBooks: Ensure that your QuickBooks software is up to date. Sometimes, outdated software can cause compatibility issues with the Express Web Connect feature.Check Internet Connection: Make sure that your internet connection is stable and working properly. Poor internet connectivity can cause communication errors with the financial institution’s servers.Restart QuickBooks: Sometimes, simply restarting QuickBooks can resolve temporary glitches or errors.Update Financial Institution Information: If the error persists, try updating the financial institution information in QuickBooks. Go to the Banking menu, select Bank Feeds, and then choose Bank Feeds Center. From there, select the financial institution experiencing the error and click on the Edit :pencil: icon. Follow the prompts to update the connection information.Deactivate and Reactivate Account: If updating the financial institution information doesn’t work, you can try deactivating and then reactivating the affected account. Go to the Banking menu, select Bank Feeds, and then choose Bank Feeds Center. Select the account experiencing the error, and click on the Deactivate :heavy_multiplication_x: icon. After deactivating, repeat the process to reactivate the account.Contact Customer Support: If none of the above steps resolve the issue, it’s recommended to contact QuickBooks customer support for further assistance. They can provide specific guidance tailored to your situation and help troubleshoot the problem. Read More
How Do I Fix QuickBooks Company File Error 6190 and 816
QuickBooks is a powerful accounting software used by millions of businesses worldwide to manage their financial operations efficiently. However, like any software, QuickBooks can encounter errors that disrupt workflow and cause frustration. One such error is the QuickBooks Company File Error 6190 and 816. In this article, we’ll delve into what this error is, its possible causes, and effective solutions to resolve it.
What is QuickBooks Company File Error 6190 and 816?
QuickBooks Error 6190 and 816 is a company file error that occurs when a user tries to access a QuickBooks company file, but the file is either not accessible or corrupted. This error typically appears with an error message indicating that QuickBooks was unable to open the company file.
Reasons Behind QuickBooks Company File Error 6190 and 816:
Mismatched Transactions: One of the most common causes of this error is when there’s a mismatch between the transactions recorded on the server and those on the workstation.
Single User Mode: If the company file is accessed in Single User Mode by one user while another user tries to access it simultaneously, it can lead to this error.
Network Issues: Problems with the network connection, such as poor network connectivity or a network outage, can also trigger Error 6190 and 816.
Data Corruption: If the company file is damaged or corrupted, either due to improper shutdowns, power outages, or malware infections, it can result in this error.
Solutions to Fix QuickBooks Company File Error 6190 and 816:
Use QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool provided by Intuit to fix various QuickBooks-related issues, including company file errors. Download and run the QuickBooks File Doctor tool, and follow the on-screen instructions to scan and repair the company file.
Ensure Single User Mode: Make sure that only one user is accessing the company file at a time. If multiple users need to access the file simultaneously, consider switching to Multi-User Mode.
Update QuickBooks and Server: Ensure that both QuickBooks software and your server are updated to the latest version. Outdated software can sometimes cause compatibility issues leading to errors.
Check Network Connectivity: Verify that your network connection is stable and functioning correctly. Troubleshoot any network issues that may be affecting the communication between QuickBooks and the company file.
Rename .TLG and .ND Files: Renaming the transaction log file (.TLG) and network descriptor file (.ND) associated with the company file can sometimes resolve the error. Simply add “.old” at the end of the file names to rename them, and then try opening the company file again.
Restore a Backup: If the company file is severely damaged and cannot be repaired, you may need to restore a backup of the file from a previous point in time when it was working correctly.
Contact QuickBooks Support: If none of the above solutions work, it’s advisable to seek assistance from QuickBooks customer support. They can provide further troubleshooting steps tailored to your specific situation and help resolve the error.
Conclusion:
QuickBooks Company File Error 6190 and 816 can be a frustrating issue, but with the right troubleshooting steps, it can be resolved effectively. By following the solutions outlined in this article and addressing the possible causes of the error, you can get your QuickBooks company file back up and running smoothly.
Related Searches:
#Error message 6190 and 816 #QuickBooks Error 6190 & 816 #QuickBooks error 6190 77 #QuickBooks Error 6190 816 #QuickBooks Error 6190 and 816 #QuickBooks error message 6190 816 #QuickBooks Message code 6190
QuickBooks is a powerful accounting software used by millions of businesses worldwide to manage their financial operations efficiently. However, like any software, QuickBooks can encounter errors that disrupt workflow and cause frustration. One such error is the QuickBooks Company File Error 6190 and 816. In this article, we’ll delve into what this error is, its possible causes, and effective solutions to resolve it.What is QuickBooks Company File Error 6190 and 816?QuickBooks Error 6190 and 816 is a company file error that occurs when a user tries to access a QuickBooks company file, but the file is either not accessible or corrupted. This error typically appears with an error message indicating that QuickBooks was unable to open the company file.Reasons Behind QuickBooks Company File Error 6190 and 816:Mismatched Transactions: One of the most common causes of this error is when there’s a mismatch between the transactions recorded on the server and those on the workstation.Single User Mode: If the company file is accessed in Single User Mode by one user while another user tries to access it simultaneously, it can lead to this error.Network Issues: Problems with the network connection, such as poor network connectivity or a network outage, can also trigger Error 6190 and 816.Data Corruption: If the company file is damaged or corrupted, either due to improper shutdowns, power outages, or malware infections, it can result in this error.Solutions to Fix QuickBooks Company File Error 6190 and 816:Use QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool provided by Intuit to fix various QuickBooks-related issues, including company file errors. Download and run the QuickBooks File Doctor tool, and follow the on-screen instructions to scan and repair the company file.Ensure Single User Mode: Make sure that only one user is accessing the company file at a time. If multiple users need to access the file simultaneously, consider switching to Multi-User Mode.Update QuickBooks and Server: Ensure that both QuickBooks software and your server are updated to the latest version. Outdated software can sometimes cause compatibility issues leading to errors.Check Network Connectivity: Verify that your network connection is stable and functioning correctly. Troubleshoot any network issues that may be affecting the communication between QuickBooks and the company file.Rename .TLG and .ND Files: Renaming the transaction log file (.TLG) and network descriptor file (.ND) associated with the company file can sometimes resolve the error. Simply add “.old” at the end of the file names to rename them, and then try opening the company file again.Restore a Backup: If the company file is severely damaged and cannot be repaired, you may need to restore a backup of the file from a previous point in time when it was working correctly.Contact QuickBooks Support: If none of the above solutions work, it’s advisable to seek assistance from QuickBooks customer support. They can provide further troubleshooting steps tailored to your specific situation and help resolve the error.Conclusion:QuickBooks Company File Error 6190 and 816 can be a frustrating issue, but with the right troubleshooting steps, it can be resolved effectively. By following the solutions outlined in this article and addressing the possible causes of the error, you can get your QuickBooks company file back up and running smoothly. Related Searches: #Error message 6190 and 816 #QuickBooks Error 6190 & 816 #QuickBooks error 6190 77 #QuickBooks Error 6190 816 #QuickBooks Error 6190 and 816 #QuickBooks error message 6190 816 #QuickBooks Message code 6190 Read More
MGDC for SharePoint FAQ: How to deal with schema changes
0. Introduction
When you use Microsoft Graph Data Connect, you will commonly refer to the dataset schemas to understand what is provided with each dataset. For SharePoint datasets, you can see the schemas using this link: https://aka.ms/SharePointDatasets.
Microsoft Graph Data Connect schemas do not change often. However, on rare occasions, the schemas will change to offer additional capabilities or improve existing ones. Even when that happens, the goal is to avoid disruptions to your existing pipelines.
This blog post covers a few details about how schemas change and how to deal with some of the rare side effects.
1, Non-breaking schema changes
If a dataset schema changes in a way that causes all your pipelines to stop working, we call that a breaking change. That would be the case if the data type or the meaning of a column changes. That would also be the case of an existing column being renamed or removed. See changes marked with a red X in the diagram below. Breaking schema changes should never happen.
If these types of schema changes are required, the required procedure is to create a new version of the schema (essentially a new schema with a new name) and deprecate (and eventually remove) the old schema.
However, it’s possible to make changes that will not break existing pipelines. To do this, schema changes can only contain new columns. For nested columns, it is OK to add more properties to the nested object if the parent column and existing children are not changed. See changes marked with a blue check in the diagram below.
Your pipeline will typically be unaffected by these non-breaking changes in the schema. Everything should continue to run after the changes happen without any modifications to your pipelines.
2. Pipeline change after consent
There is a situation that could cause your pipeline to fail due to a non-breaking schema change. This happens when you create the MGDC Application (consent request) before the schema change and the pipeline after the schema change.
Imagine that you created the MGDC application, got the proper consent for the specific dataset, but did not immediately create the pipeline to consume that dataset. A schema change then added a new column after the consent was granted but before the pipeline was created. When you got around to creating the pipeline, the new column was included, but you did not have consent for that column.
In that case, when you run the pipeline, you could see an error like this:
ErrorCode=UserErrorOffice365DataLoaderError,
Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
Message=Office365 data loading failed to execute.
office365LoadErrorType: PermanentError.
Invalid requested columns.
The following requested columns were not consent to
for dataset [BasicDataSet_v0.SharePointSites_v1]
under application [00000000-444e-45d0-aa5a-39f318fae21c]: [Privacy].
This is by designed and the pipeline fails because that new column is in the pipeline definition but not in the consent. The error message might mention invalid columns, lack of consent, or it might just say that it “cannot resolve” the column.
If you don’t care for the new column, a simple workaround is to edit the pipeline (specifically the data source configuration) to remove the newly added column (lacking consent). Without a reference to that column, the pipeline will run fine with the existing consent.
If you are indeed interested in the new column, then the solution is to update the MGDC Application request to include it. You will need your Microsoft 365 Global Administrator to approve that updated application consent.
3. Delta changes
Another potential side effect of a schema change is related to Delta pulls. That happens in the specific case where a new property is added to a nested column. For instance, this would happen in the earlier example in the diagram where a new “email” property is added to the “owner” object.
An existing pipeline will have no problem pulling the updated column and you will not have any issues. The only additional work might be to investigate scenarios where this new nested column would be useful and make changes to your reports or dashboards to leverage it.
However, from a Delta standpoint, you will see an update to every object in the dataset. Effectively, when the pipeline runs right after the schema changes, you will pull all the objects and that one Delta pull will operate like a full pull.
Unfortunately, there is no workaround for this one. MGDC can only filter the top-level objects in the datasets, so there is no mechanism to filter out just the newly introduced “owner.email” property. Excluding the entire “owner” nested object also will not work, since that would also create a Delta change, in addition to excluding a potentially useful column.
As I mentioned, there will be no errors. This is just something to be aware of in case you are wondering why a particular Delta pull is showing more objects than expected on a specific date.
4. Conclusion
Microsoft Graph Data Connect schema changes don’t happen often and they are usually uneventful. However, I hope this post helps you address some uncommon issues related to these schema changes. For more information about MGDC for SharePoint, check the overview post at https://aka.ms/SharePointData.
Microsoft Tech Community – Latest Blogs –Read More