Importing data

[jobu9999]

I want to create a column in the project plan window called "WO". I
downloaded a list of WOs from our CMMS to Excel. I then created a column and
named it WO. I then tried to use the import wizard to populate the field so
I could access WO numbers from a drop down. I'm having NO LUCK. I've
searched help extensively and can find no specific direction on what I'm
doing wrong. Can anyone please point this lost soul down the path of
righteousness?

Thanks

 

[Jim Aksel]

I am making an assumption that the import wizard at least populated the WO
column for you coming in from Excel abd that you used a Text column (ie:
Text2, Text18, etc) for the data. If that didn't work, I suggest the
copy/paste method as long as there is a one for one match on the rows and
your WO data in Excel is known and good.

What I have done is make an assumption that the data in the Excel columns is
perfect. That is, you have verified that each WO in Excel is corect with no
typo's etc. The reason to do that is to avoid data inconsistencies when the
drop down is created separately.

To create the dropdown selection list, rigth click on the WO column (Text1)
and select Custmize Fields. Select Value List. The list can be populated and
you may restrict selection to members of the list, or, allow new list entries
via the check boxes at the bottom of the dialog box.

As long as you enter all the values on your WO column, you will not lose any
data. You should do a sanity check when complete.

If you need additional information, please post back.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[jobu9999]

I didn't explain myself well. I'm trying to create a list with hundreds of
WO numbers in it. I want to populate the list from a spreadsheet. When I
enter a task, I want to be able to select a WO number using a drop down. If
I undertand what you told me, it looks like I'm going to have to manually
enter each WO number?
Thanks

 

[Jim Aksel]

Not exactly, my answer assumed you were importing task data from Excel into
Project along with dates, task names, etc. I assumed that those had a WO.

What is in the Excel file, a single column of unique WOs?

 

[jobu9999]

Yes, a single column of unique WOs.

Thanks

 

[Jim Aksel]

I beleive there is an import values, but it only applies to Projects. You
probably need to have that column of numbers in the Text1 column of a
Project1.mpp file and then have that open at the same time as YourFile.mpp.

Try right clicking on the colum you want to make as the drop down, select
Customize Fields, Value LIst. Is there an Import routine there?
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[JulieS]

Hi Jim and Jobu,

Pardon me for bumping in. Sadly the Import List button only allows you
to import a *value list* already established in another project file.
(I remembered the import list button and tried importing a straight list
from another project's text1 field -- no joy).

It may be possible to populate the list through a macro. If have some
VBA skills and need assistance, I suggest posting your questions to the
Project Developer newsgroup.

Short of VBA, I think it may be a typing chore.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[jobu9999]

I tried what Jim suggested - you're right - no joy. I posted the ? to the
developer board. I'll let you know what's said. Thanks for the help.

 

[JulieS]

You're welcome. Sorry I didn't have better news.
Julie
Project MVP

 

[Jim Aksel]

I tried it too.... no luck. I may have a macro to do it... I'll check on the
Developer side.

Jim
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project