Bug #55
Export of XML File doesn't include the Duration amount (copy and paste if table view is same way)
| Status: | Closed | Start: | 09/25/2009 | |
| Priority: | Urgent | Due date: | ||
| Assigned to: | Armindo Antunes | % Done: | 0% |
|
| Category: | General | |||
| Target version: | - | |||
| Vote: | 0 |
Description
Enter several time sessions
Perform a export to .xml
View the .xml (via import into excel or view by looking at XML Nopepad 2007 by microsoft)
Result > the Duration is not listed in the xml file... and the breakdown of the data is space delimited when using copy and pasting ( in know this is 2 seperate issues but when ahead and entered one for these)
Originally in 0.9.10.0, you could do a copy and paste of row in the 'table' view and paste into excel to get pivot table/charts... now when you do that all the task, time, am/pm etc... are space seperated in to it individual cells...
Because the application doesn't currently support breaking within tasks... i'm using excel to create this information for me.. but now I can't do that as each word is viewed and seperated by spaces are pasted into it's seperate cells in excel and not manageable. Can you fix both the xml to have duration and the copy (from table view) and paste (to excel) to keep the grouped information together?
example if you copy the a table row then paste into excel you get the following result of data per cell (pipe delimited to indicate individual cells in excel:
9/25/2009 | 9:30 | AM | 10:15 | AM | 00:15:00 | ITO | Team | Meetings | 1 | on | 1 | Meeting | with | Lori |
expected (version 0.9.10.0 allowed this):
9/25/2009 | 9:30 AM | 10:15 AM | 00:15:00 | ITO Team Meetings | 1 on 1 Meeting with Lori |
Thanks
History
Updated by Armindo Antunes 859 days ago
- Status changed from New to Feedback
Hi!
My comments:
- About the duration in the XML:
Currently it doesn't have the duration field because it can be easily calculated (duration = stop time - start time).
If you really need it let me know and I'll include it in next release :)
- About the copy past:
The tab is still used for separating field (you can try pasting to excel and see the fields tab align).
E.g.:
9/25/2009 <tab>9:30 AM <tab>10:15 AM <tab>00:15:00 <tab>ITO Team Meetings 1 on 1 Meeting with Lori
Are you having some Excel configuration troubles?
Best regards,
Armindo
Updated by Armindo Antunes 843 days ago
- Status changed from Feedback to Closed