View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Question about Resetting Values in My Template Project (Project ID 21) - ProjeQtOr
 

[SOLVED] Question about Resetting Values in My Template Project (Project ID 21)

More
06 Feb 2025 08:47 #1 by chandrashekhar
Hi There,Hope you're having a good day.I've been working on setting up a template project (Project ID 21) with some pre-existing planning information. I'd like to reset the planned start date, end date, and duration for these template tasks to be null or zero so they can be easily customized for new projects.I was considering using the following SQL update statement to achieve this:update planningelement set plannedStartDate=null, plannedEndDate=null, Plannedduration=0
where idproject=21 and (plannedStartDate is not null or plannedEndDate is not null or ifnull(Plannedduration,0)<>0) ;Before I proceed, I wanted to humbly ask for your expert guidance. I'm a little unsure about any potential knock-on effects this might have on other related data or functionalities. Would you mind taking a quick look to see if you foresee any potential issues or have any suggestions for a better approach? I really appreciate you taking the time to help me with this, especially since you're so generously providing this support without charge.

Thank you so much for your consideration!Best regards,

Please Log in or Create an account to join the conversation.

More
08 Feb 2025 12:38 #2 by babynus
Never use DB updates unless your are sure of what you do.
What you try and do will set the mess.

Use multiple update feature

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Feb 2025 06:31 #3 by chandrashekhar
Hi,

Thank you for the suggestion – using the multiple update feature for activities was my first thought as well. I tried to use it to update the planningelement, plannedStartDate, plannedEndDate, and Plannedduration fields, but they don't seem to be present in the options. I've attached a screenshot; am I missing something, or is there a specific configuration needed to access these fields?
 
Attachments:

Please Log in or Create an account to join the conversation.

More
10 Feb 2025 11:15 #4 by babynus
The "planned" values are readonly, as they are calculated by planning calcvulation process.
Just go to Gantt view and calculate planning to update these fields.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Feb 2025 12:22 #5 by chandrashekhar
Hi,

Is it compulsory to run planning calculation?
What if I've been working on setting up a template project?

There is no planning needed in template project.

Could you guide me accordingly?

Please Log in or Create an account to join the conversation.

More
18 Feb 2025 09:55 #6 by babynus
Template projets are planned, to show you what it gives with constraints you defined, planning modes and so one, but their planning is not stored.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: chandrashekhar

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.062 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.