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.
Hello,
We are trying to enter some of our completed projects for archiving and client tracking purpose.
We would like to take a shortcut by importing the data in bulk from our Excel timesheets, into a project structure and pre-defined WBS.
-Tasks
- Assigned ressources
- Actual work done by calander days.
Can you suggest a simple method, or do we need to do all the steps manually like a regular project?
Thanks!
Martin
This cannot be done simple through csv import as :
- you need to import one kind of ojects at a time (projects, then activities, then assignement)
- you need to make relations yourself (put id of activity when storing assignment, ...)
- you cannot import WBS relationship easily
Best way to import full project is to import from MS-Project XML format (thanks to our dedicated plugin)
Thanks for the reply,
I tried importing MS Projects and got import errors,
Same thing with importing Activities.
After reading the forum, I suspect those two problems are related to either character encoding UTF-8, or an incompatibility problem with our installation of ProjeQtor in french?
So far, the only successful import I had, was an activity exported from PorjeQtor and then directly reimported.
As soon as I make change to the CSV file, the import generates errors.
I solved my ACTIVITY import problem that was caused by LibreOffice replacing ";" by "," in csv files.
Now I will test the MS Project and Project Libre Import. It might have had teh same kind of problem.