Introduction
Until now it has not been possible for a user to see who changed something in the configuration/settings of an account or to see the previous value of a setting. The possibility to see this in MyTranssmart is now added. Also, the functionality to restore a previous version of a modified or deleted record is added. It is also possible to restore a batch of changes that were done at the same time, for instance via an upload.
If for some reason a change was done incorrectly, it now can be undone.
All users with the role of ‘Administrator’ have access to this page.
If you click this tile, a new page will open and by default show the date range of today and filter on the ClientCarriers setting group:
Learn more about the different filter options and functionalities:
- Filter: Affected setting group
-
Filter: User
- Parent user
- Database user - Filter: Account
- Filter: Type
- Filter: Search value
- Toggle: Show per batch
- Column: Affected user
- Column: Type
- Details page
- Restore of an older version
- Explanation of versions
Filter: Affected setting group
In the filter Affected setting group you can choose from a dropdown list which setting / table you want to see:
Explanation of all possibilities:
|
Affected setting group |
Affected setting detail |
Explanation |
|
AccountSettings |
culture |
Language setting |
|
defaultSettings |
Settings of page Account Settings |
|
|
mailTemplateIsoCode |
Mail template ISO code |
|
|
additionalReferences |
Active additional references in Account Settings |
|
|
bookingProfiles |
All booking profiles of this account |
|
|
packages |
All packages of this account |
|
|
costCenters |
All cost centers of this account |
|
|
themeSettings |
Theme settings of this account |
|
|
addressSearchAlgorithm |
Address book setting search method 'contains' / |
|
|
UserSettings |
dashboard |
Landing page setting of the user |
|
shipmentScreenSections |
User setting which fields/sections are visible |
|
|
culture |
Language setting of the user |
|
|
defaultSettings |
All user settings of My Details |
|
|
ClientCarriers |
‘Qualifier code’ |
Config table |
|
RoutingRules |
No details |
Config table |
|
TransitTimes |
No details |
Config table |
|
Generics |
No details |
Config table |
|
DocumentGeneration |
No details |
Config table |
|
DocumentRetrieval |
No details |
Config table |
|
Zones |
No details |
Config table |
|
OpeningHours |
No details |
Config table |
|
BuyRates |
No details |
Config table |
|
SellRates |
No details |
Config table |
|
SellMargins |
No details |
Config table |
|
BuyWeights |
No details |
Config table |
|
SellWeights |
No details |
Config table |
|
Weights |
No details |
Config table |
|
MailTemplate |
No details |
Mail template configuration |
|
MailTimes |
No details |
Mail trigger configuration |
|
MailTemplateGroups |
No details |
Mail template groups |
|
Accounts |
No details |
The account fields: name, code, parent, org_code and featureSet |
|
Users |
No details |
The user fields: name, email, password (hashed) |
Filter: User
If you want to see all changes that one specific user made, you can either:
- Type in (a part) of the name and it will filter on it or
- If you see the desired name on the screen, you can click the Copy to filter button to copy/paste the whole value into the user filter:
So the filter User matches with the column Changed by.
Important note: If you only type a part of the user name and search in a table with many records (e.g. Buy Rates, Sell Rates) then it might take a while to load. In these tables, it’s better to search using the full user name.
Parent user
If a user of the (grand)parent account or employee of nShift has made the change, you will not see the user name when you log in to a subaccount. Instead, you will see the parent user.
In the example below, I am logged into the account TEST* and you can see the change log record 1 was done by a user of this account and record 2 was done by someone of the parent account:
If I log in to the parent account MASTER*, you can see which user it was:
Database user
If an automated process or service has made the change, it will say database user.
Filter: Account
If you want to see all changes for a specific account, you can use the dropdown list to search for the right value:
So the filter Account matches with the column Affected account.
Note: you cannot select values "SELECT ALL” or “SELECT EMPTY” so if you want to clear this search value, use the option Clear filters.
Filter: Type
If you only want to see changes of a specific type, you can use the dropdown list to search for the right value:
Filter: Search value
If you have selected a specific setting in the Affected setting group, you are able to search for a value in the details of the records, so for instance, when I search for “123456” it will find this record:
When you click on the line, you will see this value:
Toggle: Show per batch
If you toggle on this option, it will group the results per batch. A batch is a collection of records that were inserted, updated or deleted at the same time. In the column 'Count' you can see how many records the batch contains
If you click on a line, a new page will be opened and will show you actions you can do for this batch.
- It will first summarize some details of this batch: the time, who did the change, which setting group and how many records the batch contains.
- If you press the button Download, it will download the records to Excel. You can use the download to check/verify if it is indeed the batch you are looking for. If so, you have 2 options: either use this Excel file to upload it (if you have the rights to the Admin Panel) or go to step 3:
- If you press the button Restore it will restore the records.
- Press the button Cancel to leave this screen.
Note: the same page is shown, if in the default Change Log page -so with setting Show per batch toggled off- you click the button Show batch at the end of a line.
Column: Affected user
In the affected setting groups UserSettings and Users the column Affected user will show the user of the changed record.
Column: Type
This column will tell what type of change it is:
|
Type |
Explanation |
|
INSERT |
The creation of a new record |
|
UPDATE |
The modification of an existing record |
|
DELETE |
The deletion of an existing record |
Details page
If you click on a line, a new page will be opened and will show you all* versions of the current record.
*Note: it will show a maximum of 100 previous versions and it also depends on the retention period. How long we keep the data varies from one setting to another.
- Fixed value “Change log”.
- For informational purposes, the setting group and setting detail of the record are shown.
- A fixed column with the field names. Will stay visible on the screen if you scroll to the right (See 5.)
- The columns represent all versions of this record.
- Scroll bar to scroll to the first version (INSERT) of this record.
Restore of an older version
- If you wish to restore a version of a record, select the radio button in the desired column
- Click the Restore button to restore it. A warning message will popup:
- Click the Restore button and you will see this message pop-up:
Explanation of versions
- In this case, the rightmost column is the INSERT of the record. You can see which values I inserted.
- Then in the second column from the right, you can see I did an UPDATE; I filled in Cost Center “CC” and changed the value from “1” to “2”.
- In the second column from the left, you can see I did another UPDATE; I deleted the Cost Center.
- And finally, in the left column, you can see I deleted this record. All fields are empty.
The left column is always the current version of the record so therefore it has no radio button.
Normally, DELETE is the final state of a record because a newly inserted record will never get the same Record ID as a record that has been deleted.
There is one exception: if you restore a previous version of the deleted record, it will keep the same Record ID. So if you then look at this details page, you will see after the DELETE, a new INSERT is done:
So, a restore action is also always logged and therefore visible in the Change Log details of a record.