Export grid to excel or csv

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

4 posts
First unread post

4 posts

Export grid to excel or csv#824935

By HeshanKaru1994 - Sun Jun 16, 2019 2:34 am

- Sun Jun 16, 2019 2:34 am #824935

I want to export a grid to any kind of excel or csv format when you click on a link in the dynaform to download the file

Re: Export grid to excel or csv#824952

By amosbatto - Mon Jun 17, 2019 2:47 pm

- Mon Jun 17, 2019 2:47 pm #824952

See:
https://www.pmusers.com/index.php/Impor ... t_of_grids

Re: Export grid to excel or csv#825044

By HeshanKaru1994 - Fri Jun 21, 2019 5:58 am

- Fri Jun 21, 2019 5:58 am #825044

Can we not use the file and set the generated csv to a link

Re: Export grid to excel or csv#825086

By amosbatto - Tue Jun 25, 2019 3:08 am

- Tue Jun 25, 2019 3:08 am #825086

HeshanKaru1994 wrote: ↑Fri Jun 21, 2019 5:58 am Can we not use the file and set the generated csv to a link

The code example I gave you explains how to get the URL. Use this code:

Code: Select all

 	//If needing to get URL to download CSV file:	
	@@csvFileUrl = ($g->is_https() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] .
          '/sys' . @@SYS_SYS . '/en/neoclassic/cases/cases_ShowDocument?a=' . @@fileId;
	@@csvFilename = pathinfo($filePath, PATHINFO_BASENAME);

Then add a link field to the Dynaform whose "href" property is set to: @@csvFileUrl
and whose "display text" property is set to: @@csvFilename
See: https://wiki.processmaker.com/3.2/Links ... n_Triggers