Entitiy Relationship Modell of AssetCenter-Database

• Jan 20, 2005

• #2

jjoensuu

MIS

Oct 22, 2001

45

US

Hi Nico876,

if you chose to also install the documentation when you installed AssetCenter, check the document named "PhysicalDataModels.pdf" in the [install dir]\doc\pdf directory. Another document that may be useful for you is one called "dbstruct.chm", located in the [install dir]\doc\chm directory.

cheers,

JJ

 

Upvote 0 Downvote

• Jan 21, 2005

• Thread starter
• #3

Nico876

Programmer

Dec 19, 2004

7

DE

Thank you jjoensuu!

But, in the document "PhysicalDataModels.pdf" are only parts of the hole Datamodell. I'm searching for a hole one. I'v just seen it for ServiceCenter. And I asked already PRGN for a AC-Datamodell, but they say that such a Datamodell doesn's exists. I can't really believe this, because when I develop a Database (as a DB-develop-manufacturer) I do need a Datamodell of the hole Database.
I tryed even to produce one with the function "Reverse Engineering" of the tool "DBDesigner 4". But it doesn't works. I mean, after the reverse engineering, I see only Systemtables(?).

Furthermore, I would like to ask you how I can find more "Peregrine-experts" in this forum, and if you know any other websites with a Peregrine-forum (AssetCenter preferred)?

Thanks,
Nick

 

Upvote 0 Downvote

• Jan 21, 2005

• #4

jjoensuu

MIS

Oct 22, 2001

45

US

Hi Nico876,

it sounds unlikely that Peregrine would not have a full ERD for their own database. After all, all the OOB table fields, links, keys etc are documented in the "database.txt" file, located in the \doc\infos directory. I do not know, though, if there's a tool that can create an ERD from the data in this file.

About finding AC experts, you could try following sources:

1. check Peregrine's support site, support.peregrine.com. They have a forum where you can post questions.
2. join your local chapter of the "Peregrine Users Group". Check out

http://www.gpug.org

for more info.
3.

http://www.sc-resources.net

has info and a discussions forum
4.

http://www.sandreas.de

has Peregrine information
5. yahoo groups hosts a couple of Peregrine related discussions forums. Go to groups.yahoo.com/group/ +
peregrineassetcenter
peregrineservicecenterforum
gsantana
The last one is mainly for OAA questions. None of the yahoo groups are particularly active, though.

cheers,

JJ

 

Upvote 0 Downvote

• Mar 7, 2005

• #5

wrueckert

Programmer

Apr 20, 2002

8

CH

the easiest: take dbbase.txt from a subfolder of the AC intallation or generate a new one with AC-dbadmin

 

Upvote 0 Downvote

• Mar 8, 2005

• Thread starter
• #6

Nico876

Programmer

Dec 19, 2004

7

DE

Thanks wrueckert,
but I knew the dbase.txt already.
It's not what I'm searching for.

I would like to have a graphical Data Model (ERM).
And to create one with the dbase.txt is very exhausting.

Bye,
Nic

 

Upvote 0 Downvote

• Mar 8, 2005

• #7

Jasonic

Technical User

Jun 20, 2001

69

GB

Nico876

Furthermore, I would like to ask you how I can find more "Peregrine-experts" in this forum, and if you know any other websites with a Peregrine-forum (AssetCenter preferred)?

What do you wish to know?

Jason Thomas
AssetCenter Consultant
Jason Thomas Consultancy Limited

 

Upvote 0 Downvote

• Mar 10, 2005

• #8

JArmengaud

Programmer

Jan 15, 2003

4

FR

I can confirm that the R&D does not have a full graphical diagram. With so many tables, it is very difficult to even print it...! So its use would be limited.

-Joel Armengaud

 

Upvote 0 Downvote

• Nov 3, 2005

• #9

wrueckert

Programmer

Apr 20, 2002

8

CH

Hi,
you can get it out of the AC-DB-Admin.
Follow menue: Action-Templates

If no template are indicated you have to load them from the AC-Programm folder. Look in the AC-Manual for details,

Wolfgang

 

Upvote 0 Downvote