More on the subject of Gantt charts (Using Python API to import into MS Project)
Juan Carlos Gonzalez-Najera
via
I just finished entering an entire project and I have sequences, shots, tasks, etc. I was about to start adding deadlines but I got stuck, because the only way I can think of doing this is by going to each task and entering. This in itself would be tedious, but it is more complicated than that.
I know that implementation of a full Gantt may not be in the plans. However, I would love to have at least a Print function so that I could see all my tasks at the same time, in the context of their respective elements, shots., etc. If this view where more interactive where I could add dates directly there, that would be fantastic.
Juan Carlos
Showing the most recent page of comments. View the first page
Comments are currently closed for this discussion. You can start a new one.
Support Staff 32 Posted by cameron on 30 Jul, 2009 05:47 AM
Juan Carlos,
The error you are getting suggests that you are having some kind of network issue. I'm not seeing that from here and its going to be hard for me to debug that part. When you put that URL into your browser, what do you see?
If you are on Linux or Mac OS X, you can try curl:
Now, beyond that we had a couple more issues.
1) Some of the tasks in your project do not have users assigned, so I had to modify the script to account for that.
2) There is one place in the data where someone entered a Unicode character, and the CSV python library does not support Unicode, so I had to go through and escape any Unicode strings.
The revised script is attached.
Cheers,
Cameron
33 Posted by Juan Carlos Gonzalez-Najera on 30 Jul, 2009 11:40 AM
Cameron,
Following the URL, I see a login screen and then a web page (screen shots attached).
However, I tried the new script, and it works! I got all my tasks into Project with barely a hitch. Project uses import templates to link CSV files to its internal database. I need to tweak the template to match the CSV file, and when I'll see if these templates can be exported. If they can, I'll send it to you so that other Project users can download the template and start using the script.
Juan Carlos
Support Staff 34 Posted by cameron on 30 Jul, 2009 01:25 PM
Juan Carlos,
Excelllent news! I'm curious to see what that gives you in MS Project.
Cheers,
Cameron
cameron closed this discussion on 30 Jul, 2009 01:25 PM.