Duplicating a form type for a new project
Article ID: 109710
Updated On:
Products
Issue/Introduction
We are creating 2 new projects and want to create new form types for the new projects that look the same as the original project, just with new form type names and new data tables.
Environment
CA Harvest SCM all versions and platforms
Resolution
To create a new form type that duplicates an existing form type you will need 2 files - the original form's XML file and SQL file. Here is an example using one of the pre-packaged example form types, the "Comment" form:
1. Make copies of the original form's XML file and SQL file, giving them the new form type name you are creating.
2. Edit the new form's SQL file, making the following changes:
- In the INSERT INTO harformtype statement, in the VALUES clause, change the second item in the list to be the name of the new data table, and change the third item in the list to be the new form type name.
- In the CREATE TABLE statement, change the name to be the new data table name
3. Edit the new form's XML file making the following changes:
- In the "<harvest_form" tag, change the values for "dbtable=" and "id=" to be the name of the new data table
- In the "<harvest_form" tag, change the value for "name=" to be the new form type name
After saving and closing both files, you can execute the SQL script, then use hformsync to import the new form type's xml script.
Additional Information
Information about executing the SQL script to set up your form's table can be found here: Add the Form Table to Your CA Harvest SCM Database
Information about importing the form's XML into the database can be found here: Store the XML Templates From the Form Reference Folder
Everything about creating and maintaining form types can be found here: Create and Modify Form Types
Attachments
Feedback
