Export/Import Project

I'm having an issue with importing Xls and XML into P6 v8.2.

It is simply totally not working at all.

DBJACKET.primavera.xml.SummaryImportLog.txt looks like:

"com.primavera.integration.client.ClientException: Fatal error: null

    at com.primavera.integration.client.Session.a(Session.java:379)

    at com.primavera.integration.client.Session.login(Session.java:339)

    at com.primavera.integration.app.importexport.ImportExportAction.b(ImportExportAction.java:172)

    at com.primavera.integration.app.importexport.ImportExportMain.main(ImportExportMain.java:33)

Original Exception:

java.lang.NullPointerException

    at com.primavera.bo.datacaches.ServerUserPrivsCache.getServerUserPrivsCache(ServerUserPrivsCache.java:765)

    at com.primavera.bo.common.b.a(LoginHelper.java:360)

    at com.primavera.bo.common.b.a(LoginHelper.java:166)

    at com.primavera.bo.remotable.SessionLifetime.login(SessionLifetime.java:57)

    at com.primavera.bo.remotable.qproxy.SessionLifetime.login(SessionLifetime.java:76)

    at com.primavera.bo.DBSessionLifetime.login(DBSessionLifetime.java:26)

    at com.primavera.integration.server.ServerFacadeBase.login(ServerFacadeBase.java:411)

    at com.primavera.integration.server.ServerFacade.login(ServerFacade.java:11)

    at com.primavera.integration.client.LocalSession.login(LocalSession.java:92)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at com.primavera.integration.client.Session.a(Session.java:351)

    at com.primavera.integration.client.Session.login(Session.java:339)

    at com.primavera.integration.app.importexport.ImportExportAction.b(ImportExportAction.java:172)

    at com.primavera.integration.app.importexport.ImportExportMain.main(ImportExportMain.java:33)"

I have no idea on what could be wrong ?? 

Dear Planners

I would like to aks, is it possible to import part of project which is came from our contractors to my master plan project, for example i have one big schedule with difirenet kind of job civil mechanical and E&I, therefore i am recieving 3 types of schedule, and i want to import into my main schedule these reports, i mean import for right place? pls help

If you have any instruction please send to my email

Aibekcoolsary@gmail.com

Aibek

you can export and import individual layouts since they do not come with the project during an exporting of an xer 

go to 1st machine 

view layout open

highlight the the layout you want to export

on the right hand side select export (it will be a .plf file)

save the file 

go to 2nd machine 

view layout open

on the right hand side select import

file the .pil file that you previous exported and then import it 

Hi,

Strictly on the layout import / export question.  Here's a complete step-by-step with screenshots:

https://www.planacademy.com/importing-exporting-emailing-layouts-in-oracle-primavera-p5-p6/

Hope it helps,

m

Hi....

I am new to Primavera with some basic knowledge. I have a doubt, if i import a program prepared by some other planned in to my system will the calander also will be imported which the other planner had defined?? i would be glad if any one can assist me in guiding how to export the baseline schedule? how to import the baseline schedule along with the process update??

Looking forward for early assistance.

Rgds

Linkan

Hi....

I am new to Primavera with some basic knowledge. I have a doubt, if i import a program prepared by some other planned in to my system will the calander also will be imported which the other planner had defined?? i would be glad if any one can assist me in guiding how to export the baseline schedule? how to import the baseline schedule along with the process update??

Looking forward for early assistance.

Rgds

Linkan

10-4

Rafael,

I’ve found this info too; therefore the issue is closed, isn’t it?

Alexandre

Alexandre,



Sure it helps; by the way from a Google search I just find out that the last part of the procedure can solve issues on P6 Bad Public user name & password as follows.



You will need to use the SQL Server Management Studio in order to get this to work. When you log into the SQL Manager, You select the P6 database. Right click and select: "New Query".



In the right pane you will need to paste the following script:



