Importing Activity Codes
In the Open Standard
Ken BarrettMember for 19 years 5 months
- Created
- 1
- 3
0
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
Ken
1 reply
Oldest first- 0Andrew Dick ·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
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?