Hi HelpMasters,
As you know, HelpMaster v10 has a new one-line summary text field on the job screen. See http://www.helpmasterpro....-HelpMaster-v10.aspx if you didn't already know this.
Before this field was available, some users have configured a custom text field to store such data. If you have upgraded to v10, or are planning to and want to transfer this custom data into the new summary field, you can do this easily via the attached SQL script.
Here's how to use it.
- Make a backup of your database first!
- Open the SQL script in SQL Server Management studio
- Replace the 'Exact name of text custom field goes here' with the name of your custom field
- Click on the "Execute" button on the toolbar
All of your job summary fields will now be updated with the contents of the custom text field that you specified.
Note: If a job already had a value for the summary field, this will not be over-written with custom data. The last "Where" clause prevents this.