Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTD for PowerDesigner XML
- Thread starter JWFox
- Start date
- Thread starter
- #3
I am frequently asked to export information out of PowerDesigner in a format that can be imported into another tool, whether that tool is MS Excel, MS Access, etc. Having the DTD for the XML-format PowerDesigner file would be extremely helpful in building some kind of tool to provide that export functionality.
Hello.
I don't have the DTD to give you. Saving the models as XML allows PowerDesigner to be very flexibly init's processing of models, not neccesarily to export in this case. If you wish to export to an external tool their are several process.
Your best chance is using PD 9!
I know this isn't quite what you asked for but here goes.
In PD 9 you have much more flexability in exporting the metamodel.
You can export the UML diagram as an XMI format for interchange with other UML tools. (See below for details). And this will automatically generate the DTD for the UML.
If you wish to export to something like Excel then in PowerDesigner 9 a VB API has been introduced so that you can automate certain things. one of the sample scripts will export a CDM to EXcel. You can tailor this for the othermodels as well. Using this you can customize exactly what you need to export to Excell etc. It would be the same for Acceess unles you wished to generate an acccess database and thenb I would reccomend using the built in Access genertation tool to generate the DB.
--------------------
When you export
an XMI file, you save your OOM under the XML format. Simultaneously a DTD UML 1.3 file is created in the same directory as your exported XML file allowing you to validate your file.
HTH
Jay
I don't have the DTD to give you. Saving the models as XML allows PowerDesigner to be very flexibly init's processing of models, not neccesarily to export in this case. If you wish to export to an external tool their are several process.
Your best chance is using PD 9!
I know this isn't quite what you asked for but here goes.
In PD 9 you have much more flexability in exporting the metamodel.
You can export the UML diagram as an XMI format for interchange with other UML tools. (See below for details). And this will automatically generate the DTD for the UML.
If you wish to export to something like Excel then in PowerDesigner 9 a VB API has been introduced so that you can automate certain things. one of the sample scripts will export a CDM to EXcel. You can tailor this for the othermodels as well. Using this you can customize exactly what you need to export to Excell etc. It would be the same for Acceess unles you wished to generate an acccess database and thenb I would reccomend using the built in Access genertation tool to generate the DB.
--------------------
When you export
an XMI file, you save your OOM under the XML format. Simultaneously a DTD UML 1.3 file is created in the same directory as your exported XML file allowing you to validate your file.
HTH
Jay
Hello,
Check out
DTD and XML editors
Furthermore PowerDesigner XML files support a DTD (Document Type Definition) for each type of model. The DTD enables you to use an XML editor to browse through the hierarchical structure of the objects in the model. The different DTDs are available in the \DTD folder in the PowerDesigner installation directory.
Check out
DTD and XML editors
Furthermore PowerDesigner XML files support a DTD (Document Type Definition) for each type of model. The DTD enables you to use an XML editor to browse through the hierarchical structure of the objects in the model. The different DTDs are available in the \DTD folder in the PowerDesigner installation directory.
Take care to not make confusion between data item and entity attribute.
To get dataitem properties with vbs, use the following
========================================
set M=ActiveModel
for each E in M.Entities
for each A in E.Attributes
DescribeDI DI A.DataItem
next
next
sub DescribeDI(x)
output x.Name
' and whatever data item property you want
end sub
To get dataitem properties with vbs, use the following
========================================
set M=ActiveModel
for each E in M.Entities
for each A in E.Attributes
DescribeDI DI A.DataItem
next
next
sub DescribeDI(x)
output x.Name
' and whatever data item property you want
end sub
- Status
Similar threads
- Locked
- Question