Use the below script within the EP database to generate tasks for a project very rapidly with just the name of the project, the task name, and the estimated time for the task:
Turn on your Clarity VPN
Open SSMS and connect to the following server
SQL Server: 10.100.130.113\SQL2014
Username: clarity
Password: ******** (check internally for password)
Database: _CMISHQ_v01
Right click the above database and "New Query"
Open the Estimates sheet for the project you are working on
Copy the following formula into cell AD3, and drag the corner down so that it fills all rows that have a line item on them Stop Before "Projected Estimate" Row
=IF(I3="","","EXECUTE _sp_Create_Task_With_ProjectName '"&$AD$1&"', '"&B3&"', "&I3&"")
Find the "Project Name" in EP for the project you are trying to create tasks for. This should be set up by an ops team member.
Type the "Project Name" exactly as it appears in EP into cell: AD1
Copy the columns that have a created procedure script
Paste into SQL Server Management Studio window that you opened from above
Click F5
You should see an output message in the window
You should now be able to view your tasks in EP
Example script for creating a task via the stored procedure:
_sp_Create_Task_With_ProjectName 'Project Name', 'Task Name', 20