Import lessons form

This popup form can be accessed via the CSV import iconimport icon at the bottom of the Lessons tab at any of the selected parent asset view pages (e.g. Contact details iconorganisation, Programme iconprogramme, Project iconproject, Subproject iconsub-project, Risk map iconrisk or issues iconissue), as shown in Figure 1.import lessons via tab

Figure 1 – Access via lessons tab

The import popup is shown in conjunction with each phase below, and can be used to import a number of lessons from a Comma Separated Values (CSV) file into the selected parent asset.Completing the lessons CSV import iconimport consists of a number of phases:

Phase 1 – Import file

import lessons formFigure 2 – Import lessons form (1)

The first phase is to select file you want to import and some details about the file, using the browse option of the import file field. You can also set the delimiter used in the file, whether you  want Psoda to match the entries in the file with existing lessons and update those.Click the Next button to move to the next step.

Phase 2 – Mapping

import lessons form 2Figure 3 – Import lessons form (2)

Phase 2 allows you to map or specify which columns from the import file should go into which fields of the new lessons. For example the Reference field allows you to select which column to import into the reference field. The Category field allows you to select the category column, and so on. If the column headers already match the field names then Psoda will automatically select those.If you do not want to import a particular column from the file the just select the “Do not import” option from the list. You will be given an opportunity in the next step to specify default values for any fields you do not want to import.NOTE: The reference field must be unique for every lesson in your asset so you cannot choose not to import the reference.Select the Next button to move to the next step. If you have selected columns for all the fields then you will skip over the next phase (default values) and go straight to the last phase (results).

Phase 3 – Default values

Phase 3 allows you to set default values for any fields you chose not to import from the file.The fields may be the same as for creating a new lesson, but the fields present in this phase are very much dependent on which options you selected in phase 2.Click the Import lessons button to start importing the lessons.

Phase 4 – Importing…

import lessons progressFigure 4 – Import lessons form (4)

Phase 4 performs the actual import. You will see a progress bar that will automatically update and show you how much of the file has been imported. If you do not see automatic updates then you can force a refresh with the Refresh button.Once the import is complete the Refresh button will change to a Next button.

Phase 5 – Results

Once the import is completed, click on the Next button to see the results.If there were any failures while importing a table will by shown listing all of the failures including the line where the failure occurred, descriptions of the failures and the first 20 characters of the line to make it easier to identify.If any lessons were successfully imported they will be listed in a table with links allowing you to easily view the new lessons.The Import lessons form will remember the options that you selected for next time that you want to import more lessons.