DownloadCurrent version of Crabby is available here:
http://www.ffevo.com/files/file/99-crabby/Setup Crabby- Download and unzip the program and run it.
- Click on the Settings tab
- Click Setup Chat Tabs button
- Look for the Add New Chatlog section.
- In the Title Box, type Fishing
- Tick the Checkbox in the Advanced (Regex) section and input "0020|0042" without quotes.
- Click Add
- Click Save Settings button on the bottom of the window
Now when you go to the Chatlog tab, it will show echo, fishing results and exp gain.
Using CrabbyHere is an example of what you will see on the fishing tab. You can select/copy this information.
[23:36:45] You prepare to cast into the fishable waters. (Grade 4)
[23:36:49] Your line sinks to the desired depth.
[23:36:54] You wait for a fish to bite.
[23:37:03] You feel a nibble.
[23:37:07] You wait for a fish to bite.
[23:37:13] You feel a bite.
[23:37:20] You have hooked something but cannot reel it in.
[23:37:29] The fish has tired, but you still cannot reel it in.
[23:37:40] You reel in your catch!
[23:37:47] You obtain 2 hammerhead sharks.
[23:37:51] You gain 137 fishing skill points.
[23:37:51] You gain 541 experience points.
[23:37:57] You sense hammerhead sharks above where you are fishing.
The only issue here is tracking your Depth, Weather, Moon Phase, etc. I accomplish this by using /echo whenever any of these items changes.
For example..
/echo ___ Depth -5, Floating Minnow, Grade 4 Cedarwood, Waxing Gibbous, Windy
Will show up in this log as:
[23:37:57] ___ Depth -5, G4 Cedarwood, No Pool, Waxing Gibbous, Windy
I put Moon and Weather last because they change the most (if you are fishing in one place)
Further Parsing for DoL LogNow, what might you do with all of these results? Well, as long as Crabby is open, it will retain your logs. There are a few ways to do additional parsing, but here is what I find easiest.
- Click on the Fishing tab
- Select all (CTRL+A)
- Copy (CTRL+C)
- Open a Notepad document
- Paste in your logs (CTRL+V)
- Save document wherever you like, I usually use the Desktop
- Open Microsoft Excel (I am currently using 2007)
- Click on the Data tab
- In the Get External Data section, click From Text
- Find and select the fishing log file you saved
- Set File Type to Fixed Width. Defaults for the rest should work. You may need to change File origin for Excel to parse correctly.
- Click Next
- Slide the first break line over so it is immediately to the left of your chatlog messages. This means one space after the timestamp.
- There will be two more break lines. Double click or drag them off of the preview area to get rid of them
- Click Next
- Click Finish. You can customize formatting here, but I just leave defaults.
- An Import Data box pops up. Select New Worksheet.
- Click OK. Your fishing data is now split between two columns, one for timestamp and one for the messages.
- On the Data tab, click Filter
- Your two columns now have dropdown arrows in the topmost cells. Click the dropdown on the second column (which holds your fishing messages).
- You should see a huge list of checkboxes below that define things the filter should show. Tick off the items you dont want to see, such as "Logging Out", "You wait for a fish to bite", "You reel in your catch!", "You feel a nibble" etc.
- When finished, click OK
If you dont have a version of excel or other program that has a "Get External Data" type option, do this:
- Paste your logs into Notepad or another text editor.
- Use the Find and Replace function to convert the spaces after each "]" to a tab
- Copy and paste the results into any version of excel and setup filters.
Using our log from above as an example, after filtering out messages, you will see the following for each catch.
Yes, you can filter it further if you like.
[23:37:13] You feel a bite.
[23:37:40] You reel in your catch!
[23:37:47] You obtain 2 hammerhead sharks.
[23:37:51] You gain 137 fishing skill points.
[23:37:51] You gain 541 experience points.
OK, Why do this?Do you still need more examples of how this is useful to the DoL log? Well, consider that you will now easily see something like the following after capturing information for a while...
[23:37:10] __ DEPTH 0, Grade 4 Cedarwood, Waxing Gibbous, Windy
[23:37:11] Nature's Bounty takes effect
[23:37:13] You feel a bite.
[23:37:40] You reel in your catch!
[23:37:47] You obtain 2 hammerhead sharks.
[23:37:51] You gain 137 fishing skill points.
[23:37:51] You gain 541 experience points.
[23:37:52] Your Nature's Bounty effect fades.
[23:37:59] Nothing bites
If/when the DoL log will have the ability to record whether you have an ability active, capturing your fishing data like this will help determine the general effects it can have on your catches.
Once someone figures out how to automatically grab the weather, location and moon phase, it will be even easier :) I dont think this will happen until the Silverlight/LUA addon API is released for FFXIV or until someone finds the memory address to capture this info and creates an ffEvo plugin or something.
How do I get this stuff into the DoL Log?Good ol' elbow grease.. or knuckle/wrist grease. At this time, you have to do it manually.
Following this process will make it easier for you to find the data to type in. You can just fish while watching TV or something and input your log data at a later date.
Please remember to do the /echo command to note weather and moon phase changes.TIPS:I move my weather/moon widget down by the gathering window so it is easier to see.
Crabby shows XP gained and the xp per hour rate, so if you only use it when you are fishing, you will be able to see how effective fishing in a given area is for you pretty easily!
Questions?If you have questions on this process, let me know!
I did not make Crabby, so you will have to address any development concerns with goldandsurf on the ffEvo forums.
Edited by user Tuesday, November 30, 2010 7:38:28 PM(UTC)
| Reason: Not specified