Introducing IceTea!
Summary
IceTea is a lightweight utility designed to simplify editing Salesforce datasets stored as .sql files within CumulusCI repositories by enabling easy import/export through Excel. It effectively addresses the challenge admins face when manually editing complex dataset files by providing a convenient tabular view to modify records without breaking data relationships. By using IceTea along with CumulusCI, Salesforce professionals can confidently manage and manipulate sandbox data, speeding up testing and development processes. The tool emphasizes ease of data corrections such as adding missing fields or sanitizing data in a user-friendly way.
Takeaways
- Use IceTea to open CumulusCI .sql dataset files directly in Excel for easier editing.
- Modify dataset records in Excel without affecting database relationships by avoiding header edits.
- Leverage CumulusCI datasets to automate sandbox data loading with preserved record relationships.
- Run 'icetea in' to import datasets and 'icetea out' to export and update .sql files seamlessly.
- Install IceTea locally; it is not a Salesforce app but a utility for local dataset management.
Today I'm writing to introduce a cool and useful tool that my son, Arden , developed. I'm actually rather late in writing about this—Arden made this for me over a year ago. (In case the IP Police are listening, IceTea was developed long before Arden even applied for his current job. So don't click on his LinkedIn and assume it has anything to do with where he's working now that he's graduated college.) Despite too much delay, I hereby present: IceTea . What Is IceTea? IceTea is a little utility that does two things: Open a database (stored as a .sql text file in your CumulusCI repo) in Excel. Convert that Excel file back to .sql after you've made changes to the rows. What is so delicious about it? When you store a dataset using CumulusCI it takes the form of a SQL database in a text file. Though it's theoretically possible to hand-edit if you need to change a value in that table, it's rather inconvenient. And if you want to add values for blank fields (represented by ".