Moving Signup Clients to a new Branch without loosing transactional data.
  • 11 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Moving Signup Clients to a new Branch without loosing transactional data.

  • Dark
    Light
  • PDF

Article summary

How can you move Signup Clients (computers) from one Branch to Another without loosing the transactional data?


The only way to move the pc's would be using a sql query.

Note: moved transactions will be assigned to the new group/type that the machine is placed in. The transactions stay with the individual PC.

The following are the tables of interest in the DB:

computers

computer_types

computer_groups
 
From these 3 tables, you can work out which pc is in what group etc.

The following is a query to move a pc:

update computers set computer_type_id = 2, computer_group_id = 2 where computer_id = 2

In my scenario, I wanted to move a pc from Branch 1 in Computer Group 'Default Group' (computer_group = 1) and Computer Type 'Internet' (computer_type = 1) to Branch 2 in a different computer group and type.

After running the above query, a change control would still need to be performed to push the changes to the client pc's.


Was this article helpful?


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.