Code Format Generator

For this process you will adjust the various Part # combo boxes.

As you make changes the Final Format boxes will be updated and the Examples will be populated.

When you are finished defining your format you can use the Export to CSV button.

Final Format

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

GL Account

Contract/Job (Project)

Phase Code (Cost Code)

Equipment Number

Equipment Category

Equipment Cost Code

Material Categories

Phone Number

Maximum Field Lengths

GL Account, Phase Code (Cost Code) and Phone Number have a limit of 20 characters.
Everything else has a limit of 10 characters.

Examples

This section generates 20 sample records depending on the format selected above.

Export to CSV

You can export the format that you have entered into a clean CSV file. This file can be used by TAD to import and apply into your Vista database. The entire process requires zero data entry which eliminates potential errors.

The file also contains SQL UPDATE statements for each datatype so you can run it directly in SQL Server Management Studio.

Note: Once formats are applied, any changes could require converting data, which is a billable service.

Disclaimer

By exporting the CSV file:

You acknowledge and accept full responsibility for the accuracy, completeness, and validity of the data contained within.
You assume responsibility for applying the format correctly into the SQL Server database.

Neither the software provider nor its developers shall be held liable for any issues arising from the data’s accuracy, formatting, or its application within the database.