Previous DB -> DCR's

Hello. I have a DB with a lot of articles and I would like my editors to use TeamSite instead of the custom admin tool that I have inherited. Is there anything I can do with all the DB records? I want my editors to be able to edit old articles as well as create new ones? Is there some way to do a DB-to-XML deployment that will give me as many DCR's as rows in the database?

Any help at all is much appreciated.

Whoah TeamSite!
<Charlie/>

Find more posts tagged with

Comments

Migrateduser

database to XML deployment will create the xml file in a format different from that of DCRs. So, you would have to convert the output into a DCR format yourself.

You can control what needs to be written to the output, by specifying the complete query to select the database rows. Look into the documentation for <db-producer-query>

Pavan

You should create a DCR in Teamsite and the view the corresponding XML file for that DCR.

Then You can write a simple Java program which takes all the records from database and converts them into XML file one by one and then save it on the file system.

Then you can copy all these XML files into /templating/...../data/ directory.

Then write a small batch file, which sets the extended attributes on all these files.

Now Teamsite will recognize these files as if they were created from Teamsite. Now, you should run iwsyncdb.ipl once again so that database will synchronize with all these DCRs in your teamsite and then your users can Add/Update/Delete these DCRs and they will be reflected in database.

It should be very easy. I have done the same thing very recently and it works fine.