Re: Export of Issues to CSV

On Monday 10 March 2014 12:06:44 Tom Ekberg wrote:
> Andreas,

Tom,
 
> How does your version compare with the one I wrote in issue 2550792?

First of all, I wasn't aware that there was just recently a similar approach 
to improve ExportCSVNames of the Wiki to make it even more readable.

I have filed an additional issue 2550833 which has now slightly more 
functionality to my understanding. But both versions are fairly similar. I see 
the following differences in functionality between version 2550792 and version 
from issue 2550833.

- The version 2550833 is missing the comment, 
  see http://issues.roundup-tracker.org/issue2550833
- It is tested as an extension on version 1.5.0.
- Logging is tried to be done differently,using the logging module. But
  this didn't seem to work for me. I stepped back and changed the
  HTTP header to 'text' while doing my tests. But this is reverted to
  the original again.
- Multilinks are slightly handled differently. As the CSV export on my platform
  uses the comma ',' as a separator I used the variable list_sep = ';'
  as a separator. This way the fields are not split if importing on ',' as
  a separator into e.g. Excel or LibreOffice. The list is just a list
  of semicolon values without surrounding brackets, i.e. "[]".
- Date format is converted to either YYYY-mm-dd if hour and minute is 
  00:00. This happens for instance on the due_date. Otherwise the date
  format is YYYY-mm-dd HH:MM. Additionally, the timezone is used rendering
  the datetime value.
- Instead of 'username' the version 2550833 uses 'realname' since this is
  more natural in our environment. Username is an alias for the account
  and realname is the lastname, firstname pair of the user name.
- If the user doesn't have the right to view a field, well actually on
  the 'user' column, as for the web interface the string "[hidden]" is
  rendered and not the actual value.

Andreas


> Tom Ekberg
> Senior Computer Specialist, Lab Medicine
> University of Washington Medical Center
> 1959 NE Pacific St, MS 357110
> Seattle WA 98195
> work: (206) 598-8544
> email: [email protected]
> 
> On Sun, 9 Mar 2014, Andreas Flöter wrote:
> > Date: Sun, 09 Mar 2014 14:43:59 +0100
> > From: Andreas Flöter <[email protected]>
> > To: [email protected]
> > Subject: Re: [Roundup-users] Export of Issues to CSV
> > 
> > On Sunday 09 March 2014 14:19:51 Andreas Flöter wrote:
> > 
> > I found already a mistake in my code. The 'list_sep' variable is a local
> > to
> > the class and must be reference as 'self.list_sep'.
> > 
> > 75c75
> > <                     return self.list_sep.join(seq)
> > ---
> > 
> >>                     return list_sep.join(seq)
> > 
> > 85c85
> > <                     return self.list_sep.join(seq)
> > ---
> > 
> >>                     return list_sep.join(seq)
> >> 
> >> Hi,
> >> 
> >> I have extended a little the "ExportCSVNames" script from the Wiki which
> >> now resolves also Lists and Multilink values to there clear text values.
> >> 
> >> The date is not yet aligned to the timezone. This needs to be fixed.
> >> 
> >> My amendments are not really beautiful but I was wondering if somebody
> >> could incorporate this functionality into the main stream of roundup.
> >> The current CSV export is very basic and could be more helpful if done
> >> in this way.
> >> 
> >> Andreas
> > 
> > --------------------------------------------------------------------------
> > ---- Subversion Kills Productivity. Get off Subversion & Make the Move to
> > Perforce. With Perforce, you get hassle-free workflows. Merge that
> > actually works. Faster operations. Version large binaries.  Built-in WAN
> > optimization and the freedom to use Git, Perforce or both. Make the move
> > to Perforce.
> > http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clkt
> > rk _______________________________________________
> > Roundup-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/roundup-users

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech