QParse is DOS-based utility for extracting semi-unstructured
text-based file data and presenting it in a structured CSV spreadsheet.
Basic Syntax:
QPARSE srcfile.ext /F:functionname >outfile.csv
where, srcfile.ext is the 8.3 format of the file name, which you can discover
in Windows 2000 / XP by typing 'DIR longsrcfilename.ext /X' at the command
prompt; /F:functionname is any function name listed in the QParse.Ini file;
and outfile.csv is the name of the destination output file.
You can get more command-line options by typing 'QPARSE /?' at the command
prompt. NOTE: some newer functions may not be listed in the documentation.
If you come up with other useful functions for EQ2Log files, please e-mail
at [email protected].
Here are the EQ2Log functions included in the most recent update [2004-11-30]:
- LogBackDat - Extracts the last lines from the log file, so you can back
up the log file, and use these lines to start a new one. This is because when you
just start with a blank log file, some info needed for other functions, such as
the characters current level in both adventuring and crafting won't be there;
current zone; money; last skill to go up; etc.
- Killed - Mobs you have killed, the zone they were in, and if you used /loc before or during the
encounter, lists the location of the mob, otherwise it lists the last /loc
you used, even if in another zone
- Locs - lists all the location numbers and zone names for all /loc used.
A note about all the functions which report locations. The CSV file will have
locations listed as E/W, D/U + N/S, and Facing. It is best prior to opening
the CSV file, to use a text editor to replace all occurances of ", " (not including
the quotation marks) with some rather unique characters such as "@" (not including
the quotation marks). You can then inside your spreadsheet application split
the D/U + N/S column by the character deliminiter. You can split it without
doing this, but if the zone has a N/S location that exceeds 999 or is lower than
-999, the EQ2Log file will have it listeed with a thousands place comma and there
will split the column into three columns instead of two.
- QuestName - Use this one by saying in-game QUEST OFFER "quest name" from %t
while having the Quest giver targetted. Or if it's from an item, then leave
out the %t and Drag the item to the chat bar to insert the item in place of the target.
If neither of those options work, just type some explicative in place of the %t
such as Examining a Stack of Books. Merging the CSV result of this function with
the NPCDialog and QuestReward functions and then sorting by the Date / Time
columns will help list out Quest information.
- Skills - lists your current adventure and artisian level as well as current
skill level, whenever a skill is increased
- Loot - Finds all the loot and from which mobs in which zones. This
spreadsheet needs work to merge the information, and later on, I'll list what
to do to get the information in a more compact form. That is, the resulting
CSV file contains three to four different columns for each of: from what mob,
and what item, as well as two to three for who looted, and the item's number.
- Consider - Lists your level, and what level a mob /cons. It may or may
not be complete. Looking at the EQ2Log.Ini file will show the /cons I'm not
sure if exist or not. I have never gotten a /con for those, but put them in
there to note that they may exist.
- NPCLoc - Lists NPCs name, zone, and location. Use a /loc command followed
by a /say Hail, %t to insure getting an NPCs location listed with this function,
since some NPCs do not echo the hail message back to the log file when using the
Hail command [H by default].
- Places - Use /say PLACE place name in-game
to get it listed with this function. That in-game command is also good for the log2map
utility.
- QuestReward - Use /say QUEST REWARD COIN:
0.123456p ITEM: "item option 1 name", "item 2 name",
...,"item n name" in-game to list quest rewards. See QuestName
and NPCDialog functions as well
- NPCDialog - Lists all NPC dialog and your responses
- Channels - Currently set to /shout, /ooc, Qeynos_Scout,
Qeynos_Predator, Qeynos_Traders, and Qeynos_Crafting channels, but you can
edit the EQ2Log.Ini file to include whatever channels you want.
- ItemNums - Lists Item names and their respective item numbers. The log
file stores these in this format for linking:
\aITEM itemnumber item_name:item_name\/a
- YouSay - Lists all your /say lines
Log2Map extracts /loc data from the specified eq2log file and appends
any information between specifier commands to zone maps.
Basic Syntax:
LOG2MAP srcfile.ext
where, srcfile.ext is the 8.3 format of the file name, which you can discover
in Windows 2000 / XP by typing 'DIR longsrcfilename.ext /X' at the command
prompt.
To mark the beginning and end of a mapping sequence, just say in-game 'BEGIN
OUTLINE' or 'BEGIN OUTLINE objectname COLOR red blue green', where objectname
what you want the object called (currently ignored but can help when trying
to fix a messed up log file), and red, blue, and green are decimal values
between 0 and 255 representing the color you want the lines to be on the map.
You can also mark spots by just saying in-game 'PLACE description', where
description is the text that will be displayed on the map.
If you use this, you will also need Mappie (see below) to view the maps.
