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. If for some reason a change was done incorrectly, it now can be undone.
Note: At this moment, the page is only available for a selected group of pilot customers.
Once the pilot phase has finished, all users with the role of ‘Administrator’ will get access to this page.
If you click this tile, a new page will open and by default show the date range of the last 7 days and filter on the ClientCarriers setting group:
Learn more about the different filter options and functionalities:
- Filter: Affected setting group
- Filter: User
- Filter: Account
- Filter: Search value
- 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 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: 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 I click on the Details link at the end of the line, you will see this value:
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
At the end of each line, the button Details is available. If you click it, 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 is 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.