I created a MS Form with a 45 minute timer a while ago and it was working fine.  Since last week I noticed the forms that were closed due to time up were not saving at all. Any suggestions/advice/update? 

​I created a MS Form with a 45 minute timer a while ago and it was working fine.  Since last week I noticed the forms that were closed due to time up were not saving at all. Any suggestions/advice/update?   Read More

​

I have several Excel spreadsheets with over 100,000 lines.  I would like to set the default Search parameter for each to search By Column instead of By Row.  Preferably for all Excel documents, but I can live with this default for my most highly used large documents.  There appears to be a way to do this in older versions of Excel, but the directions provided do not work with my current version of Excel.  I am using Microsoft 365 apps for enterprise.  Any guidance would be appreciated.

​I have several Excel spreadsheets with over 100,000 lines.  I would like to set the default Search parameter for each to search By Column instead of By Row.  Preferably for all Excel documents, but I can live with this default for my most highly used large documents.  There appears to be a way to do this in older versions of Excel, but the directions provided do not work with my current version of Excel.  I am using Microsoft 365 apps for enterprise.  Any guidance would be appreciated.  Read More

​

I have a Signin form (frmSignIn) with two Text Boxes asking for a UserName (txtName) and Password (txtPassword).  The form also has two command buttons Enter (cmdEnter) and Add User (cmdAddUser).

I would like to validate that data has been entered into the text boxes before processing the form.

I have tried the following VBA Code in the BeforeUpdate event for the text Box.

Option Compare Database
Option Explicit

Private Sub txtName_BeforeUpdate(Cancel As Integer)
     If txtName = “” Or IsNull(txtValue) Then
          MsgBox “You are a Dummy”
          Cancel = True
     End If
End Sub

This only works if I enter a value in the txtName Box and then backspace to erase the value.

What am I doing wrong?

​I have a Signin form (frmSignIn) with two Text Boxes asking for a UserName (txtName) and Password (txtPassword).  The form also has two command buttons Enter (cmdEnter) and Add User (cmdAddUser). I would like to validate that data has been entered into the text boxes before processing the form. I have tried the following VBA Code in the BeforeUpdate event for the text Box. Option Compare DatabaseOption ExplicitPrivate Sub txtName_BeforeUpdate(Cancel As Integer)     If txtName = “” Or IsNull(txtValue) Then          MsgBox “You are a Dummy”          Cancel = True     End IfEnd Sub This only works if I enter a value in the txtName Box and then backspace to erase the value. What am I doing wrong?   Read More

​

Hi Folks,

It’s been over 20 years since I’ve really had to dive into the depths of exchange, and sad to say, I have forgotten most of what I knew. Please bear with me as I fumble through this…

Scenario:

I am currently trying to get a hosted accounting software (QB) to connect to on-prem exchange 2016 via webmail. QB will ask for password when using configs below. Change anything and it states it cant connect.

Configs:

QB is configured to use webmail to server, mail. domain name, port 25. I have created a receive connector to listen for mail from the IP of the hosted QB, over port 25.

Authentication on connector is TLS and Basic Auth. Permission is, exchange users. Protocol logging is verbose. OWA works just fine.

I cant tell if QB truly connects or not. How can I troubleshoot this scenario, and verify QB actually connects to my receiver? I have talked w/ QB T2 tech support and they could not resolve. Sent me link to developer site and said good luck… Not a developer, so not sure what to do with that.

Any help would be greatly appreciated!

​Hi Folks,It’s been over 20 years since I’ve really had to dive into the depths of exchange, and sad to say, I have forgotten most of what I knew. Please bear with me as I fumble through this… Scenario:I am currently trying to get a hosted accounting software (QB) to connect to on-prem exchange 2016 via webmail. QB will ask for password when using configs below. Change anything and it states it cant connect. Configs:QB is configured to use webmail to server, mail. domain name, port 25. I have created a receive connector to listen for mail from the IP of the hosted QB, over port 25.Authentication on connector is TLS and Basic Auth. Permission is, exchange users. Protocol logging is verbose. OWA works just fine. I cant tell if QB truly connects or not. How can I troubleshoot this scenario, and verify QB actually connects to my receiver? I have talked w/ QB T2 tech support and they could not resolve. Sent me link to developer site and said good luck… Not a developer, so not sure what to do with that. Any help would be greatly appreciated!  Read More

​

HttpClient stands out for its flexibility. It can send HTTP requests asynchronously, manage headers, handle authentication, and work with cookies, all while giving you detailed control over request and response formats. Its reusable nature makes it an essential tool for making network requests in modern apps, whether you’re connecting to web APIs, microservices, or handling file uploads and downloads.

What you can achieve with HttpClient:

Perform all types of HTTP operations (GET, POST, PUT, DELETE, etc.).
Send and receive complex data such as JSON or multipart form data.
Receiving responses from web services or APIs.
Handling asynchronous operations for efficient request management.

