Report Writer For Asana-It Can Be Done

English Forum App Integrations
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…

1 Like
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.

4 Likes
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: Powershell script to backup Asana · GitHub

5 Likes
11

Thanks! i Will look into it !

1 Like
12

So, @James_Carl - what’s been the progress on report writers for Asana since your post back in April of 2017?
I chose Asana without checking output capabilities. Love the internal capabilities AND, getting reports out to stakeholders and senior management cannot be as challenging as it seems here in 2023…

What news can you share?

13

Welcome, @G_A_Borden,

This thread hasn’t been updated in over six years, but I’m happy to “report” there are more options now.

I’m responsible for this one (free to almost all individuals and businesses):

You can explore other options at Asana Apps and Integrations • Asana.

Thanks,

Larry

14

Thanks. Will look into it.

About to go back to MS Project…

1 Like
15

We have to help you :sweat_smile:

16

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.