Loading...
 
Features / Usability

Features / Usability


Automating Export of Tracker Tabular

posts: 220 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: 126819 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:

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: 220 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: 8503 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: 220 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