Getting Started #
The Code Format Generator revolutionizes the code format process, eliminating the inefficiencies of the old method. Previously, code formats were managed in an Excel file, which was prone to formula errors and required manual entry into Vista—a process where even experienced consultants could make mistakes.
In a typical implementation, the code format is always handled by the consultant, and clients do not apply their own code formats. This documentation exists for rare circumstances where direct application by the client may be necessary.
With the new method, you can select the various parts, and the Final Format is automatically built for you. This eliminates manual data entry, significantly reducing the risk of errors.
Key benefits of the new approach:
- All formats are displayed on a single screen, removing the need to cycle through multiple Excel worksheets.
- A CSV file is generated with the approved formats, which can be applied using TAD or SQL Server Management Studio (SSMS).
By automating and streamlining the code format process, the Code Format Generator ensures accuracy and efficiency—saving time while preventing costly mistakes.
Apply using TAD #
If you have the generated CSV file with your code formats, follow the instructions in the Implementation – Apply Code Format template to apply them seamlessly. This ensures accurate and efficient application of your formats without manual entry errors.
Apply using SQL Server Management Studio #
The generated CSV file also includes SQL UPDATE statements that can be executed in SQL Server Management Studio (SSMS).
To apply the updates:
- Open the CSV file in Excel to view the generated SQL statements.
- Copy and paste the UPDATE statements into SSMS.
- Execute the statements to apply the code formats.
Each statement is structured to update only the appropriate data type, ensuring accuracy and preventing format mismatches.
