Category: News
Drive Encryption through Endpoint Security no longer showing option to backup information in Entra
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug?
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug? Read More
Improve your forms with Copilot suggestions
Copilot has always been helpful at crafting forms and fine-tuning questions. Now, it also serves as an intelligent assistant throughout your journey, offering additional smart suggestions. By using these tips, you can make your form/quiz more attractive and easier to complete, leading to better results with less effort. Let’s check it now!
Apply Copilot suggestions
How to activate
For any newly created or existing forms/quizzes, a banner at the top will remind you that Copilot has suggestions for you. You can just click ‘View’ to check the details.
Copilot suggestions on the top of a form
Theme suggestion
Responder’s first impression of your form is crucial, and a visually appealing design can certainly capture their attention. Copilot will start by offering several theme options based on your topic, helping you choose a look that grabs their interest.
Copilot suggestions – theme
Setting suggestion
Based on your content, Copilot will suggest settings to make your form more effective. For example, it might remind you to allow responders to save and edit their responses for more accurate feedback or set a timer for improved time management.
Copilot suggestions – settings
Distribution suggestion
Additionally, Copilot will guide you through sending out your form to help you gather more responses. Without needing to open ‘Collect Responses,’ Copilot will draft a personalized message to boost responses and help set the appropriate permissions. You only need to enter the responders’ details and send out the form.
Copilot suggestions – distribution
Copilot in Forms assistant will start rolling out to commercial users (including Enterprise, SMB and EDU) in late July 2024. A Copilot for Microsoft 365 license is required to access Copilot in Forms. Discover more about Copilot for Microsoft 365 here.
Microsoft Tech Community – Latest Blogs –Read More
How to iteratively go through a structure?
I have some data from 100 different tests that I ran. There are 2 variables that were swept through for 10 values each, resulting in 100 tests (i.e. variable 1 is A with 10 elements, variable 2 is B with 10 elements, my test data is from all the permutations of A and B). A few timeseries measurements are made for each test. I have my data saved in a structure like:
Data.A1.B1.meas1
Data.A1.B1.meas2
%…
Data.A1.B1.measN
Data.A1.B2.meas1
Data.A1.B2.meas2
%…
Data.A2.B1.meas1
%…
Data.A10.B10.measN
I need to take the mean of the timeseries data for each test. Is there some way to set up a loop such that I can easily iterate through the struct to do this? Some thing like:
for i = 1:10
for j = 1:10
DataMean = mean(Data.A(i).B(j).meas1)
end
end
Is there a more efficient way to structure the data to make this easier?I have some data from 100 different tests that I ran. There are 2 variables that were swept through for 10 values each, resulting in 100 tests (i.e. variable 1 is A with 10 elements, variable 2 is B with 10 elements, my test data is from all the permutations of A and B). A few timeseries measurements are made for each test. I have my data saved in a structure like:
Data.A1.B1.meas1
Data.A1.B1.meas2
%…
Data.A1.B1.measN
Data.A1.B2.meas1
Data.A1.B2.meas2
%…
Data.A2.B1.meas1
%…
Data.A10.B10.measN
I need to take the mean of the timeseries data for each test. Is there some way to set up a loop such that I can easily iterate through the struct to do this? Some thing like:
for i = 1:10
for j = 1:10
DataMean = mean(Data.A(i).B(j).meas1)
end
end
Is there a more efficient way to structure the data to make this easier? I have some data from 100 different tests that I ran. There are 2 variables that were swept through for 10 values each, resulting in 100 tests (i.e. variable 1 is A with 10 elements, variable 2 is B with 10 elements, my test data is from all the permutations of A and B). A few timeseries measurements are made for each test. I have my data saved in a structure like:
Data.A1.B1.meas1
Data.A1.B1.meas2
%…
Data.A1.B1.measN
Data.A1.B2.meas1
Data.A1.B2.meas2
%…
Data.A2.B1.meas1
%…
Data.A10.B10.measN
I need to take the mean of the timeseries data for each test. Is there some way to set up a loop such that I can easily iterate through the struct to do this? Some thing like:
for i = 1:10
for j = 1:10
DataMean = mean(Data.A(i).B(j).meas1)
end
end
Is there a more efficient way to structure the data to make this easier? structures, loops MATLAB Answers — New Questions
Save numbers after text pattern in a vector
Dear all
I have a text file that looks like these:
#——————————————————
# Atomistic spin configuration file for vampire v5+
#——————————————————
# Date: Wed Jul 31 19:19:54 2024
#——————————————————
Time: 1e-15
Field: 0 0 0
Temperature: 0.05
Magnetisation: -0.999883 0.0152572 -0.000478932
#——————————————————
Number of spin files: 1
spins-00000000.data
#——————————————————
I am interested in saving in an array the three numerical values after "Field:". I have tried something like
field_str=regexp(meta_file_read,'(?<=^TField:s+)(S+)s*(S+)s*(S+)’,’match’,’lineanchors’); % T
But the cell seems to be empty.
Any ideas?Dear all
I have a text file that looks like these:
#——————————————————
# Atomistic spin configuration file for vampire v5+
#——————————————————
# Date: Wed Jul 31 19:19:54 2024
#——————————————————
Time: 1e-15
Field: 0 0 0
Temperature: 0.05
Magnetisation: -0.999883 0.0152572 -0.000478932
#——————————————————
Number of spin files: 1
spins-00000000.data
#——————————————————
I am interested in saving in an array the three numerical values after "Field:". I have tried something like
field_str=regexp(meta_file_read,'(?<=^TField:s+)(S+)s*(S+)s*(S+)’,’match’,’lineanchors’); % T
But the cell seems to be empty.
Any ideas? Dear all
I have a text file that looks like these:
#——————————————————
# Atomistic spin configuration file for vampire v5+
#——————————————————
# Date: Wed Jul 31 19:19:54 2024
#——————————————————
Time: 1e-15
Field: 0 0 0
Temperature: 0.05
Magnetisation: -0.999883 0.0152572 -0.000478932
#——————————————————
Number of spin files: 1
spins-00000000.data
#——————————————————
I am interested in saving in an array the three numerical values after "Field:". I have tried something like
field_str=regexp(meta_file_read,'(?<=^TField:s+)(S+)s*(S+)s*(S+)’,’match’,’lineanchors’); % T
But the cell seems to be empty.
Any ideas? text patterns MATLAB Answers — New Questions
how to make subscripts in plot labeling
Hello
I have a plot as shown below. However i wantet to make the x and y labeling in subscript
forexample in the x and y label 1 next to K should be subscripted
Thank you for your helpHello
I have a plot as shown below. However i wantet to make the x and y labeling in subscript
forexample in the x and y label 1 next to K should be subscripted
Thank you for your help Hello
I have a plot as shown below. However i wantet to make the x and y labeling in subscript
forexample in the x and y label 1 next to K should be subscripted
Thank you for your help labeling MATLAB Answers — New Questions
Standalone App will not install without internet
I am trying to run the installer for a standalone app that was compiled with the option to download runtime engine from web. However what I would like to do is have the runtime engine installed on the target computer in advance. This computer is not connected to the internet. When I try to run the app installer on this computer, I get an error since the computer is not connected to the internet. It does not even try to check if the runtime engine is already installed on the computer.
I don’t want to compile the installer that contains the runtime engine, since that is a very large file and takes a long time to compile each time. Is there a way to configure the app installer so that
1) I don’t need to include the entire runtime engine with it
2) The target computer does not need to be connected to the internet during installation?I am trying to run the installer for a standalone app that was compiled with the option to download runtime engine from web. However what I would like to do is have the runtime engine installed on the target computer in advance. This computer is not connected to the internet. When I try to run the app installer on this computer, I get an error since the computer is not connected to the internet. It does not even try to check if the runtime engine is already installed on the computer.
I don’t want to compile the installer that contains the runtime engine, since that is a very large file and takes a long time to compile each time. Is there a way to configure the app installer so that
1) I don’t need to include the entire runtime engine with it
2) The target computer does not need to be connected to the internet during installation? I am trying to run the installer for a standalone app that was compiled with the option to download runtime engine from web. However what I would like to do is have the runtime engine installed on the target computer in advance. This computer is not connected to the internet. When I try to run the app installer on this computer, I get an error since the computer is not connected to the internet. It does not even try to check if the runtime engine is already installed on the computer.
I don’t want to compile the installer that contains the runtime engine, since that is a very large file and takes a long time to compile each time. Is there a way to configure the app installer so that
1) I don’t need to include the entire runtime engine with it
2) The target computer does not need to be connected to the internet during installation? app designer, compiler MATLAB Answers — New Questions
Showing the error “Variable nDimes has an incorrect value”
For this problem your code will need to do the following:
Accurately determine the number of each coin type present. Use variable names nDimes, nNickels, nQuarters, and nFiftyCents.
Calculate the total $ value of coins present. Use variable name USD
The code:
testImageIdx = randi([1,3]);
testCoinImage = imread("testCoinImage" + testImageIdx + ".png");
imshow(testCoinImage);
title("Original Coin Image");
[testcoinMask, MaskedtestCoin] = segmentCoin(testCoinImage);
se = strel(‘disk’, 20, 0);
testCoinMask = imfill(testcoinMask, ‘holes’);
testCoinMask = imerode(testcoinMask, se);
imgFilt = imgaussfilt(MaskedtestCoin, 0.5, ‘Padding’, "circular", ‘FilterDomain’, "frequency", ‘FilterSize’, 3);
faceEdgeMask = edge(imgFilt, "sobel", 0.05, "both");
faceEdgeMask(~testcoinMask) = false;
imshow(faceEdgeMask);
title("Edge Mask Detection for Valid Coins");
see = strel("disk", 25, 0);
fb = imfill(faceEdgeMask, "holes");
Bw2 = imdilate(fb, see);
validCoinMask = Bw2 & testcoinMask;
set = strel("disk", 2, 0);
validCoinMask = imdilate(validCoinMask, set);
montage({testcoinMask, validCoinMask});
title("testcoinMask vs ValidCoinMask");
coinSizes = regionprops("table", validCoinMask, "Area");
nDimes = coinSizes.Area < 1100;
nDimes = sum(nDimes);
nNickels = (coinSizes.Area > 1100 & coinSizes.Area < 2200);
nNickels = sum(nNickels);
nQuarters = (coinSizes.Area > 2200 & coinSizes.Area < 3200);
nQuarters = sum(nQuarters);
nFiftyCents = coinSizes.Area >= 3200;
nFiftyCents = sum(nFiftyCents);
USD = (nDimes * 0.10) + (nNickels * 0.05) + (nQuarters * 0.25) + (nFiftyCents * 0.50);
function [testcoinMask, MaskedtestCoin] = segmentCoin(X)
X = im2gray(X);
testcoinMask = im2gray(X) > 150;
radius = 12;
decomp = 4;
se = strel(‘disk’, radius, decomp);
testcoinMask = imclose(testcoinMask, se);
MaskedtestCoin = X;
MaskedtestCoin(~testcoinMask) = 0;
endFor this problem your code will need to do the following:
Accurately determine the number of each coin type present. Use variable names nDimes, nNickels, nQuarters, and nFiftyCents.
Calculate the total $ value of coins present. Use variable name USD
The code:
testImageIdx = randi([1,3]);
testCoinImage = imread("testCoinImage" + testImageIdx + ".png");
imshow(testCoinImage);
title("Original Coin Image");
[testcoinMask, MaskedtestCoin] = segmentCoin(testCoinImage);
se = strel(‘disk’, 20, 0);
testCoinMask = imfill(testcoinMask, ‘holes’);
testCoinMask = imerode(testcoinMask, se);
imgFilt = imgaussfilt(MaskedtestCoin, 0.5, ‘Padding’, "circular", ‘FilterDomain’, "frequency", ‘FilterSize’, 3);
faceEdgeMask = edge(imgFilt, "sobel", 0.05, "both");
faceEdgeMask(~testcoinMask) = false;
imshow(faceEdgeMask);
title("Edge Mask Detection for Valid Coins");
see = strel("disk", 25, 0);
fb = imfill(faceEdgeMask, "holes");
Bw2 = imdilate(fb, see);
validCoinMask = Bw2 & testcoinMask;
set = strel("disk", 2, 0);
validCoinMask = imdilate(validCoinMask, set);
montage({testcoinMask, validCoinMask});
title("testcoinMask vs ValidCoinMask");
coinSizes = regionprops("table", validCoinMask, "Area");
nDimes = coinSizes.Area < 1100;
nDimes = sum(nDimes);
nNickels = (coinSizes.Area > 1100 & coinSizes.Area < 2200);
nNickels = sum(nNickels);
nQuarters = (coinSizes.Area > 2200 & coinSizes.Area < 3200);
nQuarters = sum(nQuarters);
nFiftyCents = coinSizes.Area >= 3200;
nFiftyCents = sum(nFiftyCents);
USD = (nDimes * 0.10) + (nNickels * 0.05) + (nQuarters * 0.25) + (nFiftyCents * 0.50);
function [testcoinMask, MaskedtestCoin] = segmentCoin(X)
X = im2gray(X);
testcoinMask = im2gray(X) > 150;
radius = 12;
decomp = 4;
se = strel(‘disk’, radius, decomp);
testcoinMask = imclose(testcoinMask, se);
MaskedtestCoin = X;
MaskedtestCoin(~testcoinMask) = 0;
end For this problem your code will need to do the following:
Accurately determine the number of each coin type present. Use variable names nDimes, nNickels, nQuarters, and nFiftyCents.
Calculate the total $ value of coins present. Use variable name USD
The code:
testImageIdx = randi([1,3]);
testCoinImage = imread("testCoinImage" + testImageIdx + ".png");
imshow(testCoinImage);
title("Original Coin Image");
[testcoinMask, MaskedtestCoin] = segmentCoin(testCoinImage);
se = strel(‘disk’, 20, 0);
testCoinMask = imfill(testcoinMask, ‘holes’);
testCoinMask = imerode(testcoinMask, se);
imgFilt = imgaussfilt(MaskedtestCoin, 0.5, ‘Padding’, "circular", ‘FilterDomain’, "frequency", ‘FilterSize’, 3);
faceEdgeMask = edge(imgFilt, "sobel", 0.05, "both");
faceEdgeMask(~testcoinMask) = false;
imshow(faceEdgeMask);
title("Edge Mask Detection for Valid Coins");
see = strel("disk", 25, 0);
fb = imfill(faceEdgeMask, "holes");
Bw2 = imdilate(fb, see);
validCoinMask = Bw2 & testcoinMask;
set = strel("disk", 2, 0);
validCoinMask = imdilate(validCoinMask, set);
montage({testcoinMask, validCoinMask});
title("testcoinMask vs ValidCoinMask");
coinSizes = regionprops("table", validCoinMask, "Area");
nDimes = coinSizes.Area < 1100;
nDimes = sum(nDimes);
nNickels = (coinSizes.Area > 1100 & coinSizes.Area < 2200);
nNickels = sum(nNickels);
nQuarters = (coinSizes.Area > 2200 & coinSizes.Area < 3200);
nQuarters = sum(nQuarters);
nFiftyCents = coinSizes.Area >= 3200;
nFiftyCents = sum(nFiftyCents);
USD = (nDimes * 0.10) + (nNickels * 0.05) + (nQuarters * 0.25) + (nFiftyCents * 0.50);
function [testcoinMask, MaskedtestCoin] = segmentCoin(X)
X = im2gray(X);
testcoinMask = im2gray(X) > 150;
radius = 12;
decomp = 4;
se = strel(‘disk’, radius, decomp);
testcoinMask = imclose(testcoinMask, se);
MaskedtestCoin = X;
MaskedtestCoin(~testcoinMask) = 0;
end image processing, image segmentation, image analysis MATLAB Answers — New Questions
Deleted Teams App still being looked for on startup
Hi Everyone, we have a puzzling one, we published and subsequently deleted an App from our Teams portal. all users now get a message saying that the app can’t be found and we’re struggling with how to remedy this. The app is 100% gone from the portal. we have tried uninstall and reinstall of teams including deleting the cache, but this has not helped at all. Has anyone any idea of where to look to resolve this one – I think there’s something somewhere in the teams portal but can’t fine anything.
Kind Regards
Pete
Hi Everyone, we have a puzzling one, we published and subsequently deleted an App from our Teams portal. all users now get a message saying that the app can’t be found and we’re struggling with how to remedy this. The app is 100% gone from the portal. we have tried uninstall and reinstall of teams including deleting the cache, but this has not helped at all. Has anyone any idea of where to look to resolve this one – I think there’s something somewhere in the teams portal but can’t fine anything. Kind Regards Pete Read More
Public preview checkbox keeps unchecking
Hi 🙂
When I tick the ‘Public preview’ box within settings, it is not clear if this instantly changes to the preview version or if it needs a restart. In Classic Teams, enabling public preview used to relaunch the app.
In addition, the checkbox also regularly shows as unticked. I suspect this is happening after Teams updates (which it does a few times a day sometimes).
Does anyone else notice this? I would like to stay in preview mode the majority of the time, but at the least until I choose to turn it off. With this current way of working I am often taken out of it without being notified.
Thanks,
Ian
Hi :)When I tick the ‘Public preview’ box within settings, it is not clear if this instantly changes to the preview version or if it needs a restart. In Classic Teams, enabling public preview used to relaunch the app. In addition, the checkbox also regularly shows as unticked. I suspect this is happening after Teams updates (which it does a few times a day sometimes). Does anyone else notice this? I would like to stay in preview mode the majority of the time, but at the least until I choose to turn it off. With this current way of working I am often taken out of it without being notified. Thanks,Ian Read More
Azure Devops Teams Notification
Hello Team,
I have recently added Azure Repo app to my dev release channel. I configured “@Azure Repos subscriptions” and added notification for when a Pull Request is created. Is there a way I can exclude draft Pull Requests from sending notifications?
Hello Team, I have recently added Azure Repo app to my dev release channel. I configured “@Azure Repos subscriptions” and added notification for when a Pull Request is created. Is there a way I can exclude draft Pull Requests from sending notifications? Read More
ADODB performance problem
Hi All, (Win10, Win11)
To highlight a performance problem (with ADODB/ACCESS), on a heavy client, I wrote two small programs one in VB.NET (and VBA), the other in CPP/MFC. Using the same component (msado15.dll).
This piece of code does nothing but connect to two ACCESS files (with a single table of 15,000 records), and via a recordset copy from one database to the other.
Under VB.NET, it takes 1 second.
Under CPP, on a machine that has the runtime access 2013 x64, it takes 9 seconds. (i spend 99% of my time in AddNew() )…
Under CPP, on a machine that has the runtime access 2016 x64 OR Office365, it takes 20 minutes. (i spend 99% of my time in AddNew() )…
The target computer must have Office365…
I need an issue…
PS : My two sln (exe/cpp/…) are available…There is no sensitive data…
A short running test…
|Nom de la fonction|Total [unit, %]|Self [unit, %]|Nombre d’appels|Module|
|-|-|-|-|-||*+*D:\users\phili\Downloads\Test_ADO_Cpp_VB\test_minimal\x64\Release\test.exe (PID : )|115,73s (100,00*%)|0ns (0,00*%)|0|Plusieurs modules|
||*+*__report_gsfailure|115,73s (100,00*%)|9,20?s (0,00*%)|1|test|
|||*+*__scrt_common_main_seh|115,73s (100,00*%)|13,20?s (0,00*%)|1|test|
||||*+*main|115,73s (100,00*%)|654,83ms (0,57*%)|1|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947bc40|104,82s (90,58*%)|104,82s (90,58*%)|6215|msado15| <= AddNew() !!!
|||||*-*[Native] ucrtbase.dll!0x00007fff373ccad0|9,31s (8,05*%)|9,31s (8,05*%)|1|ucrtbase|
|||||*-*ADODB::Connection15::Open|413,29ms (0,36*%)|8,80?s (0,00*%)|2|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947c010|101,83ms (0,09*%)|101,83ms (0,09*%)|2|msado15|
|||||*-*printf|96,90ms (0,08*%)|157,30?s (0,00*%)|214|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947d3d0|91,69ms (0,08*%)|91,69ms (0,08*%)|74568|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947d380|50,46ms (0,04*%)|50,46ms (0,04*%)|74568|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe894d8fc0|30,92ms (0,03*%)|30,92ms (0,03*%)|149136|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947bfc0|28,68ms (0,02*%)|28,68ms (0,02*%)|6214|msado15|
|||||*-*[Native] combase.dll!0x00007fff39403f10|26,94ms (0,02*%)|26,94ms (0,02*%)|5|combase|
|||||*-*[Native] msado15.dll!0x00007ffe89513fc0|17,39ms (0,02*%)|17,39ms (0,02*%)|149137|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe894c1480|15,11ms (0,01*%)|15,11ms (0,01*%)|1|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947c230|14,46ms (0,01*%)|14,46ms (0,01*%)|149137|msado15|
|||||*-Native]msado15.dll!0x00007ffe8947d2b0|11,32ms,01*%)|11,32ms,01*%)|149136|msado15|
Regards
Hi All, (Win10, Win11)To highlight a performance problem (with ADODB/ACCESS), on a heavy client, I wrote two small programs one in VB.NET (and VBA), the other in CPP/MFC. Using the same component (msado15.dll).This piece of code does nothing but connect to two ACCESS files (with a single table of 15,000 records), and via a recordset copy from one database to the other.Under VB.NET, it takes 1 second.Under CPP, on a machine that has the runtime access 2013 x64, it takes 9 seconds. (i spend 99% of my time in AddNew() )…Under CPP, on a machine that has the runtime access 2016 x64 OR Office365, it takes 20 minutes. (i spend 99% of my time in AddNew() )…The target computer must have Office365…I need an issue…PS : My two sln (exe/cpp/…) are available…There is no sensitive data…A short running test…|Nom de la fonction|Total [unit, %]|Self [unit, %]|Nombre d’appels|Module||-|-|-|-|-||*+*D:\users\phili\Downloads\Test_ADO_Cpp_VB\test_minimal\x64\Release\test.exe (PID : )|115,73s (100,00*%)|0ns (0,00*%)|0|Plusieurs modules|||*+*__report_gsfailure|115,73s (100,00*%)|9,20?s (0,00*%)|1|test||||*+*__scrt_common_main_seh|115,73s (100,00*%)|13,20?s (0,00*%)|1|test|||||*+*main|115,73s (100,00*%)|654,83ms (0,57*%)|1|test||||||*-*[Native] msado15.dll!0x00007ffe8947bc40|104,82s (90,58*%)|104,82s (90,58*%)|6215|msado15| <= AddNew() !!!|||||*-*[Native] ucrtbase.dll!0x00007fff373ccad0|9,31s (8,05*%)|9,31s (8,05*%)|1|ucrtbase||||||*-*ADODB::Connection15::Open|413,29ms (0,36*%)|8,80?s (0,00*%)|2|test||||||*-*[Native] msado15.dll!0x00007ffe8947c010|101,83ms (0,09*%)|101,83ms (0,09*%)|2|msado15||||||*-*printf|96,90ms (0,08*%)|157,30?s (0,00*%)|214|test||||||*-*[Native] msado15.dll!0x00007ffe8947d3d0|91,69ms (0,08*%)|91,69ms (0,08*%)|74568|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947d380|50,46ms (0,04*%)|50,46ms (0,04*%)|74568|msado15||||||*-*[Native] msado15.dll!0x00007ffe894d8fc0|30,92ms (0,03*%)|30,92ms (0,03*%)|149136|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947bfc0|28,68ms (0,02*%)|28,68ms (0,02*%)|6214|msado15||||||*-*[Native] combase.dll!0x00007fff39403f10|26,94ms (0,02*%)|26,94ms (0,02*%)|5|combase||||||*-*[Native] msado15.dll!0x00007ffe89513fc0|17,39ms (0,02*%)|17,39ms (0,02*%)|149137|msado15||||||*-*[Native] msado15.dll!0x00007ffe894c1480|15,11ms (0,01*%)|15,11ms (0,01*%)|1|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947c230|14,46ms (0,01*%)|14,46ms (0,01*%)|149137|msado15||||||*-Native]msado15.dll!0x00007ffe8947d2b0|11,32ms,01*%)|11,32ms,01*%)|149136|msado15|Regards Read More
Adjacent column formulas not updated correctly on power query refresh
I have a query that reads a few csv files. It’s a simple query. There are a couple thousand rows, but it’s not complicated.
That data is loaded into a table.
I then added columns in excel, adjacent to the table with formula. Fairly straight forward.
Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table.
I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction. One thing I’m wondering is the whether the formula structure is causing an issue. I am not using structured formlas, rather simply referencing cells.
I have a query that reads a few csv files. It’s a simple query. There are a couple thousand rows, but it’s not complicated.That data is loaded into a table.I then added columns in excel, adjacent to the table with formula. Fairly straight forward.Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table. I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction. One thing I’m wondering is the whether the formula structure is causing an issue. I am not using structured formlas, rather simply referencing cells. Read More
MS Bookings Calendars being viewable in Outlook Shared Calendars
The trouble we have is that we are unable to see/share the bookings calendars in the our Outlook calendars with stakeholders & managers. All employees go through O365 to the bookings page and enter the calendar from there to look at it. If we were able to see the MS Bookings page calendar where we usually select shared calendars to view them side by side would be a huge benefit.
Does anyone know if this is at all possible. Or anyone else having this challenge?
The trouble we have is that we are unable to see/share the bookings calendars in the our Outlook calendars with stakeholders & managers. All employees go through O365 to the bookings page and enter the calendar from there to look at it. If we were able to see the MS Bookings page calendar where we usually select shared calendars to view them side by side would be a huge benefit.Does anyone know if this is at all possible. Or anyone else having this challenge? Read More
Fraudulant use
Lately, I have been seeing email with my user name and an addition to it like below:
email address removed for privacy reasons email address removed for privacy reasons.S7S <email address removed for privacy reasons email address removed for privacy reasons.S7S>
I want to know how to stop this kind of garbage from sending me what can only be described as junk and phishing emails. I cannot block them because Outlook states I cannot block my email address removed for privacy reasons email even though it really isn’t my email.
Anyone else experiencing this kind of garbage?
Frustrated Long-Time User (If you couldn’t tell from my hotmail.com address),
Ray
Lately, I have been seeing email with my user name and an addition to it like below:email address removed for privacy reasons email address removed for privacy reasons.S7S <email address removed for privacy reasons email address removed for privacy reasons.S7S>I want to know how to stop this kind of garbage from sending me what can only be described as junk and phishing emails. I cannot block them because Outlook states I cannot block my email address removed for privacy reasons email even though it really isn’t my email. Anyone else experiencing this kind of garbage?Frustrated Long-Time User (If you couldn’t tell from my hotmail.com address),Ray Read More
Sharepoint Online – 4000 site permissions adjustment query
Hi everyone, im hoping for some recommendations/advice. We have around 4000 sharepoint sites for Devices that currently have a single document library named Projects and some sub-folders in there created using pnp site provisioning. Every site is identical.
The permissions are currently dynamic where by the Members group has a security group added that ensures all active licensed users can access.
We have a requirement to start provisioning new sites where by two of the folders within the Projects library will have custom permissions which means breaking the inheritance and then adding another security group in however from what i have read this is against best practices.
Also it doesn’t help us as this will then need doing on the 4000 existing sites and having that many sites to manage at a unique level seems very scary.
What can be done here to block access to a couple of folders at tenant level for so many sites without needing to break inheritance of permissions.
Or is there no way, would one alternative be to create a new master site where every “Device” was a document library in this site (Around 4000) then the two folders in there and have a security group then assigned to the root members of that site fixing the permission requirement.
Thankyou,
Hi everyone, im hoping for some recommendations/advice. We have around 4000 sharepoint sites for Devices that currently have a single document library named Projects and some sub-folders in there created using pnp site provisioning. Every site is identical. The permissions are currently dynamic where by the Members group has a security group added that ensures all active licensed users can access. We have a requirement to start provisioning new sites where by two of the folders within the Projects library will have custom permissions which means breaking the inheritance and then adding another security group in however from what i have read this is against best practices. Also it doesn’t help us as this will then need doing on the 4000 existing sites and having that many sites to manage at a unique level seems very scary. What can be done here to block access to a couple of folders at tenant level for so many sites without needing to break inheritance of permissions. Or is there no way, would one alternative be to create a new master site where every “Device” was a document library in this site (Around 4000) then the two folders in there and have a security group then assigned to the root members of that site fixing the permission requirement. Thankyou, Read More
Windows Insider Program Feedback Sign In
I am getting an error message “Can’t sign you in”, error code CAA20003 when accessing Windows Insider Program Feedback from Windows Update. I have Windows 11. I follow the prompt to check Outlook and acknowledge the request. This completes just fine. I also tried the feedback hub app from the website.
I am getting an error message “Can’t sign you in”, error code CAA20003 when accessing Windows Insider Program Feedback from Windows Update. I have Windows 11. I follow the prompt to check Outlook and acknowledge the request. This completes just fine. I also tried the feedback hub app from the website. Read More
Copy existing formulas into Advanced Formula Environment module?
I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.
I could copy & paste one at a time … but in some cases it would be onerous!
Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE:
The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image).
Am I missing something?
Thanks!
I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.I could copy & paste one at a time … but in some cases it would be onerous! Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE: The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image). Am I missing something? Thanks! Read More
MVP’s Favorite Content: Surface, Azure, Microsoft AI
In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.
SungKi Park, Windows and Devices MVP, Korea
Surface MVP showcase: Enabling commercial experiences on Surface – Microsoft Community Hub
“Introduce a joint blog article that provides accurate product information about Microsoft Surface, which provides both AI PC and Copilot PC, as well as insights from five Surface MVPs.”
*Relevant activities:
– Event/ FY24 Surface Partner Day: Post | LinkedIn
– Blog/ Surface Pro 10 for Business Product Review: “비즈니스용 서피스 프로10” AI PC 시대.. : 네이버블로그 (naver.com)
– Blog/ Surface Laptop 6 for Business Product Review: 비즈니스용 마이크로소프트 서피스 랩탑 6, A.. : 네이버블로그 (naver.com)
Hamid Sadeghpour Saleh, Microsoft Azure MVP, Azerbaijan
“Well Architected Framework is an important design framework to learn and make an architectural mindset out of it and having those best practices in the pocket!”
Mohamed Azarudeen Z, AI Platform MVP, India
Machine learning Archives | Microsoft AI Blogs
“The Microsoft AI Blogs is an invaluable resource that offers the latest insights on the forefront of artificial intelligence advancements. Covering a diverse array of topics, it delves into the transformative power of AI across multiple industries and its seamless integration within Microsoft’s ecosystem of products and services. as an AI- MVP, I suggest this to everyone to yearn learning AI.
The blog also explores the wider impact of AI on various industry landscapes, analyzing how this groundbreaking technology is revolutionizing business operations, fostering innovation, and significantly influencing individuals’ lives on a global scale.”
Tomoitsu Kusaba, Developer Technologies MVP, Japan
Generative AI for Beginners – Full Videos Series Released! (microsoft.com)
“This video provides a well-organized summary of what developers should learn about generative AI. By making it available in video format, it caters to those who prefer learning through text as well as those who prefer video. From an accessibility standpoint, this approach is excellent.”
(In Japanese: 生成AIについて開発者が学ぶべき事柄がよくまとまっています。動画で公開されたことで、テキストで学習したい方、動画で学習したい方それぞれに対応しアクセシビリティの観点から見ても素晴らしい対応と感じています。)
Microsoft Tech Community – Latest Blogs –Read More
Downloading Microsoft Store apps using Windows Package Manager
By: Carlos Britos and Jason Sandys – Principal Product Managers | Microsoft Intune
Offline apps is the last remaining significant function of the Microsoft Store for Business on its path to full retirement. Offline apps allows customers to download packaged apps from the Microsoft Store for Business or Education for distribution through alternate mechanisms like a Windows Provisioning Package.
With the impending retirement of the Microsoft Store for Business and Education on August 15, 2024, this offline apps functionality will also retire but the ability to download and distribute packaged apps from the Microsoft Store to devices with restricted connectivity to the Microsoft Store remains. For this reason, starting with version 1.8, Windows Package Manager (WinGet) added the capability to download packages from the Microsoft Store. Unless explicitly disabled, all Windows devices will have automatically updated to this version already. To check the version running locally, you can run winget –v from a command prompt. For troubleshooting guidance, see Debugging and troubleshooting issues with the WinGet tool.
Keep in mind that just as with offline applications from the Microsoft Store for Business and Education, the download feature in WinGet is limited to packaged apps where the publisher has permitted offline licensing and distribution for organizations. This is controlled by the app publisher, not Microsoft. All unpackaged apps published to the Microsoft Store are available for download.
Also note, packaged apps include UWP apps packaged in the AppX format as well as apps packaged in the MSIX format. Unpackaged apps include all Win32 apps packaged in an alternate format such as MSI or EXE.
Downloading a Microsoft Store app using WinGet
Using the WinGet command line interface (CLI) to download an app from the Microsoft Store is straight-forward. The following example walks through the download of the Microsoft Remote Desktop app. This is an app published by Microsoft and allows offline downloads. For more information on any of the below steps or information related to the new download option, please refer to the WinGet download command documentation. Note that WinGet leverages Delivery Optimization to download apps from the Microsoft Store.
Locate the package you wish to download using the WinGet CLI. This step is optional
if you already know the exact package name or ID of the desired package in which case you can skip directly to step 2 below.
winget search “remote desktop” –source MSStore
The result from running WinGet search for “remote desktop”.
Use the new download command line argument for the CLI along with the package ID previously returned. By default, files for the specified package are downloaded to the Downloads subfolder of the current user’s profile folder. To override this location, use the -d or –download-directory option on the WinGet command line.
winget download –id 9WZDNCRFJ3PS
Note: You can limit the scope of the downloaded package using additional filtering options on the WinGet command line, e.g., use -a or –architecture to only download content related to a specific OS architecture.
The result from running “WinGet download –id 9WZDNCRFJ3PS”.
Review the initial information shown and accept the agreements linked by pressing Y and then Enter. If the current account is not currently logged into Microsoft Entra, you will be presented with a standard Entra ID authentication prompt and must successfully authenticate to proceed. Additionally, the account used requires one of the following roles:
Global Administrator
User Administrator
License Administrator
The result from accepting the agreements.
WinGet creates a new folder in the default or specified download folder named for the package ID you specified and proceeds to download the packages and its dependencies to this subfolder. Additionally, WinGet retrieves a license for the package as all packaged apps from the Microsoft Store require a license.
The folder contents from using WinGet to download the Microsoft Remote Desktop application.
You can now use the downloaded package using your management tool of choice.
Installing a WinGet downloaded package in a Windows provisioning package
Using packages downloaded by WinGet within a Windows provisioning package allows you to install the downloaded apps while provisioning a Windows device for management by Microsoft Intune. To do this, follow these steps:
Download the Windows Configuration Designer (WCD) app from the Microsoft Store.
Launch WCD and choose the Provision desktop devices option on the Start page.
Provide a name and location for the project.
Provide information on the Set up device, Set up network, and Account Management pages as needed.
For the Add applications page, click Add an Application.
Provide the Application name, Installer path and License path for the application that you are adding.
Add all Required appx dependencies and click Add to finish. The following screenshot shows the completed Add applications page in WCD for Microsoft Remote Desktop including its x64 dependencies.
The ‘Add applications’ page in WCD completed for Microsoft Remote Desktop including x64 dependencies.
Complete the Add certificates page as needed and under the Finish step, select Create to complete the process.
Your provisioning package is now ready.
Installing a WinGet downloaded package using Intune
In general, we recommend using the built-in Intune functionality to distribute Microsoft Store apps to managed Windows devices. However, you can also use other device management tools to deploy packaged apps separately downloaded using WinGet download. Scenarios where you may consider this include the following:
Managed clients cannot access or are restricted from connecting to the Microsoft Store.
Strict app version control is required.
To use Intune for this, follow the steps at Add a Windows line-of-business app to Microsoft Intune. Note that managed Windows endpoints must be able to connect to the Microsoft license server to retrieve a license for any apps deployed this way as Intune has no built-in capability to do this. Additionally, Microsoft Store apps will automatically update from the Microsoft Store if devices have connectivity to the Microsoft Store and Automatic Store app updates is not disabled, regardless of the app deployment method.
By following these steps, you can effectively utilize WinGet and Intune to manage app deployments, ensuring all necessary licenses and dependencies are correctly handled. This approach facilitates a streamlined and controlled deployment process across managed Windows devices.
If you have any questions or feedback, leave a comment below or reach out to us on X @IntuneSuppTeam.
Microsoft Tech Community – Latest Blogs –Read More
Why did I get duplicate variables in my workspace after changing their names?
(I did solve this problem but I haven’t been able to repeat it. I hope it’s okay to ask here anyway because I am curious if anyone has an explanation. I will describe below what solved it and how I have tried to repeat it. Couldn’t find any threads describing this anywhere.)
I had a few variables in my script with names starting with capital letters that I wanted to change to lowercase first letters. For example I wanted to change "Flux_th" to "flux_th". See code example below with only the relevant lines from my script.
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
Flux_th = 42078172084928.6; % [neutrons/cm2/s]
I used the shift+enter function in matlab to change "Flux_th" to "flux_th" (same with the other variables).
I cleared my workspace, I ran the script (like below) and got BOTH "Flux_th" and "flux_th" in my workspace (they have the same value).
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
I tried changing back to capital letters on "Flux_th" and doing the same thing again but it still gave me duplicates.
I am pretty sure that I tried manually deleting the duplicates with capital letters in the workspace and then running the script, but that also gave me duplicates.
It happened again even after restarting matlab.
What DID actually solve the problem is the following sequence:
I cleared the workspace, then I ran this separate script that creates and saves the .mat files, that script looks like this:
%% Global nuclear data
%data for reactions
dataNucGlobal_reac = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["barn";"isotopefrac";"reference"]);
dataNucGlobal_reac(‘O16 (n,p) N16: s-f’, 🙂 = {2.026e-5, 99.76, "ENDL"};
save(‘dataNucGlobal_reac’)
%data for nuclides
dataNucGlobal_nuc = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["halflife_s"; "decayconst"; "reference"]);
dataNucGlobal_nuc(‘N16’, 🙂 = {7.12, log(2)/7.12, "?"};
save(‘dataNucGlobal_nuc’)
Then I ran my original script without the load lines like this:
% load(‘dataNucGlobal_nuc.mat’)
% load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
This time I did not get any duplicates, so I cleared my workspace again and reinserted the load lines and finally ran the script like this:
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
Now everything is working and I can’t reproduce what happened by changing variable names from capital to lowercase letters.
I am super confused because as you can see, the .mat-files DO NOT contain any of the variables that became duplicates, so it doesn’t make any sense that this would help. I have no idea what happened so that is why I am asking here.(I did solve this problem but I haven’t been able to repeat it. I hope it’s okay to ask here anyway because I am curious if anyone has an explanation. I will describe below what solved it and how I have tried to repeat it. Couldn’t find any threads describing this anywhere.)
I had a few variables in my script with names starting with capital letters that I wanted to change to lowercase first letters. For example I wanted to change "Flux_th" to "flux_th". See code example below with only the relevant lines from my script.
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
Flux_th = 42078172084928.6; % [neutrons/cm2/s]
I used the shift+enter function in matlab to change "Flux_th" to "flux_th" (same with the other variables).
I cleared my workspace, I ran the script (like below) and got BOTH "Flux_th" and "flux_th" in my workspace (they have the same value).
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
I tried changing back to capital letters on "Flux_th" and doing the same thing again but it still gave me duplicates.
I am pretty sure that I tried manually deleting the duplicates with capital letters in the workspace and then running the script, but that also gave me duplicates.
It happened again even after restarting matlab.
What DID actually solve the problem is the following sequence:
I cleared the workspace, then I ran this separate script that creates and saves the .mat files, that script looks like this:
%% Global nuclear data
%data for reactions
dataNucGlobal_reac = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["barn";"isotopefrac";"reference"]);
dataNucGlobal_reac(‘O16 (n,p) N16: s-f’, 🙂 = {2.026e-5, 99.76, "ENDL"};
save(‘dataNucGlobal_reac’)
%data for nuclides
dataNucGlobal_nuc = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["halflife_s"; "decayconst"; "reference"]);
dataNucGlobal_nuc(‘N16’, 🙂 = {7.12, log(2)/7.12, "?"};
save(‘dataNucGlobal_nuc’)
Then I ran my original script without the load lines like this:
% load(‘dataNucGlobal_nuc.mat’)
% load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
This time I did not get any duplicates, so I cleared my workspace again and reinserted the load lines and finally ran the script like this:
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
Now everything is working and I can’t reproduce what happened by changing variable names from capital to lowercase letters.
I am super confused because as you can see, the .mat-files DO NOT contain any of the variables that became duplicates, so it doesn’t make any sense that this would help. I have no idea what happened so that is why I am asking here. (I did solve this problem but I haven’t been able to repeat it. I hope it’s okay to ask here anyway because I am curious if anyone has an explanation. I will describe below what solved it and how I have tried to repeat it. Couldn’t find any threads describing this anywhere.)
I had a few variables in my script with names starting with capital letters that I wanted to change to lowercase first letters. For example I wanted to change "Flux_th" to "flux_th". See code example below with only the relevant lines from my script.
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
Flux_th = 42078172084928.6; % [neutrons/cm2/s]
I used the shift+enter function in matlab to change "Flux_th" to "flux_th" (same with the other variables).
I cleared my workspace, I ran the script (like below) and got BOTH "Flux_th" and "flux_th" in my workspace (they have the same value).
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
I tried changing back to capital letters on "Flux_th" and doing the same thing again but it still gave me duplicates.
I am pretty sure that I tried manually deleting the duplicates with capital letters in the workspace and then running the script, but that also gave me duplicates.
It happened again even after restarting matlab.
What DID actually solve the problem is the following sequence:
I cleared the workspace, then I ran this separate script that creates and saves the .mat files, that script looks like this:
%% Global nuclear data
%data for reactions
dataNucGlobal_reac = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["barn";"isotopefrac";"reference"]);
dataNucGlobal_reac(‘O16 (n,p) N16: s-f’, 🙂 = {2.026e-5, 99.76, "ENDL"};
save(‘dataNucGlobal_reac’)
%data for nuclides
dataNucGlobal_nuc = table(‘Size’,[0,3], ‘VariableTypes’,["double", "double", "string"],’VariableNames’,["halflife_s"; "decayconst"; "reference"]);
dataNucGlobal_nuc(‘N16’, 🙂 = {7.12, log(2)/7.12, "?"};
save(‘dataNucGlobal_nuc’)
Then I ran my original script without the load lines like this:
% load(‘dataNucGlobal_nuc.mat’)
% load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
This time I did not get any duplicates, so I cleared my workspace again and reinserted the load lines and finally ran the script like this:
load(‘dataNucGlobal_nuc.mat’)
load(‘dataNucGlobal_reac.mat’)
flux_th = 42078172084928.6; % [neutrons/cm2/s]
Now everything is working and I can’t reproduce what happened by changing variable names from capital to lowercase letters.
I am super confused because as you can see, the .mat-files DO NOT contain any of the variables that became duplicates, so it doesn’t make any sense that this would help. I have no idea what happened so that is why I am asking here. variable-names, duplicates MATLAB Answers — New Questions
