Data feed links allow you to create your own dynamic reports. You can share or post them back to Freedcamp, share them as a static image, or a dynamic chart for your team and clients.
Essentially we allow you to enable a unique link (URL) returning up to date Tasks data every time it is accessed. This ability allows to use such links in a spreadsheet file. Below we explain how to use this functionality with Google Sheets IMPORT_DATA() function to create reports.
It’s a free feature in Freedcamp.
We created sample Google Sheet file for you which contains some reports. Please feel free to copy it and give it a try. All you have to do is to follow our instructions shared on the first sheet. Please share formulas and ideas of your reports and extra data you want to be exposed with us.
NOTE: Google Docs documentation says that IMPORT_DATA() function will pull data one every hour but we found that it is getting updated about every 20 minutes.
Once you have your reports ready you can share results with your team by any means. To capture a static report – save it as an image and post it inline.
You can post inline images to Tasks, Issues, Discussions, Pro Subtasks descriptions and comments as well as Wikis in Freedcamp. You can also upload images to your Reports folder in Files. See an example below:
Freedcamp Development
tasks created vs tasks completed as at 13 August 2016
In Google Sheets you can also grab an embed HTML code allowing you to publish your report which will change as new data are pulled into your Google Sheet from Freedcamp. See how:
Now switch to source mode in Freedcamp and add your chart.
Freedcamp Development tasks created vs tasks completed
(updates every hour)
We describe how to use source mode to embed your mind maps and videos here and here.
Anyone with the link can view this data feed. It is a read only functionality – having the link does not allow a person to change your Freedcamp tasks data but only to see data as a CSV file. We provide a secure and unique link similar to DropBox and GDrive functionality, where everyone having a link can access it without additional authorization.
Only Tasks application is currently supported. Want to have data feeds for Time, Milestones, Issue Tracker or data feeds for project groups? Please post your request.
Check how to enable this functionality and manage it in Freedcamp’s documentation.
Start your next project in two minutes
Freedcamp is free for unlimited projects, tasks and users. No credit card, no trial clock.
Cool feature, but I haven’t been able to test it because I am not listed as the project owner. The permissions for data feeds don’t make sense, unfortunately. If I can view data, I should be able to export it – users are going to find a way to do that if they can see it in any form.
It is unfortunate that Freedcamp still doesn’t have an API. For me, in my use case of trying to connect my Freedcamp tasks to my personal todo list, this means that I am going to be exporting my full task list to Excel and parsing it. Why am I able to export the full task list to Excel, but not use a data feed?
Thanks for the feature. The Data dump differs when data is exported from the Global Task Board and hen exported from within each individual project. I feel the mapping that was done for the attached excel file was made from the data exported from an individual project, so when I export the complete data for all projects from Global Task Board it didn’t map.
Hi Farhad,
Thanks! Do you want us to prepare another template to work with Global tasks Board feed?
Ideally to prevent future mismatches it would be great to have the data extraction to be mapped for individual projects in the same format as the data extracted from Global Tasks. However, I sure wouldn’t mind a template for Global Task Board feed… my main struggle is remapping the last Calculated Data Sheet.
Hi Farhad,
We will add project name and project group name columns to a project feed and we will fix template asap so it will work with both types of links.
Cheers,
Igor
Awesomeness. Cheers!
@Farhad – done (moved project name and project group name columns back). Now you can use provided template for both types of feeds – one project or many projects.
A dummy question: Where do I need to take the ‘data feed link’ from (to be pasted behind IMPORTDATA)? I tried the URL of a taskboard but it doesn’t work…
Hi Celeste,
Did you check documentation page? -> https://freedcamp.com/Freedcamp_LxR/Freedcamp_Devel_yOf/wiki/wiki_public/view/Ksbab
Please email me help@freedcamp.com if still a question.
I was just having a quick look at importing into Excel – whilst I can download and import a csv file where I know the filename from a HTTP source using ‘import a text file’ the direct freedcamp API call that produces the csv does not seem to have a consistent filename due to the timestamp appended to the end of it.
Do you have any thoughts of how I might be able to achieve the same effect as you have with Google docs in MS Excel?
FYI – not personally wedded to Excel but the organisations I support block google drive and docs amongst other similar tools.
Many thanks
Please email us help@freedcamp.com and give us some more info – I amnot sure what is the question, sorry.
Awesome!
I tried it and seems like works for my team.
One problem though, Timestamps for progress start and end is not in the csv.
Hey,
We do not track progress status change now as it can change from Not started to In progress and backwards. We plan to integrate Time Tracking with Tasks soon. Will it help?
Cheers,
Igor
Does this still work? I entered my link (global) but all of the reports on the tabs are blank
Hi Amanda,
Please email help@freedcamp.com for support. You can see contact us forms on freedcamp.com/help page
Thank you
Where can I find examples of other templates and formulas? I’m trying to create a high-level daily report for execs that shows the status of all projects at a glance
Hi Mona,
I see your request in support and will reply by email.
Cheers,
Igor