Report Writer For Asana-It Can Be Done


#1

I don’t know why people a lot smarter than me in data management don’t find the most inexpensive report writer available and teach the community or create for, or create an integration. I knew about Zoho Report Writer vaguely from another brief life with Zoho (not one I would recommend over Asana). So here is what I did and I am not a programmer. (I hired one for Sendana :slight_smile:Asana_Example_Report Test.pdf (13.8 KB)

  1. Created an Advanced Search in Asana.
  2. Exported to CSV File
  3. Signed up for the free addition of Zoho Report Writer
  4. Imported the CSV file
  5. Customized my report including what columns, grouping etc.
  6. I left assignments out on purpose for confidentiality.
  7. I think I can save this template and this advanced report and merely import the CSV file and I can have a clean report.
  8. The free is limited and I don’t want to pay $50 per month, but I am sure others are out there.

And guess what, I created a pretty clean report along the lines of numerous request for a simple task listing! This just happened to be accounting department I set up for a church. So take a look and let me know what you think.

So some of you guys/gals more talented than me, you have an opportunity, and maybe a commercial one at that.:slight_smile: This is only one of many programs that support importing CSV files or access API’s, Maybe better yet, Asana, it would be great to have a report writer on your road map…


#2

Also with tools like Zapier, possibilities are limitless…


#3

@Bastien_Siebman Does Zapier have a report writer aspect or is it mainly a trigger system. I was not aware your can generate custom reports like shown with Zoho. That would be great.

Thanks


#4

I don’t know, just saying there are many possibilities around Asana when you start connecting it to external tools :slight_smile:


#5

What I am doing is likely not for everyone, but this thread prompted me to share.

When we first moved to Asana we worried about not having a backup. So I made use of the api to write a Powershell script that would pull everything down and save it as a single XML file.

Once I had that, it was fairly easy to write scripts against the XML file and generate Excel reports. The most useful one is a list of all active projects with stats like number of open and completed tasks, project age and days since last update.


A better Dashboard for high level overview
#6

Hi Can you share this script please ?

would be great !

Edwin


#8

Hi, i’m sorry , I meant to reply to @mkoehler :wink:

for his Powershell script

Edwin


#9

Not a problem good luck with getting information :slight_smile:


#10

Sorry for the delayed response.

You can find it here: https://gist.github.com/mwkoehler/8c6b93f7c6bb75d5664b65758023bc9d


#11

Thanks! i Will look into it !