Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Typia

Pages: [1] 2 3 ... 5
PCS General Board / Re: PCS and Active Directory security
« on: July 20, 2021, 10:53:39 pm »
You import users but map groups . My understanding, but we are still trying this, is that as soon as user is added to a mapped AD group, the user will be able to perform all the functions the group is mapped to.

I'm gonna try but in my understanding groups are not mapped and you have to make a manual sync everytime a user is added on AD
(you click sync, new users are on the left, and you click add)
Moreover, when a user is removed from AD, his authorizations are left and you have to delete it manually.

General Board / Re: Disable version control completely
« on: June 29, 2021, 09:38:58 pm »
I took a look at your script and saw it was not allowed for SQL server repositories which is my case.

That is simply a safety measure for use so we don't accidentally execute this on our production database.
You can disable that check by removing that part of the code.


Ok, but if I'm not mistaken in your script you only set iscontrolled field to 0, but version control also modifies a few other fields (XMLPath and maybe others).
If I run your script, it will set all packages to iscontrolled = 0 and may allow me to remove completely version control on project but will leave fields filled that should not be.
Am I wrong ?

General Board / Re: Compare two models
« on: June 29, 2021, 09:34:50 pm »
Hi !
Elaboration :

Project B is copy of Project A 1 month ago
Team should have worked on project A but some team members worked on project B
I want to know which object are different between two projects

General Board / Re: Disable version control completely
« on: June 29, 2021, 07:55:34 pm »
thanks for your reply.
Problem is I have a lot of package which are configured, and I have to through each of them, often not knowing where they are in the Project Browser.

I took a look at your script and saw it was not allowed for SQL server repositories which is my case.

Can I make a request on db just to check which packaged are version controlled and disable it in EA then ? I think it's the safest way to do

You can manually remove version control from each package via the menu option Configure | Version Control | Package VC

You can do the same thing using a script

Or use the nuclear option and update the database directly


General Board / Compare two models
« on: June 29, 2021, 07:50:47 pm »
I have two models stored in 2 different DB repositories, is there any way to compare differences between the 2 models ?

Many thanks,

Best regards

General Board / Best pratice to copy Package from a model to Another
« on: June 29, 2021, 07:49:38 pm »
Hi guys,
what's the best practice to copy package from a model to another ?
Copy --> Paste Full Structure for Duplication or Publish --> Export XML --> Import XML ?

PCS General Board / PCS - Modify connection string for a model
« on: June 29, 2021, 07:17:15 pm »
we're currently migrating our Database Server.
I see no possibilities in Database Manager to simply modify the DB behind a model (can't even edit the connection string).
I have to delete entry in Database Manager and recreate it.
Is there any way to simply modify an entry, or mass modify it ?

Many thanks.

PCS General Board / PCS and Active Directory security
« on: June 29, 2021, 07:12:57 pm »
we're currently moving from a DB based access to PCS
We have about 50 databases, one per project which are secured by an AD group each e.g for project1 EA_Project1 DB and AD group.

In my understanding, when using PCS, user which launches PCS must have full access to every db then security is set up within EA Model internal security.

We would like to keep an AD based and Managed Security. I know EA internal Security has capabilities to import AD users and groups but it's only import.
We need a live sync between our AD groups and Security.

I must admit I'm pretty confused by advertised capabilities of PCS, as I find really hard to understand what's advertised as prolaborate (seems like prolaborate has that full sync AD access) and PCS.

Is there a way we can achieve our needs ?

Many thanks

General Board / Re: Any way to check last modifier ?
« on: June 23, 2021, 10:45:19 pm »
Thanks for your reply,
currently the only versioning system we use is git and it's not supported by EA.
I'll try auditing and track the size growth.

General Board / Disable version control completely
« on: June 23, 2021, 10:43:41 pm »
Hi guys,
we configured a SVN version control which is now out of date and no more supported in our company.
I'd like to delete configurations in version control settings but it states that configuration is currently used in many packages and I can't find where disable it on those packages.

Is there any way to simply disable version control ?

Many thanks.

General Board / Any way to check last modifier ?
« on: June 23, 2021, 10:36:27 pm »
Hi guys,
I may not have looked the right place but I can't find last modifier on an object, only author.
Even in the database on t_object and t_diagram tables I only find Author, createddate and modifieddate fields.

Where can I have information for last modifier ?

General Board / Re: Model users mass management
« on: June 15, 2021, 10:24:15 pm »
You could run a repository.execute("DELETE FROM t_secuser WHERE userlogin <> 'admin'")

That's just out of my head without testing. So make a backup and try out.

I'm not sure if that is the best idea. You risk creating orphaned records at table such as t_secusergroup, t_secuserpermission, t_seclocks and maybe others.

It will be faster and safer to simply delete the 100 users using the GUI. That isn't going to take more than half an hour is it?


You're right.
atfer recount I had almost 500 users (imported from AD ..) I deleted manually

General Board / Model users mass management
« on: June 15, 2021, 06:46:45 pm »
Hi guys,
I have a model with security enabled and users added over time (more than 100 ..)
I would like to clean up and remove every user in the model but local admin one.
Currently I can't select more than 1 user a the time and list is refreshed every time I click on delete.

Any way to mass modify users ?

Many thanks

I'd like to change the log directory for a Jira integration, by default it seems to be in %install_path%/SBPI/logs and it's greyed out in config client.

How can I change it ?

Many thanks

Hi guys,
we have a need to track users activity through PCS.
We used to track it with keys checkin / checkout in keystore service but as far as I know when we use keystore feature of PCS there's no more logging.
Regarding the use of PCS keystore feature, is there a way to use it without providing user / password ? When I want to register an EA Client, user / Password is required.

More generally, we would like to track user activity through PCS, is there any way to acheive it ?

Many thanks

Pages: [1] 2 3 ... 5