Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Importing Activity Codes

1 reply [Last post]
Thu, 2008-01-31 10:01
Ken Barrett
User offline. Last seen 13 years 32 weeks ago. Offline
Joined: 14 May 2007
Posts: 37
Groups: Petro-Chem / Oil & Gas
Is it possible to populate a global activity code library by importing from a spreadsheet. I have about 800 notification numbers to manually type into the global activity code library, and each has a description of a work order number... at the rate im going its going to take me days, and manual input of 7 diget numbers is screaming for errors. I have everything on a spreadsheet and if i could just import it it would save me pain-staking hours. Thanks in advance

Ken
Top

Replies

Thu, 2008-01-31 15:46
#1
Andrew Dick
User offline. Last seen 8 years 51 weeks ago. Offline
Joined: 14 Feb 2007
Posts: 295
Groups: Regional Representatives, The GrapeVine
Ken,
Lets first of all presume that your using P5.
That being the case if you create the headers for your codes in a project and then export this to excel, ensuring you select all of the appropriate fields/columns.
You should then be able to populate the excel sheet with a sufficient amount of activities and code them with your codes, and re-import that data.

Also if you are using P5 had you thought about keeping the code at an EPS level instead of a global level - just may save on some clutter for your other users??

Hope this helps
Andy
Top