Project Management - import resources

[duncane]

I have a load of defined resources in MS Project and I would like to import them into EA rather than type them all in again, even better I would like to share the MS Project Resources as I do in MS Project. Is there any way of doing this now or planned?

[fwoolz]

Lessee...

If you set up an MS Project export template to match the EA XML data format (I haven't tried this myself UPDATED!!!! I tried it, but I think the best you can do is HTML, turn it into XHTML, then --> XSLT), you should be able to import the XML file directly.  Here's the EA XML info:

The EA XML schema for resources is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<!--W3C Schema generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
     <xs:complexType name="ColumnType">
           <xs:attribute name="name" use="required">
                 <xs:simpleType>
                       <xs:restriction base="xs:NMTOKEN">
                             <xs:enumeration value="Email"/>
                             <xs:enumeration value="Fax"/>
                             <xs:enumeration value="Mobile"/>
                             <xs:enumeration value="Name"/>
                             <xs:enumeration value="Notes"/>
                             <xs:enumeration value="Organisation"/>
                             <xs:enumeration value="Phone1"/>
                             <xs:enumeration value="Phone2"/>
                             <xs:enumeration value="Roles"/>
                       </xs:restriction>
                 </xs:simpleType>
           </xs:attribute>
           <xs:attribute name="value" type="xs:string" use="required"/>
     </xs:complexType>
     <xs:complexType name="DataRowType">
           <xs:sequence>
                 <xs:element name="Column" type="ColumnType" maxOccurs="unbounded"/>
           </xs:sequence>
     </xs:complexType>
     <xs:complexType name="DataSetType">
           <xs:sequence>
                 <xs:element name="DataRow" type="DataRowType" maxOccurs="unbounded"/>
           </xs:sequence>
           <xs:attribute name="name" type="xs:string" use="required"/>
           <xs:attribute name="table" type="xs:string" use="required"/>
           <xs:attribute name="filter" type="xs:string" use="required"/>
     </xs:complexType>
     <xs:element name="RefData">
           <xs:complexType>
                 <xs:sequence>
                       <xs:element name="DataSet" type="DataSetType"/>
                 </xs:sequence>
                 <xs:attribute name="version" type="xs:decimal" use="required"/>
                 <xs:attribute name="exporter" type="xs:string" use="required"/>
           </xs:complexType>
     </xs:element>
</xs:schema>

Here's an example EA XML file produced by exporting resources...

<?xml version="1.0" encoding="windows-1252"?>
<RefData version="1.0" exporter="EA.25" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:\Projects\UML\EA\resources.xsd">
     <DataSet name="Project Resources" table="t_resources" filter="Name='#Name#'">
           <DataRow>
                 <Column name="Name" value="Enna Jettick"/>
                 <Column name="Organisation" value="Development"/>
                 <Column name="Phone1" value="+1 (987) 555-1234"/>
                 <Column name="Phone2" value="+1 (987) 555-4321"/>
                 <Column name="Mobile" value="+1 (876) 555-0143"/>
                 <Column name="Fax" value="+1 (987) 555-6754"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Engineer"/>
                 <Column name="Notes" value="C++ specialist; also has expertise in RUP."/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Yoors Truley"/>
                 <Column name="Organisation" value="Development"/>
                 <Column name="Phone1" value="+1 (987) 555-1231"/>
                 <Column name="Phone2" value="+1 (987) 555-7834"/>
                 <Column name="Mobile" value="+1 (876) 555-9875"/>
                 <Column name="Fax" value="+1 (987) 555-6754"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Project Manager"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Ben Dare"/>
                 <Column name="Organisation" value="Development"/>
                 <Column name="Phone1" value="+1 (987) 555-1235"/>
                 <Column name="Phone2" value="+1 (987) 555-9982"/>
                 <Column name="Mobile" value="+1 (876) 555-0094"/>
                 <Column name="Fax" value="+1 (987) 555-6754"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Engineer"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Anna Liser"/>
                 <Column name="Organisation" value="Development"/>
                 <Column name="Phone1" value="+1 (987) 555-1236"/>
                 <Column name="Phone2" value="+1 (987) 555-6753"/>
                 <Column name="Mobile" value="+1 (876) 555-0193"/>
                 <Column name="Fax" value="+1 (987) 555-6754"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Engineer"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Hugh Broquette"/>
                 <Column name="Organisation" value="Development"/>
                 <Column name="Phone1" value="+1 (987) 555-1237"/>
                 <Column name="Phone2" value="+1 (987) 555-8734"/>
                 <Column name="Mobile" value="+1 (876) 555-0199"/>
                 <Column name="Fax" value="+1 (987) 555-6755"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Test Engineer"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Ophelia Payne"/>
                 <Column name="Organisation" value="Quality Assurance"/>
                 <Column name="Phone1" value="+1 (987) 555-1245"/>
                 <Column name="Phone2" value="+1 (987) 555-4777"/>
                 <Column name="Mobile" value="+1 (876) 555-0122"/>
                 <Column name="Fax" value="+1 (987) 555-6756"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Quality Assurance Engineer"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Allin Awder"/>
                 <Column name="Organisation" value="Quality Assurance"/>
                 <Column name="Phone1" value="+1 (987) 555-1246"/>
                 <Column name="Phone2" value="+1 (987) 555-4321"/>
                 <Column name="Mobile" value="+1 (876) 555-0143"/>
                 <Column name="Fax" value="+1 (987) 555-6756"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Configuration Manager"/>
           </DataRow>
           <DataRow>
                 <Column name="Name" value="Phil De Blanc"/>
                 <Column name="Organisation" value="Contracts"/>
                 <Column name="Phone1" value="+1 (987) 555-1264"/>
                 <Column name="Phone2" value="+1 (987) 555-9451"/>
                 <Column name="Mobile" value="+1 (876) 555-0111"/>
                 <Column name="Fax" value="+1 (987) 555-6757"/>
                 <Column name="Email" value="[email protected]"/>
                 <Column name="Roles" value="Software Engineer"/>
           </DataRow>
     </DataSet>
</RefData>

[duncane]

Thanks, at least I know its possible! I will get one of my developers to give it a go! Bit beyond me these days :-).

I am looking at using a lot of the features of EA professional throughout my development process especially the testing features.