View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Import from MSproject - ProjeQtOr
 
 

Import from MSproject

More
25 Nov 2011 10:11 #1 by falou56
Hello Babynus and the team.

I tried to import a project from MSprojet (translate in cvs as well!!)
My problem was to keep the links beetween activities and dates(requested, validated ...).

The format you suggest (activity.csv) don't seems to be enought complete. I tried to import from Mysql, but there is many tables to modifie and I lost some links, for exemple beetween the activity table and the planningelement table.

Do you think there is a way to import a MSproject even translate in cvs without losing the links and dependency beetween tasks ?

Thank you & regards

Falou

Please Log in or Create an account to join the conversation.

More
25 Nov 2011 11:25 #2 by babynus
Replied by babynus on topic RE : Import from MSproject
It may be possible, but it's quite complex.
Unless an integrated solution is proposed, it will be a mess...

you must get from MS-Project :
- activities
- dependencies
- resources
- affectations
- assignments
- real work
... and retrieve links between these elements, using internal id that will, of course, be different from MS-Project ones.

I would not try such a work unless a have several quiet weeks in front of me and a lot of coffee. :)

Actually, I'm working on Export to MS-Project, what is much more easy than what you try, but I'm getting mad getting things clean in MS-Project...

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
25 Nov 2011 14:21 #3 by falou56
Replied by falou56 on topic RE : Import from MSproject
I don't know sufficiently the SQL request to write it.
by the way, my other problem is to know in witch SQL tables all the elements from MSproject must be save!!

To try to help you, if I send you a MSproject exemple with a few tasks, will you be able to identify the SQL tables were informations will be write ?
Then I will looking after my SQL books :):) ans as you take a strong coffee :D

Please Log in or Create an account to join the conversation.

More
25 Nov 2011 19:00 #4 by babynus
Replied by babynus on topic RE : Import from MSproject

by the way, my other problem is to know in witch SQL tables all the elements from MSproject must be save!!

Many !
at leat :
- activity
- planningelement
- user
- dependency
- assignment
- work
But if you insert manually with SQL, I am 99% sure you're database will be inconsistent and won't be working anymore.
(I've been working for more than 2 years to define all the persistence framework and objects to maintain consistancy)

if I send you a MSproject exemple with a few tasks, will you be able to identify the SQL tables were informations will be write ?

No. I know MS-Porject XML format. It's a mess and there is not direct relation with Project'Or tables.

and as you take a strong coffee

Coffee will no be enough. You can order some cokaine right now !

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.031 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.