Anyone know hot to copy a record from one issues databse to another

[rway]

Does anyone know how to copy a record from one issues database to another. Can this be done using basic SQL? I have not been able to find any information on the databse schema etc.

I am looking to use the issues database as a "Batch Job Documentation" tool and I need a "PRODUCTION" database for production documentation and another database for "SCHEDULING REQUESTS". Once requests are completed I want to copy the record from the "SCHEDULING REQUESTS" database and insert/replace the record in the "PRODUCTION DATABASE"

Has anyone done this before. Unable to find any documentation in my manuals on this.

 

[ChaserNL]

The issues database doenst ring any bells, which sharepoint version are you using?

Also an important note!!: editing a sharepoint database directly is not supported!! only access the database trough the objectmodel...!

 

[rway]

I am currently using Sharepoint Services for Windows 2003. The issues database is created from the home page by selecting Create>Issues

Thanks

 

[ChaserNL]

Hi rway,

I found the list you are talking about, (i use a different language version so it is called very different).

As i said before, dont do anything to the database directly...

You should write your own part to do this...

As i have made a few examples already here on the board i refer to "Generating user reports" thread here i gave an example to go through the site and subsites, you should then navigate to the correct site and find the correct lists,

Then read the field from one list and then add these values to the ohter list, in "add an URL to a list through SDK" (2nd page) i gave an example to add a new record.

to read the fields use the same syntax as adding them ie field["fieldname"];

a complete list of the available fields for each list is found here:

http://msdn.microsoft.com/library/d...s/spptsdk/html/tsovFieldsTable_SV01084251.asp

But this is quite some work to get it right...

I hope this is of some help!