Thanks for the feedback, guys.
I'll see what I can do about performance issues, but I was aware of
them when I published the app. The description does say it works best
for short time ranges, e.g. less than a week.
I basically wanted something that would give me data on sales for
today (searching for "CHARGEABLE"), and the latest day of resolved
payments ("CHARGED" from 2 days ago), and I wanted something that
listed sales by app. The problem is that the only place the item name
is stored is in the history of new order notifications. So what I have
to do is query the Google Checkout servers for all new orders for a
given day, and store the order numbers and item names. Then I have to
do a separate query for the same time range to get the financial
status (CHARGED, CANCELLED, etc.) for each order number. Then I have
to merge the two to produce the report.
The second query returns one line for each order in comma-delimited
text. But the notification history queries return big chunks of XML
for each order, and only return 50 orders per query. If the query
covers more than 50 orders, the XML that is returned contains a next-
page-token, which you then use for a subsequent query, and so on for
every 50 orders. So that's why it's so slow for longer periods of
time, and tends to just time out for queries with many hundreds or
thousands of orders.
Now, one thing I could add is the ability to build up a local database
and store any previous data you've fetched, which would make new
queries that cover ranges of previous ones a lot faster if you don't
have to fetch the results from Google, but the first time you grab the
data it's always going to be slow. But I didn't really intend for it
to be an all-purpose reporting tool, just a small app to fetch a day
or two, or maybe a week's worth of data. I just needed a tool that
would give me data broken down by app name, and Google Checkout wasn't
doing that for me.
At some point I may opensource it...we'll see.
On Nov 23, 10:17 pm, Streets Of Boston <[email protected]>
wrote:
> Great idea... i was waiting for such an app.
> But it is very very very very slow, at least for getting few month's
> worth of data, even when getting all the data over WiFi. It just sits
> there spinning and then nothing....
>
> A few weeks data was sluggish too, but did produce some results :)
>
> On Nov 23, 8:14 pm, Craigo <[email protected]> wrote:
>
>
>
> > > Just d/led it. I entered my Merchant ID. However, where do I find my
> > > Merchant Key?
>
> > Just found my key in Google Checkout Settings -> Integration.
>
> > I tried to get the last months data. I noticed that if I ask for the
> > date to end on the default (today) it always says "no data found".
> > But if I change it to 2 days before today, it would sit there for ages
> > and then force close.
>
> > If I ask for 1 week ending 2 days before today, it works.
--
You received this message because you are subscribed to the Google Groups
"Android Discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/android-discuss?hl=en.
