Month: June 2024
Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB
Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table in TempDB in Azure SQL Database using OPENROWSET and a format file.
First, we need to create a database scoped credential and an external data source to access the Azure Blob Storage.
CREATE DATABASE SCOPED CREDENTIAL MyCredential
WITH
IDENTITY = ‘SHARED ACCESS SIGNATURE’,
SECRET = ‘sv=2022-11-02&ss=bfqt&srt=sco&sp=rwdlacupiytfx&se=2024-06-30T16:56:42Z&st=2024-06-21T08:56:42Z&spr=https&sig=tAjokk5xO9kc%3D’;
CREATE EXTERNAL DATA SOURCE MyDataSource
WITH (
TYPE = BLOB_STORAGE,
LOCATION = ‘https://blobstorage.blob.core.windows.net/demo’,
CREDENTIAL = MyCredential
);
In this situation, I would like to create a format file that defines the structure of the CSV file and how it maps to the table columns. Below is an example format file in XML.
<?xml version=”1.0″?>
<BCPFORMAT xmlns=”http://schemas.microsoft.com/sqlserver/2004/bulkload/format” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<RECORD>
<FIELD ID=”1″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”2″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”3″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”4″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”5″ xsi:type=”CharTerm” TERMINATOR=”rn” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
</RECORD>
<ROW>
<COLUMN SOURCE=”1″ NAME=”Key” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”2″ NAME=”NumData” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”3″ NAME=”Col_01″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”4″ NAME=”Col_02″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”5″ NAME=”Col_03″ xsi:type=”SQLNVARCHAR”/>
</ROW>
</BCPFORMAT>
Save this format file and upload it to your Azure Blob Storage container.
Finally, we use OPENROWSET function to load data from the CSV file using the format file and insert it into a temporay table in TempDB.
SELECT *
INTO #test1
FROM OPENROWSET(
BULK ‘test1.csv’,
DATA_SOURCE = ‘MyDataSource’,
FORMATFILE =’format.xml’,
FORMATFILE_DATA_SOURCE = ‘MyDataSource’,
FIRSTROW = 2
) AS rows;
Microsoft Tech Community – Latest Blogs –Read More
New on Microsoft AppSource: June 7-13, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 193 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
Buddiz – AI for Schools & Higher Ed Colleges: Buddiz provides AI tools and solutions for schools, colleges, teachers, students, and parents, incorporating interactive chatbots into lesson planning and learning experiences. An advanced dashboard furnishes real-time analytics.
ChatGPTeMail: Najtech’s ChatGPTeMail add-in for Microsoft Outlook lets you compose and respond to emails through ChatGPT. Click the add-in icon to refine your draft’s language and tone. Compare versions before and after the transformation, then use them to elevate your professional correspondence.
Hardware Assets Inventory: Are you tired of using spreadsheets to track and manage your IT assets? IT Power’s app lets you view the status of your hardware assets from anywhere. Easily add new items, sort them into different categories, and monitor your stock. Access your inventory data from your mobile devices, your tablet, or your preferred browser.
HR Suite 360 – Human Capital Management (Start Package): HR Suite 360 from NEXXYSS offers a complete human resources solution, from recruitment to performance management. Keep employee records, track absences, store documents, and manage contracts. This offer is available in French.
Icon Map Pro: Icon Map Pro from Tekantis is a geospatial visualization tool designed for data analysts, GIS specialists, and business intelligence professionals. It offers background mapping, overlays, reference layers, and data layers. The tool provides seamless integration of geographic insights with an intuitive low-code or no-code Microsoft Power BI interface.
IndiGO Electronic Document: IndiGO Electronic Document from Indigo Technologies simplifies and automates the transfer of electronic documents for healthcare institutions. It ensures compliance with regulatory requirements and improves operational efficiency by centralizing information and reducing processing times and errors. This offer is available only in Spanish.
PleoMaintenance CMMS: PleoMaintenance from PleoData manages work orders, preventive maintenance scheduling, inventory parts, and asset costs via standard operating procedures built into workflows. Predict failures, eliminate downtime, and improve reliability with PleoMaintenance.
RENOVA2: RENOVA2 measures individual and group emotional well-being and relates this to organizational performance. Using advanced machine learning models trained on more than 90 groups, RENOVA2 identifies prevalent emotional well-being conditions in the Latin American population and issues personalized reports and recommendations. This offer is available only in Spanish.
SITA Mission Control SaaS: SITA’s Mission Control app enhances cross-functional cooperation in airline operations by connecting day-of-operations teams and driving increased collaboration through real-time air-ground information exchange. The app helps airlines better manage operational variability, turnarounds, fuel consumption, and carbon emissions.
Skypoint AI Platform for Social Services: Skypoint’s AI platform unifies all data sources into a data lakehouse and brings fragmented data into a social services-specific ontology. Streamline regulatory adherence, enhance staff scheduling, and customize care and wellness plans for residents based on data insights.
TriZetto Touchless Authorization Processing: TriZetto Touchless Authorization Processing (TTAP) is a cloud-based solution that automates healthcare prior authorization requests, streamlining the process and reducing turnaround time. It supports medical pre-planned inpatient and outpatient procedures, automates eligibility checks, and accommodates payer clinical guideline sets.
Vue.ai’s Intelligent Document Processing: Vue.ai automates document processing and workflows, allowing teams to improve accuracy and spare themselves repetitive manual tasks. Vue.ai is easy to use, handles all types of data, and has powerful AI features, such as pretrained and customizable models.
Waffle Chart Maker: The Waffle Chart Maker by VisioChart is a versatile and interactive tool for data visualization in Microsoft Power BI. It offers customizable features such as color, sorting, and display units, making it adaptable to different data representation needs. Cross-filtering enables comprehensive analysis, making it easier for stakeholders to understand and act upon insights.
Waterfall Chart: Waterfall Chart from VisioChart is a powerful visual tool for Microsoft Power BI to make your reports and dashboards informative and visually stunning. It automates variance calculations, year-over-year growth rates, and more, transforming your data into actionable insights. Customizable features ensure your chart is both aesthetically pleasing and functional.
Go further with workshops, proofs of concept, and implementations
Application Monitoring Solution with Microsoft Sentinel: AVASOFT’s consulting services aim to help you get started with or extend your use of Microsoft 365 by providing the expertise, capabilities, and know-how that you may lack in-house or need to enhance. In this engagement, AVASOFT will customize Microsoft Sentinel’s monitoring capabilities to offer detailed insights into your application’s performance and security.
CO2e Emissions Reporting Workshop: Lingaro offers sustainability expertise and data integration support to help companies accurately report carbon dioxide emissions. Using Microsoft tools like Power BI and Azure to manage, analyze, and visualize data, Lingaro’s experts will enable detailed reporting and analytics.
Continia Document Capture Installment, Workshop, and Support: Are you looking to implement Continia Document Capture? Navtilus can handle the installation process seamlessly, ensuring a smooth transition for your team. Navtilus will set up templates adjusted to fit your requirements, ensuring optimal performance and efficiency.
Copilot Change Management and Adoption: This workshop from ASI Solutions will give you hands-on experience with Microsoft 365 Copilot. Learn change management strategies to maximize the benefits of this transformative tool and provide the skills and support needed for successful adoption.
Copilot for Microsoft 365 Workshop: Inovasys will help your organization assess needs and build a plan for implementing Microsoft 365 Copilot so you can enhance productivity and gain access to resources, best practices, and community support to ensure successful implementation.
Copilot for Microsoft 365: 12-Week Impact Analysis Implementation: WM Reply offers a 12-week program to help organizations adopt Microsoft Copilot. The program includes a Copilot dashboard setup, employee surveys, focus groups, A/B testing, and ROI calculation. WM Reply provides expert mentorship to ensure effective and safe use of AI.
Copilot Microsoft 365: Workshop Sessions: This workshop from ASEE Solutions will teach participants how to integrate AI-powered tools into their daily duties, automating routine tasks and enhancing creativity. Topics will include drafting reports, summarizing data, and creating presentations.
Copilot Pro Adoption & Advisory Service: Logotel will implement DOJO, a tool based on Microsoft 365 that’s dedicated to the adoption of Microsoft Copilot. Employees can practice with a Microsoft AI assistant, facilitating fluid and effective adoption over time. Scale the impact of AI and unleash the potential of each person and team in your organization.
Dell Implementation Services for Copilot Security: Dell Technologies can maximize the full potential of your Microsoft Copilot for Security investment. Dell’s certified professionals will create customized prompts and ingest data from a range of security tools so your teams can gather intelligence, hunt threats, and effectively respond to any incident.
Device Domain Migration from On-Premises to Cloud: With the expertise of AVASOFT, your organization can efficiently migrate device domains from on-premises locations to the cloud, ensuring a secure and compliant environment while optimizing operational costs.
Device Monitoring with Microsoft Defender for Endpoint: Stay ahead of potential security breaches with the real-time monitoring and response capabilities of Microsoft Defender for Endpoint. In this offer, AVASOFT will help you manage and analyze device logs, gain activity insights, ensure compliance, centralize monitoring, and quickly identify and investigate security incidents.
Device Security Management with Microsoft Intune: Use Microsoft Intune to secure numerous devices and centralize control for easier management. In this offer, AVASOFT will help your organization implement Microsoft Intune to safeguard against cyber threats and ensure robust endpoint protection.
Dynamics 365 Business Central: 8-Week Implementation: AlphaBOLD will provide a hassle-free implementation of Microsoft Dynamics 365 Business Central. This will be preceded by a system gap analysis to identify needs, challenges, and automation opportunities. Post-go-live support will ensure system success through issue resolution, update management, ongoing training, and knowledge transfer.
Dynapt Advisory Services for Microsoft 365 Copilot: Dynapt offers AI advisory services for Microsoft 365 Copilot to enhance productivity, creativity, and innovation within organizations. The services include licensing planning, security configuration, usage setup, business case identification, pilot rollout, employee training, governance planning, and ongoing support.
Fabric in a Day: Workshop: Derevo’s workshop will accelerate your team’s adoption of Microsoft Fabric, an analytics platform that unifies data sources and tools like Azure Data Factory, Azure Synapse Analytics, and Power BI. Microsoft Fabric helps business professionals harness the potential of their data and lay the foundation for the AI era.
Increasing Efficiency with Copilot: Vision Software S.A.S will enable you to make the most of Microsoft 365 Copilot. Vision will explore different possibilities and business scenarios where Copilot can boost productivity, optimize performance, and foster dynamic collaboration. This offer is available only in Spanish.
Infosys Extending of Copilot Capabilities: Infosys can fast-track your AI journey. In this offer, Infosys will build custom copilots using Microsoft 365 Copilot and its prompts library. These copilots will automate tasks and address various persona needs in your organization.
Infra and Network Monitoring with Microsoft Sentinel: AVASOFT offers consulting services to help organizations efficiently monitor infrastructure and networks using Microsoft Sentinel. Proactive monitoring ensures resilience against threats. Focus on your business goals while AVASOFT manages your infrastructure and network security.
Integrating Microsoft Sentinel with Carbon Black EDR: Combine the power of Microsoft Sentinel analytics with Carbon Black EDR’s endpoint protection for comprehensive threat visibility. With AVASOFT’s assistance, your organization can efficiently integrate Microsoft Sentinel with Carbon Black EDR, ensuring a secure and compliant environment while optimizing operational efficiency.
Integrating Microsoft Sentinel with External EDR Service: In this offer, AVASOFT will seamlessly integrate Microsoft Sentinel with an external endpoint detection and response service to establish robust security, ensure compliance, centralize alert management, and enable proactive threat detection.
Microsoft Defender XDR Accelerator: This service from The Partner Masters will simplify your company’s security operations center workflow, reduce manual work, and provide a comprehensive view of threats. Experts from The Partner Masters will plan, design, deploy, and configure a pilot of Microsoft Defender XDR with the option for full production deployment.
Microsoft Multi-Cloud Security Engagement: 2-Week POC: Long View will use Microsoft Defender for Cloud to enhance your organization’s cloud security. Long View will establish foundational cloud security posture management, then activate cloud workload protection features to detect API threats and vulnerabilities across up to five resources.
Microsoft Volume Licensing: IT Partner’s experts will help you choose the right licensing program for your organization, as well as track renewals and monitor pricing adjustments. This will ensure you get maximum value from your Microsoft 365 investment while staying compliant and ready for audits. The service requires at least one legal business entity and the intent to purchase five products.
Power BI Migration Accelerator: 3-Week Proof of Concept: This service from iLink Systems helps businesses transition from IBM Cognos Analytics or Qlik Sense to Microsoft Power BI. It offers support for the latest Power BI features, as well as advanced data modeling and streamlined model editing and management. Minimal business interruption is ensured, and ongoing support will be provided.
Security Operations Center with Microsoft Sentinel: AVASOFT offers consulting services to help businesses efficiently manage security operations using Microsoft Sentinel. In this engagement, AVASOFT will empower your business with a security operations center powered by Microsoft Sentinel. This will streamline monitoring and analysis so your team can easily track security events and anomalies.
Self Service with Power BI: From Requirement to First Insightful Report in 4 Hours: This workshop from ITGAIN Consulting teaches skills for developing insightful reports using Microsoft Power BI, with a focus on a manufacturing company facing a drop in profit. Participants will enhance their analytical skills and visualize solutions in Power BI. The workshop can be held on-site or remotely in English or German.
SMB Readiness Workshop for Microsoft 365 Copilot: Intended for small and medium-sized businesses with 50 to 300 user, this workshop from Clear Concepts assesses readiness for Microsoft 365 Copilot. Clear Concepts will discuss the tool’s benefits, technical requirements, and licensing, then determine cloud environment readiness and deployment timelines.
Sustainability Reporting: CSRD: Lingaro offers comprehensive sustainability reporting services to help businesses comply with the European Union’s Corporate Sustainability Reporting Directive (CSRD). Lingaro will guide clients through the reporting process using Microsoft tools like Power BI and Azure.
Sustainability Reporting: US SEC: Lingaro offers expert services to guide clients through the United States Securities and Exchange Commission reporting process, with a focus on sustainability and climate-related disclosures. Lingaro will help you properly disclose greenhouse gas emissions and climate impacts, using Microsoft tools to provide accurate reporting.
Teams for GCC High: 3-Week Implementation: RSM’s Teams for GCC High is a secure communication and collaboration platform designed to meet the compliance needs of government entities. It utilizes Microsoft’s Cloud for Sovereignty, ensuring compliance with U.S. government regulations and requirements.
Unifying Microsoft Sentinel with Cloud Services: AVASOFT offers consulting services to help organizations unify Microsoft Sentinel with cloud services for comprehensive security coverage, centralized monitoring, and strengthened data protection. Deliverables include enhanced security and risk management, resource optimization, and centralized visibility and control.
Workshops: Solve the Right Problem the Right Way: This workshop series from Sirocco helps customers overcome obstacles and agree on goals for an initial project scope. The first workshop identifies the biggest barrier to their goal; the second discovers the root cause of the barrier; the third frames the problem for solutions; the fourth generates ideas to find innovative answers.
Contact our partners
1000minds Health-Related Quality of Life Value Set
9A Advanced Manufacturing – CAD/PLM Link
Access Charity CRM Add-in for Microsoft Outlook
Access Charity CRM Add-in for Microsoft Word
Accigo Readiness Assessment for Copilot for Microsoft 365
Accurate and Updated U.S. Denied Parties List (DPL)
ADAM AI Augmented Data Management Engine
AI Assistants for Healthcare Facilities
AI Consulting Services: 1-Day Workshop
AI LaunchPad: Custom AI Solutions for Office 365
AnaApp Sourcing & Vendor Management
APIVerve: Unified API Access for Streamlined Development
Aptean Production Costing for Food and Beverage
Assessment for Migration from Dynamics AX to Dynamics 365
AVL Data Analytics for Battery
B2C eCommerce for Dynamics 365 Business Central
Barcode API for Shipping Labels
BE-terna Incoming Document Register
Bionic Reading for Microsoft Word
BURQ iPaaS: eBay Integration with Dynamics 365 Business Central
CAP Logistics: Warehouse Operations
CAPEX & OPEX Authorization for Expenditure
Cloudmore Commerce Platform for Direct CSP Providers
Contract Management Extension for Dynamics 365
Coupler.io Revenue Dashboard for QuickBooks
DataPoint Add-in for PowerPoint
Devart Connector: Connect HubSpot to Excel
Devart Connector: Connect Magento to Excel
Devart Connector: Connect Mailchimp to Excel
Devart Connector: Connect Marketo to Excel
Devart Connector: Connect MySQL to Excel
Devart Connector: Connect NetSuite to Excel
Devart Connector: Connect Oracle to Excel
Devart Connector: Connect PostgreSQL to Excel
Devart Connector: Connect QuickBooks Online to Excel
Devart Connector: Connect Salesforce Marketing Cloud to Excel
Devart Connector: Connect Shopify to Excel
Devart Connector: Connect SQLite to Excel
Devart Connector: Connect SQL Server to Excel
Dynamics GP to Dynamics 365 Business Central Migration: 4-Week Assessment
EnterpriseGPT with Smart Search
Eyna: Advanced Package Management
Financials Template for SharePoint and Excel
Folderit DMS Add-in for Outlook
Frontline Worker Assessment for Healthcare
Gen AI-Powered Insurance Underwriter
Gen AI-Based Smart Credit Underwriter
Generative AI Community Support: 6-Month Service
GetAccept for Microsoft Dynamics 365
HCP Home Care Packages Aged Care Management for Microsoft Dynamics 365
High-Quality U.S. Publicly Listed Company Hierarchy
ILINX Process Improvement Platform
InsightStore Consumer Analytics Platform
KUBE 365 Business Process Automation Platform
Kyriba Open Reports Studio – Emerald
Kyriba Open Reports Studio – Quartz
Local Government Accelerator: 1-Hour Assessment
Microsoft 365 Copilot: 4-Week AI Assessment
Microsoft 365 Optimization Assessment
Microsoft 365 Threat Assessment
Mobile Time Tracking for Microsoft Dynamics 365
Nanhua Futures Assistant for Microsoft Excel
OnePortal: Digital Grid Connection Requests
OneTrust Data Activation and Compliance Risk Platform
Oraya Insights: Market Monitoring Your Way
Patient Experience: 2-Hour Briefing
Power Apps Process Coordination: Workshop & Assessment
Proactive Security Monitoring Service
ProcessNx Business Process Digital Transformation Platform
Real-Time Production Monitoring & Analytics
RingCentral RingCX for Dynamics 365
SAGE: Consumer Insights AI Assistant
Security and Compliance Assessment with Microsoft Purview
Service Portal for Dynamics 365 Business Central
SSH’s Electronic Invoice Solution for Mexico
Stock Trading Platform Monitor
The Last Business Card – NFC Digital Business Cards
Thomson Reuters Legal Task Manager
TRASER DMS 365 x Continia Document Capture
With Copilot Plugin Extension for ITSM
XTEL AI Enterprise Analytics Suite
Yooz Connector for Finance and Supply Chain Management
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Unlock the power of Microsoft Education in your Learning Management System
Microsoft Education is committed to supporting educators and learners with engaging and inclusive learning experiences, wherever teaching and learning happens. Whether you teach and learn in a physical classroom, online, or in a hybrid mode, Microsoft Education has the tools and resources to help you achieve your goals. One of the ways we do this is by integrating our products and services with popular Learning Management Systems (LMS). Building on our previous work to bring Microsoft 365 documents, Microsoft Teams collaboration, OneNote Class Notebooks, and Microsoft Reflect into LMS platforms, our new integration of Teams Assignments represents a leap forward in bringing more of the unique value of Microsoft Education directly to LMS users.
Achieve More with Assignments in your LMS
The new Teams Assignments integration brings unique new capabilities into your LMS, saving educators time, and providing powerful tools to accelerate learning. For example, with Teams assignments you can:
Leverage AI during assignment creation to rapidly draft assignment descriptions and rubrics
Accelerate student learning with powerful tools like Reading Progress, Search Progress, and Speaker Progress
Deliver quizzes with Microsoft Forms
Access unique assignment types such as Microsoft Whiteboard, MakeCode, and Flip video
Use Reflect exit check-ins to understand student sentiment related to assignments
Teams Assignments are seamlessly integrated with LMS assignments via the Learning Tools Interoperability® (LTI®) v1.3 Advantage standard. As an educator, you can create new Teams assignments or link existing Teams assignments in your LMS course. Once linked, you can view and access those assignments as you would any other assignment in the LMS course. Your students can view and access their Teams assignments in the same way as their other LMS assignments. Assignment grades in Teams are automatically imported into the LMS gradebook. You can now use the best that Teams assignments and your LMS offer working together, instead of working alongside each other.
This new integration is currently in private preview for PowerSchool Schoology Learning and Canvas. Support for additional LMS platforms will be added soon. You can sign up here for information on current and future previews.
Choose the Right Tool for the Right Assignment
Many educators are already using the OneDrive LTI® tool to bring M365 documents into LMS assignments. The new Teams Assignments LTI® tool is a complementary solution that brings unique capabilities of Teams for Education to LMS users. When creating an assignment in your LMS, you should choose the tool that best meets the needs of the specific assignment. Whatever the choice of tool, the assignment can be viewed and accessed like any other assignment in the LMS, and grades will be added into the LMS gradebook.
Teams Assignments LTI® tool
OneDrive LTI® tool
What is it best used for?
Learning Accelerators, Forms Quizzes, Whiteboard, MakeCode, Flip video, AI-assisted assignment creation, and any other features exclusive to Teams Assignments
Embedding or linking M365 documents in course content; Collaborative editing of documents; Assignments to be completed in Word, PowerPoint, or Excel
When opened in the LMS, where are assignments completed and turned in?
Microsoft Teams
Word, PowerPoint, or Excel
Where are assignments graded?
In Microsoft Teams, with grades automatically copied back to the LMS gradebook.
In the LMS, using the native LMS capabilities.
Requires Microsoft Teams for Education?
Yes
No
Leverage Microsoft Education for more than Assignments in your LMS
The new Teams assignments integration is the latest advancement in our continued efforts to bring the full value of Microsoft Education to users of learning management systems. You can already use the capabilities of Microsoft Teams, OneDrive, OneNote Class Notebooks, Microsoft Reflect directly within LMS courses. You can learn more about these integrations with leaning management systems such as Blackboard Learn, Brightspace, Canvas, Schoology Learning and Moodle in our previous overview, and our support page.
Learning Tools Interoperability® (LTI®) is a trademark of the 1EdTech Consortium, Inc. (www.1edtech.org)
Microsoft Tech Community – Latest Blogs –Read More
Simscape block parameter, change dynamically during simulation
Hallo,
is it possible to change a parameter of a Simscape block during simulation time?
Example: I want to change the thermal conductivity of the "Conductive Heat Transfer" block during the simulation time.
Example:
<</matlabcentral/answers/uploaded_files/85080/model_simcape.PNG>>
The thermal conductivity depends on the transferred heat and the temperature of the sink. For this I have a lookup table or a variable in workspace. Is it possible to check after each iteration the heat from the "Ideal Heat Flow Sensor" and the sink temperature and then send the new thermal conductivity to the "Conductive Heat Transfer" block for the next iteration?Hallo,
is it possible to change a parameter of a Simscape block during simulation time?
Example: I want to change the thermal conductivity of the "Conductive Heat Transfer" block during the simulation time.
Example:
<</matlabcentral/answers/uploaded_files/85080/model_simcape.PNG>>
The thermal conductivity depends on the transferred heat and the temperature of the sink. For this I have a lookup table or a variable in workspace. Is it possible to check after each iteration the heat from the "Ideal Heat Flow Sensor" and the sink temperature and then send the new thermal conductivity to the "Conductive Heat Transfer" block for the next iteration? Hallo,
is it possible to change a parameter of a Simscape block during simulation time?
Example: I want to change the thermal conductivity of the "Conductive Heat Transfer" block during the simulation time.
Example:
<</matlabcentral/answers/uploaded_files/85080/model_simcape.PNG>>
The thermal conductivity depends on the transferred heat and the temperature of the sink. For this I have a lookup table or a variable in workspace. Is it possible to check after each iteration the heat from the "Ideal Heat Flow Sensor" and the sink temperature and then send the new thermal conductivity to the "Conductive Heat Transfer" block for the next iteration? simscape, simulink, thermal, change parameter dynamically, matlab MATLAB Answers — New Questions
How to normalize a single row wise in MACONT, or multiply equation to single column only
I am making a code for MACONT and using 3 normalization technique, I am unable to normalization single column with their respective value (0-1) eventually ended up normalizing the the whole data from 0-1
Or is this possible to mulitpy a certain equation to one coloumn only without extracting itI am making a code for MACONT and using 3 normalization technique, I am unable to normalization single column with their respective value (0-1) eventually ended up normalizing the the whole data from 0-1
Or is this possible to mulitpy a certain equation to one coloumn only without extracting it I am making a code for MACONT and using 3 normalization technique, I am unable to normalization single column with their respective value (0-1) eventually ended up normalizing the the whole data from 0-1
Or is this possible to mulitpy a certain equation to one coloumn only without extracting it macont MATLAB Answers — New Questions
Using matlab from local computer to connect and transfer files to remote computer
Hello all,
I am trying to write a script to login to a remote computer, transfer the local files, and run some programs on the remote computer. I am using a linux system and I am able to login to the remote computer (also linux) using the unix(‘ssh -Y username@hostname’) matlab command, but once I login, the commands written in the editor after this do not execute. For example, I would like to execute the print working directory (pwd) command after logging in to the remote computer.
Script I have written in the editor for the login and pwd command:
unix(‘ssh -Y username@hostname’);
unix(‘pwd’);
What the matlab command window shows me:
>> script
username@hostname’s Password: *enter password in command window*
username@hostname-login2:~>
Now the unix(‘pwd’) command does not seem to execute in the username@hostname-login2:~>
To execute the pwd command, I would have to go to the command window and type it. My question is how do I write the script in the matlab editor so that the pwd command is executed from the editor itself when running the script?
Let me know if you need additional details. Thanks in advance for your help.
Regards,
SouHello all,
I am trying to write a script to login to a remote computer, transfer the local files, and run some programs on the remote computer. I am using a linux system and I am able to login to the remote computer (also linux) using the unix(‘ssh -Y username@hostname’) matlab command, but once I login, the commands written in the editor after this do not execute. For example, I would like to execute the print working directory (pwd) command after logging in to the remote computer.
Script I have written in the editor for the login and pwd command:
unix(‘ssh -Y username@hostname’);
unix(‘pwd’);
What the matlab command window shows me:
>> script
username@hostname’s Password: *enter password in command window*
username@hostname-login2:~>
Now the unix(‘pwd’) command does not seem to execute in the username@hostname-login2:~>
To execute the pwd command, I would have to go to the command window and type it. My question is how do I write the script in the matlab editor so that the pwd command is executed from the editor itself when running the script?
Let me know if you need additional details. Thanks in advance for your help.
Regards,
Sou Hello all,
I am trying to write a script to login to a remote computer, transfer the local files, and run some programs on the remote computer. I am using a linux system and I am able to login to the remote computer (also linux) using the unix(‘ssh -Y username@hostname’) matlab command, but once I login, the commands written in the editor after this do not execute. For example, I would like to execute the print working directory (pwd) command after logging in to the remote computer.
Script I have written in the editor for the login and pwd command:
unix(‘ssh -Y username@hostname’);
unix(‘pwd’);
What the matlab command window shows me:
>> script
username@hostname’s Password: *enter password in command window*
username@hostname-login2:~>
Now the unix(‘pwd’) command does not seem to execute in the username@hostname-login2:~>
To execute the pwd command, I would have to go to the command window and type it. My question is how do I write the script in the matlab editor so that the pwd command is executed from the editor itself when running the script?
Let me know if you need additional details. Thanks in advance for your help.
Regards,
Sou ssh remote login, unix command MATLAB Answers — New Questions
ZAP (Zero-Hour Auto Purge) on internal traffic
Greetings !!
Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”.
I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ?
Any thoughts ?
Thank you.
Greetings !!Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”. I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ? Any thoughts ? Thank you. Read More
Images are broken in Microsoft Teams Bot – Intermittently in the New Teams
When we are trying to upload the large image size, there is a delay in rendering within the Teams bot. This problem was not present in the older version of Teams.
When we are trying to upload the large image size, there is a delay in rendering within the Teams bot. This problem was not present in the older version of Teams. Read More
How can I force to install Windows 11 on unsupported PC?
I recently tried to install Windows 11 on my old unsupported PC and ran into a tricky problem because my hardware doesn’t meet the official system requirements. Despite running compatibility checks, I’m wondering if there is a way to bypass these limitations and force an installation. My PC is currently running an older version of Windows which works fine for my needs. I realize that forcing the installation could lead to potential problems or lack of support from Microsoft, but I am willing to take that risk. Can anyone walk me through these steps or provide a reliable way to install Windows 11 on unsupported hardware?
I recently tried to install Windows 11 on my old unsupported PC and ran into a tricky problem because my hardware doesn’t meet the official system requirements. Despite running compatibility checks, I’m wondering if there is a way to bypass these limitations and force an installation. My PC is currently running an older version of Windows which works fine for my needs. I realize that forcing the installation could lead to potential problems or lack of support from Microsoft, but I am willing to take that risk. Can anyone walk me through these steps or provide a reliable way to install Windows 11 on unsupported hardware? Read More
Since 22H2, File Explorer windows sometimes spontaneously move to the front
I normally close File Explorer windows after using them, but sometimes I forget, and since the 22H2 update, I’ve noticed that File Explorer windows sometimes spontaneously move to the front. After engaging in an arms race with developers in the 90’s and 00’s to stop programs from stealing focus in this way, Microsoft seems to have largely given up on preventing applications from doing this, but these Explorer windows are just sitting there doing nothing when it happens. They haven’t completed any action and have no reason to try to get attention, which is usually why apps want to do this. I can’t be sure, but this new behavior may have begun when File Explorer tabs were enabled, but using tabs is not a condition for the misbehavior. It definitely did not happen before 22H2. No other windows do this. Anyone else notice this? Read More
Need PNP Search results webpart to display metadata column that I added in a SharePoint library
I have an issue trying to get a SharePoint Doc Library metadata column to show up in PNP Search results webpart. Here are the details:
I have a SharePoint Site where I am just leveraging the default document Library “Documents”.
In this Library, there are the default columns “Name”, “Modified” etc. I have also created a new Metadata column called “Document type” that holds values “Test” and “Production” as choice values.
I have created two folders in this Lib called “Test Docs” and “Production Docs”
I have configured the library settings such that when user uploads document into “Test docs” folder, the column “document type” automatically gets tagged with the value “test”. Similarly when a doc is uploaded to the “Production docs” folder, this column gets tagged with value “Production”. See example image below:
I have then setup PnP Search webparts in a page in this Site. The PnP Search results webpart in this page refers to the “Documents” library above, and to return the results based on the “PnP search box” search.
I am having trouble getting the PnP search results webpart to display the metadata column which I created in the library “Document type”.
I need “document type” displayed in the PNP Search results webpart, as I need to restrict user access based on the tag value of the document in this column. So 2 things I am trying to achieve here :
1. Get the “document type” metadata column to appear in PNP Search results webpart, but I am unable to add this column to the PnP search results webpart view. I cant see this column in the list of columns when I edit this webpart (Please advice if I should do some mapping of that document type column to get it to show in the webpart view):
Please advice.
2. Once the column is displayed in the PnP search results view, I need to setup the following restriction.
– When a user of country A logs in, they should be able to only see the documents tagged as “Test” in the document type column. Same way if a user of country B logs in, they should only see the documents they are supposed to see (for eg “Production” tagged docs).
I have an issue trying to get a SharePoint Doc Library metadata column to show up in PNP Search results webpart. Here are the details:I have a SharePoint Site where I am just leveraging the default document Library “Documents”.In this Library, there are the default columns “Name”, “Modified” etc. I have also created a new Metadata column called “Document type” that holds values “Test” and “Production” as choice values.I have created two folders in this Lib called “Test Docs” and “Production Docs”I have configured the library settings such that when user uploads document into “Test docs” folder, the column “document type” automatically gets tagged with the value “test”. Similarly when a doc is uploaded to the “Production docs” folder, this column gets tagged with value “Production”. See example image below:I have then setup PnP Search webparts in a page in this Site. The PnP Search results webpart in this page refers to the “Documents” library above, and to return the results based on the “PnP search box” search.I am having trouble getting the PnP search results webpart to display the metadata column which I created in the library “Document type”.I need “document type” displayed in the PNP Search results webpart, as I need to restrict user access based on the tag value of the document in this column. So 2 things I am trying to achieve here :1. Get the “document type” metadata column to appear in PNP Search results webpart, but I am unable to add this column to the PnP search results webpart view. I cant see this column in the list of columns when I edit this webpart (Please advice if I should do some mapping of that document type column to get it to show in the webpart view):Please advice. 2. Once the column is displayed in the PnP search results view, I need to setup the following restriction.- When a user of country A logs in, they should be able to only see the documents tagged as “Test” in the document type column. Same way if a user of country B logs in, they should only see the documents they are supposed to see (for eg “Production” tagged docs). Read More
Accessed Denied error when deleting Classic WebPart via code (C# and/or PowerShell)
Hi guys,
We have an Azure (C#) Function that is used to build Subsites within a Classic Site Collection, that has been in use for many years. As part of building the sub site, the function manipulates the WebParts held within the default.aspx page, deleting OOTB supplied ones, and adding custom ones.
When we last tried to create a new subsite (on 13th June) the call to delete the WebPart failed with “Access Denied”. The run prior to that, on 5th June worked perfectly and there have been no code changes or updates in that period.
The C# Function connects to SharePoint using a ClientId/Secret created via the AppRegNew.aspx mechanism (since the application that the subsite belongs to is an AddOn app and the function is using the same Id/secret combination) with “Site Collection Full Control” permission, and the secret doesn’t expire until 11-Aug-2024.
The code in question is:
var homepage = web.GetFileByServerRelativeUrl(web.ServerRelativeUrl + “/default.aspx”);
web.Context.Load(homepage);
web.Context.ExecuteQuery();
LimitedWebPartManager wpm = homepage.GetLimitedWebPartManager(PersonalizationScope.Shared);
web.Context.Load(wpm);
web.Context.ExecuteQuery();
IEnumerable<WebPartDefinition> webPartDef = web.Context.LoadQuery(wpm.WebParts.Include(wp => wp.Id, wp => wp.WebPart.Title));
web.Context.ExecuteQuery();
if (webPartDef.Count() > 0)
{
foreach (var wpd in webPartDef)
{
if (wpd.WebPart.Title.ToLower().Equals(name.ToLower())) // If matched, remove.
wpd.DeleteWebPart(); // <=== This is now generating “Access Denied”
}
web.Context.ExecuteQuery();
}
Have tried raising Microsoft tickets, since we have Premier support, but the final one directed me to raise the issue here.
So really wondering what changed? NB: Deleting the web part using PowerShell (PnP.PowerShell module) under my Site Collection Admin credentials also fails.
Regards
Steve
Hi guys, We have an Azure (C#) Function that is used to build Subsites within a Classic Site Collection, that has been in use for many years. As part of building the sub site, the function manipulates the WebParts held within the default.aspx page, deleting OOTB supplied ones, and adding custom ones.When we last tried to create a new subsite (on 13th June) the call to delete the WebPart failed with “Access Denied”. The run prior to that, on 5th June worked perfectly and there have been no code changes or updates in that period.The C# Function connects to SharePoint using a ClientId/Secret created via the AppRegNew.aspx mechanism (since the application that the subsite belongs to is an AddOn app and the function is using the same Id/secret combination) with “Site Collection Full Control” permission, and the secret doesn’t expire until 11-Aug-2024.The code in question is:var homepage = web.GetFileByServerRelativeUrl(web.ServerRelativeUrl + “/default.aspx”);web.Context.Load(homepage);web.Context.ExecuteQuery();LimitedWebPartManager wpm = homepage.GetLimitedWebPartManager(PersonalizationScope.Shared);web.Context.Load(wpm);web.Context.ExecuteQuery();IEnumerable<WebPartDefinition> webPartDef = web.Context.LoadQuery(wpm.WebParts.Include(wp => wp.Id, wp => wp.WebPart.Title));web.Context.ExecuteQuery();if (webPartDef.Count() > 0){ foreach (var wpd in webPartDef) { if (wpd.WebPart.Title.ToLower().Equals(name.ToLower())) // If matched, remove. wpd.DeleteWebPart(); // <=== This is now generating “Access Denied” } web.Context.ExecuteQuery();}Have tried raising Microsoft tickets, since we have Premier support, but the final one directed me to raise the issue here.So really wondering what changed? NB: Deleting the web part using PowerShell (PnP.PowerShell module) under my Site Collection Admin credentials also fails.RegardsSteve Read More
I need a best YouTube to MP4 converter for my Windows 11 without ads
Due to the needs of my project, I am looking for a reliable & best YouTube to MP4 converter that will work properly in Windows 11. I’ve tried several options, but none of them quite fit my needs. I’m looking for a tool that maintains high quality video and offers a variety of resolution settings without ads or security issues. So far, the converters I’ve tested have been disappointing, either poor performance or too many ads. Can anyone recommend a reliable converter known for its efficiency and quality? Thank you for your help!
Due to the needs of my project, I am looking for a reliable & best YouTube to MP4 converter that will work properly in Windows 11. I’ve tried several options, but none of them quite fit my needs. I’m looking for a tool that maintains high quality video and offers a variety of resolution settings without ads or security issues. So far, the converters I’ve tested have been disappointing, either poor performance or too many ads. Can anyone recommend a reliable converter known for its efficiency and quality? Thank you for your help! Read More
Microsoft options for VMware migration
Looking to migrate from VMware to Windows Server 2025? Contact your Microsoft account team!
Windows Server 2025 is the most secure and performant release yet! Download the evaluation now!
Windows Server 2025 is the most secure and performant release yet! Download the evaluation now!
The 2024 Windows Server Summit was held in March and brought three days of demos, technical sessions, and Q&A, led by Microsoft engineers, guest experts from Intel®, and our MVP community. For more videos from this year’s Windows Server Summit, please find the full session list here.
Microsoft options for VMware migration
Recent developments in the on-premises virtualization market have unsettled users and prompted a re-evaluation of their organization’s strategy. Microsoft provides a robust set of solutions tailored to your specific goals and requirements. During this session, we will delve into these options, emphasizing the long-term advantages of choosing Microsoft & Hyper-V.
Microsoft Tech Community – Latest Blogs –Read More
Mass spring damper system problem
Hello, I am designing the mass spring damper system in the image. I am creating this code for the design of a ship crane. In my road equation, there is an increase of approximately 20 meters, and the spring k_c is stretched by 20 meters. I just want the spring to follow the road, but the spring follows the road like an arrow, which is very high like 2000N/mm². Stress occurs. I think there is a mistake in my input equation, but I couldn’t figure it out completely. I would be very happy if you could help me
The image of the system is also attached.
Matlab code:
"% System parameters
M_c = 917; % Mass of the crane boom (kg)
M_s = 87; % Mass of the shock absorber (kg)
M_WL = 4075; % Mass of the working load (kg)
k_c = 554376; % Spring constant of the crane + crane hook ropes (N/m)
k_s = 24162; % Spring constant of the shock absorber system (N/m)
k_R = 9090572; % Spring constant of the lifting beam and lower rope (N/m)
c_s = 5800; % Damping constant of the shock absorber system (Ns/m)
A = 1.5; % Amplitude of input signal (m)
omega = 1; % Angular frequency of input signal (rad/s)
V_H1 = 0.69; % Linear term coefficient for first interval (m/s)
V_H2 = 0; % Linear term coefficient for second interval (m/s)
V_H3 = -0.1; % Linear term coefficient for third interval (m/s)
d_c = 0.026; % Diameter of spring kc (m)
d_s = 0.03; % Diameter of spring ks (m)
d_R = 0.0226; % Diameter of spring kR (m)
% Combined time vector with smaller sampling period
t = 0:0.01:45; % From 0 to 45 seconds with 0.01s sampling period
% Input signal (m)
u = zeros(size(t));
u(t <= 25) = A * sin(omega * t(t <= 25)) + V_H1 * t(t <= 25);
u(t > 25 & t <= 35) = A * sin(omega * t(t > 25 & t <= 35)) + V_H1 * 25 + V_H2 * (t(t > 25 & t <= 35) – 25);
u(t > 35) = A * sin(omega * t(t > 35)) + V_H1 * 25 + V_H3 * (t(t > 35) – 35);
% State-space matrix
A_matrix = [0 1 0 0 0 0;
-k_c/M_c -c_s/M_c k_s/M_c c_s/M_c 0 0;
0 0 0 1 0 0;
k_s/M_s c_s/M_s -(k_s+k_R)/M_s -c_s/M_s k_R/M_s 0;
0 0 0 0 0 1;
0 0 k_R/M_WL 0 -k_R/M_WL 0];
B_matrix = [0;
k_c/M_c;
0;
0;
0;
0];
C_matrix = [1 0 0 0 0 0;
0 0 1 0 0 0;
0 0 0 0 1 0];
D_matrix = [0;
0;
0];
% Create state-space model
sys = ss(A_matrix, B_matrix, C_matrix, D_matrix);
% Simulate system response
[y, t, x] = lsim(sys, u, t);
% Calculate spring extensions (m)
delta_kc = u’- y(:,1); % Extension of spring kc
delta_ks = y(:,1) – y(:,2); % Extension of spring ks
delta_kR = y(:,2) – y(:,3); % Extension of spring kR
% Convert spring extensions to meters (m)
delta_kc_m = delta_kc; % Assuming input signal u is in meters
delta_ks_m = delta_ks; % Assuming displacements are in meters
delta_kR_m = delta_kR; % Assuming displacements are in meters
% Calculate spring stresses (N/m²)
A_c = pi * (d_c/2)^2; % Cross-sectional area of spring kc (m²)
A_s = pi * (d_s/2)^2; % Cross-sectional area of spring ks (m²)
A_R = pi * (d_R/2)^2; % Cross-sectional area of spring kR (m²)
F_kc = k_c * delta_kc_m; % Force in spring kc (N)
F_ks = k_s * delta_ks_m; % Force in spring ks (N)
F_kR = k_R * delta_kR_m; % Force in spring kR (N)
sigma_kc = F_kc / A_c; % Stress in spring kc (N/m²)
sigma_ks = F_ks / A_s; % Stress in spring ks (N/m²)
sigma_kR = F_kR / A_R; % Stress in spring kR (N/m²)
% Convert stress to N/mm²
sigma_kc_mm2 = sigma_kc * 1e-6;
sigma_ks_mm2 = sigma_ks * 1e-6;
sigma_kR_mm2 = sigma_kR * 1e-6;
% Plot input signal and outputs
figure;
subplot(5,1,1);
plot(t, u);
title(‘Input Signal u’);
xlabel(‘Time (s)’);
ylabel(‘u (m)’);
subplot(5,1,2);
plot(t, y(:,1));
title(‘Output y1’);
xlabel(‘Time (s)’);
ylabel(‘y1 (m)’);
subplot(5,1,3);
plot(t, y(:,2));
title(‘Output y2’);
xlabel(‘Time (s)’);
ylabel(‘y2 (m)’);
subplot(5,1,4);
plot(t, y(:,3));
title(‘Output y3’);
xlabel(‘Time (s)’);
ylabel(‘y3 (m)’);
% Plot spring stresses in separate figures
subplot(5,1,5);
hold on;
plot(t, sigma_kc_mm2, ‘r’);
plot(t, sigma_ks_mm2, ‘g’);
plot(t, sigma_kR_mm2, ‘b’);
title(‘Stress in Springs’);
xlabel(‘Time (s)’);
ylabel(‘Stress (N/mm²)’);
legend(‘Stress sigma_{kc}’, ‘Stress sigma_{ks}’, ‘Stress sigma_{kR}’);
grid on;
% Animation
figure;
% Define positions of masses and springs
y1_base = 2; % Base position of mass 1 (m)
y2_base = 1; % Base position of mass 2 (m)
y3_base = 0; % Base position of mass 3 (m)
% Plot settings
axis([-0.5 1.5 -1 30]);
hold on;
% Initial positions of masses
h_m1 = rectangle(‘Position’,[0.4 y1_base + y(1,1) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘blue’);
h_m2 = rectangle(‘Position’,[0.4 y2_base + y(1,2) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘green’);
h_m3 = rectangle(‘Position’,[0.4 y3_base + y(1,3) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘red’);
% Labels for masses
text(0.65, y1_base + y(1,1) + 0.1, ‘M_c’, ‘FontSize’, 12, ‘Color’, ‘blue’);
text(0.65, y2_base + y(1,2) + 0.1, ‘M_s’, ‘FontSize’, 12, ‘Color’, ‘green’);
text(0.65, y3_base + y(1,3) + 0.1, ‘M_{WL}’, ‘FontSize’, 12, ‘Color’, ‘red’);
% Initial positions of springs
h_spring1 = plot([0.5 0.5], [3 y1_base + y(1,1) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring2 = plot([0.5 0.5], [y1_base + y(1,1) y2_base + y(1,2) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring3 = plot([0.5 0.5], [y2_base + y(1,2) y3_base + y(1,3) + 0.2], ‘k’, ‘LineWidth’, 2);
% Labels for springs and dampers
text(0.3, 2.5, ‘k_c’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 1.5, ‘k_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 0.5, ‘k_R’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.7, y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2, ‘c_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
% Initial position of the damper
h_damper = plot([0.45 0.55], [y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2], ‘k’, ‘LineWidth’, 6);
% Animation loop
for i = 1:length(t)
% Update positions of masses
if isvalid(h_m1)
set(h_m1, ‘Position’, [0.4 y1_base + y(i,1) 0.2 0.2]);
end
if isvalid(h_m2)
set(h_m2, ‘Position’, [0.4 y2_base + y(i,2) 0.2 0.2]);
end
if isvalid(h_m3)
set(h_m3, ‘Position’, [0.4 y3_base + y(i,3) 0.2 0.2]);
end
% Update positions of springs
if isvalid(h_spring1)
set(h_spring1, ‘YData’, [3 y1_base + y(i,1) + 0.2]);
end
if isvalid(h_spring2)
set(h_spring2, ‘YData’, [y1_base + y(i,1) y2_base + y(i,2) + 0.2]);
end
if isvalid(h_spring3)
set(h_spring3, ‘YData’, [y2_base + y(i,2) y3_base + y(i,3) + 0.2]);
end
% Update position of the damper
if isvalid(h_damper)
set(h_damper, ‘YData’, [y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2]);
end
% Pause to create animation effect
pause(0.01);
end
hold off;
"Hello, I am designing the mass spring damper system in the image. I am creating this code for the design of a ship crane. In my road equation, there is an increase of approximately 20 meters, and the spring k_c is stretched by 20 meters. I just want the spring to follow the road, but the spring follows the road like an arrow, which is very high like 2000N/mm². Stress occurs. I think there is a mistake in my input equation, but I couldn’t figure it out completely. I would be very happy if you could help me
The image of the system is also attached.
Matlab code:
"% System parameters
M_c = 917; % Mass of the crane boom (kg)
M_s = 87; % Mass of the shock absorber (kg)
M_WL = 4075; % Mass of the working load (kg)
k_c = 554376; % Spring constant of the crane + crane hook ropes (N/m)
k_s = 24162; % Spring constant of the shock absorber system (N/m)
k_R = 9090572; % Spring constant of the lifting beam and lower rope (N/m)
c_s = 5800; % Damping constant of the shock absorber system (Ns/m)
A = 1.5; % Amplitude of input signal (m)
omega = 1; % Angular frequency of input signal (rad/s)
V_H1 = 0.69; % Linear term coefficient for first interval (m/s)
V_H2 = 0; % Linear term coefficient for second interval (m/s)
V_H3 = -0.1; % Linear term coefficient for third interval (m/s)
d_c = 0.026; % Diameter of spring kc (m)
d_s = 0.03; % Diameter of spring ks (m)
d_R = 0.0226; % Diameter of spring kR (m)
% Combined time vector with smaller sampling period
t = 0:0.01:45; % From 0 to 45 seconds with 0.01s sampling period
% Input signal (m)
u = zeros(size(t));
u(t <= 25) = A * sin(omega * t(t <= 25)) + V_H1 * t(t <= 25);
u(t > 25 & t <= 35) = A * sin(omega * t(t > 25 & t <= 35)) + V_H1 * 25 + V_H2 * (t(t > 25 & t <= 35) – 25);
u(t > 35) = A * sin(omega * t(t > 35)) + V_H1 * 25 + V_H3 * (t(t > 35) – 35);
% State-space matrix
A_matrix = [0 1 0 0 0 0;
-k_c/M_c -c_s/M_c k_s/M_c c_s/M_c 0 0;
0 0 0 1 0 0;
k_s/M_s c_s/M_s -(k_s+k_R)/M_s -c_s/M_s k_R/M_s 0;
0 0 0 0 0 1;
0 0 k_R/M_WL 0 -k_R/M_WL 0];
B_matrix = [0;
k_c/M_c;
0;
0;
0;
0];
C_matrix = [1 0 0 0 0 0;
0 0 1 0 0 0;
0 0 0 0 1 0];
D_matrix = [0;
0;
0];
% Create state-space model
sys = ss(A_matrix, B_matrix, C_matrix, D_matrix);
% Simulate system response
[y, t, x] = lsim(sys, u, t);
% Calculate spring extensions (m)
delta_kc = u’- y(:,1); % Extension of spring kc
delta_ks = y(:,1) – y(:,2); % Extension of spring ks
delta_kR = y(:,2) – y(:,3); % Extension of spring kR
% Convert spring extensions to meters (m)
delta_kc_m = delta_kc; % Assuming input signal u is in meters
delta_ks_m = delta_ks; % Assuming displacements are in meters
delta_kR_m = delta_kR; % Assuming displacements are in meters
% Calculate spring stresses (N/m²)
A_c = pi * (d_c/2)^2; % Cross-sectional area of spring kc (m²)
A_s = pi * (d_s/2)^2; % Cross-sectional area of spring ks (m²)
A_R = pi * (d_R/2)^2; % Cross-sectional area of spring kR (m²)
F_kc = k_c * delta_kc_m; % Force in spring kc (N)
F_ks = k_s * delta_ks_m; % Force in spring ks (N)
F_kR = k_R * delta_kR_m; % Force in spring kR (N)
sigma_kc = F_kc / A_c; % Stress in spring kc (N/m²)
sigma_ks = F_ks / A_s; % Stress in spring ks (N/m²)
sigma_kR = F_kR / A_R; % Stress in spring kR (N/m²)
% Convert stress to N/mm²
sigma_kc_mm2 = sigma_kc * 1e-6;
sigma_ks_mm2 = sigma_ks * 1e-6;
sigma_kR_mm2 = sigma_kR * 1e-6;
% Plot input signal and outputs
figure;
subplot(5,1,1);
plot(t, u);
title(‘Input Signal u’);
xlabel(‘Time (s)’);
ylabel(‘u (m)’);
subplot(5,1,2);
plot(t, y(:,1));
title(‘Output y1’);
xlabel(‘Time (s)’);
ylabel(‘y1 (m)’);
subplot(5,1,3);
plot(t, y(:,2));
title(‘Output y2’);
xlabel(‘Time (s)’);
ylabel(‘y2 (m)’);
subplot(5,1,4);
plot(t, y(:,3));
title(‘Output y3’);
xlabel(‘Time (s)’);
ylabel(‘y3 (m)’);
% Plot spring stresses in separate figures
subplot(5,1,5);
hold on;
plot(t, sigma_kc_mm2, ‘r’);
plot(t, sigma_ks_mm2, ‘g’);
plot(t, sigma_kR_mm2, ‘b’);
title(‘Stress in Springs’);
xlabel(‘Time (s)’);
ylabel(‘Stress (N/mm²)’);
legend(‘Stress sigma_{kc}’, ‘Stress sigma_{ks}’, ‘Stress sigma_{kR}’);
grid on;
% Animation
figure;
% Define positions of masses and springs
y1_base = 2; % Base position of mass 1 (m)
y2_base = 1; % Base position of mass 2 (m)
y3_base = 0; % Base position of mass 3 (m)
% Plot settings
axis([-0.5 1.5 -1 30]);
hold on;
% Initial positions of masses
h_m1 = rectangle(‘Position’,[0.4 y1_base + y(1,1) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘blue’);
h_m2 = rectangle(‘Position’,[0.4 y2_base + y(1,2) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘green’);
h_m3 = rectangle(‘Position’,[0.4 y3_base + y(1,3) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘red’);
% Labels for masses
text(0.65, y1_base + y(1,1) + 0.1, ‘M_c’, ‘FontSize’, 12, ‘Color’, ‘blue’);
text(0.65, y2_base + y(1,2) + 0.1, ‘M_s’, ‘FontSize’, 12, ‘Color’, ‘green’);
text(0.65, y3_base + y(1,3) + 0.1, ‘M_{WL}’, ‘FontSize’, 12, ‘Color’, ‘red’);
% Initial positions of springs
h_spring1 = plot([0.5 0.5], [3 y1_base + y(1,1) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring2 = plot([0.5 0.5], [y1_base + y(1,1) y2_base + y(1,2) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring3 = plot([0.5 0.5], [y2_base + y(1,2) y3_base + y(1,3) + 0.2], ‘k’, ‘LineWidth’, 2);
% Labels for springs and dampers
text(0.3, 2.5, ‘k_c’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 1.5, ‘k_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 0.5, ‘k_R’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.7, y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2, ‘c_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
% Initial position of the damper
h_damper = plot([0.45 0.55], [y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2], ‘k’, ‘LineWidth’, 6);
% Animation loop
for i = 1:length(t)
% Update positions of masses
if isvalid(h_m1)
set(h_m1, ‘Position’, [0.4 y1_base + y(i,1) 0.2 0.2]);
end
if isvalid(h_m2)
set(h_m2, ‘Position’, [0.4 y2_base + y(i,2) 0.2 0.2]);
end
if isvalid(h_m3)
set(h_m3, ‘Position’, [0.4 y3_base + y(i,3) 0.2 0.2]);
end
% Update positions of springs
if isvalid(h_spring1)
set(h_spring1, ‘YData’, [3 y1_base + y(i,1) + 0.2]);
end
if isvalid(h_spring2)
set(h_spring2, ‘YData’, [y1_base + y(i,1) y2_base + y(i,2) + 0.2]);
end
if isvalid(h_spring3)
set(h_spring3, ‘YData’, [y2_base + y(i,2) y3_base + y(i,3) + 0.2]);
end
% Update position of the damper
if isvalid(h_damper)
set(h_damper, ‘YData’, [y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2]);
end
% Pause to create animation effect
pause(0.01);
end
hold off;
" Hello, I am designing the mass spring damper system in the image. I am creating this code for the design of a ship crane. In my road equation, there is an increase of approximately 20 meters, and the spring k_c is stretched by 20 meters. I just want the spring to follow the road, but the spring follows the road like an arrow, which is very high like 2000N/mm². Stress occurs. I think there is a mistake in my input equation, but I couldn’t figure it out completely. I would be very happy if you could help me
The image of the system is also attached.
Matlab code:
"% System parameters
M_c = 917; % Mass of the crane boom (kg)
M_s = 87; % Mass of the shock absorber (kg)
M_WL = 4075; % Mass of the working load (kg)
k_c = 554376; % Spring constant of the crane + crane hook ropes (N/m)
k_s = 24162; % Spring constant of the shock absorber system (N/m)
k_R = 9090572; % Spring constant of the lifting beam and lower rope (N/m)
c_s = 5800; % Damping constant of the shock absorber system (Ns/m)
A = 1.5; % Amplitude of input signal (m)
omega = 1; % Angular frequency of input signal (rad/s)
V_H1 = 0.69; % Linear term coefficient for first interval (m/s)
V_H2 = 0; % Linear term coefficient for second interval (m/s)
V_H3 = -0.1; % Linear term coefficient for third interval (m/s)
d_c = 0.026; % Diameter of spring kc (m)
d_s = 0.03; % Diameter of spring ks (m)
d_R = 0.0226; % Diameter of spring kR (m)
% Combined time vector with smaller sampling period
t = 0:0.01:45; % From 0 to 45 seconds with 0.01s sampling period
% Input signal (m)
u = zeros(size(t));
u(t <= 25) = A * sin(omega * t(t <= 25)) + V_H1 * t(t <= 25);
u(t > 25 & t <= 35) = A * sin(omega * t(t > 25 & t <= 35)) + V_H1 * 25 + V_H2 * (t(t > 25 & t <= 35) – 25);
u(t > 35) = A * sin(omega * t(t > 35)) + V_H1 * 25 + V_H3 * (t(t > 35) – 35);
% State-space matrix
A_matrix = [0 1 0 0 0 0;
-k_c/M_c -c_s/M_c k_s/M_c c_s/M_c 0 0;
0 0 0 1 0 0;
k_s/M_s c_s/M_s -(k_s+k_R)/M_s -c_s/M_s k_R/M_s 0;
0 0 0 0 0 1;
0 0 k_R/M_WL 0 -k_R/M_WL 0];
B_matrix = [0;
k_c/M_c;
0;
0;
0;
0];
C_matrix = [1 0 0 0 0 0;
0 0 1 0 0 0;
0 0 0 0 1 0];
D_matrix = [0;
0;
0];
% Create state-space model
sys = ss(A_matrix, B_matrix, C_matrix, D_matrix);
% Simulate system response
[y, t, x] = lsim(sys, u, t);
% Calculate spring extensions (m)
delta_kc = u’- y(:,1); % Extension of spring kc
delta_ks = y(:,1) – y(:,2); % Extension of spring ks
delta_kR = y(:,2) – y(:,3); % Extension of spring kR
% Convert spring extensions to meters (m)
delta_kc_m = delta_kc; % Assuming input signal u is in meters
delta_ks_m = delta_ks; % Assuming displacements are in meters
delta_kR_m = delta_kR; % Assuming displacements are in meters
% Calculate spring stresses (N/m²)
A_c = pi * (d_c/2)^2; % Cross-sectional area of spring kc (m²)
A_s = pi * (d_s/2)^2; % Cross-sectional area of spring ks (m²)
A_R = pi * (d_R/2)^2; % Cross-sectional area of spring kR (m²)
F_kc = k_c * delta_kc_m; % Force in spring kc (N)
F_ks = k_s * delta_ks_m; % Force in spring ks (N)
F_kR = k_R * delta_kR_m; % Force in spring kR (N)
sigma_kc = F_kc / A_c; % Stress in spring kc (N/m²)
sigma_ks = F_ks / A_s; % Stress in spring ks (N/m²)
sigma_kR = F_kR / A_R; % Stress in spring kR (N/m²)
% Convert stress to N/mm²
sigma_kc_mm2 = sigma_kc * 1e-6;
sigma_ks_mm2 = sigma_ks * 1e-6;
sigma_kR_mm2 = sigma_kR * 1e-6;
% Plot input signal and outputs
figure;
subplot(5,1,1);
plot(t, u);
title(‘Input Signal u’);
xlabel(‘Time (s)’);
ylabel(‘u (m)’);
subplot(5,1,2);
plot(t, y(:,1));
title(‘Output y1’);
xlabel(‘Time (s)’);
ylabel(‘y1 (m)’);
subplot(5,1,3);
plot(t, y(:,2));
title(‘Output y2’);
xlabel(‘Time (s)’);
ylabel(‘y2 (m)’);
subplot(5,1,4);
plot(t, y(:,3));
title(‘Output y3’);
xlabel(‘Time (s)’);
ylabel(‘y3 (m)’);
% Plot spring stresses in separate figures
subplot(5,1,5);
hold on;
plot(t, sigma_kc_mm2, ‘r’);
plot(t, sigma_ks_mm2, ‘g’);
plot(t, sigma_kR_mm2, ‘b’);
title(‘Stress in Springs’);
xlabel(‘Time (s)’);
ylabel(‘Stress (N/mm²)’);
legend(‘Stress sigma_{kc}’, ‘Stress sigma_{ks}’, ‘Stress sigma_{kR}’);
grid on;
% Animation
figure;
% Define positions of masses and springs
y1_base = 2; % Base position of mass 1 (m)
y2_base = 1; % Base position of mass 2 (m)
y3_base = 0; % Base position of mass 3 (m)
% Plot settings
axis([-0.5 1.5 -1 30]);
hold on;
% Initial positions of masses
h_m1 = rectangle(‘Position’,[0.4 y1_base + y(1,1) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘blue’);
h_m2 = rectangle(‘Position’,[0.4 y2_base + y(1,2) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘green’);
h_m3 = rectangle(‘Position’,[0.4 y3_base + y(1,3) 0.2 0.2], ‘Curvature’, [0.1 0.1], ‘FaceColor’, ‘red’);
% Labels for masses
text(0.65, y1_base + y(1,1) + 0.1, ‘M_c’, ‘FontSize’, 12, ‘Color’, ‘blue’);
text(0.65, y2_base + y(1,2) + 0.1, ‘M_s’, ‘FontSize’, 12, ‘Color’, ‘green’);
text(0.65, y3_base + y(1,3) + 0.1, ‘M_{WL}’, ‘FontSize’, 12, ‘Color’, ‘red’);
% Initial positions of springs
h_spring1 = plot([0.5 0.5], [3 y1_base + y(1,1) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring2 = plot([0.5 0.5], [y1_base + y(1,1) y2_base + y(1,2) + 0.2], ‘k’, ‘LineWidth’, 2);
h_spring3 = plot([0.5 0.5], [y2_base + y(1,2) y3_base + y(1,3) + 0.2], ‘k’, ‘LineWidth’, 2);
% Labels for springs and dampers
text(0.3, 2.5, ‘k_c’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 1.5, ‘k_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.3, 0.5, ‘k_R’, ‘FontSize’, 12, ‘Color’, ‘black’);
text(0.7, y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2, ‘c_s’, ‘FontSize’, 12, ‘Color’, ‘black’);
% Initial position of the damper
h_damper = plot([0.45 0.55], [y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(1,1) / 2 + y(1,2) / 2], ‘k’, ‘LineWidth’, 6);
% Animation loop
for i = 1:length(t)
% Update positions of masses
if isvalid(h_m1)
set(h_m1, ‘Position’, [0.4 y1_base + y(i,1) 0.2 0.2]);
end
if isvalid(h_m2)
set(h_m2, ‘Position’, [0.4 y2_base + y(i,2) 0.2 0.2]);
end
if isvalid(h_m3)
set(h_m3, ‘Position’, [0.4 y3_base + y(i,3) 0.2 0.2]);
end
% Update positions of springs
if isvalid(h_spring1)
set(h_spring1, ‘YData’, [3 y1_base + y(i,1) + 0.2]);
end
if isvalid(h_spring2)
set(h_spring2, ‘YData’, [y1_base + y(i,1) y2_base + y(i,2) + 0.2]);
end
if isvalid(h_spring3)
set(h_spring3, ‘YData’, [y2_base + y(i,2) y3_base + y(i,3) + 0.2]);
end
% Update position of the damper
if isvalid(h_damper)
set(h_damper, ‘YData’, [y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2 y1_base + (y2_base – y1_base) / 2 + y(i,1) / 2 + y(i,2) / 2]);
end
% Pause to create animation effect
pause(0.01);
end
hold off;
" matlab code, mass spring damper, matlab MATLAB Answers — New Questions
Power operator (^) precedence levels and evaluation order
While
2^-1^-2
returns 4, which indicates a "left to right" evaluation order (as it is common in many programming languages),
2^-1^-2^3
returns 0.125, which I find surprising – I would have expected a value of 4^3 = 64.
To examine the order applied by Matlab, I tried all possible combinations:
((2^-1)^-2)^3 % returns 64 (1st, then 2nd operator)
(2^-1)^-(2^3) % returns 256 (1st and 3rd)
(2^-(1^-2))^3 % returns 0.125 (2nd, then 1st)
2^-((1^-2)^3) % returns 0.5 (2nd, then 3rd)
2^-(1^-(2^3)) % returns 0.5 (3rd, then 2nd)
So it seems that Matlab first evaluates the 2nd operator, then the 1st (=left), then the 3rd (=rightmost). That seems very odd. Can anybody explain why Matlab chooses this evaluation order?
I’m aware of https://de.mathworks.com/help/matlab/matlab_prog/operator-precedence.html, but it just doesn’t make sense to me. According to the rules given there, the 3rd operator (^) in my example should even come first, as it has a higher precedence than the other two (^-) operators. So doesn’t Matlab adhere to its own rules?While
2^-1^-2
returns 4, which indicates a "left to right" evaluation order (as it is common in many programming languages),
2^-1^-2^3
returns 0.125, which I find surprising – I would have expected a value of 4^3 = 64.
To examine the order applied by Matlab, I tried all possible combinations:
((2^-1)^-2)^3 % returns 64 (1st, then 2nd operator)
(2^-1)^-(2^3) % returns 256 (1st and 3rd)
(2^-(1^-2))^3 % returns 0.125 (2nd, then 1st)
2^-((1^-2)^3) % returns 0.5 (2nd, then 3rd)
2^-(1^-(2^3)) % returns 0.5 (3rd, then 2nd)
So it seems that Matlab first evaluates the 2nd operator, then the 1st (=left), then the 3rd (=rightmost). That seems very odd. Can anybody explain why Matlab chooses this evaluation order?
I’m aware of https://de.mathworks.com/help/matlab/matlab_prog/operator-precedence.html, but it just doesn’t make sense to me. According to the rules given there, the 3rd operator (^) in my example should even come first, as it has a higher precedence than the other two (^-) operators. So doesn’t Matlab adhere to its own rules? While
2^-1^-2
returns 4, which indicates a "left to right" evaluation order (as it is common in many programming languages),
2^-1^-2^3
returns 0.125, which I find surprising – I would have expected a value of 4^3 = 64.
To examine the order applied by Matlab, I tried all possible combinations:
((2^-1)^-2)^3 % returns 64 (1st, then 2nd operator)
(2^-1)^-(2^3) % returns 256 (1st and 3rd)
(2^-(1^-2))^3 % returns 0.125 (2nd, then 1st)
2^-((1^-2)^3) % returns 0.5 (2nd, then 3rd)
2^-(1^-(2^3)) % returns 0.5 (3rd, then 2nd)
So it seems that Matlab first evaluates the 2nd operator, then the 1st (=left), then the 3rd (=rightmost). That seems very odd. Can anybody explain why Matlab chooses this evaluation order?
I’m aware of https://de.mathworks.com/help/matlab/matlab_prog/operator-precedence.html, but it just doesn’t make sense to me. According to the rules given there, the 3rd operator (^) in my example should even come first, as it has a higher precedence than the other two (^-) operators. So doesn’t Matlab adhere to its own rules? power operator, precedence level, evaluation order, ^- MATLAB Answers — New Questions
How to interpolate 2-parameter dependents matrices?
So i have a set of matrixes F computed in different points (for each matrix there is associated a pair of points V,q). How do i compute an interpolation which gives me all possible F matrixes for values of (V,q) in a certain range not present in my dataset?
I wish i’ve been clear in my question, thank youSo i have a set of matrixes F computed in different points (for each matrix there is associated a pair of points V,q). How do i compute an interpolation which gives me all possible F matrixes for values of (V,q) in a certain range not present in my dataset?
I wish i’ve been clear in my question, thank you So i have a set of matrixes F computed in different points (for each matrix there is associated a pair of points V,q). How do i compute an interpolation which gives me all possible F matrixes for values of (V,q) in a certain range not present in my dataset?
I wish i’ve been clear in my question, thank you interpolation, lpv system, control engineering, gain scheduling MATLAB Answers — New Questions
Creating a 7-day retention policy to target recordings and transcripts only
Hi everyone! As the title says, we are trying to create a 7-day retention policy that would target transcripts and recordings only without affecting emails and other mailbox artifacts. So this policy would have to delete the recordings and transcripts only after 7 days. Is there a way to do this? Thank you!
Hi everyone! As the title says, we are trying to create a 7-day retention policy that would target transcripts and recordings only without affecting emails and other mailbox artifacts. So this policy would have to delete the recordings and transcripts only after 7 days. Is there a way to do this? Thank you! Read More
Azure Open AI
Hi Team, I have been trying to use gpt-4o capability on azure open-ai to pass base64 encoded image. But I m getting this response:
{“requestPayload”:null,”meta”:{“blocking”:true},”status”:”completed”,”planId”:”38334edf2b3242102d79fa97ce91bf37″,”capabilities”:{“35070ec3fbb68e5007e5f69605efdc04”:{“provider”:”Azure OpenAI”,”response”:”The provided JSON contains a structure with two main elements: a text prompt and an image URL. The text prompt asks, “What’s in this image?” and the image URL is encoded in base64 format. However, the base64 string for the image is incomplete and appears to be corrupted or truncated.nnTo properly analyze the image, the complete base64 string is required. If you can provide the full base64 string, I can help you decode and analyze the image. Alternatively, you can upload the image to a file-sharing service and provide the link.”,”logId”:”7b40eb2b3b32c210f27a3c8c24e45ae1″,”status”:”success”}},”startedAt”:”2024-06-21 03:38:59″,”completedAt”:”2024-06-21 03:39:07″,”transactionId”:”e5564919-b644-43fb-b0ba-a2bc60016513″,”message”:null}
I have ensured the image URL is correct and contains correct base64 value but still its not working. What could be the issue?
Hi Team, I have been trying to use gpt-4o capability on azure open-ai to pass base64 encoded image. But I m getting this response: {“requestPayload”:null,”meta”:{“blocking”:true},”status”:”completed”,”planId”:”38334edf2b3242102d79fa97ce91bf37″,”capabilities”:{“35070ec3fbb68e5007e5f69605efdc04”:{“provider”:”Azure OpenAI”,”response”:”The provided JSON contains a structure with two main elements: a text prompt and an image URL. The text prompt asks, “What’s in this image?” and the image URL is encoded in base64 format. However, the base64 string for the image is incomplete and appears to be corrupted or truncated.nnTo properly analyze the image, the complete base64 string is required. If you can provide the full base64 string, I can help you decode and analyze the image. Alternatively, you can upload the image to a file-sharing service and provide the link.”,”logId”:”7b40eb2b3b32c210f27a3c8c24e45ae1″,”status”:”success”}},”startedAt”:”2024-06-21 03:38:59″,”completedAt”:”2024-06-21 03:39:07″,”transactionId”:”e5564919-b644-43fb-b0ba-a2bc60016513″,”message”:null} I have ensured the image URL is correct and contains correct base64 value but still its not working. What could be the issue? Read More
Is it possible to run VsTest in azure pipelines against pre-installed test project
Hi All
I have an azure pipeline that deploys candidate releases to a staging server. When the server update is complete a series of automated tests are then run, this is the current layout.
Now the completion speed for all tasks is not bad but as always the question is can we make it faster? So because these are smoke tests they do not change very often which makes me think instead of the Restore and Build steps can we not simply have a ready built solution installed on Azure so then all we have to do is run the final VsTest step?
We are using VS and Playwright for the test project
I have never done it that way before so my questions are. Can it be done? and how please?
Thanks in advance for any help here.
Hi AllI have an azure pipeline that deploys candidate releases to a staging server. When the server update is complete a series of automated tests are then run, this is the current layout. Now the completion speed for all tasks is not bad but as always the question is can we make it faster? So because these are smoke tests they do not change very often which makes me think instead of the Restore and Build steps can we not simply have a ready built solution installed on Azure so then all we have to do is run the final VsTest step? We are using VS and Playwright for the test project I have never done it that way before so my questions are. Can it be done? and how please? Thanks in advance for any help here. Read More