When viewing .csv files with Notepad, everything looks great.

However, when I open these files, every other row is blank including the header row.

Is the problem on my end with various format selections, or the party sending me these files with, perhaps, and extra line feed tacked onto the end of each record?

Getting rid of every other blank line is manually time consuming and should not be there in the first place.

Thank you for any suggestions.

​When viewing .csv files with Notepad, everything looks great.However, when I open these files, every other row is blank including the header row.Is the problem on my end with various format selections, or the party sending me these files with, perhaps, and extra line feed tacked onto the end of each record?Getting rid of every other blank line is manually time consuming and should not be there in the first place.Thank you for any suggestions.  Read More

​

I have 3 workbooks.  One called PO number system and one for each project manager.

Workbook 1 – PO Number system

Workbook 2 – Marc

Workbook 3 – Kyle

On the PO Number System, Column A is dropdown for project manager name.

Column B is PO number (generated from formula tied to Customer List in same workbook)

I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column.  If it doesn’t say Marc’s name, then nothing happens to his spreadsheet.  If A2 says Kyle, then everything should fill in on Kyle’s workbook.

Spreadsheets attached for reference.

​I have 3 workbooks.  One called PO number system and one for each project manager.Workbook 1 – PO Number systemWorkbook 2 – MarcWorkbook 3 – KyleOn the PO Number System, Column A is dropdown for project manager name.Column B is PO number (generated from formula tied to Customer List in same workbook)I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column.  If it doesn’t say Marc’s name, then nothing happens to his spreadsheet.  If A2 says Kyle, then everything should fill in on Kyle’s workbook.Spreadsheets attached for reference.  Read More

​

The service name property of an appointment was previously editable per docs and testing.
https://learn.microsoft.com/en-us/graph/api/bookingappointment-update?view=graph-rest-1.0

Now when an update occurs via API, the service name completely resets to the default service name of the appointments service ID. You can still pass the service name when creating and appointment via the API, but any updates will break it. Anyone else experiencing this issue?

​The service name property of an appointment was previously editable per docs and testing.https://learn.microsoft.com/en-us/graph/api/bookingappointment-update?view=graph-rest-1.0Now when an update occurs via API, the service name completely resets to the default service name of the appointments service ID. You can still pass the service name when creating and appointment via the API, but any updates will break it. Anyone else experiencing this issue?  Read More

​

Hello,

I’ve been trying to get past the “employment verification” step for almost a month now. In the “fix now” menu, I was asked to provide the domain registration receipt, which I’ve submitted multiple times. I opened a ticket and was advised to change my email address to something non-generic, which I did. However, I haven’t received any further updates. I’ve followed up multiple times, only to receive the same automated response: “We’re looking into your issue and will provide an update.” Today, I received an email stating that after several unsuccessful attempts to verify my information, the verification process has been terminated. This is very frustrating, as all my information is legit, and there seems to be no reason my profile shouldn’t be approved.

Please assist, as opening tickets doesn’t seem to move the process forward at all.

Thank you!

​Hello,I’ve been trying to get past the “employment verification” step for almost a month now. In the “fix now” menu, I was asked to provide the domain registration receipt, which I’ve submitted multiple times. I opened a ticket and was advised to change my email address to something non-generic, which I did. However, I haven’t received any further updates. I’ve followed up multiple times, only to receive the same automated response: “We’re looking into your issue and will provide an update.” Today, I received an email stating that after several unsuccessful attempts to verify my information, the verification process has been terminated. This is very frustrating, as all my information is legit, and there seems to be no reason my profile shouldn’t be approved.Please assist, as opening tickets doesn’t seem to move the process forward at all.Thank you!  Read More

​

Developing your virtual machine offer is a webinar offered regularly through the Mastering the Marketplace series. This session reviews the required technical configurations to make Virtual Machine apps and how to publish virtual machines offers to the Azure marketplace.

Looking for additional guidance with Virtual Machines? An Azure technical expert will take you through:

A brief overview of what a virtual Machine offer type is.
How to publish a Virtual machine offer and integrate the solution from the Azure Portal tool to Partner center.
How to setup Tenants.
How to create different plans to best suit your customers’ needs
How to use Cloud-init within the Azure Portal.

Attendees can also participate in a short Q&A following the session.

Below is a list of recently asked questions from this session.

Q1. Once I published the image to the gallery, does it make sense to keep the generalized VM around (if yes, then for what purpose?) or may I delete it?

A: You can delete the image after the offer is published live on the marketplace. At full publish, MS maintains a registry of your images, so you no longer have to hold on to it.

Q2. Does the standard Microsoft Marketplace agreement work both for transactable and non-transactable?

A: Yes it does. It simply is an option for your T&C if you don’t have your own.

Q3. Last time we used the Direct Shared Gallery it was in Preview and sharing was severely limited (only a few tenants and subscriptions). What is the situation now?

A: As of August 2024 it still has these limitations. You can share it across subscriptions on the same tenant but not across tenants. If that doesn’t work, you can use a vhd link to publish the VM offer.

