For the complete documentation index, see llms.txt. Markdown versions of documentation pages are available by appending .md to page URLs; this page is available as Markdown.

Data Import Tool

Installing Data Import Tool

  • I want to Install the Data Import Tool

The installation guide is available at this link: Installing Data Import Tool

Getting started with Data Import Tool

Introduction to Data Import Tool

What is Data Import Tool?

  • Data Import Tool is a Microsoft Excel-based tool created to import data into the Spade Core Banking platform.
  • Using this tool, one can download Excel sheets, enter all the required information in the Excel sheet itself and upload it.
  • One can enter multiple clients, groups and centers information in the Excel sheets downloaded as a separate sheet for each category.
  • Similarly, one can enter information about multiple loan accounts and savings accounts given to the customers.
  • If the Excel sheet is uploaded successfully, the updated information will be shown instantly on Spade Core Banking.

Data Import Tool vs. Data Migration Tool

  • Data Import Tool allows you to transfer data and perform load operations between a database and external files (like Microsoft Excel sheets).
  • Importing data can be done in different file formats.
  • Data Migration Tool allows users to transfer data from a legacy 2.x deployment to Spade Core Banking.
  • Data Migration Tool uses ETL (Extract Transfer Load) for database operations.

What You Can’t Do Using Data Import Tool

  • You can’t create offices and employees.
  • You can’t define currencies and funds.
  • You can’t create loan products, savings products, and their respective charges.
  • You can’t create users and set them definite roles and permissions.
  • Data table inputs cannot be captured.
  • You cannot update client details.
  • You cannot enter loans in partial state.

HOWEVER, the Data Import Tool allows you to perform all the operations listed above.

Then, why do we need the Data Import Tool?

  • You can enter information about thousands of clients in a Microsoft Excel sheet, and once you upload it successfully, It is as good as creating thousands of clients in one-shot (saves time and improves efficiency).
  • Similarly, you can assign loan accounts and saving accounts to thousands of clients at once.
  • You can do repayments for loans and deposits, withdrawals for savings as bulk using Data Import Tool.
  • You can approve loans and disburse with dates for a number of loans given to the clients.

Security aspects:

  • Your Spade Core Banking username and password mentioned in dataimport.properties file can be seen by unauthorized users.
  • You need to keep the file either hidden or password protected so that only authorized users can access the file.

Related articles