#3156: Export Milestone to CSV
---------------------------+------------------------------------------------
Reporter: anonymous | Owner: daniel
Type: enhancement | Status: reopened
Priority: normal | Milestone:
Component: report system | Version: 0.9.4
Severity: normal | Resolution:
Keywords: export to csv |
---------------------------+------------------------------------------------
Comment (by anonymous):
eblot, I do not have the python skills to write the code needed. I have
provided a use case and sudo code for this enhancement request. If I can
do anything else please let me know. thank you.
== use case ==
{{{
1. user queries ticket database
2. user exports all historic data with a provided link (similar to the
comma-delimited text link) "historic csv"
3. user saves text and smiles in appreciation:-)
}}}
== sudo code ==
the very loose sudo code provided is what should take place after the
user clicks the "historic csv" link
{{{
0. detect user platform (Linux, Windows, OS X)
1. connect to the sqlite db specified in trac.ini
2. perform the user's query (use case set # 1) adding whatever sql is
needed to include all historic data
3. aggregate the data separating each record.field data by ',' and each
record by a newline and carriage return when needed by the user's platform
4. return the comma-delimited result back to the user.
}}}
== sudo code ==
the loose sudo code provided here is what should take place after the
user clicks the "historic comma-delimited" link
{{{
0. detect user platform (Linux, Windows, OS X)
1. connect to the sqlite db specified in trac.ini as the trac db
2. perform the user's query (use case set # 1) adding whatever sql is
needed to include all historic data
3. agregate the data seperating each record.field data by ',' and each
record by a newline and carage return when needed by the user's platform
4. return the comma-delimited result back to the user.
}}}
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3156>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
