Automatic generation of DCR's

Hi all,

I need to migrate all my existing HTML pages into Teamsite as DCR's. I have come up with the following approach:
The core migration utility will be split into following 2 modules:
1.Java based utility that can parse and retrieve data from MS Excel sheet which contains all details for creating a DCR.
2.Java based utility that can transfer content read from Excel sheet into a XML file that adheres to DCR structure and store it in data folder.

If i directly create the DCR bypassing the Teamsite DCR generation method, will it work? Has anyone adopted this route before? Any impacts when i upgrade TS versions in future?

Any input about this is highly appreciated.

Thanks,
Subash.

Find more posts tagged with

Comments

ads66

Hi subhash,

if what you state that the utility adheres to:
1.Java based utility that can parse and retrieve data from MS Excel sheet which contains all details for creating a DCR.
2.Java based utility that can transfer content read from Excel sheet into a XML file that adheres to DCR structure and store it in data folder.

I dont see a problem in trying it out and letting us know. I guess as long as the DCR standards in XML format are supported by interwoven, it should work for the current version. Regarding upgrade, I think you might have to change your DCRs a bit since it depends on the dtd version i believe.

BTW, what version are u working on?
Thanks,
A

Adam Stoller

Hi all,

I need to migrate all my existing HTML pages into Teamsite as DCR's. I have come up with the following approach:
The core migration utility will be split into following 2 modules:
1.Java based utility that can parse and retrieve data from MS Excel sheet which contains all details for creating a DCR.
2.Java based utility that can transfer content read from Excel sheet into a XML file that adheres to DCR structure and store it in data folder.

If i directly create the DCR bypassing the Teamsite DCR generation method, will it work? Has anyone adopted this route before? Any impacts when i upgrade TS versions in future?

Any input about this is highly appreciated.

Thanks,
Subash.

Don't forget that you have to set the EA on the file to identify it as a DCR (this has been posted about in many threads)

rdelange

I have successfully used Excel 2007 with its buiilt-in XML capabilites to accomplish this -
Using a sample DCR, I created an XSD file that describes its structure (basically the MS version of a DTD), and loaded this XSD file within Excel. Excel uses the XSD as a map, which you can use to assign the spreadsheet columns to the XML entities (it's as simple as dragging and dropping).
Then using a VB macro, I simply export and save a single row of the spreadsheet as a XML file that can be imported into the CMS. The macro iterate though each row in the spreadsheet, basing the XML filename on the value of the first column.
All that's left to do after that is to run the iwextattr command to assign the DCR to a template.

Gogz

Rdelange,

Could please provide those files for our reference.

Antharix

I have successfully used Excel 2007 with its buiilt-in XML capabilites to accomplish this -
Using a sample DCR, I created an XSD file that describes its structure (basically the MS version of a DTD), and loaded this XSD file within Excel. Excel uses the XSD as a map, which you can use to assign the spreadsheet columns to the XML entities (it's as simple as dragging and dropping).
Then using a VB macro, I simply export and save a single row of the spreadsheet as a XML file that can be imported into the CMS. The macro iterate though each row in the spreadsheet, basing the XML filename on the value of the first column.
All that's left to do after that is to run the iwextattr command to assign the DCR to a template.

Solution is interesting. Can you please share samples and the steps. Much Appriciated. Smiley Happy

gzevin

Hi all,

I need to migrate all my existing HTML pages into Teamsite as DCR's. I have come up with the following approach:
The core migration utility will be split into following 2 modules:
1.Java based utility that can parse and retrieve data from MS Excel sheet which contains all details for creating a DCR.
2.Java based utility that can transfer content read from Excel sheet into a XML file that adheres to DCR structure and store it in data folder.

If i directly create the DCR bypassing the Teamsite DCR generation method, will it work? Has anyone adopted this route before? Any impacts when i upgrade TS versions in future?

Any input about this is highly appreciated.

Thanks,
Subash.

try to ask the support for a pdf copy of my and Powell Trussler's best practice document on Templating (written actually ages ago, when I was with IWOV). It has this topic covered.