Importing and Exporting stories
Hi,
Is there a way to export or import stories or projects in a formatted file like Excel or other Office program?
Thank you for your help,
Showing the most recent page of comments. View the first page
Log in to AgileZen
Hi,
Is there a way to export or import stories or projects in a formatted file like Excel or other Office program?
Thank you for your help,
Showing the most recent page of comments. View the first page
Support Staff 32 Posted by Mary on 16 Mar, 2011 08:23 PM
Mike,
I'm glad to hear it's working, please let me know if you run into any other questions :)
Sincerely,
Mary
Support Staff 33 Posted by Mary on 16 Mar, 2011 08:35 PM
Hi Pat,
Currently we do not import directly from Excel, but yes you could create an app to do so using our API. If you do create an app or if any of our other users wish to share theirs, we would love to be able to share them with others. Please let me know if you have any other questions along the way.
Sincerely,
Mary
34 Posted by Lee Gathercole on 16 Mar, 2011 10:44 PM
I'll send through what i did. Reads a comma delimited file and does a series of posts
--- original message ---
From: "Mary" <***@tenderapp.com>
Subject: Importing and Exporting stories [Feedback]
Date: 16th March 2011
Time: 8:36:20 pm
35 Posted by Pat Good on 17 Mar, 2011 12:55 PM
Thanks,
That would be great.
Pat Good
513-386-6406
-----Original Message-----
From: Lee Gathercole [mailto:***@tenderapp.com]
Sent: Wednesday, March 16, 2011 6:45 PM
To: Good, Pat
Subject: Importing and Exporting stories [Feedback]
Support Staff 36 Posted by Mary on 17 Mar, 2011 01:10 PM
Lee,
How wonderful, that is extremely generous of you and thank you :) I know a lot our users would really appreciate it.
Most grateful,
Mary
37 Posted by Lars Brandt on 17 Mar, 2011 01:21 PM
This comment was split into a new discussion: Simple Import Tool in Rails
Is there some way of turning off email notifycations? I am sort of drowning in emails :-)
By the way I made a really simple import tool in rails. If anybody need it check out the "upload" method in https://github.com/larsbrandt/PreZen/blob/master/app/controllers/st...
Lars
Support Staff 38 Posted by Mary on 18 Mar, 2011 03:14 PM
Hi Lars,
Thank you so much for sharing your tool, we truly appreciate your generosity. This will be so helpful to many of our users, thank you. To answer your notification question, if you go into Settings ->Notifications from your Account Dashboard you will have the option to disable them. Please let me know if you have any further questions, thanks again!
Most sincerely,
Mary
39 Posted by Lee Gathercole on 18 Mar, 2011 05:16 PM
This comment was split into a new discussion: TFSUpload
Ok, So there are sooooo many caveats with this code, that I don't know where to start. This worked for us, but I've removed my api key in case anyone gets cheeky ;-)
It basically reads in a comma separated file and translates into a serializable object and sends that to AgileZen. I'm sure it could be tweaked to death, but hopefully it helps someone.
I've left the tags out because I found I had to add them separately, that might have been because of what I was doing at the time, but I found I did two iterations. First one added all the stories with the text, then the second time round I updated the colour and tags.
Hope this helps and absolute no warranties or responsibility taken ;-)
Lee Gathercole
Atos Origin
m: +44 (0) 7805 910290
Atos Origin
United Kingdom
e: ***@atosorigin.com
www.atosorigin.com
Atos Origin is the Official IT Partner for the London 2012 Olympic Games
Please consider your environmental responsibility before printing this e-mail.
-----Original Message-----
From: Mary [mailto:***@tenderapp.com]
Sent: 17 March 2011 13:11
To: Gathercole, Lee
Subject: Importing and Exporting stories [Feedback]
40 Posted by Mike on 18 Mar, 2011 06:47 PM
Hello Maria,
I don't understand whether i faced with a bug or not.
Basically i created an app, which creates a stories in my project in AgileZen by sending POST requests to the service. In this request i am passing certain JSON string which contains info about my story, for example
{"Text":"Create Coding Guidelines document - version 1.0","Details":"As a PO I would like the team to provide coding conventions and best practices to get coding done in a uniformed way","Size":"0,0","Color":"green","Status":"","ReasonBlocked":""}.This request works fine from Developer's console with my key and for my project.
But! If the same request is generated from my app, Zen service returns a json response which always contains a first created story. If there is no story, the Zen service will return empty JSON string.
I don't know whether it is a bug or not, and will continue experimenting with this tomorrow, but would appreciate, if you could point to my problem or give some advice.
Thanks in advance,
Mike
41 Posted by Mike on 18 Mar, 2011 06:54 PM
To be precise, the JSON string returned in response to my app is not completely emply, it is like that:
"{\"page\":1,\"pageSize\":100,\"totalPages\":0,\"totalItems\":0,\"items\":[]}"In the same time, when I sending the same JSON from developer's console, i receive a valid JSON in response:
{"id":2,"text":"Create Coding Guidelines document - version 1.0","size":"0,0","color":"green","status":"planned","project":{"id":20492,"name":"TFSZenIntegratorTest"},"phase":{"id":117509,"name":"Backlog"},"creator":{"id":23361,"name":"Mike","userName":"migan","email":"***@firstlinesoftware.com"}}MikeSupport Staff 42 Posted by Mary on 21 Mar, 2011 04:10 PM
Hi Mike,
I plugged in your same syntax into the REST client for firefox and am receiving the same response as the developer console. Could there be something in your app causing this strange response? You mentioned you were going to continue to experiment, have you found anything that could be the cause?
Sincerely,
Mary
43 Posted by Ryan Wilkins on 10 Aug, 2011 02:56 PM
Where do i find the code that Lee Gathercole posted on March 16, the comma delimited upload source code? That sure would be handle to look at. Thank you.
Support Staff 44 Posted by Mary on 10 Aug, 2011 03:36 PM
Hi Ryan,
If you look at comment #39 of this discussion Lee attached the source code in a zip file, hope that helps :) Please let me know if you have any other questions.
Sincerely,
Mary
45 Posted by Charlie Yi on 28 Oct, 2011 07:55 PM
Has anyone run into issues with formating the dates imported from AZ? When I format the dates from decimal value to standard day/month/year: hour:seconds via Format Cells it does not reflect the date/time stamp in AZ.
Comments Example: 40806.8017361111 converts to 9/20/2011 7:14:30 PM
What my board shows is attached.
Support Staff 46 Posted by Mary on 28 Oct, 2011 08:26 PM
Hi Charlie,
How are you importing the data to receive decimal values? Are all dates not converting correctly or just certain ones? I'd be happy to help figure out what may be the problem :)
Sincerely,
Mary
47 Posted by Charlie Yi on 28 Oct, 2011 11:46 PM
Mary,
I'm using the Web API through Excel. Its for all the dates. They seem to be off by 8 hours.
Cheers,
Charlie
________________________________
From: Mary [mailto:***@tenderapp.com]
Sent: Fri 10/28/2011 4:26 PM
To: Charles Yi
Subject: Importing and Exporting stories [API Forum]