Month: June 2024
Excel Worksheet Tab appearance
Hi All,
I have a client who is asking to revert back the Rounded Corners to the Rectangle type Interface or appearance of the Worksheet tab, Can you share how?
Thank you in advance!
Really a appreciate you all
PS: I have the rectangle one with the office version of 17425.20146, I have downgraded the version with same as mine. but interface didn’t change anything
Hi All,I have a client who is asking to revert back the Rounded Corners to the Rectangle type Interface or appearance of the Worksheet tab, Can you share how?Thank you in advance!Really a appreciate you allPS: I have the rectangle one with the office version of 17425.20146, I have downgraded the version with same as mine. but interface didn’t change anything Read More
How to store users input in a file?
Let’s say I made a input asking for the users name and age, and wanted to say his input to a .txt file, I already know how to do that but my issue is how to keep that stored data if the script was ran again.
my code to store the users name and age:
name = input(‘What is your name? ‘,’s’);
age = input(‘How old are you? ‘);
fid = fopen(‘data.txt’,’w’);
fprintf(fid,’%s is %i years oldn’,name,age);
fclose(fid);Let’s say I made a input asking for the users name and age, and wanted to say his input to a .txt file, I already know how to do that but my issue is how to keep that stored data if the script was ran again.
my code to store the users name and age:
name = input(‘What is your name? ‘,’s’);
age = input(‘How old are you? ‘);
fid = fopen(‘data.txt’,’w’);
fprintf(fid,’%s is %i years oldn’,name,age);
fclose(fid); Let’s say I made a input asking for the users name and age, and wanted to say his input to a .txt file, I already know how to do that but my issue is how to keep that stored data if the script was ran again.
my code to store the users name and age:
name = input(‘What is your name? ‘,’s’);
age = input(‘How old are you? ‘);
fid = fopen(‘data.txt’,’w’);
fprintf(fid,’%s is %i years oldn’,name,age);
fclose(fid); input MATLAB Answers — New Questions
Split a matrix of nodes (x,y,z) into 2/3 matrices with dbscan or spectralcluster
Hi! I should split the matrix ‘M4_5’ or ‘M4_12’ into 2/3 matrices like figure.
I have tried the functions ‘dbscan’ or ‘spectralcluster’ but I cannot subdivide the matrix.
load M4_5.mat
% load M4_12.mat
idx = dbscan(M4,0.3,4);
% idx = spectralcluster(M4,2);
[r1,c] = find(idx == 1);
[r2,c] = find(idx == 2);
M4_a = M4(r1,:);
M4_a = M4(r2,:);
figure
plot3(M4(:,1),M4(:,2),M4(:,3),’k.’,’Markersize’,8);
hold on
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’y.’,’Markersize’,12);
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’m.’,’Markersize’,12);
hold off
axis equalHi! I should split the matrix ‘M4_5’ or ‘M4_12’ into 2/3 matrices like figure.
I have tried the functions ‘dbscan’ or ‘spectralcluster’ but I cannot subdivide the matrix.
load M4_5.mat
% load M4_12.mat
idx = dbscan(M4,0.3,4);
% idx = spectralcluster(M4,2);
[r1,c] = find(idx == 1);
[r2,c] = find(idx == 2);
M4_a = M4(r1,:);
M4_a = M4(r2,:);
figure
plot3(M4(:,1),M4(:,2),M4(:,3),’k.’,’Markersize’,8);
hold on
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’y.’,’Markersize’,12);
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’m.’,’Markersize’,12);
hold off
axis equal Hi! I should split the matrix ‘M4_5’ or ‘M4_12’ into 2/3 matrices like figure.
I have tried the functions ‘dbscan’ or ‘spectralcluster’ but I cannot subdivide the matrix.
load M4_5.mat
% load M4_12.mat
idx = dbscan(M4,0.3,4);
% idx = spectralcluster(M4,2);
[r1,c] = find(idx == 1);
[r2,c] = find(idx == 2);
M4_a = M4(r1,:);
M4_a = M4(r2,:);
figure
plot3(M4(:,1),M4(:,2),M4(:,3),’k.’,’Markersize’,8);
hold on
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’y.’,’Markersize’,12);
plot3(M4_a(:,1),M4_a(:,2),M4_a(:,3),’m.’,’Markersize’,12);
hold off
axis equal dbscan, spectralcluster, data, matrix array, matrix manipulation, matrix, matrices MATLAB Answers — New Questions
How do I get the true position of UIAxes with daspect = [1 1 1] and contained within a grid?
I have an AppDesigner app that features a GridLayout set up like this:
The xy UIAxes object has its data aspect ratio set to [1 1 1], which means that when I resize the window, the axes resize so as to always match the aspect ratio of the plotted data. However, this presents a problem, as the xz and yz UIAxes objects don’t always match the width and/or height of the xy UIAxes object.
After exhausting a number of other potential approaches, I’m now trying to manually update the appropriate ColumnWidth and RowHeight values of the parent GridLayout, but I’m unable to get the true position of the xy UIAxes, because they always correspond to the maximum possible space occupied by the xy UIAxes. If that doesn’t parse in text, this should help:
How can I get the true position I’m looking for?I have an AppDesigner app that features a GridLayout set up like this:
The xy UIAxes object has its data aspect ratio set to [1 1 1], which means that when I resize the window, the axes resize so as to always match the aspect ratio of the plotted data. However, this presents a problem, as the xz and yz UIAxes objects don’t always match the width and/or height of the xy UIAxes object.
After exhausting a number of other potential approaches, I’m now trying to manually update the appropriate ColumnWidth and RowHeight values of the parent GridLayout, but I’m unable to get the true position of the xy UIAxes, because they always correspond to the maximum possible space occupied by the xy UIAxes. If that doesn’t parse in text, this should help:
How can I get the true position I’m looking for? I have an AppDesigner app that features a GridLayout set up like this:
The xy UIAxes object has its data aspect ratio set to [1 1 1], which means that when I resize the window, the axes resize so as to always match the aspect ratio of the plotted data. However, this presents a problem, as the xz and yz UIAxes objects don’t always match the width and/or height of the xy UIAxes object.
After exhausting a number of other potential approaches, I’m now trying to manually update the appropriate ColumnWidth and RowHeight values of the parent GridLayout, but I’m unable to get the true position of the xy UIAxes, because they always correspond to the maximum possible space occupied by the xy UIAxes. If that doesn’t parse in text, this should help:
How can I get the true position I’m looking for? matlab, appdesigner, axes MATLAB Answers — New Questions
surface pro 7 bios locked and no bootable file found
my friend gave me his surface to fix and i figured it would easy. but the thing has got a system password which he dont know and it will not boot windows due to no bootable file being found. apparantly its not so easy as a regular desktop or laptop to just boot from usb a windows iso and do a clean install. if anyone can point me in the right direction i would appreciate it.
my friend gave me his surface to fix and i figured it would easy. but the thing has got a system password which he dont know and it will not boot windows due to no bootable file being found. apparantly its not so easy as a regular desktop or laptop to just boot from usb a windows iso and do a clean install. if anyone can point me in the right direction i would appreciate it. Read More
How to normalize comma separated values that are the same but were loaded in a different order
Hello, looking for some help. Is there an easy way to normalize the following table? The values in column B are all the same, they were just loaded in a different order. Is there a way to mass update so that these appear in the same order. The file itself contains many combinations…for example, there may be cells that have 3 comma separated values but each value is the same, just in a different load order. Or 4 values, in a different load order. Thank you in advance!!
Hello, looking for some help. Is there an easy way to normalize the following table? The values in column B are all the same, they were just loaded in a different order. Is there a way to mass update so that these appear in the same order. The file itself contains many combinations…for example, there may be cells that have 3 comma separated values but each value is the same, just in a different load order. Or 4 values, in a different load order. Thank you in advance!! Read More
Can JSON formatting check if document is checked out?
In a SharePoint Document Library, I’m wondering if JSON formatting can check if a document is checked out. What I’m trying to do is change a value of a “Status” column to “under review” if the document is checked out.
I tried to Google, use CoPilot, and bing to find an answer, but couldn’t find a conclusive answer if it’s even possible.
Thank you for any guidance provided!
In a SharePoint Document Library, I’m wondering if JSON formatting can check if a document is checked out. What I’m trying to do is change a value of a “Status” column to “under review” if the document is checked out. I tried to Google, use CoPilot, and bing to find an answer, but couldn’t find a conclusive answer if it’s even possible. Thank you for any guidance provided! Read More
after installing WIndows 11 Pro 24h2 Release Preview Insider Preview I get this…
Hello to all, After Installing Windows 11 24H2 Pro Release Preview Insider Preview I get this mainly after the optional update that brings this to build 26100.712 : Dism Host Servicing Process Problem signature Problem Event Name: CbsPackageServicingFailure2 Stack Version: 10.0.26100.712 Package: Package_for_SafeOSDU Version: 26100.712.1.69 Architecture: amd64 Culture: unknown Status: 800f0818 Failure Source: CBS Other Start State: Absent Target State: Installed Client Id: DISM Package Manager Provider OS Version: 10.0.26100.2.0.0.256.48 Locale ID: 1033
I am wondering How to fix it or if it is a possible known issue that Microsoft is going to fix hopefully very soon anyways!! Thanks for your time in advance and Have a great day ahead and stay safe also!!..
Hello to all, After Installing Windows 11 24H2 Pro Release Preview Insider Preview I get this mainly after the optional update that brings this to build 26100.712 : Dism Host Servicing Process Problem signature Problem Event Name: CbsPackageServicingFailure2 Stack Version: 10.0.26100.712 Package: Package_for_SafeOSDU Version: 26100.712.1.69 Architecture: amd64 Culture: unknown Status: 800f0818 Failure Source: CBS Other Start State: Absent Target State: Installed Client Id: DISM Package Manager Provider OS Version: 10.0.26100.2.0.0.256.48 Locale ID: 1033 I am wondering How to fix it or if it is a possible known issue that Microsoft is going to fix hopefully very soon anyways!! Thanks for your time in advance and Have a great day ahead and stay safe also!!.. Read More
KB5037771 fails to install
Hi,
I have a few computers at my organization that fail to install the May Cumulative Update. It gives either error 0x800f081f or 0x80070003. I’ve tried to delete SoftwareDistribution and catroot2 folders, reset winsock, dism, sfc, tried to install manually by downloading it through Update Catalog–everything fails. I know some people suggest In-Place upgrade, but my users are remote, so that would be my last option.
Hi, I have a few computers at my organization that fail to install the May Cumulative Update. It gives either error 0x800f081f or 0x80070003. I’ve tried to delete SoftwareDistribution and catroot2 folders, reset winsock, dism, sfc, tried to install manually by downloading it through Update Catalog–everything fails. I know some people suggest In-Place upgrade, but my users are remote, so that would be my last option. Read More
Universal API Center – a truly comprehensive API catalog that warmly welcomes all your APIs!
Silent yet powerful, APIs are the unsung heroes of our digital era!
Welcome! Your presence here, fully engaged in this article, indicates an insightful understanding of the immense importance and catalytic role that APIs, or Application Programming Interfaces, play in shaping our technology-driven lives today!
Findings show that businesses across sectors have been amassing APIs year after year, a trend that has sharply escalated in recent months due to groundbreaking advancements in the field of Artificial Intelligence (AI).
Have you ever counted the number of APIs used within your organization? Moreover, do you know how many of these APIs are efficiently governed, securely managed, and observed to verify their compliance with service-level objectives? Quite probably, you don’t – simply because managing these governance tasks isn’t easy and often doesn’t take the top priority.
Various factors contribute to the challenges of managing the API landscape:
A key factor is the deployment of APIs across a vast selection of hybrid and multi-cloud environments. This encompasses SaaS applications, no code/low code platforms, cloud platforms utilizing containers and microservices, as well as legacy systems. Each of these environments possesses distinctive attributes that affect the API lifecycle and its effective governance.
Another consideration is the diverse spectrum of API protocols, specifications, and architectural styles available. At present, REST APIs, primarily using the OpenAPI specification for newer APIs, enjoy the highest popularity. Nonetheless, it’s crucial to note that the API landscape incorporates other protocols and specifications including but not limited to AsyncAPI, GraphQL, SOAP, WebSockets and more.
Additionally, the enterprise scene features a diverse array of API Gateways and API management solutions. Numerous vendors offer a wide spectrum of services, extending from distinct API gateway functionality to complete lifecycle API management. These solutions make a major contribution to API management within a given scope. However, they often remain dispersed across different environments, cloud providers, and API types, adding to the difficulty of managing the complete API landscape.
Introducing the Azure API Center, a comprehensive platform for all your APIs!
Recognizing these challenges, Microsoft has launched the Azure API Center, which is now generally available. It offers a centralized API inventory for seamless API discovery, reuse, and governance, regardless of the API type, lifecycle stage, or deployment location. By addressing the critical need for a centralized API inventory, Azure API Center guarantees that the unprecedented growth of APIs augments, rather than hampers, the digital transformation through APIs.
Main benefits:
Build and maintain a comprehensive inventory of all APIs within your organization.
Encourage communication and collaboration between API program managers and developers to boost API reuse, quality, security, compliance, and productivity.
Implement efficient governing strategies to APIs to adhere to your organizational standards using custom metadata and analysis of API definitions.
Promote easy API discovery to encourage API reuse and enhance developer productivity with the help of AI assisted development powered by GitHub Copilot.
Boost API consumption to minimize the time it takes for the first API call. This guarantees security and standardizes usage in line with your organization’s standards.
Browse the Azure API Center overview page to know more.
How to build a universal API inventory of all your APIs?
A Universal API inventory substantially boosts an organization’s ability to manage any API, regardless of its origins or deployment location.
This article will delve into the techniques for inventorying APIs from diverse sources, including API gateways and full life cycle API management solutions.
Firstly, you’ll need to provision an Azure API Center resource if you haven’t already done so. Comprehensive guides are available in the service documentation, detailing ways to accomplish this task using the Azure Portal, Azure CLI, or infrastructure as code such as Bicep or ARM.
Before you begin the process of inventorying your APIs, you should define the custom metadata that needs to be configured in the Azure API Center.
Both built-in and custom metadata can be utilized to effectively organize your APIs, environments, and deployments within your API center. By requiring specific metadata for APIs, environments, and deployments, you can enforce governance standards within your organization. API Center supports a wide range of metadata types, including objects, arrays and predefined choices.
Identifying custom metadata is a dynamic process. Initiate it by thoroughly exploring the entire API landscape, all the different sources and systems, and understanding the crucial properties necessary for correctly classifying APIs, environments, and deployments.
Tip! Begin with a compact set of properties and gradually incorporate additional custom metadata over time for an enriched catalog.
Follow this tutorial to configure the custom metadata in Azure API Center.
Inventorying your APIs
Now that you’re ready to start inventorying your APIs, we’re going to equip you with tools to import APIs from a wide variety of sources using samples from an open-source repo. This includes sources like Git source control systems, Azure API Management, Amazon API Gateway, Google Apigee API Management, Kong API Gateway, MuleSoft Anypoint API Manager, along with a generic import for other sources and API gateways. Get ready for a smooth and efficient import process!
Visit the public GitHub repository listed below to gain access to our provided labs. These guides will streamline your learning experience about the API Center inventory process.
For the import process, we’re going to use the straightforward Azure Command-Line Interface (CLI) commands provided by Azure API Center. The Azure CLI is a versatile, cross-platform command-line tool designed to connect with Azure and perform administrative commands on Azure resources. It facilitates the running of commands through a terminal using either interactive command-line prompts or a script.
The inventory guides provided below feature scripts powered by Azure CLI. These can be seamlessly adapted and expanded to cater to your unique requirements and added to your automation workflows.
Uses the import-from-apim command to bulk import your Azure API Management APIs into API Center. Please follow this guide for a more customized approach.
Uses the AWS CLI to export REST APIs with all the available details and import the APIs into API Center with versions, API specifications and the relevant metadata.
Exports the Apigee APIs using Google Cloud CLI and then imports API details, revisions, definitions and deployments. Consider reusing this repo, that offers a custom approach migrating Apigee to Azure APIM.
Leverages the Kong Admin API that works with OSS, Plus and Enterprise Kong API Gateways to export APIs and import them into API Center. You can easily extend this lab to work with Kong Konnect.
🧪MuleSoft Anypoint API Manager
Exports the MuleSoft Anypoint envs and respective API artifacts from API Manager using the Anypoint Platform CLI and loads everything into API Center. You can extend this lab to load Exchange assets.
Clone the Git repository to your local file system and start crawling the files to identify valid API specifications. These specifications are then imported into API Center.
Uses the API OpenAPI specification as the source of truth to register the API with version, definition, and associated deployments in a single command. Reuse this lab for other sources and API gateways.
Next steps?
With the inventory guides provided, you are able to consolidate in a unified catalog all the APIs used throughout your organization!
To keep the API Center always updated, you should encourage your developers to maximize the use of API Center VS Code extensions for APIs being built with an API-first or code-first approach. It is even better to automate the process with CI/CD workflows. This not only facilitates efficient API registration directly from VS Code but also streamlines the overall API supply chain.
You are now prepared to enhance API governance and boost the quality and security of your API landscape. Azure API Center offers the capability of performing automatic linting and analysis on API definitions in accordance with your organization’s API style rules. This feature ensures enhanced API quality, promoting consistency and the highest standards in API usage within your organization.
When you are confident your APIs are consolidated in a single, organized view for optimal quality, it’s time to promote discovery and API usage. For that Azure API Center provides different interfaces to meet users where they are:
The Azure Portal provides robust API Center discovery capabilities for administrators, operators, and developers, among others, right out of the box with the UI or the Azure CLI.
API Center provides the API Center portal as an open-source project to enable full customization. It provides a platform for developers and other stakeholders within your organization to explore APIs and delve into specific API details with ease. This uses the highly versatile API Center Data API, enabling effortless integration with any existing tool.
VS Code with the API Center extension. With the API Center extension for VS Code, you can effortlessly discover APIs and API definitions in your Azure API Center. Employ the GitHub Copilot Chat agent in conjunction with Azure API Center extension for Visual Studio Code to enhance your coding experience. The chat agent, @apicenter, along with additional features provided by the Azure API Center extension, proves tremendously beneficial for developers. These tools not only assist in discovering, testing, and utilizing APIs but also help maintain developer’s productivity momentum.
We’re eager to hear your thoughts! Kindly leave your comments below or contact the API Center product team. We warmly welcome your feedback, as it helps us immensely by highlighting areas for improvement. Whether it pertains to your experiences, problems, or feature requests, we are always ready to listen and evolve.
Thank you!
Microsoft Tech Community – Latest Blogs –Read More
