📥 File Import

Few General Rules

  1. LeaseID is a unique field and cannot be repeated.
  2. It can be alphanumeric.
  3. It can contain special characters like -, ,, ;

  4. It cannot contain &.

  5. File import functionality is available only to users with a Maker ID.

  6. Ensure all columns marked in Green are filled up. These are mandatory fields.

  7. Do not add columns or type anything in a column without a header.

  8. The file name cannot contain a period (.) except for the .xlsx extension.
    The tool searches for .xlsx after the last period to identify it as an Excel upload file.

Step 1: Move Excel Upload File into the Staging Table

  • Navigate to:
    File > Data Import

  • Click InsertDB to load the file into the Staging Table.

Basic checks performed at this stage:

  • No extra columns are present in the file.
  • No duplicate LeaseIDs within the file itself (not comparing against the tool data yet).
  • Date columns use the format YYYY-MM-DD.
  • Numeric columns contain no alphabets or special characters.

If errors occur, the ViewErrors button will be enabled. Clicking it will display error details on each line of the uploaded Excel file.

Example:
LeaseID in Row 618 (Line 619 in the Excel file, excluding header) in the sheet STLSAgreementAndAssetDetails is duplicated within the file and must be corrected before continuing.

Step 2: Move Data from Staging Table to Actual Database

  • Navigate to:
    Transactions > Imported Leases

  • Select the Checker who will approve the imported leases.

  • Click Move to Actual to start validation and import.

Validation checks performed at this stage include:

  • All mandatory fields are filled.
  • Logical validations, such as:
  • Payment start date is after lease commencement date.
  • “Date till reasonably certain” is not before the lock-in period.
  • Verification that Company name, Asset type, and Cost Centre exist in the respective Masters.
  • Duplicate LeaseID check against existing data in the tool.
  • Lease commencement date is not prior to the period close date (prevents backdated leases).

If errors are found, they will be displayed below the import section. After correcting errors, repeat Steps 1 and 2.

Successful Import Confirmation

If there are no errors, the tool will display a confirmation message along with the total number of leases imported shown in the third column.

Important:
The tool is designed so that if even a single error exists in the upload file, none of the leases will be imported. This ensures errors are fixed before re-importing.