Well, all spreadsheet apps I know of (Excel, OO.org, Numbers…) let you import CSV files.
If you're affiliating Reflexive games then you probably already know that since the end of last December, Reflexive introduced a brand new kind of Royalty Report. As usual it comes in a zipped .PDF file, but from now on it only contains this single sentence:
There's no need to send me a zipped PDF file just to tell me that, a simple email would have been sufficient.Please use the GameCenterSolution Control Center to create customized Affiliate reports and to download your data: https://cc.gamecentersolution.comWhat about using again those nice and informative PDF reports that you used to generate monthly? I'll still use the new reporting ability that you've introduced into the GCS control panel, but seriously I can't do anything ATM with those CSV or XML files. I have no time to write a parser or something. And my accountant likes nice PDFs.
Sorry for the somewhat sarcastic tone of this message.![]()
Last edited by Olivier; 01-18-2010 at 11:28 AM. Reason: made it a bit less sarcastic
OliverPearl.com - CrazyCrab iOS - Flash Games - Bonbon Quest - MinuteMatch
Social - #OliverPearl - FB - YouTube - Blog
Well, all spreadsheet apps I know of (Excel, OO.org, Numbers…) let you import CSV files.
Mine still included a PDF with totals on it - unfortunately it no longer breaks up my sales by platform, which is a pain for my personal accounting needs, but I'm asking to see if that can be fixed. (But then, I'm a developer, not an affiliate, maybe that's the difference.)
I can read CSV or XML files, but they don't look as nice as the reports we used to get. These reports contained a summary table, and a detailed table. The latter listed per game the number of downloads, net units sold, unit price, COGs, gross/net referrals, gross/net revenue and the totals.
Now we're left with the new 'Affiliate Earning' report which lists less than half of the data described above. The best I can do at the moment is to generate the report in my GCS control panel and make a print screen.![]()
OliverPearl.com - CrazyCrab iOS - Flash Games - Bonbon Quest - MinuteMatch
Social - #OliverPearl - FB - YouTube - Blog
Apologies for any inconvenience the reporting changes may have caused. I won't bore you with the technical details, but suffice to say that some backend changes made it impossible to continue our old affiliate statements. We're working hard to improve the online reporting - hopefully you'll bear with us through the transition.
OliverPearl.com - CrazyCrab iOS - Flash Games - Bonbon Quest - MinuteMatch
Social - #OliverPearl - FB - YouTube - Blog