View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - How to mass update data? - ProjeQtOr
 

How to mass update data?

More
03 Nov 2021 20:10 #1 by bgenolini
Hello,
I have tried to mass update user names (from "<first name> <last name>" to "<last name> <first name>"). I have prepared the xlsx file with ids and the new field names. I don't get any error at import, but the field are not changed. Is it related to the old version I am using? (v. 9.0.6).

Any solution? Thanks in advance,

Bernard

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

More
04 Nov 2021 12:40 #2 by mkavurcic
Replied by mkavurcic on topic How to mass update data?
use sql and update "resource" table column "name"

create script with set of update statements and execute:
UPDATE 'dbname'.`resource`
SET
`name` = "<last name> <first name>"
WHERE `name` = "<first name> <last name>" ;
---

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

More
05 Nov 2021 10:57 #3 by bgenolini
Replied by bgenolini on topic How to mass update data?
Thanks. However, I need this kind of solution from the application. Is it possible?

Bernard

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

More
05 Nov 2021 11:04 #4 by mkavurcic
Replied by mkavurcic on topic How to mass update data?
Frankly, I've never tried

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

More
08 Nov 2021 14:21 #5 by babynus
Replied by babynus on topic How to mass update data?
Really it should work.
You just need to export, change and re-import id and name for users.
On import result, check result for each line *, on rightmost column.
Also take care that you have 'name' which is the user name (account) and 'fullName' which is I think what you expect to change.

Babynus
Administrator of ProjeQtOr web site

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

More
08 Nov 2021 15:26 #6 by bgenolini
Replied by bgenolini on topic How to mass update data?
This is what I did. I have three columns: id, user name, real name, which is the element I want to change. The result column says that there is nothing to change, for each line. The result is the same, wheter in xlsx or csv format.
I did not see any information in the log file.
I've tried without the id column, and the error message is that the user name is mandatory. With the id but without the user name, I have the same behavior as with the user name.

Bernard

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

Moderators: babynusprotion
Time to create page: 0.048 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.