Missing data after importing a project from excel

[Project Server Slave]

Hello,

I'm attempting to import a project plan from an excel 2003 file into
Project Pro 2007. We import just fine, but then when we attempt to
import the same excel 2003 project plan file with updated data in it,
we choose to merge the data instead of apphend. This is where the
problem occurs.

We are merging 2 text fields that track start and finish dates and
mapping them to a custom field for Start 1, and Finish 1. We've also
tried mapping them to text fields.

The data imports fine for about 1900ish rows, but then just stops,
leaving the rest of the fields with N/A. The last 400 or 500 are
spotty, with some having data and some not. All of the fields have
data in this column, it just doesnt seem to be pulling it over. The
formatting of the dates is the same.

The total project is about 25,000 rows long. Is this perhaps an issue
with the size of the project? If so, is there a way around it? We have
data coming from a different system that needs to be merged into this
project plan regularily, and this seems to be the best way, if it
would work.

 

[Rob Schneider]

Hello,

I'm attempting to import a project plan from an excel 2003 file into
Project Pro 2007. We import just fine, but then when we attempt to
import the same excel 2003 project plan file with updated data in it,
we choose to merge the data instead of apphend. This is where the
problem occurs.

We are merging 2 text fields that track start and finish dates and
mapping them to a custom field for Start 1, and Finish 1. We've also
tried mapping them to text fields.

The data imports fine for about 1900ish rows, but then just stops,
leaving the rest of the fields with N/A. The last 400 or 500 are
spotty, with some having data and some not. All of the fields have
data in this column, it just doesnt seem to be pulling it over. The
formatting of the dates is the same.

The total project is about 25,000 rows long. Is this perhaps an issue
with the size of the project? If so, is there a way around it? We have
data coming from a different system that needs to be merged into this
project plan regularily, and this seems to be the best way, if it
would work.

Two quick thoughts:

1. have you looked at the input data at about row 1900 to see if there
are any anomolies? A change in pattern? Extra characters? Something?
What's special about that region in the data.

2. 25,000 is well below the spec for max number of records.

 

[Project Server Slave]

Two quick thoughts:

1. have you looked at the input data at about row 1900 to see if there
are any anomolies?  A change in pattern? Extra characters?  Something?
What's special about that region in the data.

2. 25,000 is well below the spec for max number of records.- Hide quoted text -

- Show quoted text -

Thanks for the reply Rob. The thing is, it doesnt entirely stop at
1900, its around there. A lot of the tasks have data in this column,
but then around 1900, some have it and some dont. It's not as if all
the tasks have data until the 1900th row, some do and some dont. We
cant really see anything that is different about the ones that dont
and then around the 1900th row, they just dont have any data at all.
This is a critical process towards the success of the overall
implementation, so we really need some help. Any other ideas?

 

[Rob Schneider]

Thanks for the reply Rob. The thing is, it doesnt entirely stop at
1900, its around there. A lot of the tasks have data in this column,
but then around 1900, some have it and some dont. It's not as if all
the tasks have data until the 1900th row, some do and some dont. We
cant really see anything that is different about the ones that dont
and then around the 1900th row, they just dont have any data at all.
This is a critical process towards the success of the overall
implementation, so we really need some help. Any other ideas?

Sorry. Out of ideas. Computers tend not to be random. Your desription
tends to suggest randomness. Dunno. Sorry.