Export/Import Project

In the Open Standard

Nestor PrincipeMember for 17 years 11 months

Created: 24 Jun 2009, 05:39
: 22
: 9

Dear All,

I have exported a project and imported to another computer. We are using 2 stand alone systems.

The layouts and filters are not imported. Is this normal or I missed something.

Thanks to your assistance. I can read the manual but I need the solution urgently.

Cheers,
Nestor

Save Follow Follow forum Report

Reply New topic

22 replies

Oldest first

0
Alexandre Faulx-Briole · 17 years ago
#1
Nestor,
Exporting a project does not export layouts nor filters; only project data
Alexandre
Report
0
Nestor Principe · 17 years ago
#2
Hi Alexandre,

Thanks to your prompt reply. It saves me time.

Great!! That means I have to recreate about 50 layouts and less than hundred filters.

There must be way to work around.

Cheers,
Nestor

Report
0
Glenn Dexter Ubaldo · 17 years ago
#3
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
Report
0
Alexandre Faulx-Briole · 17 years ago
#4
Glenn,
it helps, indeed; thanks a lot
Alexandre
Report
0
A D · 17 years ago
#5
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.
Report
0
Rafael Davila · 17 years ago
#6
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.
Report
0
Alexandre Faulx-Briole · 17 years ago
#7
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
Report
0
Rafael Davila · 17 years ago
#8
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

Report
0
Alexandre Faulx-Briole · 17 years ago
#9
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
Report
0
Rafael Davila · 17 years ago
#10
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.
Report
0
Alexandre Faulx-Briole · 17 years ago
#11
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

Report
0
Rafael Davila · 17 years ago
#12
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

Report
0
Alexandre Faulx-Briole · 17 years ago
#13
Rafael,
I’ve found this info too; therefore the issue is closed, isn’t it?
Alexandre
Report
0
Rafael Davila · 17 years ago
#14
10-4
Report
0
Nestor Principe · 17 years ago
#15
Conclusion.

P6 needs improvemetn to make it simple and user friendly or just maybe it needs to add module for macros. I remember Project 2 in the early days.

Thanks to all.

Cheers,
Nestor

Report
0
Nestor Principe · 17 years ago
#16
I encountered another problem. The budgeted and actual total cost got 1% difference when exported. I used global change to corect the budgeted cost and still trying to find how to correct the actual cost,it’s affecting my stored period performances.

Somebody experienced the same?

Cheers,
Nestor

Report
0
Linkan RS · 14 years ago
#17
Hi....I am new to Primavera
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
Report
0
Linkan RS · 14 years ago
#18
Hi....I am new to Primavera
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
Report
0
Michael Lepage · 11 years ago
#19
Hi,Strictly on the layout
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
Report
0
Zoltan Palffy · 11 years ago
#20
you can export and import
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
Report
0
Field Corosion · 10 years ago
#21
Dear Planners I would like to
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
Report
0
Johan Verhoeven · 9 years ago
#22
I'm having an issue with
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 ??
Report

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?