B
BradE
I have created an XML file from Project 2007. It appears to contain
all of the User Defined Fields I have used in the project. Then I
created a new Access 2007 database and imported the XML file. All 12
of the Access tables appear to have been created and populated
correctly. However, I cannot find any of the User Defined Fields from
the Project file in the Access file.
For example, I have "Text 1" populated with "xyz" and "Number 1"
populated with "1234". They appear in the XML file in the appropriate
tags. However, I cannot find either of those values in any of the 12
tables created during the import. The ExtendedAttribute table
contains the Field Names from the <Project><ExtendedAttributes>
section in the XML file. The XML file has the "xyz" and "1234" values
in the <Task><ExtendedAttributes> section, but they do not appear in
any table that I can find in Access.
Is this a problem with the Access XML import? Or is there some
mapping function that I have to perform and if so, where do I do it
and how do I get to it (I tried to investigate mapping but could not
find it in either Project or Access). In my case, I always want the
full Project file with all fields on all tasks, resources and
assignments (i.e., no filtering).
Configuration: XP SP3, Project 2007 SP1, Access 2007 SP1.
Many thanks! .... Brad
all of the User Defined Fields I have used in the project. Then I
created a new Access 2007 database and imported the XML file. All 12
of the Access tables appear to have been created and populated
correctly. However, I cannot find any of the User Defined Fields from
the Project file in the Access file.
For example, I have "Text 1" populated with "xyz" and "Number 1"
populated with "1234". They appear in the XML file in the appropriate
tags. However, I cannot find either of those values in any of the 12
tables created during the import. The ExtendedAttribute table
contains the Field Names from the <Project><ExtendedAttributes>
section in the XML file. The XML file has the "xyz" and "1234" values
in the <Task><ExtendedAttributes> section, but they do not appear in
any table that I can find in Access.
Is this a problem with the Access XML import? Or is there some
mapping function that I have to perform and if so, where do I do it
and how do I get to it (I tried to investigate mapping but could not
find it in either Project or Access). In my case, I always want the
full Project file with all fields on all tasks, resources and
assignments (i.e., no filtering).
Configuration: XP SP3, Project 2007 SP1, Access 2007 SP1.
Many thanks! .... Brad