Tag Archives: microsoft
MS Universal Print Windows Sockets Error | error=10053
Hello,
I am trying to share queue made in MyQ solution into Universal Print but unfortunately after doing so I receive following error MS Universal Print Windows Sockets Error | error=10053, there is so sign of queue in Azure side and in MyQ status of queue is “Printer is being created in Azure”. Outbound connection to all necessary endpoints is allowed. Tls 1.2 is on. Any ideas what could be wrong?
Hello,I am trying to share queue made in MyQ solution into Universal Print but unfortunately after doing so I receive following error MS Universal Print Windows Sockets Error | error=10053, there is so sign of queue in Azure side and in MyQ status of queue is “Printer is being created in Azure”. Outbound connection to all necessary endpoints is allowed. Tls 1.2 is on. Any ideas what could be wrong? Read More
Issue with coauthoring in pages – The file (SharePoint Page) is locked for shared use by “User”
We have a custom SPFx web part added to our SharePoint pages. When users enter the required information and click on ‘Save as draft’ or ‘Submit for approval’ (with Power Automate enabled for the approval process), the information should save to the respective columns (page properties) in Site Pages, using REST API for data storage. Until yesterday, it worked fine, but since the rollout of coauthoring on site pages, we are encountering an error: “The file (SharePoint Page) is locked for shared use by ‘User’,” even though the user encountering the error is the one who edited the page.
We have a custom SPFx web part added to our SharePoint pages. When users enter the required information and click on ‘Save as draft’ or ‘Submit for approval’ (with Power Automate enabled for the approval process), the information should save to the respective columns (page properties) in Site Pages, using REST API for data storage. Until yesterday, it worked fine, but since the rollout of coauthoring on site pages, we are encountering an error: “The file (SharePoint Page) is locked for shared use by ‘User’,” even though the user encountering the error is the one who edited the page. Read More
Sharepoint list Status column
I have a sharepoint list with a status column. It has “not Started”, ” In Work”, “In Transit”, and “Complete”. I need a way to lock them in order so a step is not skipped. Any ideas on how I can do this?
I have a sharepoint list with a status column. It has “not Started”, ” In Work”, “In Transit”, and “Complete”. I need a way to lock them in order so a step is not skipped. Any ideas on how I can do this? Read More
Prompt to help me to find available slots for a meeting
Hello,
I try this prompt
Please identify two available time slots before the end of August 2024 for a 1-hour meeting with X and Y.
The slots should align with their working hours, respective time zones, and avoid any scheduling
conflicts.
However, the outcomes are not always consistent, and I typically have two types of responses:
-I have two time slots as options, but not everyone is available, or the time zone check was not considered.
Based on the available information, I have identified two potential time slots for a 1-hour meeting with X and Y before the end of August 2024:
* Thursday, August 10th at 9:00 AM CEST (X’s local time), which corresponds to Thursday,
August 10th at 3:00 AM EDT (Y’s local time)
* Tuesday, August 22nd at 4:00 PM CEST (X’s local time), which corresponds to Tuesday,
August 22nd at 10:00 AM EDT (Y’s local time).
– I received this
I’m sorry, but I couldn’t find specific availability information for X and Y before the end of August 2024.
To identify two available time slots for a 1-hour meeting, I recommend using the scheduling feature within Microsoft 365
to view their calendars and find slots that align with your working hours and time zones. If you need assistance with
scheduling or using the features, please let me know how I can help further.
Could you suggest a rewording of the Prompt or help me understand the answers?
Thanks
Matthieu
Hello, I try this prompt Please identify two available time slots before the end of August 2024 for a 1-hour meeting with X and Y. The slots should align with their working hours, respective time zones, and avoid any scheduling conflicts.However, the outcomes are not always consistent, and I typically have two types of responses:-I have two time slots as options, but not everyone is available, or the time zone check was not considered.Based on the available information, I have identified two potential time slots for a 1-hour meeting with X and Y before the end of August 2024:* Thursday, August 10th at 9:00 AM CEST (X’s local time), which corresponds to Thursday, August 10th at 3:00 AM EDT (Y’s local time)* Tuesday, August 22nd at 4:00 PM CEST (X’s local time), which corresponds to Tuesday, August 22nd at 10:00 AM EDT (Y’s local time).- I received this I’m sorry, but I couldn’t find specific availability information for X and Y before the end of August 2024. To identify two available time slots for a 1-hour meeting, I recommend using the scheduling feature within Microsoft 365 to view their calendars and find slots that align with your working hours and time zones. If you need assistance with scheduling or using the features, please let me know how I can help further.Could you suggest a rewording of the Prompt or help me understand the answers?Thanks Matthieu Read More
Combine two queries
I need to combine these two queries to receive one result:
Here is the first query
with cte as (
select ID,
assessmentdate,
Jurisdiction,
name,
studentid,
submitdate,
count(*) over (partition by studentid) as dup_count
from tblTest
)
Select m.assessmenttype, Count(m.studentid) As referredforassessment
From tblProfile m
Inner Join cte s on
m.studentid = s.studentid
Where dup_count > 1
and s.SubmitDate between ’06/01/2024′ and ’06/30/2024′
and countyid = 6
Group by assessmenttype
Order by assessmenttype
Here are the results from this query:
assessmenttype
referredforassessment
2
3
3
1
7
1
Here is the second query:
select assessmenttype,
SUM(CASE WHEN referredforassessment = 1 THEN 1 ELSE 0 END) as referredforassessment
from tblProfile
where SUBMITDATE >= ’06/01/2024′ and SUBMITDATE < ’06/30/2024′ and countyid = 6
Group By assessmenttype
order by assessmenttype
Here are the results from the second query:
assessmenttype
referredforassessment
2
2
4
1
Here are my desired results:
assessmenttype
referredforassessment
2
5
3
1
4
1
7
1
I need to combine these two queries to receive one result: Here is the first query with cte as (
select ID,
assessmentdate,
Jurisdiction,
name,
studentid,
submitdate,
count(*) over (partition by studentid) as dup_count
from tblTest
)
Select m.assessmenttype, Count(m.studentid) As referredforassessment
From tblProfile m
Inner Join cte s on
m.studentid = s.studentid
Where dup_count > 1
and s.SubmitDate between ’06/01/2024′ and ’06/30/2024′
and countyid = 6
Group by assessmenttype
Order by assessmenttype Here are the results from this query:assessmenttypereferredforassessment233171 Here is the second query:select assessmenttype,
SUM(CASE WHEN referredforassessment = 1 THEN 1 ELSE 0 END) as referredforassessment
from tblProfile
where SUBMITDATE >= ’06/01/2024′ and SUBMITDATE < ’06/30/2024′ and countyid = 6
Group By assessmenttype
order by assessmenttype Here are the results from the second query: assessmenttypereferredforassessment2241 Here are my desired results: assessmenttypereferredforassessment25314171 Read More
Getting the Most Filled Out Cells to the Top – Sort and Filter
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet.
For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet.
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet. For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet. Read More
FabSoft, Just Software, and Volo offer transactable partner solutions in Azure Marketplace
Microsoft partners like FabSoft, Just Software, and Volo deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:
DeskConnect: Deliver Documents to Azure OpenAI: Automatically capture and redistribute all transactional documents involving user-level interaction and input with DeskConnect so you can eliminate costly disruptions from customers, vendors, and staff. This powerful solution from FabSoft transforms a tedious manual process into an automated knowledge base.
EasyScep: One-click PKI for Intune Endpoint Certificates: If you need a streamlined, cost-effective public key infrastructure (PKI) solution for Microsoft Intune, EasyScep from Just Software is a hassle-free way to manage WiFi and VPN certificates. Its simple configuration process and straightforward pricing let you easily improve your security without complicating your infrastructure or adding daily management tasks. EasyScep supports all devices managed by Intune, including Windows, iOS, and Android.
Volo SaaS: Cloud Foundations (Landing Zone and Shared Services): Volo automates the setup and maintenance of well-configured, up-to-date cloud landing zones and shared services without the need to hire outside experts. Reduce cloud management costs by up to 70 percent while ensuring compliance and remaining in full control of your environment.
Microsoft Tech Community – Latest Blogs –Read More
Nuget Package problem while creating a .Net MAUI application
Everytime I try to create a .net maui app, I get this error (NU1008) i am unable to fix it. can anyone help me….
Error (active) NU1008 :Projects that use central package version management should not define the version on the PackageReference items but on the PackageVersion items: Microsoft.Maui.Controls;Microsoft.Maui.Controls.Compatibility;Microsoft.Extensions.Logging.Debug.
Everytime I try to create a .net maui app, I get this error (NU1008) i am unable to fix it. can anyone help me….Error (active) NU1008 :Projects that use central package version management should not define the version on the PackageReference items but on the PackageVersion items: Microsoft.Maui.Controls;Microsoft.Maui.Controls.Compatibility;Microsoft.Extensions.Logging.Debug. Read More
Calculating COGS through FIFO method
I am trying to create an excel sheet for a small business. I have calculated and linked most of it however in order to accurately calculate the cost of goods sold, I have to use a method called FIFO method (First in first out). For example if I purchase 300 units of item A at 300,000 and 500 units of items A at a later date for 450,000, so when I sell 350 units, it is basically 300 units @ 300,000/300 and remining 50 units @ 450,000/500. Now there are multiple issues doing this in excel.
1. before anything I have to match the product code (column D)
2. I have to see that the cost of goods sold (column K) first calculates cost based on the oldest purchase and after that if needed the next purchase and so on.
3. I have to make sure that the next time I make sale, it also accounts for the previous sale as the oldest purchase might already be accounted for in a previous sale.
I looked for an attachment button but couldn’t find one so here is my sheet
S.no at column B, Purchase Date at column C, ARTICLE CODE at column D, Purchase units at column E, Purchase price at column F, Transport Expense at column G, Cost of Goods Purchased at column H, Sale Date at column I, Units Sold at column J, Cost of Goods Sold at column K.
Reading it back I realized that I have not written this in the simplest terms. Let’s hope you guys understand.
I am trying to create an excel sheet for a small business. I have calculated and linked most of it however in order to accurately calculate the cost of goods sold, I have to use a method called FIFO method (First in first out). For example if I purchase 300 units of item A at 300,000 and 500 units of items A at a later date for 450,000, so when I sell 350 units, it is basically 300 units @ 300,000/300 and remining 50 units @ 450,000/500. Now there are multiple issues doing this in excel.1. before anything I have to match the product code (column D)2. I have to see that the cost of goods sold (column K) first calculates cost based on the oldest purchase and after that if needed the next purchase and so on.3. I have to make sure that the next time I make sale, it also accounts for the previous sale as the oldest purchase might already be accounted for in a previous sale. I looked for an attachment button but couldn’t find one so here is my sheetS.no at column B, Purchase Date at column C, ARTICLE CODE at column D, Purchase units at column E, Purchase price at column F, Transport Expense at column G, Cost of Goods Purchased at column H, Sale Date at column I, Units Sold at column J, Cost of Goods Sold at column K. Reading it back I realized that I have not written this in the simplest terms. Let’s hope you guys understand. Read More
Access to subscription resources.
Hello,
I want to ask you all about subscription access for users outside.
The idea is to split our Azure subscription from one global to one per coutry. We are going to do some stuff there but we might need to give access to resources for employes from other countries to ex. show them what we did, how it works and let them play with it.
Example:
Right now we are doing some R&D on global account but it will be much better to have our own for each country. In future, we might need to share access to that environment/product etc. to other employes outside our subscription.
Why?
We want to have some kind of indicator which will tell us how many hours/connections was done and all that stuff.
Why not resource group?
It will be much easier to just give access to “our” own Azure env rather than specifying roles, telling what to edit and what not etc. We have some production stuff there etc…
So, is it possible to give access to these resources for employes from other subscriptions with “full” functionality of resources inside? Can connections to VM’s or Kube clusters will be possible?
Thank you!
Hello,I want to ask you all about subscription access for users outside. The idea is to split our Azure subscription from one global to one per coutry. We are going to do some stuff there but we might need to give access to resources for employes from other countries to ex. show them what we did, how it works and let them play with it. Example:Right now we are doing some R&D on global account but it will be much better to have our own for each country. In future, we might need to share access to that environment/product etc. to other employes outside our subscription. Why?We want to have some kind of indicator which will tell us how many hours/connections was done and all that stuff. Why not resource group?It will be much easier to just give access to “our” own Azure env rather than specifying roles, telling what to edit and what not etc. We have some production stuff there etc… So, is it possible to give access to these resources for employes from other subscriptions with “full” functionality of resources inside? Can connections to VM’s or Kube clusters will be possible? Thank you! Read More
Channel connectors not loading
Hello there,
we are using a connector to get a notification about new Azure DevOps Pull Requests to a Microsoft Teams channel. Since these connectors are deprecating soon, we wrote an PowerAutomate flow to replace the old one.
We now finished the new flow and want to remove the old connector. But unfortunately the list of configured connectors for the channel is not loading – no matter if I try to access it in the installed app or in different browsers on different operating systems. The lists for adding new connectors work, but “Configured” and “My Accounts” does not.
I already cleared the cache of Teams, I also installed new browsers (on MacOS and on Windows systems), but the list is always empty.
Does someone have any tips how to remove the old connector?
Hello there, we are using a connector to get a notification about new Azure DevOps Pull Requests to a Microsoft Teams channel. Since these connectors are deprecating soon, we wrote an PowerAutomate flow to replace the old one. We now finished the new flow and want to remove the old connector. But unfortunately the list of configured connectors for the channel is not loading – no matter if I try to access it in the installed app or in different browsers on different operating systems. The lists for adding new connectors work, but “Configured” and “My Accounts” does not. I already cleared the cache of Teams, I also installed new browsers (on MacOS and on Windows systems), but the list is always empty. Does someone have any tips how to remove the old connector? Read More
SharePoint Public Folder URL
Hi,
We are looking to create a public (anonymous/unauthenticated) access to a document library. The library resides on a separate SharePoint site that will only contain the public documents.
When I share the document library using the anonymous link, I can access the document library without issue and then navigate around the available folders.
However, we want to be able to add URL parameters into the anonymous link so that upon someone clicking the link they are taken to a specific folder within the library.
i.e. I want to be taken straight to the folder called ‘Test’ within the ‘PublicDocuments’ document library
ourtenant.sharepoint.com/:f:/s/publicsite/EqabcMvYN1tFq7oiQXAg2VoBnPDpAyk66HKeem9UBSco4g/PublicDocuments/Test
If I use the normal path it requires a login i.e. ourtenant.sharepoint.com/sites/publicsite/Shared%20Documents/PublicDocuments/test
Has anyone found a way of doing this?
Hi, We are looking to create a public (anonymous/unauthenticated) access to a document library. The library resides on a separate SharePoint site that will only contain the public documents. When I share the document library using the anonymous link, I can access the document library without issue and then navigate around the available folders. However, we want to be able to add URL parameters into the anonymous link so that upon someone clicking the link they are taken to a specific folder within the library. i.e. I want to be taken straight to the folder called ‘Test’ within the ‘PublicDocuments’ document library ourtenant.sharepoint.com/:f:/s/publicsite/EqabcMvYN1tFq7oiQXAg2VoBnPDpAyk66HKeem9UBSco4g/PublicDocuments/Test If I use the normal path it requires a login i.e. ourtenant.sharepoint.com/sites/publicsite/Shared%20Documents/PublicDocuments/test Has anyone found a way of doing this? Read More
Missing client protocols
Hello everyone,
I have a problem with one of my two SQL Server instances.
The client protocols are missing for one of the instances. You can actually add these there (see To enable or disable a client protocol ) but unfortunately the Properties entry is missing (see image below).
I have never had this before. Does anyone have any ideas?
Thanks in advance,
Frank
Hello everyone,I have a problem with one of my two SQL Server instances. The client protocols are missing for one of the instances. You can actually add these there (see To enable or disable a client protocol ) but unfortunately the Properties entry is missing (see image below). I have never had this before. Does anyone have any ideas? Thanks in advance,Frank Read More
Change colour of text in whole row when 1 cell is negative %
Hello
I’m wondering if there is a way of changing the colour of text in a whole row when one of the cells is a negative %.
I’ve tried various conditional formatting using the <0 but that didn’t work.
Be glad if someone could help.
Thanks
HelloI’m wondering if there is a way of changing the colour of text in a whole row when one of the cells is a negative %.I’ve tried various conditional formatting using the <0 but that didn’t work.Be glad if someone could help.Thanks Read More
What’s my Best way to return a data value – Xlookup or Index/Match ?
What’s my Best way to return a data value –
Hello what’s my best way to return a value based on multiple criteria?
X lookup or Index/Match ?
I have the sample data sheets below
I need Column ‘R’ in ‘sample data master’ to look at column ‘g’ and column ‘d’ in ‘sample data master’ and look into ‘Sample data 1 lookup’ against column ‘d’ and ‘e’ and return column ‘h’ in ‘Sample data 1 lookup’
Happy to use any formula that does this – so just asking for help
What’s my Best way to return a data value – Hello what’s my best way to return a value based on multiple criteria? X lookup or Index/Match ? I have the sample data sheets below I need Column ‘R’ in ‘sample data master’ to look at column ‘g’ and column ‘d’ in ‘sample data master’ and look into ‘Sample data 1 lookup’ against column ‘d’ and ‘e’ and return column ‘h’ in ‘Sample data 1 lookup’ Happy to use any formula that does this – so just asking for help Read More
Font changes each time I move cells. how do I stop it?
Font changes each time I move cells. Changes from Arial Narrow to Aptos. Reset it in Account and on the header but it still swaps back when I change cells. Any advice?
Font changes each time I move cells. Changes from Arial Narrow to Aptos. Reset it in Account and on the header but it still swaps back when I change cells. Any advice? Read More
Disable reschedule option/remove button from email
Hi, I’ve seen several posts requesting a solution for this but none have been provided. One post recommended going to the ‘customer actions’ section but there isn’t one available. Can anyone tell me how to disable the ‘reschedule’ option in confirmation emails please? It seems Teams is imprinting the original staff member as the organiser on the rescheduled meeting, which means the only way they can be removed is by creating a new meeting.
Hi, I’ve seen several posts requesting a solution for this but none have been provided. One post recommended going to the ‘customer actions’ section but there isn’t one available. Can anyone tell me how to disable the ‘reschedule’ option in confirmation emails please? It seems Teams is imprinting the original staff member as the organiser on the rescheduled meeting, which means the only way they can be removed is by creating a new meeting. Read More
Query group fields into one
Hi
I’m new to the community… forgive me if I’m not precise.
I’m looking for the best way to write a SQL query for MS Access, capable of obtaining the grouping of the values contained in the same field, but in different rows, and having the same key (not primary).
I have 3 rows with the same key (i.e. “1234”)each row has a precise text value in the “Field” field (Water, Earth and Air)
I would like to create a SQL query that results in a single row, with the concatenation of the contents of the “Field” fields.
1234Water1234Earth1234Air
I want a query result like this
1234Water, Earth, Air
also taking into account the fact that there can be NULL values.
Can you help me?
Thanks in advance
HiI’m new to the community… forgive me if I’m not precise.I’m looking for the best way to write a SQL query for MS Access, capable of obtaining the grouping of the values contained in the same field, but in different rows, and having the same key (not primary).I have 3 rows with the same key (i.e. “1234”)each row has a precise text value in the “Field” field (Water, Earth and Air)I would like to create a SQL query that results in a single row, with the concatenation of the contents of the “Field” fields.1234Water1234Earth1234AirI want a query result like this1234Water, Earth, Airalso taking into account the fact that there can be NULL values.Can you help me?Thanks in advance Read More