There are functions built into MISSION: Auto Number specifically for importing data.
MISSION: Auto Number has a specific function named “IGNORE”, which when used during the create or update of a record tells the sequence rule to skip processing the record and instead write a “NULL” value in lieu of the “IGNORE” value.
An example would be:
- A user wants to import a large amount of historic account records but does not want to trigger the sequence rule that will write a value to the “Account Number” attribute
- The user may want to do this instead of temporarily disabling the rule so that ongoing processing of accounts will continue to generate sequence rule values
- For the user to achieve this they simply enter the text value of “IGNORE” in the “Account Number” attribute.
- The sequence rule reads the value “IGNORE”, does not apply the rule to that record and instead replaces the “IGNORE” value with NULL when it is written to the account record