177 posts
  • 5 Years of Membership
  • Affiliate Level 1
  • Collector Level 3
  • Exclusive Author
+2 more
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

3875 posts Community Moderator
  • Weekly Top Seller
  • Moderator
  • Tuts+ Instructor
  • Netherlands
+10 more
Joost
Moderator
says

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

1908 posts YOU TOUCH IT YOU BUY IT
  • Top Monthly Author
  • Community Superstar
  • Author Level 11
  • Winner
+10 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.

5441 posts
  • Author Level 11
  • Moderator
  • Winner
  • 6 Years of Membership
+20 more
dtbaker
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
  • 7 Years of Membership
  • Affiliate Level 1
  • Australia
  • Beta Tester
+11 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.

1908 posts YOU TOUCH IT YOU BUY IT
  • Top Monthly Author
  • Community Superstar
  • Author Level 11
  • Winner
+10 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