TrackStudio 3.5.31 has been released

admin · Last edited by admin on Mon Jun 22, 2009 10:14 pm; edited 1 time in total

What's new:

1) Now TrackStudio support templates-configurations. You can create configuration (workflows, categories, users, tasks, permissions) using server manager and move them between server. Configuration is just difference between old saved XML exoirt and current database state.
2) If only one category is available for user - it will be default in the "Create a task or a project" pulldown.
3) If user have no subordinates or task have no subtasks TrackStudio will jump to Task/User page, instead of Subtasks/User List.
4) SVN diff now with changes highlighting.
5) Enter in editor don't add empty line now.
6) You can set login/password in URL directly now:

vadimk · Joined: 06 Nov 2005 Posts: 233

admin · Posted: Fri Jul 18, 2008 2:33 pm Post subject:

vadimk · Joined: 06 Nov 2005 Posts: 233

admin · Posted: Fri Jul 18, 2008 3:56 pm Post subject:

vadimk · Joined: 06 Nov 2005 Posts: 233

admin · Posted: Sat Jul 19, 2008 9:26 pm Post subject:

vadimk · Joined: 06 Nov 2005 Posts: 233

You are suggesting to have 2 instances of TS against the same database.
When I first time start the second instance will it alter the database, which would affect the original instance in any kind?
_________________
--
Vadim

vadimk · Joined: 06 Nov 2005 Posts: 233

Just installed SA version and played a bit with the test database (in fact just took a look into the configuration management and the base configuration file (/etc/sql/en.xml).

From what I see is the good dump of the database tables that contain the needed configuration. It shold serve well when migrating to the new database (between test database and production database - a very valuable tool indeed).

But applying this to the target issue of cloning pieces of the existing database - I am not sure how useful it is going to become.

Here are pros and cons:
* the obvious value is to list ALL tables that are related to the configuration (about 10% of saved effort comparing to what I was doing my cloning script)
* when preparing the project template I would need to manually strip off XML nodes for records attached outside the template task (10-25% of effort when I was doing my cloning script; additional 20% of effort comparing to same logic if done in relational database)
* when importing hopefully the configuration management would merge / append configuration records without removing records not found in the XML file (showstopper if not)
* the problem would still remain of remapping GUIDs - basically the part of the configuration management would be to generate the import configuration template from the seed template, which would include producing the new XML from the pre-existing XML, and generate and properly propagate all GUIDs changes (about 50% of effort in the cloning script)
* the obvious value of database independence (but it is mostly value for you - I always use and will use SQL Server)
* another value is stability - instead of going after the details of database structure (including ways of handling long text) using this method would allow to abstract the logic and stay reliable (reliability + 10% of saved effort)
* the issue where I failed with my cloning script is cloning filter definitions since very special internal structure that needs to be parsed espocially in cases of UDFs; preparing the new filter definitions would require as much effort to update it in XML as inside the database itself (failed effort, but took about 10% of effort while I was working on my cloning script)
* both methods would require the server restarts after executing; however, going after database could be programmable while using ServerManager is the multi-step manual activity - assuming the pre-existing XML is prepared the first step would be running the process to clone XML and then there will be manual step of using configuration management to apply it; and the third step would be to restart the run-time environment
_________________
--
Vadim

admin · Posted: Sat Jul 19, 2008 11:34 pm Post subject: