reading data from multiple DCR's into an ASP page.

user is using my news release template to contribute the content. but they also want a historical news release web page which shows the "title" and "date" of all the historical news releases that have been created using this template.
How can I accomplish this? I am guessing that when user creates a DCR using the DCT, I should store the same data into a table (oracle ). And develop another asp page that can pull the data from the table.
Is this correct way of doing? any thoughts please
thank you

Find more posts tagged with

Comments

akshathp

Can you not have this taken care by EAs on DCR? If all you need is a title and date, then each DCR created with your template could store EAs for these values and then you could dynamically create a page with the values of these EAs as and when required.

Hope this helps!

Akshat Pramod Sharma
Interwoven Inc.

Johnny

Normally a second template is created for an 'index' page or 'archive' page.

This would traverse all DCR's to retrieve the info it needs (heading etc) and generate a list.

John
Sydney, Australia

tvaughan

I've got this exact setup working for our Press Releases.

Basically, when a user fills in a new press release DCR and clicks 'close' on the DCT, it kicks off a workflow that makes an external call to the "iwptcompile" command. I pass it the name of a TPL that:

does a 'find' command on my data directory,
sorts the DCR filenames
opens each DCR (use iwpt_load_dcr)
grabs the title (and some other info) from the XML
spits out HTML for the index page

It's pretty straight forward Perl coding, but I've also seen that there's a new "auto indexing" feature that can auto-create index pages based on other files stored within TeamSite. Check out the TS admin guide (or is it the TFO guide??) for more info on this.

Tom

Migrateduser

what are EA's? could you pls explain more.
thanks
nath

akshathp

EAs are Extended Attributes on a file. TeamSite has Command Line Tool iwextattr which can be used to set an extended attribute on a file and that you can use for storing information like date and title.

Hope this helps!

Akshat Pramod Sharma
Interwoven Inc.

gzevin

as I replied to this in the same question but in Templating section...

one could either parse DCRs.. but a more elegant way of doing this could be using DataDeploy's DAS feature that would sync all the DCR fields with a database and make them available for any SQL queries...

However, if DD is not an option, then of course parsing DCRs is a good option

Greg Zevin
Independent Interwoven Consultant/Architect
Sydney, AU

Screenshot-2012-04-18_12.32.57.png

Screenshot-2012-04-18_12.33.41.png