on 07-13-2007 11:13 AM
Hi there
Can anyone tell me where KM content is stored ... is it on the file system somewhere, or within SAP tables?
Perhaps that is too broad a question, so I will elaborate a bit ...
We are delivering a 2004s BW system, and the templates are delivered through the portal. Part of the functionality of our templates is to allow the users to add/view/edit comments for a dataprovider.
I have been requested to delete comments that are more than a month old, so was hoping I could write a Java / ABAP program to read the comments from wherever they are stored, and delete the old ones accordingly.
From what I can see, comments are handled like other KM content, hence the question as to where KM content is stored.
Any information would be greatly appreciated.
Cheers,
Andrew
Hi Andrew ,
the storing of data depends on the type of repository ,u r creating.Whether it is
1.DB mode
2.DBFS mode
3.FSDB mode
u can chk this link for internal repository-CM repository manager
http://help.sap.com/saphelp_nw70/helpdata/en/4c/9d953fc405330ee10000000a114084/frameset.htm
i think it will help u.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew,
if you know the id of the KM repository where the comments are stored, you can easily find out where the content is stored. Prerequisite is that you can access the portal with system administration rights. Then you can take a look into the Content Management configuration.
To do this select System Administration / System Configuration in the top level navigation. In the detailed navigation select Knowledge Management / Content Management. This will open the Content Management Configuration.
Select the area 'Repository Managers'. Now you should see the different types of Repository Managers. Most likely your repository manager will either be a CM Repository or a File System Repository. Click on the respective sub areas and check the list of configured repository managers for a repository with the id you are searching for.
If your content is stored in a file system repository you will find the storage location in the 'Root Directory' column of your file system repository manager's configuration.
If the content is stored in a CM repository, then at least part of the information is stored in a database. This depends on the 'Persistence Mode' of the repository manager.
To delete content that is older than a certain date I recommend that you write a KM report which walks over the repository content, checks the date and deletes the old resources via the KM API. This will work for any type of repository.
Hope that helps!
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It depends (on the repository manager and its configuration). It may be in the file system, in the database, or somewhere else.
If you want to access it, you should use the KM Java API, or a protocol supported by KM (such as (HTTP/WebDAV).
Best regards, Julian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK, so how do I tell how the repository manager has been configured.
And if it uses the file system, how do I determine the path?
And if it uses database, which tables?
I have downloaded the Repository Framework Explorer, which seems quite useful, but still not giving me quite what I want at the moment, although it does show me what all is being stored in KM, and I can at least confirm that the comments associated with a dataprovider and template are indeed stored in the KM repository (wherever that may be)
Thanks for the help so far.
Cheers,
Andrew
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.