import single pid file in current database

[vijay_prajapati]

Hi friends,
I've one more issue with sppid. My client sent us some sppids pid files without any database and my lead ask me to import in current database. Could you help me guys? How to import single file in database. Thanx in advance

[Patrick_Aps]

You only can import a P&ID from one plant to another if you have access to both plants.
What you could do is:
- ask a backup of his complete site, including Reference Data
- restore this backup at your computer. You'll need to have a separate database or separate database users.
- then try to import the P&ID from the backup into your plant.

[vijay_prajapati]

Thanx patrik for the help. But problem is that our client is in another country and they are sending pid files via mails and my lead says import in database and start working on it and in future also we will receive same kind of files. I don't know how to tackle this situation. Any body know about it then pls. Post reply
Thanx

[dave]

oracle or sql?

You need to first create your site (if you dont have one already) and tablespaces in oracle. You need to make sure the versions are the same (and service packs!) as a database change was made in sppid 2007 SP4.

You can get the names of the tablespaces if you try to restore the project without first creating them. Eng. Manager will throw and error saying "Cant find tablespace "Project" or something. Then you can create the new tablespace based on that name. You will need 2 - one for the project data, and one for the data dictionary data.

Patrick Aps probably has some utility that can look in the .dmp file and find the tablespace names but I am not so fancy like him. :)

[vijay_prajapati]

Thanx dave for wonderful suggession. My project is in oracle. We already raised the project on server and start working on it. As a part of this project they are sending some newly created or say updated pid files via mails and I have to import it in same project. Is it possible?

[dave]

if the project is the same, just have them make an assembly of the drawing and send it to you for you to insert. Of course all of the symbols will have to be the same to do that. From there you just have to change the tag numbers if they conflict with your existing ones. This is the easiest way I think. Patrick Aps, what do you think?

[Patrick_Aps]

If your site is created as a "sattelite" site of the "master plant" overseas, then you can update single P&ID's between the files with using "get latest version" in the Drawing manager.
But that's only possible in an "offline workshare" situation:
To create the sattelite on your site, there must have been a large zip file with the whole configuration and the complete symbol catalog.
Then, so send some PID files from the master site to the slave or back, you have to fetch versions etc in the drawing manager.

Try to find workshare.pdf on an P&ID workstation and read it.

[dave]

Patrick, did you get my PM?