177 posts
  • Bought between 50 and 99 items
  • Exclusive Author
  • Has been a member for 4-5 years
  • Referred between 1 and 9 users
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • United Kingdom
conceptcoding says

I was going to make this slightly more bulletproof but I threw this together for _freshface and I’ve not really got the time to extend it much futher. It takes your statement and spits out a reformatted one into another .csv file. It should be fairly straightforward to use though.

http://pastie.org/788894

3673 posts Community Moderator
  • Has been a member for 5-6 years
  • Contributed a Tutorial to a Tuts+ Site
  • Netherlands
  • Community Moderator
  • Envato Studio (Microlancer) Beta Tester
  • Sold between 10 000 and 50 000 dollars
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Exclusive Author
+4 more
Joost Volunteer moderator says

Good job, conceptcoding! How would you suggest going about adding all the statements in one file together as well? ;)

1864 posts YOU TOUCH IT YOU BUY IT
  • Bought between 100 and 499 items
  • Referred between 200 and 499 users
  • Has been a member for 5-6 years
  • Won a Competition
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Elite Author
  • Sold between 250 000 and 1 000 000 dollars
+1 more
FRESHFACE says

Yeah, good job Thomas! Thank you very much for taking the time for it :)

@Joost I just copy paste the outputs into one excel file.

2957 posts
  • Australia
  • Community Moderator
  • Elite Author
  • Author had a Free File of the Month
  • Most Wanted Bounty Winner
  • Author had a File in an Envato Bundle
  • Has been a member for 5-6 years
  • Contributed a Blog Post
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
+10 more
dtbaker Volunteer moderator says

Having all the juicy details locked up in a string makes out of the box excel processing not possible. Dev’s should keep the string representation of the statement item there if they want, but split out the good stuff into new columns like “rate” “sale amount” “sale/widthdraw/etc” “item name” and “item_id”

the date isn’t too hard to parse, excel should be able to recognise it. if not, then a Y-m-d H:i:s would be perfect.

431 posts
  • Attended a Community Meetup
  • Australia
  • Author had a Free File of the Month
  • Beta Tester
  • Bought between 50 and 99 items
  • Exclusive Author
+4 more
john says

Hey guys.

The statement CSV is how it is for no real good reason, other than that’s how it got built originally. And it’s a bit tricky to change (in its current form)

Over the past few months however, we’ve been making a lot backend changes in how our accounting system generates reports internally.

There’s still a bit more work going on behind the scenes, but when it’s all finished it will be much easier to produce more meaningful account statements – and we’ll be pretty open to suggestions (within technical feasibility) on how that data comes out.

If you’ve noticed we’ve been sluggish on API change requests and issues with the statements, it’s largely because the backend code supporting these bits have been in flux.

1864 posts YOU TOUCH IT YOU BUY IT
  • Bought between 100 and 499 items
  • Referred between 200 and 499 users
  • Has been a member for 5-6 years
  • Won a Competition
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Elite Author
  • Sold between 250 000 and 1 000 000 dollars
+1 more
FRESHFACE says

Thanks John for taking the time to wrote it up for us, I really appreciate it! I understand it’s hard to make any changes in this phase of development. Good luck with the Envato monster :)

@GlennMcKeown:
:P

by
by
by
by
by
by