Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » Automating Export of Tracker Tabular
 
Thread actions
Print this page
  • Print all pages

    • Automating Export of Tracker Tabular

    Posted by Mike Finko 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

    Reads: 928
    Posted by Jonny Bradley posts: 126892 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 😛

    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! 😁

    Posted by Mike Finko 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


    Posted by Bernard Sfez / Tiki Specialist posts: 8654 France
    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

    Posted by Mike Finko 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