VCS Enablement and setting automatically

[Svelan]

Hi

We are using PLSQL Dev with the VCS Plug-in. However for any new developer using the PLSQL, the VCS plug-in needs to be enabled manually.

Is there any possibility to enable the VCS for all users?
Also is it possible to configure the user with the windows login onto the VCS from PL-SQL Dev?

Any help is greatly appreciated.

Thanks and Best regards,
Velan

 

[Marco Kalter]

Any Plug-In will be enabled by default. They can be disabled through Tools > Configure Plug-Ins. A disabled Plug-In will have an entry in the following registry section:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\Configuration

If the Plug-In is listed with a 0 value, it is disabled. If it is not listed, or listed with a 1 value, it is enabled.

 

[Svelan]

Hi
Thanks very much.

My situation is like this:
We install PLSQL Developer fresh with ADMIN -> Install VCS PLUGIN.

A new user logs in to PLSQL Dev-> While login he does not get the VCS window. Hence he goes to the tools -> Plugin-> Add it -> The relogin -> he need to choose the VCS Database.

My question is : Is it possible by one setting that these parameters of the VCS (Database, User, Password and enablement) are automatically done for all users logging in?

Your reply is highly appreciated.

Thanks
Velan

 

[Marco Kalter]

A new user logs in to PLSQL Dev-> While login he does not get the VCS window. Hence he goes to the tools -> Plugin-> Add it

As stated before, this is only necessary if the Plug-In is disabled.

My question is : Is it possible by one setting that these parameters of the VCS (Database, User, Password and enablement) are automatically done for all users logging in?

You need to configure this once on a PC, and then export/import the following registry section:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS

 

[Svelan]

Dear Marco,

Thanks very much for your inputs once again. Pardon me for giving the inputs quite late. However our problem is that we have multiple users log into the same server (like Terminal Server connection).

The above method suggested works for the same user if he logs in different environments. How do we make sure that the setup done (VCS Project details) by the admin or a single user is transmitted automatically for all users?

Thanks in advance for your help!

Best Regards,
Velan

 

[Marco Kalter]

The above method suggested works for the same user if he logs in different environments. How do we make sure that the setup done (VCS Project details) by the admin or a single user is transmitted automatically for all users?

You would have to ensure that a corresponding registry import runs when such a user logs on.

 

[Svelan]

Hello Marco,

Thanks very much for your inputs and it seems to be working fine for the defaulting of the parameters, provided the user has set his VCS parameters.

I have a problem for the fresh login user where the VCS defaults are not setup. I tried creating the individual registry in such a case but this really does not work.

For example, when we launch PLSQL Dev => Tools => Configure Plugins => Plugin Manager => Configure => Choose the VCS tool which we want to integrate.

In the above situation, I am not sure to understand where this setting is saved. I tried the ini and also the registry but do not know where this default VCS tool selection is saved. If I know this, then I could simply add it for each user even if he is never logged on before.

Thanks in advance for your help and feedback

Regards,
Velan

 

[Marco Kalter]

Settings are stored in the registry at this location:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS

The settings for each VCS tool are in store in a group with its name. For example:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\Microsoft Visual SourceSafe

 

[Svelan]

Hello Marco,

I observed that but I am not sure which registry corresponds to the default VCS system as we have three VCS system (PUSH OK SCC, VSS and TORTOISE ).

I tried this option as below to run during the launch of PLSQL Dev and it populates the entry onto the registry but when we see from PLSQL the default system is still not selected and we need to choose it manually:

CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowCommentCheckOut" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowCommentCheckIn" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowCommentAdd" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowCommentRemove" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsCheckOut" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsCheckIn" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsUndoCheckOut" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsGet" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsAdd" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ShowOptionsRemove" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "QueryFileStatus" /t REG_DWORD /d 00000001 /f
CMD.exe /c REG ADD "HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\PushOk SVNSCC" /v "ReopenProject" /t REG_DWORD /d 00000001 /f

Thanks for letting me know how we could resolve this problem.

Best Regards,
Velan

 

[Marco Kalter]

What happens on startup is this, a list of recently used projects is loaded from this registry section:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\ProjectHistory

and if the following value is 0:

HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\VCS\Init

then the most recent item from the ProjectHistory is activated.

So you'll need to add one item to ProjectHistory. A running version should give you the values you need.

 

[Svelan]

Hello Marco,

Thanks for your reply. I tried entering the Project History entry as well. However if I have a SVN connection, its getting connected only upon saying ok in the open project section, although the settings are made.

Regards
Velan

 

[Svelan]

Hello Marco,

Thanks very much for your inputs. I tried this and it works fine as long as we have only one VCS project or only one db connection from PLSQL Developer.

Suppose if I want to have two connections to two different DBs and different SVN web addresses, how do I achieve that.

I tried the INIT value you mentioned to 2 in a command line before launching PLSQL, but it does not help. The system always takes the default project as 1.

How can i force it to use the project 2 for a particular connection. Is it possible?

Also I saw that we could pass some registry home in the commandline before launching the PLSQLdev.exe. I am not sure how to use it. Do you have an idea?

Thanks
Velan

 

[Marco Kalter]

You will have to switch projects. The VCS Plug-In can only open one project at a time.