A Collect template can be built in a several ways. An existing template can be merged with other template(s) or a new template can be added to the Template Designer page. To create a new template, select the New Form Template button on the top right corner of the Template Designer page.
Several options are available to build a template:
•New Form Template – Create entirely new template design.
•Upload Form Template – Upload a previously saved Collect template.
•Generate Template – Generates a new Collect template by uploading a Microsoft Excel file containing the structure of the forms, fields, mappings, and field attributes.
•Copy Template – Copy a previously designed Collect template.
Choose the New Form Template option on the Form Templates window to open the Form Template Layout window.
The Upload Form Template option allows for selection of a previously designed Collect template to create a new Collect template. Choose the Upload Form Template option on the Form Templates window.
Browse to the desired Collect template file and click the Upload button.
When uploading a Collect template with an already assigned format, a case insensitive check is performed to ensure that the format is in the database (e.g., collect_inspection = COLLECT_INSPECTION = Collect_Inspection). If the format is not present in the database, a dialog will be displayed to allow the user to either remove the invalid format or select from formats available in the database.
Note: Templates are not backwards compatible (i.e., users cannot upload a template created in a Collect Enterprise build newer than the Collect Enterprise build being used).
EarthSoft has provided a generic Microsoft Excel template file that can be downloaded and used to create a new Collect Template. The Generate Template option allows the generation of Collect templates by denoting the structure of the forms, fields, mappings, and field attributes within a Microsoft Excel file. Once the Excel file is detailed with the necessary form(s) and field(s) information, the file can be uploaded through the Generate Template dialog to create a Collect template.
Click the Generate Template tile to open the Generate Template dialog to select an already configured Excel file or to download a generic Excel template.
Click the Download Generic button to download the generic Excel template that contains worksheets for Forms, Fields, Mappings, and Selectors. Name the file as desired and click OK. The Generic Template file can also be downloaded by clicking the following link GenericTemplate.xlsx. See the Generic Excel Template article for details about populating this file.
Click the Choose File button on the Generate Template dialog to select an Excel file containing already populated Collect template information. In the Open File window, browse to the desired Excel template file. Click the Generate button to create a new Collect template. Upon successfully uploading the Excel file, a dialog will display noting the number of forms created and have options to download a log file and/or template information, if desired.
Click OK to open the Form Template Layout window.
In the example above, three forms (two parent forms and one sub-form) were created in the Collect template.
The default template name is "GeneratedTemplate". Rename the template, adjust the version number, add an appropriate description, and select the appropriate EQuIS format to match data mappings, if the Mappings Worksheet was populated in the Excel file.
An already implemented Collect template can be used by copying it to a new version. Choose the Copy Template option on the Form Templates window.
Existing templates will be displayed. If desired, select the Filter Templates drop-down to limit the display of templates based on template status.
Choose an existing template from the Form Templates window. In this example, an existing Water Sample template was selected.
Click the Copy button to copy the existing template.
Copyright © 2023 EarthSoft, Inc. • Modified: 07 Dec 2023