Export data source as csv

Zendesk API User

• 15. April 2020 17:38

Author: mareike
Publication Date: 4/15/2020 17:38

Hey community,
is it possible to export a data set in FirstSpririt for example as csv file?

Thanks for hints!

Tags: dataset, datasource

Verknüpfung mit

• Developers
• Knowledgebase
• System Operations

0

• 

  Zendesk API User

  • 25. März 2021 22:39

  Author: bojan_vujnovic - 3/25/2021 22:39
  

  Yes it is possible. You must create overview page in Page template(in properties tab, change extension from html to csv)

  After that in html tab you create function to access data source. Something like this:

  <CMS_FUNCTION name="contentSelect" resultname="fr_content">

    <CMS_PARAM name="schema" value="referenceNameSchema" />

    <QUERY entityType="referenceNameForTable"/>

  </CMS_FUNCTION>$--

  --$$CMS_TRIM(level:3)$

       $CMS_SET(set_header,["ID","Language","Other fields"])$

       $CMS_VALUE(set_header.toString(";"))$

            $CMS_FOR(for_item,fr_content)$

                 $CMS_FOR(sv_lang, #global.project.languages)$

                     $CMS_SET(#global.language, sv_lang)$

                     $CMS_SET(set_values,[])$

                      $CMS_SET(void, set_values.add(if(!for_item.id.isEmpty,for_item.id,"null")))$

                     $CMS_SET(void, set_values.add(sv_lang))$

                      $CMS_SET(void,set_values.add(for_item.otherFields)$

                                $CMS_VALUE(set_values.toString(";"))$

                 $CMS_END_FOR$

            $CMS_END_FOR$

  $CMS_END_TRIM$

  After this in Page content insert new page(page from page template).Open it and you get csv.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.