Forum

Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

The47thSen
#1 Posted : Friday, September 06, 2013 7:48:11 AM(UTC)
The47thSen


Rank: Amateur

Groups: FFXIV Player
Joined: 8/31/2013(UTC)
Posts: 5
Japan
Location: Kobe

Was thanked: 4 time(s) in 2 post(s)
I'm trying to populate the database for my crafting app.

xivdb has all the items but I can't sort or search by crafting items alone and I don't know which area and aren't crafting items since my highest is a carpenter at 15.

Edited by user Friday, September 06, 2013 7:49:35 AM(UTC)  | Reason: Not specified

Sponsor
Orophin
#2 Posted : Friday, September 06, 2013 10:00:34 AM(UTC)
Orophin


Rank: Artisan

Groups: FFXIV Player, Moderator
Joined: 11/5/2010(UTC)
Posts: 511
Location: Phoenix, AZ

Thanks: 113 times
Was thanked: 181 time(s) in 129 post(s)
I think the best start would be to get a list of a level 50's botany and mining logs as I'm sure everything gathered from those professions are used in some craft or another. Another way to circumvent this is to go on the market board and go through the different categories of items. (ores, leathers etc.)

There's a lot of useless fish so a way you can check those is to manually the market board against xivdb and see which ones have a recipe associated with them.
http://www.youtube.com/user/oroelf - FFXIV 1.0 Cutscene Videos
Kida
#3 Posted : Friday, September 06, 2013 10:21:30 AM(UTC)
Kida


Rank: Administration

Groups: Administrators
Joined: 7/15/2010(UTC)
Posts: 1,174
Location: Copenhagen, Denmark

Thanks: 290 times
Was thanked: 349 time(s) in 224 post(s)
There are A LOT of crafting materials. You have to remember that many of the items you craft are materials for other items so in order to get all materials I guess you would have to know all recipes.

I am contemplating getting all recipes for this site but it is a major task if you don't know how to data mine the game.

What is this app you are making? Sounds interesting.
The47thSen
#4 Posted : Friday, September 06, 2013 10:28:59 AM(UTC)
The47thSen


Rank: Amateur

Groups: FFXIV Player
Joined: 8/31/2013(UTC)
Posts: 5
Japan
Location: Kobe

Was thanked: 4 time(s) in 2 post(s)
The only data mining I'm doing is the manual sort. Looking at what's available and writing it down, but I'm still low on the level tree. 25 botanist, 15 carpenter, 14 leather ,13 weaver. One of those is probably mixed up.

The app, is based in part on the gear chart I put up on the other forum. I compiled a whole list of gear for my little lumberjack, sorted it by list, then decided what the hell, let's add some mining and fishing. Then came the crafting classes.

Basically use it to keep track of your character's current class and level, and show you what gear you should prepare to upgrade next. Haven't had much time to work on it but ideas have been brewing. I'm probably going to throw in the gathering log with a map of where to gather what.

Once I'm done with the gathering classes, I'll start adding the crafting side; gear, crafting logs, etc.


These are the database tables I'm preparing.

Are you a programmer too, Kidda?

I'd like to hear any suggestions if you have any.
I'm probably separating the crafting mats later into 1 whole recipes table by itself.

Gear
https://docs.google.com/...HNDazBDR0JLWlNBSFE#gid=0
Tools
https://docs.google.com/...VBLYXc&usp=drive_web

Edited by user Friday, September 06, 2013 10:33:58 AM(UTC)  | Reason: Not specified

Raldo
#5 Posted : Friday, September 06, 2013 1:41:51 PM(UTC)
Raldo


Rank: Journeyman

Groups: FFXIV Player, Moderator
Joined: 11/10/2011(UTC)
Posts: 244

Thanks: 44 times
Was thanked: 102 time(s) in 70 post(s)
Originally Posted by: The47thSen Go to Quoted Post
The only data mining I'm doing is the manual sort.

Well, there's always manually flipping through every recipe on XIVDB and writing down the materials.
Orophin
#6 Posted : Friday, September 06, 2013 4:06:16 PM(UTC)
Orophin


Rank: Artisan

Groups: FFXIV Player, Moderator
Joined: 11/5/2010(UTC)
Posts: 511
Location: Phoenix, AZ

Thanks: 113 times
Was thanked: 181 time(s) in 129 post(s)
Not to steal thunder from your project Sen - found this on Reddit:

http://caas.thokk.com/

(not sure if this is what you're working on or not)

Doesn't seem to be entirely accurate yet though, as I plugged in level 50 fisherman and it didn't have Halcyon or Luminary rods listed, nor the fisherman hat, so I don't know what criteria it's using.
http://www.youtube.com/user/oroelf - FFXIV 1.0 Cutscene Videos
The47thSen
#7 Posted : Friday, September 06, 2013 5:09:42 PM(UTC)
The47thSen


Rank: Amateur

Groups: FFXIV Player
Joined: 8/31/2013(UTC)
Posts: 5
Japan
Location: Kobe

Was thanked: 4 time(s) in 2 post(s)
I saw that. it's a bit similar. Doesn't hurt to have competition. I made it more for myself anyway.
Orophin
#8 Posted : Friday, September 06, 2013 11:00:09 PM(UTC)
Orophin


Rank: Artisan

Groups: FFXIV Player, Moderator
Joined: 11/5/2010(UTC)
Posts: 511
Location: Phoenix, AZ

Thanks: 113 times
Was thanked: 181 time(s) in 129 post(s)
Originally Posted by: The47thSen Go to Quoted Post
I saw that. it's a bit similar. Doesn't hurt to have competition. I made it more for myself anyway.

I know how that goes. :) I make tons of spreadsheets just for my personal use but end up sharing them anyway.
http://www.youtube.com/user/oroelf - FFXIV 1.0 Cutscene Videos
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.