Exporting Data

Emily Davis's Avatar

Emily Davis

01 May, 2017 05:34 PM

Since AZ is now closing up, we tried to export the data per the instructions but it is not working. For example, in my version of Excel for Mac there is now way to access data from the web. Also, some of the links provided do not work in the instructions.

Please advise on how to export our hundreds of stories to Excel for Mac.

  1. 1 Posted by Emily Davis on 01 May, 2017 05:38 PM

    Emily Davis's Avatar

    The instructions provided are for Office 2005 - 2010. I use Office 365 and these instructions will not work.

  2. 2 Posted by Michal Illich on 02 May, 2017 11:37 AM

    Michal Illich's Avatar

    We are also interested in exporting our data. Going through Excel would not work for us.

    Can you just provide a downloadable file with our data?
    Format doesn't matter much (.tsv or .xml in a .zip would be fine).

  3. 3 Posted by William Kammers... on 02 May, 2017 07:47 PM

    William Kammersell's Avatar

    Hi Emily, although the instructions work on newer versions of Windows Excel, I have not had success with any of Mac Excel's built-in tools. In the export instructions, if you open the url in a web browser you'll see the API returns XML (the example URL in the help article is https://agilezen.com/api/v1/projects/yourProjectID/stories.xml?apikey=yourtokennumberhere&pageSize=1000&with=details If you copy the XML shown by your web browser, you could use a XML to CSV converter to make the data into a XML format. These converters can be found via a web search. Once you have the CSV you can open it in Excel 365.

    Just let me know if more info would help.

  4. 4 Posted by William Kammers... on 02 May, 2017 07:49 PM

    William Kammersell's Avatar

    Hi Michal, in the export instructions (http://help.agilezen.com/kb/getting-started/api) there are several example URLs you can make which will give XML files, like https://agilezen.com/api/v1/projects/yourProjectID/stories.xml?apikey=yourtokennumberhere&pageSize=1000&with=details So, if you open that URL with a web browser, you can copy/paste the XML into a file or save it as a XML file. If you have any more questions, please let me know.

  5. 5 Posted by Andreas Johnson on 12 May, 2017 07:32 AM

    Andreas Johnson's Avatar

    Hello,

    This is not working for us, we use office 365 and I only get messege "Forbidden" when I paste in the URL with my project and API key. I manage to get the first part in the tutorial to show up in excel, but this only gives me a list of all my projects, but when I try with the url to get the project details, I get the error message "Forbidden". Please assist me!

    Regards,
    Andreas Johnson

  6. 6 Posted by William Kammers... on 19 May, 2017 03:52 PM

    William Kammersell's Avatar

    I'm working with Andreas on his issue, and if anyone else has the same problem then please check the API Access level for your project. You can learn more about API Access at http://help.agilezen.com/kb/getting-started/api-overview#access_levels/

    If you go to the project you want to export, and if you're not the owner, you'll likely find that the API Access is set to None. You (or the Owner/Admin) will need to set it to at least Read.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

19 May, 2017 03:52 PM
17 May, 2017 03:45 PM
16 May, 2017 05:22 PM
15 May, 2017 05:46 AM
11 May, 2017 05:33 PM