nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

exporting data lists into excel

adam_brown

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

Find more posts tagged with

Comments

jriker1

same question here.

mikeh

No, this isn't currently possible.

Mike

krups

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?

krups

Got it working now.

krups

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.

wfloyd

Would you please share your web script with us?

krups

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.

jego

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

muralidharand

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

rock_tu

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!

rock_tu

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!

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

Import Export Data List : Alfresco Datalist Import Export - YouTube