12 replies to this topic

[Llewey]

Hi All!

I would like to make an android application for crafting that will list all the recipes for each profession, the crafting level required to craft it, and what the item is dropped by for the base level ingredients (aspen tree for green wood; Bandits, Centaurs, etc. for Jute Cloth; Wurms, Spiders, etc for Tiny Venom Sacks) as well as allowing recipes to be filtered by base ingredients. If there is a clean and intuitive way to include other information I will do so, but I need the data first. There are some OK web solutions to this, but none of them are stellar. Also, I have to alt tab and navigate the clunky sites to find what I want. I envision sitting at the Chef Station and seeing in the discovery pane that I have 30 more recipes that I can discover using Carrots but I am only at 75 cooking skill, so I pull out the app and click "cooking", then in the ingredients filter I click "carrots" and in the level filter I click "75" and then below there are a series of expandable sections a la the GW2wiki and I am able to expand "Soups", "Meals", "Desserts" or whatever and find the recipes that use carrots and are craftable at the 0-150 bracket. But again, I need this data first.

I don't really want to go through and manually create my own database...what a pain! So is there an existing database that I can hook into to get the data from? I know the GW2 wiki has (incomplete) crafting information and gw2db has what appears to be a much larger list of items but without where to obtain them. Is there a way to directly pull the information from either of those sites? Does somebody have an existing crafting database that they would let me use? Or does someone have advice about writing a script to pull the information from a web resource to fill my own database?

Any help or advice you could give me would be great

[Llewey]

I have just released version 1 of Guild Wars 2: Crafting DB on the Google Play store. Please check it out and if you have any comments feel free to share them here. If you have any problems with the app please let me know before leaving a bad review and I'll see if I can address it.

"GW2 Crafting DB is a tool to help players wade through the thousands of crafting recipes in Guild Wars 2. Search for recipes by name, ingredients, and stats; filter them by quality level and skill level; and see all the items you can make with the 100+ scraps of jute or iron ingots you have."


Play Store: play.google.com (free), play.google.com (paid - mostly to cover the cost of making a developer account)

Screenshots:

Dashboard   Recipes List    Recipe Information
 gw2craftdb_dash_small.png   65.12K   3 downloads     gw2craftdb_profession_window_small.png   44.91K   0 downloads     gw2craftdb_recipe_window_small.png   40.9K   0 downloads

Search Results

Edited by Llewey, 27 December 2012 - 11:51 AM.

[Operative 14]

Very, very nice! I just downloaded it and this is a very slick app - thanks! It works very nicely on my Nexus 4.

What did you do you get the data? Are you hooking into an existing site or did you have to compile it all yourself and put it in a sqlite database?

[Llewey]

Operative 14, on 27 December 2012 - 07:31 AM, said:

Very, very nice! I just downloaded it and this is a very slick app - thanks! It works very nicely on my Nexus 4.

What did you do you get the data? Are you hooking into an existing site or did you have to compile it all yourself and put it in a sqlite database?

Thank you! I am glad you like it. I harvested the data from the GW2DB site (http://www.gw2db.com/)  into a sqlite db before they released the JSON API, so it isn't using network bandwidth to get the information.

[Minimal DJ]

Great work Llewey, would love to know how you built the Apk, in java ?

[Llewey]

I would like to give a big thank you to the GW2 community for embracing this app. Yesterday marks a huge milestone...It already has over over 1000 downloads!! To make the app even better, feel free to pm me or post any feedback that you might have.

And yes DJ, it is written in Java with the android SDK.

[Llewey]

Hello again and thanks for your continued support in making this app a success with nearly 3000 downloads to date. I can't believe so many people have downloaded it and checked it out.

I just wanted to let you all know that I just updated the app to fix a couple bugs that caused it to crash when viewing certain items with incomplete data. Hopefully this wasn't affecting many of you, but if it was please give the app another shot and let me know if you have any concerns or other bugs/issues.

Happy hunting,

Llewey

[Daesu]

I just got my Nexus 7 tablet and I downloaded your application.  It looks pretty neat.

[cobalt]

i got it and used it a couple times already when crafting... thx for the great app.

[Nuclear_Herring]

Downloaded and in use. Thanks very much for your efforts.

[Llewey]

Thanks for the comments and you're all very welcome :-)

I do have a question though: I was told that some recipes in the game have changed/aren't accurate in the app (in a review on the app, so I don't have any way of actually asking the person what they noticed different). a) When was that update? b ) Has that change been made in gw2db? c) Does gw2db or guildwars2guru make posts or announcements somewhere that I can find when the database changes? I see a post here that talks about items that were added on the 28th but I don't see anything about recipes being added and I don't want to re-crawl the DB and update the app if it doesn't actually have any changes AND I would like a place to bookmark to check once a week and make sure I don't miss any recipe updates.

Thanks all!!

Llewey

Edited by Llewey, 31 January 2013 - 04:42 PM.

[Daesu]

Honestly I haven't seen any API documentation from gw2db.  I requested on their api request thread sometime back but I never heard back from them.  I assume that they have only released api information to some people but their api is not public, so I don't know how that goes.  Gw2spidy has a public api and Ruben provides update on his api changes through his mailing list.

I have read some people claiming that gw2db has some outdated data.  I suppose somebody must be maintaining that data since users are not allowed to update it like a wiki.

Edited by Daesu, 01 February 2013 - 10:12 AM.

[Llewey]

I have access to the API, but I didn't get it until after I scanned the DB and built my app and I don't really have time to change everything now and I'm not sure I'd be able to get everything I have now from the API as easily as I do now with a static DB, plus that requires constant network connection to use which is a negative, but the positive is that it would be as up-to-date as gw2db. But anyway, it is what it is, I just want to know when they update their db TELL ME GW2GURU!!! lol

Edited by Llewey, 02 February 2013 - 02:10 AM.