export data in forms in csv

Confluence User - 02 Nov, 2016

Hi All!

I need to export by cron job or by ssh form data. Either csv, pdf, xml or excel version?

All I can find is Export data or related with the user log in!

 

Is there a way to do this in Joget?

 

Thanks

 

export;csv;cronjob;cli;ssh

3


02 Nov, 2016
confluenceUser
confluenceUser

Hi Peter,

You can probably achieve what you want by simply creating a script to export the respective app_fd_* table from the database you use. (unless you are on cloud.joget.com)

There should be a number of scripts you can find on google / stackoverflow regarding scheduled export of tables from f.e. mysql to csv or xls.

I hope this helps,

Eric

03 Nov, 2016
confluenceUser
confluenceUser

Hi Eric,

That's what I'm doing but I wanted the pdf repport. So I don't have to recontruct whole thing...

The problem from the database is that  for one particular repport I need multiple table extractions.

 

I thaught it was possible to connect and access the app from /php or cli and request the pdf version or the xml version.

 

Do you think of a way to do this?

 

03 Nov, 2016
confluenceUser
confluenceUser

Hi Peter,

May be you can consider create a datalist and use the export link under the list?

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print