Category: News
Trying to acquire Data using the data acquisition tool and setting the rate leads to the ScansAvailableFcn not running enough times.
I am creating an app in app designer and am using the data acquisition toolbox. I for the app I need to change the rate of the data acquistion using the "Rate" variable but, the number of data points that is collecting per trigger cannot be in decimals and but be a positive integer (understandably). For example I am trying to collect at 2048Hz ("Rate") and the number of scans per trigger can only be set to 205 or 206 and will try to get triggered 10 times. With either of these it ends up going to 0.9s of a 1.0s trial but there are not enough points of data for the trigger to trigger the final 0.1s of data collection. I have also tried to chagnge the ScansAvailableFcnCount within the trigger after the 9th run but that does not seem to work either? I am not 100% if I did it correctly but I did try the best I could. When I have tried to change the number of scans (points of data) that it collects per trigger It will just set it back to the closet one that the selected "Rate" would automatically set it to(either 205 or 206). Does anyone have any solution for this problem?
The "Rate" variable needs to be able to be equal to anything from 120-2048 but I am currently just trying to figure out how I can get the ScansCallback to read in the last couple hundred points of data.
Any and all help is greatly appreciated!
Thanks!
I took the follow picture from the 9th run of the trialI am creating an app in app designer and am using the data acquisition toolbox. I for the app I need to change the rate of the data acquistion using the "Rate" variable but, the number of data points that is collecting per trigger cannot be in decimals and but be a positive integer (understandably). For example I am trying to collect at 2048Hz ("Rate") and the number of scans per trigger can only be set to 205 or 206 and will try to get triggered 10 times. With either of these it ends up going to 0.9s of a 1.0s trial but there are not enough points of data for the trigger to trigger the final 0.1s of data collection. I have also tried to chagnge the ScansAvailableFcnCount within the trigger after the 9th run but that does not seem to work either? I am not 100% if I did it correctly but I did try the best I could. When I have tried to change the number of scans (points of data) that it collects per trigger It will just set it back to the closet one that the selected "Rate" would automatically set it to(either 205 or 206). Does anyone have any solution for this problem?
The "Rate" variable needs to be able to be equal to anything from 120-2048 but I am currently just trying to figure out how I can get the ScansCallback to read in the last couple hundred points of data.
Any and all help is greatly appreciated!
Thanks!
I took the follow picture from the 9th run of the trial I am creating an app in app designer and am using the data acquisition toolbox. I for the app I need to change the rate of the data acquistion using the "Rate" variable but, the number of data points that is collecting per trigger cannot be in decimals and but be a positive integer (understandably). For example I am trying to collect at 2048Hz ("Rate") and the number of scans per trigger can only be set to 205 or 206 and will try to get triggered 10 times. With either of these it ends up going to 0.9s of a 1.0s trial but there are not enough points of data for the trigger to trigger the final 0.1s of data collection. I have also tried to chagnge the ScansAvailableFcnCount within the trigger after the 9th run but that does not seem to work either? I am not 100% if I did it correctly but I did try the best I could. When I have tried to change the number of scans (points of data) that it collects per trigger It will just set it back to the closet one that the selected "Rate" would automatically set it to(either 205 or 206). Does anyone have any solution for this problem?
The "Rate" variable needs to be able to be equal to anything from 120-2048 but I am currently just trying to figure out how I can get the ScansCallback to read in the last couple hundred points of data.
Any and all help is greatly appreciated!
Thanks!
I took the follow picture from the 9th run of the trial data acquisition MATLAB Answers — New Questions
Subplot of a matrix 2x361x10
Hi, I need to know how I can make a subplot. With the FEM analysis on an asynchronous machine, I get a matrix of the magnetic field taken after simulation in matlab, which is 2x361x10. Where 361 are the rotor positions, and 10 are the time instants for which I calculated the 361 rotor positions, each time. I would like to know how to make 10 subplots of B as a function of the instants of time for which I calculated the matrix.Hi, I need to know how I can make a subplot. With the FEM analysis on an asynchronous machine, I get a matrix of the magnetic field taken after simulation in matlab, which is 2x361x10. Where 361 are the rotor positions, and 10 are the time instants for which I calculated the 361 rotor positions, each time. I would like to know how to make 10 subplots of B as a function of the instants of time for which I calculated the matrix. Hi, I need to know how I can make a subplot. With the FEM analysis on an asynchronous machine, I get a matrix of the magnetic field taken after simulation in matlab, which is 2x361x10. Where 361 are the rotor positions, and 10 are the time instants for which I calculated the 361 rotor positions, each time. I would like to know how to make 10 subplots of B as a function of the instants of time for which I calculated the matrix. matrix, subplot MATLAB Answers — New Questions
Armchair Architects: POC to Prod Must-haves
Our host, David Blank-Edelman and our armchair architects Uli Homann and Eric Charran will be discussing how to transition from proof-of-concept (POC) to production (Prod) for AI solutions. It’s one thing to have a POC but what factors should solution architects be mindful of when taking that POC and moving into a real-world production environment?
Below are some key considerations to keep in mind:
Scale with Confidence First and foremost, scale is critical. Ensuring that your chosen model or hosted foundational model can handle queries and API requests efficiently is paramount. It’s not just about handling the volume but also about delivering valuable responses promptly.
Seamless Integration Next, integration with existing systems cannot be overlooked. The API service of your model partner should be robust, secure, and offer features like schematization of prompts and returns, confidence intervals for rating the LLM’s responses, and comprehensive error handling.
Cost Engineering and Security Cost engineering is another vital aspect. With services like OpenAI’s GPT versions offering multiple models, choosing the right one can significantly impact both performance and budget. Additionally, ensuring that your hosting system aligns with your enterprise security model is essential for safeguarding access to endpoints.
Observability and Content Safety Lastly, observability and content safety are key. Establishing guardrails to process prompts securely and monitoring the right metrics from a customer’s perspective ensures a secure and reliable system.
Keep in mind that each step is a building block towards a successful and sustainable production environment. Stay tuned for more insights from the Armchair Architects on the Azure Enablement Show.
Watch the episode below or watch more episodes in the Armchair Architects Series.
Resources
Training: Scale AI in your organization
Architectural approaches for AI and ML in multitenant solutions
Azure AI Content Safety documentation
Plan to manage costs for Azure OpenAI Service
What is Azure AI Content Safety?
Watch more episodes in the Armchair Architects Series
Related Blogs
Armchair Architects: How to choose a LLM partner for your AI project
Armchair Architects: What Is Responsible AI?
Armchair Architects: Are AI Charters Valuable?
Armchair Architects: Considerations for Ethical and Responsible Use of AI in Applications
Armchair Architects: Large Language Models (LLMs) & Vector Databases
Armchair Architects: Artificial Intelligence, Large Language Models, and Architects (Part 1 of 2)
Armchair Architects: Artificial Intelligence, Large Language Models, and Architects (Part 2 of 2)
Microsoft Tech Community – Latest Blogs –Read More
table2timetable with Time as double
Hello,
I have the following table :
The data come from a CAN trace, hence the varialbe time step.
My final goal is to do some analysis on the data.
My understanding is that it would be easier with a timetable and a resampling.
But I fail to convert this to a timetable :
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04);
Error using table2timetable (line 59)
Input table must contain datetime or duration vector for row times.
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04,"RowTimes","Time");
Error using table2timetable (line 135)
Row times must be datetime or duration vector.
I have the feeling that the type of Time variable is not correct but I had no luck trying to convert it.
ThanksHello,
I have the following table :
The data come from a CAN trace, hence the varialbe time step.
My final goal is to do some analysis on the data.
My understanding is that it would be easier with a timetable and a resampling.
But I fail to convert this to a timetable :
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04);
Error using table2timetable (line 59)
Input table must contain datetime or duration vector for row times.
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04,"RowTimes","Time");
Error using table2timetable (line 135)
Row times must be datetime or duration vector.
I have the feeling that the type of Time variable is not correct but I had no luck trying to convert it.
Thanks Hello,
I have the following table :
The data come from a CAN trace, hence the varialbe time step.
My final goal is to do some analysis on the data.
My understanding is that it would be easier with a timetable and a resampling.
But I fail to convert this to a timetable :
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04);
Error using table2timetable (line 59)
Input table must contain datetime or duration vector for row times.
my_timetable=table2timetable(my_traces(4).ewellix_num_data.fbk.ID04,"RowTimes","Time");
Error using table2timetable (line 135)
Row times must be datetime or duration vector.
I have the feeling that the type of Time variable is not correct but I had no luck trying to convert it.
Thanks timetable double duration seconds resample MATLAB Answers — New Questions
there is error in plotting, how to resolve it?
how to plot this function f(x,y)=x^y
i am getting error because function is becoming undefined at 0^0 but how to resolve this case.
x and y limit is same from -10 to 10
so how can we plot a function in which there are some value which are undefinedhow to plot this function f(x,y)=x^y
i am getting error because function is becoming undefined at 0^0 but how to resolve this case.
x and y limit is same from -10 to 10
so how can we plot a function in which there are some value which are undefined how to plot this function f(x,y)=x^y
i am getting error because function is becoming undefined at 0^0 but how to resolve this case.
x and y limit is same from -10 to 10
so how can we plot a function in which there are some value which are undefined 3d plots MATLAB Answers — New Questions
Map invoice and receipt on FIFO basis
Hi, i am attaching a sample data below, in which i have amounts in Positive as Invoices raised and Negative Values as Amount received, now i want to map receipts against invoice documents on FIFO basis.
format of desired output is as below.
Kindly help.
Hi, i am attaching a sample data below, in which i have amounts in Positive as Invoices raised and Negative Values as Amount received, now i want to map receipts against invoice documents on FIFO basis. format of desired output is as below. Kindly help. Read More
isdate function in SQL server
I am using isdate function to verify after extracting the first 8 chars from a sting.
isdate() returned 1 with the example below and my following code failed to calculated a Datediff().
Declare @Mystr varchar(29)
SET @Mystr=’05/020/2′
Select IsDate(’05/020/2′)
Is there any other similar function in SQL?
Thanks in advance for any idea.
I am using isdate function to verify after extracting the first 8 chars from a sting.isdate() returned 1 with the example below and my following code failed to calculated a Datediff().Declare @Mystr varchar(29)SET @Mystr=’05/020/2’Select IsDate(’05/020/2′) Is there any other similar function in SQL?Thanks in advance for any idea. Read More
Stuck in language pack installation process
Hi, I just got my new alienware gaming computer which comes with windows 11 pro system, I successfully downloaded the Chinese(simplied) language pack and restarted the laptop to apply the new display language, however it stuck at the restarting process for hours, it is now shows a black screen with the following words: “updates are underway. Please keep your computer on.” And that’s it for hours, I don’t think the restarting and installing process can take this long, please let me know what I can do now. It asks me to keep the computer on so I am so afraid to turn it off and on…
Hi, I just got my new alienware gaming computer which comes with windows 11 pro system, I successfully downloaded the Chinese(simplied) language pack and restarted the laptop to apply the new display language, however it stuck at the restarting process for hours, it is now shows a black screen with the following words: “updates are underway. Please keep your computer on.” And that’s it for hours, I don’t think the restarting and installing process can take this long, please let me know what I can do now. It asks me to keep the computer on so I am so afraid to turn it off and on… Read More
Appdesigner window ends up in background after uigetfile
I am creating a graphic program using appdesigner but when I call a function where the user can choose a file (uigetfile) the figure window is often put behind some other of my open windows after the file has been chosen. For example if I have a word document open at the same time as my program, the word document gets focus when the file has been chosen and I have to click at the bottom bar to get back to my program. I was using GUIDE before and then I didn’t have that problem. I am running on Windows. Is there a way to solve this?I am creating a graphic program using appdesigner but when I call a function where the user can choose a file (uigetfile) the figure window is often put behind some other of my open windows after the file has been chosen. For example if I have a word document open at the same time as my program, the word document gets focus when the file has been chosen and I have to click at the bottom bar to get back to my program. I was using GUIDE before and then I didn’t have that problem. I am running on Windows. Is there a way to solve this? I am creating a graphic program using appdesigner but when I call a function where the user can choose a file (uigetfile) the figure window is often put behind some other of my open windows after the file has been chosen. For example if I have a word document open at the same time as my program, the word document gets focus when the file has been chosen and I have to click at the bottom bar to get back to my program. I was using GUIDE before and then I didn’t have that problem. I am running on Windows. Is there a way to solve this? appdesigner, uifigure, figure, focus MATLAB Answers — New Questions
Evaluation of a function where some of the expression are above realmax but the value of the function at each point is not
Hi guys,
I try to evluate the following function,
Rnm = besselj(n,m1*r)-(besselj(n,m1)/besseli(n,m1))*besseli(n,m1*r);
Ynm = besselj(n,m1*r)+(besselj(n+1,m1)-besselj(n-1,m2))/(besseli(n+1,m1)+besseli(n-1,m2))*besseli(n,m2*r);
Where n is an integer, m1 and m2 are a real numbers, and r is a vector spaning from 0 to 1. And thus the resulted Rnm variable is also a vector same size as r.
I have a problem to evluate this vectors while working with large numbers of m1 and m2 (both are at the smae order always but not the exact values, and large means order of 1000). The issue is the besseli function, which are similar to exponants so they reach to vlaues above realmax at the edges of the domain, but as I also devide by them the result supposed to be an osilating function decaying to zero at r=0.
I look for an option to evluate this function for larger numbers of m1 and m2 as well.
Thanks in advance,
Israel.Hi guys,
I try to evluate the following function,
Rnm = besselj(n,m1*r)-(besselj(n,m1)/besseli(n,m1))*besseli(n,m1*r);
Ynm = besselj(n,m1*r)+(besselj(n+1,m1)-besselj(n-1,m2))/(besseli(n+1,m1)+besseli(n-1,m2))*besseli(n,m2*r);
Where n is an integer, m1 and m2 are a real numbers, and r is a vector spaning from 0 to 1. And thus the resulted Rnm variable is also a vector same size as r.
I have a problem to evluate this vectors while working with large numbers of m1 and m2 (both are at the smae order always but not the exact values, and large means order of 1000). The issue is the besseli function, which are similar to exponants so they reach to vlaues above realmax at the edges of the domain, but as I also devide by them the result supposed to be an osilating function decaying to zero at r=0.
I look for an option to evluate this function for larger numbers of m1 and m2 as well.
Thanks in advance,
Israel. Hi guys,
I try to evluate the following function,
Rnm = besselj(n,m1*r)-(besselj(n,m1)/besseli(n,m1))*besseli(n,m1*r);
Ynm = besselj(n,m1*r)+(besselj(n+1,m1)-besselj(n-1,m2))/(besseli(n+1,m1)+besseli(n-1,m2))*besseli(n,m2*r);
Where n is an integer, m1 and m2 are a real numbers, and r is a vector spaning from 0 to 1. And thus the resulted Rnm variable is also a vector same size as r.
I have a problem to evluate this vectors while working with large numbers of m1 and m2 (both are at the smae order always but not the exact values, and large means order of 1000). The issue is the besseli function, which are similar to exponants so they reach to vlaues above realmax at the edges of the domain, but as I also devide by them the result supposed to be an osilating function decaying to zero at r=0.
I look for an option to evluate this function for larger numbers of m1 and m2 as well.
Thanks in advance,
Israel. realmax, large-values, beeseli, nan, inf MATLAB Answers — New Questions
Make trainnet pass in one observation to the network at a time
As best I can tell, trainnet vectorizes its computations across the batch dimension of every minibatch. I.e., during training, it feeds minibatches of data into the network as a complete SxSxSxCxB array where B is the number of observations in the minibatch. This can be quite memory intensive depending on S^3*C, and limits the minibatch sizes that can be selected for training.
Is there no way to force trainnet to compute the loss function and its gradients incrementally, by feeding one member of the minibatch (of size SxSxSxCx1) to the network at a time?As best I can tell, trainnet vectorizes its computations across the batch dimension of every minibatch. I.e., during training, it feeds minibatches of data into the network as a complete SxSxSxCxB array where B is the number of observations in the minibatch. This can be quite memory intensive depending on S^3*C, and limits the minibatch sizes that can be selected for training.
Is there no way to force trainnet to compute the loss function and its gradients incrementally, by feeding one member of the minibatch (of size SxSxSxCx1) to the network at a time? As best I can tell, trainnet vectorizes its computations across the batch dimension of every minibatch. I.e., during training, it feeds minibatches of data into the network as a complete SxSxSxCxB array where B is the number of observations in the minibatch. This can be quite memory intensive depending on S^3*C, and limits the minibatch sizes that can be selected for training.
Is there no way to force trainnet to compute the loss function and its gradients incrementally, by feeding one member of the minibatch (of size SxSxSxCx1) to the network at a time? trainnet, memory, minibatch, vectorization MATLAB Answers — New Questions
Code-m file for Sampling
Write a MATLAB code to
1) Generate a band limited signal (at extremely high sampling rate to approximate it as a continuous signal)
2) Plot the signal in Time Domain.
3) Take the FFT of the signal and plot the magnitude and phase of the signal spectrum and show it is a bandlimited signal.
4) Generate an impulse train at an appropriate sampling rate using DFS and show that its FFT is again an impulse train.
5) Using the signal and impulse train generated in (1) and (4), produce sampled signal by multiplying the two and apply FFT.
6) Display the sampled signal and its spectrum.
7) Reconstruct the original signal from its sampled value using sinc (interpolation) filter and display the same.Write a MATLAB code to
1) Generate a band limited signal (at extremely high sampling rate to approximate it as a continuous signal)
2) Plot the signal in Time Domain.
3) Take the FFT of the signal and plot the magnitude and phase of the signal spectrum and show it is a bandlimited signal.
4) Generate an impulse train at an appropriate sampling rate using DFS and show that its FFT is again an impulse train.
5) Using the signal and impulse train generated in (1) and (4), produce sampled signal by multiplying the two and apply FFT.
6) Display the sampled signal and its spectrum.
7) Reconstruct the original signal from its sampled value using sinc (interpolation) filter and display the same. Write a MATLAB code to
1) Generate a band limited signal (at extremely high sampling rate to approximate it as a continuous signal)
2) Plot the signal in Time Domain.
3) Take the FFT of the signal and plot the magnitude and phase of the signal spectrum and show it is a bandlimited signal.
4) Generate an impulse train at an appropriate sampling rate using DFS and show that its FFT is again an impulse train.
5) Using the signal and impulse train generated in (1) and (4), produce sampled signal by multiplying the two and apply FFT.
6) Display the sampled signal and its spectrum.
7) Reconstruct the original signal from its sampled value using sinc (interpolation) filter and display the same. homework, sampling, signal reconstruction MATLAB Answers — New Questions
‘My teams’ tab does not show all groups I am part of
I cannot see all groups I am part of on the tab. I can’t get to some Planner that are under those Teams
I cannot see all groups I am part of on the tab. I can’t get to some Planner that are under those Teams Read More
Blazor server app with Windows authentication getting 401 unauthorized
I’m building a Blazor server application for an internal company use and using Windows authentication. The app is supposed to field updates from another app via an exposed controller. I am trying to test the controller and getting a 401 unauthorized however I try to hit it (Postman, browser, test Console app, from within the Blazor server app itself, etc.). I’m running .NET 6 and scaffolded the app using Visual Studio and selecting Windows Authentication from the Create Project wizard for Blazor server app. I’m running the app from Visual Studio using IIS Express option. Here is the simple test I set up in the Console app just trying to get a positive response from the controller:
public async Task GetUpdateTestTimerResult()
{
var client = new HttpClient();
client.BaseAddress = new Uri(“http://localhost:40871”);
var url = “api/updateTest”;
var value = await JsonSerializer.DeserializeAsync
(await client.GetStreamAsync(url), new JsonSerializerOptions() { PropertyNameCaseInsensitive = true });
return value;
}
I’ve tried setting the AllowAnonymous attribute on the controller but no dice there. How do I expose a controller that will allow an outside application (also internal to the company/on premises) access?
I’m building a Blazor server application for an internal company use and using Windows authentication. The app is supposed to field updates from another app via an exposed controller. I am trying to test the controller and getting a 401 unauthorized however I try to hit it (Postman, browser, test Console app, from within the Blazor server app itself, etc.). I’m running .NET 6 and scaffolded the app using Visual Studio and selecting Windows Authentication from the Create Project wizard for Blazor server app. I’m running the app from Visual Studio using IIS Express option. Here is the simple test I set up in the Console app just trying to get a positive response from the controller: public async Task GetUpdateTestTimerResult()
{
var client = new HttpClient();
client.BaseAddress = new Uri(“http://localhost:40871”);
var url = “api/updateTest”;
var value = await JsonSerializer.DeserializeAsync
(await client.GetStreamAsync(url), new JsonSerializerOptions() { PropertyNameCaseInsensitive = true });
return value;
} I’ve tried setting the AllowAnonymous attribute on the controller but no dice there. How do I expose a controller that will allow an outside application (also internal to the company/on premises) access? Read More
Track and Revoke Local Document access
I have a hard time appreciating the new feature Track and revoke document access | Microsoft Learn.
I wish the button didn’t show on documents stored in SharePoint or OneDrive, or for a user whom is not “owner” of a document.
I wish the button didn’t take users to the Compliance portal with navigational items which doesn’t concern end-users.
I do recognize the need for educating users in controlling access to files in SharePoint, but I think this information is misplaced.
Disabling this feature doesn’t remove the button.
One thing I do like about this button, is that when an external user press it there is no redirect to Compliance portal, just a prompt containing the email of the user who applied this Sensitivity label with encryption. If only it could be possible for an internal user to obtain this information too.
I would appreciate if anyone care to comment.
I have a hard time appreciating the new feature Track and revoke document access | Microsoft Learn. I wish the button didn’t show on documents stored in SharePoint or OneDrive, or for a user whom is not “owner” of a document. I wish the button didn’t take users to the Compliance portal with navigational items which doesn’t concern end-users. I do recognize the need for educating users in controlling access to files in SharePoint, but I think this information is misplaced. Disabling this feature doesn’t remove the button. One thing I do like about this button, is that when an external user press it there is no redirect to Compliance portal, just a prompt containing the email of the user who applied this Sensitivity label with encryption. If only it could be possible for an internal user to obtain this information too. I would appreciate if anyone care to comment. Read More
New Outlook not connecting properly
Hi Tech community,
Since last Thursday I’ve had major issues with New Outlook.
1) I will write an email, send it and it will tell me it cannot send. It doesn’t save the email in drafts, it just disapears.
2) Folders are not visible when filing
3) Signature does not default when writing an email.
It’s essentially as if I’m disconnected but I’m hard wired to internet with no downage.
Any help would be greatly appreciated. I’d prefer not to switch back to the other Outlook.
Hi Tech community, Since last Thursday I’ve had major issues with New Outlook. 1) I will write an email, send it and it will tell me it cannot send. It doesn’t save the email in drafts, it just disapears.2) Folders are not visible when filing3) Signature does not default when writing an email. It’s essentially as if I’m disconnected but I’m hard wired to internet with no downage. Any help would be greatly appreciated. I’d prefer not to switch back to the other Outlook. Read More
Working with Access trying to create a report with a subreport
I am working with basketball stats (girls high school – many seasons). I have 3 queries that I ‘need’.
(a) v1 – list of girls with sisters that have played – varsity, reserve and/or freshman
(b) v21 – list of points scored by individuals at the varsity level
(c) v31 – list of points scored by the sisters combined
Each query includes a sister_code. (Most of the players do not have a sister_code)
I have created a report showing the (i) code, (ii) Last name, (iii) total points and (iv) number of sisters.
I am (trying) to create/link a subreport to each detail line of my report that then shows the scoring for each of the individual sisters. (When I am finished the sister_code will NOT be visible.)
My ‘ideal’ report will look like:
Most points scored by sisters at the varsity level
Sis_code Name Points Sisters
Smi Smith 2500 3
Smi Amy Smith 1200 1984-87
Smi Beth Smith 900 2000-02
Smi Chris Smith 400 1992-95
JL Jones 2200 2
Deb Jones 1300 2007-10
Ellie Lopez 900 2013-16
Right now I get my report to print ‘nicely’. But, my sub-report prints all of my 60 sisters, not just the 2 or 3 from the detail.
Yes, my sub-report is the reports detail part. BUT I have not done anything to limit(link) my sub-report. What do I need to do?
I am working with basketball stats (girls high school – many seasons). I have 3 queries that I ‘need’.(a) v1 – list of girls with sisters that have played – varsity, reserve and/or freshman(b) v21 – list of points scored by individuals at the varsity level(c) v31 – list of points scored by the sisters combinedEach query includes a sister_code. (Most of the players do not have a sister_code)I have created a report showing the (i) code, (ii) Last name, (iii) total points and (iv) number of sisters.I am (trying) to create/link a subreport to each detail line of my report that then shows the scoring for each of the individual sisters. (When I am finished the sister_code will NOT be visible.)My ‘ideal’ report will look like:Most points scored by sisters at the varsity levelSis_code Name Points SistersSmi Smith 2500 3 Smi Amy Smith 1200 1984-87 Smi Beth Smith 900 2000-02 Smi Chris Smith 400 1992-95JL Jones 2200 2 Deb Jones 1300 2007-10 Ellie Lopez 900 2013-16 Right now I get my report to print ‘nicely’. But, my sub-report prints all of my 60 sisters, not just the 2 or 3 from the detail.Yes, my sub-report is the reports detail part. BUT I have not done anything to limit(link) my sub-report. What do I need to do? Read More
forgot password to open Excel file
I have a very important file that I have forgotten the password to. I desparately need to get into the file. HELP!!!
I have a very important file that I have forgotten the password to. I desparately need to get into the file. HELP!!! Read More
Application Insights for Azure Logic Apps (Standard) – Correlation Tracking Update
In this blog post we are going to discuss a new feature flag that will modify the default behavior of passing correlation between Azure services and Logic Apps when tracking data using Application Insights v2. The feature allows you to control the Operation Id that gets emitted to Application Insights V2. The default behavior is to store the workflow’s Run Id in the operation_id field. The impact of this default behavior is that it can lead to additional complexity when trying to correlate events across other services like API Management and Azure Functions.
Note: To learn more about Application Insights (V2), please check out the following blog post: Application Insights Enhancements for Azure Logic Apps (Standard) reaches General Availability (microsoft.com)
The following image depicts the default behavior when an API subsequently calls a Logic App workflow which subsequently calls a Function App.
If you subsequently try to view the Application Map in Application Insights, you will see that the correlation is disconnected.
To address the need of propagating correlation values and creating linkages, we have enabled a feature flag that will allow you to override the default behavior and instead use an operation_id of the calling service. The following image illustrates the desired outcome that we are interested in. The remainder of this post will be dedicated to setting this up correctly.
To ensure that the correlation between Azure API Management and Azure Logic Apps lines up correctly, it is advisable to enable the W3C Correlation protocol in the API Management – API.
You will also need to enable the “Runtime.ApplicationInsights.PreserveIncomingOperationId“: “true” in the host.json file of your Logic App. You can enable this in VS Code or by using Kudu in Azure Portal. Save these new settings and make sure that your Logic App is restarted. This feature flag is disabled by default, meaning if you don’t enable it, your logging will use the default behavior as above.
Note: In the configuration below, we have set “Runtime.ApplicationInsightTelemetryVersion“: “v2”. This enables v2 of our Application Insights functionality. If you do not have v2 enabled, there is no need to set he PreserveIncomingOperationId as this is only available in v2.
{
“version”: “2.0”,
“extensionBundle”: {
“id”: “Microsoft.Azure.Functions.ExtensionBundle.Workflows”,
“version”: ” [1, 2.00) “
},
“extensions”: {
“workflow”: {
“Settings”: {
“Runtime.ApplicationInsightTelemetryVersion”: “v2”,
“Runtime.ApplicationInsights.PreserveIncomingOperationId”: “true”
}
}
}
}
When we rerun our transaction using the new feature flag, we can see that we have a consistent operation_id across our API, workflows and Function App.
This will allow the Application Map to render properly.
If you are using Application Insights v2 in Azure Logic Apps, it is recommended that you enable this feature so that you don’t have breakages in the Application Map functionality. However, this setting is opt-in so that we don’t impact any existing deployments of Logic Apps and Application Insights logging.
Looking for a video on this content? Check out the following YouTube video:
Microsoft Tech Community – Latest Blogs –Read More
Most widely used SharePoint Framework ISVs from the Store – April 2024
We are excited to see the continuous growth on the submissions of the SharePoint Framework (SPFx) solutions to the app source and on the usage of the SharePoint store for extending experiences for SharePoint and Microsoft Viva. Here are the top 10 most wide used ISVs based on the solution installations from the store and/or from Microsoft AppSource during April 2024.
SharePoint Framework is extensibility model for Microsoft Viva, Microsoft Teams, Outlook, Microsoft 365 app and SharePoint. It enables the same code to be used easily across the Microsoft 365 with this widely adopted tooling which uses industry standard tech with easy and automatic SSO and hosting. Usage of SPFx is growing steady and we have currently tens of millions of monthly active users in Microsoft 365 on custom extensibility build with SPFx.
Here are the latest roadmap items around SharePoint Framework and store:
Chart card support for the Viva Connections with the SPFx 1.19 release.
Deprecation of SharePoint add-in and Azure ACS authentication models – UX powered extensibility should be transformed to us SharePoint Framework powered implementations. Add-in model was introduced back in 2012 and has not really evolved since. This deprecation does not impact SharePoint Framework (SPFx) solutions.
Additional capabilities and features for SharePoint Framework solutions in Microsoft 365 as part of the SPFx 1.18 release.
Enabling Microsoft Viva Connections targeted solutions, powered by SharePoint Framework, in the app source and store – Will be automatically set for suitable SPFx solutions as part of the submission pipeline
Extending SharePoint Framework solutions across the Microsoft 365 with support for Microsoft Teams, Microsoft Viva, Outlook, Microsoft 365 app (Office), SharePoint and more – see the v1.16 release announcement for more details
Alignment of SharePoint Framework solution packaging model with the Microsoft Teams packages – include the best of both worlds and enable SPFx powered solutions across the Microsoft 365
Support for SharePoint Framework solutions in the Microsoft Teams store – no exact schedule, dependent on the previous bullet point
Support SharePoint Framework extensibility for list and library new, edit and view panels
and more to come…
What about AI extensibility story with SPFx? – Yes. We got you covered and more to come within 2024. More details during spring 2024. Don’t miss out the Microsoft Build 2024 conference to hear more.
We are looking forward to more great solutions that enable innovation, and help our customers get more done with Microsoft Viva, Microsoft Teams, SharePoint and more.
These are the ISVs which has the most usage from the SharePoint store during last month:
Accelerator 365 by Reply
Solution details:
Solutions at app source / store
Solution provider: Accelerator 365 by Reply
Sprinklr, Inc.
Solution details:
Solutions at app source / store
Solution provider: Sprinklr, Inc.
Achievers
Solution details:
Solutions at app source / store
Solution provider: Achievers
Ichicraft
Solution details:
Solutions at app source / store
Solution provider: Ichicract
SharePoint|sapiens
Solution details:
Solution at app source / store
Solution provider: SharePoint | sapiens
Plumsail Inc
Solution details:
Solutions at app source / store
Solution provider: Plumsail Inc
Cloudwell
Solution details:
Solutions at app source / store
Solution provider: Cloudwell
Dream Broker Oy
Solution details:
Solutions at app source / store
Solution provider: Dream Broker
Bloch Engineering
Solution details:
Solutions at app source / store
Solution provider: Bloch Engineering
Sharepointalist, Inc.
Solution details:
Solutions at app source / store
Solution provider: Sharepointalist, Inc.
Resources
Please see following resources around getting started on building extensibility for Microsoft Teams, Microsoft Viva and SharePoint using SharePoint Framework.
Announcing SharePoint Framework 1.19 with updates on building enterprise extensibility within Microsoft 365
Announcing SharePoint Framework 1.18 with updates for Microsoft Teams, Microsoft Viva and SharePoint
Announcing general availability of SharePoint Framework 1.16 – Enabling SPFx across Microsoft 365 platform
Explore and deploy SharePoint Framework solutions from partners in SharePoint (Microsoft 365)
Overview of the SharePoint Framework
Publish SharePoint Framework applications to the marketplace
Overview of Viva Connections Extensibility
Guidance for implementing partner offerings for Viva Connections with ACEs and custom APIs
Microsoft Learn – Extend Microsoft Viva Connections
SharePoint Framework samples to get started from Microsoft and community – Microsoft 365 & Power Platform Unified Sample Gallery
Happy coding! 🧡
Microsoft Tech Community – Latest Blogs –Read More