P6 Project Notebook creation date?
- Created
- 4
- 4
Hello All,
I am using the Project level Notebook feature to record Monthly Progress Statements which are then exported in a csv file for use in other reporting systems.
My challenge is:
- How can the Notebook entry "creation date" be found in the backend workings of the Oracle database and included in the export?
This month I will want all the newly created entries, next month all the newly created entries for that timeperiod and so on, month by month I want to capture the latest dated Notebook entry per category.
Without having to manually type the date in the Comments text window.
Thanks,
Rod
4 replies
Oldest first- 0Santosh Bhat ·
Hi Rodney, Assuming you're
Hi Rodney, Assuming you're tapping directly into the database tables? I'm no expert in this, but I did look inot the P6 database schema, and there is a table called "WBSMEMO" that conaints the EPS/PROJECT/WBS level notebook topics. The columns within this table are:
Columns Key Name Type Description Default PK wbs_memo_id integer Unique ID FK proj_id integer FK to PROJECT table - identifies the project FK wbs_id integer FK to PROJWBS table - identifies the WBS FK memo_type_id integer FK to MEMOTYPE table - identifies the notebook topic wbs_memo blob Notebook contents stored as text string update_date date Refresh audit field of last date updated. Trigger maintained. update_user string(255) Refresh audit field of last user updated. Trigger maintained. create_date date Refresh audit field for date record created. Trigger maintained. create_user string(255) Refresh audit field for user that created the record. Trigger maintained. delete_session_id integer Deleted by session id. Client maintained. delete_date date Deleted date. Client maintained.
So if you can read the update_date and create_date fields, you should be able to achieve what you're looking for.
- 0Steven Auld ·
Rod,Santosh has identified
Rod,
Santosh has identified the correct table in the database for the Project Notebooks.
One thing I thought worth mentioning is that these notebooks are not separate data entries in the database for each update.
Notebooks are stored as an HTML file that is updated each time the Notebook is updated, so checking against the update_date field would identify which notebook has been updated, but when you extract the information it will be a single text block in HTML format, so the other reporting format would need to be able to get the data from this HTML File.
To get a new instance per update period, you would need to create a new Notebook Topic for each reporting period then update that to get individual period update data. This would likely not help what you are trying to achieve, as it would be harder to identify the corrent memo type to export each month.
The "DISCUSSION" table does store information in text format with a timestamp & the name of the user that made the comment, however there does not appear to be a way to delete these comments from within the Primavera application itself & would have to be deleted at the database level if you wanted to remove them. Unfortunately this field is at the activity level & not available for Project level.
Regards,
Steven
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?