Skip to content
ProjectControls.com
Oracle Primavera - PM6

import xls into notebook entry

In the Open Standard
Johnny PainMember for 21 years
Created
6
3
0
hi all,

I have a small problem here.
a colleague of mine is currently building a "database" of activities in a client-based program. these activities are going to be imported into P6 at some point, but before we can do this, I have to try things out to see if it works.
my problem is that I can’t seem to find how to import the comments he wrote into the notebook field in P6.
I tried to export a project w/comments just to see what field it was in, and it seems that even when exporting, the notebook data isn’t available.

does someone have an idea ?
I already tried the forum search function, but didn’t find what I was looking for.


thanks for your time,

djo
Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Dieter Wambach ·
    #1
    Johnny

    as many notebook items can ce attached to one activity, it is a list and would require one more group. Not available, so you can’t export or import notebook items.

    If it’s only text to import, you can define a user defined field of the type "text" which can contain about 250 (256?)characters. If not sufficient, define a second UDF and you’ll have >500 characters, and a ....

    Hope this helps et bonne chance!

    Dieter
    Report
  2. 0
    Muhammad Anwar ·
    #2
    Dieter,


    How would you add notebook topic to used defined field[UDF] then how woudl you add same topic to multiple fields means two UDF. Please eloborate a bit more. I am sure this is not possible. you can play around with notebook topic via dictionary.xls or you can see the comments inside a specific topic in a report but not in UDF.


    regards

    Muhammad.
    Report
  3. 0
    Johnny Pain ·
    #3
    I’ll try the user defined text field stuff.
    I think I’ll need only one of these.

    thanks !
    Report
  4. 0
    Dieter Wambach ·
    #4
    Good Morning Muhammad,

    Did you find a better solution? This is a discussion forum so I used my little experience with P3e (currently P6.7) for my comment and would be lucky if someone has a better solution.

    Notebooks you can only get in some very few reports, show in a Gantt chart but not use for filter or global change. You can export them in XER and XML format. XML is difficult to work with.
    So in my humble opinion it would be the best, not to use notebook items but UDF. Exeptions might be of course.

    Johnny
    maybe you can convince your colleague to use UDF.

    Regards

    Dieter

    Report
  5. 0
    Johnny Pain ·
    #5
    hey

    I tried to import some comments into an UDF field, and it worked.
    the most important thing I needed was to import comments, wherever they might land, and the UDF field fits alright.

    thanks again !
    Report
  6. 0
    Rodel Marasigan ·
    #6
    Johnny,
    UDF is a best way but if you have SDK you import comments to notebook on any topic you wanted.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?