Excell exporter.

[joksy]

Hi everyone!!

As the title of the topics suggest my task is to export some data into an excell file.
In details, all my file in alfresco are build from the property and association which a user define to it after the creation, in the end all information are store in this way. The point now is understand a way to extract all property from a custom type and save it into an excel file.

So before starting i would ask you if exist a simple way to solve my problem, or the only way  to do it  is through programming maybe enter in the JCR and retrieve all object and for each of them extract the value of the property…

Any help will be very appreciate.

Thanks
J.

[joksy]

Hi guys,

The fastest way to extract meta-data content is to use the alfresco jcr api. If you do not produce on demand an xls file you can easly create a .csv file and after import them in excel.
So by using this http://wiki.alfresco.com/wiki/Introducing_the_Alfresco_Java_Content_Repository_API#Appendix_1:_Compl... example all became doable.

Best R.
J.

[krutik_jayswal]

There is one generic example using which you can export any kind of data in excel.Below link will help you understanding that stuff.

Alfresco Webscript : Export Data In Excel | Krutik Jayswal