Exec sp_change_users_login ’Update_one’,’PUBUSER’,’PUBUSER’



Exec sp_change_users_login ’Update_one’,’PRIVUSER’,’PRIVUSER’



and select "Execute" from the menu.



The connection to the priv- and pubuser is reestablished. Now you will no longer receive the "Bad Public user name & password" error.



Best Regards,

Rafael

Rafael,

1. to switch on the same stand alone PC between SQL Server PM database 1 and 2, is just as easy as moving both files to an empty windows directory, then pasting the alternative files; say: "C:\Dir1\pmdb$primavera_DAT.MDF" is my standard database and "C:\Dir2\pmdb$primavera_DAT.MDF" is the one I am using for a specific training; to avoid deleting one of them, I also use a C:\Dir3 directory in between

2. to work on two different stand alone PCs, the following procedure must be used:

create a Resync MS SQL Server script (i.e. resync_privandpub.sql) with the following info:

use pmdb

exec sp_change_users_login ’Update_One’,’pubuser’,’pubuser’

exec sp_change_users_login ’Update_One’,’privuser’,’privuser’

I hope this is explanatory enough and will help.

Alexandre

Alexandre,



For sure what you are asking is no copyright infringement. Posting a primavera document intended only for those under service agreement would be, we understand why you can only make a reference and not issue a posting of the document. Therefore I was asking for you to provide us with information on how to transfer databases in your own words so there is no copyright infringement.



Can the following link be a jumpstart on the issue?



http://primavera.zxlm.cn/kb/prim54984



Best regards,

Rafael



With a copy and paste into MS Word I copied the article for my own use, that I cannot distribute.

Rafael,

thank you for the compliment, I am not a Primavera guru, only a professional instructor who likes working and teaching this software

be sure that I will not air any protected document; I know that not all PM users have access to the knowledgebase, I suppose that only a few people in a Primavera customer company are allowed to connect the knowledgebase; my opinion is that I will not breach any law by suggesting these users to request the said document from support people.

Alexandre

Alexandre,



Your knowledge stands high as always. As I said I do not have P6 but I am sure many P6 users will be interested in how to copy a database from one PC to another, something I never did. Just keep in mind many network users have not have access to the knowledgebase, share your wisdom without any copyright infringement, please.



Rafael

Rafael,

you can make copies of the PM6 database and use them alternatively on the same computer

if you want to copy a database from one PC to another, you will have to use a specific procedure available on www.primavera.com; otherwise, PM will not be able to connect to the "new" database

IMHO, it’s easier (but much longer indeed) to export layouts the way described by Glenn

"Exporting" databases is really the good solution if you need to copy from one PC to another a complete project management environnement; being a software instructor myself, I need to do so when I want all my trainees to have the same working environnement on their stand alone PCs.

Alexandre

Maybe you can create a copy of your original database and rename it, erase all unwanted data to be transferred, then copy this database into the other computer and make it accessible using your database software.



I don’t think P6 limits you to use only one database file, once configured you can select any at the startup dialog. We tried P6 and stopped using it as we found it to be overkill for our needs, I do not have a copy of it so I cannot give you any more details of how I created an additional database, sorry. I was exploring the idea of keeping separated projects on separate databases from various clients I provide CPM Scheduling support but never bought a license for myself.



Best regards,

Rafael



Remember to always keep your backups to date, just in case.

U can’t export / import filters along with the program.



Only way is to assign them as Global.



It is useful, only if u have limited no. of projects, o/w becomes messy.

Glenn,

it helps, indeed; thanks a lot

Alexandre

Hi Nestor

I hope this help, regarding layouts go to view/layout/open and select the layout you want to export then click export and make it in .plf format, do the same in all the layout you want to copy and then open it in the other computer using the same steps but with import command, that should do the trick but regarding the filter im still trying to figure it out also,



Glenn

Nestor,

Exporting a project does not export layouts nor filters; only project data

Alexandre