History: Export trackers
Source of version: 13 (current)
Copy to clipboard
! Export Trackers As an admin you can access the interface to export trackers if you click at the icon to export the tracker from the tracker list. {img src="display787" link="display787" width="400" rel="box[g]" imalign="center" desc="Click to expand" align="center" styleimage="border"} You can do 4 things: # "__Quick export__" (of tracker items) # "__Export of Tracker Items__" (with filters and more optional settings) # "__Structure__" (export trackers with tiki's own syntax) # "__Profile Export__" ( to be reused from profiles, using YAML syntax) __Table of contents of this page:__ !!# Quick Export (of tracker items) Click at the button and you get a csv with all items in bulk as dumped from the mysql tables. Very fast, but there is no way to customize the results. To customize and filter the output, see the next option "Export Tracker items". !!# Export tracker items (with filters and more optional settings) {img src="display788" link="display788" width="400" rel="box[g]" imalign="center" desc="Click to expand" align="center" styleimage="border"} !!!# UI (1) - using Trackers directly It is possible to export the tracker items in a csv format. Before tikiwiki3, it was only a feature possible for an admin. After A permission tiki_p_export_tracker display a tab 'Export Tracker Items' in the view on the tracker items. {img src="tiki-download_file.php?fileId=158" alt="" link="tiki-download_file.php?fileId=158&display" rel="shadowbox[g];type=img"} The export pannel gives also the opportunity to filters the tracker items !!!!# Url It is possible to use an url to directly generate the csv file {CODE()} tiki-export_tracker.php?trackerId=7&listfields=5:6:7&f_8=y&showStatus=on {CODE} !!!!# Paramters ||trackerId|tracker ID| listfields|Field Ids separated by :| f_fieldId|filter fieldId (replace fieldId par the field Id ex: f_8 for the field 8) with the exact value of the parameter| x_fieldId|filter fieldId that contains the value of the parameter|??? more information needed showStatus|on showItemId|on showCreated|on showLastModif|on parse|on separator|character delimitorL|steing delimitorR|string file|default filename (default: tracker_1.csv) for the trackerId=1 status|o,p,c || !!!# UI (2) - using Plugin TrackerFilter in a Wiki page Using ((PluginTrackerFilter)) with param -+export_action+- !!# Structure (export trackers with tiki's own syntax) Export tracker to be reused from Tracker import (using tiki's own syntax) {img src="display789" link="display789" width="400" rel="box[g]" imalign="center" desc="Click to expand" align="center" styleimage="border"} You can then copy that content, edit as needed with your favourite text editor, and then re-import in tiki later on through the interface that you can access here: "__Trackers > Duplicate/Import Tracker > Import Structure (raw data)__". You can optionally select that you want to preserve the tracker ID. !!# Profile Export ( to be reused from profiles, using YAML syntax) Export tracker to be reused from profiles (using YAML syntax) {img src="display790" link="display790" width="400" rel="box[g]" imalign="center" desc="Click to expand" align="center" styleimage="border"} After clicking at OK, you will see a page with the tracker shown in YAML format. {img src="display791" link="display791" width="400" rel="box[g]" imalign="center" desc="Click to expand" align="center" styleimage="border"} The direct URL has the following pattern: https://example.com/tiki-tracker-export_profile?trackerId=7 You can then use it to create a configuration ((Profile)) with it in http://profiles.tiki.org, or import it in another tiki with that syntax through "__Trackers > Duplicate/Import Tracker > Import from Profile/YAML__". You !! Related * ((Trackers)) * ((Import Trackers)) * ((MultilingualTracker)) -=Alias names for this page=- (alias(Tracker Export)) | (alias(Trackers Export)) | (alias(Export Tracker)) | (alias(TrackerExport)) | (alias(TrackersExport)) | (alias(ExportTracker)) | (alias(ExportTrackers))