Understanding Control Numbering Options in Imports

Understanding Control Numbering Options in Imports

When importing data across all categories, you have the option to assign a control number through your load file or in the interface. 

You have three options to attribute Control Numbers to your data.

1. Control Number Included in Your Load File - You can have a column that has your Control Number that you ESI Analyst to that field
2. Control Numbers Keyed off of a Unique ID in the Load File - You can have a separate column that will have your numbers in order and supply the Control Prefix and Zero Padding on the field mapping page.  


3. Provide the Control Number Formats and Value - You can input all Control Numbering options on the field mapping page. 
    • Related Articles

    • Assigning Control Numbers During Import

      Control Numbers are important to all projects to have a consistent numbering scheme for data reference at the item level. It is best to have an idea on how your data is going to be represented in the system before you process your first import and ...
    • Creating or Including Control Numbering in Your Import Process

      When creating Control Numbers using the import process within ESI Analyst, you have the option to have those already created in your load file OR they can be created upon ingestion.  When determining your control number you will be able to designate ...
    • How to Search Using a Specific Control Number

      When in Review Project Metadata, you can filter by a partial or full control number by clicking Control Number and you will see a text box drop down. You can either type in the full control number or a segment like part of the number or prefix as ...
    • ESI Analyst Frequently Asked Questions

      How should I format my Control Numbers? Control Numbers are important to all projects to have a consistent numbering scheme for data reference at the item level. It is best to have an idea on how your data is going to be represented in the system ...
    • Understanding Deduplication Options

      ESI Analyst offers multiple options for removal of duplicates (deduplication) from data that will aid with paring down data sets to a manageable population. However, there are instances where you may not want to deduplicate at a global level. Here is ...