Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Generate Customized a Data Model or Data Dictionary

Avatar

Level 3

I am using this code to Generate a data model. But here you get the data model for the whole database. Is there any way to get a data model out of a selective tables from DB

var strXslt = "nl:dbdToOdt.xsl"

var strTemplate = installDirectory("datakit/nl/dbd-template.odt")

var strOutputFile = "database-description.odt"

var sql = xtk.sqlSchema.create()

sql.Generate() //-----------> tables from whole database is taken. Can it be customized to take only a few tables

var strDbXml = db = sql.toXML().toXMLString()

var strOdt = applyXsl(strXslt, strDbXml)

strOdt = strOdt.replace(/^<\?xml .*\?>\r?\n/, '\r\n')

var mbContent = new MemoryBuffer

mbContent.fromString(strOdt, "utf-8")

var zip = new ZipFile(strTemplate)

zip.open()

zip.setEntry("content.xml", mbContent)

zip.save(strOutputFile)

1 Accepted Solution

Avatar

Correct answer by
Level 4

HI

You can use

var schema = application.getSchema("cus:myTable")

To generate a single table schema. Is this is what you are looking for?

View solution in original post

5 Replies

Avatar

Community Advisor

Hi,

the Generate() method does not receive any parameter.

Please, find the other methods which may be helpful for you on: sqlSchema

Regards,

Milan

Avatar

Level 3

Sorry, I used the wrong line as reference. i should have used this line

var sql = xtk.sqlSchema.create()

Here as we can see the whole of xtk.sqlSchema is used. Is there anyway that i can use my custom schemas to create the the object sql. I only need my custom schemas in that variable.Is it possible?

Is there any way I can pass the namespace in xtk.sqlSchema.create()?

Avatar

Correct answer by
Level 4

HI

You can use

var schema = application.getSchema("cus:myTable")

To generate a single table schema. Is this is what you are looking for?

Avatar

Level 3

Thank you for your help.

i want to generate for 3-4 schemas in a single pdd. How to include those? Can the schemas be separated by comma? Also xtk.sqlSchema.create() generates WPPobject. Is it possible to generate WPPobject the for 3-4 schemas?

Avatar

Employee

Hello,

You can try this tool. It makes it possible to select the schemas/tables you want and print in PDF part of your Data Model. 

https://github.com/ChrisRedfield126/ac-campaign-analyzer

Hope it will help