XML Import into Access 2007

[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 XMLfile 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

 

[Michael Gramelspacher]

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 XMLfile 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

With the disclaimer that I know little to nothing about the subject, are the missing fields
attribtes or elements. If they are attributes, I do not think Access will import them.

 

[BradE]

With the disclaimer that I know little to nothing about the subject, are the missing fields
attribtes or elements.  If they are attributes, I do not think Access will import them.  - Hide quoted text -

- Show quoted text -

That seems to be the problem (ah, the Access "feature"). I'll have to
create some XSLT to map the attributes so they can be loaded.
Thanks for the clue!

..... Brad