(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.
Hi All,
I have created some Activity Codes to be assigned for accounting purposes. The first stage was easy as there were only 8 groups and maybe 5 or 6 codes within each group.
Sample: Code Value Description
2 Tailings/BPF Area 2.1 C-12394-01-02-05-07 2.2 C-12394-01-02-05-06 2.3 C-12394-01-02-04-04 2.4 C-12394-01-02-05-07 2.5 C-12394-01-02-05-07 2.6 C-12394-01-02-06-03 2.7 C-12394-01-02-04-06 but now the request is to expand the listing and groupings to an additional level as below:| 2 | 2 | Tailings/BPF Area | ||||
| 2.1 | C-12394-01-02-05-06 | 2.1 | Bulk Earthworks BPF area | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.1 | Bulk excavation of BPF pad & roads areas to subgrade - spoil to material to Water treatment plant area (Subject to remeasure against actual) | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.2 | Excavate and trim Drain A | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.3 | Excavate and trim Drain B | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.4 | Supply, Place, Compact and trim pavement to BPF Pad & roads | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.5 | Supply & Installation of culverts & head walls to Drain A & B | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.6 | Supply, place geofabrics & rock works to Drain A & Drain B outlets | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.7 | Supply and installation drain A Gabion wall | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.8 | Form road side safety bunds | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.9 | Excavate, form and pour concrete spoon drain | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.10 | Drainage bund at CV1097 | |||
| 2.1 | C-12394-01-02-05-06 | 2.1.11 | Supply and Installation of conduit services (Subject to remeasure against actual) | |||
How can I upload the codes spreadsheet?
Thanks,
Rod
Printer-friendly version
Send to friend
yes this can do a whole lot such as creating WBS, activity code dictionary, adding resources , printing calendars etc
hi Zoltan, excellent!this tool answers some of my other questions as well.
Much appreciated.
Rod
sdk is no longer supported I use Ranga whihc is an excel add in you can build activity code dictionaries as well was a wbs
Hi Rodel,
Yes, I was thinking about SDK last night. I have created an odbc to my dB but haven't yet explored the connection any further than running some basic queries.
Xer parser has been difficult to run, I think I had to go back to excel v10 or something but I do have the codes already in Excel.
Excellent ideas, thanks mate, I'll let you know how I go.
There are two options that you can use.
1) Option 1 - Using SDK (excel) - you can import/ upload Global, EPS or Project if you have SDK setup on your machine.
2) Option 2 - Using XER Builder/ parser - You need to have a deep knowledge on P6 database to do this. You can build your Activity codes library Global, EPS or Project by creating XER with Activity Codes library
are the pics displaying? They are showing when I select Edit but not when posted. ???
Sorry, here are screen shots:
and
the text is the related activity name
Email: PPadmin@planningplanet.com
Replies