View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Is there a way to set a field 'NULL' in multiple update ? - ProjeQtOr
 

Is there a way to set a field 'NULL' in multiple update ?

More
10 Nov 2017 16:57 #1 by caccia
Is there a way to set a field 'NULL' in multiple update ? was created by caccia
Hello,
Using multiple update, I wanted to move some tickets to a different project.
I had defined a planning activity for these tickets, but want to simply move them to new project without giving them a planning activity.

Is it possible to set planning activity = 'null' in multiple update ?

File Attachment:

File Name: export_Tic...237.xlsx
File Size:9 KB
Attachments:

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

More
10 Nov 2017 17:34 #2 by babynus
Replied by babynus on topic Is there a way to set a field 'NULL' in multiple update ?
No.
No value for field means no change.

But you can do this with import :
- export your activities to csv format,
- update you csv file to set Planning Activity to NULL
- import.
Babynus
Administrator of ProjeQtOr web site

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

More
10 Nov 2017 17:46 #3 by caccia
Replied by caccia on topic Is there a way to set a field 'NULL' in multiple update ?
I actually tried using import of CSV file, but it tells me "nothing to update" if I just set the planning activity to NULL.
See attached in my initial message - does it need quotes or something ?

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

More
10 Nov 2017 17:57 #4 by babynus
Replied by babynus on topic Is there a way to set a field 'NULL' in multiple update ?
replace header "planning activity" with field id "idActivity"
Otherwise, we look for activity named "NULL"
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: caccia

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

More
10 Nov 2017 18:18 #5 by caccia
Replied by caccia on topic Is there a way to set a field 'NULL' in multiple update ?
Sorry - I was too confident. Actually even with 'idActivity' as header I end up with "no change to update".
Perhaps you could confirm with the attached file on the Demo site ? (i don't have access to the Import screen there :))
Project is "Import-tst" .

File Attachment:

File Name: export_181502.xlsx
File Size:9 KB
Attachments:

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

More
11 Nov 2017 16:21 #6 by babynus
Replied by babynus on topic Is there a way to set a field 'NULL' in multiple update ?
Yep, that's right.
NULL value does not work for lists field.

To have it work, you must change line 431 in /model/Importable.php, from
if (substr($fldName, 0, 2) == 'id' and substr($fldName, 0, 4) != 'idle' and strlen($fldName) > 2 and !is_numeric($field) ) {
to
if (substr($fldName, 0, 2) == 'id' and substr($fldName, 0, 4) != 'idle' and strlen($fldName) > 2 and !is_numeric($field) and $field!=null) {

This patch will be included in V6.5.0
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.046 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.

Login Form