sorry, wrong formatting, retry:
Dear Ralf,
I was trying to update the status of several projects (with subprojects) to nonactive
On GUI it seems that the only way is clicking through the whole list. I’ve more than 100 project items to change > I need another way.
Fortunately I found the import function of EGW, where I could create a custom import as well only changing the important columns. Great idea from you!
the new import definition from DB:
import_def.csv (2.92 KB)
the test file was:
“Project ID”;“Access”;“Status”
“243”;“private”;“nonactive”
“242”;“private”;“nonactive”
“241”;“private”;“nonactive”
“240”;“private”;“nonactive”
“222”;“private”;“nonactive”
“223”;“private”;“nonactive”
“263”;“private”;“nonactive”
“239”;“private”;“nonactive”
“220”;“private”;“nonactive”
“262”;“private”;“nonactive”
“224”;“private”;“nonactive”
this was prepared from an export before.
and the problem: the dry run of the import shows the followings:
Projectid Access Status
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
335 private nonactive
the project ids are wrong
could you please help?
thanks in advance and br
Erikimport_def.csv (2.92 KB)