thate

• 🎯 Purpose
• 🚀 Features
• 📦 Installation
• 🛠️ Usage
  • Convert STF to Excel
    • Options
  • Convert Excel to STF
• 🛠 Configuration File: .thate.json
  • 📄 Example .thate.json
• 📝 License
• 📝 ChangeLog
  • 1.1.0
  • 1.0.3
  • 1.0.2
  • 1.0.0

thate is a command-line application built with Node.js to simplify the handling of translation files in Salesforce projects.

🎯 Purpose

I created thate — short for "translation hate" — because I've always hated how tedious and error-prone Salesforce translation file management can be. This tool was born out of frustration with the .stf format and the manual work it often requires, especially when clients only work with .xlsx files.

The tool allows you to convert .stf (Salesforce Translation Files) into .xlsx files and vice versa. It currently supports bilingual formats — files with one source and one target language.

This helps reduce manual effort, as clients are usually provided with .xlsx files for translation, while .stf files are used within Salesforce for importing and exporting translations.

🚀 Features

• ✅ Convert .stf files to .xlsx
• ✅ Convert .xlsx files back to .stf
• ✅ Support for bilingual translation files
• ✅ Streamlines the localization process in Salesforce projects

📦 Installation

Install globally using npm:

npm install -g thate

Or locally within your project:

npm install thate

🛠️ Usage

thate will convert all files in source folders

Convert STF to Excel

thate excel

Options

• --omit: omit translated values from the Excel file output.

Convert Excel to STF

thate stf

🛠 Configuration File: .thate.json

To customize how thate works within your project, you can create a configuration file named .thate.json in the root directory of your project.

This file allows you to specify default paths for input/output and define rules for filtering out unwanted translations during processing.

📄 Example .thate.json

{
  "outputStf": "utils/translations/output-stf",
  "outputStfRevised": "utils/translations/source-stf-revised",
  "outputXlsx": "utils/translations/output-xlsx",
  "sourceStf": "utils/translations/source-stf",
  "sourceXlsxTranslated": "utils/translations/translated-xlsx",
  "stuffToRemove": [
    ".Google",
    "ActionPlanTemplateItem.",
    "CustomApp.Sales",
    "PicklistValue.Standard.opportunityStage"
  ]
}

📝 License

MIT License

📝 ChangeLog

1.1.0

• Added --omit option to excel command: allows you to omit translated values from the Excel file output

1.0.3

• typo

1.0.2

• Improved error handling for missing folders

1.0.0

• thate is born!