Share via

MS Project Resource Assignment Imports Are Not Working !!!! I've Done Them Tons of Times Before.

Anonymous
2019-07-12T20:10:33+00:00

So, I am venting and asking for help at the same time.  I have such a hard time importing resource assignments into MS Project sometimes.  I try different combinations.  I try formatting as text.  I try used Unique ID as the key.  I try using the Resource or Resource ID as the key.  Sometimes I do the EXACT same thing and it works one time whereas it didn't before.  Other times when I import it renames the whole file that I am merging into as the name of the file I am trying to import.  It is so @#%@#^% cludgy!  I hate it.  Any ideas?  The problem is that I get NO ERROR messages at all, so you are left wondering WTH is wrong because it looks fine on the previews screen.  One time it was too many decimal places in the hours.  It's all kinds of **** that you just don't knwo what the issue is.  I need to have some data uploaded by morning and I cannot get labor resources or cost resource assignments to load.  I even ripped out all of the old assignments, renamed them the same thing and tried to start from scratch.  Nothing.  NO errors, but no data either.

Unique ID Text1 Resource Name Cost
2664 13051 Material 225,000
2504 13162 Material 250,000
2816 13693 Material 675,000
3498 14600 Material 1,300,000
1997 85042 Material 100,000
2492 85046 Material 100,000
1763 12539 Material 20,000,000
1764 12540 Material 25,000,000
1765 12541 Material 25,000,000
1766 12542 Material 25,000,000
1767 12543 Material 21,000,000
1768 12544 Material 20,000,000
1769 12545 Material 10,000,000
1770 12546 Material 10,000,000
Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-13T21:54:32+00:00

    Thanks so much.  The data is private but there is a code pseudonym to the project and everything is so out of context that nothing will mean anything to anyone.

    Here is the suggested video link:

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-07-13T08:43:13+00:00

    Dear Eric S,

    Thanks for posting the thread on our forum.

    It seems that the data you uploaded above contains some private information. May I know whether it can be shared publicly. If yes, please add your comment. I’ll remove it after 24 hours to protect your privacy.

    Meanwhile, as you said that there are no error messages when importing the Excel file, to clarify the whole process of the issue, could you use PowerPoint 2016 to record a video showing the issue? If the video can’t be shared publicly, I’d like you to provide the video link in the private message for us to get it for troubleshooting. If it can be shared publicly, just provide the link here.

    For your reference: Record your screen in PowerPoint

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-07-13T02:40:25+00:00

    I also tried to delete all % Completes that may have been making the tasks appear inactive.  This a replanning exercise.  I may delete the actual/start finish info as well if I have to.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-07-12T20:42:00+00:00

    I am also using CSV format as that seems a little more reliable, but I am going to see if Excel format works next.  Here is a small sample of the labor upload.

    Text1 Unique ID Resource Name Resource ID Work
    10649 3830 5115424 9 200 hrs
    10650 3831 5115424 9 200 hrs
    10796 3939 5115081 3 8 hrs
    10802 3941 5115081 3 100 hrs
    10803 3942 5115081 3 2800 hrs
    10804 3943 5115081 3 220 hrs
    11020 2184 5115238 5 732.8 hrs
    11022 2185 5115238 5 549.6 hrs
    11024 2186 5115238 5 183.2 hrs
    11026 2187 5115238 5 183.2 hrs
    11028 2188 5115238 5 183.2 hrs
    11030 2189 5115238 5 458 hrs
    11032 2190 5115238 5 458 hrs
    11034 2191 5115238 5 458 hrs
    11036 2192 5115238 5 458 hrs
    11038 2193 5115238 5 183.2 hrs
    11040 2194 5115238 5 183.2 hrs
    11042 2195 5115238 5 366.4 hrs
    11044 2196 5115238 5 366.4 hrs
    11046 2197 5115238 5 183.2 hrs
    11048 2198 5115238 5 183.2 hrs
    11052 2200 5115238 5 183.2 hrs
    11054 2201 5115238 5 366.4 hrs
    11056 2202 5115238 5 183.2 hrs
    11057 2203 5115238 5 183.2 hrs
    11304 3837 5115424 9 250 hrs
    12008 3915 5130006 16 23.03 hrs

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-07-12T20:11:55+00:00

    The above is just a small portion of the data from just one of the uploads I am attempting.  I have thousands of lines to get in there - especially the labor piece.

    Was this answer helpful?

    0 comments