How to use the MP-Desktop Import Log
Introduction
The Import Log provides detailed information about every file processed.
To open the Import Log, select it from the Data Entry Menu, or under Import Data in the MonitorPro Desktop Control Panel.
Users should select a date range and all data batches during that period will be displayed, colour-coded with their status. Where the column Log Available states yes, further details can be viewed by either double-clicking the row or selecting the row and clicking View Import Details. Users can further refine the list to a particular Importer under Origin, or select only those files of a certain Status.
Statuses
Success - A Green Sucess indicates the file imported directly the first time with no resolutions needed. The data included will be present in the database*
Note
*Data can be shown as Sucess as this is true at the time of import. Data can later be deleted or data subsequently imported over the original entry.
Pending/Uncommitted - An Amber Pending/Uncommitted indicates that at least one record has been held back for resolution. This could be either an unknown object(s) or validation such as a physical limit or an old date check. Users can review the resolutions required by accessing the Import Processor. This status will remain until at such point the data in the Import Processor is resolved or rejected.
Manually Processed - A Blue Manually Processed status indicates that resolutions have been made to the file and that all the data within the original file has been processed and accepted into the database. This is a follow on the status from Pending/Uncommitted.
Partial Import - A Pink Partial Import status indicates that some of the data in the file were accepted into the database but some remaining rows were discarded (not accepted). This is a follow on the status from Pending/Uncommitted.
Note
This status is also used for importing embedded (non-data files such as pdf). The files will first show as partial, with the text File Uploaded and then an automated process will try and associate the file as per the rules set on the importer. Linked files will then turn Green Success with the text File Uploaded and Linked.
Rejected - A Rejected Red status indicates the entire contents of that file were either rejected by the user and will display the text Removed, or the file failed to import and will display the text Failed - Incorrect Structure. For failed files, users would need to look at the layout of the original file and confirm that it includes the required header rows or header aliases, or that it was imported into the correct importer for that file type. More on file types are included in the Importer Setup.
Import Summary
Details on large (>2,000 row) imports are not retained for later review. Logs are also only retained for 30 days to limit database growth, however, this limit can be increased from System Options/Other Settings, but it will result in some database growth.
The first tab, Import Summary gives general information on the import.
The Source file tab shows the original format of the file as the importer saw it. Select any cell to view a summary of how it was interpreted.
The Processed file tab displays the file after it was processed to be sent to the database or Import Processor.
