1584 posts AEdorde.com - After Effects Projects
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Has referred 1000+ members
  • Has been part of the Envato Community for over 5 years
+9 more
dorde says

We can download csv from statement page, but only for current month.
Any chance to download full statement from beginning until current day?
As far as I remember it worked few months ago :/



Optionally we can fetch all with statementer (btw awesome script by revaxarts), but values are not separated by commas, and I can open it in excel only as plain text, but I would like to have csv syntax: “value1”,”value2”,”value3” etc in order to manipulate with data.

Thanks.

1584 posts AEdorde.com - After Effects Projects
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Has referred 1000+ members
  • Has been part of the Envato Community for over 5 years
+9 more
dorde says

Just flagged 1st post for staff reply. I hope that staff will have appropriate answer on bold question above.
Now we can download statements for every month, one by one, and creating final statement in excel looks like huge and boring work (36 months for me). I don’t see reason why can’t we download all statements in one csv file. :/
I think that only logical answer is a bug.

Thanks.

3310 posts
  • Provided great contribution to our forums
  • Nominated Community Superstar of the month
  • Helps us moderate the forums
  • Has been part of the Envato Community for over 5 years
+18 more
dtbaker Moderator says

There has never been a “download all” option. This should be relatively easy for someone to create as a browser extension. Currently I scrape my statements and combine them with a bit of PHP .

Just make up a bunch of links like this in an email to yourself, then click on each of them to download each file, eg:

http://codecanyon.net/user/dorde/download_statement_as_csv?month=8&year=2012
http://codecanyon.net/user/dorde/download_statement_as_csv?month=7&year=2012
http://codecanyon.net/user/dorde/download_statement_as_csv?month=6&year=2012
http://codecanyon.net/user/dorde/download_statement_as_csv?month=5&year=2012
etc..

then use “cat” or whatever the windows equivalent is to combine all the files together, then sort the final file by date, and remove all the headers that will be grouped together at the top. shouldn’t take more than 10 minutes.

2187 posts
  • Made it to the Authors' Hall of Fame
  • Had an item featured on Envato Market
  • Participated in a focus group or interview to improve the user experience on Envato Market
  • Interviewed on an Envato blog
+10 more
revaxarts says

If you use the “fetch all” function you can copy and paste the result in excel and can work with the data. The problem with comma separated values is that you can’t copy paste them directly into Excel. I uses tabs instead of the comma

1584 posts AEdorde.com - After Effects Projects
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Has referred 1000+ members
  • Has been part of the Envato Community for over 5 years
+9 more
dorde says

Thanks for replies.

I have worked with csv before, but never with tsv. Everything is fine now, I saved statementer data to txt, renamed to tsv, opened in excel and works like a charm :)
Thanks!

Helpful Information

  • Please read our community guidelines. Self promotion and discussion of piracy is not allowed.
  • Open a support ticket if you would like specific help with your account, deposits or purchases.
  • Item Support by authors is optional and may vary. Please see the Support tab on each item page.

Most of all, enjoy your time here. Thank you for being a valued Envato community member.

Post Reply

Format your entry with some basic HTML. Read the Full Details, or here is a refresher:

<strong></strong> to make things bold
<em></em> to emphasize
<ul><li> or <ol><li> to make lists
<h3> or <h4> to make headings
<pre></pre> for code blocks
<code></code> for a few words of code
<a></a> for links
<img> to paste in an image (it'll need to be hosted somewhere else though)
<blockquote></blockquote> to quote somebody

:grin: :shocked: :cry: Complete List of Smiley Codes

by
by
by
by
by
by