In this article, we will walk through creating a simple console application in C# that allows users to input basic student details, Roll Number, Name, Age and upload a certificate. The certificate file can be in any format (pdf, doc etc.). We will use HttpClient to send the data to a web server.

Step 1: Create a new Console Application
Open your terminal or command prompt and run the following command to create a new console application:

dotnet new console -n StudentUploadApp

Navigate into the project directory:

cd StudentUploadApp

Step 2: Add Required Packages
You will need the System.Net.Http package, which is typically included by default in .NET SDK. If you need to install it, use:

dotnet add package System.Net.Http

Step 3: Write the Application Code
Open the Program.cs file and replace the existing code with the following:

using System;
using System.IO;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;

class Program
{
private static readonly HttpClient client = new HttpClient();

static async Task Main(string[] args)
{
Console.Write(“Enter Student Roll Number: “);
string rollNumber = Console.ReadLine();

Console.Write(“Enter Student Name: “);
string studentName = Console.ReadLine();

Console.Write(“Enter Student Age: “);
string studentAge = Console.ReadLine();

Console.Write(“Enter path to Birth Certificate PDF: “);
string pdfPath = Console.ReadLine();

if (File.Exists(pdfPath))
{
await UploadStudentData(rollNumber, studentName, studentAge, pdfPath);
}
else
{
Console.WriteLine(“File not found. Please check the path and try again.”);
}
}

private static async Task UploadStudentData(string rollNumber, string name, string age, string pdfPath)
{
using (var form = new MultipartFormDataContent())
{
form.Add(new StringContent(rollNumber), “rollNumber”);
form.Add(new StringContent(name), “name”);
form.Add(new StringContent(age), “age”);

var pdfContent = new ByteArrayContent(await File.ReadAllBytesAsync(pdfPath));
pdfContent.Headers.ContentType = MediaTypeHeaderValue.Parse(“application/pdf”);
form.Add(pdfContent, “birthCertificate”, Path.GetFileName(pdfPath));

// Replace with your actual API endpoint
var response = await client.PostAsync(“https://yourapi.com/upload”, form);

if (response.IsSuccessStatusCode)
{
Console.WriteLine(“Student data uploaded successfully!”);
}
else
{
Console.WriteLine($”Failed to upload data: {response.StatusCode}”);
}
}
}
}

Please note that you need to replace this URL “https://yourapi.com/upload” with your actual API endpoint where the data should be sent. Ensure the server can handle multipart form data.

Step 4: Modify your API Controller
Create a new controller and replace its content with the following code:

using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using System.IO;
using System.Threading.Tasks;

namespace StudentUploadApi.Controllers
{
[ApiController]
[Route(“api/[controller]”)]
public class StudentController : ControllerBase
{
[HttpPost(“upload”)]
public async Task<IActionResult> UploadStudentData(
[FromForm] string rollNumber,
[FromForm] string name,
[FromForm] string age,
[FromForm] IFormFile birthCertificate)
{
if (birthCertificate == null || birthCertificate.Length == 0)
{
return BadRequest(“No file uploaded.”);
}

var filePath = Path.Combine(“UploadedFiles”, birthCertificate.FileName);

// Ensure the directory exists
Directory.CreateDirectory(“UploadedFiles”);

// Save the uploaded file to the specified path
using (var stream = new FileStream(filePath, FileMode.Create))
{
await birthCertificate.CopyToAsync(stream);
}

// Here, you can add logic to save the student data to a database or perform other operations

return Ok(new { RollNumber = rollNumber, Name = name, Age = age, FilePath = filePath });
}
}
}

Step 5: Now, your API is ready to accept POST requests. Run the API.

You can run your API with the following command:

dotnet run

Step 6: Finally, run your console application. 

You will be prompted to enter the student’s Roll Number, Name, Age, and the path to their certificate file. Make sure the file exists at the specified path.

Now, when you run your console application and upload a student’s details along with the certificate file, the API will receive the data and save the file to UploadedFiles directory in your API project. You can enhance the API by adding validations, error handling, and database integration as needed.

Finally, you should see a confirmation message in the console window as below.

Conclusion:

In this article, we explored the power of HttpClient by building a simple console application that uploads student details along with a file to a web API. HttpClient is a powerful class in the .NET framework enabling developers to easily perform HTTP operations such as sending and receiving data, managing headers, and handling multipart form data. Whether you’re building client-side apps or interacting with external APIs, HttpClient simplifies communication. With the right setup, you can handle complex file uploads and data transmissions effortlessly in your applications.

​Microsoft Tech Community – Latest Blogs –Read More 

Which learning paths and certifications will be recommended for someone trying to learn cloud security for the SOC, IR ?

By the way hi my name is Enyel. 

​Which learning paths and certifications will be recommended for someone trying to learn cloud security for the SOC, IR ?By the way hi my name is Enyel.    Read More

​

Hi,

I’ve created a timetable to track student lessons at my school (what subject and which staff – selected from lists) I have all students tracked on the same table, and a sheet for each day of the week (eg Mon – Fri)

what I’d really like to add now is a sheet where I can select a students name from a list, and generate a full week timetable just for that student. I’ve tried to work out how to do that, but I’m struggling!

if possible I’d then like to do the same for staff members to show which lessons and students they’re supporting – but think that may be more difficult!

Happy to attach where I’m up to if it helps!

​Hi,I’ve created a timetable to track student lessons at my school (what subject and which staff – selected from lists) I have all students tracked on the same table, and a sheet for each day of the week (eg Mon – Fri)what I’d really like to add now is a sheet where I can select a students name from a list, and generate a full week timetable just for that student. I’ve tried to work out how to do that, but I’m struggling!if possible I’d then like to do the same for staff members to show which lessons and students they’re supporting – but think that may be more difficult!Happy to attach where I’m up to if it helps!  Read More

​

Have you ever wondered what it takes to have an enterprise level HPC environment in the Cloud? What components should be in place and what steps should be taken to move from an on-premises environment to a Cloud environment? And what are the best practices in this process? Everything starts with a Proof-of-Concept (PoC), in which an organization assesses how the key applications will perform in the Cloud, considering not only performance but also the costs involved. Once a decision is made, it is important to understand what it takes to have an enterprise level HPC Cloud environment.

Based on our experience with various clients, partners, and product groups, we have put together a comprehensive documentation on HPC lift and shift Cloud migration and this blog post gives an overview on what we cover in the document. Feedback is always welcome, as we will keep improving the documentation over time.

TL;DR

–   We just made available a detailed documentation on HPC lift and shift cloud migration, containing components, steps, examples, and best practices. We also provide references for products, code repositories, and blog posts.

–   Documentation can be accessed here: https://learn.microsoft.com/en-us/azure/high-performance-computing/lift-and-shift-overview

DOCUMENTATION OVERVIEW

Here we provide an overview of the documentation: LINK

On-premises. We start the document by describing what a typical on-premises HPC environment looks like, which includes compute nodes, job schedulers like SLURM, PBS, or LSF, identity management, storage options, and monitoring tools, all hosted within a private network.

Personas. After discussing the on-premises environment, we talk about the personas. From our experience, we observe a lot of discussion on what changes and what does not change for all people involved when moving from on-premises to the Cloud. We discuss their responsibilities and new tasks in an HPC Cloud setup, considering four personas:

– End-user (engineer / scientist / researcher)

– HPC administrator

– Cloud administrator

– Business manager / owner

HPC Cloud target architecture. The next discussion is an overview of the target HPC Cloud architecture, which highlights that there is not much change compared to an on-premises environment in terms of the conceptual components involved. One of the key differentiators is that resources are allocated on demand, allowing users to access more resources as needed.

Migration guide. After a brief discussion on exploring the Cloud environment through a Proof-of-Concept (PoC), we dive deep into the migration guide itself.  We have broken the guide into five steps.

Basic infrastructure. The focus here is on setting up resource groups, networking, and basic storage, which serve as the backbone of a successful HPC lift-and-shift deployment;

Base services. This section covers the core components related to the job scheduler, including the resource orchestrator for provisioning and setting up resources, identity management for user authentication, monitoring (including node health checks), and accounting to better understand the status and usage of resources. Each component plays a crucial role in ensuring the performance, scalability, and security of the HPC environment.

Storage. This section highlights the critical considerations for managing storage in an HPC cloud environment, focusing on the variety of cloud storage options and the processes for migrating data. Also, it offers practical guidance for setting up storage and managing data migration, with an emphasis on scalability and automation as the HPC environment evolves.

Compute nodes. This section provides guidance on selecting and managing compute resources efficiently for HPC workloads in the cloud, including some recommendations and pointers on VM images.

End user entry point. This section explores the options for user interaction, emphasizing the importance of addressing potential latency issues that may arise when moving to the cloud. It also provides guidance on tools, services, and best practices optimizing the user entry point for HPC lift-and-shift deployments. A quick start setup is included to help establish this component efficiently, with the goal of automating it as the cloud infrastructure matures.

WHAT IS NEXT?

We will continue to improve and expand the documentation on this topic as new services, products, and learnings become available. The documentation is not targeted to cover all the possible deployments in the Cloud, but provide guidance based on patterns we observe in how customers use the Cloud to run their HPC workloads. If there is any subject on which more details are required, please send us a note!

LINK TO FULL DOCUMENTATION

https://learn.microsoft.com/en-us/azure/high-performance-computing/lift-and-shift-overview

#AzureHPCAI

​Microsoft Tech Community – Latest Blogs –Read More