Table of Contents
Introduction
The import tool is a fast and efficient way to transfer large amounts of data to LoanPro's management system (LMS). Instead of manually inputting each individual piece of data into the software, the import tool will upload the information for you in bulk.
This article will introduce you to the import tool and briefly explain how it works. Once you understand the basics of imports, our article Importing into LoanPro will show you how to use it in the software.
Highlights
Although the import tool will upload the information for you in the software, you still have the responsibility of inputting the data for the tool to read and upload to your account. To do this, LoanPro uses .csv files.
These .csv (comma-separated values) files are spreadsheets with columns corresponding to data in the software. For example: if you are importing a customer's information into LoanPro, the .csv file for Customer Information will have columns that relate to a customer's personal information, such as their first and last name and their mailing address. We provide downloadable templates that have these columns preset so that you just have to fill in the information.
Once these files are completed, you can upload them to LoanPro and the import tool will transfer the information you entered in the .csv file into the software.
If you're transferring a large amount of data into the LoanPro, it can be a tedious process ensuring that each value you input is formatted correctly. The import tool has a few features that can make this process more manageable and decrease the likelihood of error:
- In-Software Instructions: We have instructions in the software that explains each value and how to format them correctly. We also have specific articles on common imports that provide a in-depth guide of how to do this process.
- Validation: Once you've finished inputting the data and uploaded the file to the software, the system will validate your data. You'll then be notified if there are any errors you need to fix. If there are no errors, your file will move onto the next step of ingesting the data into the system.
Where Do Imports Fit?
Moving your information from your legacy software into a new system is a logistical headache. The import tool eases your pain during the onboarding process by transferring information in less time than you may have anticipated. Using imports, the company can export their data and format it to match the .csv file columns and have their data uploaded, validated and ingested into the system quickly and efficiently.
Outside of onboarding, the import tool can help accomplish certain servicing tasks. For instance, if you're wanting to make changes to a large amount of your loans in the software, doing it manually will possibly take days to finish. Instead, you can download the relevant .csv file and input the existing loan information and values to make the necessary changes. The upload and validation process will be the same as it is for transferring data.
Imports are also useful for lenders that use a third party service instead of our integrated services for certain servicing tasks. To give you an idea of what this looks like, we have integrated with a number of payment processors for loan payments, but lenders are free to use another processing service if they feel inclined. If they choose the latter, they can use imports to transfer the information from their payment processor to the LoanPro.
This Feature is Not
- The import tool is NOT the API. While they both help make processes in the software more efficient, the import tool and LoanPro's API work differently in their own unique way. Our article Import vs API: What's the Difference? outline these distinctions clearly.
- Formatting imports correctly does require some work. Exporting your data and formatting it correctly requires some technical knowledge. Especially with large amounts of data, it is important that you are going into the import process with an understanding of all the moving parts within it.
What’s Next?
From here, you're ready to learn about the ins and outs of importing. Importing into LoanPro and Imports – Best Practices will guide you through the steps and provide tips on how to import your data successfully.
import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import import