---
title: "Richard C (@ailstudio) | Hashnode"
description: "Richard C · AIL Studio. Read the latest articles by Richard C on Hashnode."
url: "https://hashnode.com/@ailstudio"
---

@ailstudio

# Richard C

@ailstudio · Joined October 2026

Richard C · AIL Studio

[Website](https://ailstudio.netlify.app/?utm_source=hashnode&utm_medium=profile&utm_campaign=site)

### [How to group Data Loader error rows after a Salesforce import](https://ailstudio.hashnode.dev/how-to-group-data-loader-error-rows-after-a-salesforce-import?utm_source=hashnode&utm_medium=feed)

Group a Salesforce Data Loader error CSV by the ERROR column so you fix each failure type once, then reload only the corrected rows. EXAMPLE DATA.

5 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/how-to-group-data-loader-error-rows-after-a-salesforce-import?utm_source=hashnode&utm_medium=feed)

[Nov 10](https://hashnode.com/posts/how-to-group-data-loader-error-rows-after-a-salesforce-import/6af272ea45a9f952c065f64b)

### [Check a Salesforce Contact export after a load: orphans, duplicate External IDs, and picklist mismatches](https://ailstudio.hashnode.dev/check-a-salesforce-contact-export-after-a-load-orphans-duplicate-external-ids-and-picklist-mismatches?utm_source=hashnode&utm_medium=feed)

Check Salesforce Contact and Account exports after a load for orphans, duplicate External IDs, and bad picklist values, using a spreadsheet and SOQL.

7 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/check-a-salesforce-contact-export-after-a-load-orphans-duplicate-external-ids-and-picklist-mismatches?utm_source=hashnode&utm_medium=feed)

[Nov 10](https://hashnode.com/posts/check-a-salesforce-contact-export-after-a-load-orphans-duplicate-external-ids-and-picklist-mismatches/6af2725e4e969c99b1167d22)

### [Did that cancellation actually work? A cancellation check log in Google Sheets](https://ailstudio.hashnode.dev/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets?utm_source=hashnode&utm_medium=feed)

After cancelling a subscription, log its expected next charge date and check your statement. This spreadsheet does not cancel services or send alerts.

7 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets?utm_source=hashnode&utm_medium=feed)

[Nov 9](https://hashnode.com/posts/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets/6af239c72c58937f358afefb)

### [How to find orphan Contacts after a Salesforce migration (AccountId is blank)](https://ailstudio.hashnode.dev/how-to-find-orphan-contacts-after-a-salesforce-migration-accountid-is-blank?utm_source=hashnode&utm_medium=feed)

After a Salesforce migration, find Contacts with a blank AccountId using SOQL, export them, and decide how to attach or leave them before go-live.

6 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/how-to-find-orphan-contacts-after-a-salesforce-migration-accountid-is-blank?utm_source=hashnode&utm_medium=feed)

[Nov 9](https://hashnode.com/posts/how-to-find-orphan-contacts-after-a-salesforce-migration-accountid-is-blank/6af204238828320faee2f218)

### [How to find duplicate records after a Salesforce data migration (before users do)](https://ailstudio.hashnode.dev/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do?utm_source=hashnode&utm_medium=feed)

By Richard C, AIL Studio The load finished, the record counts are close enough, and sign-off is tomorrow. Then a sales rep finds "Northwind Traders" twice, with Contacts split between the two. Here's

5 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do?utm_source=hashnode&utm_medium=feed)

[Nov 6](https://hashnode.com/posts/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do/6aede1b9d24a82b8dae79555)
