The Facility File Maintenance Clone function allows you to clone an existing Facility that may have similar features to a new Facility you would like to create. This process can save a tremendous amount of time, especially when building a new database.
By default the Facility File Maintenance Clone program will create exact copies of the selected record. Additional Options allow you to specify how much information is copied in the event you do not want an exact copy. Additional Options also allow you to create new Facility Classes and Locations from the original record, if desired.
Click Here to view Standard File Maintenance Clone Setting field definitions for the top half of the screen. Field definitions for Additional Options specific to this module/program are listed below.
FRFacilityClone_Tab1
List of NEW Facility Classes (FRFacilityClone_FacilityClassCloneList)
To create new Classes from this Facility, enter a Class Code (For Example: GYM) or a comma-delimited list of Location Codes (GYM, PARK, CAMP) in this field. The system will create as many new Classes as you list in this field, each with the same cloned Facility/Facilities specified in the New Record Code List and other selection options above.
DeleteSequence Type? (FRFacilityClone_FacilityClassSequenceType)
Expand the Drop-down list to select your Sequence Type. A selection in this field is necessary only if you opt to create cloned records using a wildcard asterisk. Making a selection here is NOT necessary if using a single New Record Code only or if using a comma-delimited list in the New Record Code List.
-
Numeric - The wildcard values will be numbers. The number of numbers will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is **-Test." Your Sequence Type is 'Numeric.' Your Min Sequence Number is "1" and your Max Sequence Number is "50." The clone process will create 50 records from 01-Test to 50-Test. -
Alpha - The wildcard values will be letters. The number of letters will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is "10150-*." Your Sequence Type is 'Alpha' Your Min Sequence Number is "0" and your Max Sequence Number is "25." The clone process will create 26 records from 10150-A to 10150-Z.
Min Sequence Number (FRFacilityClone_FacilityClassSequenceMin)
Enter the starting value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will auto-fill leading zeros as appropriate based on the number of wildcard asterisks being used in New Record Code List.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. The first code created will be Test-001. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B" and so forth.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is "0." The first code created will be Test-AAA the second code will be Test-AAB etc....
Max Sequence Number (FRFacilityClone_FacilityClassSequenceMax)
Enter the ending value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will create as many new records as numbers in your range.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. Your Maximum Sequence Number is 999. The system will create 1,000 codes from Test-001 to Test-999. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B" and so forth through "z." In the event you have multiple asterisks the system will continue using alpha characters in the sequence of the alphabet (AAA - AAZ ABZ - AZZ BZZ-ZZZ). The system will NOT do every possible combination of a-z in the event of multiple asterisks.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 0 . Your Maximum Sequence Number is 75. The first code created will be Test-AAA the second code will be Test-AAB etc… the 26th code will be ABZ the 27th will be ACZ etc… through to ZZZ.
List of NEW Facility Locations (FRFacilityClone_FacilityLocationCloneList)
To create new Locations from this Facility, enter a Location Code (For Example: POTPK) or a comma-delimited list of Location Codes (POTPK, WALPK, PEAPK
DeleteSequence Type? (FRFacilityClone_FacilityLocationSequenceType)
Expand the Drop-down list to select your Sequence Type. A selection in this field is necessary only if you opt to create cloned records using a wildcard asterisk. Making a selection here is NOT necessary if using a single New Record Code only or if using a comma-delimited list in the New Record Code List.
-
Numeric - The wildcard values will be numbers. The number of numbers will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is **-Test." Your Sequence Type is 'Numeric.' Your Min Sequence Number is "1" and your Max Sequence Number is "50." The clone process will create 50 records from 01-Test to 50-Test. -
Alpha - The wildcard values will be letters. The number of letters will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is "10150-*." Your Sequence Type is 'Alpha' Your Min Sequence Number is "0" and your Max Sequence Number is "26." The clone process will create 26 records from 10150-A to 10150-Z.
Min Sequence Number (FRFacilityClone_FacilityLocationSequenceMin)
Enter the starting value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will auto-fill leading zeros as appropriate based on the number of wildcard asterisks being used in New Record Code List.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. The first code created will be Test-001. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B" and so forth.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is "0." The first code created will be Test-AAA the second code will be Test-AAB etc....
Max Sequence Number (FRFacilityClone_FacilityLocationSequenceMax)
Enter the ending value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will create as many new records as numbers in your range.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. Your Maximum Sequence Number is 999. The system will create 1,000 codes from Test-001 to Test-999. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B" and so forth through "z." In the event you have multiple asterisks the system will continue using alpha characters in the sequence of the alphabet (AAA - AAZ ABZ - AZZ BZZ-ZZZ). The system will NOT do every possible combination of a-z in the event of multiple asterisks.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 0 . Your Maximum Sequence Number is 75. The first code created will be Test-AAA the second code will be Test-AAB etc... the 27th code will be ABZ the 28th will be ACZ etc... through to ZZZ.
Clone Linked Tables to this Facility? (FRFacilityClone_FRFacilityTables)
If opting to create new Locations from the Facility, accept the default entries (all tables) or click the Picklist icon to select which information (i.e. which screen tabs) you wish to clone from the existing record to the new records.
Delete