Post War / Chain Report Programming | Tools & Userscripts | TO…
Post War / Chain Report Programming
    • vonPadre [2587824]
    • Role: Civilian
    • Level: 40
    • Posts: 253
    • Karma: 236
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 18:28:41 - 27/01/22 (6 months ago)
    |
    Last replied 03:04:48 - 30/06/22 (1 month ago)
    Hello,

    Full Disclosure - I know what I'd like to receive via a report ..but.. zero knowledge of how to get there. I've just recently started playing with API connections to Google Sheets but I'm running around in a fog bank.

    I"m unsure of best tool(s) to use in order to meet my expectations. Ideally, one report is ran against all faction members upon War or Chain conclusion. Ideally, date/time params are used for start and stop of data collection.

    Data to be returned includes;

    Optional Fields
    Faction ID
    Faction Name
    Player ID

    Required Fields
    Donator or Subscriber Status
    Player Name
    Level
    War Hits
    Other Hits
    Total Hits
    Assists
    Last Online
    Attacks Made
    Defends
    Times Attacked
    Armory Points Used
    Armory Xanax Used
    Armory Vicodin Used
    Number of ODs
    Armory Temp Items Used by Type
    Armory Blood Bags Used
    Armory First Aid Items Used by Type
    FHCs Used
    Bounties Placed and Value
    Bounties Received and Value

    Is this a pipe-dream? I've collected most of the data above, but it's been a long, manual process. Very time consuming. I'd like to think there's a better way. Which way though, and more importantly.... how?

    Ideally, our faction starts a Chain or enters into a War at time xxxx. Event ends at zzzz. Fill those two params in and kick off the report. Open up the spreadsheet and review.

    Thanks in Advance.
    Last edited by vonPadre on 02:23:51 - 26/03/22
    • vonPadre [2587824]
    • Role: Civilian
    • Level: 40
    • Posts: 253
    • Karma: 236
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:27:33 - 26/03/22 (4 months ago)
    Post link copied to clipboard Copy post link
    *Bump

    We just finished another Ranked War and I'm having to manually compile above info using YATA, TornStats, and Torn itself. And, to make matters worse the data doesn't match across all three platforms. Go figure.

    I'd really like to think there's a method of pulling this info. Yes, No, Maybe?

    A programmer I am not and attempts to find useful 'how-to' documentation to build out my own query have been fruitless.

    Is it a matter of compensation? If so, let's chat.

    Thank you
    • masheen [2625139]
    • Role: Reporter
    • Level: 71
    • Posts: 3025
    • Karma: 2643
    • Last Action: 6 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:08:14 - 26/03/22 (4 months ago)
    Post link copied to clipboard Copy post link
    Speak to the leaders of the faction Goodnight Moon. They sell a nice faction management & chain reporting sheet. I can't remember the name of the person I spoke to.
    • vonPadre [2587824]
    • Role: Civilian
    • Level: 40
    • Posts: 253
    • Karma: 236
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 03:04:48 - 30/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    I'm still searching for a programmer, and willing to pay for your time in Torn $$$.  

    I'm currently running numerous different YATA reports post chain or RW, then combining them into a single spreadsheet. I'd love the ability to get all requested info in one report.

    Contact me. Let's discuss.

    Thanks.
Reply
Thread Title: