TomGill - Sunday, February 7, 2010 6:43 PM:
I just finished a project configuring the MSProject import/export community solution, and made a couple of changes that I thought others might be interested in.
1. I used the utility to export a few projects from one database, and import into another. The import received a string to long error. It turns out that the issues is with the msproject export function. To fix:
Administration->SQLs.
Edit "select_project_list2".
In line 3, change "name char(" to "name varchar("
Save, Unlock exit.
Thanks to Jon Hodge for helping me on this one.
2. I had several properties on the Project itemtype that were required. The MSproject import needs to save during the import, and since the required properties were not input, the import failed. There are 2 ways to fix, either remove the required check on the property in the itemtype, or modify the import method. To modfiy the import method;
Administration -> methods
Edit ImportMSProject
Duplicate line 195 for as many properties as you have required
195 iProject.setProperty("project_update_mode","1");
Change "project_update_mode" to the name of your required property and change "1" to a value.;
If you want to get a bit more creative, you pull the properties from other fields within the project file.
Tom
