Saving Ms word document (with formatting) in oracle using liferay

[Haris Tasawar, modificado 11 Anos atrás.]

Hey all,
I have a requirement to save the data of a MS word document (with formatting like tables, bold characters, headers etc) to oracle database and then read it back. Is this possible? If you guys have any idea regarding this then please let me know .

Thanks,
Haris

[Tim Telcik, modificado 11 Anos atrás.]

Hello Haris,

depending upon your requirements, you could :

1/ Store the entire MS Word document (binary content) in an Oracle database as a BLOB type.

2/ Use Apache POI to parse, process and create MS Word documents. See "http://poi.apache.org/hwpf/index.html"


Regards,

Tim

[Juan Gonzalez P, modificado 11 Anos atrás.]

Perhaps you could use Database store in Liferay, using this

dl.store.impl=com.liferay.portlet.documentlibrary.store.DBStore

in portal-ext.properties in 6.1 GA

[Hitoshi Ozawa, modificado 11 Anos atrás.]

Just use database store and use Document and Media portlet to save MS document files. Liferay will automatically save MS document files to Oracle database.

[Haris Tasawar, modificado 11 Anos atrás.]

Thanks guys for your quick reply....but can you please tell me that what is data store and how to use it :/ , also can i search the contents of this file???

[Hitoshi Ozawa, modificado 11 Anos atrás.]

Check the following page.
https://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/document-library-portlet

You'll need to create a portal-ext.properties file. Read up about it in "Customizing Configuration" in following page:
http://www.packtpub.com/article/setting-up-and-configuring-a-liferay-portal

MS Office and PDF files saved to Document and Media portlet will be indexed by default. You'll be able to use "Search" in Document and Media portlet to search for the content.