Excel to Proj Mapping -> Can't get col of data to map to Proj - Why?

%3CLINGO-SUB%20id%3D%22lingo-sub-2650420%22%20slang%3D%22en-US%22%3EExcel%20to%20Proj%20Mapping%20-%26gt%3B%20Can't%20get%20col%20of%20data%20to%20map%20to%20Proj%20-%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650420%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EThis%20should%20be%20intuitively%20easy%2C%20but%20I%20think%20there%20is%20something%20fundamentally%20incorrect%20about%20my%20understanding%20of%20MS%20Proj%20mapping.%26nbsp%3B%20%3CU%3E%3CSTRONG%3ESee%20images%20in%20doc%20attached%20to%20help%20with%20explaining%20my%20problem.%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20able%20to%20successfully%20map%20a%20small%20test%20file%20with%20several%20columns%20of%20data.%26nbsp%3B%20However%2C%20I%20can't%20get%20Assignment_Owner%20in%20excel%20to%20map%20successfully%20show%20information%20using%20the%20Assignment_Owner%20option%20in%20the%20field%20selection%20for%20MS%20Proj.%26nbsp%3B%20Why%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20changed%20the%20Excel%20field%20name%20to%20be%20exactly%20the%20same%20as%20the%20MS%20Proj%20field%20name%2C%20but%20can't%20get%20the%20data%20in%20there.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20I%20noticed%20that%20for%20another%20column%20of%20info%2C%20I%20had%20to%20hunt%20and%20peck%20to%20find%20the%20correct%20Mapping%20field%20name%20that%20would%20pull%20in%20my%20column%20labeled%20'Task%20Name'.%26nbsp%3B%20It%20ended%20up%20being%20'Name'.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20why%20on%20earth%20should%20it%20matter%20because%20as%20I%20expected%20this%20to%20work%20is%20that%20anything%20that%20has%20a%20text%20type%20should%20be%20able%20to%20pull%20in%20a%20column%20with%20text%20information%20in%20it%3F%26nbsp%3B%20That%20doesn't%20seem%20to%20happen.%26nbsp%3B%20Also%2C%20I%20tried%20using%20simply%20'Text1'%20as%20a%20mapping%20label%20and%20then%20rename%20it%20later%2C%20but%20that%20didn't%20work%20either.%26nbsp%3B%20What%20is%20the%20decoder%20ring%20for%20the%20field%20names%20for%20Mapping%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20missing%3F%26nbsp%3B%20I%20have%20not%20been%20able%20to%20find%20a%20resource%20telling%20me%20specifically%20what%20restrictions%20there%20are%20when%20mapping%20data.%26nbsp%3B%20If%20there%20is%20a%20resource%20or%20link%20I%20would%20be%20really%20appreciative.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650490%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20to%20Proj%20Mapping%20-%26amp%3Bgt%3B%20Can't%20get%20col%20of%20data%20to%20map%20to%20Proj%20-%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650490%22%20slang%3D%22en-US%22%3Eex.%20is%20meant%20%22orf%22%20and%20is%20only%20available%20in%20read%20only%20and%20is%20too%20a%20project%20requirement%20to%20be%20resident%20of%20the%20location%20not%20where%20it%20is%20rehabilitation%20respectfully.%20Because%20you%20are%20%22col%22%20it%20is%20invalid%20.0%20%26amp%3B%20Final.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650492%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20to%20Proj%20Mapping%20-%26amp%3Bgt%3B%20Can't%20get%20col%20of%20data%20to%20map%20to%20Proj%20-%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1071536%22%20target%3D%22_blank%22%3E%40ex-gs-workstudy-425-1-435%3C%2FA%3E%26nbsp%3BI%20am%20sorry.%26nbsp%3B%20I%20didn't%20understand%20most%20of%20that.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20challenge%20is%20what%20drop%20down%20map%20categories%20are%20text%20types%2C%20and%20also%20(forgot%20to%20mention%20this)%20why%20does%20the%20Preview%20in%20Import%20Wizard%20not%20show%20actual%20results%20in%20the%20Project.%26nbsp%3B%20Preview%20seems%20kind%20of%20useless.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

This should be intuitively easy, but I think there is something fundamentally incorrect about my understanding of MS Proj mapping.  See images in doc attached to help with explaining my problem.

 

I am able to successfully map a small test file with several columns of data.  However, I can't get Assignment_Owner in excel to map successfully show information using the Assignment_Owner option in the field selection for MS Proj.  Why?

I changed the Excel field name to be exactly the same as the MS Proj field name, but can't get the data in there. 

 

Also I noticed that for another column of info, I had to hunt and peck to find the correct Mapping field name that would pull in my column labeled 'Task Name'.  It ended up being 'Name'.  

 

Now why on earth should it matter because as I expected this to work is that anything that has a text type should be able to pull in a column with text information in it?  That doesn't seem to happen.  Also, I tried using simply 'Text1' as a mapping label and then rename it later, but that didn't work either.  What is the decoder ring for the field names for Mapping?

 

What am I missing?  I have not been able to find a resource telling me specifically what restrictions there are when mapping data.  If there is a resource or link I would be really appreciative.

 

 

9 Replies
ex. is meant "orf" and is only available in read only and is too a project requirement to be resident of the location not where it is rehabilitation respectfully. Because you are "col" it is invalid .0 & Final.

@ex-gs-workstudy-425-1-435 I am sorry.  I didn't understand most of that.  

 

My challenge is what drop down map categories are text types, and also (forgot to mention this) why does the Preview in Import Wizard not show actual results in the Project.  Preview seems kind of useless.

In text because the person does not know how to configure it correctly.
How do I 'configure correctly' the text? Is there a document that shows how to do that or tutorial? Thanks.
Also define useless. Are you suggesting a task to be listed under taskkill because this operation is not available to even the senior level and is not looked upon for the internet of things in the best practices. I would advise you to insure that the security of the text is first not already in its end-user point because the application driving and pushing this text can only be advising your profession that it is in violation for retrieving it.
Don't even know what 'taskkill' is. Question is also not about 'internet of things' best practices.

I simply want to import excel to MS Project and the categories don't work except for a few which I have listed in my original post along with pictures in the document. The preview shows that the category I chose pulls in the correct information but when I hit 'Finish', no data.

@bborman120,

Your first mistake was assuming it would be "intuitively easy", nothing about importing data from Excel to Project using an import map is intuitive or easy.

 

To answer your first question, are you using Project Online or Project Web App? If not (i.e. you are using a stand alone version of Project), then the Assignment Owner field is not available.

 

The main reason it is challenging to import Excel data into Project is that Excel is an "open-format" spreadsheet. In Excel cell data can be whatever you want it to be whereas in Project, fields are very strictly defined and there are separate and independent fields with the same name that are properties of tasks, resources, and assignments (e.g. task Text1 is not the same as Resource Text1 or Assignment Text1). This means that even though you can represent several pieces of information about a task on a single row or column in Excel, you may need to break that data into multiple field maps for Project (i.e. task data, resource data and assignment data).

 

Also be aware that the Predecessor field in Project is directly dependent on how the dependencies between tasks is set up and will normally not follow the row number that task occupies on the Excel spreadsheet.

 

I'm sure there are articles written about using import maps but I don't have any ready reference. I find the most reliable way to get data from Excel to Project (and vice versa) is through VBA.

 

John

@John-project 

 

Thank you.  It is as I suspected; strict compliance within Project and different fields have different types.  I appreciate the info.  Will keep futzing with it.  Take care.

Oh I love it when users talk technical (i.e. "futzing") :)

You're welcome and thanks for the feedback.
John