(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.
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:
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
Printer-friendly version
Send to friend
Hi Steven,
Brilliant, I'll pass your comments over to our DB administrator, thank you so much for that information.
Regards,
Rod
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
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.
Email: PPadmin@planningplanet.com
Replies