Home → Suggestions →

More on the subject of Gantt charts (Using Python API to import into MS Project)

Juan Carlos Gonzalez-Najera

11 Jul, 2009 07:45 PM via

Admin Functions

• Edit
• Remove

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

1. 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?

   http://t3x.shotrunner.com/projects.xml?conditions%5Blabel%5D=SAP
   

   If you are on Linux or Mac OS X, you can try curl:

   $ curl -u username/password http://t3x.shotrunner.com/projects.xml?conditions%5Blabel%5D=SAP
   

   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

   • 106_tasks_jcgn.py 2.5 KB

   Admin Functions

   • Edit
   • Remove

2. 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

   • page.jpg 146.4 KB

   Admin Functions

   • Edit
   • Split
   • Remove

3. 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

   Admin Functions

   • Edit
   • Remove

4. cameron resolved this discussion on 30 Jul, 2009 01:25 PM.

Comments are currently closed for this discussion. You can start a new one.