EQ2 Raid Log Import

  • Ok so this may sound a little stupid, however it is my first go around using EQDKP-Plus with Everquest 2.
    With that being said, I am having issues importing or actually Exporting the log in XML format from ACT that
    I can paste into the RLI string so that the Parser can actually read it.


    I am using the following plugins in ACT:
    ACT EQ2 English Parser
    LootParsing
    RaidAttendance


    My question is: is there a Plugin that I am missing that is not listed on the ACT (Advanced Combat Tracker) Website. ?

  • I've done my due diligence and searched through the forums here, but have not come to any conclusive data for this,
    I see String data for Everquest2 ACT import however even that data is to large to paste into a webpage and expect PHP to handle it.
    and its not even a readable format.


    if I export the data as an XML from ACT the resulting log XML file is still entirely to large.


    Any Help would be appreciated

  • I know people have used it in the past with EQ2 with success, but there is some work involved. I personally do not use it as I use RH for DKP.


    First, EQ2 Log files are ridiculously large files. ACT does do a decent job of breaking it down into daily files, but even those can be quite large. My suggestion before anything is turning /log off, deleting/backing up/or renaming the log file, and turning /log back on just before start of raid. Then again turning /log back off after the raid. This will make a log file just the length of the raid.
    Again, even these can be quite large to parse as EQ2 combat data will make these files very large.


    I'll try using Raidlog import tomorrow and see if I run into any issues.


    P.S. I know you can turn combat filtering off somewhere in EQ2. That will help tremendously in reducing the file size.

    Edited 2 times, last by darkmaeg ().

  • I know that the size of the EQ2 Logs are ridiculously large, I have been playing EQ2 since Early BETA and then on and off through the years. I usually start with a fresh Log every time I start the game, as well as perform a /whoraid once in the Raid zone, This gives me a point of reference in the Log.


    I have been using EQDKP for quite a while for my SWTOR guild


    This is my first time using it for EQ2
    I previously used Dragonfly CMS, RosterMaster For Dragonfly, GEMS (Guild Event Manager), and a Custom Script I wrote to query MySQL for signups Logged for GEMS to Calculate DKP.
    I have looked into RH, but not sure I want to go that route if I can just import a csv, or xml into EQDKP
    I have read through the forum threads, and it appears that at one point this was or may have been working
    of course those threads are from 2+ years ago.


    the RL Import String in EQDKP+ for "Everquest2 ACT" does not seem to Like the .ACT (Last one I tried was 55kb) and the XML export is just entirely to Large 16 MB


    There are a couple plugins for ACT that will export in .CSV
    One example is "RaidAttendance.cs"
    I have attempted to use these as these Plugins just tally Attendance and Loot, which is all that is needed. but these do not import correctly. the Raid Zone is not detected (Not a big Deal, this can be manually set as I have gone ahead and manually entered in all raid Zones into EQDKP) and then when it gets to characters everything is parsed into One Line, so character name field in EQDKP contains all data in the .csv: date, time, Loot, characters name.


    I have also tried using EQ2PreParser to trip the Log down and just use the raw Log File Data, no luck in that.

  • can you please attach the act file?

    Viele Grüße,
    GodMod


    Bitte sendet mir keine unaufgeforderten Support-PNs. | Please don't send me unwanted support-PMs.
    Du willst dich bei mir bedanken: | You want to thank me:

    amazon_wishlist.jpg paypal_logo.jpg

  • ok so that is a .CSV export from a Plugin for Advanced Combat Tracker, Not a .ACT File Export from Advanced Combat Tracker.
    The only Plugin that I know of that will save in .CSV in ACT that looks similar to the .csv file you provided in the link above
    is RaidAttendance.cs
    I did try using that plugin, I do not have access to a Log at the moment to try it again, or re-import the data into Advanced Combat Tracker.
    Will take a look after I get home from Work.

  • i remembered that i uploaded a log to my FTP Server that is from last wekk
    So I went ahead and Pulled it (Have nothing going on at work anyway right now)
    Trimmed it down
    Loaded it up in ACT and Exported in RaidAttendance.sc ACT Plugin to an .CSV


    Used that for RLI in EQDKP


    It didn't detect the zone - but that portion of the log was cut out
    It Did Detect the Characters.
    It did not detect the loot


    The Loot issue appears to be the way that it is exported in the .csv export, Instead of the ItemID it is being exported to .CSV with the html link to the item on
    eq2wire.com Example: http://u.eq2wire.com/item/index/1699153394
    the ending numerical value in the Link is the ItemId


    Here is a exert of the log:

    Player,DKP Holder,DKP,Bid/Roll,Raid Duration (d.HH:MM),Join Time,Join Zone,Leave Time,Leave Zone,Gap Time,Looted (ID),Sit,Comment,
    Artoriaan,,,,2:45,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Awkill,,,,1:58,10/20/2017 10:36:11 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Cantank,,,,2:45,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Charliee,,,,1:41,10/20/2017 10:26:27 PM,"The Sinking Sands",10/21/2017 12:07:29 AM,"The Sinking Sands",,,,,
    Daddumspiritx,,,,2:33,10/20/2017 10:01:39 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Eleco,,,,2:04,10/20/2017 10:30:50 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Gore,,,,2:40,10/20/2017 9:50:50 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",0:03,Benthaf's Head Protector(http://u.eq2wire.com/item/index/276724099) ,,,
    Higheals,,,,2:43,10/20/2017 9:49:43 PM,"The Sinking Sands",10/21/2017 12:33:14 AM,"The Sinking Sands",,,,,
    Itsjustdraven,,,,2:28,10/20/2017 10:06:38 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",,Flurry of Blades III (Master)(http://u.eq2wire.com/item/index/613067292) Dark League Gloves(http://u.eq2wire.com/item/index/3425993978) Highwayman's Silver-Trimmed Chain Leggings of the Bloodsinger(http://u.eq2wire.com/item/index/4107152285) ,,,
    Jaylah,,,,1:56,10/20/2017 10:35:29 PM,"The Sinking Sands",10/21/2017 12:31:30 AM,"The Sinking Sands",,,,,
    Jezabell,,,,2:00,10/20/2017 10:05:19 PM,"The Sinking Sands",10/21/2017 12:06:13 AM,"The Sinking Sands",,,,,
    Kenjuu,,,,1:54,10/20/2017 10:32:32 PM,"The Sinking Sands",10/21/2017 12:26:52 AM,"The Sinking Sands",,,,,
    Leaflett,,,,2:35,10/20/2017 9:58:16 PM,"The Sinking Sands",10/21/2017 12:34:12 AM,"The Sinking Sands",,,,,
    Littlepea,,,,0:23,10/20/2017 10:16:13 PM,"The Sinking Sands",10/20/2017 10:39:28 PM,"The Sinking Sands",,,,,
    Nisi,,,,2:42,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:33:40 AM,"The Sinking Sands",0:01,,,,
    Oryor,,,,2:37,10/20/2017 9:56:52 PM,"The Sinking Sands",10/21/2017 12:34:04 AM,"The Sinking Sands",,Magus Channeled Slippers(http://u.eq2wire.com/item/index/1699153394) Radiant Bracelet of the Pious(http://u.eq2wire.com/item/index/63639657) ,,,
    Pandora,,,,2:36,10/20/2017 9:55:11 PM,"The Sinking Sands",10/21/2017 12:32:09 AM,"The Sinking Sands",,scaled leather pelt(http://u.eq2wire.com/item/index/1861512391) ,,,
    Poxximus,,,,2:41,10/20/2017 9:53:45 PM,"The Sinking Sands",10/21/2017 12:35:00 AM,"The Sinking Sands",,Symbol of Marzin IV (Adept)(http://u.eq2wire.com/item/index/82173642) Clairvoyant's Silver-Threaded Leggings of the Archcaster(http://u.eq2wire.com/item/index/2134039085) ,,,
    Reducto,,,,2:45,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:35:00 AM,"The Sinking Sands",,Spell Curse II (Master)(http://u.eq2wire.com/item/index/699067695) ,,,
    Sharp,,,,2:37,10/20/2017 9:57:02 PM,"The Sinking Sands",10/21/2017 12:34:10 AM,"The Sinking Sands",,,,,
    Yurtin,,,,2:38,10/20/2017 9:54:36 PM,"The Sinking Sands",10/21/2017 12:33:03 AM,"The Sinking Sands",,Ancient Teachings of: Healing Grove(http://u.eq2wire.com/item/index/1529961624) ,,,
    Jerry,,,9 [yeah 9-11 est is much better ],1:40,10/20/2017 10:51:51 PM,"The Gates of Ahket Aken",10/21/2017 12:32:09 AM,"The Sinking Sands",,,,,
    Innuyasha,,,10 [10 30 your time is 4 30pm my time],2:45,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,
    Fangtasm,,,17 [not bad 17 lvl's in about an hour],2:45,10/20/2017 9:49:43 PM,"Unknown",10/21/2017 12:35:00 AM,"The Sinking Sands",,,,,




  • @GodMod


    So I am able to import the log now. couple of things of note


    the following may be an issue on my part but will re-test after next raid:
    1. Raid Start and End aren't being detected, or time is off
    2. Attendance is filled out with Characters present but Time bar is incorrect and have to cycle clicking on the time bar
    Otherwise I can not proceed with the import.


    Importing items
    Items are being displayed properly in the output text box during the import using the ItemID with "http://u.eq2wire.com/item/index/" removed, however when looking at the items
    after the import it appears they are still being Stored in the Database with "http://u.eq2wire.com/item/index/" Making Item Lookup/ItemToolTips impossible.



    infotooltip:
    1509225828.6008s: getitem called: item_name: Hoop of Endless Time, lang: en, game_id: http://u.eq2wire.com/item/index/1452881468, forceupdate: false, data: Fallen Gate
    1509225828.6027s: Search in cache: eq2_en_http://u.eq2wire.com/item/index/1452881468_YToxOntzOjY6InNlcnZlciI7czoxMToiRmFsbGVuIEdhdGUiO30=
    1509225828.6028s: Item found, but item is baditem. forceupdate set to true.
    1509225828.6028s: Force item-update.
    1509225828.6028s: eq2_en_Hoop of Endless Time_YToxOntzOjY6InNlcnZlciI7czoxMToiRmFsbGVuIEdhdGUiO30= deleted from cache.
    1509225828.603s: eq2_en_http://u.eq2wire.com/item/index/1452881468_YToxOntzOjY6InNlcnZlciI7czoxMToiRmFsbGVuIEdhdGUiO30= deleted from cache.
    1509225828.6031s: update called: item_name: Hoop of Endless Time, lang: en, game_id: http://u.eq2wire.com/item/index/1452881468, data: Fallen Gate
    1509225828.6071s: Load Parser in priority: 1. daybreak, 2. daybreak,
    1509225828.6071s: Call getitem for parser: daybreak
    1509225828.7388s: Call getitem for parser: daybreak
    1509225828.8665s: Hoop of Endless Time added to cache in lang en.



    Exert from Database:

    168 Hoop of Endless Time 25 6 11.00 1509161405 Fangtasm NULL 0641f96aa0d7ff38114dc85aea4185c3 http://u.eq2wire.com/item/index/1452881468 1 NULL


    I know you added "str_replace" was this just for the initial parsing of string and does not apply to the injection of the data into the database ?

  • Use the checkbox settings, and dont use the bars.
    Start and End are taken from min and max join/leave times of chars.
    The "str_replace" should be for everything.

    Viele Grüße,
    GodMod


    Bitte sendet mir keine unaufgeforderten Support-PNs. | Please don't send me unwanted support-PMs.
    Du willst dich bei mir bedanken: | You want to thank me:

    amazon_wishlist.jpg paypal_logo.jpg

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!