Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi,
I'm having some trouble with the "import data" functionality.
In order to update several fields in my Activities list, I did an export to CSV of my project's activites, did my updates in Excel, and then imported the modified activities.
My problem is I have the following project structure:
>MyProject trunk
>>SubProj1
>>>Support Project
>>>>Activities...
>>>Development Project
>>SubProj2
>>>Support Project
>>>>Activities...
So if I export my project's activities, it looks like this:
| id | project | name |
| 1 | Support | Activitiy_name |
| 2 | Support | other_activity |
Problem is, when I import the CSV file, the tool does not know whether the "Support" project is the one in SubProj1 or in SubProj2...
I think it always takes the first project ID where name = "Support", so I find myself with some activities which have been moved to a different subproject - which is not what I expected ! 😳
As a quick fix, I was thinking maybe when we export to CSV, fields such as "idProject", "idActivity" (parent activity) could be exported as "1234-Name" (concatenation of ID & name, to ensure uniqueness).
Any thoughts ? I would definitely be interested in a quick patch... :blush:
If it can help I'll have a developer take a look, see if it's feasible - so if you have any suggestions, more than welcome !
Thanks in advance, and sorry for the huge post.
Hi,
If exported as ID+NAME, import will fail everytime.
What is possible is to select to export references as ID or NAME.
Ticket #1280 recorded
Of, course no good to change export by itself, since import will be lost... :pinch: