The Log tab is the place where you can find a confirmation of the result of your import or manually edited records. All actions with regards to imported files are logged for reference and are available for review in the Log tab
Table of contents:
The following information is available in the overview:
Name: This reflects the name of the file that was imported. In case this is a manual action, this will be presented as "Records updated".
Date & Time: This is a timestamp of the exact moment the import was executed.
Status: This confirms if the import was processed successfully or if the import has failed.
Success records: The number of records that has been successfully imported into your import source in this specific import action.
Total no. of records: The total number of records that was available in the original import file.
Import type: This states the type of import that was performed (manual, through SFTP, etc.)
User stamp: This reflects the user account from which the import was initiated.
Action: This provides you with a downloadable file with details about the import attempt. If the file import is failed then this download icon comes in handy to check the exact error message.
The Name, Date & Time, Status and User Stamp columns can be sorted from A-Z and Z-A by clicking on the column header. If you would like to search the import log or place a filter, these columns allow for that as well. Just click the funnel icon next to the column header of the particular column you would like to search or filter on.
At the top right corner, you can add one or more users as a recipient of log reports.
For every successful import, users added to this list get a notification in their user profile with the result.
For every unsuccessful import, users added to this list get a notification in their user profile as well as heads-up via email.
This functionality will make sure you keep up to date with any data that is added to your data garden.
Please note that with every import attempt, the log tab is updated. When you have several failed attempts, you will be notified of each separate attempt.
By pressing the download icon underneath the action button, you will receive an export in your download folder that provides you with a more detailed.
If you download the logfile of an import it will look something like this (click to enlarge image):
The logfile will provide you with the following information:
Name: The name of the file.
Records: The number of records that were in there.
DateTime: The time the import attempt was made.
ModifiedDate: The timestamp of the last time the original file was edited.
UserStamp: The user that made the import attempt.
ImportType: The way the import was performed.
TotalRecords: How many records were part of the import.
SuccesfulRecords: How many records were successfully imported.
FailedRecords: How many records were not successfully imported.
Message: The reason why the import failed
Action and UniqueID are left blank as they are not relevant for this type of logfile.
In the screenshot above you will see that the reason for the record not being imported was because the creation date of the file did not match the conditions of the dynamic rules on import that were in place. This information will help you resolve the issue.
If you download the logfile of manually edited records, the logfile will provide you with information that is slightly different, but more suitable to the situation:
This logfile will provide you with the following information:
Id: The number of the edit that was made. Each edit has a unique, consecutive number.
LogId: The number in which log the edit is registered.
Action: What kind of action was taken? (add, delete, edit).
DateTime: The moment the record was imported (or added to) the import source.
ModifiedDate: The moment the action was performed.
UserId: The code of the user that performed the modification.
UserStamp: The name the user that performed the action is currently user for his account.
TotalRecords: The total amount of records that was involved.
SucceedRecords: The amount of records that was successfully modified.
FailedRecords: The amount of records that were not successfully modified.
Message: A description of what happened to a record.
UniqueId: The unique number (sys_imports) of the record that got modified.
CreatedOn: The created on is left blank as it is currently not relevant for this log type.
All manual updates of records that take place within one day will fall under the same logreport.