topic Re: exporting data lists into excel in Alfresco Archive

exporting data lists into excel

adam_brown — Mon, 09 Aug 2010 16:08:41 GMT

Is it possible to export the contents of a datalist to an excel spreadsheet?

Re: exporting data lists into excel

jriker1 — Thu, 11 Nov 2010 15:26:06 GMT

same question here.

Re: exporting data lists into excel

mikeh — Thu, 11 Nov 2010 15:38:30 GMT

No, this isn't currently possible.

Mike

Re: exporting data lists into excel

krups — Tue, 31 Jul 2012 06:24:12 GMT

Hello

I am using alfresco 4.0.d community edition.
I want to export my custom datalist into excel.
Can someone please help me out?

Re: exporting data lists into excel

krups — Thu, 09 Aug 2012 02:37:41 GMT

Got it working now.

Re: exporting data lists into excel

krups — Mon, 24 Sep 2012 08:27:06 GMT

Hello All,

Finally I have got it done.
I've created web script to export my custom datalists which responses CSV output.
and on button click I called this webscript.
this way I did it and it worked for me.

Re: exporting data lists into excel

wfloyd — Tue, 30 Oct 2012 21:17:22 GMT

Would you please share your web script with us?

Re: exporting data lists into excel

krups — Thu, 01 Nov 2012 03:33:01 GMT

Hi
Sorry I didn't mentioned it before but my aim was to export all datalist of my custom type.
and here is the script.
downloaddatalist.get.desc.xml


<shortname>Download my custom datalists</shortname>
<description>Download all datalists of custom type from repository</description>
<url>/downloadDatalist.csv</url>
<format default="csv"></format>
<authentication>user</authentication>
</webscript>
‍‍‍‍‍‍‍‍

downloaddatalist.get.js


var query,result;
var content = new Array();
query = "TYPE:\"{namespace of custom model}custommodel\"";
result = search.luceneSearch(query);
for each (node in result){
 ID = node.properties["cd:ID"];
 content.push({"ID":ID});
}
model.resultset=result;
‍‍‍‍‍‍‍‍‍‍‍

downloaddatalist.get.csv.ftl


"No","Title","Description","Unit","Location"
<#list resultset?sort_by(["properties","cm:created"]) as node>"<#if node.properties["cd:ID"]??>${node.properties["cd:ID"]?string}","${node.properties["cm:title"]?string}</#if>","<#if node.properties["cm:description"]??>${node.properties["cm:description"]?string}</#if>","<#if node.properties["cd:unit"]??>${node.properties["cd:unit"]?string}</#if>","<#if node.properties["cd:location"]??>${node.properties["cd:location"]?string}</#if>"
</#list>
‍‍‍‍‍

Hope this will help.

Re: exporting data lists into excel

jego — Sun, 17 Feb 2013 21:21:37 GMT

Hi,

there are also the datalist extensions (http://code.google.com/p/fme-alfresco-extensions/wiki/DatalistExtension#XLS_Export). They provide a xls export and a lot more…

Cheers,
Jens

Re: exporting data lists into excel

muralidharand — Mon, 18 Feb 2013 05:14:22 GMT

The Data List Download dashlet allows you to download any Data List from your site in a variety of Spreadsheet formats, including Excel .xls and CSV (Comma Separated Value)

http://addons.alfresco.com/addons/data-list-download

Re: exporting data lists into excel

rock_tu — Wed, 03 Sep 2014 08:34:14 GMT

Hello krups
Thank you for your code,I have done that what you said,But I found that appears a error,The error is reference error "search",I think that I need to import a page in the download datalist.get.js page,is it right?could you give me a solution?thanks in advance!
What's more,I want to know that whether can export all sites datalist with a specific and same kind,thank you very much!

Re: exporting data lists into excel

rock_tu — Wed, 03 Sep 2014 09:26:27 GMT

Hello muralidharand
Thank you for your idea,the above link can export all datalists in the specific site,But now I want to export all sites datalists with a specific datalist at once,So in my opinion,we need to modify the source code within the above link,could you tell how to to that?thanks a lot!

Re: exporting data lists into excel

krutik_jayswal — Sat, 15 Jul 2017 08:14:58 GMT

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

Import Export Data List : Alfresco Datalist Import Export - YouTube