__________________________________________________________

Additional Resources:

Register for the next webinar on Developing your virtual machine offer, August 20 at 9 am PT.
Register for additional Mastering the Marketplace webinars here.

​Developing your virtual machine offer is a webinar offered regularly through the Mastering the Marketplace series. This session reviews the required technical configurations to make Virtual Machine apps and how to publish virtual machines offers to the Azure marketplace.
 
Looking for additional guidance with Virtual Machines? An Azure technical expert will take you through:

A brief overview of what a virtual Machine offer type is.
How to publish a Virtual machine offer and integrate the solution from the Azure Portal tool to Partner center.
How to setup Tenants.
How to create different plans to best suit your customers’ needs
How to use Cloud-init within the Azure Portal.

Attendees can also participate in a short Q&A following the session.
 
Below is a list of recently asked questions from this session.
 
Q1. Once I published the image to the gallery, does it make sense to keep the generalized VM around (if yes, then for what purpose?) or may I delete it?
A: You can delete the image after the offer is published live on the marketplace. At full publish, MS maintains a registry of your images, so you no longer have to hold on to it.
 
Q2. Does the standard Microsoft Marketplace agreement work both for transactable and non-transactable?
A: Yes it does. It simply is an option for your T&C if you don’t have your own.
 
Q3. Last time we used the Direct Shared Gallery it was in Preview and sharing was severely limited (only a few tenants and subscriptions). What is the situation now?
A: As of August 2024 it still has these limitations. You can share it across subscriptions on the same tenant but not across tenants. If that doesn’t work, you can use a vhd link to publish the VM offer.
__________________________________________________________
Additional Resources:

Register for the next webinar on Developing your virtual machine offer, August 20 at 9 am PT.
Register for additional Mastering the Marketplace webinars here.  Read More

​

Hello, 

We’re having an issue as of this morning where Shared Channels do not seem to take when created. When I try to create a Shared Channel in the Admin Center it doesn’t show up in the list of channels, even when I go to manage the Team through the Teams app and look at the channels that way.

If I or a user creates a Shared Channel in Teams through the app it shows only for the person who created it, but it’s grayed out, you cannot interact with it, and does not appear in the list of channels when managing the Team through the app or the Admin Center.

Standard and Private channels are working as expected. I tried on multiple Teams to make sure it wasn’t an issue with a certain Team. I checked all the settings I could think of that could be blocking it even though none of them should have changed since the last time I was able to successfully create a Shared Channel.

Any idea as to what is going on? Anyone else experiencing this? 

Update: They all decided to show up, but now I can’t delete any of the ones we created while trying to get it to work.

​Hello,  We’re having an issue as of this morning where Shared Channels do not seem to take when created. When I try to create a Shared Channel in the Admin Center it doesn’t show up in the list of channels, even when I go to manage the Team through the Teams app and look at the channels that way. If I or a user creates a Shared Channel in Teams through the app it shows only for the person who created it, but it’s grayed out, you cannot interact with it, and does not appear in the list of channels when managing the Team through the app or the Admin Center. Standard and Private channels are working as expected. I tried on multiple Teams to make sure it wasn’t an issue with a certain Team. I checked all the settings I could think of that could be blocking it even though none of them should have changed since the last time I was able to successfully create a Shared Channel. Any idea as to what is going on? Anyone else experiencing this?  Update: They all decided to show up, but now I can’t delete any of the ones we created while trying to get it to work.  Read More

​

hello

             I AMIT KHINDRI START TO EXEAL NOT WORKING FOR EXEAL PLZ CHEAK & COMNEUCATE

​hello              I AMIT KHINDRI START TO EXEAL NOT WORKING FOR EXEAL PLZ CHEAK & COMNEUCATE    Read More

​

I’m wanting to set up conditional formatting so an entire cell row changes color when a certain date is reached. I’ve been able to change a single cell but I’m having trouble doing the row, and it’s been years since I’ve really had to use EX

The cells range A-N, and it starts on row 3, so A3 is the 98 field. I would like the entire row to turn red if the date in K3 (this is the 6/4/2025 field) within 30 days, of 6/4/2025, and to turn yellow if this same field is within 60 days.

Thanks for any help.

98Hipot (0-120 kVAC)High Voltage Inc.112XTDYes116/4/20246/4/2025Test Lab

​I’m wanting to set up conditional formatting so an entire cell row changes color when a certain date is reached. I’ve been able to change a single cell but I’m having trouble doing the row, and it’s been years since I’ve really had to use EXThe cells range A-N, and it starts on row 3, so A3 is the 98 field. I would like the entire row to turn red if the date in K3 (this is the 6/4/2025 field) within 30 days, of 6/4/2025, and to turn yellow if this same field is within 60 days.Thanks for any help. 98Hipot (0-120 kVAC)High Voltage Inc.112XTDYes116/4/20246/4/2025Test Lab   Read More

​