Loading...
 
Features / Usability

Features / Usability


Automating Export of Tracker Tabular

posts: 228 Ukraine

Hi,

Tracker Tabular has a button for exporting, but if his needs to be done once per day it should be automated, I'm just not sure of the best approach. This is necessary as the data in the Tracker is regularly and permanently deleted per the project requirements.

Cron Job

  • Maybe setting a cron job would be the simplest? However, where would the export go? some email?


Tiki Scheduler

  • Similar to setting a Cron job, but maybe unnecessary complexity if only one action.
  • Or, maybe this is necessary, as first the export needs to be run, then sent by email?


List Execute

  • Maybe use List Execute? On the List Execute docs page, under 'email' there is an option 'pdf_page_attachment', which is similar, but not exactly exporting the data, so static for viewing only.
  • Or, use List Execute to run the 'export' from Tracker Tabular (?) (or directly from List Execute?) and then a Cron job or Tiki Scheduler task to send (email) it?


Before stabbing away, any advice for the best direction would be appreciated.

Thanks,
Mike

posts: 126886 United Kingdom

Hi Mike, been thinking about you of course... hope you and yours are all ok!

I set up something like this a while ago, it has to be a combination of cron and, hmm, can't remember the last bit :p

Set up a cron (or tiki scheduler) task to do the export with something like:

Copy to clipboard
cd /path/to/your/tiki; php console.php tracker:export 42 files/tracker_42_exported.csv;

which should end up with a file you can get to from the site, e.g. https://example.com/files/tracker_42_exported.csv (or put is somewhere private if it needs security)

Then i think in the previous time i did this we just got whoever needed the file to go there when they wanted, but i guess you could put it into a "batch upload" directory, then run php console.php files:batchupload to import it into a file gallery, then you might be able to get ListExecute to email it on a schedule?

Does that get you started (unless anyone else has a better idea)?

Stay safe! mrgreen

posts: 228 Ukraine

Hi Jonny,

yes, definitely helpful, huge thanks!
Sounds like the simplest and most straight forward approach.

All is good, we left Ukraine.

br,
Mike


posts: 8633 Israel
Mike Finko wrote:

Hi,

Tracker Tabular has a button for exporting, but if his needs to be done once per day it should be automated, I'm just not sure of the best approach. This is necessary as the data in the Tracker is regularly and permanently deleted per the project requirements.

Cron Job

  • Maybe setting a cron job would be the simplest? However, where would the export go? some email?


Tiki Scheduler

  • Similar to setting a Cron job, but maybe unnecessary complexity if only one action.
  • Or, maybe this is necessary, as first the export needs to be run, then sent by email?


List Execute

  • Maybe use List Execute? On the List Execute docs page, under 'email' there is an option 'pdf_page_attachment', which is similar, but not exactly exporting the data, so static for viewing only.
  • Or, use List Execute to run the 'export' from Tracker Tabular (?) (or directly from List Execute?) and then a Cron job or Tiki Scheduler task to send (email) it?


Before stabbing away, any advice for the best direction would be appreciated.

Thanks,
Mike


I'm more and more using the Tiki Scheduler so I have more control as Tiki admin inside Tiki.
You can set only one cron job to run for the scheduler : https://doc.tiki.org/Scheduler

Then from the admin -> scheduler you can set anything you want.

If you need help I'll be glad to support.
Stay safe

posts: 228 Ukraine

Hi Bernard,

Yea, I like Tiki Scheduler, it's a very good tool. I would have like to have used it on this project, however we were already faced with a lot of other challenges and their IT sysadmin is already over burdened, so went with simple cron jobs (and, it's unlikely this project will grow much)
If time allows, however, maybe we'll give it a go on a a test site.

br,
Mike


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting