Forums

Clan List Logger

Quick find code: 86-87-226-65189098

E Bom

E Bom

Posts: 740 Steel Posts by user Forum Profile RuneMetrics Profile
Agita Sage said :
Hello Blasty,

I have commented on here before but wish to do so again, just again to thank you for creating this logger.

I personally use it almost daily as do my fellow clan owners; it is a fantastic way of keeping track of the goings-ons in our clan: so I really do appreciate you making something like this for us to use!


Currently I am looking at freeing up member space in our clan for new P2P members by letting go the inactive F2P members.
I'm not very good at programming/ using Google spreadsheets and it's quite an arduous job manually going through our member list to find such F2P members.
I would love it if your logger was able to carry this task out for me so I can get an automatic copy of who is P2P or F2P.


I have been trawling through our member list and doing this manually by basically copying the members from our List of Clanmates from the RuneScape website and pasting into a spreadsheet as text.

It comes up in the format:
Name Name Rank Member XP Kills Online/ Offline

But for the part of Member, if they are a P2P member it comes up as 'Pro' in the spreadsheet and comes up blank if they are F2P member.


I seen on one of your initial posts you are working on a column for membership, so I don't know if this 'Pro' for P2P member information would prove to be any use to you or not, but thought I would mention it anyway!

Cheers! :)


I would recommend you making a clan competition each month on rune tracker and using that as your main tool for finding inactives.

23-Apr-2014 05:58:53

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
I found a way to check membership, you can use this to get a list of your members and whether they are f2p or p2p:

E: Might not be working or correct at the moment

https://script.google.com/macros/s/AKfycbxoU1JZVaMH84eSLCitKLS4khsjAXNgHzxXD1cETP9VLunYM9VZ/exec?clanName=CLAN_NAME

e.g.:
https://script.google.com/macros/s/AKfycbxoU1JZVaMH84eSLCitKLS4khsjAXNgHzxXD1cETP9VLunYM9VZ/exec?clanName=Maxed

It uses the playerData api which was easy enough to set up. The only thing I had to account for was splitting the requests up if the url length was greater than 2000.

Keep in mind that this causes each playerData request to have on average a maximum of 100 players, so requests for larger clans may take longer.

Putting this into the sheet as part of the daily update isn't straightforward so for now if you want to see a list of your clan listed by F2P and P2p you'll have to use the link above.

E: Error handling and caching isn't set up so use please don't automate requests to it because it may return 404. If it returns an error when you check manually, you can try refreshing.


Nevermind, it doesn't work.

i

­­
­­<
Blasty
the Blue
>­­
­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

25-Apr-2014 07:19:00 - Last edited on 25-Apr-2014 08:48:30 by Blasty

Freud

Freud

Posts: 6,469 Rune Posts by user Forum Profile RuneMetrics Profile
Blasty said :
Features in progress:
- Column for membership
- Daily updating clan hiscores
- Improved menu options
- More convenient system for updating
- System to account for name changes
- System to allow custom notes on clan mates
- System that notifies of inactive players
- Graph generator for player XP over time
- Improved alternative interface
- Customization for appearance
- Improvements to settings
- Colour coding ranks and including images
- Improved instructions and notifications


Any update on these features? How about a new feature if they are capped or not?
.......:::::::;;;;;;;;
¸.·°´¯`°·.¸
;;;;;;;:::::..
Freud
;;;;;;;:::::::....
¸.·°´¯`°·.¸
.......::::::;;;;;;
`°·.¸
Clueless Adventurers
¸.·°

28-May-2014 19:28:09

Freud

Freud

Posts: 6,469 Rune Posts by user Forum Profile RuneMetrics Profile
Is it possible for it to automatically update hourly?
.......:::::::;;;;;;;;
¸.·°´¯`°·.¸
;;;;;;;:::::..
Freud
;;;;;;;:::::::....
¸.·°´¯`°·.¸
.......::::::;;;;;;
`°·.¸
Clueless Adventurers
¸.·°

04-Jun-2014 23:00:46

E Bom

E Bom

Posts: 740 Steel Posts by user Forum Profile RuneMetrics Profile
Runeclan has an event log that is pretty much this, and it includes name changers some how. Not sure if it going off assumption or found a way to actually do it. It also includes specific times too.

Hate to advertise this website, but it really does a pretty good job at incorporating a lot information needs for owners/members

05-Jun-2014 01:09:22

Quick find code: 86-87-226-65189098 Back to Top