From: Hüber E. <hu...@ka...> - 2015-06-18 21:07:30
|
Dear Ralf,I was trying to update the status of several projects (with subprojects) to nonactiveOn 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 <http://egroupware.219119.n3.nabble.com/file/n4007834/import_def.csv> 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 Status335 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 wrongcould you please help?thanks in advance and brErik -- View this message in context: http://egroupware.219119.n3.nabble.com/custom-import-for-project-manager-test-fails-tp4007834.html Sent from the egroupware-users mailing list archive at Nabble.com. |
From: Hüber E. <hu...@ka...> - 2015-06-18 21:02:31
|
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 <http://egroupware.219119.n3.nabble.com/file/n4007835/import_def.csv> 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 Erik import_def.csv <http://egroupware.219119.n3.nabble.com/file/n4007835/import_def.csv> -- View this message in context: http://egroupware.219119.n3.nabble.com/custom-import-for-project-manager-test-fails-tp4007834p4007835.html Sent from the egroupware-users mailing list archive at Nabble.com. |
From: Hüber E. <hu...@ka...> - 2015-06-20 12:11:41
|
maybe with the xml definition it is easier to analyse... thanks in advance Erik importexport_definition.xml <http://egroupware.219119.n3.nabble.com/file/n4007848/importexport_definition.xml> -- View this message in context: http://egroupware.219119.n3.nabble.com/custom-import-for-project-manager-test-fails-tp4007834p4007848.html Sent from the egroupware-users mailing list archive at Nabble.com. |
From: Hüber E. <hu...@ka...> - 2015-06-20 14:27:24
|
it is not important anymore: I could manage it via GUI at project list > right click > Modify status > non active tnx -- View this message in context: http://egroupware.219119.n3.nabble.com/custom-import-for-project-manager-test-fails-tp4007834p4007849.html Sent from the egroupware-users mailing list archive at Nabble.com. |