Import Loans - Wizard Mapping

screenshot of the mapping page to match the source file with the loan wizard's properties

This page allows you to match up the data from excel to the equivalent boxes of the loan wizard. Each of the boxes that the loan wizard presents appears in this mapping list.

You can map as many or as few properties as you like to the loan wizard. Technically, you can proceed with none of the properties mapped, but you’ll just get a bunch of loans that are set up with whatever the loan wizard uses for defaults.

Connect the properties to your fields in the excel file. For options that are true/false or have drop-down choices, those options are available in the list, along with the options to map to a column in the excel file. You can also type anything you want into the boxes to have a single value copied into every imported loan.

Many of the properties are used conditionally. For example, the interest schedule, count, start, end, and end type are only used if the Schedule Selection property is set to “Separate”. Separate here denotes that the interest is on its own schedule and the wizard will create that schedule using these settings. If either “Daily” or “Payment” is chosen for the Schedule Selection, the wizard ignores the interest schedule settings because the interest is calculated based on the days between events on the loan, or on the same schedule as the payment, respectively. In those cases, the interest schedule is defined by other settings in the wizard. If you set up an Amortized loan using the loan wizard, you’ll notice that the interest schedule is only enabled if your choose the “Interest is on a separate schedule” option. This is how it goes with all of the setting you will map to import loans. Some settings are not needed if another setting overrides them.

For mapping your import, only relevant settings need to be mapped. It’s ok to leave anything as the default value if you wouldn’t have to change it in the loan wizard. If you were to map the interest schedule anyways, and the schedule selection was set to payment, there’s no harm done, as the importer will run the wizard and the properties are ignored anyway. Only a mapping that supplies incorrect information to a field will cause any trouble.

Be sure to leave any fields that you don’t need to use as “-not set-”, so the importer will leave the values on the wizard’s default value for that property.

If the Account Number is blank after the mapping is applied to the loan wizard, Moneylender will assign the next automatic account number based on the portfolio settings.

The required data type is listed in parenthesis next to each box. Be sure the values from excel, or the values you type in can be converted to the proper data type.

DateTime is a date field. Usually Moneylender will ignore time values.

Boolean is either True or False.

Double is a number that usually has a decimal point, like an amount of money or an interest rate.

Int32 is an integer – whole numbers only.

Any of the other types you see are called Enums, and that means there’s a list of possible valid values. If you will include one of these in your excel file, be sure to exactly match what Moneylender is expecting. For example, ScheduleType is the frequency used throughout Moneylender. You can map a column in Excel to a ScheduleType as long as the column has the exact values like “Weekly” and “Monthly”. If the column has “W”, “monthly”, “month” or anything else, the mapping will not work. Any enum will have the list of possible values shown in drop-down for that property mapping.

When you have mapped any fields that will get their data from the Excel file, and set constants wherever the value should be different from the wizard’s defaults, click Next to continue.