XML Forms saved on the portal DB

[Former Member]

Hello all,

We have created an XML form application and inserted a few items.

I need a direct access to the data (I don't want to display it with XML Forms).

I was told that the XML files that where created are saved on the portal DB.

Can anyone tell me what are the names of the tables that the data is being saved on?

What is the format that the files are being saved in? what is the format that the properties/meta data is being saved in?

Thanks for your time, Adi.

[Former Member]

Hi Adi,

I would initially suggest you to check whether the same exists under "etc" directory.

Go to Content Administration - > KM content -> etc

Here the xml forms are stored.

Regards,

venkat.

[Former Member]

Hi Venkat,

Thanks for your reply.

My xml forms are not under "etc" folder, but rather under "documents"

The CM repository has "db" persistence mode.

I guess I should explain my goal better:

We have created XML forms for entering data like news.

We don't want to display the data using more XML forms but rather with webDynpro Java.

We are looking for a way to access the data.

what would be the best approach for that?

Access the DB where the data is stored,

or are there any ready to use API's for that?

Thanks again, Adi

[Former Member]

Hi Adi,

I got your point.

Generally, it is difficult to trace the location of files in datbase as they generally stored in encyrpted form or so(not sure).

Also, accessing the database tables to retrieve the data is risky and is not suggested.

Regards,

venkat.

[Former Member]

Hi Venkat,

Thanks again

Anyone can advice on how to access the data?

[Former Member]

Well, you can access the content through either the KM APIs (make sure to call getUnfilteredContent()...), or through HTTP/WebDAV (in this case, send a request header of "Translate: f" to select the unfiltered content).

Best regards, Julian

[Former Member]

Thanks Julian!!

It works thanks to your hint about <b>getUnfilteredContent</b>

and another very helpfull post:

Regards, Adi.