[opencms-dev] how to find unused/not linked/orphan files in vfs - pls help

[always.work.in.progress always.work.in.progress]

Hi Stephan..
I succeded to make it work  :)
It was the missing "org.opencms.relations.*" at the top of the jsp file..
I really thank you!
Now i have to find/create jsp code in order to delete all the files
reporting "orphan: true"
I will see...

Thanks.
Bye.

Il martedì 27 febbraio 2018, always.work.in.progress
always.work.in.progress <always.work.in.progress at gmail.com> ha scritto:

> hi Stephan,
>
> yes it helps a lot!
> i created a new "test.jsp" file inside my opencms site with your code;
> unfortunately it does not work telling me the following error:
>
> "CmsRelation cannot be resolved to a type"
>
> related to this line code:
>  List<CmsRelation> relations = cms.getRelationsForResource(file,
> CmsRelationFilter.SOURCES);
>
> can be due to some "missing import or declaration of specific java class" ?
>
> at the top of my test.jsp file i have the following "java class page
> import":
>
> <%@ page import="java.sql.*,org.opencms.db.*,java.util.*,org.opencms.
> jsp.*,org.opencms.file.*,org.opencms.main.*,org.opencms.jsp.util.CmsJspElFunctions"
> %>
>
> Thanks again.
>
> Il martedì 27 febbraio 2018, Stephan Schrader <zstephanz at gmail.com> ha
> scritto:
>
>> Try to embed this code in a JSP:
>>
>>         String folder = "/test";
>>
>>         CmsObject cms = CmsJspElFunctions.getCmsObject(pageContext);
>>         List<CmsResource> files = cms.getFilesInFolder(folder);
>>
>>         for (CmsResource file : files) {
>>             List<CmsRelation> relations = cms.getRelationsForResource(file,
>> CmsRelationFilter.SOURCES);
>>             out.print(file.getRootPath() + " is orphan: " +
>> (relations.size() == 0));
>>         }
>>
>> Hope this helps you.
>>
>> Stephan
>>
>> 2018-02-27 9:58 GMT+01:00 always.work.in.progress always.work.in.progress
>> <always.work.in.progress at gmail.com>:
>>
>>> hi Stephan :)
>>> i really thank you for your reply!
>>> Can you show me a simple code example in order to better undestand that method
>>> you have suggested to me ?
>>> say that i have a "test" folder inside opencms VFS:
>>>
>>> /test
>>>
>>> and this folder contains some files (.pdf, .docx, etc)
>>> how can i create the script in order to check the "orphaned" relations for
>>> files inside "/test" folder ?
>>>
>>> thanks in advance.
>>>
>>>
>>> Il martedì 27 febbraio 2018, Stephan Schrader <zstephanz at gmail.com> ha
>>> scritto:
>>>
>>>> Hi,
>>>>
>>>> you can use: *CmsObject.getRelationsForResource(CmsResource resource,
>>>> CmsRelationFilter filter)* with *CmsRelationFilter.SOURCE* as
>>>> parameter. If the result is empty, no other resource references the given
>>>> resource.
>>>>
>>>> Stephan
>>>>
>>>>
>>>>
>>>> 2018-02-23 17:59 GMT+01:00 always.work.in.progress
>>>> always.work.in.progress <always.work.in.progress at gmail.com>:
>>>>
>>>>> hi all...
>>>>> i am using Opencms 10.0.0/mysql set up in multisite environment (apache
>>>>> + mod proxy)
>>>>> i manage some large web sites plenty of xml contents/pages that link
>>>>> to many internal uploaded pdf/images files/other filetypes etc..
>>>>> often these files that are not needed anymore, are unlinked from
>>>>> related xml contents, but unfortunately they are not deleted from the vfs
>>>>> workplace and so become "forgotten".. :(
>>>>>
>>>>> Is there an internal workplace jsp script or function in order to find
>>>>> these "orphan files" ?
>>>>> i mean files that are present in vfs but not anymore linked from any
>>>>> xml contents page;
>>>>>
>>>>> these files waste db blob space and the mysql database under opencms
>>>>> is growing in size and getting more and more big..
>>>>>
>>>>> i tried to look for a way to do that but i've never found a similar
>>>>> function/method..
>>>>> it would be really useful in order to locate these unused  files and
>>>>> delete them.
>>>>>
>>>>> thanks in advance for your reply.
>>>>>
>>>>> bye.
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> This mail is sent to you from the opencms-dev mailing list
>>>>> To change your list options, or to unsubscribe from the list, please
>>>>> visit
>>>>> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>> _______________________________________________
>>> This mail is sent to you from the opencms-dev mailing list
>>> To change your list options, or to unsubscribe from the list, please
>>> visit
>>> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>>>
>>>
>>>
>>>
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20180227/154bddfb/attachment.htm>