Hi,

many of our non-software-oriented projects have the same "project folder layout" in OnTime, i.e. they consist of a main project folder and then four or five subfolders for the standard phases the project will go through. We would like to design a kind of "project template" so that when a new project is started, a standard "hive" of project folders (each of which perhaps also would contain several standard items, i.e. features) can be generated, so that the responsible project manager doesn't have to create each folder and its standard items manually.

Would it be possible to automate this task using the SDK (or any other way, i.e. via SQL script)?

Many thanks!

The OnTime SDK does not currently support adding of projects.  Doing it through SQL is certainly possible, though not recommended.

If you do end up doing it through SQL, though, a few things to keep in mind:

• remember to set the ParentId and Path fields properly in the Projects table, or make sure to use the insert/update sprocs
• there are four tables you may need to look at for 'assigning' things to the project:
• ProjectWorkflowSettings
• ProjectFieldTemplateSettings
• ProjectEscalationSettings
• ProjectCustomerPortalSettings
• if you need to set up security for the projects, you'll need to use the SecurityRoleProjects table to assign the projects to the roles you want.

---

Dan Suceava
http://www.axosoft.com