Role required: admin.

Concept


In short, the VCS configuration pack provides version control in SimpleOne. Version control system allows:

  • monitoring changes, tracking who updated the record and when 
  • restoring record versions
  • transferring record versions created when updating or developing applications between unrelated instances.

VCS records provide a way to transfer data from one instance to another in an automatic or semi-automatic way. You can just import a configuration pack in order to avoid recreation of changes on every instance. This technology ensures easy update migration between instances.

For example, your team has created a new application on the development instance. Instead of copying scripts and recreating all elements one by one manually, they assemble a configuration pack and import it to the production instance. While importing this pack into the target instance, the system checks changes for possible collisions. This way, you can make sure that these changes work fine.

Configuration pack flow


Good practice is to develop new applications and implement changes into existing ones on a separate instance. This will lessen mistakes and risks for everyday processes on the production instance. Therefore, VCS records should be collected into one local pack within the relevant application.

The configuration management involves two main processes:

  • Export – collecting VCS records into a local pack on Instance #1, the result of which is a Local Pack in the Completed state and a .SOP file.
  • Import – uploading and deployment of the previously prepared configuration pack on Instance #2.

To learn more about version control in SimpleOne and more, see the following articles:

Local packs 


Local packs allow the development of application configurations on a separate instance, exporting it as a .SOP file, and implementing changes to the production instance. This approach minimizes the risks of mistakes, errors, and conflicts, which may affect the production instance during application development.

All system configuration activities should be performed within a separate local pack. Do not use the default local pack for these needs.

Local pack is a record in the VCS Local Pack (sys_vcs_local_pack) table compiling relevant records from the VCS Record (sys_vcs_record) table. This allows associating VCS records with a particular pack and exporting them as a complete set.

  • Only users with the admin role can create and read VCS Local Pack records. 
  • Admin users can edit the NameIs DefaultDescriptionState fields. 
  • They can also delete VCS Local Pack records that have empty VCS records or no VCS records at all. 

Every single version is an atomic state of versioned tables (those ones which have the Is VCS Enabled checkbox selected). All records in this table contain JSON formatted changes and other attributes described below.

Example of JSON Copy field in a VCS Record
{"value": "Report Item", "policy": "Open", "sys_id": 159653803414986194, "column_id": 156941403909472422, "record_id": 159653803414985080, "language_id": 156628684306541141, "application_id": 155931135900000002, "sys_created_at": "2020-08-04 10:47:14", "sys_created_by": 155931135900000001, "sys_updated_at": "2020-08-04 10:47:14", "sys_updated_by": 155931135900000001}

Application configurations are stored in configuration packs represented as a .SOP file. Administrators can create their own applications if needed.

There can be more than one local pack in the system, but the changes made by a single source can be written only in one local pack selected in the Admin Preferences menu at the right. That is, if the selected local pack is Default 3, all changes will be stored in the Default 3 pack.

All record versions in a local pack are displayed in the VCS Record related list.

In the Admin Preferences menu, select the local pack on which you are working. This local pack will be saved as preferred: if you switch between applications, this pack will be selected automatically. If the preferred local pack has a state other than In Progress, the local pack will switch to the default one.

VCS Local Pack form fields

FieldMandatoryDescription
NameYName of the local pack.
Is DefaultNSelect this checkbox to set the local pack as default. When moving versions from other local packs, selected VCS records will be moved to this default pack.
StateY

Local pack state. Available options:

  • In progress
  • Completed
  • Ignored
  • Rollback Previewed
  • Rollbacked.
ApplicationNApplication to which this local pack relates and which records contains. One local pack cannot contain records belonging to different applications.
DescriptionNLocal pack description.

If there is no need in assembling a separate local pack for export, all record versions will be compiled into the default local pack. The default pack can also contain VCS records moved from developing local pack (for example, created by mistake).

VCS Records


Configuration packs are also used to monitor changes in particular records.

After any transaction (create/update/delete) for the versioned table object, the record is created in the VCS Records (sys_vcs_record) table corresponding to the object state after the transaction. The record version contains the information described below.

  • VCS records cannot be created, updated, or deleted manually. These records are created automatically by the system. Only users with the admin role can read them.
  • Admin can also edit the Local Pack and Is Strong Overwrite fields. 

