Document Library: Where is the physical location of file storing?

[Wilson Hew, modificado 13 Anos atrás.]

Hi Liferay friends,

Anyone knows where is the physical location of file storing that we uploaded in Document Library portlet? Can we edit the physical location? How?

Thanks.

Regards,
Wilson Hew

[Manish Kumar Gupta, modificado 13 Anos atrás.]

By default, it is under data/document_library.

You can change it using property dl.hook.file.system.root.dir

[Wilson Hew, modificado 13 Anos atrás.]

Manish Kumar Gupta:

You can change it using property dl.hook.file.system.root.dir

Thank you for prompt reply.

May I know where is the property located in?

[Manish Kumar Gupta, modificado 13 Anos atrás.]

This property is located in portal.properties and you need to create portal-ext.properties to override it.
Copy this portal-ext.properties in server classpath.

[hari pulijala, modificado 13 Anos atrás.]

What could be the database table names if they are getting stored in db?
I have the following tables in my db but the files seem not to be stored any where.
DLFileEntry |
| DLFileRank |
| DLFileShortcut |
| DLFileVersion |
| DLFolder

Can any one please guide me which table the actual file blob will reside?

[James Falkner, modificado 13 Anos atrás.]

hari pulijala:

What could be the database table names if they are getting stored in db?
I have the following tables in my db but the files seem not to be stored any where.
DLFileEntry |
| DLFileRank |
| DLFileShortcut |
| DLFileVersion |
| DLFolder

Can any one please guide me which table the actual file blob will reside?

By default, the file content is not stored in the DB. Those tables are used to keep track of what documents in the document library, but not the actual content. The actual content is in the location Manish references (by default). And they are stored in a directory hierarchy according to group id, document id, version, etc.

[hari pulijala, modificado 13 Anos atrás.]

Thank you James.
I dumped all the workspace items and blobs into my new liferay repo location and every thing perfectly works fine..

[Dounia Mikou, modificado 9 Anos atrás.]

Hi,

You said that documents are by default stored in the file system and all the rest of content ( wiki pages, articles,..) are stored in the database.

I have one question. In fact I tried to look at the content of liferay_home/data/document library and I found many repositories which names are numbers. But I can't find the real documents in the document library (I mean PDF and Word documents I added to the document library). SO what is the content that I find in the document_library directory ? Are there indexes? And where can I find the real documents ?


Thanks

[Robin Nagpal, modificado 9 Anos atrás.]

Dounia Mikou:

Hi,

I found many repositories which names are numbers. But I can't find the real documents in the document library (I mean PDF and Word documents I added to the document library). SO what is the content that I find in the document_library directory ? Are there indexes? And where can I find the real documents ?


Thanks

I hope you are using the default liferay store i.e dl.store.impl=com.liferay.portlet.documentlibrary.store.FileSystemStore

The actual folder path that is used by Liferay for storing documents is this:

/companyId/folderId/numericFileEntryName/versionNumber

The first folder name is the company ID to which the site belongs. The second folder name is the ID of the Documents and Media folder within which the document resides. The third folder name is the numeric file entry name of the document itself. Finally, the fourth name is a version number which is used for storing multiple versions of the document.

The numeric file entry name of a document is distinct from the document ID; be careful not to confuse the two! Each has an independent counter. The numeric file entry name of a document is used in the folder path for storing the document but the document ID is not. The numeric file entry name of document can be found in the name column of the DLFileEntry table in Liferay’s database; the document ID can be found in the fileEntryId column of the same table.

[Dounia Mikou, modificado 9 Anos atrás.]

Thank you for ur answer.
So I am not able to find the real content of the document in clear ?
I mean suppose that I added a document 'Test 01' to the library and wrote in it 'this is a test document'. I can't find this content nor the title of the document in the file system ?

[Raja Seth, modificado 9 Anos atrás.]

Hi Dounia,

Any update for the real content path?

Thanks & Regards,
Raja

[Jitendra Rajput, modificado 9 Anos atrás.]

You won't able to find the document way you uploaded. If you see the answer from Robin Nagpal you will get clear understanding how liferay generates folder structure for your companyId and folder id.

You can narrow down the folders based on below format.

 /companyId/folderId/numericFileEntryName/versionNumber 

You will see file located under above folder structure with fileEntryId.hooktype.

It means if you are using FileSystemHook then you will see file with 1123.fsh extension.

If you are using AdvanceFileSystemHook you will file with 1123.afsh extension.

You can try by renaming this document to actual format to view the content of this files.

Hope this will help you,
Jitendra

[Raja Seth, modificado 9 Anos atrás.]

Thanks Jitendra for your reply.