Salesforce Deploy inbound change set – Deploy button grayed out

Even after the change set appears and you click Deploy, you’ll choose a test option and the Deploy button can’t be clicked.2019-08-22 13_41_06-Change Set Test Options ~ Salesforce - Enterprise Edition

If you click on the Change Set Name, though, you’ll get the following message:

Change Set Unavailable
This change set isn’t available right now. Change sets are uploaded asynchronously, so a change set that was recently uploaded can take up to 30 minutes or longer before it’s available for deployment. Please wait and try deploying your change set again later.

In short, you have to wait for a few more minutes for the change set components to be pushed to the new organization. Then you’ll be able to deploy.


Take a screenshot of an entire web page without scrolling

In Firefox:

  • Open the Developer Tools by pressing F12 on the keyboard.
  • Press F1 to open the Dev Tools settings.
  • Under Available Toolbox Buttons, check the “Take a screenshot of the entire page” button
  • Now, on the right side of the Dev Tools menu bar, there will be a camera button. Browse to the webpage you want to capture and click the button. The screenshot will be stored in your Downloads directory. (C:/Users/<your username>/Downloads)

I’m sure Chrome has a similar option.

2019-08-19 10_04_36-Edit Post ‹ Chris Tech Blog —

Office 365 email statistics by user

Run a message trace from History only goes back 90 days. Enter one or more to/from email addresses and choose inbound or outbound messages. Submit the request and download the CSV when it’s ready.

Open the CSV in Excel and add a Date column with this formula:


This takes the date portion origin_timestamp field and converts it into an Excel-compatible date format. Then format the new Date column with the Short Date format.

Now you can create a PivotTable. Put message_id in the Values field and sender_address and Date in the Rows field. You’ll get a breakdown of the how many emails that particular email address sent out (for example) for each month and day (this can be changed in the PivotTable settings).

Reduce Excel workbook file size (when it’s large for no particular reason)

A large number of empty cells may be formatted, causing them to increase the file size even when those cells are empty.

The easy way is to run the Clean Excess Cell Formatting command. Enable the Inquire add-in from the COM Add-ins section, then on the Inquire tab, click Clean Excess Cell Formatting.

Another way to check this is to open the XLSX file in 7-Zip or any archive program. Go into the xl/worksheets directory and look for any sheets with a vastly higher size than the others:


In this case, sheet 54 is the offender. Open the xl/workbook.xml and find the line with the matching ID:

<sheet name=”July2019″ sheetId=”182″ r:id=”rId54“/>

Delete the sheet from within Excel, or if you’re feeling brave, delete sheet54.XML from 7-Zip. When the file is next opened, Excel will inform you that the file is corrupted and it will recover the contents. Make a backup copy before doing this, though.

Using the format cleaner, the file size went from ~120MB to ~25MB. Deleting the XML brought it down to ~10MB, and opening/saving was unsurprisingly much faster.

Black screen after cloning Windows 10 fix

I had an Acer desktop with three partitions – a factory recovery partition, Windows “System Reserved”, and the main Windows OS. I didn’t want to clone the recovery partition because it took up ~20GB of space.

Using Clonezilla, I cloned only the two Windows partitions. The result: a black screen when attempting to boot from the newly-cloned SSD. No amount of finagling with drive letters, setting the partitions to active, repairing and recreating the BCD/boot sector/MBR, or Windows System Repair did anything.

Instead, I wiped the SSD and started installing a new copy of Windows 10. Once the installer tried to reboot the machine for the first time (when booted from the USB installer), I shut the machine off, booted into Clonezilla, and cloned/copied only the main c: partition from the old hard drive. This left the new System Reserved partition alone. The machine now boots normally. The trick is getting that System Reserved partition, which boots the OS, set up properly, and by letting the Windows installer do that, it’s guaranteed to work.

Salesforce REST API / Postman / leads and campaigns

Creating a Salesforce app and configuring Postman to connect with OAuth:

Settings to get an access token for a Developer Edition org:

2019-07-24 16_32_44-Postman

Request URL/Endpoint for dealing with leads (for example):

  • The GET action is for retrieves information
    • for the above URL, this will show some basic properties of the lead object, URLs to get more information, and recently accessed lead IDs.
      • To find the lead fields, use the Describe URL: /services/data/v36.0/sobjects/Lead/describe
  • POST is for creating new records
  • PATCH is for updating existing records. When sending data in a POST or PATCH, the data should be formatted in JSON.

After creating a lead with this JSON:

“LastName”: “TestLead”,
“Company”: “TestCompany”

The response is this:


The ID can be used to view the record in the browser – https://<My Org ID> – or to get the lead’s information:


“attributes”: {
“type”: “Lead”,
“url”: “/services/data/v36.0/sobjects/Lead/00Q3i000001ov0HEAQ”
“Id”: “00Q3i000001ov0HEAQ”,
“IsDeleted”: false,
“MasterRecordId”: null,
“LastName”: “TestLead”,
“FirstName”: “null”,
“Salutation”: null,
“Name”: “TestLead”,
“Title”: “null”,
“Company”: “TestCompany”,



To update the record, send a PATCH to https://<my org ID>

“FirstName”: “TestLead”,
“Title”: “CEO”

When it’s successful, the response will be blank and the status code is 204 No Content.

To add the lead to a campaign, POST the following to

“LeadId”: “00Q3i000001ov0HEAQ”,
“CampaignId”: “7013i0000002MDIAA2”


“id”: “00v3i00000174ZKAAY”,
“success”: true,
“errors”: []

That ID is for a CampaignMember, not the campaign or (nor?) the lead.

Remove a computer from Active Directory with PowerShell – one line

Be sure to use a back slash instead of a forward slash. WordPress doesn’t like back slashes.

Remove-Computer -UnjoinDomainCredential yourdomain/username -ComputerName <PC’s host name> -PassThru -Verbose -Restart

If you have PowerShell credential manager, you can run the command like this so you aren’t prompted to enter your password.

Remove-Computer -UnjoinDomainCredential (Get-StoredCredential -UserName -ComputerName pc_name_here -PassThru -Verbose -Restart

Outlook / OneDrive for Business attachments won’t attach/upload

When trying to attach files stored in OneDrive for Business, or attaching files stored on the local PC and then uploading them to OfB, the files will remain as or be converted to regular attachments. In other words, OneDrive-hosted files won’t attach to the email.

This is because the email is in Plain Text format. The OneDrive links are HTML, so when Outlook tries to add them to the email, that process fails (but Outlook doesn’t inform you of this). To fix this, go to the Format Text tab and change the Format from Plain Text to HTML. (You’ll have to click Pop Out when replying to the message if you haven’t opened it in a new window. The Format Text tab won’t appear when replying within the main Outlook window)

2019-06-24 10_05_07-RE_ Custom Report - Daily Email Reports for Marketing - Message (Plain Text).png

Blog at

Up ↑