Hello,
I have tried to mass update user names (from " " to " "). 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
use sql and update "resource" table column "name"
create script with set of update statements and execute:
UPDATE 'dbname'.`resource`
SET
`name` = " "
WHERE `name` = " " ;
---
Thanks. However, I need this kind of solution from the application. Is it possible?
Bernard
Frankly, I've never tried
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.
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
Hi,
I had similar problems before with the first column of import files (other topic in this forum)
Remove BOM in csv or update ProjeQtOr solved it.
Hi,I could not reproduce you issueI used and screenshot of result : names are correctly updated
He used V9.0.6
The problem with bom was solved by you after V9.2.2 (thank you 🙂 )
https://www.projeqtor.org/en/forum/5-ask-questions/11734-import-csv-with-activity-name-change#30925
Thanks. It worked.
I did both the suppression of the BOM and update the column name. When I exported the data, the column name was in English (real name). However, I use the French interface. And it worked with the French column name (nom usuel).
Bernard