Please note that removing does not mean 'deletion': removed records are stored in the default local pack.

If a local pack includes unwanted VCS records, move them to the default pack by completing the following steps:

  1. Navigate to Configuration → Local Packs.
  2. Open the VCS Local Pack containing the VCS record you need to remove.
  3. Scroll down to the Related Lists area and open the VCS Record tab.
  4. Select record or records to be removed by selecting the checkboxes and click Move to Default.
  5. These records will be removed to the default local pack of the same application.

As a result:

  • Selected record versions are removed to the default pack.
  • Record versions with the same Record ID as the selected ones are removed to the default pack.

VCS record removal is not available in default local packs.

Default local pack is a local pack with the Is Default checkbox selected. 

VCS Record form fields

FieldDescription
Table Name

System name of the target record table.

RecordUnique ID of the source record processed by the transaction.
Document Record

Target table ID and target record ID for which the current record is created. For example:

JSON Copy

This field stores target record attributes in JSON format as an associative massive.

Example
{"value": "Report Item", "policy": "Open", "sys_id": 159653803414986194, "column_id": 156941403909472422, "record_id": 159653803414985080, "language_id": 156628684306541141, "application_id": 155931135900000002, "sys_created_at": "2020-08-04 10:47:14", "sys_created_by": 155931135900000001, "sys_updated_at": "2020-08-04 10:47:14", "sys_updated_by": 155931135900000001}
Is CurrentThis checkbox is a marker for relevant version records. When selected, the version corresponds to the target record relevant for now, in other words, it is the most up-to-date version.
Created byAuthor of the changes.
Created atDate and time of record creation.
Local PackLocal pack to which this record is related.
Retrieved PackRetrieved pack to which this record is related.
Restored byUnique ID of the version record from which the current record was restored.
Action

Transaction type. Available options:

  • Create
  • Update
  • Delete
Record Policy

Current record protection policy after the transaction is over. Possible options:

  • Open
  • Changed
  • Protected
Is Strong OverwriteWhen selected, the current record will be written over the existing version with the Protected policy.

Restoring VCS Records


All the record versions – both previous and current – are stored in the VCS Record table. Current versions have the Is Current checkbox selected.

If you need to restore one of the record previous versions, complete the steps below:

  1. Open the record which version you need to restore.
  2. Scroll down to the Related Lists area and open the VCS Records tab.
  3. Open the record version you need to restore.
  4. Click Restore Version.

Another way to restore a record version is the following:

  1. Navigate to Configuration → VCS Records.
  2. Find the record to be recovered. You can use list search boxes or the Condition Builder.
  3. Open the record you need.
  4. Click Restore Version.


After that, a new VCS record is associated with the current local pack. It will be displayed in the VCS Records related list.

Some forms may not display the VCS Records related list by default. You can add it to the versioned table form as a related list. After that, all versions (previous and current) of the current record are displayed on the record form.

To add the VCS Record related list, perform the following steps:

  1. Open a record for which you need to add the related table.
  2. In the hamburger menu, select Configure → Related List → Layout.
  3. Move the VCS Record->Document Record element from the Available box to the Selected box.
  4. Click Save to apply changes.

Protection Policy


The Protection Policy attribute is responsible for data protection purposes. After creating a record in the versioned table, the Protection Policy for this record is Open. Once the record is updated, the Protection Policy becomes Changed. These values are transferred to the Record Policy field in the related VCS record, that is, the record version has the same Policy as the record itself.

Admin can update only the Local Pack and Is Strong Overwrite fields of records with any protection policy.

During the importing process, the records possible to overwrite can be updated. Both record policy values set in the system and in the configuration pack are taken into account. All possible policy combinations are described in the table below.

Source record Protection PolicyTarget record Protection PolicyResult
Protected

ProtectedSuccess
OpenSuccess
ChangedSuccess
Changed

ProtectedFailed. Use Strong Overwrite to proceed.
OpenSuccess
ChangedSuccess
Open

ProtectedFailed. Use Strong Overwrite to proceed.
OpenSuccess
ChangedFailed. Use Strong Overwrite to proceed.

/

  • No labels