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 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
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...
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 😀
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 !